I_RepetitiveMfgConfItem

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_RepetitiveMfgConfItem.
-- 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_RepetitiveMfgConfItem AS
SELECT
  cast(blpp.prtnr as pph_prtnr preserving type) AS RepetitiveMfgConfirmation,
  cast(blpp.prtps as vdm_prtps preserving type) AS RepetitiveMfgConfirmationItem,
  cast(blpp.belnr as mblnr preserving type) AS MaterialDocument,
  blpp.vbeln AS DeliveryDocument,
  cast(blpp.posnr as cnmm_posnr_vl preserving type) AS DeliveryDocumentItem,
  cast(blpp.rueck as pph_rueck preserving type) AS ConfirmationGroup,
  blpp.rmzhl AS ConfirmationCount,
  cast(blpp.cobln as vdm_rp_belnr preserving type) AS ReportingPointDocument,
  cast(blpp.weblnr as pph_weblnr preserving type) AS FailedGoodsMovement,
  cast(rmrp.pernr as pph_pernr preserving type) AS Personnel,
  cast(rmrp.loart as pph_loart preserving type) AS EmployeeWageType,
  cast(rmrp.logrp as pph_logrp preserving type) AS EmployeeWageGroup
FROM blpp
LEFT OUTER JOIN I_RepetitiveMfgConfBasic AS _ConfirmationHeader ON RepetitiveMfgConfirmation = _ConfirmationHeader.RepetitiveMfgConfirmation  -- association [1..1]
;