C_BPAddlCustSalesArea

C view for Cust Sales Area | view: CBPADDCSA | Extraction: Not supported | Component: Business Partners
Tables used: MDG_MLT_ASSGMNT, KNVV
Column Name Description
BusinessPartner Business Partner Number
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
OrderCombinationIsAllowed Order Combination Indicator Show values
CompleteDeliveryIsDefined Complete Delivery Defined for Each Sales Order? Show values
PartialDeliveryIsAllowed Partial delivery at item level Show values
ItemOrderProbabilityInPercent Order Probability of the Item Show values
Column Name Description Domain name
BusinessPartnerForEdit Business Partner Number BU_PARTNER
AccountByCustomer Shipper's (Our) Account Number at the Customer or Vendor CHAR12
CustomerABCClassification Customer classification (ABC analysis) KLABC
DeliveryPriority null
IncotermsTransferLocation Incoterms (Part 2) INCO2
IncotermsLocation1 Incoterms Location 1 INCO_L
IncotermsLocation2 Incoterms Location 2 INCO_L
CustomerPaymentTerms Terms of payment key ZTERM
AuthorizationGroup Authorization Group BEGRU
SalesItemProposal Item proposal VBELN
Master Data Relations Join Conditions
Customer Group 1
  • Customer Group 1
  • Client
  • C_BPADDLCUSTSALESAREA.ADDITIONALCUSTOMERGROUP1 == TVV1.KVGR1
  • C_BPADDLCUSTSALESAREA.MANDT == TVV1.MANDT
Customer Group 2
  • Customer Group 2
  • Client
  • C_BPADDLCUSTSALESAREA.ADDITIONALCUSTOMERGROUP2 == TVV2.KVGR2
  • C_BPADDLCUSTSALESAREA.MANDT == TVV2.MANDT
Customer Group 3
  • Customer Group 3
  • Client
  • C_BPADDLCUSTSALESAREA.ADDITIONALCUSTOMERGROUP3 == TVV3.KVGR3
  • C_BPADDLCUSTSALESAREA.MANDT == TVV3.MANDT
Customer Group 4
  • Customer Group 4
  • Client
  • C_BPADDLCUSTSALESAREA.ADDITIONALCUSTOMERGROUP4 == TVV4.KVGR4
  • C_BPADDLCUSTSALESAREA.MANDT == TVV4.MANDT
Customer Group 5
  • Customer Group 5
  • Client
  • C_BPADDLCUSTSALESAREA.ADDITIONALCUSTOMERGROUP5 == TVV5.KVGR5
  • C_BPADDLCUSTSALESAREA.MANDT == TVV5.MANDT
Billing block for customer (sales and distribution)
  • Client
  • Billing block for customer (sales and distribution)
  • C_BPADDLCUSTSALESAREA.MANDT == TVFS.MANDT
  • C_BPADDLCUSTSALESAREA.BILLINGISBLOCKEDFORCUSTOMER == TVFS.FAKSP
Currency
  • Client
  • Currency
  • C_BPADDLCUSTSALESAREA.MANDT == TCURC.MANDT
  • C_BPADDLCUSTSALESAREA.CURRENCY == TCURC.WAERS
Customer Number
  • Client
  • Customer Number
  • Customer Number
  • C_BPADDLCUSTSALESAREA.MANDT == KNA1.MANDT
  • C_BPADDLCUSTSALESAREA.CUSTOMER == KNA1.KUNNR
  • C_BPADDLCUSTSALESAREA.CUSTOMERFOREDIT == KNA1.KUNNR
Account Assignment Group for this Customer
  • Account Assignment Group for this Customer
  • Client
  • C_BPADDLCUSTSALESAREA.CUSTOMERACCOUNTASSIGNMENTGROUP == TVKT.KTGRD
  • C_BPADDLCUSTSALESAREA.MANDT == TVKT.MANDT
