I_OrderDocumentedGoodsMovement

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 I_OrderDocumentedGoodsMovement.
-- 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.
-- SQL view name: IORDDOCDGMVT

CREATE VIEW I_OrderDocumentedGoodsMovement AS
SELECT
  aufm.mblnr AS GoodsMovement,
  cast(aufm.mjahr as nsdm_mjahr preserving type) AS GoodsMovementYear,
  cast(aufm.zeile as nsdm_mblpo preserving type) AS GoodsMovementItem,
  aufm.aufnr AS OrderID,
  aufm.nplnr AS ProjectNetwork,
  cast(aufk.autyp as pph_autyp preserving type) AS OrderCategory,
  aufk.auart AS OrderType,
  aufk.werks AS Plant,
  cast(aufm.matnr as co_matnr preserving type) AS Material,
  aufm.werks AS GoodsMovementPlant,
  aufm.rsnum AS Reservation,
  cast(aufm.rspos as pph_rspos preserving type) AS ReservationItem,
  cast(aufm.rsart as pph_rsart preserving type) AS ReservationRecordType,
  aufm.kzear AS ReservationIsFinallyIssued,
  cast(aufm.lgort as pph_lgort preserving type) AS StorageLocation,
  aufm.charg AS Batch,
  cast(aufm.bwtar as pph_bwtar preserving type) AS InventoryValuationType,
  cast(aufm.shkzg as pph_shkzg preserving type) AS DebitCreditCode,
  cast(aufm.bwart as pph_bwart preserving type) AS GoodsMovementType,
  cast(aufm.kzbew as pph_kzbew preserving type) AS GoodsMovementRefDocType,
  cast(aufm.sobkz as pph_sobkz preserving type) AS InventorySpecialStockType,
  cast(aufm.kdauf as co_kdauf preserving type) AS SalesOrder,
  cast(aufm.kdpos as co_kdpos preserving type) AS SalesOrderItem,
  cast(aufm.ps_psp_pnr as ps_s4_pspnr preserving type) AS WBSElementInternalID,
  aufm.lifnr AS Supplier,
  cast(aufm.wempf as pph_wempf preserving type) AS GoodsRecipientName,
  aufm.ablad AS UnloadingPointName,
  cast(aufm.weunb as pph_weunb preserving type) AS GoodsReceiptIsNonValuated,
  aufm.elikz AS GoodsReceiptIsCmpltlyDelivered,
  aufm.kokrs AS ControllingArea,
  aufm.budat AS PostingDate,
  aufm.bldat AS DocumentDate,
  aufm.meins AS BaseUnit,
  cast(aufm.menge as vdm_pp_menge preserving type) AS QuantityInBaseUnit,
  aufm.erfme AS EntryUnit,
  cast(aufm.erfmg as pph_erfmg preserving type) AS QuantityInEntryUnit,
  aufm.waers AS CompanyCodeCurrency,
  cast(aufm.dmbtr as pph_dmbtr preserving type) AS TotalGoodsMvtAmtInCCCrcy
