I_BillingDocItemPartner

DDL: I_BILLINGDOCITEMPARTNER SQL: ISDBILDOCITPT Type: view COMPOSITE Package: VDM_SD_BIL_BD
19 Fields 1 Data Sources 2 Associations

Billing Document Item Partner

I_BillingDocItemPartner (Composite)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Public Edition with built-in and side-by-side extension capabilities.

Sales

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. Part of development package VDM_SD_BIL_BD.

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 →

SAP API Hub

CategoryComposite
StateC1
Line of BusinessSales
Application ComponentSD-BIL-BD-2CL
CapabilitiesData Source in SQL Select,Data Source for Defining CDS Entities,Association Target for Defining CDS Entities
Extensible (Key User)No
Extensible (Developer)No
Release State (Key User)Released
Release State (Developer)Released
PackageSales for SAP S/4HANA Cloud Public Edition
Description <p>This CDS view provides the prerequisites for answering questions about billing document partners at item level. Example business questions could include:</p> <ul> <li> <p>What are the partner functions specified in a given billing document item?</p> </li> <li> <p>Who is the customer or contact person for a given billing document item?</p> </li> <li> <p>What is the address of a partner in a given billing document item?</p> </li> </ul>

Documentation

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

KeyFieldSource TableSource FieldDescription
KEY BillingDocument I_BillingDocItemPartnerBasic BillingDocument Billing Document
KEY BillingDocumentItem I_BillingDocItemPartnerBasic BillingDocumentItem Billing Item
KEY PartnerFunction I_BillingDocItemPartnerBasic PartnerFunction Partner Function
Customer I_BillingDocItemPartnerBasic Customer Customer Number
Supplier I_BillingDocItemPartnerBasic Supplier Account Number of Supplier
Personnel I_BillingDocItemPartnerBasic Personnel Personnel Number
AddressID I_BillingDocItemPartnerBasic AddressID Ship-to address
ContactPerson I_BillingDocItemPartnerBasic ContactPerson Number of Contact Person
AddressPersonID I_BillingDocItemPartnerBasic AddressPersonID Person Number
ReferenceBusinessPartner I_BillingDocItemPartnerBasic ReferenceBusinessPartner Business Partner Number
BPRefAddressIDForDocSpcfcAddr I_BillingDocItemPartnerBasic BPRefAddressIDForDocSpcfcAddr BP Reference Address Number
SDDocPartnerAddressRefType I_BillingDocItemPartnerBasic SDDocPartnerAddressRefType Address indicator
_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.
-- SQL view name: ISDBILDOCITPT

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