0CUSTOMER_ATTR

Customer Number | #ATTR | Extraction method: F1 | Delta: E | Component: Logistics Master Data
Tables used: KNA1, LFA1, KNVK, T001W, LFB1 ... +11 more
Column Name Description
KUNNR Customer Number
LIFNR FK Account Number of Supplier
WERKS FK Plant
Column Name Description
💲 Currency of sales figure (UWAER):
UMSAT Annual sales
UMSA1 Annual sales
Column Name Description
Column Name Description
ERDAT Date on which the Record Was Created
Column Name Description
EXABL Indicator: Unloading points exist Show values
LOEVM Central Deletion Flag for Master Record Show values
SPERR Central posting block Show values
STKZA Indicator: Business Partner Subject to Equalization Tax? Show values
STKZU Liable for VAT Show values
XCPDK Indicator: Is the account a one-time account? Show values
XZEMP Indicator: Alternative Payee in Document Allowed? Show values
DEAR1 Indicator: Competitor Show values
DEAR2 Indicator: Sales partner Show values
DEAR3 Indicator: Sales prospect Show values
DEAR4 Indicator for customer type 4 Show values
DEAR5 ID for default sold-to party Show values
DEAR6 Indicator: Consumer Show values
STKZN Natural Person Show values
INSPBYDEBI Inspection Carried Out By Customer (No Inspection Lot) Show values
INSPATDEBI Inspection for a Delivery Note After Outbound Delivery Show values
DTAMS Report key for data medium exchange Show values
DUEFL Status of Data Transfer into Subsequent Release Show values
SPERZ Payment Block Show values
CIVVE ID for mainly non-military use Show values
MILVE ID for mainly military use Show values
XKNZA Indicator: Alternative payer using account number Show values
XICMS Customer is ICMS-exempt Show values
XXIPI Customer is IPI-exempt Show values
CFOPC Customer's CFOP category Show values
CCC01 Indicator for biochemical warfare for legal control Show values
CCC02 Indicator for nuclear nonproliferation for legal control Show values
CCC03 Indicator for national security for legal control Show values
CCC04 Indicator for missile technology for legal control Show values
Column Name Description Domain name
ADRNR Address ADRNR
ANRED Title TEXT15
BAHNE Express train station BAHNH
BAHNS Train station BAHNH
BBBNR International location number (part 1) NUM07
BBSNR International location number (Part 2) NUM05
BEGRU Authorization Group BRGRU
BUBKZ Check digit for the international location number NUM01
DATLT Data communication line no. TEXT14
ERNAM Name of Person who Created the Object USNAM
KONZS Group key KONZS
LOCCO City Coordinates LOCCO
NAME1 Name 1 NAME
NAME2 Name 2 NAME
NAME3 Name 3 NAME
NAME4 Name 4 NAME
ORT01 City TEXT35
ORT02 District TEXT35
PFACH PO Box PFACH
PSTL2 P.O. Box Postal Code PSTLZ
PSTLZ Postal Code PSTLZ
RPMKR Regional market RPMKR
SORTL Sort field CHAR10
STCD1 Tax Number 1 STCD1
STCD2 Tax Number 2 STCD2
STRAS Street and House Number TEXT35
TELBX Telebox number TEXT15
TELF1 First telephone number TEXT16
TELF2 Second telephone number TEXT16
TELFX Fax Number TEXT31
TELTX Teletex number TEXT30
TELX1 Telex number TEXT30
STCEG VAT Registration Number STCEG
EKONT Initial contact VBELN
UMJAH Year For Which Sales are Given JAHR
JMZAH Yearly number of employees JMZAH
JMJAH Year for which the number of employees is given JAHR
MCOD1 Search term for matchcode search CHAR25
MCOD2 Search Term for Matchcode Search CHAR25
MCOD3 Search term for matchcode search CHAR25
PFORT PO Box city TEXT35
DTAWS Instruction Key for Data Medium Exchange DTAWS
HZUOR Assignment to Hierarchy HZUOR
STCD3 Tax Number 3 CHAR18
STCD4 Tax Number 4 CHAR18
CASSD Central sales block for customer CASSP
KNURL Uniform resource locator TEXT132
Master Data Relations Join Conditions
Usage Indicator
  • Client
  • Usage Indicator
  • 0CUSTOMER_ATTR.MANDT == TVLV.MANDT
  • 0CUSTOMER_ATTR.ABRVW == TVLV.ABRVW
