I_BPCustDeptAddrDepdntInfo

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