P_SDDocumentCompletePartners

Private view for SD Document Complete Partners | view: PSDDOCCMPLTPART | TRAN | Extraction: Not supported | Component: Partner determination
Tables used: VBPA, VBPA, CVI_CUST_CT_LINK, BUT000, CVI_CUST_LINK, CVI_VEND_LINK
Column Name Description
SDDocument Sales and Distribution Document Number
SDDocumentItem Item number of the SD document
PartnerFunction FK Partner Function
Column Name Description
Column Name Description
Column Name Description
Column Name Description
SDDocPartnerAddressRefType Address indicator Show values
AddressObjectType Address type (1=Organization, 2=Person, 3=Contact person) Show values
PartnerIsOneTimeAccount Indicator: Is the account a one-time account? Show values
CustIsPrcDetnRlvt Relevant for price determination ID Show values
CustomerIsRebateRelevant Indicator: Customer Is Rebate-Relevant Show values
VBPADataMigrationStatus SilentDataMigration: Status Material Ledger Table Conversion Show values
Column Name Description Domain name
Personnel Personnel Number PERNR
ContactPerson Number of Contact Person PARNR
AddressID Address ADRNR
BPRefAddressIDForDocSpcfcAddr BP Reference Address Number AD_ADDRNUM
VATRegistration VAT Registration Number STCEG
UnloadingPointName Unloading Point TEXT25
CustomerHierarchyLevel Level number within hierarchy NUM2
CustomerHierarchyFixedLevel Assignment to Hierarchy HZUOR
TransportZone Transportation zone to or from which the goods are delivered ZONE
Master Data Relations Join Conditions
Person Number
  • ?
  • ?
  • Client
  • Person Number
  • P_SDDOCUMENTCOMPLETEPARTNERS.[column in domain "AD_NATION"] == ADRP.NATION
  • P_SDDOCUMENTCOMPLETEPARTNERS.[column in domain "AD_DATE_FR"] == ADRP.DATE_FROM
  • P_SDDOCUMENTCOMPLETEPARTNERS.MANDT == ADRP.CLIENT
  • P_SDDOCUMENTCOMPLETEPARTNERS.ADDRESSPERSONID == ADRP.PERSNUMBER
Address Determination in Document
  • Client
  • Address Determination in Document
  • P_SDDOCUMENTCOMPLETEPARTNERS.MANDT == TB008S.CLIENT
  • P_SDDOCUMENTCOMPLETEPARTNERS.BPADDRDETERMINATIONTRANSACTION == TB008S.OPERATION
Country/Region Key
  • Country/Region Key
  • Client
  • P_SDDOCUMENTCOMPLETEPARTNERS.COUNTRYCODE == T005.LAND1
  • P_SDDOCUMENTCOMPLETEPARTNERS.MANDT == T005.MANDT
Customer - Document Customer
  • Client
  • Customer Number
  • P_SDDOCUMENTCOMPLETEPARTNERS.MANDT == KNA1.MANDT
  • P_SDDOCUMENTCOMPLETEPARTNERS.CUSTOMER == KNA1.KUNNR
Customer hierarchy type
  • Client
  • Customer hierarchy type
  • P_SDDOCUMENTCOMPLETEPARTNERS.MANDT == THIT.MANDT
  • P_SDDOCUMENTCOMPLETEPARTNERS.CUSTOMERHIERARCHYTYPE == THIT.HITYP
Partner function - Document partner
  • Partner Function
  • Client
  • P_SDDOCUMENTCOMPLETEPARTNERS.PARTNERFUNCTION == TPAR.PARVW
  • P_SDDOCUMENTCOMPLETEPARTNERS.MANDT == TPAR.MANDT
Business Partner Number
  • Business Partner Number
  • Client
  • P_SDDOCUMENTCOMPLETEPARTNERS.REFERENCEBUSINESSPARTNER == BUT000.PARTNER
  • P_SDDOCUMENTCOMPLETEPARTNERS.MANDT == BUT000.CLIENT
Vendor - Document Vendor
  • Account Number of Supplier
  • Client
  • P_SDDOCUMENTCOMPLETEPARTNERS.SUPPLIER == LFA1.LIFNR
  • P_SDDOCUMENTCOMPLETEPARTNERS.MANDT == LFA1.MANDT