Central order block for customer
  • Client
  • ?
  • Central order block for customer
  • 0CUSTOMER_ATTR.MANDT == TVAST.MANDT
  • 0CUSTOMER_ATTR.[column in domain "SPRAS"] == TVAST.SPRAS
  • 0CUSTOMER_ATTR.AUFSD == TVAST.AUFSP
Industry code 1
  • Client
  • Industry code 1
  • 0CUSTOMER_ATTR.MANDT == TBRC.MANDT
  • 0CUSTOMER_ATTR.BRAN1 == TBRC.BRACO
Industry code 2
  • Client
  • Industry code 2
  • 0CUSTOMER_ATTR.MANDT == TBRC.MANDT
  • 0CUSTOMER_ATTR.BRAN2 == TBRC.BRACO
Industry code 3
  • Client
  • Industry code 3
  • 0CUSTOMER_ATTR.MANDT == TBRC.MANDT
  • 0CUSTOMER_ATTR.BRAN3 == TBRC.BRACO
Industry code 4
  • Client
  • Industry code 4
  • 0CUSTOMER_ATTR.MANDT == TBRC.MANDT
  • 0CUSTOMER_ATTR.BRAN4 == TBRC.BRACO
Industry code 5
  • Client
  • Industry code 5
  • 0CUSTOMER_ATTR.MANDT == TBRC.MANDT
  • 0CUSTOMER_ATTR.BRAN5 == TBRC.BRACO
Industry key
  • Client
  • Industry key
  • 0CUSTOMER_ATTR.MANDT == T016.MANDT
  • 0CUSTOMER_ATTR.BRSCH == T016.BRSCH
City Code
  • Client
  • City Code
  • Country/Region Key
  • Region (State, Province, County)
  • 0CUSTOMER_ATTR.MANDT == T005G.MANDT
  • 0CUSTOMER_ATTR.CITYC == T005G.CITYC
  • 0CUSTOMER_ATTR.LAND1 == T005G.LAND1
  • 0CUSTOMER_ATTR.REGIO == T005G.REGIO
County Code
  • Client
  • County Code
  • Country/Region Key
  • Region (State, Province, County)
  • 0CUSTOMER_ATTR.MANDT == T005E.MANDT
  • 0CUSTOMER_ATTR.COUNC == T005E.COUNC
  • 0CUSTOMER_ATTR.LAND1 == T005E.LAND1
  • 0CUSTOMER_ATTR.REGIO == T005E.REGIO
IS-R Labeling: customer/plant group
  • Client
  • IS-R Labeling: customer/plant group
  • 0CUSTOMER_ATTR.MANDT == TWEK.MANDT
  • 0CUSTOMER_ATTR.ETIKG == TWEK.KUNGR
Central billing block for customer
  • Client
  • Central billing block for customer
  • 0CUSTOMER_ATTR.MANDT == TVFS.MANDT
  • 0CUSTOMER_ATTR.FAKSD == TVFS.FAKSP
Account number of the master record with the fiscal address
  • Client
  • Account number of the master record with the fiscal address
  • 0CUSTOMER_ATTR.MANDT == KNA1.MANDT
  • 0CUSTOMER_ATTR.FISKN == KNA1.KUNNR
Tax Type
  • ?
  • Client
  • Tax type
  • 0CUSTOMER_ATTR.[column in domain "KOART"] == J_1AFITP.KOART
  • 0CUSTOMER_ATTR.MANDT == J_1AFITP.MANDT
  • 0CUSTOMER_ATTR.FITYP == J_1AFITP.J_1AFITP
