P_StkPostgHistBasic

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view P_StkPostgHistBasic.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- Parameters: P_StartDate : sydate, P_EndDate : sydate

CREATE VIEW P_StkPostgHistBasic AS
SELECT
  '0' AS StockLevelIsValuated,
  matdoc.MaterialDocument AS MaterialDocument,
  matdoc.MaterialDocumentYear AS MaterialDocumentYear,
  matdoc.MaterialDocumentItem AS MaterialDocumentItem,
  case when _MatDocAccounting.FiscalYear is null then cast('0000' as gjahr) else _MatDocAccounting.FiscalYear end as FiscalYear AS FiscalYearendasFiscalYear,
  matdoc.CostEstimate AS CostEstimate,
  matdoc.CompanyCode AS CompanyCode,
  matdoc.StockIdentifyingMaterial AS Material,
  matdoc.Plant AS Plant,
  matdoc.StockIdfgStorageLocation AS StorageLocation,
  matdoc.StockIdentifyingBatch AS Batch,
  matdoc.SpecialStockIdfgSupplier AS Supplier,
  matdoc.SpecialStockIdfgSalesOrder AS SalesOrder,
  matdoc.SpecialStockIdfgSalesOrderItem AS SalesOrderItem,
  matdoc.SpecialStockIdfgWBSElement AS WBSElementInternalID,
  matdoc.SpecialStockIdfgCustomer AS Customer,
  matdoc.InventoryStockType AS InventoryStockType,
  matdoc.InventorySpecialStockType AS InventorySpecialStockType,
  matdoc.SpecialStockIdfgStockOwner AS SpecialStockIdfgStockOwner,
  matdoc.ResourceID AS ResourceID,
  matdoc.InventoryValuationType AS InventoryValuationType,
  matdoc.MaterialBaseUnit AS MaterialBaseUnit,
  matdoc.MatlStkChangeQtyInBaseUnit AS MatlStkChangeQtyInBaseUnit,
  matdoc.CompanyCodeCurrency AS CompanyCodeCurrency,
  matdoc.PurchaseOrder AS PurchaseOrder,
  matdoc.PurchaseOrderItem AS PurchaseOrderItem,
  matdoc.ManufacturingOrder AS ManufacturingOrder,
  matdoc.ManufacturingOrderItem AS ManufacturingOrderItem,
  matdoc.DeliveryDocument AS DeliveryDocument,
  matdoc.DeliveryDocumentItem AS DeliveryDocumentItem,
  matdoc.Reservation AS Reservation,
  matdoc.ReservationItem AS ReservationItem,
  matdoc.GoodsMovementType AS GoodsMovementType,
  matdoc.GoodsMovementRefDocType AS GoodsMovementRefDocType,
  matdoc.GoodsReceiptType AS GoodsReceiptType,
  matdoc.ConsumptionPosting AS ConsumptionPosting,
  matdoc.PostingDate AS CompanyCode0asStockLevelIsValuated,
  acdoca.AccountingDocument AS AccountingDocument,
  acdoca.FiscalYear AS FiscalYear,
  acdoca.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  acdoca.PostingDate AS xleadingX1asStockLevelIsValuated,
  acdoca.PostingDate AS PostingDate
FROM I_MaterialDocumentRecord AS matdoc
INNER JOIN I_MaterialDocumentRecord AS _matdoc ON /* join condition not captured in parsed metadata */
INNER JOIN finsc_ledger ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): P_StkPostgHistAcctgNoStkQty, I_GLAccountLineItemRawData
;