I_SalesDocItemCompletePartner

Sales Doc Item and Inherited Partners | view: ISLSDOCITMCMPLPT | 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
PartnerIsSpecificForSDDocItem Partner is specific for item Show values
Column Name Description Domain name
ContactPerson Number of Contact Person PARNR
Personnel Personnel Number PERNR
AddressID Address ADRNR
BPRefAddressIDForDocSpcfcAddr BP Reference Address Number AD_ADDRNUM
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
Master Data Relations Join Conditions
Person Number
  • ?
  • ?
  • Person Number
  • Client
  • I_SALESDOCITEMCOMPLETEPARTNER.[column in domain "AD_NATION"] == ADRP.NATION
  • I_SALESDOCITEMCOMPLETEPARTNER.[column in domain "AD_DATE_FR"] == ADRP.DATE_FROM
  • I_SALESDOCITEMCOMPLETEPARTNER.ADDRESSPERSONID == ADRP.PERSNUMBER
  • I_SALESDOCITEMCOMPLETEPARTNER.MANDT == ADRP.CLIENT
Address Determination in Document
  • Address Determination in Document
  • Client
  • I_SALESDOCITEMCOMPLETEPARTNER.BPADDRDETERMINATIONTRANSACTION == TB008S.OPERATION
  • I_SALESDOCITEMCOMPLETEPARTNER.MANDT == TB008S.CLIENT
Customer - Document Customer
  • Customer Number
  • Client
  • I_SALESDOCITEMCOMPLETEPARTNER.CUSTOMER == KNA1.KUNNR
  • I_SALESDOCITEMCOMPLETEPARTNER.MANDT == KNA1.MANDT
Partner function - Document partner
  • Partner Function
  • Client
  • I_SALESDOCITEMCOMPLETEPARTNER.PARTNERFUNCTION == TPAR.PARVW
  • I_SALESDOCITEMCOMPLETEPARTNER.MANDT == TPAR.MANDT
Business Partner Number
  • Business Partner Number
  • Client
  • I_SALESDOCITEMCOMPLETEPARTNER.REFERENCEBUSINESSPARTNER == BUT000.PARTNER
  • I_SALESDOCITEMCOMPLETEPARTNER.MANDT == BUT000.CLIENT
Vendor - Document Vendor
  • Account Number of Supplier
  • Client
  • I_SALESDOCITEMCOMPLETEPARTNER.SUPPLIER == LFA1.LIFNR
  • I_SALESDOCITEMCOMPLETEPARTNER.MANDT == LFA1.MANDT