P_CollabnApplCarrierInvoice

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 P_CollabnApplCarrierInvoice.
-- 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: PCOLLCARRINVC

CREATE VIEW P_CollabnApplCarrierInvoice AS
SELECT
  SupplierFreightInvoice.SuplrFrtInvcReqUUID AS SuplrFrtInvcReqUUID,
  ltrim(SupplierFreightInvoice.SupplierFreightInvoiceRequest, '0' ) AS SupplierFreightInvoiceRequest,
  SupplierFreightInvoice.SuplrFrtInvcReqType AS SuplrFrtInvcReqType,
  SupplierFreightInvoice.SuplrFrtInvcReqCategory AS SuplrFrtInvcReqCategory,
  SupplierFreightInvoice.PurchasingOrgExternalID AS PurchasingOrgExternalID,
  SupplierFreightInvoice.PurchasingGroupExternalID AS PurchasingGroupExternalID,
  SupplierFreightInvoice.CarrierBusPurposeIsCompleted AS CarrierBusPurposeIsCompleted,
  SupplierFreightInvoice.BillFromPtyBusPrpsIsCompleted AS BillFromPtyBusPrpsIsCompleted,
  SupplierFreightInvoice.PayeeBusPurposeIsCompleted AS PayeeBusPurposeIsCompleted,
  SupplierFreightInvoice.InvoiceDate AS InvoiceDate,
  SupplierFreightInvoice.FrtCarrInvcID AS FrtCarrInvcID,
  SupplierFreightInvoice.CarrierUUID AS CarrierUUID,
  CollabnApplAddlAgrmtPty.Coll_Carrier AS Coll_Carrier,
  CollabnApplAddlAgrmtPty.BusinessPartnerUUID AS BusinessPartnerUUID,
  CarrierUser.BusinessPartnerCompany AS BusinessPartnerCompany,
  SupplierFreightInvoice.PaymentTerms AS PaymentTerms,
  _TranspChargeObject.TranspChrgNetAmtInDocCrcy AS TranspChrgNetAmtInDocCrcy,
  _TranspChargeObject.TranspChargeDocumentCurrency AS TranspChargeDocumentCurrency,
  SupplierFreightInvoice.PurgOrgCompanyCode AS PurgOrgCompanyCode
INNER JOIN P_CollabnApplFrtOrdParty AS CollabnApplAddlAgrmtPty ON /* join condition not captured in parsed metadata */
INNER JOIN P_CollabnApplCarrierUser AS CarrierUser ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CompanyCode AS _PurchasingCompanyCode ON PurgOrgCompanyCode = _PurchasingCompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_TranspChargeObject AS _TranspChargeObject ON SuplrFrtInvcReqUUID = _TranspChargeObject.TranspChargeHostDocumentUUID  -- association [0..1]
;