I_BillingDocItemPartner

DDL: I_BILLINGDOCITEMPARTNER Type: view COMPOSITE
19 Fields 1 Data Sources 2 Associations

Billing Document Item Partner

I_BillingDocItemPartner is a Composite CDS View that provides data about "Billing Document Item Partner" in SAP S/4HANA. It reads from 1 data source (I_BillingDocItemPartnerBasic) and exposes 19 fields with key fields BillingDocument, BillingDocumentItem, PartnerFunction. It has 2 associations to related views.

SAP Help Documentation

CategoryBilling Documents
Purpose
This CDS view provides the prerequisites for answering questions about billing document partners at item level. Example business questions could include: What are the partner functions specified in a given billing document item? Who is the customer or contact person for a given billing document item? What is the address of a partner in a given billing document item? Note If you want to retrieve data from preliminary billing documents, billing document requests, or invoice lists, you can use the Billing Process Document view (see Related Information below). In addition, you can use the views Billing Document Request , Preliminary Billing Document , and Invoice List .

Prerequisites
Authorizations One of the following business catalogs must be assigned to a user to be able to use this CDS view: Sales - Billing Documents ( SAP_SD_BC_BIL_DOC_PC ) Sales - Billing Document Display ( SAP_SD_BC_BIL_DOC_DISPL_PC )

Structure
Business Objects This view is built on the following business objects: BillingDocument This view is based on the I_SDDocumentItemPartner view. You can use BillingDocument , BillingDocumentItem , and PartnerFunction . Main input parameters This view has no input parameters. Measures and attributes The view contains the following attributes: Billing document number ( BillingDocument ) Billing document item number ( BillingDocumentitem ) Partner function ( PartnerFunction ) Customer number ( Customer ) Supplier account number ( Supplier ) Personnel number ( Personnel ) Contact person number ( ContactPerson ) Partner address ( AdressID )

View on SAP Help Portal →

Data Sources (1)

SourceAliasJoin Type
I_BillingDocItemPartnerBasic Partner from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_BillingDocument _BillingDocument $projection.BillingDocument = _BillingDocument.BillingDocument
[1..1] I_BillingDocumentItem _Item $projection.BillingDocument = _Item.BillingDocument and $projection.BillingDocumentItem = _Item.BillingDocumentItem

Annotations (13)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Billing Document Item Partner view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
AbapCatalog.sqlViewName ISDBILDOCITPT 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 (19)

KeyFieldSource TableSource FieldDescription
KEY BillingDocument I_BillingDocItemPartnerBasic BillingDocument SD Document
KEY BillingDocumentItem I_BillingDocItemPartnerBasic BillingDocumentItem Item
KEY PartnerFunction I_BillingDocItemPartnerBasic PartnerFunction Partner Functn
Customer I_BillingDocItemPartnerBasic Customer Sold-to Party
Supplier I_BillingDocItemPartnerBasic Supplier Supplier
Personnel I_BillingDocItemPartnerBasic Personnel Personnel No.
AddressID I_BillingDocItemPartnerBasic AddressID Ship-to address
ContactPerson I_BillingDocItemPartnerBasic ContactPerson Contact Person Key
AddressPersonID I_BillingDocItemPartnerBasic AddressPersonID Person Number
ReferenceBusinessPartner I_BillingDocItemPartnerBasic ReferenceBusinessPartner Busn. Partner
BPRefAddressIDForDocSpcfcAddr I_BillingDocItemPartnerBasic BPRefAddressIDForDocSpcfcAddr BP Ref. Address Num.
SDDocPartnerAddressRefType I_BillingDocItemPartnerBasic SDDocPartnerAddressRefType Adress ind.
_BillingDocument _BillingDocument
_Item _Item
_PartnerFunction I_BillingDocItemPartnerBasic _PartnerFunction
_Address I_BillingDocItemPartnerBasic _Address
_BusinessPartnerAddress I_BillingDocItemPartnerBasic _BusinessPartnerAddress
_BPRefAddressForDocSpcfcAddr I_BillingDocItemPartnerBasic _BPRefAddressForDocSpcfcAddr
_DfltAddrRprstn I_BillingDocItemPartnerBasic _DfltAddrRprstn

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_BillingDocItemPartner.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW I_BillingDocItemPartner AS
SELECT
  Partner.BillingDocument AS BillingDocument,
  Partner.BillingDocumentItem AS BillingDocumentItem,
  Partner.PartnerFunction AS PartnerFunction,
  Partner.Customer AS Customer,
  Partner.Supplier AS Supplier,
  Partner.Personnel AS Personnel,
  Partner.AddressID AS AddressID,
  Partner.ContactPerson AS ContactPerson,
  Partner.AddressPersonID AS AddressPersonID,
  Partner.ReferenceBusinessPartner AS ReferenceBusinessPartner,
  Partner.BPRefAddressIDForDocSpcfcAddr AS BPRefAddressIDForDocSpcfcAddr,
  Partner.SDDocPartnerAddressRefType AS SDDocPartnerAddressRefType,
  Partner._PartnerFunction AS _PartnerFunction,
  Partner._Address AS _Address,
  Partner._BusinessPartnerAddress AS _BusinessPartnerAddress,
  Partner._BPRefAddressForDocSpcfcAddr AS _BPRefAddressForDocSpcfcAddr,
  Partner._DfltAddrRprstn AS _DfltAddrRprstn
FROM I_BillingDocItemPartnerBasic AS Partner
LEFT OUTER JOIN I_BillingDocument AS _BillingDocument ON BillingDocument = _BillingDocument.BillingDocument  -- association [1..1]
LEFT OUTER JOIN I_BillingDocumentItem AS _Item ON BillingDocument = _Item.BillingDocument AND BillingDocumentItem = _Item.BillingDocumentItem  -- association [1..1]
;

Learn More