I_BusinessPartnerCustomerTP

BOPF view customer root | view: IBUPACUSTTP | Extraction: Not supported | Component: Business Partners
Tables used: BP001, BUT000, BUT000, CVI_CUST_LINK, KNA1, TB003, BUT100
Column Name Description
BusinessPartner Business Partner Number
Column Name Description
Column Name Description
Column Name Description
Column Name Description
DataMediumExchangeIndicator Report key for data medium exchange Show values
VATLiability Liable for VAT Show values
PostingIsBlocked Central posting block 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
BPIsEqualizationTaxSubject Checkbox Show values
SalesIsBlockedForCustomer Checkbox Show values
DeletionIndicator Central Deletion Flag for Master Record Show values
Column Name Description Domain name
Customer Customer Number KUNNR
BusinessPartnerForEdit Business Partner Number BU_PARTNER
BusinessPartnerUUID Business Partner GUID SYSUUID
AuthorizationGroup Authorization Group BRGRU
ExpressTrainStationName Express train station BAHNH
TrainStationName Train station BAHNH
CityLocationCoordinatesCode City Coordinates LOCCO
CustomerCorporateGroup Group key KONZS
DataExchangeInstructionKey Instruction Key for Data Medium Exchange DTAWS
PaymentReason Payment Reason FARP_PAYT_RSN
Region Region (State, Province, County) REGIO
Country Country/Region Key LAND1
Master Data Relations Join Conditions
Account Number of an Alternative Payer
  • Account Number of an Alternative Payer
  • Client
  • I_BUSINESSPARTNERCUSTOMERTP.ALTERNATIVEPAYERACCOUNT == KNA1.KUNNR
  • I_BUSINESSPARTNERCUSTOMERTP.MANDT == KNA1.MANDT
Central billing block for customer
  • Client
  • Central billing block for customer
  • I_BUSINESSPARTNERCUSTOMERTP.MANDT == TVFS.MANDT
  • I_BUSINESSPARTNERCUSTOMERTP.BILLINGISBLOCKEDFORCUSTOMER == TVFS.FAKSP
City Code
  • ?
  • Client
  • City Code
  • ?
  • I_BUSINESSPARTNERCUSTOMERTP.[column in domain "REGIO"] == T005G.REGIO
  • I_BUSINESSPARTNERCUSTOMERTP.MANDT == T005G.MANDT
  • I_BUSINESSPARTNERCUSTOMERTP.CITYCODE == T005G.CITYC
  • I_BUSINESSPARTNERCUSTOMERTP.[column in domain "LAND1"] == T005G.LAND1
County Code
  • County Code
  • ?
  • Client
  • ?
  • I_BUSINESSPARTNERCUSTOMERTP.COUNTY == T005E.COUNC
  • I_BUSINESSPARTNERCUSTOMERTP.[column in domain "REGIO"] == T005E.REGIO
  • I_BUSINESSPARTNERCUSTOMERTP.MANDT == T005E.MANDT
  • I_BUSINESSPARTNERCUSTOMERTP.[column in domain "LAND1"] == T005E.LAND1
Customer Account Group
  • Customer Account Group
  • Client
  • I_BUSINESSPARTNERCUSTOMERTP.CUSTOMERACCOUNTGROUP == T077D.KTOKD
  • I_BUSINESSPARTNERCUSTOMERTP.MANDT == T077D.MANDT
Customer Classification
  • Customer Classification
  • Client
  • I_BUSINESSPARTNERCUSTOMERTP.CUSTOMERCLASSIFICATION == TKUKL.KUKLA
  • I_BUSINESSPARTNERCUSTOMERTP.MANDT == TKUKL.MANDT
Customer Condition Group
  • Customer condition group 1
  • Client
  • I_BUSINESSPARTNERCUSTOMERTP.CUSTOMERCONDITIONGROUP1 == TVKGG.KDKGR
  • I_BUSINESSPARTNERCUSTOMERTP.MANDT == TVKGG.MANDT
