I_BPCustomerSalesAddressInfo

BP and Cust sls Addr Depdnt Info | view: IBPCUSTSLSADDR | Extraction: Not supported | Component: Business Partners
Tables used: BUT000, BUT020, KNA1, KNVV, CVI_CUST_LINK, KNVV_ADDR
Column Name Description
BusinessPartner FK Business Partner Number
AddressID FK Address 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
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
IncotermsClassification Incoterms (Part 1) INCO1
IncotermsLocation1 Incoterms Location 1 INCO_L
IncotermsLocation2 Incoterms Location 2 INCO_L
IncotermsVersion Incoterms Version INCOV
DeliveryIsBlocked Customer delivery block (sales area) LIFSP
SalesOffice Sales office VKBUR
SalesGroup Sales group VKGRP
SupplyingPlant Delivering Plant (Own or External) WERKS
AccountByCustomer Shipper's (Our) Account Number at the Customer or Vendor CHAR12
CustomerABCClassification Customer classification (ABC analysis) KLABC
CustomerPaymentTerms Terms of payment key ZTERM
AuthorizationGroup Authorization Group BRGRU
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
  • Client
  • Customer Group 1
  • I_BPCUSTOMERSALESADDRESSINFO.MANDT == TVV1.MANDT
  • I_BPCUSTOMERSALESADDRESSINFO.ADDITIONALCUSTOMERGROUP1 == TVV1.KVGR1
Customer Group 2
  • Client
  • Customer Group 2
  • I_BPCUSTOMERSALESADDRESSINFO.MANDT == TVV2.MANDT
  • I_BPCUSTOMERSALESADDRESSINFO.ADDITIONALCUSTOMERGROUP2 == TVV2.KVGR2
Customer Group 3
  • Customer Group 3
  • Client
  • I_BPCUSTOMERSALESADDRESSINFO.ADDITIONALCUSTOMERGROUP3 == TVV3.KVGR3
  • I_BPCUSTOMERSALESADDRESSINFO.MANDT == TVV3.MANDT
Customer Group 4
  • Client
  • Customer Group 4
  • I_BPCUSTOMERSALESADDRESSINFO.MANDT == TVV4.MANDT
  • I_BPCUSTOMERSALESADDRESSINFO.ADDITIONALCUSTOMERGROUP4 == TVV4.KVGR4
Customer Group 5
  • Client
  • Customer Group 5
  • I_BPCUSTOMERSALESADDRESSINFO.MANDT == TVV5.MANDT
  • I_BPCUSTOMERSALESADDRESSINFO.ADDITIONALCUSTOMERGROUP5 == TVV5.KVGR5
Address Number
  • Address Number
  • Client
  • ?
  • ?
  • I_BPCUSTOMERSALESADDRESSINFO.ADDRESSID == ADRC.ADDRNUMBER
  • I_BPCUSTOMERSALESADDRESSINFO.MANDT == ADRC.CLIENT
  • I_BPCUSTOMERSALESADDRESSINFO.[column in domain "AD_NATION"] == ADRC.NATION
  • I_BPCUSTOMERSALESADDRESSINFO.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM
Business Partner Number
  • Client
  • Business Partner Number
  • I_BPCUSTOMERSALESADDRESSINFO.MANDT == BUT000.CLIENT
  • I_BPCUSTOMERSALESADDRESSINFO.BUSINESSPARTNER == BUT000.PARTNER
Credit control area
  • Client
  • Credit control area
  • I_BPCUSTOMERSALESADDRESSINFO.MANDT == T014.MANDT
  • I_BPCUSTOMERSALESADDRESSINFO.CREDITCONTROLAREA == T014.KKBER
Currency
  • Client
  • Currency
  • I_BPCUSTOMERSALESADDRESSINFO.MANDT == TCURC.MANDT
  • I_BPCUSTOMERSALESADDRESSINFO.CURRENCY == TCURC.WAERS
Customer Number
  • Client
  • Customer Number
  • I_BPCUSTOMERSALESADDRESSINFO.MANDT == KNA1.MANDT
  • I_BPCUSTOMERSALESADDRESSINFO.CUSTOMER == KNA1.KUNNR
