A_CustomerSalesArea

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