I_CustProjSlsOrdPartner

Sales Order Partner for Customer Project | view: ICUSTPROJSOHP | TRAN | Extraction: Not supported | Component: Project-Based Services in Sales Documents
Tables used: VBKD, VEDA, VBAK, /CPD/D_MP_HDR, /CPD/D_MP_ITEM, VBPA, VBPA, ADRP, ADCP, ADRC, CVI_CUST_CT_LINK, BUT0ID, BUT000, ADRP, KNVK, CVI_CUST_LINK, CVI_VEND_LINK
Column Name Description
CustomerProject Commercial Project ID
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
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
  • ?
  • ?
  • Client
  • Person Number
  • I_CUSTPROJSLSORDPARTNER.[column in domain "AD_NATION"] == ADRP.NATION
  • I_CUSTPROJSLSORDPARTNER.[column in domain "AD_DATE_FR"] == ADRP.DATE_FROM
  • I_CUSTPROJSLSORDPARTNER.MANDT == ADRP.CLIENT
  • I_CUSTPROJSLSORDPARTNER.ADDRESSPERSONID == ADRP.PERSNUMBER
Address Determination in Document
  • Client
  • Address Determination in Document
  • I_CUSTPROJSLSORDPARTNER.MANDT == TB008S.CLIENT
  • I_CUSTPROJSLSORDPARTNER.BPADDRDETERMINATIONTRANSACTION == TB008S.OPERATION
Distribution channel in order header
  • Client
  • Distribution Channel
  • Sales Organization
  • I_CUSTPROJSLSORDPARTNER.MANDT == TVKOV.MANDT
  • I_CUSTPROJSLSORDPARTNER.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
  • I_CUSTPROJSLSORDPARTNER.SALESORGANIZATION == TVKOV.VKORG
Division in order header
  • Client
  • Division
  • Distribution Channel
  • Sales Organization
  • I_CUSTPROJSLSORDPARTNER.MANDT == TVTA.MANDT
  • I_CUSTPROJSLSORDPARTNER.ORGANIZATIONDIVISION == TVTA.SPART
  • I_CUSTPROJSLSORDPARTNER.DISTRIBUTIONCHANNEL == TVTA.VTWEG
  • I_CUSTPROJSLSORDPARTNER.SALESORGANIZATION == TVTA.VKORG
Partner function - Document partner
  • Client
  • Partner Function
  • I_CUSTPROJSLSORDPARTNER.MANDT == TPAR.MANDT
  • I_CUSTPROJSLSORDPARTNER.PARTNERFUNCTION == TPAR.PARVW
Business Partner Number
  • Client
  • Business Partner Number
  • I_CUSTPROJSLSORDPARTNER.MANDT == BUT000.CLIENT
  • I_CUSTPROJSLSORDPARTNER.REFERENCEBUSINESSPARTNER == BUT000.PARTNER
Order type in order header
  • Client
  • Sales Order Type
  • I_CUSTPROJSLSORDPARTNER.MANDT == TVAK.MANDT
  • I_CUSTPROJSLSORDPARTNER.SALESORDERTYPE == TVAK.AUART
Sales organization in order header
  • Client
  • Sales Organization
  • I_CUSTPROJSLSORDPARTNER.MANDT == TVKO.MANDT
  • I_CUSTPROJSLSORDPARTNER.SALESORGANIZATION == TVKO.VKORG