Legal status
  • Client
  • Legal status
  • 0CUSTOMER_ATTR.MANDT == TVGF.MANDT
  • 0CUSTOMER_ATTR.GFORM == TVGF.GFORM
Attribute 1
  • Client
  • Attribute 1
  • 0CUSTOMER_ATTR.MANDT == TVK1.MANDT
  • 0CUSTOMER_ATTR.KATR1 == TVK1.KATR1
Attribute 10
  • Client
  • Attribute 10
  • 0CUSTOMER_ATTR.MANDT == TVK0.MANDT
  • 0CUSTOMER_ATTR.KATR10 == TVK0.KATR10
Attribute 2
  • Client
  • Attribute 2
  • 0CUSTOMER_ATTR.MANDT == TVK2.MANDT
  • 0CUSTOMER_ATTR.KATR2 == TVK2.KATR2
Attribute 3
  • Client
  • Attribute 3
  • 0CUSTOMER_ATTR.MANDT == TVK3.MANDT
  • 0CUSTOMER_ATTR.KATR3 == TVK3.KATR3
Attribute 4
  • Client
  • Attribute 4
  • 0CUSTOMER_ATTR.MANDT == TVK4.MANDT
  • 0CUSTOMER_ATTR.KATR4 == TVK4.KATR4
Attribute 5
  • Client
  • Attribute 5
  • 0CUSTOMER_ATTR.MANDT == TVK5.MANDT
  • 0CUSTOMER_ATTR.KATR5 == TVK5.KATR5
Attribute 6
  • Client
  • Attribute 6
  • 0CUSTOMER_ATTR.MANDT == TVK6.MANDT
  • 0CUSTOMER_ATTR.KATR6 == TVK6.KATR6
Attribute 7
  • Client
  • Attribute 7
  • 0CUSTOMER_ATTR.MANDT == TVK7.MANDT
  • 0CUSTOMER_ATTR.KATR7 == TVK7.KATR7
Attribute 8
  • Client
  • Attribute 8
  • 0CUSTOMER_ATTR.MANDT == TVK8.MANDT
  • 0CUSTOMER_ATTR.KATR8 == TVK8.KATR8
Attribute 9
  • Client
  • Attribute 9
  • 0CUSTOMER_ATTR.MANDT == TVK9.MANDT
  • 0CUSTOMER_ATTR.KATR9 == TVK9.KATR9
Customer Condition Group
  • Client
  • Customer condition group 1
  • 0CUSTOMER_ATTR.MANDT == TVKGG.MANDT
  • 0CUSTOMER_ATTR.KDKG1 == TVKGG.KDKGR
Customer Condition Group
  • Client
  • Customer condition group 2
  • 0CUSTOMER_ATTR.MANDT == TVKGG.MANDT
  • 0CUSTOMER_ATTR.KDKG2 == TVKGG.KDKGR
Customer Condition Group
  • Client
  • Customer condition group 3
  • 0CUSTOMER_ATTR.MANDT == TVKGG.MANDT
  • 0CUSTOMER_ATTR.KDKG3 == TVKGG.KDKGR
Customer Condition Group
  • Client
  • Customer condition group 4
  • 0CUSTOMER_ATTR.MANDT == TVKGG.MANDT
  • 0CUSTOMER_ATTR.KDKG4 == TVKGG.KDKGR
Customer Condition Group
  • Client
  • Customer condition group 5
  • 0CUSTOMER_ATTR.MANDT == TVKGG.MANDT
  • 0CUSTOMER_ATTR.KDKG5 == TVKGG.KDKGR
Working Time Calendar 0CUSTOMER_ATTR.KNAZK == TFACD.IDENT
Account Number of an Alternative Payer
  • Client
  • Account Number of an Alternative Payer
  • 0CUSTOMER_ATTR.MANDT == KNA1.MANDT
  • 0CUSTOMER_ATTR.KNRZA == KNA1.KUNNR
