I_CustProjSlsOrdItemPartner

Sales Order Item Partner for Cust Proj | view: ICUSTPROJSOIP | TRAN | Extraction: Not supported | Component: Project-Based Services in Sales Documents
Tables used: VBAP, VBKD, VEDA, VBAK, VBAK, VBAP, VBKD, VEDA, VBAP, /CPD/D_MP_HDR, /CPD/D_MP_ITEM, VBPA, VBPA, CVI_CUST_CT_LINK, BUT000, CVI_CUST_LINK, CVI_VEND_LINK
Column Name Description
CustomerProject Commercial Project ID
PartnerFunction FK Partner Function
SalesOrderItem Sales Order Item
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
SalesOrder Sales Order VBELN
BusinessPartner Customer Number KUNNR
AddressID Address ADRNR
BPRefAddressIDForDocSpcfcAddr BP Reference Address Number AD_ADDRNUM
Master Data Relations Join Conditions
Person Number
  • Person Number
  • ?
  • ?
  • Client
  • I_CUSTPROJSLSORDITEMPARTNER.ADDRESSPERSONID == ADRP.PERSNUMBER
  • I_CUSTPROJSLSORDITEMPARTNER.[column in domain "AD_NATION"] == ADRP.NATION
  • I_CUSTPROJSLSORDITEMPARTNER.[column in domain "AD_DATE_FR"] == ADRP.DATE_FROM
  • I_CUSTPROJSLSORDITEMPARTNER.MANDT == ADRP.CLIENT
Address Determination in Document
  • Address Determination in Document
  • Client
  • I_CUSTPROJSLSORDITEMPARTNER.BPADDRDETERMINATIONTRANSACTION == TB008S.OPERATION
  • I_CUSTPROJSLSORDITEMPARTNER.MANDT == TB008S.CLIENT
Distribution channel in order header
  • Sales Organization
  • Distribution Channel
  • Client
  • I_CUSTPROJSLSORDITEMPARTNER.SALESORGANIZATION == TVKOV.VKORG
  • I_CUSTPROJSLSORDITEMPARTNER.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
  • I_CUSTPROJSLSORDITEMPARTNER.MANDT == TVKOV.MANDT
Division in order header
  • Division
  • Sales Organization
  • Distribution Channel
  • Client
  • I_CUSTPROJSLSORDITEMPARTNER.ORGANIZATIONDIVISION == TVTA.SPART
  • I_CUSTPROJSLSORDITEMPARTNER.SALESORGANIZATION == TVTA.VKORG
  • I_CUSTPROJSLSORDITEMPARTNER.DISTRIBUTIONCHANNEL == TVTA.VTWEG
  • I_CUSTPROJSLSORDITEMPARTNER.MANDT == TVTA.MANDT
Partner function - Document partner
  • Partner Function
  • Client
  • I_CUSTPROJSLSORDITEMPARTNER.PARTNERFUNCTION == TPAR.PARVW
  • I_CUSTPROJSLSORDITEMPARTNER.MANDT == TPAR.MANDT
Business Partner Number
  • Business Partner Number
  • Client
  • I_CUSTPROJSLSORDITEMPARTNER.REFERENCEBUSINESSPARTNER == BUT000.PARTNER
  • I_CUSTPROJSLSORDITEMPARTNER.MANDT == BUT000.CLIENT
Order type in order header
  • Sales Order Type
  • Client
  • I_CUSTPROJSLSORDITEMPARTNER.SALESORDERTYPE == TVAK.AUART
  • I_CUSTPROJSLSORDITEMPARTNER.MANDT == TVAK.MANDT
Sales organization in order header
  • Sales Organization
  • Client
  • I_CUSTPROJSLSORDITEMPARTNER.SALESORGANIZATION == TVKO.VKORG
  • I_CUSTPROJSLSORDITEMPARTNER.MANDT == TVKO.MANDT