R_BillgDocRequestItemPartnerTP

DDL: R_BILLGDOCREQUESTITEMPARTNERTP Type: view_entity TRANSACTIONAL Package: RAP_SD_BIL_BDR

Billing Document Request Item Partner - TP

R_BillgDocRequestItemPartnerTP is a Transactional CDS View that provides data about "Billing Document Request Item Partner - TP" in SAP S/4HANA. It reads from 1 data source (I_BillgProcDocItemCmpltPartner) and exposes 13 fields with key fields BillingDocumentRequest, BillingDocumentRequestItem, PartnerFunction. It has 3 associations to related views. Part of development package RAP_SD_BIL_BDR.

1 data source(s) 13 fields

Data Sources (1)

SourceAliasJoin Type
I_BillgProcDocItemCmpltPartner ItemPartner from

Associations (3)

CardinalityTargetAliasCondition
[1..1] R_BillingDocumentRequestTP _BillingDocumentRequest $projection.BillingDocumentRequest = _BillingDocumentRequest.BillingDocumentRequest
[0..1] I_BusPartAddress _BusinessPartnerAddressCP $projection.AddressID = _BusinessPartnerAddressCP.AddressID and $projection.ContactPerson is not initial and $projection.SDDocPartnerAddressRefType = 'I'
[0..1] I_BusPartAddress _BusinessPartnerAddress $projection.ReferenceBusinessPartner = _BusinessPartnerAddress.BusinessPartner and $projection.AddressID = _BusinessPartnerAddress.AddressID and $projection.SDDocPartnerAddressRefType = 'H'

Annotations (7)

NameValueLevelField
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #TRANSACTIONAL view
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
EndUserText.label Billing Document Request Item Partner - TP view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY BillingDocumentRequest
KEY BillingDocumentRequestItem
KEY PartnerFunction PartnerFunction
PartnerIsSpecificForSDDocItem PartnerIsSpecificForSDDocItem
Customer Customer
Supplier Supplier
Personnel Personnel
ContactPerson ContactPerson
ReferenceBusinessPartner ReferenceBusinessPartner
AddressID AddressID
SDDocPartnerAddressRefType SDDocPartnerAddressRefType
_BillingDocumentRequest _BillingDocumentRequest
_Item _Item 
@VDM: {
  lifecycle.contract.type: #SAP_INTERNAL_API,
  viewType: #TRANSACTIONAL
}
@AccessControl: {
  authorizationCheck: #MANDATORY,   //MANDATORY

  personalData.blocking: #('TRANSACTIONAL_DATA')
//  privilegedAssociations: [ '_DfltAddrRprstn' ]

}
@ObjectModel: {
   usageType: {
     dataClass:      #TRANSACTIONAL,
     serviceQuality: #C,
     sizeCategory:   #XL
   },
    semanticKey: ['BillingDocumentRequest', 'BillingDocumentRequestItem', 'PartnerFunction']
}

@EndUserText.label: 'Billing Document Request Item Partner - TP'

define view entity R_BillgDocRequestItemPartnerTP
  as select from I_BillgProcDocItemCmpltPartner        as ItemPartner

  association to parent R_BillingDocumentRequestItemTP as _Item on  $projection.BillingDocumentRequest     = _Item.BillingDocumentRequest
                                                                and $projection.BillingDocumentRequestItem = _Item.BillingDocumentRequestItem
  association [1..1] to R_BillingDocumentRequestTP     as _BillingDocumentRequest  on  $projection.BillingDocumentRequest = _BillingDocumentRequest.BillingDocumentRequest
  association [0..1] to I_BusPartAddress               as _BusinessPartnerAddressCP      on  $projection.AddressID = _BusinessPartnerAddressCP.AddressID
                                                                                         and $projection.ContactPerson is not initial
                                                                                         and $projection.SDDocPartnerAddressRefType =  'I'

  association [0..1] to I_BusPartAddress               as _BusinessPartnerAddress      on  $projection.ReferenceBusinessPartner   = _BusinessPartnerAddress.BusinessPartner
                                                                                       and $projection.AddressID                  = _BusinessPartnerAddress.AddressID
                                                                                       and $projection.SDDocPartnerAddressRefType = 'H'                                                                                                                                              
  
{
    key cast(BillingProcessDocument as vbeln_bdr preserving type)      as BillingDocumentRequest,
    key cast(BillingProcessDocumentItem as posnr_bdr preserving type)      as BillingDocumentRequestItem,                                                                                                                                                                               
    key PartnerFunction,
        
    PartnerIsSpecificForSDDocItem,
    Customer,
    Supplier,
    Personnel,
    ContactPerson,
    case ContactPerson
      when '0000000000' then
       _BusinessPartnerAddress.AddressUUID
      else
       _BusinessPartnerAddressCP.AddressUUID
                                                  end as BusinessPartnerAddressUUID,
    ReferenceBusinessPartner,
    @Consumption.hidden: true
    AddressID,
    @Consumption.hidden: true
    SDDocPartnerAddressRefType,

    //Association

    _BillingDocumentRequest,
    _Item
}
where _BillingProcessDocumentItem.SDDocumentCategory = 'EBDR'

Learn More