I_BPCustRcvgPtAddrDepdntInfo

BP and Cust rcvg pt Addr Depdnt Info | view: IBPCUSTRCVGADDR | Extraction: Not supported | Component: Business Partners
Tables used: BUT020, BUT021_FS, BUT000, BUT000, CVI_CUST_LINK, KNA1, BUT020, WRF12_ADDR, WRF12, BUT021_FS, TB008S, TB008U
Column Name Description
BusinessPartner FK Business Partner Number
AddressID FK Address Number
Customer Customer Number
ReceivingPoint null
Column Name Description
Column Name Description
Column Name Description
Column Name Description
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
UnloadingPointName null
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_BPCUSTRCVGPTADDRDEPDNTINFO.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM
  • I_BPCUSTRCVGPTADDRDEPDNTINFO.MANDT == ADRC.CLIENT
  • I_BPCUSTRCVGPTADDRDEPDNTINFO.ADDRESSID == ADRC.ADDRNUMBER
  • I_BPCUSTRCVGPTADDRDEPDNTINFO.[column in domain "AD_NATION"] == ADRC.NATION
Account Number of an Alternative Payer
  • Account Number of an Alternative Payer
  • Client
  • I_BPCUSTRCVGPTADDRDEPDNTINFO.ALTERNATIVEPAYERACCOUNT == KNA1.KUNNR
  • I_BPCUSTRCVGPTADDRDEPDNTINFO.MANDT == KNA1.MANDT
Central billing block for customer
  • Client
  • Central billing block for customer
  • I_BPCUSTRCVGPTADDRDEPDNTINFO.MANDT == TVFS.MANDT
  • I_BPCUSTRCVGPTADDRDEPDNTINFO.BILLINGISBLOCKEDFORCUSTOMER == TVFS.FAKSP
Business Partner Number
  • Client
  • Business Partner Number
  • I_BPCUSTRCVGPTADDRDEPDNTINFO.MANDT == BUT000.CLIENT
  • I_BPCUSTRCVGPTADDRDEPDNTINFO.BUSINESSPARTNER == BUT000.PARTNER
Customer Account Group
  • Client
  • Customer Account Group
  • I_BPCUSTRCVGPTADDRDEPDNTINFO.MANDT == T077D.MANDT
  • I_BPCUSTRCVGPTADDRDEPDNTINFO.CUSTOMERACCOUNTGROUP == T077D.KTOKD
Customer Classification
  • Customer Classification
  • Client
  • I_BPCUSTRCVGPTADDRDEPDNTINFO.CUSTOMERCLASSIFICATION == TKUKL.KUKLA
  • I_BPCUSTRCVGPTADDRDEPDNTINFO.MANDT == TKUKL.MANDT
Customer Condition Group
  • Client
  • Customer condition group 1
  • I_BPCUSTRCVGPTADDRDEPDNTINFO.MANDT == TVKGG.MANDT
  • I_BPCUSTRCVGPTADDRDEPDNTINFO.CUSTOMERCONDITIONGROUP1 == TVKGG.KDKGR
Customer Condition Group
  • Client
  • Customer condition group 2
  • I_BPCUSTRCVGPTADDRDEPDNTINFO.MANDT == TVKGG.MANDT
  • I_BPCUSTRCVGPTADDRDEPDNTINFO.CUSTOMERCONDITIONGROUP2 == TVKGG.KDKGR
Customer Condition Group
  • Client
  • Customer condition group 3
  • I_BPCUSTRCVGPTADDRDEPDNTINFO.MANDT == TVKGG.MANDT
  • I_BPCUSTRCVGPTADDRDEPDNTINFO.CUSTOMERCONDITIONGROUP3 == TVKGG.KDKGR
Customer Condition Group
  • Customer condition group 4
  • Client
  • I_BPCUSTRCVGPTADDRDEPDNTINFO.CUSTOMERCONDITIONGROUP4 == TVKGG.KDKGR
  • I_BPCUSTRCVGPTADDRDEPDNTINFO.MANDT == TVKGG.MANDT
Customer Condition Group
  • Client
  • Customer condition group 5
  • I_BPCUSTRCVGPTADDRDEPDNTINFO.MANDT == TVKGG.MANDT
  • I_BPCUSTRCVGPTADDRDEPDNTINFO.CUSTOMERCONDITIONGROUP5 == TVKGG.KDKGR
Central delivery block for the customer
  • Client
  • Central delivery block for the customer
  • I_BPCUSTRCVGPTADDRDEPDNTINFO.MANDT == TVLS.MANDT
  • I_BPCUSTRCVGPTADDRDEPDNTINFO.DELIVERYISBLOCKED == TVLS.LIFSP
Account number of the master record with the fiscal address
  • Account number of the master record with the fiscal address
  • Client
  • I_BPCUSTRCVGPTADDRDEPDNTINFO.FISCALADDRESS == KNA1.KUNNR
  • I_BPCUSTRCVGPTADDRDEPDNTINFO.MANDT == KNA1.MANDT
Attribute 3
  • Client
  • Attribute 3
  • I_BPCUSTRCVGPTADDRDEPDNTINFO.MANDT == TVK3.MANDT
  • I_BPCUSTRCVGPTADDRDEPDNTINFO.FREEDEFINEDATTRIBUTE03 == TVK3.KATR3
Industry code 1
  • Client
  • Industry code 1
  • I_BPCUSTRCVGPTADDRDEPDNTINFO.MANDT == TBRC.MANDT
  • I_BPCUSTRCVGPTADDRDEPDNTINFO.INDUSTRYCODE1 == TBRC.BRACO
Industry code 2
  • Industry code 2
  • Client
  • I_BPCUSTRCVGPTADDRDEPDNTINFO.INDUSTRYCODE2 == TBRC.BRACO
  • I_BPCUSTRCVGPTADDRDEPDNTINFO.MANDT == TBRC.MANDT
Industry code 3
  • Client
  • Industry code 3
  • I_BPCUSTRCVGPTADDRDEPDNTINFO.MANDT == TBRC.MANDT
  • I_BPCUSTRCVGPTADDRDEPDNTINFO.INDUSTRYCODE3 == TBRC.BRACO
Central order block for customer
  • Client
  • Central order block for customer
  • ?
  • I_BPCUSTRCVGPTADDRDEPDNTINFO.MANDT == TVAST.MANDT
  • I_BPCUSTRCVGPTADDRDEPDNTINFO.ORDERISBLOCKEDFORCUSTOMER == TVAST.AUFSP
  • I_BPCUSTRCVGPTADDRDEPDNTINFO.[column in domain "SPRAS"] == TVAST.SPRAS
Plant
  • Client
  • Plant
  • I_BPCUSTRCVGPTADDRDEPDNTINFO.MANDT == T001W.MANDT
  • I_BPCUSTRCVGPTADDRDEPDNTINFO.PLANT == T001W.WERKS
Account Number of Supplier
  • Client
  • Account Number of Supplier
  • I_BPCUSTRCVGPTADDRDEPDNTINFO.MANDT == LFA1.MANDT
  • I_BPCUSTRCVGPTADDRDEPDNTINFO.SUPPLIER == LFA1.LIFNR