I_TranspOrdDocRef

DDL: I_TRANSPORDDOCREF Type: view_entity BASIC

Transp Order: Document References

I_TranspOrdDocRef is a Basic CDS View that provides data about "Transp Order: Document References" in SAP S/4HANA. It reads from 1 data source (/scmtms/d_tordrf) and exposes 10 fields with key field TransportationOrderDocRefUUID. It has 1 association to related views.

1 data source(s) 10 fields

Data Sources (1)

SourceAliasJoin Type
/scmtms/d_tordrf /scmtms/d_tordrf from

Associations (1)

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

Annotations (7)

NameValueLevelField
EndUserText.label Transp Order: Document References view
ObjectModel.representativeKey TransportationOrderDocRefUUID view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY TransportationOrderDocRefUUID db_key
TransportationOrderUUID
TranspOrdDocReferenceID btd_id
TranspOrdDocReferenceType btd_tco
TranspOrdDocReferenceItmType btditem_tco
TranspOrdDocReferenceItmID btditem_id
TranspOrdOrigRefRootUUID orig_ref_root
TranspOrdDocumentReferenceDate btd_date
TranspOrdDocRefIssuerName btd_issuer
_TransportationOrder _TransportationOrder 
@EndUserText:   {label:              'Transp Order: Document References'}
@ObjectModel:   {representativeKey:  'TransportationOrderDocRefUUID',
                 usageType:          {serviceQuality: #B,
                                      sizeCategory:   #XXL,
                                      dataClass:      #TRANSACTIONAL}}
@VDM:           {viewType:           #BASIC}

@AccessControl: {authorizationCheck:  #PRIVILEGED_ONLY,
                 personalData.blocking:#('TRANSACTIONAL_DATA')}

define view entity I_TranspOrdDocRef
  as select from /scmtms/d_tordrf
  /* Business Object related Node Associations*/
  association [1..1] to I_TransportationOrder as _TransportationOrder on $projection.TransportationOrderUUID = _TransportationOrder.TransportationOrderUUID
{
  key db_key                                                     as TransportationOrderDocRefUUID,
      @ObjectModel.foreignKey.association: '_TransportationOrder'
      cast(parent_key as /scmtms/vdm_tor_db_key preserving type) as TransportationOrderUUID,
      btd_id                                                     as TranspOrdDocReferenceID,
      btd_tco                                                    as TranspOrdDocReferenceType,
      btditem_tco                                                as TranspOrdDocReferenceItmType,
      btditem_id                                                 as TranspOrdDocReferenceItmID,      
      orig_ref_root                                              as TranspOrdOrigRefRootUUID,
      btd_date                                                   as TranspOrdDocumentReferenceDate,
      btd_issuer                                                 as TranspOrdDocRefIssuerName,

      /* Associations */
      @ObjectModel.association.type:  [ #TO_COMPOSITION_ROOT, #TO_COMPOSITION_PARENT ]
      _TransportationOrder
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"/SCMTMS/D_TORDRF"
],
"ASSOCIATED":
[
"I_TRANSPORTATIONORDER"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More