I_SalesDocumentBusinessPartner

Sales Document Business Partner | view: ISDSLSDOCBP | TRAN | Extraction: Not supported | Component: Sales
Tables used: VBAK, VBPA, VBPA, ADR6, ADR3, ADRP, ADR2, ADCP, ADRC, CVI_CUST_CT_LINK, BUT0ID, BUT000, ADRP, KNVK, CVI_CUST_LINK, CVI_VEND_LINK, ADCP, ADR2, ADR3, ADR6, BUT000, MOM052
Column Name Description
SalesDocument Sales Document
PartnerFunction FK Partner Function
Column Name Description
Column Name Description
Column Name Description
Column Name Description
AddressObjectType Address type (1=Organization, 2=Person, 3=Contact person) Show values
SDDocPartnerAddressRefType Address indicator Show values
Column Name Description Domain name
Personnel Personnel Number PERNR
ContactPerson Number of Contact Person PARNR
Partner Customer Number KUNNR
BusinessPartnerName1 Name 1 TEXT40
BusinessPartnerName2 Name 2 TEXT40
BusinessPartnerName3 Name 3 TEXT40
BusinessPartnerName4 Name 4 TEXT40
FullName Full Name of Person TEXT80
PostalCode City postal code CHAR10
CityName City TEXT40
DistrictName District TEXT40
StreetName Street TEXT60
StreetPrefixName1 Street 2 TEXT40
StreetPrefixName2 Street 3 TEXT40
StreetSuffixName1 Street 4 TEXT40
StreetSuffixName2 Street 5 TEXT40
HouseNumber House Number TEXT10
TaxJurisdiction Tax Jurisdiction AD_TXJCD
VATRegistration VAT Registration Number STCEG
UnloadingPointName Unloading Point TEXT25
POBox PO Box CHAR10
POBoxPostalCode PO Box Postal Code CHAR10
PhoneNumber Telephone no.: dialling code+number CHAR30
PhoneNumberExtension Telephone no.: Extension CHAR10
InternationalPhoneNumber Complete Number: Dialling Code+Number+Extension CHAR30
InternationalMobilePhoneNumber Complete Number: Dialling Code+Number+Extension CHAR30
InternationalFaxNumber Fax number: dialling code+number CHAR30
FaxNumberExtension Fax no.: Extension CHAR10
EmailAddress E-Mail Address AD_SMTPADR
AddressID Address ADRNR
BPRefAddressIDForDocSpcfcAddr BP Reference Address Number AD_ADDRNUM
Master Data Relations Join Conditions
Person Number
  • ?
  • ?
  • Client
  • Person Number
  • I_SALESDOCUMENTBUSINESSPARTNER.[column in domain "AD_NATION"] == ADRP.NATION
  • I_SALESDOCUMENTBUSINESSPARTNER.[column in domain "AD_DATE_FR"] == ADRP.DATE_FROM
  • I_SALESDOCUMENTBUSINESSPARTNER.MANDT == ADRP.CLIENT
  • I_SALESDOCUMENTBUSINESSPARTNER.ADDRESSPERSONID == ADRP.PERSNUMBER
Address Determination in Document
  • Client
  • Address Determination in Document
  • I_SALESDOCUMENTBUSINESSPARTNER.MANDT == TB008S.CLIENT
  • I_SALESDOCUMENTBUSINESSPARTNER.BPADDRDETERMINATIONTRANSACTION == TB008S.OPERATION
Language I_SALESDOCUMENTBUSINESSPARTNER.CORRESPONDENCELANGUAGE == T002.SPRAS
Country key
  • Client
  • Country/Region Key
  • I_SALESDOCUMENTBUSINESSPARTNER.MANDT == T005.MANDT
  • I_SALESDOCUMENTBUSINESSPARTNER.COUNTRY == T005.LAND1
Customer - Document Customer
  • Client
  • Customer Number
  • I_SALESDOCUMENTBUSINESSPARTNER.MANDT == KNA1.MANDT
  • I_SALESDOCUMENTBUSINESSPARTNER.CUSTOMER == KNA1.KUNNR
Form-of-Address Key
  • Client
  • Form-of-Address Key
  • I_SALESDOCUMENTBUSINESSPARTNER.MANDT == TSAD3.CLIENT
  • I_SALESDOCUMENTBUSINESSPARTNER.FORMOFADDRESS == TSAD3.TITLE
Partner function - Document partner
  • Partner Function
  • Client
  • I_SALESDOCUMENTBUSINESSPARTNER.PARTNERFUNCTION == TPAR.PARVW
  • I_SALESDOCUMENTBUSINESSPARTNER.MANDT == TPAR.MANDT
Business Partner Number
  • Business Partner Number
  • Client
  • I_SALESDOCUMENTBUSINESSPARTNER.REFERENCEBUSINESSPARTNER == BUT000.PARTNER
  • I_SALESDOCUMENTBUSINESSPARTNER.MANDT == BUT000.CLIENT
Region code
  • Region (State, Province, County)
  • Client
  • Country/Region Key
  • I_SALESDOCUMENTBUSINESSPARTNER.REGION == T005S.BLAND
  • I_SALESDOCUMENTBUSINESSPARTNER.MANDT == T005S.MANDT
  • I_SALESDOCUMENTBUSINESSPARTNER.COUNTRY == T005S.LAND1
Vendor - Document Vendor
  • Client
  • Account Number of Supplier
  • I_SALESDOCUMENTBUSINESSPARTNER.MANDT == LFA1.MANDT
  • I_SALESDOCUMENTBUSINESSPARTNER.SUPPLIER == LFA1.LIFNR
Transportation zone to or from which the goods are delivered
  • Client
  • Country/Region Key
  • Transportation zone to or from which the goods are delivered
  • I_SALESDOCUMENTBUSINESSPARTNER.MANDT == TZONE.MANDT
  • I_SALESDOCUMENTBUSINESSPARTNER.COUNTRY == TZONE.LAND1
  • I_SALESDOCUMENTBUSINESSPARTNER.TRANSPORTZONE == TZONE.ZONE1