C_CustomerBySalesItemProposal

Customer by Sales Item Proposal | view: CSDCUSTBYSLSIMPL | Extraction: Not supported | Component: Sales
Tables used: ADCPADRCADR6ADR2KNA1KNVV
Column Name Description
Customer FK Customer Number
SalesOrganization FK Sales Organization
DistributionChannel FK Distribution Channel
Division FK Division
Column Name Description
Column Name Description
Column Name Description
Column Name Description
Column Name Description Domain name
SalesItemProposal Item proposal VBELN
CustomerName Name of Customer TEXT80
EmailAddress null
PhoneNumber First telephone no.: dialling code+number CHAR30
MobilePhoneNumber null
FaxNumber First Fax No.: Area Code + Number CHAR30
AuthorizationGroup Authorization Group BEGRU
Master Data Relations Join Conditions
Customer Number
  • Customer Number
  • Client
  • C_CUSTOMERBYSALESITEMPROPOSAL.CUSTOMER == KNA1.KUNNR
  • C_CUSTOMERBYSALESITEMPROPOSAL.MANDT == KNA1.MANDT
Customer Account Group
  • Customer Account Group
  • Client
  • C_CUSTOMERBYSALESITEMPROPOSAL.CUSTOMERACCOUNTGROUP == T077D.KTOKD
  • C_CUSTOMERBYSALESITEMPROPOSAL.MANDT == T077D.MANDT
Distribution Channel
  • Client
  • Distribution Channel
  • C_CUSTOMERBYSALESITEMPROPOSAL.MANDT == TVTW.MANDT
  • C_CUSTOMERBYSALESITEMPROPOSAL.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Division
  • Client
  • Division
  • C_CUSTOMERBYSALESITEMPROPOSAL.MANDT == TSPA.MANDT
  • C_CUSTOMERBYSALESITEMPROPOSAL.DIVISION == TSPA.SPART
Sales Organization
  • Client
  • Sales Organization
  • C_CUSTOMERBYSALESITEMPROPOSAL.MANDT == TVKO.MANDT
  • C_CUSTOMERBYSALESITEMPROPOSAL.SALESORGANIZATION == TVKO.VKORG