I_TransportationOrderBP

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_TransportationOrderBP.
-- 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_TransportationOrderBP AS
SELECT
  db_key AS TransportationOrderBusPartUUID,
  cast(root_key as /scmtms/vdm_tor_db_key preserving type) AS RefTransportationOrderUUID,
  cast(parent_key as /scmtms/vdm_tor_db_key preserving type) AS TransportationOrderUUID,
  cast(party_id as /scmtms/pty_consignee preserving type) AS BusinessPartner,
  cast(party_uuid as bu_partner_guid preserving type) AS BusinessPartnerUUID,
  cast(party_rco as /scmtms/vdm_partner_function preserving type ) AS BusinessPartnerRole,
  address_id AS AddressID,
  substring( address_id, 3, 3) AS AddressIDType
FROM /scmtms/d_torpty
LEFT OUTER JOIN I_TransportationOrder AS _TransportationOrder ON TransportationOrderUUID = _TransportationOrder.TransportationOrderUUID  -- association [1..1]
LEFT OUTER JOIN I_BusinessPartner AS _BusinessPartner ON BusinessPartner = _BusinessPartner.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_PartnerFunction AS _PartnerFunction ON BusinessPartnerRole = _PartnerFunction.PartnerFunction  -- association [0..1]
;