R_BillingDocumentPartnerTP

DDL: R_BILLINGDOCUMENTPARTNERTP Type: view_entity TRANSACTIONAL Package: RAP_SD_BIL_BD

Billing Document Partner - TP

R_BillingDocumentPartnerTP is a Transactional CDS View that provides data about "Billing Document Partner - TP" in SAP S/4HANA. It reads from 1 data source (I_BillingDocumentPartner) and exposes 14 fields with key fields BillingDocument, PartnerFunction. It has 1 association to related views. Part of development package RAP_SD_BIL_BD.

1 data source(s) 14 fields

Data Sources (1)

SourceAliasJoin Type
I_BillingDocumentPartner I_BillingDocumentPartner from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_BusPartAddress _BusinessPartnerAddressCP I_BillingDocumentPartner.AddressID = _BusinessPartnerAddressCP.AddressID and $projection.ContactPerson is not initial and I_BillingDocumentPartner.SDDocPartnerAddressRefType = 'I'

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 Partner - TP view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY BillingDocument BillingDocument
KEY PartnerFunction
Customer Customer
Supplier Supplier
Personnel Personnel
ContactPerson ContactPerson
ReferenceBusinessPartner ReferenceBusinessPartner
AddressID AddressID
AddressPersonID AddressPersonID
AddressObjectType AddressObjectType
VATRegistration VATRegistration
UnloadingPointName UnloadingPointName
_BillingDocument _BillingDocument
_PartnerFunction _PartnerFunction 
@VDM: {
  lifecycle.contract.type: #SAP_INTERNAL_API,
  viewType: #TRANSACTIONAL
}
@AccessControl: {
  authorizationCheck: #MANDATORY,  
  personalData.blocking: #('TRANSACTIONAL_DATA')

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

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

define view entity R_BillingDocumentPartnerTP 
  as select from I_BillingDocumentPartner
  association to parent R_BillingDocumentTP as _BillingDocument  
                                            on $projection.BillingDocument = _BillingDocument.BillingDocument
  association [0..1] to I_BusPartAddress    as _BusinessPartnerAddressCP      on I_BillingDocumentPartner.AddressID                   = _BusinessPartnerAddressCP.AddressID
                                                                              and $projection.ContactPerson is not initial
                                                                              and I_BillingDocumentPartner.SDDocPartnerAddressRefType =  'I'
{
   key BillingDocument,                                                                                           
   key cast(PartnerFunction as parvw_unv preserving type ) as PartnerFunction,
   
   Customer,
   Supplier,
   Personnel,
   ContactPerson,
   ReferenceBusinessPartner,
    
   case ContactPerson
        when '0000000000' then
         _BusinessPartnerAddress.AddressUUID
       else
         _BusinessPartnerAddressCP.AddressUUID
   end as BusinessPartnerAddressUUID,
   
   AddressID,
   AddressPersonID,
   AddressObjectType,
   cast(case SDDocPartnerAddressRefType
             when 'E' then 'X'
             when 'F' then 'X'
             else ' '
           end                 as sd_pd_doc_spec_addr_flag preserving type)          as SDDocPartnerAddrIsDocSpecific,
   VATRegistration,
   @Semantics.text: true
   UnloadingPointName,    
    
   _BillingDocument,
   _PartnerFunction   
}
where
_BillingDocument.BillingDocumentIsTemporary = ' '

Learn More