I_TRANSPORDITEMDOCREF

CDS View

Transp Order Item Document References

I_TRANSPORDITEMDOCREF is a CDS View in S/4HANA. Transp Order Item Document References. It contains 9 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_TranspOrdItemDocRefTP view_entity from TRANSACTIONAL Transp Ord Item Document Reference - TP

Fields (9)

KeyField CDS FieldsUsed in Views
KEY TranspOrdItemDocReferenceUUID TranspOrdItemDocReferenceUUID 1
TranspOrdItemDocReferenceID TranspOrdItemDocReferenceID 1
TranspOrdItemDocReferenceType TranspOrdItemDocReferenceType 1
TranspOrdItemDocRefIssuerName TranspOrdItemDocRefIssuerName 1
TranspOrdItmDocRefDate TranspOrdItmDocRefDate 1
TranspOrdItmDocReferenceItemID TranspOrdItmDocReferenceItemID 1
TranspOrdItmDocRefItemType TranspOrdItmDocRefItemType 1
TransportationOrderItemUUID TransportationOrderItemUUID 1
TransportationOrderUUID TransportationOrderUUID 1
@AccessControl: {authorizationCheck:  #PRIVILEGED_ONLY,
                 personalData.blocking:#('TRANSACTIONAL_DATA')}

@VDM:           {viewType:           #BASIC}

@EndUserText.label: 'Transp Order Item Document References'

@ObjectModel.usageType:{
  serviceQuality: #X,
  sizeCategory: #S,
  dataClass: #TRANSACTIONAL
}
define view entity I_TranspOrdItemDocRef
  as select from /scmtms/d_toridr
  /* Business Object related Node Associations*/
  association [1..1] to I_TransportationOrderItem as _TransportationOrderItem on $projection.TransportationOrderItemUUID = _TransportationOrderItem.TransportationOrderItemUUID
  association [1..1] to I_TransportationOrder     as _TransportationOrder     on $projection.TransportationOrderUUID = _TransportationOrder.TransportationOrderUUID
{
  key cast(db_key as /scmtms/vdm_tor_itm_drf_uuid preserving type) as TranspOrdItemDocReferenceUUID,

      @ObjectModel.foreignKey.association: '_TransportationOrder'
      cast(root_key as /scmtms/vdm_tor_db_key preserving type)     as TransportationOrderUUID,

      @ObjectModel.foreignKey.association: '_TransportationOrderItem'
      cast(parent_key as /scmtms/toritmuuid preserving type)       as TransportationOrderItemUUID,

      btd_id                                                       as TranspOrdItemDocReferenceID,
      btd_tco                                                      as TranspOrdItemDocReferenceType,
      btditem_tco                                                  as TranspOrdItmDocRefItemType,
      btditem_id                                                   as TranspOrdItmDocReferenceItemID,
      btd_date                                                     as TranspOrdItmDocRefDate,
      btd_issuer                                                   as TranspOrdItemDocRefIssuerName,


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