SAP Table KNA1
General Data in Customer Master
KNA1 (General Data in Customer Master) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link KNA1 to other SAP tables.
KNA1 table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
MANDT
Client
|
MANDT | T000 |
CLNT
|
3 | 0 | |||||||||||||||||||||||
|
KUNNR
Customer Number
|
KUNNR |
CHAR
|
10 | 0 | ||||||||||||||||||||||||
|
LAND1
Country Key
|
LAND1_GP | T005 |
CHAR
|
3 | 0 | |||||||||||||||||||||||
|
NAME1
Name 1
|
NAME1_GP |
CHAR
|
35 | 0 | ||||||||||||||||||||||||
|
NAME2
Name 2
|
NAME2_GP |
CHAR
|
35 | 0 | ||||||||||||||||||||||||
|
ORT01
City
|
ORT01_GP |
CHAR
|
35 | 0 | ||||||||||||||||||||||||
|
PSTLZ
Postal Code
|
PSTLZ |
CHAR
|
10 | 0 | ||||||||||||||||||||||||
|
REGIO
Region (State, Province, County)
|
REGIO | T005S |
CHAR
|
3 | 0 | |||||||||||||||||||||||
|
SORTL
Sort field
|
SORTL |
CHAR
|
10 | 0 | ||||||||||||||||||||||||
|
STRAS
House number and street
|
STRAS_GP |
CHAR
|
35 | 0 | ||||||||||||||||||||||||
|
TELF1
First telephone number
|
TELF1 |
CHAR
|
16 | 0 | ||||||||||||||||||||||||
|
TELFX
Fax Number
|
TELFX |
CHAR
|
31 | 0 | ||||||||||||||||||||||||
|
XCPDK
Indicator: Is the account a one-time account?
|
XCPDK |
CHAR
|
1 | 0 | ||||||||||||||||||||||||
|
||||||||||||||||||||||||||||
|
ADRNR
Address
|
ADRNR |
CHAR
|
10 | 0 | ||||||||||||||||||||||||
|
MCOD1
Search term for matchcode search
|
MCDD1 |
CHAR
|
25 | 0 | ||||||||||||||||||||||||
|
MCOD2
Search Term for Matchcode Search
|
MCDD2 |
CHAR
|
25 | 0 | ||||||||||||||||||||||||
|
MCOD3
Search term for matchcode search
|
MCDD3 |
CHAR
|
25 | 0 | ||||||||||||||||||||||||
|
ANRED
Title
|
ANRED |
CHAR
|
15 | 0 | ||||||||||||||||||||||||
|
AUFSD
Central order block for customer
|
AUFSD_X | TVAST |
CHAR
|
2 | 0 | |||||||||||||||||||||||
|
BAHNE
Express train station
|
BAHNE |
CHAR
|
25 | 0 | ||||||||||||||||||||||||
|
BAHNS
Train station
|
BAHNS |
CHAR
|
25 | 0 | ||||||||||||||||||||||||
|
BBBNR
International location number (part 1)
|
BBBNR |
NUMC
|
7 | 0 | ||||||||||||||||||||||||
|
BBSNR
International location number (Part 2)
|
BBSNR |
NUMC
|
5 | 0 | ||||||||||||||||||||||||
|
BEGRU
Authorization Group
|
BRGRU |
CHAR
|
4 | 0 | ||||||||||||||||||||||||
|
BRSCH
Industry key
|
BRSCH | T016 |
CHAR
|
4 | 0 | |||||||||||||||||||||||
|
BUBKZ
Check digit for the international location number
|
BUBKZ |
NUMC
|
1 | 0 | ||||||||||||||||||||||||
|
DATLT
Data communication line no.
|
DATLT |
CHAR
|
14 | 0 | ||||||||||||||||||||||||
|
ERDAT
Date on which the Record Was Created
|
ERDAT_RF |
DATS
|
8 | 0 | ||||||||||||||||||||||||
|
ERNAM
Name of Person who Created the Object
|
ERNAM_RF |
CHAR
|
12 | 0 | ||||||||||||||||||||||||
|
EXABL
Indicator: Unloading points exist
|
EXABL |
CHAR
|
1 | 0 | ||||||||||||||||||||||||
|
||||||||||||||||||||||||||||
|
FAKSD
Central billing block for customer
|
FAKSD_X | TVFS |
CHAR
|
2 | 0 | |||||||||||||||||||||||
|
FISKN
Account number of the master record with the fiscal address
|
FISKN_D | KNA1 |
CHAR
|
10 | 0 | |||||||||||||||||||||||
|
KNAZK
Working Time Calendar
|
KNAZK | TFACD |
CHAR
|
2 | 0 | |||||||||||||||||||||||
|
KNRZA
Account number of an alternative payer
|
KNRZA | KNA1 |
CHAR
|
10 | 0 | |||||||||||||||||||||||
|
KONZS
Group key
|
KONZS |
CHAR
|
10 | 0 | ||||||||||||||||||||||||
|
KTOKD
Customer Account Group
|
KTOKD | T077D |
CHAR
|
4 | 0 | |||||||||||||||||||||||
|
KUKLA
Customer classification
|
KUKLA | TKUKL |
CHAR
|
2 | 0 | |||||||||||||||||||||||
|
LIFNR
Account Number of Vendor or Creditor
|
LIFNR | LFA1 |
CHAR
|
10 | 0 | |||||||||||||||||||||||
|
LIFSD
Central delivery block for the customer
|
LIFSD_X | TVLS |
CHAR
|
2 | 0 | |||||||||||||||||||||||
|
LOCCO
City Coordinates
|
LOCCO |
CHAR
|
10 | 0 | ||||||||||||||||||||||||
|
LOEVM
Central Deletion Flag for Master Record
|
LOEVM_X |
CHAR
|
1 | 0 | ||||||||||||||||||||||||
|
||||||||||||||||||||||||||||
|
NAME3
Name 3
|
NAME3_GP |
CHAR
|
35 | 0 | ||||||||||||||||||||||||
|
NAME4
Name 4
|
NAME4_GP |
CHAR
|
35 | 0 | ||||||||||||||||||||||||
|
NIELS
Nielsen ID
|
NIELS | TNLS |
CHAR
|
2 | 0 | |||||||||||||||||||||||
|
ORT02
District
|
ORT02_GP |
CHAR
|
35 | 0 | ||||||||||||||||||||||||
|
PFACH
PO Box
|
PFACH |
CHAR
|
10 | 0 | ||||||||||||||||||||||||
|
PSTL2
P.O. Box Postal Code
|
PSTL2 |
CHAR
|
10 | 0 | ||||||||||||||||||||||||
|
COUNC
County Code
|
COUNC | T005E |
CHAR
|
3 | 0 | |||||||||||||||||||||||
|
CITYC
City Code
|
CITYC | T005G |
CHAR
|
4 | 0 | |||||||||||||||||||||||
|
RPMKR
Regional Market
|
RPMKR |
CHAR
|
5 | 0 | ||||||||||||||||||||||||
|
SPERR
Central posting block
|
SPERB_X |
CHAR
|
1 | 0 | ||||||||||||||||||||||||
|
||||||||||||||||||||||||||||
|
SPRAS
Language Key
|
SPRAS | T002 |
LANG
|
1 | 0 | |||||||||||||||||||||||
|
STCD1
Tax Number 1
|
STCD1 |
CHAR
|
16 | 0 | ||||||||||||||||||||||||
|
STCD2
Tax Number 2
|
STCD2 |
CHAR
|
11 | 0 | ||||||||||||||||||||||||
|
STKZA
Indicator: Business Partner Subject to Equalization Tax?
|
STKZA |
CHAR
|
1 | 0 | ||||||||||||||||||||||||
|
||||||||||||||||||||||||||||
|
STKZU
Liable for VAT
|
STKZU |
CHAR
|
1 | 0 | ||||||||||||||||||||||||
|
||||||||||||||||||||||||||||
|
TELBX
Telebox number
|
TELBX |
CHAR
|
15 | 0 | ||||||||||||||||||||||||
|
TELF2
Second telephone number
|
TELF2 |
CHAR
|
16 | 0 | ||||||||||||||||||||||||
|
TELTX
Teletex number
|
TELTX |
CHAR
|
30 | 0 | ||||||||||||||||||||||||
|
TELX1
Telex number
|
TELX1 |
CHAR
|
30 | 0 | ||||||||||||||||||||||||
|
LZONE
Transportation zone to or from which the goods are delivered
|
LZONE | TZONE |
CHAR
|
10 | 0 | |||||||||||||||||||||||
|
XZEMP
Indicator: Is an alternative payer allowed in document?
|
XREGU |
CHAR
|
1 | 0 | ||||||||||||||||||||||||
|
||||||||||||||||||||||||||||
|
VBUND
Company ID of trading partner
|
RASSC | T880 |
CHAR
|
6 | 0 | |||||||||||||||||||||||
|
STCEG
VAT Registration Number
|
STCEG |
CHAR
|
20 | 0 | ||||||||||||||||||||||||
|
DEAR1
Indicator: Competitor
|
DEAR1 |
CHAR
|
1 | 0 | ||||||||||||||||||||||||
|
||||||||||||||||||||||||||||
|
DEAR2
Indicator: Sales partner
|
DEAR2 |
CHAR
|
1 | 0 | ||||||||||||||||||||||||
|
||||||||||||||||||||||||||||
|
DEAR3
Indicator: Sales prospect
|
DEAR3 |
CHAR
|
1 | 0 | ||||||||||||||||||||||||
|
||||||||||||||||||||||||||||
|
DEAR4
Indicator for customer type 4
|
DEAR4 |
CHAR
|
1 | 0 | ||||||||||||||||||||||||
|
||||||||||||||||||||||||||||
|
DEAR5
ID for default sold-to party
|
DEAR5 |
CHAR
|
1 | 0 | ||||||||||||||||||||||||
|
||||||||||||||||||||||||||||
|
GFORM
Legal status
|
GFORM | TVGF |
CHAR
|
2 | 0 | |||||||||||||||||||||||
|
BRAN1
Industry Code 1
|
BRAN1_D | TBRC |
CHAR
|
10 | 0 | |||||||||||||||||||||||
|
BRAN2
Industry code 2
|
BRAN2 | TBRC |
CHAR
|
10 | 0 | |||||||||||||||||||||||
|
BRAN3
Industry code 3
|
BRAN3 | TBRC |
CHAR
|
10 | 0 | |||||||||||||||||||||||
|
BRAN4
Industry code 4
|
BRAN4 | TBRC |
CHAR
|
10 | 0 | |||||||||||||||||||||||
|
BRAN5
Industry code 5
|
BRAN5 | TBRC |
CHAR
|
10 | 0 | |||||||||||||||||||||||
|
EKONT
Initial contact
|
EKONT | VBUK |
CHAR
|
10 | 0 | |||||||||||||||||||||||
|
UMSAT
Annual sales
|
UMSAT |
CURR
|
8 | 2 | ||||||||||||||||||||||||
|
UMJAH
Year For Which Sales are Given
|
UMJAH |
NUMC
|
4 | 0 | ||||||||||||||||||||||||
|
UWAER
Currency of sales figure
|
UWAER | TCURC |
CUKY
|
5 | 0 | |||||||||||||||||||||||
|
JMZAH
Yearly number of employees
|
JMZAH |
NUMC
|
6 | 0 | ||||||||||||||||||||||||
|
JMJAH
Year for which the number of employees is given
|
JMJAH |
NUMC
|
4 | 0 | ||||||||||||||||||||||||
|
KATR1
Attribute 1
|
KATR1 | TVK1 |
CHAR
|
2 | 0 | |||||||||||||||||||||||
|
KATR2
Attribute 2
|
KATR2 | TVK2 |
CHAR
|
2 | 0 | |||||||||||||||||||||||
|
KATR3
Attribute 3
|
KATR3 | TVK3 |
CHAR
|
2 | 0 | |||||||||||||||||||||||
|
KATR4
Attribute 4
|
KATR4 | TVK4 |
CHAR
|
2 | 0 | |||||||||||||||||||||||
|
KATR5
Attribute 5
|
KATR5 | TVK5 |
CHAR
|
2 | 0 | |||||||||||||||||||||||
|
KATR6
Attribute 6
|
KATR6 | TVK6 |
CHAR
|
3 | 0 | |||||||||||||||||||||||
|
KATR7
Attribute 7
|
KATR7 | TVK7 |
CHAR
|
3 | 0 | |||||||||||||||||||||||
|
KATR8
Attribute 8
|
KATR8 | TVK8 |
CHAR
|
3 | 0 | |||||||||||||||||||||||
|
KATR9
Attribute 9
|
KATR9 | TVK9 |
CHAR
|
3 | 0 | |||||||||||||||||||||||
|
KATR10
Attribute 10
|
KATR10 | TVK0 |
CHAR
|
3 | 0 | |||||||||||||||||||||||
|
STKZN
Natural Person
|
STKZN |
CHAR
|
1 | 0 | ||||||||||||||||||||||||
|
||||||||||||||||||||||||||||
|
UMSA1
Annual sales
|
UMSA1 |
CURR
|
15 | 2 | ||||||||||||||||||||||||
|
TXJCD
Tax Jurisdiction
|
TXJCD | TTXJ |
CHAR
|
15 | 0 | |||||||||||||||||||||||
|
PERIV
Fiscal Year Variant
|
PERIV | T009 |
CHAR
|
2 | 0 | |||||||||||||||||||||||
|
ABRVW
Usage Indicator
|
ABRVW | TVLV |
CHAR
|
3 | 0 | |||||||||||||||||||||||
|
INSPBYDEBI
Inspection Carried Out By Customer (No Inspection Lot)
|
QINSPBYDEB |
CHAR
|
1 | 0 | ||||||||||||||||||||||||
|
||||||||||||||||||||||||||||
|
INSPATDEBI
Inspection for a Delivery Note After Outbound Delivery
|
QINSPATDEB |
CHAR
|
1 | 0 | ||||||||||||||||||||||||
|
||||||||||||||||||||||||||||
|
KTOCD
Reference Account Group for One-Time Account (Customer)
|
KTOCD | T077D |
CHAR
|
4 | 0 | |||||||||||||||||||||||
|
PFORT
PO Box city
|
PFORT_GP |
CHAR
|
35 | 0 | ||||||||||||||||||||||||
|
WERKS
Plant
|
WERKS_D | T001W |
CHAR
|
4 | 0 | |||||||||||||||||||||||
|
DTAMS
Indicator for Data Medium Exchange
|
DTAMS |
CHAR
|
1 | 0 | ||||||||||||||||||||||||
|
||||||||||||||||||||||||||||
|
DTAWS
Instruction key for data medium exchange
|
DTAWS |
CHAR
|
2 | 0 | ||||||||||||||||||||||||
|
DUEFL
Status of Data Transfer into Subsequent Release
|
DUEFL_BKPF |
CHAR
|
1 | 0 | ||||||||||||||||||||||||
|
||||||||||||||||||||||||||||
|
HZUOR
Assignment to Hierarchy
|
HZUOR |
NUMC
|
2 | 0 | ||||||||||||||||||||||||
|
SPERZ
Payment Block
|
SPERZ |
CHAR
|
1 | 0 | ||||||||||||||||||||||||
|
||||||||||||||||||||||||||||
|
ETIKG
IS-R Labeling: customer/plant group
|
ETIKG | TWEK |
CHAR
|
10 | 0 | |||||||||||||||||||||||
|
CIVVE
ID for mainly non-military use
|
CIVVE |
CHAR
|
1 | 0 | ||||||||||||||||||||||||
|
||||||||||||||||||||||||||||
|
MILVE
ID for mainly military use
|
MILVE |
CHAR
|
1 | 0 | ||||||||||||||||||||||||
|
||||||||||||||||||||||||||||
|
KDKG1
Customer condition group 1
|
KDKG1 | TVKGG |
CHAR
|
2 | 0 | |||||||||||||||||||||||
|
KDKG2
Customer condition group 2
|
KDKG2 | TVKGG |
CHAR
|
2 | 0 | |||||||||||||||||||||||
|
KDKG3
Customer condition group 3
|
KDKG3 | TVKGG |
CHAR
|
2 | 0 | |||||||||||||||||||||||
|
KDKG4
Customer condition group 4
|
KDKG4 | TVKGG |
CHAR
|
2 | 0 | |||||||||||||||||||||||
|
KDKG5
Customer condition group 5
|
KDKG5 | TVKGG |
CHAR
|
2 | 0 | |||||||||||||||||||||||
|
XKNZA
Indicator: Alternative payer using account number
|
XKNZA |
CHAR
|
1 | 0 | ||||||||||||||||||||||||
|
||||||||||||||||||||||||||||
|
FITYP
Tax type
|
J_1AFITP_D | J_1AFITP |
CHAR
|
2 | 0 | |||||||||||||||||||||||
|
STCDT
Tax Number Type
|
J_1ATOID | J_1ATODC |
CHAR
|
2 | 0 | |||||||||||||||||||||||
|
STCD3
Tax Number 3
|
STCD3 |
CHAR
|
18 | 0 | ||||||||||||||||||||||||
|
STCD4
Tax Number 4
|
STCD4 |
CHAR
|
18 | 0 | ||||||||||||||||||||||||
|
STCD5
Tax Number 5
|
STCD5 |
CHAR
|
60 | 0 | ||||||||||||||||||||||||
|
XICMS
Customer is ICMS-exempt
|
J_1BTCICMS |
CHAR
|
1 | 0 | ||||||||||||||||||||||||
|
||||||||||||||||||||||||||||
|
XXIPI
Customer is IPI-exempt
|
J_1BTCIPI |
CHAR
|
1 | 0 | ||||||||||||||||||||||||
|
||||||||||||||||||||||||||||
|
XSUBT
|
J_1BTCST | J_1BTXSTG |
CHAR
|
3 | 0 | |||||||||||||||||||||||
|
CFOPC
Customer's CFOP category
|
J_1BINDUS1 |
CHAR
|
2 | 0 | ||||||||||||||||||||||||
|
||||||||||||||||||||||||||||
|
TXLW1
Tax law: ICMS
|
J_1BTAXLW1 | J_1BATL1 |
CHAR
|
3 | 0 | |||||||||||||||||||||||
|
TXLW2
Tax law: IPI
|
J_1BTAXLW2 | J_1BATL2 |
CHAR
|
3 | 0 | |||||||||||||||||||||||
|
CCC01
Indicator for biochemical warfare for legal control
|
CCC01 |
CHAR
|
1 | 0 | ||||||||||||||||||||||||
|
||||||||||||||||||||||||||||
|
CCC02
Indicator for nuclear nonproliferation for legal control
|
CCC02 |
CHAR
|
1 | 0 | ||||||||||||||||||||||||
|
||||||||||||||||||||||||||||
|
CCC03
Indicator for national security for legal control
|
CCC03 |
CHAR
|
1 | 0 | ||||||||||||||||||||||||
|
||||||||||||||||||||||||||||
|
CCC04
Indicator for missile technology for legal control
|
CCC04 |
CHAR
|
1 | 0 | ||||||||||||||||||||||||
|
||||||||||||||||||||||||||||
|
CASSD
Central sales block for customer
|
CASSD_X |
CHAR
|
2 | 0 | ||||||||||||||||||||||||
|
KNURL
Uniform Resource Locator
|
URL |
CHAR
|
132 | 0 | ||||||||||||||||||||||||
|
J_1KFREPRE
Name of Representative
|
REPRES |
CHAR
|
10 | 0 | ||||||||||||||||||||||||
|
J_1KFTBUS
Type of Business
|
GESTYP | BUSTYPE |
CHAR
|
30 | 0 | |||||||||||||||||||||||
|
J_1KFTIND
Type of Industry
|
INDTYP | INDUSTYPE |
CHAR
|
30 | 0 | |||||||||||||||||||||||
|
CONFS
Status of Change Authorization (Central)
|
CONFS_X |
CHAR
|
1 | 0 | ||||||||||||||||||||||||
|
UPDAT
Date on Which the Changes Were Confirmed
|
UPDAT_RF |
DATS
|
8 | 0 | ||||||||||||||||||||||||
|
UPTIM
Time of Last Change Confirmation
|
UPTIM_RF |
TIMS
|
6 | 0 | ||||||||||||||||||||||||
|
NODEL
Central deletion block for master record
|
NODEL_X |
CHAR
|
1 | 0 | ||||||||||||||||||||||||
|
||||||||||||||||||||||||||||
|
DEAR6
Indicator: Consumer
|
DEAR6 |
CHAR
|
1 | 0 | ||||||||||||||||||||||||
|
||||||||||||||||||||||||||||
|
SUFRAMA
Suframa Code
|
J_1BSUFRAMA |
CHAR
|
9 | 0 | ||||||||||||||||||||||||
|
RG
RG Number
|
J_1BRG |
CHAR
|
11 | 0 | ||||||||||||||||||||||||
|
EXP
Issued by
|
J_1BEXP |
CHAR
|
3 | 0 | ||||||||||||||||||||||||
|
UF
State
|
J_1BUF |
CHAR
|
2 | 0 | ||||||||||||||||||||||||
|
RGDATE
RG Issue Date
|
J_1BRGDATE |
DATS
|
8 | 0 | ||||||||||||||||||||||||
|
RIC
RIC Number
|
J_1BRIC |
NUMC
|
11 | 0 | ||||||||||||||||||||||||
|
RNE
Foreign National Registration
|
J_1BRNE |
CHAR
|
10 | 0 | ||||||||||||||||||||||||
|
RNEDATE
RNE Issue Date
|
J_1BRNEDATE |
DATS
|
8 | 0 | ||||||||||||||||||||||||
|
CNAE
CNAE
|
J_1BCNAE | J_1BTCNAE |
CHAR
|
7 | 0 | |||||||||||||||||||||||
|
LEGALNAT
Legal Nature
|
J_1BLEGALNAT | J_1BTLEGALNAT |
NUMC
|
4 | 0 | |||||||||||||||||||||||
|
CRTN
CRT Number
|
J_1BCRTN |
CHAR
|
1 | 0 | ||||||||||||||||||||||||
|
||||||||||||||||||||||||||||
|
ICMSTAXPAY
ICMS Taxpayer
|
J_1BICMSTAXPAY | J_1BTICMSTAXPAY |
CHAR
|
2 | 0 | |||||||||||||||||||||||
|
INDTYP
Industry Main Type
|
J_1BINDTYP | J_1BTINDTYP |
CHAR
|
2 | 0 | |||||||||||||||||||||||
|
TDT
Tax Declaration Type
|
J_1BTDT | J_1BTTDT |
CHAR
|
2 | 0 | |||||||||||||||||||||||
|
COMSIZE
Company Size
|
J_1BCOMSIZE | J_1BTCOMSIZE |
CHAR
|
2 | 0 | |||||||||||||||||||||||
|
DECREGPC
Declaration Regimen for PIS/COFINS
|
J_1BDECREGPC | J_1BTDECREGPC |
CHAR
|
2 | 0 | |||||||||||||||||||||||
|
/VSO/R_PALHGT
Maximum Stacking Height of the Packaging Material (VSO)
|
/VSO/R_PAL_BIN_HGT |
QUAN
|
13 | 3 | ||||||||||||||||||||||||
|
/VSO/R_PAL_UL
Unit of Length for Packaging Material (VSO)
|
/VSO/R_PAL_UNIT_L | T006 |
UNIT
|
3 | 0 | |||||||||||||||||||||||
|
/VSO/R_PK_MAT
Customer-Related Packing for Each Packaging Material (VSO)
|
/VSO/M_PACK_BY_MAT |
CHAR
|
1 | 0 | ||||||||||||||||||||||||
|
||||||||||||||||||||||||||||
|
/VSO/R_MATPAL
Packaging Material of the Customer in VSO
|
/VSO/M_MATNR_PAL | MARA |
CHAR
|
18 | 0 | |||||||||||||||||||||||
|
/VSO/R_I_NO_LYR
Number Layers Under an Inter-Pallet (VSO)
|
/VSO/M_IPAL_NO_LYR |
NUMC
|
2 | 0 | ||||||||||||||||||||||||
|
/VSO/R_ONE_MAT
Packing Material-Specific for Each Packaging Material
|
/VSO/M_ONE_MAT |
CHAR
|
1 | 0 | ||||||||||||||||||||||||
|
||||||||||||||||||||||||||||
|
/VSO/R_ONE_SORT
Pack Only One Package Type for Each PKM (VSO)
|
/VSO/M_ONE_SORT |
CHAR
|
1 | 0 | ||||||||||||||||||||||||
|
||||||||||||||||||||||||||||
|
/VSO/R_ULD_SIDE
Side Preference of Loading/Unloading (VSO)
|
/VSO/M_UNLOAD_SIDE_PREF |
NUMC
|
1 | 0 | ||||||||||||||||||||||||
|
||||||||||||||||||||||||||||
|
/VSO/R_LOAD_PREF
Front/Back Preference of Loading/Unloading (VSO)
|
/VSO/M_LOAD_PREF |
NUMC
|
1 | 0 | ||||||||||||||||||||||||
|
||||||||||||||||||||||||||||
|
/VSO/R_DPOINT
Collective Unloading Point for VSO
|
/VSO/R_DELIVERYPOINT | /VSO/R_DPOINT |
CHAR
|
10 | 0 | |||||||||||||||||||||||
|
/XLSO/CUSTOMER
Data element to differentiate customer
|
/XLSO/E_CUSTOMER |
CHAR
|
1 | 0 | ||||||||||||||||||||||||
|
||||||||||||||||||||||||||||
|
/XLSO/SYSID
Name of SAP System
|
SYSYSID |
CHAR
|
8 | 0 | ||||||||||||||||||||||||
|
/XLSO/CLIENT
Client
|
MANDT |
CLNT
|
3 | 0 | ||||||||||||||||||||||||
|
/XLSO/PARTNER
Business Partner Number
|
BU_PARTNER |
CHAR
|
10 | 0 | ||||||||||||||||||||||||
|
/XLSO/PREF_PAY
Version Number Component
|
CHAR2 |
CHAR
|
2 | 0 | ||||||||||||||||||||||||
|
ALC
Agency Location Code
|
FMFG_ALC | FMFGT_ALC |
CHAR
|
8 | 0 | |||||||||||||||||||||||
|
PMT_OFFICE
Payment Office
|
FMFG_PMT_OFF | FMFGT_PO |
CHAR
|
5 | 0 | |||||||||||||||||||||||
|
FEE_SCHEDULE
Fee schedule
|
FM_FEE_SCHED |
CHAR
|
4 | 0 | ||||||||||||||||||||||||
|
DUNS
DUNS Number
|
FMCCRDUNS |
CHAR
|
9 | 0 | ||||||||||||||||||||||||
|
DUNS4
DUNS+4
|
FMCCRDUNS4 |
CHAR
|
4 | 0 | ||||||||||||||||||||||||
|
PSOFG
Processor group
|
PSOFG | PSO19 |
CHAR
|
10 | 0 | |||||||||||||||||||||||
|
PSOIS
Subledger acct preprocessing procedure
|
PSOIS |
CHAR
|
20 | 0 | ||||||||||||||||||||||||
|
PSON1
Name 1
|
NAME1_GP |
CHAR
|
35 | 0 | ||||||||||||||||||||||||
|
PSON2
Name 2
|
NAME2_GP |
CHAR
|
35 | 0 | ||||||||||||||||||||||||
|
PSON3
Name 3
|
NAME3_GP |
CHAR
|
35 | 0 | ||||||||||||||||||||||||
|
PSOVN
First Name
|
PSOVN |
CHAR
|
35 | 0 | ||||||||||||||||||||||||
|
PSOTL
Title
|
PSOTL |
CHAR
|
20 | 0 | ||||||||||||||||||||||||
|
PSOHS
House number: is no longer used from Release 4.6B
|
PSOHS |
CHAR
|
6 | 0 | ||||||||||||||||||||||||
|
PSOST
Street: No longer used from Release 4.6B
|
PSOST |
CHAR
|
28 | 0 | ||||||||||||||||||||||||
|
PSOO1
Description
|
PSOO1 |
CHAR
|
50 | 0 | ||||||||||||||||||||||||
|
PSOO2
Description
|
PSOO1 |
CHAR
|
50 | 0 | ||||||||||||||||||||||||
|
PSOO3
Description
|
PSOO1 |
CHAR
|
50 | 0 | ||||||||||||||||||||||||
|
PSOO4
Description
|
PSOO1 |
CHAR
|
50 | 0 | ||||||||||||||||||||||||
|
PSOO5
Description
|
PSOO1 |
CHAR
|
50 | 0 | ||||||||||||||||||||||||
|
OIDRC
Differential Reference Code (DRC)
|
OIC_DRC | OICDC |
CHAR
|
5 | 0 | |||||||||||||||||||||||
|
OID_POREQD
Purchase order required: X = Yes, Blank = No
|
OID_POREQD |
CHAR
|
1 | 0 | ||||||||||||||||||||||||
|
||||||||||||||||||||||||||||
|
OIPBL
Business location identifier (IS-Oil MRN)
|
OIF_PBLNR | OIFSPBL |
CHAR
|
10 | 0 | |||||||||||||||||||||||
|
RES_CNTRY
|
CHAR
|
3 | 0 | |||||||||||||||||||||||||
|
CCODE
|
CHAR
|
4 | 0 | |||||||||||||||||||||||||
KNA1 foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| KNA1 | /VSO/R_DPOINT | SYST | MANDT |
/VSO/R_DPOINT
Collective Unloading Point for VSO
|
MANDT |
| KNA1 | /VSO/R_DPOINT | KNA1 | /VSO/R_DPOINT |
/VSO/R_DPOINT
Collective Unloading Point for VSO
|
/VSO/R_DPOINT |
| KNA1 | /VSO/R_MATPAL | SYST | MANDT |
MARA
General Material Data
|
MANDT |
| KNA1 | /VSO/R_MATPAL | KNA1 | /VSO/R_MATPAL |
MARA
General Material Data
|
MATNR |
| KNA1 | /VSO/R_PAL_UL | SYST | MANDT |
T006
Units of Measurement
|
MANDT |
| KNA1 | /VSO/R_PAL_UL | KNA1 | /VSO/R_PAL_UL |
T006
Units of Measurement
|
MSEHI |
| KNA1 | ABRVW | KNA1 | MANDT |
TVLV
Check table for release orders: Usage ID
|
MANDT |
| KNA1 | ABRVW | KNA1 | ABRVW |
TVLV
Check table for release orders: Usage ID
|
ABRVW |
| KNA1 | ALC | KNA1 | MANDT |
FMFGT_ALC
Agency Location Code - U.S. Federal Government
|
MANDT |
| KNA1 | ALC | KNA1 | ALC |
FMFGT_ALC
Agency Location Code - U.S. Federal Government
|
ALC |
| KNA1 | AUFSD | KNA1 | MANDT |
TVAST
Sales Document Blocking Reasons: Texts
|
MANDT |
| KNA1 | AUFSD | SYST | LANGU |
TVAST
Sales Document Blocking Reasons: Texts
|
SPRAS |
| KNA1 | AUFSD | KNA1 | AUFSD |
TVAST
Sales Document Blocking Reasons: Texts
|
AUFSP |
| KNA1 | BRAN1 | KNA1 | MANDT |
TBRC
Industry Code (Customer Master)
|
MANDT |
| KNA1 | BRAN1 | KNA1 | BRAN1 |
TBRC
Industry Code (Customer Master)
|
BRACO |
| KNA1 | BRAN2 | KNA1 | MANDT |
TBRC
Industry Code (Customer Master)
|
MANDT |
| KNA1 | BRAN2 | KNA1 | BRAN2 |
TBRC
Industry Code (Customer Master)
|
BRACO |
| KNA1 | BRAN3 | KNA1 | MANDT |
TBRC
Industry Code (Customer Master)
|
MANDT |
| KNA1 | BRAN3 | KNA1 | BRAN3 |
TBRC
Industry Code (Customer Master)
|
BRACO |
| KNA1 | BRAN4 | KNA1 | MANDT |
TBRC
Industry Code (Customer Master)
|
MANDT |
| KNA1 | BRAN4 | KNA1 | BRAN4 |
TBRC
Industry Code (Customer Master)
|
BRACO |
| KNA1 | BRAN5 | KNA1 | MANDT |
TBRC
Industry Code (Customer Master)
|
MANDT |
| KNA1 | BRAN5 | KNA1 | BRAN5 |
TBRC
Industry Code (Customer Master)
|
BRACO |
| KNA1 | BRSCH | KNA1 | MANDT |
T016
Industries
|
MANDT |
| KNA1 | BRSCH | KNA1 | BRSCH |
T016
Industries
|
BRSCH |
| KNA1 | CITYC | KNA1 | MANDT |
T005G
City
|
MANDT |
| KNA1 | CITYC | KNA1 | LAND1 |
T005G
City
|
LAND1 |
| KNA1 | CITYC | KNA1 | REGIO |
T005G
City
|
REGIO |
| KNA1 | CITYC | KNA1 | CITYC |
T005G
City
|
CITYC |
| KNA1 | CNAE | SYST | MANDT |
J_1BTCNAE
CNAE
|
MANDT |
| KNA1 | CNAE | KNA1 | CNAE |
J_1BTCNAE
CNAE
|
J_1BCNAE |
| KNA1 | COMSIZE | KNA1 | COMSIZE |
J_1BTCOMSIZE
Company Size
|
J_1BCOMSIZE |
| KNA1 | COMSIZE | SYST | MANDT |
J_1BTCOMSIZE
Company Size
|
MANDT |
| KNA1 | COUNC | KNA1 | MANDT |
T005E
County
|
MANDT |
| KNA1 | COUNC | KNA1 | LAND1 |
T005E
County
|
LAND1 |
| KNA1 | COUNC | KNA1 | REGIO |
T005E
County
|
REGIO |
| KNA1 | COUNC | KNA1 | COUNC |
T005E
County
|
COUNC |
| KNA1 | DECREGPC | SYST | MANDT |
J_1BTDECREGPC
Declaration Regimen for PIS/COFINS
|
MANDT |
| KNA1 | DECREGPC | KNA1 | DECREGPC |
J_1BTDECREGPC
Declaration Regimen for PIS/COFINS
|
J_1BDECREGPC |
| KNA1 | EKONT | KNA1 | MANDT |
VBUK
Sales Document: Header Status and Administrative Data
|
MANDT |
| KNA1 | EKONT | KNA1 | EKONT |
VBUK
Sales Document: Header Status and Administrative Data
|
VBELN |
| KNA1 | ETIKG | KNA1 | MANDT |
TWEK
IS-R Labeling: Check Table Customer/Plant Groups
|
MANDT |
| KNA1 | ETIKG | KNA1 | ETIKG |
TWEK
IS-R Labeling: Check Table Customer/Plant Groups
|
KUNGR |
| KNA1 | FAKSD | KNA1 | FAKSD |
TVFS
Billing: Reasons for Blocking
|
FAKSP |
| KNA1 | FAKSD | KNA1 | MANDT |
TVFS
Billing: Reasons for Blocking
|
MANDT |
| KNA1 | FISKN | KNA1 | MANDT |
KNA1
General Data in Customer Master
|
MANDT |
| KNA1 | FISKN | KNA1 | FISKN |
KNA1
General Data in Customer Master
|
KUNNR |
| KNA1 | FITYP | 'D' |
J_1AFITP
Tax Types
|
KOART | |
| KNA1 | FITYP | KNA1 | FITYP |
J_1AFITP
Tax Types
|
J_1AFITP |
| KNA1 | FITYP | KNA1 | MANDT |
J_1AFITP
Tax Types
|
MANDT |
| KNA1 | GFORM | KNA1 | MANDT |
TVGF
Legal Status (Customer Master)
|
MANDT |
| KNA1 | GFORM | KNA1 | GFORM |
TVGF
Legal Status (Customer Master)
|
GFORM |
| KNA1 | ICMSTAXPAY | SYST | MANDT |
J_1BTICMSTAXPAY
ICMS Taxpayer
|
MANDT |
| KNA1 | ICMSTAXPAY | KNA1 | ICMSTAXPAY |
J_1BTICMSTAXPAY
ICMS Taxpayer
|
J_1BICMSTAXPAY |
| KNA1 | INDTYP | SYST | MANDT |
J_1BTINDTYP
Industry Main Type
|
MANDT |
| KNA1 | INDTYP | KNA1 | INDTYP |
J_1BTINDTYP
Industry Main Type
|
J_1BINDTYP |
| KNA1 | J_1KFTBUS | KNA1 | MANDT |
BUSTYPE
Type of Business
|
MANDT |
| KNA1 | J_1KFTBUS | KNA1 | J_1KFTBUS |
BUSTYPE
Type of Business
|
GESTYP |
| KNA1 | J_1KFTIND | KNA1 | MANDT |
INDUSTYPE
Type of Industry
|
MANDT |
| KNA1 | J_1KFTIND | KNA1 | J_1KFTIND |
INDUSTYPE
Type of Industry
|
INDTYPE |
| KNA1 | KATR1 | KNA1 | MANDT |
TVK1
Attribute 1 (customer master)
|
MANDT |
| KNA1 | KATR1 | KNA1 | KATR1 |
TVK1
Attribute 1 (customer master)
|
KATR1 |
| KNA1 | KATR10 | KNA1 | MANDT |
TVK0
Attribute 10 (customer master)
|
MANDT |
| KNA1 | KATR10 | KNA1 | KATR10 |
TVK0
Attribute 10 (customer master)
|
KATR10 |
| KNA1 | KATR2 | KNA1 | MANDT |
TVK2
Attribute 2 (customer master)
|
MANDT |
| KNA1 | KATR2 | KNA1 | KATR2 |
TVK2
Attribute 2 (customer master)
|
KATR2 |
| KNA1 | KATR3 | KNA1 | KATR3 |
TVK3
Attribute 3 (customer master)
|
KATR3 |
| KNA1 | KATR3 | KNA1 | MANDT |
TVK3
Attribute 3 (customer master)
|
MANDT |
| KNA1 | KATR4 | KNA1 | MANDT |
TVK4
Attribute 4 (customer master)
|
MANDT |
| KNA1 | KATR4 | KNA1 | KATR4 |
TVK4
Attribute 4 (customer master)
|
KATR4 |
| KNA1 | KATR5 | KNA1 | MANDT |
TVK5
Attribute 5 (customer master)
|
MANDT |
| KNA1 | KATR5 | KNA1 | KATR5 |
TVK5
Attribute 5 (customer master)
|
KATR5 |
| KNA1 | KATR6 | KNA1 | KATR6 |
TVK6
Attribute 6 (customer master)
|
KATR6 |
| KNA1 | KATR6 | KNA1 | MANDT |
TVK6
Attribute 6 (customer master)
|
MANDT |
| KNA1 | KATR7 | KNA1 | MANDT |
TVK7
Attribute 7 (customer master)
|
MANDT |
| KNA1 | KATR7 | KNA1 | KATR7 |
TVK7
Attribute 7 (customer master)
|
KATR7 |
| KNA1 | KATR8 | KNA1 | MANDT |
TVK8
Attribute 8 (customer master)
|
MANDT |
| KNA1 | KATR8 | KNA1 | KATR8 |
TVK8
Attribute 8 (customer master)
|
KATR8 |
| KNA1 | KATR9 | KNA1 | MANDT |
TVK9
Attribute 9 (customer master)
|
MANDT |
| KNA1 | KATR9 | KNA1 | KATR9 |
TVK9
Attribute 9 (customer master)
|
KATR9 |
| KNA1 | KDKG1 | KNA1 | MANDT |
TVKGG
Customer Condition Groups (Customer Master)
|
MANDT |
| KNA1 | KDKG1 | KNA1 | KDKG1 |
TVKGG
Customer Condition Groups (Customer Master)
|
KDKGR |
| KNA1 | KDKG2 | KNA1 | KDKG2 |
TVKGG
Customer Condition Groups (Customer Master)
|
KDKGR |
| KNA1 | KDKG2 | KNA1 | MANDT |
TVKGG
Customer Condition Groups (Customer Master)
|
MANDT |
| KNA1 | KDKG3 | KNA1 | MANDT |
TVKGG
Customer Condition Groups (Customer Master)
|
MANDT |
| KNA1 | KDKG3 | KNA1 | KDKG3 |
TVKGG
Customer Condition Groups (Customer Master)
|
KDKGR |
| KNA1 | KDKG4 | KNA1 | MANDT |
TVKGG
Customer Condition Groups (Customer Master)
|
MANDT |
| KNA1 | KDKG4 | KNA1 | KDKG4 |
TVKGG
Customer Condition Groups (Customer Master)
|
KDKGR |
| KNA1 | KDKG5 | KNA1 | KDKG5 |
TVKGG
Customer Condition Groups (Customer Master)
|
KDKGR |
| KNA1 | KDKG5 | KNA1 | MANDT |
TVKGG
Customer Condition Groups (Customer Master)
|
MANDT |
| KNA1 | KNAZK | KNA1 | KNAZK |
TFACD
Factory calendar definition
|
IDENT |
| KNA1 | KNRZA | KNA1 | KNRZA |
KNA1
General Data in Customer Master
|
KUNNR |
| KNA1 | KNRZA | KNA1 | MANDT |
KNA1
General Data in Customer Master
|
MANDT |
| KNA1 | KTOCD | KNA1 | MANDT |
T077D
Customer account groups
|
MANDT |
| KNA1 | KTOCD | KNA1 | KTOCD |
T077D
Customer account groups
|
KTOKD |
| KNA1 | KTOKD | KNA1 | KTOKD |
T077D
Customer account groups
|
KTOKD |
| KNA1 | KTOKD | KNA1 | MANDT |
T077D
Customer account groups
|
MANDT |
| KNA1 | KUKLA | KNA1 | MANDT |
TKUKL
Customers: Customer Classifications
|
MANDT |
| KNA1 | KUKLA | KNA1 | KUKLA |
TKUKL
Customers: Customer Classifications
|
KUKLA |
| KNA1 | LAND1 | KNA1 | LAND1 |
T005
Countries
|
LAND1 |
| KNA1 | LAND1 | KNA1 | MANDT |
T005
Countries
|
MANDT |
| KNA1 | LEGALNAT | SYST | MANDT |
J_1BTLEGALNAT
Legal Nature
|
MANDT |
| KNA1 | LEGALNAT | KNA1 | LEGALNAT |
J_1BTLEGALNAT
Legal Nature
|
J_1BLEGALNAT |
| KNA1 | LIFNR | KNA1 | MANDT |
LFA1
Vendor Master (General Section)
|
MANDT |
| KNA1 | LIFNR | KNA1 | LIFNR |
LFA1
Vendor Master (General Section)
|
LIFNR |
| KNA1 | LIFSD | KNA1 | MANDT |
TVLS
Deliveries: Blocking Reasons/Criteria
|
MANDT |
| KNA1 | LIFSD | KNA1 | LIFSD |
TVLS
Deliveries: Blocking Reasons/Criteria
|
LIFSP |
| KNA1 | LZONE | KNA1 | MANDT |
TZONE
Customers: Regional zones
|
MANDT |
| KNA1 | LZONE | KNA1 | LAND1 |
TZONE
Customers: Regional zones
|
LAND1 |
| KNA1 | LZONE | KNA1 | LZONE |
TZONE
Customers: Regional zones
|
ZONE1 |
| KNA1 | MANDT | KNA1 | MANDT |
T000
Clients
|
MANDT |
| KNA1 | NIELS | KNA1 | MANDT |
TNLS
Nielsen ID
|
MANDT |
| KNA1 | NIELS | KNA1 | NIELS |
TNLS
Nielsen ID
|
NIELS |
| KNA1 | OIDRC | KNA1 | MANDT |
OICDC
Differential Reference Code
|
MANDT |
| KNA1 | OIDRC | KNA1 | OIDRC |
OICDC
Differential Reference Code
|
OIDRC |
| KNA1 | OIPBL | KNA1 | MANDT |
OIFSPBL
Physical Location - Master Data
|
MANDT |
| KNA1 | OIPBL | KNA1 | OIPBL |
OIFSPBL
Physical Location - Master Data
|
PBLNR |
| KNA1 | PERIV | KNA1 | MANDT |
T009
Fiscal Year Variants
|
MANDT |
| KNA1 | PERIV | KNA1 | PERIV |
T009
Fiscal Year Variants
|
PERIV |
| KNA1 | PMT_OFFICE | KNA1 | MANDT |
FMFGT_PO
Payment Office - U.S. Federal Government
|
MANDT |
| KNA1 | PMT_OFFICE | KNA1 | PMT_OFFICE |
FMFGT_PO
Payment Office - U.S. Federal Government
|
PMT_OFFICE |
| KNA1 | PSOFG | KNA1 | PSOFG |
PSO19
Group Responsibility
|
PSOFG |
| KNA1 | PSOFG | KNA1 | MANDT |
PSO19
Group Responsibility
|
MANDT |
| KNA1 | REGIO | KNA1 | LAND1 |
T005S
Taxes: Region (Province) Key
|
LAND1 |
| KNA1 | REGIO | KNA1 | REGIO |
T005S
Taxes: Region (Province) Key
|
BLAND |
| KNA1 | REGIO | KNA1 | MANDT |
T005S
Taxes: Region (Province) Key
|
MANDT |
| KNA1 | SPRAS | KNA1 | SPRAS |
T002
Language Keys (Component BC-I18)
|
SPRAS |
| KNA1 | STCDT | KNA1 | MANDT |
J_1ATODC
Type of identification
|
MANDT |
| KNA1 | STCDT | KNA1 | STCDT |
J_1ATODC
Type of identification
|
J_1ATODC |
| KNA1 | TDT | KNA1 | TDT |
J_1BTTDT
TDT
|
J_1BTDT |
| KNA1 | TDT | SYST | MANDT |
J_1BTTDT
TDT
|
MANDT |
| KNA1 | TXJCD | T005 | KALSM |
TTXJ
Check Table for Tax Jurisdiction
|
KALSM |
| KNA1 | TXJCD | KNA1 | TXJCD |
TTXJ
Check Table for Tax Jurisdiction
|
TXJCD |
| KNA1 | TXJCD | KNA1 | MANDT |
TTXJ
Check Table for Tax Jurisdiction
|
MANDT |
| KNA1 | TXLW1 | KNA1 | TXLW1 |
J_1BATL1
Tax Law ICMS
|
TAXLAW |
| KNA1 | TXLW1 | KNA1 | MANDT |
J_1BATL1
Tax Law ICMS
|
MANDT |
| KNA1 | TXLW2 | KNA1 | MANDT |
J_1BATL2
Tax Law IPI
|
MANDT |
| KNA1 | TXLW2 | KNA1 | TXLW2 |
J_1BATL2
Tax Law IPI
|
TAXLAW |
| KNA1 | UWAER | KNA1 | MANDT |
TCURC
Currency Codes
|
MANDT |
| KNA1 | UWAER | KNA1 | UWAER |
TCURC
Currency Codes
|
WAERS |
| KNA1 | VBUND | KNA1 | MANDT |
T880
Global Company Data (for KONS Ledger)
|
MANDT |
| KNA1 | VBUND | KNA1 | VBUND |
T880
Global Company Data (for KONS Ledger)
|
RCOMP |
| KNA1 | WERKS | KNA1 | MANDT |
T001W
Plants/Branches
|
MANDT |
| KNA1 | WERKS | KNA1 | WERKS |
T001W
Plants/Branches
|
WERKS |
| KNA1 | XSUBT | SYST | MANDT |
J_1BTXSTG
Tax calc.: Sub.Trib. customer group
|
MANDT |
| KNA1 | XSUBT | KNA1 | XSUBT |
J_1BTXSTG
Tax calc.: Sub.Trib. customer group
|
STGRP |