P_CollabnApplCreditMemo

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_CollabnApplCreditMemo.
-- 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: PCOLLCRDMM

CREATE VIEW P_CollabnApplCreditMemo AS
SELECT
  CreditMemo.SuplrFrtInvcReqUUID AS SuplrFrtInvcReqUUID,
  ltrim(CreditMemo.SupplierFreightInvoiceRequest, '0' ) AS SupplierFreightInvoiceRequest,
  CreditMemo.FrtCarrInvcID AS FrtCarrCreditMemoID,
  CreditMemo.SuplrFrtReqRefDocUUID AS SuplrFrtReqRefDocUUID,
  _FreightInvoice.FrtCarrInvcID AS FrtCarrInvcID,
  CreditMemo.SuplrFrtInvcReqType AS SuplrFrtInvcReqType,
  CreditMemo.SuplrFrtInvcReqCategory AS SuplrFrtInvcReqCategory,
  CreditMemo.PurchasingOrgExternalID AS PurchasingOrgExternalID,
  CreditMemo.PurchasingGroupExternalID AS PurchasingGroupExternalID,
  CreditMemo.CarrierBusPurposeIsCompleted AS CarrierBusPurposeIsCompleted,
  CreditMemo.BillFromPtyBusPrpsIsCompleted AS BillFromPtyBusPrpsIsCompleted,
  CreditMemo.PayeeBusPurposeIsCompleted AS PayeeBusPurposeIsCompleted,
  CreditMemo.InvoiceDate AS InvoiceDate,
  CreditMemo.PaymentTerms AS PaymentTerms,
  cast( '02' as /scmtms/vdm_coll_carr_crdmm_st ) AS CreditMemoLifecycleStatus,
  CreditMemo.CarrierUUID AS CarrierUUID,
  CreditMemo.PurgOrgCompanyCode AS PurgOrgCompanyCode,
  _TranspChargeObject.TranspChrgTotalAmtInDocCrcy AS TranspChrgTotalAmtInDocCrcy,
  _TranspChargeObject.TranspChrgNetAmtInDocCrcy AS TranspChrgNetAmtInDocCrcy,
  _TranspChargeObject.TranspChargeDocumentCurrency AS TranspChargeDocumentCurrency
FROM I_SupplierFreightInvoiceReq AS CreditMemo
INNER JOIN I_TMBusinessPartnerByIntKey AS Carrier 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_CollabnApplCrdMmStatus AS _CollabnApplCrdMmStatus ON CreditMemoLifecycleStatus = _CollabnApplCrdMmStatus.CreditMemoLifecycleStatus  -- association [1..1]
LEFT OUTER JOIN I_SupplierFreightInvoiceReq AS _FreightInvoice ON SuplrFrtReqRefDocUUID = _FreightInvoice.SuplrFrtInvcReqUUID  -- association [1..1]
LEFT OUTER JOIN I_TranspChargeObject AS _TranspChargeObject ON SuplrFrtInvcReqUUID = _TranspChargeObject.TranspChargeHostDocumentUUID  -- association [0..1]
;