I_SalesDocItemBusinessPartner

Sales Document Item Business Partner | view: ISLSDOCITEMBP | TRAN | Extraction: Not supported | Component: Sales
Column Name Description
SalesDocument Sales Document
SalesDocumentItem Sales Document Item
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
Partner Customer Number KUNNR
FullName Full Name of Person TEXT80
InternationalPhoneNumber Complete Number: Dialling Code+Number+Extension CHAR30
InternationalMobilePhoneNumber Complete Number: Dialling Code+Number+Extension CHAR30
EmailAddress E-Mail Address AD_SMTPADR
Country Country/Region Key LAND1
Personnel Personnel Number PERNR
ContactPerson Number of Contact Person PARNR
AddressID Address ADRNR
BPRefAddressIDForDocSpcfcAddr BP Reference Address Number AD_ADDRNUM
Master Data Relations Join Conditions
Person Number
  • ?
  • ?
  • Person Number
  • Client
  • I_SALESDOCITEMBUSINESSPARTNER.[column in domain "AD_NATION"] == ADRP.NATION
  • I_SALESDOCITEMBUSINESSPARTNER.[column in domain "AD_DATE_FR"] == ADRP.DATE_FROM
  • I_SALESDOCITEMBUSINESSPARTNER.ADDRESSPERSONID == ADRP.PERSNUMBER
  • I_SALESDOCITEMBUSINESSPARTNER.MANDT == ADRP.CLIENT
Address Determination in Document
  • Address Determination in Document
  • Client
  • I_SALESDOCITEMBUSINESSPARTNER.BPADDRDETERMINATIONTRANSACTION == TB008S.OPERATION
  • I_SALESDOCITEMBUSINESSPARTNER.MANDT == TB008S.CLIENT
Customer - Document Customer
  • Customer Number
  • Client
  • I_SALESDOCITEMBUSINESSPARTNER.CUSTOMER == KNA1.KUNNR
  • I_SALESDOCITEMBUSINESSPARTNER.MANDT == KNA1.MANDT
Partner function - Document partner
  • Partner Function
  • Client
  • I_SALESDOCITEMBUSINESSPARTNER.PARTNERFUNCTION == TPAR.PARVW
  • I_SALESDOCITEMBUSINESSPARTNER.MANDT == TPAR.MANDT
Business Partner Number
  • Business Partner Number
  • Client
  • I_SALESDOCITEMBUSINESSPARTNER.REFERENCEBUSINESSPARTNER == BUT000.PARTNER
  • I_SALESDOCITEMBUSINESSPARTNER.MANDT == BUT000.CLIENT
Vendor - Document Vendor
  • Account Number of Supplier
  • Client
  • I_SALESDOCITEMBUSINESSPARTNER.SUPPLIER == LFA1.LIFNR
  • I_SALESDOCITEMBUSINESSPARTNER.MANDT == LFA1.MANDT