I_BillingDocReqPartner

DDL: I_BILLINGDOCREQPARTNER Type: view COMPOSITE
17 Fields 1 Data Sources

Billing Document Request Partner

I_BillingDocReqPartner (Composite)

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

Sales

I_BillingDocReqPartner is a Composite CDS View that provides data about "Billing Document Request Partner" in SAP S/4HANA. It reads from 1 data source (I_BillingDocumentPartnerBasic) and exposes 17 fields with key fields BillingDocumentRequest, PartnerFunction.

SAP Help Documentation

CategoryBilling Document Requests
StatusReleased
Purpose
This CDS view provides the prerequisites for answering questions about billing document partners at header level. For more information about billing document requests, see Billing Document Requests . Example business questions could include: What are the partner functions specified in a given billing document request? Who is the customer, supplier, personnel, or contact person entered in a given billing document request? What is the address or phone number of a partner in a given billing document request?

Prerequisites
Authorizations Users who want to use this CDS view must have the following authorization objects assigned: V_VBRK_FKA (Billing: Authorization for Billing Types) V_VBRK_VKO (Billing: Authorization for Sales Organizations)

Structure
Object types This view relates to the following SAP object types: BillingDocumentRequest You can use the field BillingDocumentRequest (document number) as a key field. Measures and attributes Some important measures and attributes are: Billing document request ( BillingDocumentRequest ) Partner function ( PartnerFunction ) Customer number ( Customer ) Supplier account number ( Supplier ) Personnel number ( Personnel ) Number of contact person ( ContactPerson ) Partner address ( AdressID )

View on SAP Help Portal →

SAP API Hub

StateC1
Line of BusinessSales
Application ComponentSD-BIL-BDR
CapabilitiesData Source in SQL Select, Data Source for Defining CDS Entities, Association Target for Defining CDS Entities
PackageSales for SAP S/4HANA Cloud Private Edition
Description <p>This CDS view provides the prerequisites for answering questions about billing document partners at header level. For more information about billing document requests, see Billing Document Requests.</p> Example business questions could include:<ul> <li><p>What are the partner functions specified in a given billing document request?</p></li> <li><p>Who is the customer, supplier, personnel, or contact person entered in a given billing document request?</p></li> <li><p>What is the address or phone number of a partner in a given billing document request?</p></li> </ul>

Documentation

Data Sources (1)

SourceAliasJoin Type
I_BillingDocumentPartnerBasic Partner from

Annotations (12)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Billing Document Request Partner view
AccessControl.authorizationCheck #CHECK view
AbapCatalog.sqlViewName ISDBDRQPT 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 BillingDocumentRequest Billing Document Request
KEY PartnerFunction Partner Function
Customer I_BillingDocumentPartnerBasic Customer Customer Number
Supplier I_BillingDocumentPartnerBasic Supplier Account Number of Supplier
Personnel I_BillingDocumentPartnerBasic Personnel Personnel Number
AddressID I_BillingDocumentPartnerBasic AddressID Ship-to address
ContactPerson I_BillingDocumentPartnerBasic ContactPerson Number of Contact Person
AddressPersonID I_BillingDocumentPartnerBasic AddressPersonID Person Number
ReferenceBusinessPartner I_BillingDocumentPartnerBasic ReferenceBusinessPartner Business Partner Number
SDDocPartnerAddressRefType I_BillingDocumentPartnerBasic SDDocPartnerAddressRefType Address indicator
BPRefAddressIDForDocSpcfcAddr I_BillingDocumentPartnerBasic BPRefAddressIDForDocSpcfcAddr BP Reference Address Number
_BillingDocumentRequest _BillingDocumentRequest
_PartnerFunction I_BillingDocumentPartnerBasic _PartnerFunction
_Address I_BillingDocumentPartnerBasic _Address
_BusinessPartnerAddress I_BillingDocumentPartnerBasic _BusinessPartnerAddress
_BPRefAddressForDocSpcfcAddr I_BillingDocumentPartnerBasic _BPRefAddressForDocSpcfcAddr
_DfltAddrRprstn I_BillingDocumentPartnerBasic _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_BillingDocReqPartner.
-- 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_BillingDocReqPartner AS
SELECT
  cast( Partner.BillingDocument as vbeln_bdr preserving type ) AS BillingDocumentRequest,
  cast(Partner.PartnerFunction as parvw_unv preserving type ) 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.SDDocPartnerAddressRefType AS SDDocPartnerAddressRefType,
  Partner.BPRefAddressIDForDocSpcfcAddr AS BPRefAddressIDForDocSpcfcAddr,
  Partner._PartnerFunction AS _PartnerFunction,
  Partner._Address AS _Address,
  Partner._BusinessPartnerAddress AS _BusinessPartnerAddress,
  Partner._BPRefAddressForDocSpcfcAddr AS _BPRefAddressForDocSpcfcAddr,
  Partner._DfltAddrRprstn AS _DfltAddrRprstn
FROM I_BillingDocumentPartnerBasic AS Partner
;

Learn More