I_SuplrFrtInvcReqEnrcd

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_SuplrFrtInvcReqEnrcd.
-- 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_SuplrFrtInvcReqEnrcd AS
SELECT
  SuplrFrtInvcReqUUID,
  SupplierFreightInvoiceRequest,
  SuplrFrtInvcReqType,
  SuplrFrtInvcReqCategory,
  PurchasingOrganization,
  PurchasingOrgExternalID,
  PurchasingGroup,
  PurchasingGroupExternalID,
  SuplrFrtInvcReqBlockReason,
  SuplrFrtInvcReqLifeCycSts,
  SuplrFrtInvcReqBlockStatus,
  SuplrFrtInvcReqConstcySts,
  SuplrFrtInvcReqArchStatus,
  SuplrFrtInvcReqConfStatus,
  InvoiceDate,
  InvoicingStatusIsInfluenced,
  BillFromPartyUUID,
  cast(_BillFromPartyByInternalKey.BusinessPartner as /scmtms/sfir_inv_billfromparty preserving type) AS BillFromParty,
  cast(_BillFromPartyByInternalKey.AuthorizationGroup as /scmtms/vdm_billfrpty_auth_grp preserving type) AS BillFromPtyAuthorizationGroup,
  cast(_BillFromPartyByInternalKey.IsBusinessPurposeCompleted as /scmtms/vdm_billfrpty_xpcpt preserving type) AS BillFromPtyBusPrpsIsCompleted,
  CarrierUUID,
  cast(_CarrierByInternalKey.BusinessPartner as /scmtms/pty_carrier preserving type) AS Carrier,
  cast(_CarrierByInternalKey.AuthorizationGroup as /scmtms/vdm_carrier_auth_grp preserving type) AS CarrierAuthorizationGroup,
  cast(_CarrierByInternalKey.IsBusinessPurposeCompleted as /scmtms/vdm_carrier_xpcpt preserving type) AS CarrierBusPurposeIsCompleted
FROM I_SupplierFreightInvoiceReq
LEFT OUTER JOIN I_TranspChargeObjectEnrcd AS _TranspChargeObjectEnrcd ON SuplrFrtInvcReqUUID = _TranspChargeObjectEnrcd.TranspChargeHostDocumentUUID  -- association [0..*]
LEFT OUTER JOIN I_BusinessPartner AS _BillFromParty ON BillFromParty = _BillFromParty.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _Carrier ON Carrier = _Carrier.BusinessPartner  -- association [0..1]
;