R_TrOrdMainBPAddrAddlRprstnTP

DDL: R_TRORDMAINBPADDRADDLRPRSTNTP Type: view_entity TRANSACTIONAL

Transp Ord Main BP Addr Addl Rprstn - TP

R_TrOrdMainBPAddrAddlRprstnTP is a Transactional CDS View that provides data about "Transp Ord Main BP Addr Addl Rprstn - TP" in SAP S/4HANA. It reads from 2 data sources (I_Address_2, I_TranspOrdMainBPAddrID) and exposes 18 fields with key fields TransportationOrderUUID, TranspOrdBizPartnerFunction, AddressRepresentationCode. It has 1 association to related views.

2 data source(s) 18 fields

Data Sources (2)

SourceAliasJoin Type
I_Address_2 _Address_2 inner
I_TranspOrdMainBPAddrID TranspOrdMainBPAddrID from

Associations (1)

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

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Transp Ord Main BP Addr Addl Rprstn - 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 TransportationOrderUUID view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY TransportationOrderUUID I_TranspOrdMainBPAddrID TransportationOrderUUID
KEY TranspOrdBizPartnerFunction I_TranspOrdMainBPAddrID TranspOrdBizPartnerFunction
KEY AddressRepresentationCode I_Address_2 AddressRepresentationCode
AddressID I_Address_2 AddressID
AddressPersonID I_Address_2 AddressPersonID
AddresseeFullName I_Address_2 AddresseeFullName
AddressTimeZone I_Address_2 AddressTimeZone
CityName I_Address_2 CityName
PostalCode I_Address_2 PostalCode
StreetName I_Address_2 StreetName
HouseNumber I_Address_2 HouseNumber
Country I_Address_2 Country
Region I_Address_2 Region
TransportationOrderCategory _TrOrdMainBPAddrDfltRprstn TransportationOrderCategory
_TrOrdMainBPAddrDfltRprstn _TrOrdMainBPAddrDfltRprstn
_TransportationOrder _TransportationOrder
_AddressRepresentationCode I_Address_2 _AddressRepresentationCode
_PartnerFunction I_TranspOrdMainBPAddrID _PartnerFunction 
@AbapCatalog.viewEnhancementCategory: [#PROJECTION_LIST]
@AccessControl: {
  authorizationCheck: #MANDATORY }
@EndUserText.label: 'Transp Ord Main BP Addr Addl Rprstn - TP'
@Metadata.ignorePropagatedAnnotations: true
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@VDM.viewType: #TRANSACTIONAL
@ObjectModel: {
    usageType: {
        sizeCategory: #L,
        serviceQuality: #C,
        dataClass:#TRANSACTIONAL
    },
    semanticKey: ['AddressID'],
    representativeKey: 'TransportationOrderUUID'
}

define view entity R_TrOrdMainBPAddrAddlRprstnTP
  as select from I_TranspOrdMainBPAddrID as TranspOrdMainBPAddrID

    inner join   I_Address_2             as _Address_2 on  _Address_2.AddressID                 = TranspOrdMainBPAddrID.AddressID
                                                       and _Address_2.AddressPersonID           = ' '
                                                       and _Address_2.AddressRepresentationCode is not initial

  association        to parent R_TrOrdMainBPAddrDfltRprstnTP as _TrOrdMainBPAddrDfltRprstn on  $projection.TransportationOrderUUID     = _TrOrdMainBPAddrDfltRprstn.TransportationOrderUUID
                                                                                           and $projection.TranspOrdBizPartnerFunction = _TrOrdMainBPAddrDfltRprstn.TranspOrdBizPartnerFunction

  association [1..1] to R_TransportationOrderTP              as _TransportationOrder       on  $projection.TransportationOrderUUID = _TransportationOrder.TransportationOrderUUID

{
  key  TranspOrdMainBPAddrID.TransportationOrderUUID          as TransportationOrderUUID,
       @ObjectModel.foreignKey.association: '_PartnerFunction'
  key  TranspOrdMainBPAddrID.TranspOrdBizPartnerFunction      as TranspOrdBizPartnerFunction,
       @ObjectModel.foreignKey.association: '_AddressRepresentationCode'
  key  _Address_2.AddressRepresentationCode                   as AddressRepresentationCode,

       // Identification for Address

       _Address_2.AddressID                                   as AddressID,
       _Address_2.AddressPersonID                             as AddressPersonID,

       // Postal Address

       _Address_2.AddresseeFullName                           as AddresseeFullName,
       _Address_2.AddressTimeZone                             as AddressTimeZone,
       _Address_2.CityName                                    as CityName,
       _Address_2.PostalCode                                  as PostalCode,
       _Address_2.StreetName                                  as StreetName,
       _Address_2.HouseNumber                                 as HouseNumber,
       _Address_2.Country                                     as Country,
       _Address_2.Region                                      as Region,

       // (Technical/Hidden) Attributes

       _TrOrdMainBPAddrDfltRprstn.TransportationOrderCategory as TransportationOrderCategory,

       /* Associations */
       _TrOrdMainBPAddrDfltRprstn,
       _TransportationOrder,

       _Address_2._AddressRepresentationCode,
       TranspOrdMainBPAddrID._PartnerFunction
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ADDRESS_2",
"I_TRANSPORDMAINBPADDRID",
"R_TRORDMAINBPADDRDFLTRPRSTNTP"
],
"ASSOCIATED":
[
"I_ADDRESSREPRESENTATION",
"I_PARTNERFUNCTION",
"R_TRANSPORTATIONORDERTP",
"R_TRORDMAINBPADDRDFLTRPRSTNTP"
],
"BASE":
[
"I_ADDRESS_2",
"I_TRANSPORDMAINBPADDRID"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More