I_SDDocumentCompletePartners

DDL: I_SDDOCUMENTCOMPLETEPARTNERS Type: view BASIC Package: VDM_SD_BF_PD
32 Fields 1 Data Sources 8 Associations

SD Document Complete Partners

I_SDDocumentCompletePartners is a Basic CDS View that provides data about "SD Document Complete Partners" in SAP S/4HANA. It reads from 1 data source (vbpa) and exposes 32 fields with key fields SDDocument, SDDocumentItem, PartnerFunction. It has 8 associations to related views. Part of development package VDM_SD_BF_PD.

Data Sources (1)

SourceAliasJoin Type
vbpa vbpa from

Associations (8)

CardinalityTargetAliasCondition
[0..1] I_PartnerFunction _PartnerFunction $projection.PartnerFunction = _PartnerFunction.PartnerFunction
[0..1] I_ContactPerson _ContactPerson $projection.ContactPerson = _ContactPerson.ContactPerson
[0..1] I_Address _Address $projection.AddressID = _Address.AddressID
[0..1] I_Address_2 _DfltAddrRprstn $projection.AddressID = _DfltAddrRprstn.AddressID and $projection.AddressPersonID = _DfltAddrRprstn.AddressPersonID and _DfltAddrRprstn.AddressRepresentationCode is initial
[0..1] I_BusPartAddress _BusinessPartnerAddress $projection.ReferenceBusinessPartner = _BusinessPartnerAddress.BusinessPartner and $projection.AddressID = _BusinessPartnerAddress.AddressID and $projection.SDDocPartnerAddressRefType = 'H'
[0..1] I_BusPartAddress _BPRefAddressForDocSpcfcAddr $projection.ReferenceBusinessPartner = _BPRefAddressForDocSpcfcAddr.BusinessPartner and $projection.BPRefAddressIDForDocSpcfcAddr = _BPRefAddressForDocSpcfcAddr.AddressID
[0..1] I_PersonWorkplaceAddress _PersonWorkplaceAddrDfltRprstn $projection.AddressID = _PersonWorkplaceAddrDfltRprstn.AddressID and $projection.AddressPersonID = _PersonWorkplaceAddrDfltRprstn.AddressPersonID and _PersonWorkplaceAddrDfltRprstn.AddressRepresentationCode is initial
[1..1] I_WorkforcePersonMappings_1 _WorkforcePersonMappings $projection.Personnel = _WorkforcePersonMappings.WorkAssignment and $projection.Personnel is not initial

Annotations (11)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label SD Document Complete Partners view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #NOT_REQUIRED view
AbapCatalog.sqlViewName ISDDOCCMPLTPART view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XL view

Fields (32)

