I_Customer

Customer | view: I_CUSTOMER_CDS | ATTR | Extraction: Full or Incremental | Component: Business Partners
Tables used: KNA1
Column Name Description
Customer Customer Number
Column Name Description
Column Name Description
Column Name Description
CreationDate Date on which the Record Was Created
Column Name Description
PostingIsBlocked Central posting block Show values
IsOneTimeAccount Indicator: Is the account a one-time account? Show values
DataMediumExchangeIndicator Report key for data medium exchange Show values
VATLiability Liable for VAT Show values
IsBusinessPurposeCompleted Business Purpose Completed Flag Show values
NFPartnerIsNaturalPerson Natural Person Show values
DeletionIndicator Central Deletion Flag for Master Record Show values
DeliveryDateTypeRule Delivery Date Rule Show values
CustomerHasUnloadingPoint Indicator: Unloading points exist Show values
IsCompetitor Indicator: Competitor Show values
TW_CollvBillingIsSupported Consolidated Invoicing for Taiwan Show values
AlternativePayeeIsAllowed Indicator: Is an alternative payer allowed in document? Show values
Column Name Description Domain name
CustomerName Name of Customer TEXT80
CustomerFullName Customer Full Name TEXT220
CreatedByUser Name of Person who Created the Object USNAM
AddressID Address ADRNR
VATRegistration VAT Registration Number STCEG
AuthorizationGroup Authorization Group BRGRU
InternationalLocationNumber1 International location number (part 1) NUM07
TaxNumber1 Tax Number 1 STCD1
TaxNumber2 Tax Number 2 STCD2
TaxNumber3 Tax Number 3 CHAR18
TaxNumber4 Tax Number 4 CHAR18
TaxNumber5 Tax Number 5 CHAR60
TaxNumber6 Tax Number 6 CHAR20
CustomerCorporateGroup Group key KONZS
OrganizationBPName1 Name 1 NAME
OrganizationBPName2 Name 2 NAME
CityName City TEXT35
PostalCode Postal Code PSTLZ
StreetName Street and House Number TEXT35
SortField Sort field CHAR10
FaxNumber Fax Number TEXT31
BR_SUFRAMACode Suframa Code J_1BSUFRAMA
TelephoneNumber1 First telephone number TEXT16
TelephoneNumber2 Second telephone number TEXT16
ExpressTrainStationName Express train station BAHNH
TrainStationName Train station BAHNH
InternationalLocationNumber2 International location number (Part 2) NUM05
InternationalLocationNumber3 Check digit for the international location number NUM01
TaxInvoiceRepresentativeName Name of Representative REPRES
Master Data Relations | to Other Relations ↓ Join Conditions
Account Number of an Alternative Payer
  • Account Number of an Alternative Payer
  • Client
  • I_CUSTOMER.ALTERNATIVEPAYERACCOUNT == KNA1.KUNNR
  • I_CUSTOMER.MANDT == KNA1.MANDT
Central billing block for customer
  • Central billing block for customer
  • Client
  • I_CUSTOMER.BILLINGISBLOCKEDFORCUSTOMER == TVFS.FAKSP
  • I_CUSTOMER.MANDT == TVFS.MANDT
City Code
  • Country/Region Key
  • City Code
  • Client
  • Region (State, Province, County)
  • I_CUSTOMER.COUNTRY == T005G.LAND1
  • I_CUSTOMER.CITYCODE == T005G.CITYC
  • I_CUSTOMER.MANDT == T005G.MANDT
  • I_CUSTOMER.REGION == T005G.REGIO
Country/Region Key
  • Country/Region Key
  • Client
  • I_CUSTOMER.COUNTRY == T005.LAND1
  • I_CUSTOMER.MANDT == T005.MANDT
County Code
  • County Code
  • Country/Region Key
  • Client
  • Region (State, Province, County)
  • I_CUSTOMER.COUNTY == T005E.COUNC
  • I_CUSTOMER.COUNTRY == T005E.LAND1
  • I_CUSTOMER.MANDT == T005E.MANDT
  • I_CUSTOMER.REGION == T005E.REGIO
Customer Account Group
  • Customer Account Group
  • Client
  • I_CUSTOMER.CUSTOMERACCOUNTGROUP == T077D.KTOKD
  • I_CUSTOMER.MANDT == T077D.MANDT
Customer Classification
  • Customer Classification
  • Client
  • I_CUSTOMER.CUSTOMERCLASSIFICATION == TKUKL.KUKLA
  • I_CUSTOMER.MANDT == TKUKL.MANDT
Working Time Calendar I_CUSTOMER.CUSTOMERWORKINGTIMECALENDAR == TFACD.IDENT
Central delivery block for the customer
  • Central delivery block for the customer
  • Client
  • I_CUSTOMER.DELIVERYISBLOCKED == TVLS.LIFSP
  • I_CUSTOMER.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_CUSTOMER.FISCALADDRESS == KNA1.KUNNR
  • I_CUSTOMER.MANDT == KNA1.MANDT
Attribute 1
  • Attribute 1
  • Client
  • I_CUSTOMER.FREEDEFINEDATTRIBUTE01 == TVK1.KATR1
  • I_CUSTOMER.MANDT == TVK1.MANDT
Attribute 2
  • Attribute 2
  • Client
  • I_CUSTOMER.FREEDEFINEDATTRIBUTE02 == TVK2.KATR2
  • I_CUSTOMER.MANDT == TVK2.MANDT
