P_SlsOrdProcFlow23_1

DDL: P_SLSORDPROCFLOW23_1 SQL: PSLSORDPROCF231 Type: view CONSUMPTION Package: ODATA_SD_SO_PROCESSFLOW
8 Fields 2 Data Sources

Sales Order Process Flow: Level +2/3 Freight Orders Submodel

P_SlsOrdProcFlow23_1 is a Consumption CDS View that provides data about "Sales Order Process Flow: Level +2/3 Freight Orders Submodel" in SAP S/4HANA. It reads from 2 data sources (I_TranspOrdDocRef, I_TransportationOrderStop) and exposes 8 fields with key fields TransportationOrderUUID, TransportationOrderStopUUID, FreightOrder. Part of development package ODATA_SD_SO_PROCESSFLOW.

Data Sources (2)

SourceAliasJoin Type
I_TranspOrdDocRef SalesOrderRef inner
I_TransportationOrderStop TransOrderStop inner

Annotations (10)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
VDM.private true view
VDM.viewType #CONSUMPTION view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.preserveKey true view
AbapCatalog.sqlViewName PSLSORDPROCF231 view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY TransportationOrderUUID FreightUnit TransportationOrderUUID
KEY TransportationOrderStopUUID I_TransportationOrderStop TransportationOrderStopUUID UUID
KEY FreightOrder
TranspOrdStopCategory I_TransportationOrderStop TranspOrdStopCategory Stop Category
FreightUnit FreightUnit TransportationOrder
TransportationOrderCategory FreightUnit TransportationOrderCategory
TransportationRequestCategory FreightUnit TransportationRequestCategory
SalesOrder

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_SlsOrdProcFlow23_1.
-- 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: PSLSORDPROCF231

CREATE VIEW P_SlsOrdProcFlow23_1 AS
SELECT
  FreightUnit.TransportationOrderUUID AS TransportationOrderUUID,
  TransOrderStop.TransportationOrderStopUUID AS TransportationOrderStopUUID,
  TransOrderStop._CapaStop._TransportationOrder.TransportationOrder AS FreightOrder,
  TransOrderStop.TranspOrdStopCategory AS TranspOrdStopCategory,
  FreightUnit.TransportationOrder AS FreightUnit,
  FreightUnit.TransportationOrderCategory AS TransportationOrderCategory,
  FreightUnit.TransportationRequestCategory AS TransportationRequestCategory,
  cast( substring(SalesOrderRef.TranspOrdDocReferenceID,26,10) as vbeln_va preserving type) AS SalesOrder
INNER JOIN I_TranspOrdDocRef AS SalesOrderRef ON /* join condition not captured in parsed metadata */
INNER JOIN I_TransportationOrderStop AS TransOrderStop ON /* join condition not captured in parsed metadata */
;

Learn More