P_SalesDocItemCompletePartner

DDL: P_SALESDOCITEMCOMPLETEPARTNER Type: view COMPOSITE
49 Fields 2 Data Sources 1 Associations

P_SalesDocItemCompletePartner is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (P_SalesDocItemInheritedPartner, I_SalesDocumentItemPartner) and exposes 49 fields with key fields SalesDocument, SalesDocumentItem, PartnerFunction, SalesDocumentItem, PartnerFunction. It has 1 association to related views.

Data Sources (2)

SourceAliasJoin Type
P_SalesDocItemInheritedPartner InheritedPartner union_all
I_SalesDocumentItemPartner ItemPartner from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_ContactPerson _ContactPerson $projection.ContactPerson = _ContactPerson.ContactPerson

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName PSDOCITMCMPLPT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
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 #PRIVILEGED_ONLY view
Metadata.ignorePropagatedAnnotations true view

Fields (49)

KeyFieldSource TableSource FieldDescription
KEY SalesDocument I_SalesDocumentItemPartner SalesDocument SD Document
KEY SalesDocumentItem I_SalesDocumentItemPartner SalesDocumentItem Sales Document Item
KEY PartnerFunction I_SalesDocumentItemPartner PartnerFunction Partner Functn
Customer I_SalesDocumentItemPartner Customer Sold-to Party
Supplier I_SalesDocumentItemPartner Supplier Supplier
ContactPerson I_SalesDocumentItemPartner ContactPerson Contact Person Key
ReferenceBusinessPartner I_SalesDocumentItemPartner ReferenceBusinessPartner Busn. Partner
Personnel I_SalesDocumentItemPartner Personnel Personnel No.
AddressID I_SalesDocumentItemPartner AddressID Ship-to address
AddressPersonID I_SalesDocumentItemPartner AddressPersonID Person Number
AddressObjectType I_SalesDocumentItemPartner AddressObjectType Address Type
SDDocPartnerAddressRefType I_SalesDocumentItemPartner SDDocPartnerAddressRefType Adress ind.
BPAddrDeterminationTransaction I_SalesDocumentItemPartner BPAddrDeterminationTransaction Address Detn
BPRefAddressIDForDocSpcfcAddr I_SalesDocumentItemPartner BPRefAddressIDForDocSpcfcAddr BP Ref. Address Num.
VATRegistration I_SalesDocumentItemPartner VATRegistration VAT Registration No.
UnloadingPointName I_SalesDocumentItemPartner UnloadingPointName Unloading Point Name
PartnerIsSpecificForSDDocItem
_Address I_SalesDocumentItemPartner _Address
_DfltAddrRprstn I_SalesDocumentItemPartner _DfltAddrRprstn
_BusinessPartnerAddress I_SalesDocumentItemPartner _BusinessPartnerAddress
_BPRefAddressForDocSpcfcAddr I_SalesDocumentItemPartner _BPRefAddressForDocSpcfcAddr
_SalesDocument I_SalesDocumentItemPartner _SalesDocument
_SalesDocumentItem I_SalesDocumentItemPartner _SalesDocumentItem
_PartnerFunction I_SalesDocumentItemPartner _PartnerFunction
SalesDocument SD Document
KEY SalesDocumentItem P_SalesDocItemInheritedPartner SalesDocumentItem Sales Document Item
KEY PartnerFunction P_SalesDocItemInheritedPartner PartnerFunction Partner Functn
Customer P_SalesDocItemInheritedPartner Customer Sold-to Party
Supplier P_SalesDocItemInheritedPartner Supplier Supplier
ContactPerson P_SalesDocItemInheritedPartner ContactPerson Contact Person Key
ReferenceBusinessPartner P_SalesDocItemInheritedPartner ReferenceBusinessPartner Busn. Partner
Personnel P_SalesDocItemInheritedPartner Personnel Personnel No.
AddressID P_SalesDocItemInheritedPartner AddressID Ship-to address
AddressPersonID P_SalesDocItemInheritedPartner AddressPersonID Person Number
AddressObjectType P_SalesDocItemInheritedPartner AddressObjectType Address Type
SDDocPartnerAddressRefType P_SalesDocItemInheritedPartner SDDocPartnerAddressRefType Adress ind.
BPAddrDeterminationTransaction P_SalesDocItemInheritedPartner BPAddrDeterminationTransaction Address Detn
BPRefAddressIDForDocSpcfcAddr P_SalesDocItemInheritedPartner BPRefAddressIDForDocSpcfcAddr BP Ref. Address Num.
VATRegistration P_SalesDocItemInheritedPartner VATRegistration VAT Registration No.
UnloadingPointName P_SalesDocItemInheritedPartner UnloadingPointName Unloading Point Name
PartnerIsSpecificForSDDocItem
_Address P_SalesDocItemInheritedPartner _Address
_DfltAddrRprstn P_SalesDocItemInheritedPartner _DfltAddrRprstn
_BusinessPartnerAddress P_SalesDocItemInheritedPartner _BusinessPartnerAddress
_BPRefAddressForDocSpcfcAddr P_SalesDocItemInheritedPartner _BPRefAddressForDocSpcfcAddr
_SalesDocument P_SalesDocItemInheritedPartner _SalesDocument
_SalesDocumentItem _SalesDocumentItem
_PartnerFunction P_SalesDocItemInheritedPartner _PartnerFunction
_ContactPerson P_SalesDocItemInheritedPartner _ContactPerson

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_SalesDocItemCompletePartner.
-- 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_SalesDocItemCompletePartner AS
SELECT
  ItemPartner.SalesDocument AS SalesDocument,
  ItemPartner.SalesDocumentItem AS SalesDocumentItem,
  ItemPartner.PartnerFunction AS PartnerFunction,
  ItemPartner.Customer AS Customer,
  ItemPartner.Supplier AS Supplier,
  ItemPartner.ContactPerson AS ContactPerson,
  ItemPartner.ReferenceBusinessPartner AS ReferenceBusinessPartner,
  ItemPartner.Personnel AS Personnel,
  ItemPartner.AddressID AS AddressID,
  ItemPartner.AddressPersonID AS AddressPersonID,
  ItemPartner.AddressObjectType AS AddressObjectType,
  ItemPartner.SDDocPartnerAddressRefType AS SDDocPartnerAddressRefType,
  ItemPartner.BPAddrDeterminationTransaction AS BPAddrDeterminationTransaction,
  ItemPartner.BPRefAddressIDForDocSpcfcAddr AS BPRefAddressIDForDocSpcfcAddr,
  ItemPartner.VATRegistration AS VATRegistration,
  ItemPartner.UnloadingPointName AS UnloadingPointName,
  cast ( 'X' as sd_partner_item_ind) AS PartnerIsSpecificForSDDocItem,
  ItemPartner._Address AS _Address,
  ItemPartner._DfltAddrRprstn AS _DfltAddrRprstn,
  ItemPartner._BusinessPartnerAddress AS _BusinessPartnerAddress,
  ItemPartner._BPRefAddressForDocSpcfcAddr AS _BPRefAddressForDocSpcfcAddr,
  ItemPartner._SalesDocument AS _SalesDocument,
  ItemPartner._SalesDocumentItem AS _SalesDocumentItem,
  ItemPartner._PartnerFunction AS _PartnerFunction,
  InheritedPartner._ContactPerson AS _ContactPerson
FROM I_SalesDocumentItemPartner AS ItemPartner
LEFT OUTER JOIN I_ContactPerson AS _ContactPerson ON ContactPerson = _ContactPerson.ContactPerson  -- association [0..1]
-- UNION ALL with additional select branch(es): P_SalesDocItemInheritedPartner
;

Learn More