I_TRANSPORDDOCREF

CDS View

Transp Order: Document References

I_TRANSPORDDOCREF is a CDS View in S/4HANA. Transp Order: Document References. It contains 8 fields. 13 CDS views read from this table.

Used by 13 CDS view(s) 8 fields

CDS Views using this table (13)

ViewTypeJoinVDMDescription
C_FrtOrdStopLoadRefERPOrder view_entity inner CONSUMPTION Reference Stop to ERP Order Item
C_FrtOrdStopLoadRefLogsExecDlv view_entity inner CONSUMPTION Reference Stop to LE Delivery Item
C_FrtOrdStopLoadRefWrhsRequest view_entity inner CONSUMPTION Reference Stop to Warehouse Request Item
P_EWM_WhseReqBillOfLadingRefTM view_entity from COMPOSITE
P_EWM_WhseReqFreightOrderRefTM view_entity from COMPOSITE
P_EWM_WhseReqTranspOrdDocRef view_entity from COMPOSITE
P_OUTBDELIVERY_FREIGHT_ORDER view inner CONSUMPTION
P_OutbDelivFrtOrdRltn view_entity inner COMPOSITE Outbound Delivery Freight Order Relation
P_RETURNSDELIVERYFREIGHTORDER view inner CONSUMPTION
P_SlsOrdProcFlow14_1 view inner CONSUMPTION
P_SlsOrdProcFlow22_1 view inner CONSUMPTION
P_SlsOrdProcFlow23_1 view inner CONSUMPTION
R_TranspOrdDocRefTP view_entity from TRANSACTIONAL Transportation Order Doc Ref - TP

Fields (8)

KeyField CDS FieldsUsed in Views
KEY TransportationOrderDocRefUUID TransportationOrderDocRefUUID 1
TranspOrdDocReferenceID TranspOrdDocReferenceID,TranspOrdERPOrderDocumentID,TranspOrdLogsExecDeliveryID,TranspOrdWarehouseRequestID 4
TranspOrdDocReferenceItmID TranspOrdDocReferenceItmID 1
TranspOrdDocReferenceItmType TranspOrdDocReferenceItmType 1
TranspOrdDocReferenceType TranspOrdDocReferenceType 1
TranspOrdDocRefIssuerName TranspOrdDocRefIssuerName 1
TranspOrdDocumentReferenceDate TranspOrdDocumentReferenceDate 1
TransportationOrderUUID TransportationOrderUUID 1 
@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
}

Learn More