I_InvoiceListPartner

DDL: I_INVOICELISTPARTNER Type: view_entity COMPOSITE Package: VDM_SD_BIL_IL

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 17 fields with key fields InvoiceList, PartnerFunction. It has 1 association to related views. Part of development package VDM_SD_BIL_IL.

Data Sources (1)

SourceAliasJoin Type
I_BillingDocumentPartnerBasic Partner from

Associations (1)

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

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
Analytics.technicalName ISDINVOICELISTPT view
EndUserText.label Invoice List Partner view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.representativeKey PartnerFunction view
ObjectModel.sapObjectNodeType.name InvoiceListPartner view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XL view
VDM.viewType #COMPOSITE view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY InvoiceList
KEY 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
BPRefAddressIDForDocSpcfcAddr I_BillingDocumentPartnerBasic BPRefAddressIDForDocSpcfcAddr
SDDocPartnerAddressRefType I_BillingDocumentPartnerBasic SDDocPartnerAddressRefType
_InvoiceList _InvoiceList
_PartnerFunction I_BillingDocumentPartnerBasic _PartnerFunction
_Address I_BillingDocumentPartnerBasic _Address
_DfltAddrRprstn I_BillingDocumentPartnerBasic _DfltAddrRprstn
_BusinessPartnerAddress I_BillingDocumentPartnerBasic _BusinessPartnerAddress
_BPRefAddressForDocSpcfcAddr I_BillingDocumentPartnerBasic _BPRefAddressForDocSpcfcAddr
@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.personalData.blocking: #('TRANSACTIONAL_DATA')
@AccessControl.privilegedAssociations: [ '_Address', '_DfltAddrRprstn' ]

@Analytics.technicalName: 'ISDINVOICELISTPT'

@EndUserText.label: 'Invoice List Partner'

@Metadata.ignorePropagatedAnnotations: true

@ObjectModel.representativeKey: 'PartnerFunction'
@ObjectModel.sapObjectNodeType.name: 'InvoiceListPartner'
@ObjectModel.supportedCapabilities: [ #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE, #CDS_MODELING_ASSOCIATION_TARGET ]
@ObjectModel.usageType: { dataClass: #TRANSACTIONAL, serviceQuality: #B, sizeCategory: #XL }

@VDM.viewType: #COMPOSITE

define view entity 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,

      @ObjectModel.foreignKey.association: '_PartnerFunction'
  key cast(Partner.PartnerFunction as parvw_unv preserving type ) as PartnerFunction,

      Partner.Customer,

      Partner.Supplier,

      Partner.Personnel,

      @ObjectModel.foreignKey.association: '_Address'
      Partner.AddressID,

      Partner.ContactPerson,

      Partner.AddressPersonID,

      Partner.ReferenceBusinessPartner,
      Partner.BPRefAddressIDForDocSpcfcAddr,
      Partner.SDDocPartnerAddressRefType,

      // Association

      @ObjectModel.association.type: [ #TO_COMPOSITION_PARENT, #TO_COMPOSITION_ROOT ]
      _InvoiceList,

      /* start suppress warning calculated_field_check */
      Partner._PartnerFunction,
      /* end suppress warning calculated_field_check */

      Partner._Address,
      Partner._DfltAddrRprstn,
      Partner._BusinessPartnerAddress,
      Partner._BPRefAddressForDocSpcfcAddr
}

where _InvoiceList.SDDocumentCategory = '3' or _InvoiceList.SDDocumentCategory = '4'