P_BillgProcDocItemInhtdPartner

DDL: P_BILLGPROCDOCITEMINHTDPARTNER Type: view_entity COMPOSITE

P_BillgProcDocItemInhtdPartner is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (I_BillingDocumentItemBasic, I_BillingDocumentPartnerBasic) and exposes 17 fields with key fields BillingDocument, BillingDocumentItem, PartnerFunction.

2 data source(s) 17 fields

Data Sources (2)

SourceAliasJoin Type
I_BillingDocumentItemBasic Item from
I_BillingDocumentPartnerBasic Partner inner

Annotations (7)

NameValueLevelField
ObjectModel.representativeKey PartnerFunction view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XL view
VDM.private true view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY BillingDocument I_BillingDocumentPartnerBasic BillingDocument
KEY BillingDocumentItem I_BillingDocumentItemBasic BillingDocumentItem
KEY PartnerFunction I_BillingDocumentPartnerBasic PartnerFunction
Customer I_BillingDocumentPartnerBasic Customer
Supplier I_BillingDocumentPartnerBasic Supplier
Personnel I_BillingDocumentPartnerBasic Personnel
ContactPerson I_BillingDocumentPartnerBasic ContactPerson
ReferenceBusinessPartner I_BillingDocumentPartnerBasic ReferenceBusinessPartner
AddressID I_BillingDocumentPartnerBasic AddressID
AddressPersonID I_BillingDocumentPartnerBasic AddressPersonID
AddressObjectType I_BillingDocumentPartnerBasic AddressObjectType
SDDocPartnerAddressRefType I_BillingDocumentPartnerBasic SDDocPartnerAddressRefType
VATRegistration I_BillingDocumentPartnerBasic VATRegistration
UnloadingPointName I_BillingDocumentPartnerBasic UnloadingPointName
_PartnerFunction I_BillingDocumentPartnerBasic _PartnerFunction
_DfltAddrRprstn I_BillingDocumentPartnerBasic _DfltAddrRprstn
_BillingDocumentBasic I_BillingDocumentPartnerBasic _BillingDocumentBasic 
@ObjectModel: {
   representativeKey: 'PartnerFunction',
   usageType: {
     dataClass:      #TRANSACTIONAL,
     serviceQuality: #B,
     sizeCategory:   #XL
   }
}

@VDM: {
  private: true,
  viewType: #COMPOSITE
}

@AccessControl.authorizationCheck: #NOT_REQUIRED
define view entity P_BillgProcDocItemInhtdPartner
  as select from           I_BillingDocumentItemBasic    as Item
    inner join             I_BillingDocumentPartnerBasic as Partner     on Item.BillingDocument = Partner.BillingDocument
    left outer to one join I_BillingDocItemPartnerBasic  as ItemPartner on  Partner.BillingDocument  = ItemPartner.BillingDocument
                                                                        and Item.BillingDocumentItem = ItemPartner.BillingDocumentItem
                                                                        and Partner.PartnerFunction  = ItemPartner.PartnerFunction
{
  key Partner.BillingDocument,
  key Item.BillingDocumentItem,
  key Partner.PartnerFunction,

      Partner.Customer,
      Partner.Supplier,
      Partner.Personnel,
      Partner.ContactPerson,
      Partner.ReferenceBusinessPartner,

      Partner.AddressID,
      Partner.AddressPersonID,
      Partner.AddressObjectType,
      Partner.SDDocPartnerAddressRefType,

      Partner.VATRegistration,
      Partner.UnloadingPointName,

      Partner._PartnerFunction,
      Partner._DfltAddrRprstn,
      Partner._BillingDocumentBasic
}
where
  ItemPartner.PartnerFunction is null
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BILLINGDOCITEMPARTNERBASIC",
"I_BILLINGDOCUMENTITEMBASIC",
"I_BILLINGDOCUMENTPARTNERBASIC"
],
"ASSOCIATED":
[
"I_ADDRESS_2",
"I_BILLINGDOCUMENTBASIC",
"I_PARTNERFUNCTION"
],
"BASE":
[
"I_BILLINGDOCUMENTPARTNERBASIC"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More