I_OrderConfirmationRequest

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_OrderConfirmationRequest.
-- 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_OrderConfirmationRequest AS
SELECT
  afrp0.counter AS PlantDataCollectionItem,
  afrp0.ernam AS EnteredByUser,
  afrp0.rueck AS OperationConfirmation,
  afrp0.aueru AS FinalConfirmationType,
  afrp0.ausor AS OpenReservationsIsCleared,
  afrp0.ru_orina AS ConfirmationApplicationOrigin,
  afrp0.ru_orini AS ConfirmationInterfaceOrigin,
  afrp0.satza AS OrderConfirmationRecordType,
  afrp0.extid AS ExternalSystemConfirmation,
  afrp0.aplfl AS Sequence,
  cast(afrp0.vornr as vdm_vornr preserving type) AS OrderOperation,
  cast(afrp0.uvorn as vdm_uvorn preserving type) AS OrderSuboperation,
  LogisticsOrder.LeadingOrder AS LeadingOrder,
  LogisticsOrder.Plant AS Plant,
  LogisticsOrder.OrderCategory AS OrderCategory,
  cast(LogisticsOrder.OrderType as aufart preserving type) AS OrderType,
  cast(afrp0.werks as vdm_poplatzwrk preserving type) AS WorkCenterPlant,
  afrp0.lmnga AS ConfirmationYieldQuantity,
  afrp0.xmnga AS ConfirmationScrapQuantity,
  afrp0.rmnga AS ConfirmationReworkQuantity,
  afrp0.grund AS VarianceReasonCode
FROM afrp0
INNER JOIN I_LogisticsOrder AS LogisticsOrder ON /* join condition not captured in parsed metadata */
;