I_FailedOrderConfirmationGroup

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_FailedOrderConfirmationGroup.
-- 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: IFAILEDORDCONFGR

CREATE VIEW I_FailedOrderConfirmationGroup AS
SELECT
  cast(afrh.afori as ru_orina preserving type) AS ConfirmationApplicationOrigin,
  cast(afrh.afruv as vdm_afruv preserving type) AS FailedOrderConfirmationGroup,
  afrh.afrvtxt AS FailedOrderConfirmationGrpText,
  afrh.erdat AS CreationDate,
  afrh.ernam AS CreatedByUser,
  afrh.aedat AS LastChangeDate,
  afrh.aenam AS LastChangedByUser
FROM afrh
LEFT OUTER JOIN I_ConfirmationApplOrigin AS _ConfirmationApplOrigin ON ConfirmationApplicationOrigin = _ConfirmationApplOrigin.ConfirmationApplicationOrigin  -- association [1..1]
LEFT OUTER JOIN I_User AS _CreatedByUser ON CreatedByUser = _CreatedByUser.UserID  -- association [1..1]
LEFT OUTER JOIN I_User AS _LastChangedByUser ON LastChangedByUser = _LastChangedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_User AS _LastConfirmedByUser ON LastConfirmedByUser = _LastConfirmedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_FailedOrderConfirmation AS _FailedOrderConfirmation ON ConfirmationApplicationOrigin = _FailedOrderConfirmation.ConfirmationApplicationOrigin AND FailedOrderConfirmationGroup = _FailedOrderConfirmation.FailedOrderConfirmationGroup  -- association [1..*]
;