Customer Number
  • Client
  • Customer Number
  • Customer Number
  • C_BPADDLCUSTSALESAREA.MANDT == KNA1.MANDT
  • C_BPADDLCUSTSALESAREA.CUSTOMER == KNA1.KUNNR
  • C_BPADDLCUSTSALESAREA.CUSTOMERFOREDIT == KNA1.KUNNR
Customer Group
  • Customer Group
  • Client
  • C_BPADDLCUSTSALESAREA.CUSTOMERGROUP == T151.KDGRP
  • C_BPADDLCUSTSALESAREA.MANDT == T151.MANDT
Customer Price Group
  • Customer Price Group
  • Client
  • C_BPADDLCUSTSALESAREA.CUSTOMERPRICEGROUP == T188.KONDA
  • C_BPADDLCUSTSALESAREA.MANDT == T188.MANDT
Customer Classification for Pricing Procedure Determination
  • Customer Classification for Pricing Procedure Determination
  • Client
  • C_BPADDLCUSTSALESAREA.CUSTOMERPRICINGPROCEDURE == TVKD.KALKS
  • C_BPADDLCUSTSALESAREA.MANDT == TVKD.MANDT
Customer procedure for product proposal
  • Customer procedure for product proposal
  • Client
  • C_BPADDLCUSTSALESAREA.CUSTPRODPROPOSALPROCEDURE == TPVD.PVKSM
  • C_BPADDLCUSTSALESAREA.MANDT == TPVD.MANDT
Customer delivery block (sales area)
  • Customer delivery block (sales area)
  • Client
  • C_BPADDLCUSTSALESAREA.DELIVERYISBLOCKEDFORCUSTOMER == TVLS.LIFSP
  • C_BPADDLCUSTSALESAREA.MANDT == TVLS.MANDT
Distribution Channel
  • Client
  • Distribution Channel
  • Distribution Channel
  • C_BPADDLCUSTSALESAREA.MANDT == TVTW.MANDT
  • C_BPADDLCUSTSALESAREA.DISTRIBUTIONCHANNEL == TVTW.VTWEG
  • C_BPADDLCUSTSALESAREA.DISTRIBUTIONCHANNELFOREDIT == TVTW.VTWEG
Distribution Channel
  • Client
  • Distribution Channel
  • Distribution Channel
  • C_BPADDLCUSTSALESAREA.MANDT == TVTW.MANDT
  • C_BPADDLCUSTSALESAREA.DISTRIBUTIONCHANNEL == TVTW.VTWEG
  • C_BPADDLCUSTSALESAREA.DISTRIBUTIONCHANNELFOREDIT == TVTW.VTWEG
Division
  • Division
  • Division
  • Client
  • C_BPADDLCUSTSALESAREA.DIVISIONFOREDIT == TSPA.SPART
  • C_BPADDLCUSTSALESAREA.DIVISION == TSPA.SPART
  • C_BPADDLCUSTSALESAREA.MANDT == TSPA.MANDT
Division
  • Division
  • Division
  • Client
  • C_BPADDLCUSTSALESAREA.DIVISIONFOREDIT == TSPA.SPART
  • C_BPADDLCUSTSALESAREA.DIVISION == TSPA.SPART
  • C_BPADDLCUSTSALESAREA.MANDT == TSPA.MANDT
Exchange Rate Type
  • Exchange Rate Type
  • Client
  • C_BPADDLCUSTSALESAREA.EXCHANGERATETYPE == TCURV.KURST
  • C_BPADDLCUSTSALESAREA.MANDT == TCURV.MANDT
Incoterms (Part 1)
  • Incoterms (Part 1)
  • Client
  • C_BPADDLCUSTSALESAREA.INCOTERMSCLASSIFICATION == TINC.INCO1
  • C_BPADDLCUSTSALESAREA.MANDT == TINC.MANDT
