I_BusinessPartnerCustomer

Business Partner Customer | view: IBUPACUSTOMER | ATTR | Extraction: Full or Incremental | Component: Business Partners
Tables used: BUT000, CVI_CUST_LINK, KNA1
Column Name Description
Customer Customer Number
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
IsActiveEntity Draft - Indicator - Is active document 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
CustomerHasUnloadingPoint Indicator: Unloading points exist Show values
IsBusinessPurposeCompleted Business Purpose Completed Flag Show values
BPIsEqualizationTaxSubject Checkbox Show values
DeletionIndicator Central Deletion Flag for Master Record Show values
Column Name Description Domain name
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
AddressID Address ADRNR
InternationalLocationNumber1 International location number (part 1) NUM07
InternationalLocationNumber2 International location number (Part 2) NUM05
InternationalLocationNumber3 Check digit for the international location number NUM01
SalesIsBlockedForCustomer null
PaymentReason Payment Reason FARP_PAYT_RSN
Master Data Relations Join Conditions
Account Number of an Alternative Payer
  • Client
  • Account Number of an Alternative Payer
  • I_BUSINESSPARTNERCUSTOMER.MANDT == KNA1.MANDT
  • I_BUSINESSPARTNERCUSTOMER.ALTERNATIVEPAYERACCOUNT == KNA1.KUNNR
Central billing block for customer
  • Client
  • Central billing block for customer
  • I_BUSINESSPARTNERCUSTOMER.MANDT == TVFS.MANDT
  • I_BUSINESSPARTNERCUSTOMER.BILLINGISBLOCKEDFORCUSTOMER == TVFS.FAKSP
Business Partner Grouping
  • Client
  • Business Partner Grouping
  • I_BUSINESSPARTNERCUSTOMER.MANDT == TB001.MANDT
  • I_BUSINESSPARTNERCUSTOMER.BUSINESSPARTNERGROUPING == TB001.BU_GROUP
City Code
  • Client
  • Country/Region Key
  • Region (State, Province, County)
  • City Code
  • I_BUSINESSPARTNERCUSTOMER.MANDT == T005G.MANDT
  • I_BUSINESSPARTNERCUSTOMER.COUNTRY == T005G.LAND1
  • I_BUSINESSPARTNERCUSTOMER.REGION == T005G.REGIO
  • I_BUSINESSPARTNERCUSTOMER.CITYCODE == T005G.CITYC
Country/Region Key
  • Client
  • Country/Region Key
  • I_BUSINESSPARTNERCUSTOMER.MANDT == T005.MANDT
  • I_BUSINESSPARTNERCUSTOMER.COUNTRY == T005.LAND1
County Code
  • Client
  • Country/Region Key
  • Region (State, Province, County)
  • County Code
  • I_BUSINESSPARTNERCUSTOMER.MANDT == T005E.MANDT
  • I_BUSINESSPARTNERCUSTOMER.COUNTRY == T005E.LAND1
  • I_BUSINESSPARTNERCUSTOMER.REGION == T005E.REGIO
  • I_BUSINESSPARTNERCUSTOMER.COUNTY == T005E.COUNC
Customer Account Group
  • Client
  • Customer Account Group
  • I_BUSINESSPARTNERCUSTOMER.MANDT == T077D.MANDT
  • I_BUSINESSPARTNERCUSTOMER.CUSTOMERACCOUNTGROUP == T077D.KTOKD
Customer Classification
  • Client
  • Customer Classification
  • I_BUSINESSPARTNERCUSTOMER.MANDT == TKUKL.MANDT
  • I_BUSINESSPARTNERCUSTOMER.CUSTOMERCLASSIFICATION == TKUKL.KUKLA
Customer Condition Group
  • Customer condition group 1
  • Client
  • I_BUSINESSPARTNERCUSTOMER.CUSTOMERCONDITIONGROUP1 == TVKGG.KDKGR
  • I_BUSINESSPARTNERCUSTOMER.MANDT == TVKGG.MANDT
Customer Condition Group
  • Client
  • Customer condition group 2
  • I_BUSINESSPARTNERCUSTOMER.MANDT == TVKGG.MANDT
  • I_BUSINESSPARTNERCUSTOMER.CUSTOMERCONDITIONGROUP2 == TVKGG.KDKGR