FROM aufm
INNER JOIN aufk ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_MaterialDocumentYear AS _GoodsMovementYear ON GoodsMovementYear = _GoodsMovementYear.MaterialDocumentYear  -- association [1..1]
LEFT OUTER JOIN I_MaterialDocumentHeader_2 AS _GoodsMovementHeader ON GoodsMovementYear = _GoodsMovementHeader.MaterialDocumentYear AND GoodsMovement = _GoodsMovementHeader.MaterialDocument  -- association [1..1]
LEFT OUTER JOIN I_MaterialDocumentItem_2 AS _GoodsMovementItem ON GoodsMovementYear = _GoodsMovementItem.MaterialDocumentYear AND GoodsMovement = _GoodsMovementItem.MaterialDocument AND GoodsMovementItem = _GoodsMovementItem.MaterialDocumentItem  -- association [1..1]
LEFT OUTER JOIN I_LogisticsOrder AS _Order ON OrderID = _Order.OrderID  -- association [0..1]
LEFT OUTER JOIN I_ProjectNetwork AS _ProjectNetwork ON ProjectNetwork = _ProjectNetwork.ProjectNetwork  -- association [0..1]
LEFT OUTER JOIN I_OrderType AS _OrderType ON OrderType = _OrderType.OrderType  -- association [1..1]
LEFT OUTER JOIN I_OrderCategory AS _OrderCategory ON OrderCategory = _OrderCategory.OrderCategory  -- association [1..1]
LEFT OUTER JOIN I_Plant AS _OrderPlant ON Plant = _OrderPlant.Plant  -- association [1..1]
LEFT OUTER JOIN I_CalendarDate AS _DocumentDate ON DocumentDate = _DocumentDate.CalendarDate  -- association [0..1]
LEFT OUTER JOIN I_CalendarDate AS _PostingDate ON PostingDate = _PostingDate.CalendarDate  -- association [0..1]
LEFT OUTER JOIN I_ReservationDocumentHeader AS _Reservation ON Reservation = _Reservation.Reservation  -- association [0..1]
LEFT OUTER JOIN I_ReservationDocumentItem AS _ReservationItem ON Reservation = _ReservationItem.Reservation AND ReservationItem = _ReservationItem.ReservationItem AND ReservationRecordType = _ReservationItem.RecordType  -- association [0..1]
LEFT OUTER JOIN I_ReservationDocRecordType AS _ReservationRecordType ON ReservationRecordType = _ReservationRecordType.RecordType  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _GoodsMovementPlant ON GoodsMovementPlant = _GoodsMovementPlant.Plant  -- association [0..1]
LEFT OUTER JOIN I_Product AS _Material ON Material = _Material.Product  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _BaseUnit ON BaseUnit = _BaseUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _EntryUnit ON EntryUnit = _EntryUnit.UnitOfMeasure  -- association [1..1]
LEFT OUTER JOIN I_GoodsMovementType AS _GoodsMovementType ON GoodsMovementType = _GoodsMovementType.GoodsMovementType  -- association [1..1]
LEFT OUTER JOIN I_GoodsMovementRefDocType AS _GoodsMovementRefDocType ON GoodsMovementRefDocType = _GoodsMovementRefDocType.GoodsMovementRefDocType  -- association [0..1]
LEFT OUTER JOIN I_InventorySpecialStockType AS _InventorySpecialStockType ON InventorySpecialStockType = _InventorySpecialStockType.InventorySpecialStockType  -- association [0..1]
LEFT OUTER JOIN I_InventoryValuationType AS _InventoryValuationType ON InventoryValuationType = _InventoryValuationType.InventoryValuationType  -- association [0..1]
LEFT OUTER JOIN I_DebitCreditCode AS _DebitCreditCode ON DebitCreditCode = _DebitCreditCode.DebitCreditCode  -- association [0..1]
LEFT OUTER JOIN I_StorageLocation AS _StorageLocation ON GoodsMovementPlant = _StorageLocation.Plant AND StorageLocation = _StorageLocation.StorageLocation  -- association [0..1]
LEFT OUTER JOIN I_Batch AS _Batch ON GoodsMovementPlant = _Batch.Plant AND Material = _Batch.Material AND Batch = _Batch.Batch  -- association [0..1]
LEFT OUTER JOIN I_SalesOrder AS _SalesOrder ON SalesOrder = _SalesOrder.SalesOrder  -- association [0..1]
LEFT OUTER JOIN I_SalesOrderItem AS _SalesOrderItem ON SalesOrder = _SalesOrderItem.SalesOrder AND SalesOrderItem = _SalesOrderItem.SalesOrderItem  -- association [0..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElement ON WBSElementInternalID = _WBSElement.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_EnterpriseProjectElement AS _EnterpriseProjectElement ON WBSElementInternalID = _EnterpriseProjectElement.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_PurchaseOrderAPI01 AS _PurchaseOrder ON PurchaseOrder = _PurchaseOrder.PurchaseOrder  -- association [0..1]
LEFT OUTER JOIN I_PurchaseOrderItemAPI01 AS _PurchaseOrderItem ON PurchaseOrder = _PurchaseOrderItem.PurchaseOrder AND PurchaseOrderItem = _PurchaseOrderItem.PurchaseOrderItem  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_SupplierCompanyByPlant AS _SupplierCompanyByPlant ON GoodsMovementPlant = _SupplierCompanyByPlant.Plant AND Supplier = _SupplierCompanyByPlant.Supplier  -- association [0..1]
LEFT OUTER JOIN I_ControllingArea AS _ControllingArea ON ControllingArea = _ControllingArea.ControllingArea  -- association [0..1]
LEFT OUTER JOIN I_GLAccount AS _GLAccount ON GLAccount = _GLAccount.GLAccount  -- association [0..*]
LEFT OUTER JOIN I_Currency AS _Currency ON CompanyCodeCurrency = _Currency.Currency  -- association [0..1]
;