I_GoodsMovementExceptionItem

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_GoodsMovementExceptionItem.
-- 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.

CREATE VIEW I_GoodsMovementExceptionItem AS
SELECT
  cast(affw.weblnr as pph_weblnr preserving type) AS GoodsMovementException,
  affw.ersda AS CreationDate,
  affw.erzet AS CreationTime,
  affw.ernam AS CreatedByUser,
  affw.laeda AS LastChangeDate,
  affw.aenam AS LastChangedByUser,
  cast(affw.matnr as co_matnr preserving type) AS Material,
  cast(affw.werks as werks_d preserving type) AS Plant,
  cast(affw.lgort as pph_lgort preserving type) AS StorageLocation,
  cast(affw.bwart as pph_bwart preserving type) AS GoodsMovementType,
  affw.grund AS GoodsMovementReasonCode,
  cast(affw.sobkz as inventoryspecialstocktype preserving type) AS InventorySpecialStockType,
  cast(affw.insmk as inventoryusabilitycode preserving type) AS InventoryUsabilityCode,
  cast(affw.kzbew as pph_kzbew preserving type) AS GoodsMovementRefDocType,
  cast(affw.shkzg as pph_shkzg preserving type) AS DebitCreditCode,
  cast(affw.kzvbr as pph_kzvbr preserving type) AS ConsumptionPosting,
  cast(affw.bwtar as pph_bwtar preserving type) AS InventoryValuationType,
  cast(affw.kdauf as co_kdauf preserving type) AS SalesOrder,
  cast(affw.kdpos as co_kdpos preserving type) AS SalesOrderItem,
  cast(affw.ps_psp_pnr as pph_pspel preserving type) AS WBSElementInternalID,
  cast(affw.ps_psp_pnr as ps_s4_pspnr preserving type) AS WBSElementInternalID_2,
  cast(affw.lifnr as lifnr preserving type) AS Supplier,
  affw.kunnr AS Customer,
  cast(affw.wempf as pph_wempf preserving type) AS GoodsRecipientName,
  cast(affw.ablad as ablad preserving type) AS UnloadingPointName,
  affw.elikz AS IsCompletelyDelivered,
  affw.kzear AS ReservationIsFinallyIssued,
  cast(affw.prvbe as pph_prvbe preserving type) AS SupplyArea,
  affw.lgnum AS Warehouse,
  affw.lgtyp AS StorageType,
  affw.lgpla AS StorageBin,
  affw.ewm_lgnum AS EWMWarehouse,
  affw.ewm_lgpla AS EWMStorageBin,
  affw.ewm_lgpla_target AS DestinationStorageBin,
  cast(affw.ewm_huident as exidv preserving type) AS HandlingUnitExternalID,
  affw.fwdat AS ErrorOccurrenceDate,
  affw.fwzet AS ErrorOccurrenceTime,
  affw.msgid AS SystemMessageIdentification,
  affw.msgno AS SystemMessageNumber,
  affw.msgty AS SystemMessageType,
  cast(affw.msgv1 as ehprc_msgv1 preserving type) AS SystemMessageVariable1,
  cast(affw.msgv2 as ehprc_msgv2 preserving type) AS SystemMessageVariable2,
  cast(affw.msgv3 as ehprc_msgv3 preserving type) AS SystemMessageVariable3,
  cast(affw.msgv4 as ehprc_msgv4 preserving type) AS SystemMessageVariable4,
  affw.smbln AS ReversalMaterialDocument,
  cast(affw.smblp as vdm_mblpo preserving type) AS ReversalMaterialDocumentItem,
  cast(affw.sjahr as vdm_mjahr preserving type) AS ReversalMaterialDocumentYear,
  affw.aufnr AS OrderID,
  cast(affw.autyp as pph_autyp preserving type) AS OrderCategory,
  affw.rsnum AS Reservation,
  cast(affw.rspos as pph_rspos preserving type) AS ReservationItem,
  cast(affw.rsart as pph_rsart preserving type) AS RecordType,
  affw.rueck AS ConfirmationGroup,
  affw.rmzhl AS ConfirmationCount,
  cast(affw.aufpl as pph_aufpl preserving type) AS OrderInternalBillOfOperations,
  cast(affw.aplzl as operationinternalid preserving type) AS OrderIntBillOfOperationsItem,
  cast(affw.prtnr as pph_prtnr preserving type) AS RepetitiveMfgConfirmation,
  cast(affw.dispo as pph_dispo preserving type) AS MRPController,
  cast(affw.fevor as pph_fevor preserving type) AS ProductionSupervisor,
  affw.mpe_gm_flg AS RecordIsFromMfgProcgExec,
  affw.sernp AS SerialNumberAssgmtProfile,
  affw.anzsn AS NumberOfSerialNumbers,
  cast(affw.sernr as gernr preserving type) AS SerialNumber,
  affw.sfi_id AS ShopFloorItem,
  affw.weblposgroup AS GdsMvtExcptnDepdntItemGroup,
  cast(affw.budat as pph_budat preserving type) AS PostingDate,
  affw.bldat AS DocumentDate,
  cast(affw.mhdat as vdm_tmhhd preserving type) AS SLEDOrManufactureDate,
  cast(affw.erfme as erfme preserving type) AS GoodsMovementEntryUnit,
  cast(affw.erfmg as pph_erfmg preserving type) AS GoodsMovementEntryQty,
  cast(affw.waers as waers preserving type) AS Currency