Attribute 3
  • Attribute 3
  • Client
  • I_CUSTOMER.FREEDEFINEDATTRIBUTE03 == TVK3.KATR3
  • I_CUSTOMER.MANDT == TVK3.MANDT
Attribute 4
  • Attribute 4
  • Client
  • I_CUSTOMER.FREEDEFINEDATTRIBUTE04 == TVK4.KATR4
  • I_CUSTOMER.MANDT == TVK4.MANDT
Attribute 5
  • Attribute 5
  • Client
  • I_CUSTOMER.FREEDEFINEDATTRIBUTE05 == TVK5.KATR5
  • I_CUSTOMER.MANDT == TVK5.MANDT
Attribute 6
  • Attribute 6
  • Client
  • I_CUSTOMER.FREEDEFINEDATTRIBUTE06 == TVK6.KATR6
  • I_CUSTOMER.MANDT == TVK6.MANDT
Attribute 7
  • Attribute 7
  • Client
  • I_CUSTOMER.FREEDEFINEDATTRIBUTE07 == TVK7.KATR7
  • I_CUSTOMER.MANDT == TVK7.MANDT
Attribute 8
  • Attribute 8
  • Client
  • I_CUSTOMER.FREEDEFINEDATTRIBUTE08 == TVK8.KATR8
  • I_CUSTOMER.MANDT == TVK8.MANDT
Attribute 9
  • Attribute 9
  • Client
  • I_CUSTOMER.FREEDEFINEDATTRIBUTE09 == TVK9.KATR9
  • I_CUSTOMER.MANDT == TVK9.MANDT
Attribute 10
  • Attribute 10
  • Client
  • I_CUSTOMER.FREEDEFINEDATTRIBUTE10 == TVK0.KATR10
  • I_CUSTOMER.MANDT == TVK0.MANDT
Industry key
  • Industry key
  • Client
  • I_CUSTOMER.INDUSTRY == T016.BRSCH
  • I_CUSTOMER.MANDT == T016.MANDT
Industry code 1
  • Industry code 1
  • Client
  • I_CUSTOMER.INDUSTRYCODE1 == TBRC.BRACO
  • I_CUSTOMER.MANDT == TBRC.MANDT
Industry code 2
  • Industry code 2
  • Client
  • I_CUSTOMER.INDUSTRYCODE2 == TBRC.BRACO
  • I_CUSTOMER.MANDT == TBRC.MANDT
Industry code 3
  • Industry code 3
  • Client
  • I_CUSTOMER.INDUSTRYCODE3 == TBRC.BRACO
  • I_CUSTOMER.MANDT == TBRC.MANDT
Industry code 4
  • Industry code 4
  • Client
  • I_CUSTOMER.INDUSTRYCODE4 == TBRC.BRACO
  • I_CUSTOMER.MANDT == TBRC.MANDT
Industry code 5
  • Industry code 5
  • Client
  • I_CUSTOMER.INDUSTRYCODE5 == TBRC.BRACO
  • I_CUSTOMER.MANDT == TBRC.MANDT
Language Key I_CUSTOMER.LANGUAGE == T002.SPRAS
Nielsen ID
  • Nielsen ID
  • Client
  • I_CUSTOMER.NIELSENREGION == TNLS.NIELS
  • I_CUSTOMER.MANDT == TNLS.MANDT
Central order block for customer
  • ?
  • Central order block for customer
  • Client
  • I_CUSTOMER.[column in domain "SPRAS"] == TVAST.SPRAS
  • I_CUSTOMER.ORDERISBLOCKEDFORCUSTOMER == TVAST.AUFSP
  • I_CUSTOMER.MANDT == TVAST.MANDT
Region (State, Province, County)
  • Country/Region Key
  • Client
  • Region (State, Province, County)
  • I_CUSTOMER.COUNTRY == T005S.LAND1
  • I_CUSTOMER.MANDT == T005S.MANDT
  • I_CUSTOMER.REGION == T005S.BLAND
Tax Type
  • Tax type
  • ?
  • Client
  • I_CUSTOMER.RESPONSIBLETYPE == J_1AFITP.J_1AFITP
  • I_CUSTOMER.[column in domain "KOART"] == J_1AFITP.KOART
  • I_CUSTOMER.MANDT == J_1AFITP.MANDT
Account Number of Supplier
  • Account Number of Supplier
  • Client
  • I_CUSTOMER.SUPPLIER == LFA1.LIFNR
  • I_CUSTOMER.MANDT == LFA1.MANDT
Tax Jurisdiction
  • ?
  • Tax Jurisdiction
  • Client
  • I_CUSTOMER.[column in domain "TAX_KALSM"] == TTXJ.KALSM
  • I_CUSTOMER.TAXJURISDICTION == TTXJ.TXJCD
  • I_CUSTOMER.MANDT == TTXJ.MANDT
J_1ATODC
  • Tax Number Type
  • Client
  • I_CUSTOMER.TAXNUMBERTYPE == J_1ATODC.J_1ATODC
  • I_CUSTOMER.MANDT == J_1ATODC.MANDT
Company ID of Trading Partner
  • Company ID of Trading Partner
  • Client
  • I_CUSTOMER.TRADINGPARTNER == T880.RCOMP
  • I_CUSTOMER.MANDT == T880.MANDT
Other Relations | to Master Data Relations ↑ Join Conditions
Type of Business
  • Type of Business
  • Client
  • I_CUSTOMER.BUSINESSTYPE == BUSTYPE.GESTYP
  • I_CUSTOMER.MANDT == BUSTYPE.MANDT
Type of Industry
  • Type of Industry
  • Client