I_InvoiceListPartner

DDL: I_INVOICELISTPARTNER Type: view COMPOSITE

Invoice List Partner

I_InvoiceListPartner is a Composite CDS View that provides data about "Invoice List Partner" in SAP S/4HANA. It reads from 1 data source (I_BillingDocumentPartnerBasic) and exposes 12 fields with key fields InvoiceList, PartnerFunction. It has 1 association to related views.

1 data source(s) 12 fields

Data Sources (1)

SourceAliasJoin Type
I_BillingDocumentPartnerBasic Partner from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_InvoiceList _InvoiceList $projection.InvoiceList = _InvoiceList.InvoiceList

Annotations (11)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Invoice List Partner view
AccessControl.authorizationCheck #CHECK view
AbapCatalog.sqlViewName ISDINVOICELISTPT 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

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY InvoiceList
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
_InvoiceList _InvoiceList
_PartnerFunction I_BillingDocumentPartnerBasic _PartnerFunction
_Address I_BillingDocumentPartnerBasic _Address
_DfltAddrRprstn I_BillingDocumentPartnerBasic _DfltAddrRprstn 
@ClientHandling.algorithm: #SESSION_VARIABLE 
@EndUserText.label: 'Invoice List Partner'
@AccessControl.personalData.blocking: #('TRANSACTIONAL_DATA')
@AccessControl: {
  authorizationCheck: #CHECK,
  privilegedAssociations: [ '_Address', '_DfltAddrRprstn' ]
}@AbapCatalog: {
  sqlViewName: 'ISDINVOICELISTPT',
  compiler.compareFilter: true,
  preserveKey: true
}
@ObjectModel: {
   representativeKey: 'PartnerFunction',
   usageType: {
     dataClass:      #TRANSACTIONAL,
     serviceQuality: #B,
     sizeCategory:   #XL
   }
}
@VDM.viewType: #COMPOSITE

define view I_InvoiceListPartner  as select from I_BillingDocumentPartnerBasic as Partner
    
    association [1..1] to I_InvoiceList     as _InvoiceList     on $projection.InvoiceList = _InvoiceList.InvoiceList    
    
{
    @Consumption.valueHelpDefinition: [ 
      { entity:  { name:    'I_InvoiceListStdVH',
                   element: 'InvoiceList' }
      }]    
    @ObjectModel.foreignKey.association: '_InvoiceList'                                                                                                                                               
    key cast(Partner.BillingDocument as vbeln_rl preserving type ) as InvoiceList,       
                                                 
    key Partner.PartnerFunction,
    
    Partner.Customer,
    
    Partner.Supplier,
    
    Partner.Personnel,

    Partner.AddressID,
    
    Partner.ContactPerson,
    
    Partner.AddressPersonID,
    
    //Association

    @ObjectModel.association.type: [#TO_COMPOSITION_PARENT, #TO_COMPOSITION_ROOT]    
    _InvoiceList,
    Partner._PartnerFunction,
    Partner._Address,
    Partner._DfltAddrRprstn    
}
 where _InvoiceList.SDDocumentCategory = '3' or _InvoiceList.SDDocumentCategory = '4' 
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BILLINGDOCUMENTPARTNERBASIC",
"I_INVOICELIST"
],
"ASSOCIATED":
[
"I_ADDRESS",
"I_ADDRESS_2",
"I_INVOICELIST",
"I_PARTNERFUNCTION"
],
"BASE":
[
"I_BILLINGDOCUMENTPARTNERBASIC"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More