Customer Condition Group
  • Client
  • Customer condition group 3
  • I_BUSINESSPARTNERCUSTOMER.MANDT == TVKGG.MANDT
  • I_BUSINESSPARTNERCUSTOMER.CUSTOMERCONDITIONGROUP3 == TVKGG.KDKGR
Customer Condition Group
  • Client
  • Customer condition group 4
  • I_BUSINESSPARTNERCUSTOMER.MANDT == TVKGG.MANDT
  • I_BUSINESSPARTNERCUSTOMER.CUSTOMERCONDITIONGROUP4 == TVKGG.KDKGR
Customer Condition Group
  • Customer condition group 5
  • Client
  • I_BUSINESSPARTNERCUSTOMER.CUSTOMERCONDITIONGROUP5 == TVKGG.KDKGR
  • I_BUSINESSPARTNERCUSTOMER.MANDT == TVKGG.MANDT
Working Time Calendar I_BUSINESSPARTNERCUSTOMER.CUSTOMERWORKINGTIMECALENDAR == TFACD.IDENT
Central delivery block for the customer
  • Central delivery block for the customer
  • Client
  • I_BUSINESSPARTNERCUSTOMER.DELIVERYISBLOCKED == TVLS.LIFSP
  • I_BUSINESSPARTNERCUSTOMER.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_BUSINESSPARTNERCUSTOMER.FISCALADDRESS == KNA1.KUNNR
  • I_BUSINESSPARTNERCUSTOMER.MANDT == KNA1.MANDT
Attribute 3
  • Client
  • Attribute 3
  • I_BUSINESSPARTNERCUSTOMER.MANDT == TVK3.MANDT
  • I_BUSINESSPARTNERCUSTOMER.FREEDEFINEDATTRIBUTE03 == TVK3.KATR3
Industry code 1
  • Client
  • Industry code 1
  • I_BUSINESSPARTNERCUSTOMER.MANDT == TBRC.MANDT
  • I_BUSINESSPARTNERCUSTOMER.INDUSTRYCODE1 == TBRC.BRACO
Industry code 2
  • Client
  • Industry code 2
  • I_BUSINESSPARTNERCUSTOMER.MANDT == TBRC.MANDT
  • I_BUSINESSPARTNERCUSTOMER.INDUSTRYCODE2 == TBRC.BRACO
Industry code 3
  • Client
  • Industry code 3
  • I_BUSINESSPARTNERCUSTOMER.MANDT == TBRC.MANDT
  • I_BUSINESSPARTNERCUSTOMER.INDUSTRYCODE3 == TBRC.BRACO
Language Key I_BUSINESSPARTNERCUSTOMER.LANGUAGE == T002.SPRAS
Central order block for customer
  • ?
  • Client
  • Central order block for customer
  • I_BUSINESSPARTNERCUSTOMER.[column in domain "SPRAS"] == TVAST.SPRAS
  • I_BUSINESSPARTNERCUSTOMER.MANDT == TVAST.MANDT
  • I_BUSINESSPARTNERCUSTOMER.ORDERISBLOCKEDFORCUSTOMER == TVAST.AUFSP
Plant
  • Client
  • Plant
  • I_BUSINESSPARTNERCUSTOMER.MANDT == T001W.MANDT
  • I_BUSINESSPARTNERCUSTOMER.PLANT == T001W.WERKS
Region (State, Province, County)
  • Client
  • Country/Region Key
  • Region (State, Province, County)
  • I_BUSINESSPARTNERCUSTOMER.MANDT == T005S.MANDT
  • I_BUSINESSPARTNERCUSTOMER.COUNTRY == T005S.LAND1
  • I_BUSINESSPARTNERCUSTOMER.REGION == T005S.BLAND
Account Number of Supplier
  • Client
  • Account Number of Supplier
  • I_BUSINESSPARTNERCUSTOMER.MANDT == LFA1.MANDT
  • I_BUSINESSPARTNERCUSTOMER.SUPPLIER == LFA1.LIFNR