I_Businesspartnersalesarea

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