I_RptvMfgConfMatlDocItem

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_RptvMfgConfMatlDocItem.
-- 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_RptvMfgConfMatlDocItem AS
SELECT
  conf.RepetitiveMfgConfirmation AS RepetitiveMfgConfirmation,
  afwi.MaterialDocument AS MaterialDocument,
  afwi.MaterialDocumentYear AS MaterialDocumentYear,
  afwi.MaterialDocumentItem AS MaterialDocumentItem,
  mseg.PostingDate AS PostingDate,
  mseg.DocumentDate AS DocumentDate,
  cast(mseg.CreatedByUser as ernam preserving type) AS CreatedByUser,
  cast(conf.Plant as pwwrk preserving type) AS ConfirmationPlant,
  conf.ReportingPointOperation AS ReportingPointOperation,
  conf.RepetitiveMfgConfScenario AS RepetitiveMfgConfScenario,
  conf.RptvMfgConfProcessingType AS RptvMfgConfProcessingType,
  conf.RptvMfgConfReversedCode AS RptvMfgConfReversedCode,
  cast(mseg.Material as co_matnr preserving type) AS Material,
  mseg.Plant AS Plant,
  mseg.Reservation AS Reservation,
  mseg.ReservationItem AS ReservationItem,
  mseg.ReservationRecordType AS ReservationRecordType,
  cast(mseg.StorageLocation as pph_lgort preserving type) AS StorageLocation,
  mseg.Batch AS Batch,
  cast(mseg.InventoryValuationType as pph_bwtar preserving type) AS InventoryValuationType,
  cast(mseg.ConsumptionPosting as pph_kzvbr preserving type) AS ConsumptionPosting,
  cast(mseg.DebitCreditCode as pph_shkzg preserving type) AS DebitCreditCode,
  cast(mseg.GoodsMovementType as pph_bwart preserving type) AS GoodsMovementType,
  mseg.GoodsMovementReasonCode AS GoodsMovementReasonCode,
  mseg.GoodsMovementRefDocType AS GoodsMovementRefDocType,
  cast(mseg.InventoryUsabilityCode as inventoryusabilitycode preserving type) AS InventoryUsabilityCode,
  cast(mseg.InventorySpecialStockType as pph_sobkz preserving type) AS InventorySpecialStockType,
  cast(mseg.InventorySpecialStockValnType as pph_kzbws preserving type) AS InventorySpecialStockValnType,
  cast(mseg.SalesOrder as co_kdauf preserving type) AS SalesOrder,
  cast(mseg.SalesOrderItem as co_kdpos preserving type) AS SalesOrderItem,
  cast(mseg.WBSElementInternalID as ps_s4_pspnr preserving type) AS WBSElementInternalID,
  mseg.Supplier AS Supplier,
  mseg.Customer AS Customer,
  cast(mseg.GoodsRecipientName as pph_wempf preserving type) AS GoodsRecipientName,
  cast(mseg.UnloadingPointName as ablad preserving type) AS UnloadingPointName,
  mseg.ReservationIsFinallyIssued AS ReservationIsFinallyIssued,
  mseg.IsCompletelyDelivered AS IsCompletelyDelivered,
  mseg.ShelfLifeExpirationDate AS ShelfLifeExpirationDate,
  mseg.ManufactureDate AS ManufactureDate,
  mseg.StorageType AS StorageType,
  mseg.StorageBin AS StorageBin,
  mseg.EWMWarehouse AS EWMWarehouse,
  mseg.HandlingUnitExternalID AS HandlingUnitExternalID,
  mseg.MaterialBaseUnit AS BaseUnit,
  mseg.QuantityInBaseUnit AS QuantityInBaseUnit,
  mseg.EntryUnit AS EntryUnit,
  cast(mseg.QuantityInEntryUnit as pph_erfmg preserving type) AS QuantityInEntryUnit,
  afwi._MaterialDocumentYear AS _MaterialDocumentYear,
  afwi._MaterialDocumentItem AS _MaterialDocumentItem,
  conf._Plant AS _ConfirmationPlant,
  conf._RepetitiveMfgScenario AS _RepetitiveMfgScenario,
  conf._RptvMfgConfProcessingType AS _ProcessingType,
  conf._RptvMfgConfRevesalType AS _ReversalType,
  mseg.EWMStorageBin AS EWMStorageBin
FROM I_RepetitiveMfgConfirmation AS conf
INNER JOIN I_RptvMfgConfMatlDocItemAssgmt AS afwi ON /* join condition not captured in parsed metadata */
INNER JOIN I_MaterialDocumentRecord AS mseg ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_RepetitiveMfgConfirmation AS _RepetitiveMfgConfirmation ON RepetitiveMfgConfirmation = _RepetitiveMfgConfirmation.RepetitiveMfgConfirmation  -- association [1..1]
LEFT OUTER JOIN I_MaterialDocumentHeader_2 AS _MaterialDocumentHeader ON MaterialDocument = _MaterialDocumentHeader.MaterialDocument AND MaterialDocumentYear = _MaterialDocumentHeader.MaterialDocumentYear  -- 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_CalendarDate AS _ShelfLifeExpirationDate ON ShelfLifeExpirationDate = _ShelfLifeExpirationDate.CalendarDate  -- association [0..1]
LEFT OUTER JOIN I_CalendarDate AS _ManufactureDate ON ManufactureDate = _ManufactureDate.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 _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 _BaseUnit ON BaseUnit = _BaseUnit.UnitOfMeasure  -- association [1..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_PhysInvtryReasonCode AS _GoodsMovementReason ON GoodsMovementType = _GoodsMovementReason.GoodsMovementType AND GoodsMovementReasonCode = _GoodsMovementReason.ReasonForPhysInvtryDifference  -- association [0..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_InvtrySpecialStockValnType AS _InventorySpecialStockValnType ON InventorySpecialStockValnType = _InventorySpecialStockValnType.InventorySpecialStockValnType  -- 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_2 AS _InventoryUsabilityCode ON InventoryUsabilityCode = _InventoryUsabilityCode.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 Plant = _Batch.Plant 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 _WBSElementBasicData ON WBSElementInternalID = _WBSElementBasicData.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_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_MaterialDocumentItem_2 AS _MaterialDocumentItem ON MaterialDocumentYear = _MaterialDocumentItem.MaterialDocumentYear AND MaterialDocument = _MaterialDocumentItem.MaterialDocument AND MaterialDocumentItem = _MaterialDocumentItem.MaterialDocumentItem  -- association [1..1]
LEFT OUTER JOIN I_MaterialDocumentYear AS _MaterialDocumentYear ON MaterialDocumentYear = _MaterialDocumentYear.MaterialDocumentYear  -- association [1..1]
-- UNION ALL with additional select branch(es): I_RepetitiveMfgConfirmation
;