I_SDDocumentPartner

DDL: I_SDDOCUMENTPARTNER Type: view BASIC Package: VDM_SD_BF_PD
32 Fields 1 Data Sources

SD Document Partner

I_SDDocumentPartner (Basic)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Public Edition with built-in and side-by-side extension capabilities.

Sales

I_SDDocumentPartner is a Basic CDS View that provides data about "SD Document Partner" in SAP S/4HANA. It reads from 1 data source (I_SDDocumentCompletePartners) and exposes 32 fields with key fields SDDocument, PartnerFunction. Part of development package VDM_SD_BF_PD.

SAP API Hub

CategoryBasic
StateC1
Line of BusinessSales
Application ComponentSD-BF-PD-2CL
CapabilitiesData Source in SQL Select,Data Source for Defining CDS Entities,Association Target for Defining CDS Entities
Extensible (Key User)No
Extensible (Developer)No
Release State (Key User)Released
Release State (Developer)Released
PackageSales for SAP S/4HANA Cloud Public Edition
Description <p>This CDS view provides the prerequisites for answering the following business questions:</p> <ul> <li> <p>What are the partner functions specified in a given SD document?</p> </li> <li> <p>Who is the customer, supplier, personnel, or contact person of a given SD document?</p> </li> <li> <p>What is the address of a partner in a given SD document?</p> </li> </ul>

Documentation

Data Sources (1)

SourceAliasJoin Type
I_SDDocumentCompletePartners I_SDDocumentCompletePartners from

Annotations (12)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label SD Document Partner view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
AccessControl.personalData.blocking #REQUIRED view
AbapCatalog.sqlViewName ISDDOCPARTNER 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
Metadata.ignorePropagatedAnnotations true view

Fields (32)

KeyFieldSource TableSource FieldDescription
KEY SDDocument SDDocument Sales and Distribution Document Number
KEY PartnerFunction PartnerFunction Partner Function
Customer Customer Customer Number
Supplier Supplier Account Number of Supplier
Personnel Personnel Personnel Number
ContactPerson ContactPerson Number of Contact Person
ReferenceBusinessPartner ReferenceBusinessPartner Business Partner Number
AddressID AddressID Ship-to address
AddressPersonID AddressPersonID Person Number
AddressObjectType AddressObjectType Address type (1=Organization, 2=Person, 3=Contact person)
SDDocPartnerAddressRefType SDDocPartnerAddressRefType Address indicator
BPAddrDeterminationTransaction BPAddrDeterminationTransaction Address Determination in Document
BPRefAddressIDForDocSpcfcAddr BPRefAddressIDForDocSpcfcAddr BP Reference Address Number
PartnerIsOneTimeAccount PartnerIsOneTimeAccount Indicator: Is the Account a One-Time Account?
SDDocPartnerAddrIsDocSpecific SDDocPartnerAddrIsDocSpecific Document-Specific Address
VATRegistration VATRegistration VAT Registration Number
UnloadingPointName UnloadingPointName Unloading Point Name
CountryCode CountryCode Country/Region Key
CustomerHierarchyType CustomerHierarchyType Customer hierarchy type
CustIsPrcDetnRlvt CustIsPrcDetnRlvt Relevant for price determination ID
CustomerIsRebateRelevant CustomerIsRebateRelevant Indicator: Customer Is Rebate-Relevant
CustomerHierarchyLevel CustomerHierarchyLevel Level number within hierarchy
CustomerHierarchyFixedLevel CustomerHierarchyFixedLevel Assignment to Hierarchy
TransportZone TransportZone Transportation zone to or from which the goods are delivered
_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_SDDocumentPartner.
-- 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_SDDocumentPartner AS
SELECT
  SDDocument,
  PartnerFunction,
  Customer,
  Supplier,
  Personnel,
  ContactPerson,
  ReferenceBusinessPartner,
  AddressID,
  AddressPersonID,
  AddressObjectType,
  SDDocPartnerAddressRefType,
  BPAddrDeterminationTransaction,
  BPRefAddressIDForDocSpcfcAddr,
  PartnerIsOneTimeAccount,
  SDDocPartnerAddrIsDocSpecific,
  VATRegistration,
  UnloadingPointName,
  CountryCode,
  CustomerHierarchyType,
  CustIsPrcDetnRlvt,
  CustomerIsRebateRelevant,
  CustomerHierarchyLevel,
  CustomerHierarchyFixedLevel,
  TransportZone
FROM I_SDDocumentCompletePartners
;

Learn More