C_BusinessPartnerSalesArea

Consumption view for customer sales area | view: CBUPASALESAREA | Extraction: Not supported | Component: Business Partners
Tables used: BUT000, KNVV, CVI_CUST_LINK, TVKOT
Column Name Description
BusinessPartner Business Partner 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
SuplrIsRlvtForSettlmtMgmt Indicator: Relevant for Settlement Management Show values
SlsDocIsRlvtForProofOfDeliv Relevant for POD processing Show values
SlsUnlmtdOvrdelivIsAllwd Unlimited Overdelivery Allowed Show values
CustomerIsRebateRelevant Indicator: Customer Is Rebate-Relevant Show values
InspSbstHasNoTimeOrQuantity Relevant for price determination ID Show values
ManualInvoiceMaintIsRelevant Manual Invoice Maintenance Show values
Column Name Description Domain name
BusinessPartnerForEdit Business Partner Number BU_PARTNER
BusinessPartnerUUID Business Partner GUID SYSUUID
SalesOrganizationName Sales Organization Description TEXT20
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
UnderdelivTolrtdLmtRatioInPct Underdelivery Tolerance PRZ21
OverdelivTolrtdLmtRatioInPct Overdelivery Tolerance PRZ21
MaxNmbrOfPartialDelivery Maximum Number of Partial Deliveries Allowed Per Item ANTLF
SalesItemProposal Item proposal VBELN
Master Data Relations Join Conditions
Customer Group 1
  • Customer Group 1
  • Client
  • C_BUSINESSPARTNERSALESAREA.ADDITIONALCUSTOMERGROUP1 == TVV1.KVGR1
  • C_BUSINESSPARTNERSALESAREA.MANDT == TVV1.MANDT
Customer Group 2
  • Customer Group 2
  • Client
  • C_BUSINESSPARTNERSALESAREA.ADDITIONALCUSTOMERGROUP2 == TVV2.KVGR2
  • C_BUSINESSPARTNERSALESAREA.MANDT == TVV2.MANDT
Customer Group 3
  • Client
  • Customer Group 3
  • C_BUSINESSPARTNERSALESAREA.MANDT == TVV3.MANDT
  • C_BUSINESSPARTNERSALESAREA.ADDITIONALCUSTOMERGROUP3 == TVV3.KVGR3
Customer Group 4
  • Customer Group 4
  • Client
  • C_BUSINESSPARTNERSALESAREA.ADDITIONALCUSTOMERGROUP4 == TVV4.KVGR4
  • C_BUSINESSPARTNERSALESAREA.MANDT == TVV4.MANDT
Customer Group 5
  • Client
  • Customer Group 5
  • C_BUSINESSPARTNERSALESAREA.MANDT == TVV5.MANDT
  • C_BUSINESSPARTNERSALESAREA.ADDITIONALCUSTOMERGROUP5 == TVV5.KVGR5
Billing block for customer (sales and distribution)
  • Billing block for customer (sales and distribution)
  • Client
  • C_BUSINESSPARTNERSALESAREA.BILLINGISBLOCKEDFORCUSTOMER == TVFS.FAKSP
  • C_BUSINESSPARTNERSALESAREA.MANDT == TVFS.MANDT
Credit control area
  • Credit control area
  • Client
  • C_BUSINESSPARTNERSALESAREA.CREDITCONTROLAREA == T014.KKBER
  • C_BUSINESSPARTNERSALESAREA.MANDT == T014.MANDT
Currency
  • Client
  • Currency
  • C_BUSINESSPARTNERSALESAREA.MANDT == TCURC.MANDT
  • C_BUSINESSPARTNERSALESAREA.CURRENCY == TCURC.WAERS
Customer Number
  • Customer Number
  • Client
  • C_BUSINESSPARTNERSALESAREA.CUSTOMER == KNA1.KUNNR
  • C_BUSINESSPARTNERSALESAREA.MANDT == KNA1.MANDT
Account Assignment Group for this Customer
  • Client
  • Account Assignment Group for this Customer
  • C_BUSINESSPARTNERSALESAREA.MANDT == TVKT.MANDT
  • C_BUSINESSPARTNERSALESAREA.CUSTOMERACCOUNTASSIGNMENTGROUP == TVKT.KTGRD
