P_SupFrtInReqTrnChgItElmEnrcd

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_SupFrtInReqTrnChgItElmEnrcd.
-- 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: PSFTCELEN

CREATE VIEW P_SupFrtInReqTrnChgItElmEnrcd AS
SELECT
  P_SupFrtInReqTranspChrgItmElm.TranspChargeItemElementUUID AS TranspChargeItemElementUUID,
  P_SupFrtInReqTranspChrgItmElm.mandt AS mandt,
  P_SupFrtInReqTranspChrgItmElm.TransportationChargesObjUUID AS TransportationChargesObjUUID,
  P_SupFrtInReqTranspChrgItmElm.SuplrFrtInvcReqUUID AS SuplrFrtInvcReqUUID,
  P_SupFrtInReqTranspChrgItmElm.TranspChargeCalcReslnBase AS TranspChargeCalcReslnBase,
  P_SupFrtInReqTranspChrgItmElm.TranspChrgItmElmntResBaseKey AS TranspChrgItmElmntResBaseKey,
  BINTOHEX (P_SupFrtInReqTranspChrgItmElm.TranspChargeItemElementUUID) AS PurgDocExternalReference,
  /scmtms/d_sf_rot.sfir_id AS SupplierFreightInvoiceRequest,
  /scmtms/d_sf_rot.tsp_id AS Carrier,
  /scmtms/d_sf_rot.logsys AS TranspOrdLogicalSystem,
  /scmtms/d_sf_rot.bill_from_party AS TranspOrdInvoicingParty
FROM P_SupFrtInReqTranspChrgItmElm
INNER JOIN /scmtms/d_sf_rot ON /* join condition not captured in parsed metadata */
;