I_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 I_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 I_TranspChargeObject AS
SELECT
  cast(db_key as /scmtms/vdm_chrg_obj_db_key preserving type) AS TransportationChargesObjUUID,
  host_key AS TranspChargeHostDocumentUUID,
  doc_currency AS TranspChargeDocumentCurrency,
  cast( cast( total_amount as abap.dec(31,6) ) * 10000 as abap.curr(31,2) ) AS TranspChrgTotalAmtInDocCrcy,
  cast( cast( net_amount as abap.dec(31,6) ) * 10000 as abap.curr(31,2) ) AS TranspChrgNetAmtInDocCrcy,
  lcl_currency AS TranspChargeLocalCurrency,
  cast( cast( net_amount_lcl as abap.dec(31,6) ) * 10000 as abap.curr(31,2) ) AS TranspChrgTotalAmtInLoclCrcy,
  calcdate_tstmp AS TranspChargeCalculationDateTme,
  cast( invoicing as transpchargepostingstatus ) AS InvoicingStatus,
  calc_status AS TranspChargeCalcStatus,
  car_invoicing AS CarrierInvoicingStatus,
  tcusagecd085 AS TranspChargeUsage,
  exchdate_doc AS ExchangeRateDate,
  cast( cast( invoiced_amt as abap.dec(31,6) ) * 10000 as abap.curr(31,2) ) AS InvoicedAmount
FROM /scmtms/d_tchrgr
LEFT OUTER JOIN I_TranspChargeItem AS _TranspChargeItem ON TransportationChargesObjUUID = _TranspChargeItem.TransportationChargesObjUUID  -- association [0..*]
LEFT OUTER JOIN I_InvoicingStatus AS _InvoicingStatus ON InvoicingStatus = _InvoicingStatus.InvoicingStatus  -- association [0..1]
LEFT OUTER JOIN I_TranspChargeCalcStatus AS _TranspChargeCalcStatus ON TranspChargeCalcStatus = _TranspChargeCalcStatus.TranspChargeCalcStatus  -- association [0..1]
LEFT OUTER JOIN I_CarrierInvoicingStatus AS _CarrierInvoicingStatus ON CarrierInvoicingStatus = _CarrierInvoicingStatus.CarrierInvoicingStatus  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _TranspChargeDocumentCurrency ON TranspChargeDocumentCurrency = _TranspChargeDocumentCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _TranspChargeLocalCurrency ON TranspChargeLocalCurrency = _TranspChargeLocalCurrency.Currency  -- association [0..1]
;