R_TranspOrdItemDocRefTP

DDL: R_TRANSPORDITEMDOCREFTP Type: view_entity TRANSACTIONAL

Transp Ord Item Document Reference - TP

R_TranspOrdItemDocRefTP is a Transactional CDS View that provides data about "Transp Ord Item Document Reference - TP" in SAP S/4HANA. It reads from 2 data sources (I_TransportationOrder, I_TranspOrdItemDocRef) and exposes 12 fields with key field TranspOrdItemDocReferenceUUID. It has 1 association to related views.

2 data source(s) 12 fields

Data Sources (2)

SourceAliasJoin Type
I_TransportationOrder TransportationOrder inner
I_TranspOrdItemDocRef TransportationOrderItemDocRef from

Associations (1)

CardinalityTargetAliasCondition
[1..1] R_TransportationOrderTP _TransportationOrder $projection.TransportationOrderUUID = _TransportationOrder.TransportationOrderUUID

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Transp Ord Item Document Reference - TP view
Metadata.ignorePropagatedAnnotations true view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.representativeKey TranspOrdItemDocReferenceUUID view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY TranspOrdItemDocReferenceUUID I_TranspOrdItemDocRef TranspOrdItemDocReferenceUUID
TransportationOrderItemUUID I_TranspOrdItemDocRef TransportationOrderItemUUID
TransportationOrderUUID I_TranspOrdItemDocRef TransportationOrderUUID
TranspOrdItemDocReferenceID I_TranspOrdItemDocRef TranspOrdItemDocReferenceID
TranspOrdItemDocReferenceType I_TranspOrdItemDocRef TranspOrdItemDocReferenceType
TranspOrdItmDocReferenceItemID I_TranspOrdItemDocRef TranspOrdItmDocReferenceItemID
TranspOrdItmDocRefItemType I_TranspOrdItemDocRef TranspOrdItmDocRefItemType
TranspOrdItmDocRefDate I_TranspOrdItemDocRef TranspOrdItmDocRefDate
TranspOrdItemDocRefIssuerName I_TranspOrdItemDocRef TranspOrdItemDocRefIssuerName
TransportationOrderCategory I_TransportationOrder TransportationOrderCategory
_TransportationOrder _TransportationOrder
_TransportationOrderItem _TransportationOrderItem 
@AbapCatalog.viewEnhancementCategory: [#PROJECTION_LIST]
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Transp Ord Item Document Reference - TP'
@Metadata.ignorePropagatedAnnotations: true
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@VDM.viewType: #TRANSACTIONAL
@ObjectModel: {
    usageType: {
        sizeCategory: #L,
        serviceQuality: #C,
        dataClass:#TRANSACTIONAL
    },
    semanticKey: ['TranspOrdItemDocReferenceID'],
    representativeKey: 'TranspOrdItemDocReferenceUUID'
}

define view entity R_TranspOrdItemDocRefTP
  as select from I_TranspOrdItemDocRef as TransportationOrderItemDocRef
  /* 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 = TransportationOrderItemDocRef.TransportationOrderUUID
  association        to parent R_TransportationOrderItemTP as _TransportationOrderItem on $projection.TransportationOrderItemUUID = _TransportationOrderItem.TransportationOrderItemUUID
  association [1..1] to R_TransportationOrderTP            as _TransportationOrder     on $projection.TransportationOrderUUID = _TransportationOrder.TransportationOrderUUID
{
      /* Attributes */
  key TransportationOrderItemDocRef.TranspOrdItemDocReferenceUUID,
      TransportationOrderItemDocRef.TransportationOrderItemUUID,
      TransportationOrderItemDocRef.TransportationOrderUUID,
      TransportationOrderItemDocRef.TranspOrdItemDocReferenceID,
      TransportationOrderItemDocRef.TranspOrdItemDocReferenceType,
      TransportationOrderItemDocRef.TranspOrdItmDocReferenceItemID,
      TransportationOrderItemDocRef.TranspOrdItmDocRefItemType,
      TransportationOrderItemDocRef.TranspOrdItmDocRefDate,
      TransportationOrderItemDocRef.TranspOrdItemDocRefIssuerName,

      // (Technical/Hidden) Attributes

      TransportationOrder.TransportationOrderCategory,

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

Learn More