KeyFieldSource TableSource FieldDescription
KEY SDDocument vbpa vbeln SD Sched. Agmt
KEY SDDocumentItem vbpa posnr WBS Element
KEY PartnerFunction vbpa parvw Task Processor
Customer vbpa kunnr Stock customer
Supplier vbpa lifnr Vendor no.
Personnel vbpa pernr Personnel no.
ContactPerson vbpa parnr Responsible
ReferenceBusinessPartner vbpa assigned_bp Busn. Partner
AddressID vbpa adrnr Sold-To Address
AddressPersonID vbpa adrnp Person Number
SDDocPartnerAddressRefType vbpa adrda Adress ind.
AddressObjectType vbpa addr_type Address Type
BPAddrDeterminationTransaction vbpa addr_operation Transaction
BPRefAddressIDForDocSpcfcAddr vbpa bp_ref_adrnr BP Ref. Address Num.
PartnerIsOneTimeAccount vbpa xcpdk One-time acct
VATRegistration vbpa stceg VAT Reg. No.
UnloadingPointName vbpa ablad Unloading Point
CountryCode vbpa land1 Trip Ctry/Reg
CustomerHierarchyType vbpa hityp Hierarchy type
CustIsPrcDetnRlvt vbpa prfre Price determin.
CustomerIsRebateRelevant vbpa bokre Rebate
CustomerHierarchyLevel vbpa histunr Hierarchy level
CustomerHierarchyFixedLevel vbpa hzuor Hier.assignment
TransportZone vbpa lzone Zone
_PartnerFunction _PartnerFunction
_ContactPerson _ContactPerson
_WorkforcePersonMappings _WorkforcePersonMappings
_Address _Address
_DfltAddrRprstn _DfltAddrRprstn
_BusinessPartnerAddress _BusinessPartnerAddress
_PersonWorkplaceAddrDfltRprstn _PersonWorkplaceAddrDfltRprstn
_BPRefAddressForDocSpcfcAddr _BPRefAddressForDocSpcfcAddr

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_SDDocumentCompletePartners.
-- 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_SDDocumentCompletePartners AS
SELECT
  vbpa.vbeln AS SDDocument,
  vbpa.posnr AS SDDocumentItem,
  vbpa.parvw AS PartnerFunction,
  vbpa.kunnr AS Customer,
  vbpa.lifnr AS Supplier,
  vbpa.pernr AS Personnel,
  vbpa.parnr AS ContactPerson,
  vbpa.assigned_bp AS ReferenceBusinessPartner,
  vbpa.adrnr AS AddressID,
  vbpa.adrnp AS AddressPersonID,
  vbpa.adrda AS SDDocPartnerAddressRefType,
  vbpa.addr_type AS AddressObjectType,
  vbpa.addr_operation AS BPAddrDeterminationTransaction,
  vbpa.bp_ref_adrnr AS BPRefAddressIDForDocSpcfcAddr,
  vbpa.xcpdk AS PartnerIsOneTimeAccount,
  vbpa.stceg AS VATRegistration,
  vbpa.ablad AS UnloadingPointName,
  vbpa.land1 AS CountryCode,
  vbpa.hityp AS CustomerHierarchyType,
  vbpa.prfre AS CustIsPrcDetnRlvt,
  vbpa.bokre AS CustomerIsRebateRelevant,
  vbpa.histunr AS CustomerHierarchyLevel,
  vbpa.hzuor AS CustomerHierarchyFixedLevel,
  vbpa.lzone AS TransportZone
FROM vbpa
LEFT OUTER JOIN I_PartnerFunction AS _PartnerFunction ON PartnerFunction = _PartnerFunction.PartnerFunction  -- association [0..1]
LEFT OUTER JOIN I_ContactPerson AS _ContactPerson ON ContactPerson = _ContactPerson.ContactPerson  -- association [0..1]
LEFT OUTER JOIN I_Address AS _Address ON AddressID = _Address.AddressID  -- association [0..1]
LEFT OUTER JOIN I_Address_2 AS _DfltAddrRprstn ON AddressID = _DfltAddrRprstn.AddressID AND AddressPersonID = _DfltAddrRprstn.AddressPersonID AND _DfltAddrRprstn.AddressRepresentationCode is initial  -- association [0..1]
LEFT OUTER JOIN I_BusPartAddress AS _BusinessPartnerAddress ON ReferenceBusinessPartner = _BusinessPartnerAddress.BusinessPartner AND AddressID = _BusinessPartnerAddress.AddressID AND SDDocPartnerAddressRefType = 'H'  -- association [0..1]
LEFT OUTER JOIN I_BusPartAddress AS _BPRefAddressForDocSpcfcAddr ON ReferenceBusinessPartner = _BPRefAddressForDocSpcfcAddr.BusinessPartner AND BPRefAddressIDForDocSpcfcAddr = _BPRefAddressForDocSpcfcAddr.AddressID  -- association [0..1]
LEFT OUTER JOIN I_PersonWorkplaceAddress AS _PersonWorkplaceAddrDfltRprstn ON AddressID = _PersonWorkplaceAddrDfltRprstn.AddressID AND AddressPersonID = _PersonWorkplaceAddrDfltRprstn.AddressPersonID AND _PersonWorkplaceAddrDfltRprstn.AddressRepresentationCode is initial  -- association [0..1]
LEFT OUTER JOIN I_WorkforcePersonMappings_1 AS _WorkforcePersonMappings ON Personnel = _WorkforcePersonMappings.WorkAssignment AND Personnel is not initial  -- association [1..1]
;

Learn More