P_SlsOrdProcFlow23_1

DDL: P_SLSORDPROCFLOW23_1 SQL: PSLSORDPROCF231 Type: view CONSUMPTION

P_SlsOrdProcFlow23_1 is a Consumption CDS View in SAP S/4HANA. It reads from 2 data sources (I_TranspOrdDocRef, I_TransportationOrderStop) and exposes 8 fields with key fields TransportationOrderUUID, TransportationOrderStopUUID, FreightOrder.

2 data source(s) 8 fields

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
KEY FreightOrder
TranspOrdStopCategory I_TransportationOrderStop TranspOrdStopCategory
FreightUnit FreightUnit TransportationOrder
TransportationOrderCategory FreightUnit TransportationOrderCategory
TransportationRequestCategory FreightUnit TransportationRequestCategory
SalesOrder 
@ClientHandling.algorithm: #SESSION_VARIABLE 
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XL

@VDM.private: true
@VDM.viewType: #CONSUMPTION
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@AbapCatalog.preserveKey: true
@AbapCatalog.sqlViewName: 'PSLSORDPROCF231'

define view P_SlsOrdProcFlow23_1
as select distinct from I_TransportationOrder     as FreightUnit
inner join              I_TranspOrdDocRef         as SalesOrderRef  on  FreightUnit.TransportationOrderUUID = SalesOrderRef.TransportationOrderUUID 
                                                                    and SalesOrderRef.TranspOrdDocReferenceType = '114'                                                               
inner join              I_TransportationOrderStop as TransOrderStop on  FreightUnit.TransportationOrderUUID = TransOrderStop.TransportationOrderUUID
                                                                    and TransOrderStop.TranspOrdStopCategory = 'O' --> Freight Order

//Reads Freight Orders preceeded by a Freight Unit

{
    key FreightUnit.TransportationOrderUUID,
    key TransOrderStop.TransportationOrderStopUUID,
    key TransOrderStop._CapaStop._TransportationOrder.TransportationOrder                   as FreightOrder,
        TransOrderStop.TranspOrdStopCategory                                                as TranspOrdStopCategory,
        FreightUnit.TransportationOrder                                                     as FreightUnit,
        FreightUnit.TransportationOrderCategory,
        FreightUnit.TransportationRequestCategory,
        cast( substring(SalesOrderRef.TranspOrdDocReferenceID,26,10) as vbeln_va preserving type)  as SalesOrder
} 
where FreightUnit.TransportationOrderCategory = 'FU'   --> Freight Unit
and   TransOrderStop._CapaStop._TransportationOrder.TransportationOrder <> ''
and   TransOrderStop._CapaStop._TransportationOrder.TransportationOrderCategory <> 'BO'
and   TransOrderStop._CapaStop._TransportationOrder.TransportationOrderCategory <> 'TU'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_TRANSPORDDOCREF",
"I_TRANSPORTATIONORDER",
"I_TRANSPORTATIONORDERSTOP"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More