Customer Group
  • Client
  • Customer Group
  • C_BUSINESSPARTNERSALESAREA.MANDT == T151.MANDT
  • C_BUSINESSPARTNERSALESAREA.CUSTOMERGROUP == T151.KDGRP
Customer Price Group
  • Client
  • Customer Price Group
  • C_BUSINESSPARTNERSALESAREA.MANDT == T188.MANDT
  • C_BUSINESSPARTNERSALESAREA.CUSTOMERPRICEGROUP == T188.KONDA
Customer Classification for Pricing Procedure Determination
  • Client
  • Customer Classification for Pricing Procedure Determination
  • C_BUSINESSPARTNERSALESAREA.MANDT == TVKD.MANDT
  • C_BUSINESSPARTNERSALESAREA.CUSTOMERPRICINGPROCEDURE == TVKD.KALKS
Customer procedure for product proposal
  • Client
  • Customer procedure for product proposal
  • C_BUSINESSPARTNERSALESAREA.MANDT == TPVD.MANDT
  • C_BUSINESSPARTNERSALESAREA.CUSTPRODPROPOSALPROCEDURE == TPVD.PVKSM
Customer delivery block (sales area)
  • Client
  • Customer delivery block (sales area)
  • C_BUSINESSPARTNERSALESAREA.MANDT == TVLS.MANDT
  • C_BUSINESSPARTNERSALESAREA.DELIVERYISBLOCKEDFORCUSTOMER == TVLS.LIFSP
Distribution Channel
  • Client
  • Distribution Channel
  • Distribution Channel
  • C_BUSINESSPARTNERSALESAREA.MANDT == TVTW.MANDT
  • C_BUSINESSPARTNERSALESAREA.DISTRIBUTIONCHANNELFOREDIT == TVTW.VTWEG
  • C_BUSINESSPARTNERSALESAREA.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Distribution Channel
  • Client
  • Distribution Channel
  • Distribution Channel
  • C_BUSINESSPARTNERSALESAREA.MANDT == TVTW.MANDT
  • C_BUSINESSPARTNERSALESAREA.DISTRIBUTIONCHANNELFOREDIT == TVTW.VTWEG
  • C_BUSINESSPARTNERSALESAREA.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Division
  • Client
  • Division
  • Division
  • C_BUSINESSPARTNERSALESAREA.MANDT == TSPA.MANDT
  • C_BUSINESSPARTNERSALESAREA.DIVISION == TSPA.SPART
  • C_BUSINESSPARTNERSALESAREA.DIVISIONFOREDIT == TSPA.SPART
Division
  • Client
  • Division
  • Division
  • C_BUSINESSPARTNERSALESAREA.MANDT == TSPA.MANDT
  • C_BUSINESSPARTNERSALESAREA.DIVISION == TSPA.SPART
  • C_BUSINESSPARTNERSALESAREA.DIVISIONFOREDIT == TSPA.SPART
Exchange Rate Type
  • Client
  • Exchange Rate Type
  • C_BUSINESSPARTNERSALESAREA.MANDT == TCURV.MANDT
  • C_BUSINESSPARTNERSALESAREA.EXCHANGERATETYPE == TCURV.KURST
Incoterms (Part 1)
  • Incoterms (Part 1)
  • Client
  • C_BUSINESSPARTNERSALESAREA.INCOTERMSCLASSIFICATION == TINC.INCO1
  • C_BUSINESSPARTNERSALESAREA.MANDT == TINC.MANDT
Incoterms Version
  • Client
  • Incoterms Version
  • C_BUSINESSPARTNERSALESAREA.MANDT == TINCV.MANDT
  • C_BUSINESSPARTNERSALESAREA.INCOTERMSVERSION == TINCV.INCOV
Invoice Dates (Calendar Identification) C_BUSINESSPARTNERSALESAREA.INVOICEDATE == TFACD.IDENT
Invoice List Schedule (calendar identification) C_BUSINESSPARTNERSALESAREA.INVOICELISTSCHEDULE == TFACD.IDENT
Customer order block (sales area)
  • Customer order block (sales area)
  • ?
  • Client
  • C_BUSINESSPARTNERSALESAREA.ORDERISBLOCKEDFORCUSTOMER == TVAST.AUFSP
  • C_BUSINESSPARTNERSALESAREA.[column in domain "SPRAS"] == TVAST.SPRAS
  • C_BUSINESSPARTNERSALESAREA.MANDT == TVAST.MANDT