Account Assignment Group for this Customer
  • Client
  • Account Assignment Group for this Customer
  • I_BPCUSTOMERSALESADDRESSINFO.MANDT == TVKT.MANDT
  • I_BPCUSTOMERSALESADDRESSINFO.CUSTOMERACCOUNTASSIGNMENTGROUP == TVKT.KTGRD
Customer Group
  • Client
  • Customer Group
  • I_BPCUSTOMERSALESADDRESSINFO.MANDT == T151.MANDT
  • I_BPCUSTOMERSALESADDRESSINFO.CUSTOMERGROUP == T151.KDGRP
Customer Price Group
  • Client
  • Customer Price Group
  • I_BPCUSTOMERSALESADDRESSINFO.MANDT == T188.MANDT
  • I_BPCUSTOMERSALESADDRESSINFO.CUSTOMERPRICEGROUP == T188.KONDA
Customer procedure for product proposal
  • Client
  • Customer procedure for product proposal
  • I_BPCUSTOMERSALESADDRESSINFO.MANDT == TPVD.MANDT
  • I_BPCUSTOMERSALESADDRESSINFO.CUSTPRODPROPOSALPROCEDURE == TPVD.PVKSM
Delivery Priority
  • Client
  • Delivery Priority
  • I_BPCUSTOMERSALESADDRESSINFO.MANDT == TPRIO.MANDT
  • I_BPCUSTOMERSALESADDRESSINFO.DELIVERYPRIORITY == TPRIO.LPRIO
Distribution Channel
  • Client
  • Distribution Channel
  • I_BPCUSTOMERSALESADDRESSINFO.MANDT == TVTW.MANDT
  • I_BPCUSTOMERSALESADDRESSINFO.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Division
  • Client
  • Division
  • I_BPCUSTOMERSALESADDRESSINFO.MANDT == TSPA.MANDT
  • I_BPCUSTOMERSALESADDRESSINFO.DIVISION == TSPA.SPART
Exchange Rate Type
  • Exchange Rate Type
  • Client
  • I_BPCUSTOMERSALESADDRESSINFO.EXCHANGERATETYPE == TCURV.KURST
  • I_BPCUSTOMERSALESADDRESSINFO.MANDT == TCURV.MANDT
Invoice List Schedule (calendar identification) I_BPCUSTOMERSALESADDRESSINFO.INVOICELISTSCHEDULE == TFACD.IDENT
Customer order block (sales area)
  • Client
  • Customer order block (sales area)
  • ?
  • I_BPCUSTOMERSALESADDRESSINFO.MANDT == TVAST.MANDT
  • I_BPCUSTOMERSALESADDRESSINFO.ORDERISBLOCKEDFORCUSTOMER == TVAST.AUFSP
  • I_BPCUSTOMERSALESADDRESSINFO.[column in domain "SPRAS"] == TVAST.SPRAS
Price List Type
  • Client
  • Price List Type
  • I_BPCUSTOMERSALESADDRESSINFO.MANDT == T189.MANDT
  • I_BPCUSTOMERSALESADDRESSINFO.PRICELISTTYPE == T189.PLTYP
Sales District
  • Client
  • Sales District
  • I_BPCUSTOMERSALESADDRESSINFO.MANDT == T171.MANDT
  • I_BPCUSTOMERSALESADDRESSINFO.SALESDISTRICT == T171.BZIRK
Sales Organization
  • Client
  • Sales Organization
  • I_BPCUSTOMERSALESADDRESSINFO.MANDT == TVKO.MANDT
  • I_BPCUSTOMERSALESADDRESSINFO.SALESORGANIZATION == TVKO.VKORG
Other Relations | to Master Data Relations ↑ Join Conditions
Units of Measure Group Check
  • ?
  • Client
  • Unit of Measure Group
  • I_BPCUSTOMERSALESADDRESSINFO.[column in domain "LRMEI"] == TWMEG.MEINS
  • I_BPCUSTOMERSALESADDRESSINFO.MANDT == TWMEG.MANDT
  • I_BPCUSTOMERSALESADDRESSINFO.PRODUCTUNITGROUP == TWMEG.MEGRU