P_SDDocumentCompletePartners_1

Private view for SD Document Complete Partners, branch 1 | view: PSDDOCCMPLTPART1 | TRAN | Extraction: Not supported | Component: Partner determination
Tables used: VBPA
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
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
  • Person Number
  • Client
  • ?
  • ?
  • P_SDDOCUMENTCOMPLETEPARTNERS_1.ADDRESSPERSONID == ADRP.PERSNUMBER
  • P_SDDOCUMENTCOMPLETEPARTNERS_1.MANDT == ADRP.CLIENT
  • P_SDDOCUMENTCOMPLETEPARTNERS_1.[column in domain "AD_NATION"] == ADRP.NATION
  • P_SDDOCUMENTCOMPLETEPARTNERS_1.[column in domain "AD_DATE_FR"] == ADRP.DATE_FROM
Address Determination in Document
  • Address Determination in Document
  • Client
  • P_SDDOCUMENTCOMPLETEPARTNERS_1.BPADDRDETERMINATIONTRANSACTION == TB008S.OPERATION
  • P_SDDOCUMENTCOMPLETEPARTNERS_1.MANDT == TB008S.CLIENT
Country/Region Key
  • Client
  • Country/Region Key
  • P_SDDOCUMENTCOMPLETEPARTNERS_1.MANDT == T005.MANDT
  • P_SDDOCUMENTCOMPLETEPARTNERS_1.COUNTRYCODE == T005.LAND1
Customer - Document Customer
  • Customer Number
  • Client
  • P_SDDOCUMENTCOMPLETEPARTNERS_1.CUSTOMER == KNA1.KUNNR
  • P_SDDOCUMENTCOMPLETEPARTNERS_1.MANDT == KNA1.MANDT
Customer hierarchy type
  • Client
  • Customer hierarchy type
  • P_SDDOCUMENTCOMPLETEPARTNERS_1.MANDT == THIT.MANDT
  • P_SDDOCUMENTCOMPLETEPARTNERS_1.CUSTOMERHIERARCHYTYPE == THIT.HITYP
Partner function - Document partner
  • Client
  • Partner Function
  • P_SDDOCUMENTCOMPLETEPARTNERS_1.MANDT == TPAR.MANDT
  • P_SDDOCUMENTCOMPLETEPARTNERS_1.PARTNERFUNCTION == TPAR.PARVW
Business Partner Number
  • Client
  • Business Partner Number
  • P_SDDOCUMENTCOMPLETEPARTNERS_1.MANDT == BUT000.CLIENT
  • P_SDDOCUMENTCOMPLETEPARTNERS_1.REFERENCEBUSINESSPARTNER == BUT000.PARTNER
Vendor - Document Vendor
  • Client
  • Account Number of Supplier
  • P_SDDOCUMENTCOMPLETEPARTNERS_1.MANDT == LFA1.MANDT
  • P_SDDOCUMENTCOMPLETEPARTNERS_1.SUPPLIER == LFA1.LIFNR