Reference Account Group for One-Time Account (Customer)
  • Client
  • Reference Account Group for One-Time Account (Customer)
  • 0CUSTOMER_ATTR.MANDT == T077D.MANDT
  • 0CUSTOMER_ATTR.KTOCD == T077D.KTOKD
Customer Account Group
  • Client
  • Customer Account Group
  • 0CUSTOMER_ATTR.MANDT == T077D.MANDT
  • 0CUSTOMER_ATTR.KTOKD == T077D.KTOKD
Customer Classification
  • Client
  • Customer Classification
  • 0CUSTOMER_ATTR.MANDT == TKUKL.MANDT
  • 0CUSTOMER_ATTR.KUKLA == TKUKL.KUKLA
Country/Region Key
  • Client
  • Country/Region Key
  • 0CUSTOMER_ATTR.MANDT == T005.MANDT
  • 0CUSTOMER_ATTR.LAND1 == T005.LAND1
Account Number of Supplier
  • Client
  • Account Number of Supplier
  • 0CUSTOMER_ATTR.MANDT == LFA1.MANDT
  • 0CUSTOMER_ATTR.LIFNR == LFA1.LIFNR
Central delivery block for the customer
  • Client
  • Central delivery block for the customer
  • 0CUSTOMER_ATTR.MANDT == TVLS.MANDT
  • 0CUSTOMER_ATTR.LIFSD == TVLS.LIFSP
Transportation zone to or from which the goods are delivered
  • Client
  • Country/Region Key
  • Transportation zone to or from which the goods are delivered
  • 0CUSTOMER_ATTR.MANDT == TZONE.MANDT
  • 0CUSTOMER_ATTR.LAND1 == TZONE.LAND1
  • 0CUSTOMER_ATTR.LZONE == TZONE.ZONE1
Nielsen ID
  • Client
  • Nielsen ID
  • 0CUSTOMER_ATTR.MANDT == TNLS.MANDT
  • 0CUSTOMER_ATTR.NIELS == TNLS.NIELS
Fiscal Year Variant
  • Client
  • Fiscal Year Variant
  • 0CUSTOMER_ATTR.MANDT == T009.MANDT
  • 0CUSTOMER_ATTR.PERIV == T009.PERIV
Region (State, Province, County)
  • Client
  • Country/Region Key
  • Region (State, Province, County)
  • 0CUSTOMER_ATTR.MANDT == T005S.MANDT
  • 0CUSTOMER_ATTR.LAND1 == T005S.LAND1
  • 0CUSTOMER_ATTR.REGIO == T005S.BLAND
Language Key 0CUSTOMER_ATTR.SPRAS == T002.SPRAS
J_1ATODC
  • Client
  • Tax Number Type
  • 0CUSTOMER_ATTR.MANDT == J_1ATODC.MANDT
  • 0CUSTOMER_ATTR.STCDT == J_1ATODC.J_1ATODC
Tax Jurisdiction
  • ?
  • Client
  • Tax Jurisdiction
  • 0CUSTOMER_ATTR.[column in domain "TAX_KALSM"] == TTXJ.KALSM
  • 0CUSTOMER_ATTR.MANDT == TTXJ.MANDT
  • 0CUSTOMER_ATTR.TXJCD == TTXJ.TXJCD
Tax Law 1
  • Client
  • Tax law: ICMS
Tax Law 2
  • Client
  • Tax law: IPI
Currency of sales figure
  • Client
  • Currency of sales figure
  • 0CUSTOMER_ATTR.MANDT == TCURC.MANDT
  • 0CUSTOMER_ATTR.UWAER == TCURC.WAERS
Company ID of Trading Partner
  • Client
  • Company ID of Trading Partner
  • 0CUSTOMER_ATTR.MANDT == T880.MANDT
  • 0CUSTOMER_ATTR.VBUND == T880.RCOMP
Plant
  • Client
  • Plant
  • 0CUSTOMER_ATTR.MANDT == T001W.MANDT
  • 0CUSTOMER_ATTR.WERKS == T001W.WERKS
Customer group for Substituiçao Tributária calculation
  • Client
  • Customer group for Substituiçao Tributária calculation