I_TranspChargeObjectEnrcd

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_TranspChargeObjectEnrcd.
-- 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_TranspChargeObjectEnrcd AS
SELECT
  TransportationChargesObjUUID,
  TranspChargeHostDocumentUUID,
  TranspChargeDocumentCurrency,
  TranspChargeLocalCurrency,
  TranspChargeCalculationDateTme,
  cast(InvoicingStatus as /scmtms/vdm_invoice_status preserving type) AS InvoicingStatus,
  TranspChargeCalcStatus,
  cast(CarrierInvoicingStatus as /scmtms/vdm_carr_invc_status preserving type) AS CarrierInvoicingStatus
FROM I_TranspChargeObject
LEFT OUTER JOIN I_TranspChargeItemEnrcd AS _TranspChargeItemEnrcd ON TransportationChargesObjUUID = _TranspChargeItemEnrcd.TransportationChargesObjUUID  -- association [0..*]
LEFT OUTER JOIN I_SuplrFrtInvcReqEnrcd AS _SuplrFrtInvcReqEnrcd ON TranspChargeHostDocumentUUID = _SuplrFrtInvcReqEnrcd.SuplrFrtInvcReqUUID  -- association [0..1]
;