C_TranspChargeObject

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 C_TranspChargeObject.
-- 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 C_TranspChargeObject AS
SELECT
  TransportationChargesObjUUID,
  TranspChargeHostDocumentUUID,
  TranspChargeDocumentCurrency,
  TranspChrgTotalAmtInDocCrcy,
  TranspChargeLocalCurrency,
  TranspChrgTotalAmtInLoclCrcy,
  TranspChargeCalculationDateTme,
  tstmp_to_dats(TranspChargeCalculationDateTme, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL' ) as TranspChargeCalculationDate AS clientNULLasTranspChargeCalculationDate,
  TranspChargeCalcStatus,
  _TranspChargeCalcStatus._Text[1: Language = $session.system_language].TranspChargeCalcStatusDesc AS TranspChargeCalcStatusDesc,
  TranspChargeUsage
FROM I_TranspChargeObject
LEFT OUTER JOIN C_TranspChargeItemElement AS _TranspChargeItemElement ON TransportationChargesObjUUID = _TranspChargeItemElement.TransportationChargesObjUUID  -- association [0..*]
LEFT OUTER JOIN I_OTRText AS _OTRText ON _OTRText.OnlnTxtRpstryConceptID = '40F2E9AFC5011ED8BA840937780C5DE1'  -- association [0..*]
;