I_BPCustomerGeneralAddressInfo

BP and Cust Addr Depdnt Info | view: IBPCUSTADDRINFO | Extraction: Not supported | Component: Business Partners
Tables used: BUT000, BUT000, CVI_CUST_LINK, KNA1, BUT020, KNA1_ADDR
Column Name Description
BusinessPartner FK Business Partner Number
AddressID FK Address Number
Column Name Description
Column Name Description
Column Name Description
Column Name Description
CustomerHasUnloadingPoint Indicator: Unloading points exist Show values
PostingIsBlocked Central posting block Show values
DataMediumExchangeIndicator Report key for data medium exchange Show values
VATLiability Liable for VAT Show values
IsNaturalPerson Natural Person Show values
DeliveryDateTypeRule Delivery Date Rule Show values
IsCompetitor Indicator: Competitor Show values
IsSalesPartner Indicator: Sales partner Show values
IsDefaultSoldToParty ID for default sold-to party Show values
IsConsumer Indicator: Consumer Show values
Column Name Description Domain name
Customer Customer Number KUNNR
ExpressTrainStationName Express train station BAHNH
TrainStationName Train station BAHNH
CityCode City Code CITYC
County County Code COUNC
AuthorizationGroup Authorization Group BRGRU
CustomerCorporateGroup Group key KONZS
CityLocationCoordinatesCode City Coordinates LOCCO
DataExchangeInstructionKey Instruction Key for Data Medium Exchange DTAWS
Master Data Relations Join Conditions
Address Number
  • Client
  • ?
  • ?
  • Address Number
  • I_BPCUSTOMERGENERALADDRESSINFO.MANDT == ADRC.CLIENT
  • I_BPCUSTOMERGENERALADDRESSINFO.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM
  • I_BPCUSTOMERGENERALADDRESSINFO.[column in domain "AD_NATION"] == ADRC.NATION
  • I_BPCUSTOMERGENERALADDRESSINFO.ADDRESSID == ADRC.ADDRNUMBER
Account Number of an Alternative Payer
  • Client
  • Account Number of an Alternative Payer
  • I_BPCUSTOMERGENERALADDRESSINFO.MANDT == KNA1.MANDT
  • I_BPCUSTOMERGENERALADDRESSINFO.ALTERNATIVEPAYERACCOUNT == KNA1.KUNNR
Central billing block for customer
  • Client
  • Central billing block for customer
  • I_BPCUSTOMERGENERALADDRESSINFO.MANDT == TVFS.MANDT
  • I_BPCUSTOMERGENERALADDRESSINFO.BILLINGISBLOCKEDFORCUSTOMER == TVFS.FAKSP
Business Partner Number
  • Client
  • Business Partner Number
  • I_BPCUSTOMERGENERALADDRESSINFO.MANDT == BUT000.CLIENT
  • I_BPCUSTOMERGENERALADDRESSINFO.BUSINESSPARTNER == BUT000.PARTNER
Customer Account Group
  • Client
  • Customer Account Group
  • I_BPCUSTOMERGENERALADDRESSINFO.MANDT == T077D.MANDT
  • I_BPCUSTOMERGENERALADDRESSINFO.CUSTOMERACCOUNTGROUP == T077D.KTOKD
Customer Classification
  • Customer Classification
  • Client
  • I_BPCUSTOMERGENERALADDRESSINFO.CUSTOMERCLASSIFICATION == TKUKL.KUKLA
  • I_BPCUSTOMERGENERALADDRESSINFO.MANDT == TKUKL.MANDT
Customer Condition Group
  • Customer condition group 1
  • Client
  • I_BPCUSTOMERGENERALADDRESSINFO.CUSTOMERCONDITIONGROUP1 == TVKGG.KDKGR
  • I_BPCUSTOMERGENERALADDRESSINFO.MANDT == TVKGG.MANDT
