I_CustomerSalesArea

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