//@EndUserText.label: 'Transportation Order: Item Delivery Document Reference'
@ObjectModel: {representativeKey: 'TransportationOrderItemUUID',
usageType: {serviceQuality: #C,
sizeCategory: #XXL,
dataClass: #TRANSACTIONAL}}
@VDM: {viewType: #COMPOSITE,
private: true}
@AbapCatalog: {compiler: {compareFilter: true},
sqlViewName: 'PTORITEDLDOREF',
buffering: {status: #NOT_ALLOWED},
preserveKey: true }
@AccessControl: {authorizationCheck: #PRIVILEGED_ONLY}
@ClientHandling.algorithm: #SESSION_VARIABLE
define view P_TranspOrdItmDelivDocRef
as select distinct from I_TransportationOrderItem
{
key TransportationOrderItemUUID as TransportationOrderItemUUID,
key TransportationOrderUUID as TransportationOrderUUID,
TranspOrdItemCategory as TranspOrdItemCategory,
TranspOrdDocReferenceID as TranspOrdDocReferenceID,
TranspOrdDocReferenceType as TranspOrdDocReferenceType,
TranspOrdItmWhseNmbr as TranspOrdItmWhseNmbr
}
where
TranspOrdItmWhseNmbr <> ''
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_TRANSPORTATIONORDERITEM"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/