P_SalesDocItemInheritedPartner

DDL: P_SALESDOCITEMINHERITEDPARTNER Type: view COMPOSITE Package: VDM_SD_SLS
25 Fields 3 Data Sources

Inherited Partners of Sales Document

P_SalesDocItemInheritedPartner is a Composite CDS View that provides data about "Inherited Partners of Sales Document" in SAP S/4HANA. It reads from 3 data sources (I_SalesDocumentItem, I_SalesDocumentItemPartner, I_SalesDocumentPartner) and exposes 25 fields with key fields SalesDocument, SalesDocumentItem, PartnerFunction. Part of development package VDM_SD_SLS.

Data Sources (3)

SourceAliasJoin Type
I_SalesDocumentItem _Item from
I_SalesDocumentItemPartner _ItemPartner left_outer
I_SalesDocumentPartner _Partner inner

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PSLSDOCITMINHPT 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 #NOT_REQUIRED view

Fields (25)

KeyFieldSource TableSource FieldDescription
KEY SalesDocument I_SalesDocumentPartner SalesDocument SD Document
KEY SalesDocumentItem I_SalesDocumentItem SalesDocumentItem Sales Document Item
KEY PartnerFunction I_SalesDocumentPartner PartnerFunction Partner Functn
Customer I_SalesDocumentPartner Customer Sold-to Party
Supplier I_SalesDocumentPartner Supplier Supplier
ContactPerson I_SalesDocumentPartner ContactPerson Contact Person Key
ReferenceBusinessPartner I_SalesDocumentPartner ReferenceBusinessPartner Busn. Partner
Personnel I_SalesDocumentPartner Personnel Personnel No.
AddressID I_SalesDocumentPartner AddressID Ship-to address
AddressPersonID I_SalesDocumentPartner AddressPersonID Person Number
AddressObjectType I_SalesDocumentPartner AddressObjectType Address Type
SDDocPartnerAddressRefType I_SalesDocumentPartner SDDocPartnerAddressRefType Adress ind.
BPAddrDeterminationTransaction I_SalesDocumentPartner BPAddrDeterminationTransaction Address Detn
BPRefAddressIDForDocSpcfcAddr I_SalesDocumentPartner BPRefAddressIDForDocSpcfcAddr BP Ref. Address Num.
PartnerIsOneTimeAccount I_SalesDocumentPartner PartnerIsOneTimeAccount One-time acct
VATRegistration I_SalesDocumentPartner VATRegistration VAT Registration No.
UnloadingPointName I_SalesDocumentPartner UnloadingPointName Unloading Point Name
_Address I_SalesDocumentPartner _Address
_DfltAddrRprstn I_SalesDocumentPartner _DfltAddrRprstn
_BusinessPartnerAddress I_SalesDocumentPartner _BusinessPartnerAddress
_BPRefAddressForDocSpcfcAddr I_SalesDocumentPartner _BPRefAddressForDocSpcfcAddr
_SalesDocument I_SalesDocumentPartner _SalesDocument
_PartnerFunction I_SalesDocumentPartner _PartnerFunction
_WorkforcePersonMappings I_SalesDocumentPartner _WorkforcePersonMappings
_ContactPerson I_SalesDocumentPartner _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_SalesDocItemInheritedPartner.
-- 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_SalesDocItemInheritedPartner AS
SELECT
  _Partner.SalesDocument AS SalesDocument,
  _Item.SalesDocumentItem AS SalesDocumentItem,
  _Partner.PartnerFunction AS PartnerFunction,
  _Partner.Customer AS Customer,
  _Partner.Supplier AS Supplier,
  _Partner.ContactPerson AS ContactPerson,
  _Partner.ReferenceBusinessPartner AS ReferenceBusinessPartner,
  _Partner.Personnel AS Personnel,
  _Partner.AddressID AS AddressID,
  _Partner.AddressPersonID AS AddressPersonID,
  _Partner.AddressObjectType AS AddressObjectType,
  _Partner.SDDocPartnerAddressRefType AS SDDocPartnerAddressRefType,
  _Partner.BPAddrDeterminationTransaction AS BPAddrDeterminationTransaction,
  _Partner.BPRefAddressIDForDocSpcfcAddr AS BPRefAddressIDForDocSpcfcAddr,
  _Partner.PartnerIsOneTimeAccount AS PartnerIsOneTimeAccount,
  _Partner.VATRegistration AS VATRegistration,
  _Partner.UnloadingPointName AS UnloadingPointName,
  _Partner._Address AS _Address,
  _Partner._DfltAddrRprstn AS _DfltAddrRprstn,
  _Partner._BusinessPartnerAddress AS _BusinessPartnerAddress,
  _Partner._BPRefAddressForDocSpcfcAddr AS _BPRefAddressForDocSpcfcAddr,
  _Partner._SalesDocument AS _SalesDocument,
  _Partner._PartnerFunction AS _PartnerFunction,
  _Partner._WorkforcePersonMappings AS _WorkforcePersonMappings,
  _Partner._ContactPerson AS _ContactPerson
FROM I_SalesDocumentItem AS _Item
INNER JOIN I_SalesDocumentPartner AS _Partner ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_SalesDocumentItemPartner AS _ItemPartner ON /* join condition not captured in parsed metadata */
;

Learn More