Incoterms Version
  • Incoterms Version
  • Client
  • C_BPADDLCUSTSALESAREA.INCOTERMSVERSION == TINCV.INCOV
  • C_BPADDLCUSTSALESAREA.MANDT == TINCV.MANDT
Invoice Dates (Calendar Identification) C_BPADDLCUSTSALESAREA.INVOICEDATE == TFACD.IDENT
Invoice List Schedule (calendar identification) C_BPADDLCUSTSALESAREA.INVOICELISTSCHEDULE == TFACD.IDENT
Customer order block (sales area)
  • Customer order block (sales area)
  • Client
  • ?
  • C_BPADDLCUSTSALESAREA.ORDERISBLOCKEDFORCUSTOMER == TVAST.AUFSP
  • C_BPADDLCUSTSALESAREA.MANDT == TVAST.MANDT
  • C_BPADDLCUSTSALESAREA.[column in domain "SPRAS"] == TVAST.SPRAS
Customer payment guarantee procedure
  • Client
  • Customer payment guarantee procedure
  • C_BPADDLCUSTSALESAREA.MANDT == T691P.MANDT
  • C_BPADDLCUSTSALESAREA.PAYMENTGUARANTEEPROCEDURE == T691P.KABSS
Sales District
  • Sales District
  • Client
  • C_BPADDLCUSTSALESAREA.SALESDISTRICT == T171.BZIRK
  • C_BPADDLCUSTSALESAREA.MANDT == T171.MANDT
Sales group
  • Sales group
  • Client
  • Sales office
  • C_BPADDLCUSTSALESAREA.SALESGROUP == TVBVK.VKGRP
  • C_BPADDLCUSTSALESAREA.MANDT == TVBVK.MANDT
  • C_BPADDLCUSTSALESAREA.SALESOFFICE == TVBVK.VKBUR
Sales office
  • Client
  • Sales office
  • C_BPADDLCUSTSALESAREA.MANDT == TVBUR.MANDT
  • C_BPADDLCUSTSALESAREA.SALESOFFICE == TVBUR.VKBUR
Sales Organization
  • Sales Organization
  • Sales Organization
  • Client
  • C_BPADDLCUSTSALESAREA.SALESORGANIZATION == TVKO.VKORG
  • C_BPADDLCUSTSALESAREA.SALESORGANIZATIONFOREDIT == TVKO.VKORG
  • C_BPADDLCUSTSALESAREA.MANDT == TVKO.MANDT
Sales Organization
  • Sales Organization
  • Sales Organization
  • Client
  • C_BPADDLCUSTSALESAREA.SALESORGANIZATION == TVKO.VKORG
  • C_BPADDLCUSTSALESAREA.SALESORGANIZATIONFOREDIT == TVKO.VKORG
  • C_BPADDLCUSTSALESAREA.MANDT == TVKO.MANDT
Shipping Conditions
  • Client
  • Shipping Conditions
  • C_BPADDLCUSTSALESAREA.MANDT == TVSB.MANDT
  • C_BPADDLCUSTSALESAREA.SHIPPINGCONDITION == TVSB.VSBED
Delivering Plant (Own or External)
  • Sales Organization
  • Sales Organization
  • Client
  • Delivering Plant (Own or External)
  • Distribution Channel
  • Distribution Channel
  • C_BPADDLCUSTSALESAREA.SALESORGANIZATION == TVKWZ.VKORG
  • C_BPADDLCUSTSALESAREA.SALESORGANIZATIONFOREDIT == TVKWZ.VKORG
  • C_BPADDLCUSTSALESAREA.MANDT == TVKWZ.MANDT
  • C_BPADDLCUSTSALESAREA.SUPPLYINGPLANT == TVKWZ.WERKS
  • C_BPADDLCUSTSALESAREA.DISTRIBUTIONCHANNEL == TVKWZ.VTWEG
  • C_BPADDLCUSTSALESAREA.DISTRIBUTIONCHANNELFOREDIT == TVKWZ.VTWEG