Customer Condition Group
  • Customer condition group 2
  • Client
  • I_BUSINESSPARTNERCUSTOMERTP.CUSTOMERCONDITIONGROUP2 == TVKGG.KDKGR
  • I_BUSINESSPARTNERCUSTOMERTP.MANDT == TVKGG.MANDT
Customer Condition Group
  • Customer condition group 3
  • Client
  • I_BUSINESSPARTNERCUSTOMERTP.CUSTOMERCONDITIONGROUP3 == TVKGG.KDKGR
  • I_BUSINESSPARTNERCUSTOMERTP.MANDT == TVKGG.MANDT
Customer Condition Group
  • Customer condition group 4
  • Client
  • I_BUSINESSPARTNERCUSTOMERTP.CUSTOMERCONDITIONGROUP4 == TVKGG.KDKGR
  • I_BUSINESSPARTNERCUSTOMERTP.MANDT == TVKGG.MANDT
Customer Condition Group
  • Customer condition group 5
  • Client
  • I_BUSINESSPARTNERCUSTOMERTP.CUSTOMERCONDITIONGROUP5 == TVKGG.KDKGR
  • I_BUSINESSPARTNERCUSTOMERTP.MANDT == TVKGG.MANDT
Central delivery block for the customer
  • Client
  • Central delivery block for the customer
  • I_BUSINESSPARTNERCUSTOMERTP.MANDT == TVLS.MANDT
  • I_BUSINESSPARTNERCUSTOMERTP.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_BUSINESSPARTNERCUSTOMERTP.FISCALADDRESS == KNA1.KUNNR
  • I_BUSINESSPARTNERCUSTOMERTP.MANDT == KNA1.MANDT
Attribute 3
  • Attribute 3
  • Client
  • I_BUSINESSPARTNERCUSTOMERTP.FREEDEFINEDATTRIBUTE03 == TVK3.KATR3
  • I_BUSINESSPARTNERCUSTOMERTP.MANDT == TVK3.MANDT
Industry code 1
  • Industry code 1
  • Client
  • I_BUSINESSPARTNERCUSTOMERTP.INDUSTRYCODE1 == TBRC.BRACO
  • I_BUSINESSPARTNERCUSTOMERTP.MANDT == TBRC.MANDT
Industry code 2
  • Client
  • Industry code 2
  • I_BUSINESSPARTNERCUSTOMERTP.MANDT == TBRC.MANDT
  • I_BUSINESSPARTNERCUSTOMERTP.INDUSTRYCODE2 == TBRC.BRACO
Industry code 3
  • Industry code 3
  • Client
  • I_BUSINESSPARTNERCUSTOMERTP.INDUSTRYCODE3 == TBRC.BRACO
  • I_BUSINESSPARTNERCUSTOMERTP.MANDT == TBRC.MANDT
Language Key I_BUSINESSPARTNERCUSTOMERTP.LANGUAGE == T002.SPRAS
Central order block for customer
  • Central order block for customer
  • ?
  • Client
  • I_BUSINESSPARTNERCUSTOMERTP.ORDERISBLOCKEDFORCUSTOMER == TVAST.AUFSP
  • I_BUSINESSPARTNERCUSTOMERTP.[column in domain "SPRAS"] == TVAST.SPRAS
  • I_BUSINESSPARTNERCUSTOMERTP.MANDT == TVAST.MANDT
Plant
  • Plant
  • Client
  • I_BUSINESSPARTNERCUSTOMERTP.PLANT == T001W.WERKS
  • I_BUSINESSPARTNERCUSTOMERTP.MANDT == T001W.MANDT
Account Number of Supplier
  • Client
  • Account Number of Supplier
  • I_BUSINESSPARTNERCUSTOMERTP.MANDT == LFA1.MANDT
  • I_BUSINESSPARTNERCUSTOMERTP.SUPPLIER == LFA1.LIFNR
Company ID of Trading Partner
  • Client
  • Company ID of Trading Partner
  • I_BUSINESSPARTNERCUSTOMERTP.MANDT == T880.MANDT
  • I_BUSINESSPARTNERCUSTOMERTP.TRADINGPARTNER == T880.RCOMP