Customer payment guarantee procedure
  • Customer payment guarantee procedure
  • Client
  • C_BUSINESSPARTNERSALESAREA.PAYMENTGUARANTEEPROCEDURE == T691P.KABSS
  • C_BUSINESSPARTNERSALESAREA.MANDT == T691P.MANDT
Price List Type
  • Price List Type
  • Client
  • C_BUSINESSPARTNERSALESAREA.PRICELISTTYPE == T189.PLTYP
  • C_BUSINESSPARTNERSALESAREA.MANDT == T189.MANDT
Sales District
  • Client
  • Sales District
  • C_BUSINESSPARTNERSALESAREA.MANDT == T171.MANDT
  • C_BUSINESSPARTNERSALESAREA.SALESDISTRICT == T171.BZIRK
Sales group
  • Client
  • Sales office
  • Sales group
  • C_BUSINESSPARTNERSALESAREA.MANDT == TVBVK.MANDT
  • C_BUSINESSPARTNERSALESAREA.SALESOFFICE == TVBVK.VKBUR
  • C_BUSINESSPARTNERSALESAREA.SALESGROUP == TVBVK.VKGRP
Sales office
  • Client
  • Sales office
  • C_BUSINESSPARTNERSALESAREA.MANDT == TVBUR.MANDT
  • C_BUSINESSPARTNERSALESAREA.SALESOFFICE == TVBUR.VKBUR
Sales Organization
  • Client
  • Sales Organization
  • Sales Organization
  • C_BUSINESSPARTNERSALESAREA.MANDT == TVKO.MANDT
  • C_BUSINESSPARTNERSALESAREA.SALESORGANIZATION == TVKO.VKORG
  • C_BUSINESSPARTNERSALESAREA.SALESORGANIZATIONFOREDIT == TVKO.VKORG
Sales Organization
  • Client
  • Sales Organization
  • Sales Organization
  • C_BUSINESSPARTNERSALESAREA.MANDT == TVKO.MANDT
  • C_BUSINESSPARTNERSALESAREA.SALESORGANIZATION == TVKO.VKORG
  • C_BUSINESSPARTNERSALESAREA.SALESORGANIZATIONFOREDIT == TVKO.VKORG
Shipping Conditions
  • Client
  • Shipping Conditions
  • C_BUSINESSPARTNERSALESAREA.MANDT == TVSB.MANDT
  • C_BUSINESSPARTNERSALESAREA.SHIPPINGCONDITION == TVSB.VSBED
Delivering Plant (Own or External)
  • Client
  • Sales Organization
  • Sales Organization
  • Distribution Channel
  • Distribution Channel
  • Delivering Plant (Own or External)
  • C_BUSINESSPARTNERSALESAREA.MANDT == TVKWZ.MANDT
  • C_BUSINESSPARTNERSALESAREA.SALESORGANIZATION == TVKWZ.VKORG
  • C_BUSINESSPARTNERSALESAREA.SALESORGANIZATIONFOREDIT == TVKWZ.VKORG
  • C_BUSINESSPARTNERSALESAREA.DISTRIBUTIONCHANNELFOREDIT == TVKWZ.VTWEG
  • C_BUSINESSPARTNERSALESAREA.DISTRIBUTIONCHANNEL == TVKWZ.VTWEG
  • C_BUSINESSPARTNERSALESAREA.SUPPLYINGPLANT == TVKWZ.WERKS
Other Relations | to Master Data Relations ↑ Join Conditions
Units of Measure Group Check
  • Client
  • ?
  • Unit of Measure Group
  • C_BUSINESSPARTNERSALESAREA.MANDT == TWMEG.MANDT
  • C_BUSINESSPARTNERSALESAREA.[column in domain "LRMEI"] == TWMEG.MEINS
  • C_BUSINESSPARTNERSALESAREA.PRODUCTUNITGROUP == TWMEG.MEGRU