I_TranspInvcPreparationData

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_TranspInvcPreparationData.
-- 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: ITMINVCPREPDATA

CREATE VIEW I_TranspInvcPreparationData AS
SELECT
  $session.client AS SAPClient,
  po_id AS PurchasingDocument,
  po_item AS PurchasingDocumentItem,
  tor_id AS TransportationOrder,
  tor_item AS TranspOrdItem,
  bordero_id AS MasterBillOfLading,
  cast(tsp_id as erptms_party_id preserving type) AS Carrier,
  sfir_id AS SupplierFreightInvoiceRequest,
  sfir_item AS SupplierFreightInvoiceReqItem,
  ivp_id AS TranspOrdInvoicingParty,
  logsys AS TranspOrdLogicalSystem,
  srce_loc AS TranspOrdStageSrceLocation,
  dest_loc AS TranspOrdStageDestLocation,
  del_d AS TranspOrdStgeArrivalDate,
  pickup_d AS TranspOrdStgeDepartureDate,
  cpudt AS CreationDate,
  cputm AS PurchasingDocumentCreationTime,
  distance AS TranspOrdStageDistance,
  dist_uom AS TranspOrdStageDistanceUnit,
  shipper AS TranspInvcPrepShipper,
  consignee AS TranspInvcPrepConsignee,
  equipment_type AS EquipmentType,
  srce_ctry AS TranspOrdStageSrceLocCntry,
  dest_ctry AS TranspOrdStageDestLocCntry,
  tor_src_ctry AS TranspOrdSourceCountryCode,
  tor_dest_ctry AS TranspOrdDestCountryCode,
  product_id AS ProductID,
  package_id AS TranspOrdItemPackageID,
  shipping_type AS TransportationShippingType,
  platenumber AS TranspOrdActvVehRscePltNmbr,
  tor_src_loc AS TranspOrdSrceLocation,
  tor_dest_loc AS TranspOrdDestLocation,
  accr_proc_var AS TranspOrdAccrProcVar,
  tor_del_d AS TranspOrdArrivalDate,
  tor_pickup_d AS TranspOrdDepartureDate,
  total_distance AS TranspOrdDistance,
  total_distance_uom AS TranspOrdDistanceUnit,
  trmodcat AS TransportationModeCategory,
  charge_type AS TranspChargeType,
  tor_stpsucc_id AS TransportationOrderStop,
  inactive AS TranspInvcPrepIsInactive
FROM erptm_iv_data
;