I_TRANSPORTATIONORDERBP

CDS View

Transportation Order: Business Partners

I_TRANSPORTATIONORDERBP is a CDS View in S/4HANA. Transportation Order: Business Partners. It contains 8 fields. 4 CDS views read from this table.

Used by 4 CDS view(s) 8 fields

CDS Views using this table (4)

ViewTypeJoinVDMDescription
I_TranspOrdBPAddrID view_entity from COMPOSITE Transp Order Bus Prtn Address ID
I_TranspOrdBPAddrID view_entity union_all COMPOSITE Transp Order Bus Prtn Address ID
I_TransportationOrderAllBP view from COMPOSITE Transportation Order: All Business Partners
R_TransportationOrderBPTP view_entity from TRANSACTIONAL Transportation Order Business Partner - TP

Fields (8)

KeyField CDS FieldsUsed in Views
KEY TransportationOrderBusPartUUID TransportationOrderBusPartUUID 1
_BusinessPartner _BusinessPartner 1
_PartnerFunction _PartnerFunction 1
AddressID TranspOrdBizPartnerAddressID 1
BusinessPartner BusinessPartner 1
BusinessPartnerRole TranspOrdBizPartnerFunction 1
BusinessPartnerUUID BusinessPartnerUUID 1
TransportationOrderUUID TransportationOrderUUID 2 
@EndUserText:   {label:              'Transportation Order: Business Partners'}
@ObjectModel:   {representativeKey:  'TransportationOrderBusPartUUID',
                 usageType:          {serviceQuality: #B,
                                      sizeCategory:   #XXL,
                                      dataClass:      #TRANSACTIONAL}}
@VDM:           {viewType:           #BASIC}
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl: {authorizationCheck: #PRIVILEGED_ONLY,
                 personalData.blocking:#('TRANSACTIONAL_DATA')}
@Metadata.ignorePropagatedAnnotations: true

define view entity I_TransportationOrderBP /*+[hideWarning] { "IDS" : [ "KEY_CHECK" ] }*/
  as select from /scmtms/d_torpty
  /* Business Object related Node Associations */
  association [1..1] to I_TransportationOrder as _TransportationOrder on $projection.TransportationOrderUUID = _TransportationOrder.TransportationOrderUUID
  association [0..1] to I_BusinessPartner     as _BusinessPartner     on $projection.BusinessPartner = _BusinessPartner.BusinessPartner
  association [0..1] to I_PartnerFunction     as _PartnerFunction     on $projection.BusinessPartnerRole = _PartnerFunction.PartnerFunction

{
  key db_key                                                            as TransportationOrderBusPartUUID,
      @ObjectModel.foreignKey.association: '_TransportationOrder'
      cast(parent_key as /scmtms/vdm_tor_db_key preserving type)        as TransportationOrderUUID,
      cast(party_id   as /scmtms/pty_consignee preserving type)         as BusinessPartner,
      cast(party_uuid as bu_partner_guid preserving type)               as BusinessPartnerUUID,
      cast(party_rco  as /scmtms/vdm_partner_function preserving type ) as BusinessPartnerRole,
      address_id                                                        as AddressID,
      substring( address_id, 3, 3)                                      as AddressIDType,

      /* Associations */
      @ObjectModel.association.type:  [ #TO_COMPOSITION_ROOT, #TO_COMPOSITION_PARENT ]
      _TransportationOrder,
      _BusinessPartner,
      _PartnerFunction
}
where
  node_key = hextobin(
             '80E0ED0A0DD11DEEA0D448872F169C9B'
             )
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"/SCMTMS/D_TORPTY"
],
"ASSOCIATED":
[
"I_BUSINESSPARTNER",
"I_PARTNERFUNCTION",
"I_TRANSPORTATIONORDER"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More