P_SDDocumentCompletePartners_1

DDL: P_SDDOCUMENTCOMPLETEPARTNERS_1 Type: view BASIC
24 Fields 1 Data Sources

P_SDDocumentCompletePartners_1 is a Basic CDS View in SAP S/4HANA. It reads from 1 data source (vbpa) and exposes 24 fields with key fields SDDocument, SDDocumentItem, PartnerFunction.

Data Sources (1)

SourceAliasJoin Type
vbpa vbpa from

Annotations (11)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #NOT_REQUIRED view
AbapCatalog.sqlViewName PSDDOCCMPLTPART1 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
VDM.private true view
VDM.viewType #BASIC view

Fields (24)

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

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_SDDocumentCompletePartners_1.
-- 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_SDDocumentCompletePartners_1 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
;

Learn More