Customer Condition Group
  • Client
  • Customer condition group 2
  • I_BPCUSTOMERGENERALADDRESSINFO.MANDT == TVKGG.MANDT
  • I_BPCUSTOMERGENERALADDRESSINFO.CUSTOMERCONDITIONGROUP2 == TVKGG.KDKGR
Customer Condition Group
  • Customer condition group 3
  • Client
  • I_BPCUSTOMERGENERALADDRESSINFO.CUSTOMERCONDITIONGROUP3 == TVKGG.KDKGR
  • I_BPCUSTOMERGENERALADDRESSINFO.MANDT == TVKGG.MANDT
Customer Condition Group
  • Customer condition group 4
  • Client
  • I_BPCUSTOMERGENERALADDRESSINFO.CUSTOMERCONDITIONGROUP4 == TVKGG.KDKGR
  • I_BPCUSTOMERGENERALADDRESSINFO.MANDT == TVKGG.MANDT
Customer Condition Group
  • Client
  • Customer condition group 5
  • I_BPCUSTOMERGENERALADDRESSINFO.MANDT == TVKGG.MANDT
  • I_BPCUSTOMERGENERALADDRESSINFO.CUSTOMERCONDITIONGROUP5 == TVKGG.KDKGR
Central delivery block for the customer
  • Central delivery block for the customer
  • Client
  • I_BPCUSTOMERGENERALADDRESSINFO.DELIVERYISBLOCKED == TVLS.LIFSP
  • I_BPCUSTOMERGENERALADDRESSINFO.MANDT == TVLS.MANDT
Account number of the master record with the fiscal address
  • Account number of the master record with the fiscal address
  • Client
  • I_BPCUSTOMERGENERALADDRESSINFO.FISCALADDRESS == KNA1.KUNNR
  • I_BPCUSTOMERGENERALADDRESSINFO.MANDT == KNA1.MANDT
Attribute 3
  • Attribute 3
  • Client
  • I_BPCUSTOMERGENERALADDRESSINFO.FREEDEFINEDATTRIBUTE03 == TVK3.KATR3
  • I_BPCUSTOMERGENERALADDRESSINFO.MANDT == TVK3.MANDT
Industry code 1
  • Industry code 1
  • Client
  • I_BPCUSTOMERGENERALADDRESSINFO.INDUSTRYCODE1 == TBRC.BRACO
  • I_BPCUSTOMERGENERALADDRESSINFO.MANDT == TBRC.MANDT
Industry code 2
  • Industry code 2
  • Client
  • I_BPCUSTOMERGENERALADDRESSINFO.INDUSTRYCODE2 == TBRC.BRACO
  • I_BPCUSTOMERGENERALADDRESSINFO.MANDT == TBRC.MANDT
Industry code 3
  • Industry code 3
  • Client
  • I_BPCUSTOMERGENERALADDRESSINFO.INDUSTRYCODE3 == TBRC.BRACO
  • I_BPCUSTOMERGENERALADDRESSINFO.MANDT == TBRC.MANDT
Central order block for customer
  • Central order block for customer
  • ?
  • Client
  • I_BPCUSTOMERGENERALADDRESSINFO.ORDERISBLOCKEDFORCUSTOMER == TVAST.AUFSP
  • I_BPCUSTOMERGENERALADDRESSINFO.[column in domain "SPRAS"] == TVAST.SPRAS
  • I_BPCUSTOMERGENERALADDRESSINFO.MANDT == TVAST.MANDT
Plant
  • Client
  • Plant
  • I_BPCUSTOMERGENERALADDRESSINFO.MANDT == T001W.MANDT
  • I_BPCUSTOMERGENERALADDRESSINFO.PLANT == T001W.WERKS
Account Number of Supplier
  • Account Number of Supplier
  • Client
  • I_BPCUSTOMERGENERALADDRESSINFO.SUPPLIER == LFA1.LIFNR
  • I_BPCUSTOMERGENERALADDRESSINFO.MANDT == LFA1.MANDT