FROM affw
LEFT OUTER JOIN I_GoodsMovementException AS _GoodsMovementException ON GoodsMovementException = _GoodsMovementException.GoodsMovementException  -- association [1..1]
LEFT OUTER JOIN I_User AS _CreatedByUser ON CreatedByUser = _CreatedByUser.UserID  -- association [1..1]
LEFT OUTER JOIN I_User AS _ChangedByUser ON LastChangedByUser = _ChangedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_Order AS _Order ON OrderID = _Order.OrderID  -- association [0..1]
LEFT OUTER JOIN I_LogisticsOrder AS _LogisticsOrder ON OrderID = _LogisticsOrder.OrderID  -- association [0..1]
LEFT OUTER JOIN I_ProductCostCtrlgOrder AS _ProductCostCtrlgOrder ON OrderID = _ProductCostCtrlgOrder.OrderID  -- association [0..1]
LEFT OUTER JOIN I_OrderCategory AS _OrderCategory ON OrderCategory = _OrderCategory.OrderCategory  -- association [0..1]
LEFT OUTER JOIN I_OrderInternalID AS _OrderInternalID ON OrderInternalBillOfOperations = _OrderInternalID.OrderInternalID  -- association [0..1]
LEFT OUTER JOIN I_OrderOperationBasic AS _OrderOperationInternalID ON OrderInternalBillOfOperations = _OrderOperationInternalID.OrderInternalID AND OrderIntBillOfOperationsItem = _OrderOperationInternalID.OrderOperationInternalID  -- association [0..1]
LEFT OUTER JOIN I_MRPController AS _MRPController ON Plant = _MRPController.Plant AND MRPController = _MRPController.MRPController  -- association [0..1]
LEFT OUTER JOIN I_ProductionSupervisor AS _ProductionSupervisor ON Plant = _ProductionSupervisor.Plant AND ProductionSupervisor = _ProductionSupervisor.ProductionSupervisor  -- association [0..1]
LEFT OUTER JOIN I_ConfirmationGroup AS _ConfirmationGroup ON ConfirmationGroup = _ConfirmationGroup.ConfirmationGroup  -- association [0..1]
LEFT OUTER JOIN I_ConfirmationCount AS _ConfirmationCount ON ConfirmationGroup = _ConfirmationCount.ConfirmationGroup AND ConfirmationCount = _ConfirmationCount.ConfirmationCount  -- association [0..1]
LEFT OUTER JOIN I_RepetitiveMfgConfirmation AS _RepetitiveMfgConfirmation ON RepetitiveMfgConfirmation = _RepetitiveMfgConfirmation.RepetitiveMfgConfirmation  -- 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 RecordType = _ReservationItem.RecordType  -- association [0..1]
LEFT OUTER JOIN I_ReservationDocRecordType AS _ReservationRecordType ON RecordType = _ReservationRecordType.RecordType  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [1..1]
LEFT OUTER JOIN I_Material AS _Material ON Material = _Material.Material  -- association [1..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _EntryUnit ON GoodsMovementEntryUnit = _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_PhysInvtryReasonCode AS _GoodsMovementReasonCode ON GoodsMovementType = _GoodsMovementReasonCode.GoodsMovementType AND GoodsMovementReasonCode = _GoodsMovementReasonCode.ReasonForPhysInvtryDifference  -- 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_ConsumptionPosting AS _ConsumptionPosting ON ConsumptionPosting = _ConsumptionPosting.ConsumptionPosting  -- association [0..1]
LEFT OUTER JOIN I_DebitCreditCode AS _DebitCreditCode ON DebitCreditCode = _DebitCreditCode.DebitCreditCode  -- association [0..1]
LEFT OUTER JOIN I_StockType AS _InventoryUsabilityCode ON InventoryUsabilityCode = _InventoryUsabilityCode.StockType  -- association [0..1]
LEFT OUTER JOIN I_StockType_2 AS _InventoryUsabilityCode_2 ON InventoryUsabilityCode = _InventoryUsabilityCode_2.StockType  -- association [0..1]
LEFT OUTER JOIN I_StorageLocation AS _StorageLocation ON Plant = _StorageLocation.Plant AND StorageLocation = _StorageLocation.StorageLocation  -- association [0..1]
LEFT OUTER JOIN I_Batch AS _Batch ON Material = _Batch.Material AND Batch = _Batch.Batch  -- association [0..*]
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_WBSElementBasicData AS _WBSElementBasic ON WBSElementInternalID_2 = _WBSElementBasic.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _Customer ON Customer = _Customer.Customer  -- association [0..1]
LEFT OUTER JOIN I_SupplierCompanyByPlant AS _SupplierCompanyByPlant ON Plant = _SupplierCompanyByPlant.Plant AND Supplier = _SupplierCompanyByPlant.Supplier  -- association [0..1]
LEFT OUTER JOIN I_CustomerCompanyByPlant AS _CustomerCompanyByPlant ON Plant = _CustomerCompanyByPlant.Plant AND Customer = _CustomerCompanyByPlant.Customer  -- association [0..1]
LEFT OUTER JOIN I_ProductionSupplyArea AS _SupplyArea ON Plant = _SupplyArea.Plant AND SupplyArea = _SupplyArea.ProductionSupplyArea  -- association [0..1]
LEFT OUTER JOIN I_Warehouse AS _Warehouse ON Warehouse = _Warehouse.Warehouse  -- association [0..1]
LEFT OUTER JOIN I_EWM_WarehouseNumber_2 AS _EWMWarehouse ON EWMWarehouse = _EWMWarehouse.EWMWarehouse  -- association [0..1]
LEFT OUTER JOIN I_EWM_StorageBin_2 AS _EWMStorageBin ON EWMWarehouse = _EWMStorageBin.EWMWarehouse AND EWMStorageBin = _EWMStorageBin.EWMStorageBin  -- association [0..1]
LEFT OUTER JOIN I_EWM_StorageBin_2 AS _DestinationStorageBin ON EWMWarehouse = _DestinationStorageBin.EWMWarehouse AND DestinationStorageBin = _DestinationStorageBin.EWMStorageBin  -- association [0..1]
LEFT OUTER JOIN I_MaterialDocumentHeader AS _MaterialDocumentHeader ON ReversalMaterialDocument = _MaterialDocumentHeader.MaterialDocument AND ReversalMaterialDocumentYear = _MaterialDocumentHeader.MaterialDocumentYear  -- association [0..1]
LEFT OUTER JOIN I_MaterialDocumentHeader_2 AS _MaterialDocumentHeader2 ON ReversalMaterialDocument = _MaterialDocumentHeader2.MaterialDocument AND ReversalMaterialDocumentYear = _MaterialDocumentHeader2.MaterialDocumentYear  -- association [0..1]
LEFT OUTER JOIN I_MaterialDocumentItem AS _MaterialDocumentItem ON ReversalMaterialDocument = _MaterialDocumentItem.MaterialDocument AND ReversalMaterialDocumentItem = _MaterialDocumentItem.MaterialDocumentItem AND ReversalMaterialDocumentYear = _MaterialDocumentItem.MaterialDocumentYear  -- association [1..1]
LEFT OUTER JOIN I_MaterialDocumentItem_2 AS _MaterialDocumentItem2 ON ReversalMaterialDocument = _MaterialDocumentItem2.MaterialDocument AND ReversalMaterialDocumentItem = _MaterialDocumentItem2.MaterialDocumentItem AND ReversalMaterialDocumentYear = _MaterialDocumentItem2.MaterialDocumentYear  -- association [1..1]
LEFT OUTER JOIN I_MaterialDocumentYear AS _MaterialDocumentYear ON ReversalMaterialDocumentYear = _MaterialDocumentYear.MaterialDocumentYear  -- association [0..1]
LEFT OUTER JOIN I_CalendarDate AS _PostingDate ON PostingDate = _PostingDate.CalendarDate  -- association [0..1]
LEFT OUTER JOIN I_CalendarDate AS _DocumentDate ON DocumentDate = _DocumentDate.CalendarDate  -- association [0..1]
LEFT OUTER JOIN I_CalendarDate AS _SLEDOrManufactureDate ON SLEDOrManufactureDate = _SLEDOrManufactureDate.CalendarDate  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _Currency ON Currency = _Currency.Currency  -- association [0..1]
;