P_BillgProcDocItemCmpltPartner

DDL: P_BILLGPROCDOCITEMCMPLTPARTNER Type: view_entity COMPOSITE Package: VDM_SD_BIL
37 Fields 2 Data Sources 1 Associations

Union of item specific partners and inherited partners.

P_BillgProcDocItemCmpltPartner is a Composite CDS View that provides data about "Union of item specific partners and inherited partners." in SAP S/4HANA. It reads from 2 data sources (P_BillgProcDocItemInhtdPartner, I_BillingDocItemPartnerBasic) and exposes 37 fields with key fields BillingDocument, BillingDocumentItem, PartnerFunction, BillingDocumentItem, PartnerFunction. It has 1 association to related views. Part of development package VDM_SD_BIL.

Data Sources (2)

SourceAliasJoin Type
P_BillgProcDocItemInhtdPartner InheritedPartner union_all
I_BillingDocItemPartnerBasic ItemPartner from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_BillingDocumentItemBasic _BillingProcessDocumentItem $projection.BillingDocument = _BillingProcessDocumentItem.BillingDocument and $projection.BillingDocumentItem = _BillingProcessDocumentItem.BillingDocumentItem

Annotations (8)

NameValueLevelField
ObjectModel.representativeKey PartnerFunction view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XL view
VDM.private true view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view

Fields (37)

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
ContactPerson I_BillingDocItemPartnerBasic ContactPerson Contact Person Key
Personnel I_BillingDocItemPartnerBasic Personnel Personnel No.
ReferenceBusinessPartner I_BillingDocItemPartnerBasic ReferenceBusinessPartner Busn. Partner
AddressID I_BillingDocItemPartnerBasic AddressID Ship-to address
AddressPersonID I_BillingDocItemPartnerBasic AddressPersonID Person Number
AddressObjectType I_BillingDocItemPartnerBasic AddressObjectType Address Type
SDDocPartnerAddressRefType I_BillingDocItemPartnerBasic SDDocPartnerAddressRefType Adress ind.
VATRegistration I_BillingDocItemPartnerBasic VATRegistration VAT Registration No.
UnloadingPointName I_BillingDocItemPartnerBasic UnloadingPointName Unloading Point Name
PartnerIsSpecificForSDDocItem
_PartnerFunction I_BillingDocItemPartnerBasic _PartnerFunction
_DfltAddrRprstn I_BillingDocItemPartnerBasic _DfltAddrRprstn
_BillingProcessDocument _BillingDocumentBasic
BillingDocument SD Document
KEY BillingDocumentItem P_BillgProcDocItemInhtdPartner BillingDocumentItem Item
KEY PartnerFunction P_BillgProcDocItemInhtdPartner PartnerFunction Partner Functn
Customer P_BillgProcDocItemInhtdPartner Customer Sold-to Party
Supplier P_BillgProcDocItemInhtdPartner Supplier Supplier
ContactPerson P_BillgProcDocItemInhtdPartner ContactPerson Contact Person Key
Personnel P_BillgProcDocItemInhtdPartner Personnel Personnel No.
ReferenceBusinessPartner P_BillgProcDocItemInhtdPartner ReferenceBusinessPartner Busn. Partner
AddressID P_BillgProcDocItemInhtdPartner AddressID Ship-to address
AddressPersonID P_BillgProcDocItemInhtdPartner AddressPersonID Person Number
AddressObjectType P_BillgProcDocItemInhtdPartner AddressObjectType Address Type
SDDocPartnerAddressRefType P_BillgProcDocItemInhtdPartner SDDocPartnerAddressRefType Adress ind.
VATRegistration P_BillgProcDocItemInhtdPartner VATRegistration VAT Registration No.
UnloadingPointName P_BillgProcDocItemInhtdPartner UnloadingPointName Unloading Point Name
PartnerIsSpecificForSDDocItem
_PartnerFunction P_BillgProcDocItemInhtdPartner _PartnerFunction
_DfltAddrRprstn P_BillgProcDocItemInhtdPartner _DfltAddrRprstn
_BillingProcessDocument P_BillgProcDocItemInhtdPartner _BillingDocumentBasic
_BillingProcessDocumentItem _BillingProcessDocumentItem

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 P_BillgProcDocItemCmpltPartner.
-- 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 P_BillgProcDocItemCmpltPartner AS
SELECT
  ItemPartner.BillingDocument AS BillingDocument,
  ItemPartner.BillingDocumentItem AS BillingDocumentItem,
  ItemPartner.PartnerFunction AS PartnerFunction,
  ItemPartner.Customer AS Customer,
  ItemPartner.Supplier AS Supplier,
  ItemPartner.ContactPerson AS ContactPerson,
  ItemPartner.Personnel AS Personnel,
  ItemPartner.ReferenceBusinessPartner AS ReferenceBusinessPartner,
  ItemPartner.AddressID AS AddressID,
  ItemPartner.AddressPersonID AS AddressPersonID,
  ItemPartner.AddressObjectType AS AddressObjectType,
  ItemPartner.SDDocPartnerAddressRefType AS SDDocPartnerAddressRefType,
  ItemPartner.VATRegistration AS VATRegistration,
  ItemPartner.UnloadingPointName AS UnloadingPointName,
  cast('X' as sd_partner_item_ind preserving type) AS PartnerIsSpecificForSDDocItem,
  ItemPartner._PartnerFunction AS _PartnerFunction,
  ItemPartner._DfltAddrRprstn AS _DfltAddrRprstn,
  InheritedPartner._BillingDocumentBasic AS _BillingProcessDocument
FROM I_BillingDocItemPartnerBasic AS ItemPartner
LEFT OUTER JOIN I_BillingDocumentItemBasic AS _BillingProcessDocumentItem ON BillingDocument = _BillingProcessDocumentItem.BillingDocument AND BillingDocumentItem = _BillingProcessDocumentItem.BillingDocumentItem  -- association [1..1]
-- UNION ALL with additional select branch(es): P_BillgProcDocItemInhtdPartner
;

Learn More