I_BillingDocumentPartner

DDL: I_BILLINGDOCUMENTPARTNER Type: view COMPOSITE

Billing Document Partner

I_BillingDocumentPartner is a Composite CDS View that provides data about "Billing Document Partner" in SAP S/4HANA. It reads from 1 data source (I_BillingDocumentPartnerBasic) and exposes 17 fields with key fields BillingDocument, PartnerFunction. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_BillingDocumentPartnerBasic Partner from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_BillingDocument _BillingDocument $projection.BillingDocument = _BillingDocument.BillingDocument

Annotations (13)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Billing Document Partner view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
AbapCatalog.sqlViewName ISDBILDOCPT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ObjectModel.representativeKey PartnerFunction view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XL view
VDM.viewType #COMPOSITE view
Metadata.ignorePropagatedAnnotations true view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY BillingDocument I_BillingDocumentPartnerBasic BillingDocument
KEY PartnerFunction I_BillingDocumentPartnerBasic PartnerFunction
Customer I_BillingDocumentPartnerBasic Customer
Supplier I_BillingDocumentPartnerBasic Supplier
Personnel I_BillingDocumentPartnerBasic Personnel
AddressID I_BillingDocumentPartnerBasic AddressID
ContactPerson I_BillingDocumentPartnerBasic ContactPerson
AddressPersonID I_BillingDocumentPartnerBasic AddressPersonID
ReferenceBusinessPartner I_BillingDocumentPartnerBasic ReferenceBusinessPartner
SDDocPartnerAddressRefType I_BillingDocumentPartnerBasic SDDocPartnerAddressRefType
BPRefAddressIDForDocSpcfcAddr I_BillingDocumentPartnerBasic BPRefAddressIDForDocSpcfcAddr
_BillingDocument _BillingDocument
_PartnerFunction I_BillingDocumentPartnerBasic _PartnerFunction
_Address I_BillingDocumentPartnerBasic _Address
_BusinessPartnerAddress I_BillingDocumentPartnerBasic _BusinessPartnerAddress
_DfltAddrRprstn I_BillingDocumentPartnerBasic _DfltAddrRprstn
_BPRefAddressForDocSpcfcAddr I_BillingDocumentPartnerBasic _BPRefAddressForDocSpcfcAddr
@ClientHandling.algorithm: #SESSION_VARIABLE 
@EndUserText.label: 'Billing Document Partner'
@AccessControl: {
  authorizationCheck: #CHECK,
  personalData.blocking: #REQUIRED,
  privilegedAssociations: [ '_Address', '_DfltAddrRprstn' ]
}
@AbapCatalog: {
  sqlViewName: 'ISDBILDOCPT',
  compiler.compareFilter: true,
  preserveKey: true
}
@ObjectModel: {
   representativeKey: 'PartnerFunction',
   usageType: {
     dataClass:      #TRANSACTIONAL,
     serviceQuality: #B,
     sizeCategory:   #XL
   },
   supportedCapabilities: [ #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE, #CDS_MODELING_ASSOCIATION_TARGET ]      
}
@VDM.viewType: #COMPOSITE
@Metadata.ignorePropagatedAnnotations: true

define view I_BillingDocumentPartner as select from I_BillingDocumentPartnerBasic as Partner
    
    association [1..1] to I_BillingDocument     as _BillingDocument     on $projection.BillingDocument = _BillingDocument.BillingDocument    
{
                                             
      //--[ GENERATED:012:GlBfhyJl7kY4v5RWfCiSf0

      @Consumption.valueHelpDefinition: [ 
        { entity:  { name:    'I_BillingDocumentStdVH',
                     element: 'BillingDocument' }
        }]
      // ]--GENERATED

    @ObjectModel.foreignKey.association: '_BillingDocument'
    key Partner.BillingDocument,                                                                                                   
    @ObjectModel.foreignKey.association: '_PartnerFunction'
    key Partner.PartnerFunction,
    
    Partner.Customer,
    
    Partner.Supplier,
    
    Partner.Personnel,
    @ObjectModel.foreignKey.association: '_Address'
    Partner.AddressID,
    Partner.ContactPerson,
    
    Partner.AddressPersonID,
    Partner.ReferenceBusinessPartner,
    Partner.SDDocPartnerAddressRefType,
    Partner.BPRefAddressIDForDocSpcfcAddr,
    
    //Association

    @ObjectModel.association.type: [#TO_COMPOSITION_PARENT, #TO_COMPOSITION_ROOT]    
    _BillingDocument,
    Partner._PartnerFunction,
    Partner._Address,
    Partner._BusinessPartnerAddress,
    Partner._DfltAddrRprstn,
    Partner._BPRefAddressForDocSpcfcAddr   
}
where
     _BillingDocument.SDDocumentCategory = 'M' // Invoice

  or _BillingDocument.SDDocumentCategory = 'N' // Invoice Canceled

  or _BillingDocument.SDDocumentCategory = 'O' // Credit Memo

  or _BillingDocument.SDDocumentCategory = 'P' // Debit Memo

  or _BillingDocument.SDDocumentCategory = 'S' // Credit Memo Canceled

  or _BillingDocument.SDDocumentCategory = 'U' // Pro Forma Invoice

  or _BillingDocument.SDDocumentCategory = '5' // Intercompany Invoice

  or _BillingDocument.SDDocumentCategory = '6' // Intercompany Credit Memo

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BILLINGDOCUMENT",
"I_BILLINGDOCUMENTPARTNERBASIC"
],
"ASSOCIATED":
[
"I_ADDRESS",
"I_ADDRESS_2",
"I_BILLINGDOCUMENT",
"I_BUSPARTADDRESS",
"I_PARTNERFUNCTION"
],
"BASE":
[
"I_BILLINGDOCUMENTPARTNERBASIC"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/