R_TRANSPORDDOCREFTP

CDS View

Transportation Order Doc Ref - TP

R_TRANSPORDDOCREFTP is a CDS View in S/4HANA. Transportation Order Doc Ref - TP. 6 CDS views read from this table.

Used by 6 CDS view(s)

CDS Views using this table (6)

ViewTypeJoinVDMDescription
A_FreightBookingDocRef view_entity projection CONSUMPTION Freight Booking Document Reference
A_FreightOrderDocRef view_entity projection CONSUMPTION Freight Order Document Reference
A_FreightUnitDocumentReference view_entity projection CONSUMPTION Freight Unit Documnet Reference
I_FreightBookingDocRefTP view_entity projection TRANSACTIONAL Freight Booking Document Reference - TP
I_FreightOrderDocRefTP view_entity projection TRANSACTIONAL Freight Order Document Reference - TP
I_FreightUnitDocRefTP view_entity projection TRANSACTIONAL Freight Unit Document Reference - TP 
@AbapCatalog.viewEnhancementCategory: [#PROJECTION_LIST]
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Transportation Order Doc Ref - TP'
@Metadata.ignorePropagatedAnnotations: true
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@VDM.viewType: #TRANSACTIONAL
@ObjectModel: {
    usageType: {
        sizeCategory: #L,
        serviceQuality: #C,
        dataClass:#TRANSACTIONAL
    },
    semanticKey: ['TranspOrdDocReferenceID'],
    representativeKey: 'TransportationOrderDocRefUUID'
}

define view entity R_TranspOrdDocRefTP
  as select from I_TranspOrdDocRef as TransportationOrderDocRef
  /* We must join I_TransportationOrder to make I_TransportationOrder.TransportationOrderCategory available in the
   * projection views to filter by TransportationOrderCategory
   */
  inner join I_TransportationOrder as TransportationOrder on TransportationOrder.TransportationOrderUUID = TransportationOrderDocRef.TransportationOrderUUID
  association to parent R_TransportationOrderTP as _TransportationOrder on $projection.TransportationOrderUUID = _TransportationOrder.TransportationOrderUUID
{
      /* Attributes */
  key TransportationOrderDocRef.TransportationOrderDocRefUUID,
      TransportationOrderDocRef.TransportationOrderUUID,
      TransportationOrderDocRef.TranspOrdDocReferenceID,
      TransportationOrderDocRef.TranspOrdDocReferenceType,
      TransportationOrderDocRef.TranspOrdDocReferenceItmType,
      TransportationOrderDocRef.TranspOrdDocReferenceItmID,
      TransportationOrderDocRef.TranspOrdDocumentReferenceDate,
      TransportationOrderDocRef.TranspOrdDocRefIssuerName,
      
      // (Technical/Hidden) Attributes

      TransportationOrder.TransportationOrderCategory,

      /* Associations */
      _TransportationOrder
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_TRANSPORDDOCREF",
"I_TRANSPORTATIONORDER"
],
"ASSOCIATED":
[
"R_TRANSPORTATIONORDERTP"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More