SAP Table KNA1
General Data in Customer Master
What Is the SAP KNA1 Table?
SAP KNA1 Table stores general data for customer master records in SAP. It is a customer-level data and is generally application for all organizational units in which customer is used.
KNA1 contains important customer information such as customer number, Name, Country/Region, Postal Code, Account Group, Address number and indicators for blocking & deleting.
Customer Master Data in SAP is defined at different levels and stored in different tables
- KNA1: Customer Master General Data
- KNB1: Customer Master Company Code data
- KNVV: Customer Master Sales Area Data
In SAP ECC, Customer Master Records are commonly created, changes and display using transaction code XD01, XD02, & XD03.
In SAP S/4HANA, Business Partner (BP) is used for maintain the customer master data based on BP roles. The classic customer transaction codes XD01, XD02, XD03 are obsolete for customer maintenance and redirected to transaction BP. Customer Vendor Integration (CVI) synchronize the business partner with customer specific data.
The tables KNA1, KNB1 and KNVV continue to be available in S/4HANA and provide relevant customer information for general data, company code data and sales area data.
Quick overview
| SAP table | KNA1 |
|---|---|
| Short description | General Data in Customer Master |
| Table type | Transparent table |
| Primary key | MANDT (Client), KUNNR (Customer Number) |
| Client-dependent | Yes |
Important fields explained
| Field | SAP field description | What this field means |
|---|---|---|
KUNNR |
Customer Number | Customer Number that uniquely identifies the customer master record in SAP |
NAME1 |
Name 1 | Name of Customer maintained in the customer master record |
LAND1 |
Country/Region Key | Country/ Regiin key that identifies the country or region in which the customer is located |
ORT01 |
City | City in which the customer is located |
ADRNR |
Address | Address number used to link to customer master record that contains with the compete address information |
KTOKD |
Customer Account Group | Customer Account group that classifies customer master record and control settings such as number assignment and field selction during customer master maintenance |
At a glance
- Module
- Financial Accounting
- Application component
- LOGISTICS - GENERAL LO
- Subcomponent
- LOGISTICS BASIC DATA LO-MD
- Specific component
- BUSINESS PARTNERS LO-MD-BP
- Component level 4
- CUSTOMER MASTER LO-MD-BP-CM
Technical details
- Delivery class
- A (Application table: master and transaction data)
- Data class
- APPL0 (Master Data, Transparent Tables)
- Package
- Application development R/3 sales master data (VSCORE)
Primary key fields
| Field | Description | Data element | Type | Length |
|---|---|---|---|---|
MANDT
|
Client | MANDT | CLNT | 3 |
KUNNR
|
Customer Number | KUNNR | CHAR | 10 |
Table fields
264 fields
264 fields
| Field | Description | Data element | Domain | Type | Length | Decimals | Check table |
|---|---|---|---|---|---|---|---|
MANDT
Key
|
Client | MANDT | MANDT | CLNT | 3 | — | T000 |
KUNNR
Key
|
Customer Number | KUNNR | KUNNR | CHAR | 10 | — | |
LAND1
|
Country/Region Key | LAND1_GP | LAND1 | CHAR | 3 | — | T005 |
NAME1
|
Name 1 | NAME1_GP | NAME | CHAR | 35 | — | |
NAME2
|
Name 2 | NAME2_GP | NAME | CHAR | 35 | — | |
ORT01
|
City | ORT01_GP | TEXT35 | CHAR | 35 | — | |
PSTLZ
|
Postal Code | PSTLZ | PSTLZ | CHAR | 10 | — | |
REGIO
|
Region (State, Province, County) | REGIO | REGIO | CHAR | 3 | — | T005S |
SORTL
|
Sort field | SORTL | CHAR10 | CHAR | 10 | — | |
STRAS
|
Street and House Number | STRAS_GP | TEXT35 | CHAR | 35 | — | |
TELF1
|
First telephone number | TELF1 | TEXT16 | CHAR | 16 | — | |
TELFX
|
Fax Number | TELFX | TEXT31 | CHAR | 31 | — | |
XCPDK
|
Indicator: Is the account a one-time account? | XCPDK | XFELD | CHAR | 1 | — | |
ADRNR
|
Address | ADRNR | ADRNR | CHAR | 10 | — | |
MCOD1
|
Search term for matchcode search | MCDD1 | CHAR25 | CHAR | 25 | — | |
MCOD2
|
Search Term for Matchcode Search | MCDD2 | CHAR25 | CHAR | 25 | — | |
MCOD3
|
Search term for matchcode search | MCDD3 | CHAR25 | CHAR | 25 | — | |
ANRED
|
Title | ANRED | TEXT15 | CHAR | 15 | — | |
AUFSD
|
Central order block for customer | AUFSD_X | KAUFS | CHAR | 2 | — | TVAST |
BAHNE
|
Express train station | BAHNE | BAHNH | CHAR | 25 | — | |
BAHNS
|
Train station | BAHNS | BAHNH | CHAR | 25 | — | |
BBBNR
|
International location number (part 1) | BBBNR | NUM07 | NUMC | 7 | — | |
BBSNR
|
International location number (Part 2) | BBSNR | NUM05 | NUMC | 5 | — | |
BEGRU
|
Authorization Group | BRGRU | BRGRU | CHAR | 4 | — | |
BRSCH
|
Industry Key | BRSCH | BRSCH | CHAR | 4 | — | T016 |
BUBKZ
|
Check digit for the international location number | BUBKZ | NUM01 | NUMC | 1 | — | |
DATLT
|
Data communication line no. | DATLT | TEXT14 | CHAR | 14 | — | |
ERDAT
|
Record Created On | ERDAT_RF | DATUM | DATS | 8 | — | |
ERNAM
|
Name of Person who Created the Object | ERNAM_RF | USNAM | CHAR | 12 | — | |
EXABL
|
Indicator: Unloading points exist | EXABL | XFELD | CHAR | 1 | — | |
FAKSD
|
Central billing block for customer | FAKSD_X | FAKSP | CHAR | 2 | — | TVFS |
FISKN
|
Account number of the master record with the fiscal address | FISKN_D | KUNNR | CHAR | 10 | — | KNA1 |
KNAZK
|
Working Time Calendar | KNAZK | WFCID | CHAR | 2 | — | TFACD |
KNRZA
|
Account Number of an Alternative Payer | KNRZA | KUNNR | CHAR | 10 | — | KNA1 |
KONZS
|
Group key | KONZS | KONZS | CHAR | 10 | — | |
KTOKD
|
Customer Account Group | KTOKD | KTOKD | CHAR | 4 | — | T077D |
KUKLA
|
Customer Classification | KUKLA | KUKLA | CHAR | 2 | — | TKUKL |
LIFNR
|
Account Number of Supplier | LIFNR | LIFNR | CHAR | 10 | — | LFA1 |
LIFSD
|
Central delivery block for the customer | LIFSD_X | LIFSP | CHAR | 2 | — | TVLS |
LOCCO
|
City Coordinates | LOCCO | LOCCO | CHAR | 10 | — | |
LOEVM
|
Central Deletion Flag for Master Record | LOEVM_X | XFELD | CHAR | 1 | — | |
NAME3
|
Name 3 | NAME3_GP | NAME | CHAR | 35 | — | |
NAME4
|
Name 4 | NAME4_GP | NAME | CHAR | 35 | — | |
NIELS
|
Nielsen ID | NIELS | NIELS | CHAR | 2 | — | TNLS |
ORT02
|
District | ORT02_GP | TEXT35 | CHAR | 35 | — | |
PFACH
|
PO Box | PFACH | PFACH | CHAR | 10 | — | |
PSTL2
|
P.O. Box Postal Code | PSTL2 | PSTLZ | CHAR | 10 | — | |
COUNC
|
County Code | COUNC | COUNC | CHAR | 3 | — | T005E |
CITYC
|
City Code | CITYC | CITYC | CHAR | 4 | — | T005G |
RPMKR
|
Regional market | RPMKR | RPMKR | CHAR | 5 | — | |
SPERR
|
Central posting block | SPERB_X | XFELD | CHAR | 1 | — | |
SPRAS
|
Language Key | SPRAS | SPRAS | LANG | 1 | — | T002 |
STCD1
|
Tax Number 1 | STCD1 | STCD1 | CHAR | 16 | — | |
STCD2
|
Tax Number 2 | STCD2 | STCD2 | CHAR | 11 | — | |
STKZA
|
Indicator: Business Partner Subject to Equalization Tax? | STKZA | STKZA | CHAR | 1 | — | |
STKZU
|
Liable for VAT | STKZU | XFELD | CHAR | 1 | — | |
TELBX
|
Telebox Number | TELBX | TEXT15 | CHAR | 15 | — | |
TELF2
|
Second telephone number | TELF2 | TEXT16 | CHAR | 16 | — | |
TELTX
|
Teletex Number | TELTX | TEXT30 | CHAR | 30 | — | |
TELX1
|
Telex Number | TELX1 | TEXT30 | CHAR | 30 | — | |
LZONE
|
Transportation zone to or from which the goods are delivered | LZONE | ZONE | CHAR | 10 | — | TZONE |
XZEMP
|
Indicator: Is an alternative payer allowed in document? | XREGU | XFELD | CHAR | 1 | — | |
VBUND
|
Company ID of Trading Partner | RASSC | RCOMP | CHAR | 6 | — | T880 |
STCEG
|
VAT Registration Number | STCEG | STCEG | CHAR | 20 | — | |
DEAR1
|
Indicator: Competitor | DEAR1 | XFELD | CHAR | 1 | — | |
DEAR2
|
Indicator: Sales partner | DEAR2 | XFELD | CHAR | 1 | — | |
DEAR3
|
Indicator: Sales prospect | DEAR3 | DEAR3 | CHAR | 1 | — | |
DEAR4
|
Indicator for customer type 4 | DEAR4 | XFELD | CHAR | 1 | — | |
DEAR5
|
ID for default sold-to party | DEAR5 | XFELD | CHAR | 1 | — | |
GFORM
|
Legal status | GFORM | GFORM | CHAR | 2 | — | TVGF |
BRAN1
|
Industry code 1 | BRAN1_D | BRACO | CHAR | 10 | — | TBRC |
BRAN2
|
Industry code 2 | BRAN2 | BRACO | CHAR | 10 | — | TBRC |
BRAN3
|
Industry code 3 | BRAN3 | BRACO | CHAR | 10 | — | TBRC |
BRAN4
|
Industry code 4 | BRAN4 | BRACO | CHAR | 10 | — | TBRC |
BRAN5
|
Industry code 5 | BRAN5 | BRACO | CHAR | 10 | — | TBRC |
EKONT
|
Initial contact | EKONT | VBELN | CHAR | 10 | — | |
UMSAT
|
Annual sales | UMSAT | UMSAT | CURR | 8 | 2 | |
UMJAH
|
Year For Which Sales are Given | UMJAH | JAHR | NUMC | 4 | — | |
UWAER
|
Currency of sales figure | UWAER | WAERS | CUKY | 5 | — | TCURC |
JMZAH
|
Yearly number of employees | JMZAH | JMZAH | NUMC | 6 | — | |
JMJAH
|
Year for which the number of employees is given | JMJAH | JAHR | NUMC | 4 | — | |
KATR1
|
Attribute 1 | KATR1 | ATTR1 | CHAR | 2 | — | TVK1 |
KATR2
|
Attribute 2 | KATR2 | ATTR2 | CHAR | 2 | — | TVK2 |
KATR3
|
Attribute 3 | KATR3 | ATTR3 | CHAR | 2 | — | TVK3 |
KATR4
|
Attribute 4 | KATR4 | ATTR4 | CHAR | 2 | — | TVK4 |
KATR5
|
Attribute 5 | KATR5 | ATTR5 | CHAR | 2 | — | TVK5 |
KATR6
|
Attribute 6 | KATR6 | ATTR6 | CHAR | 3 | — | TVK6 |
KATR7
|
Attribute 7 | KATR7 | ATTR7 | CHAR | 3 | — | TVK7 |
KATR8
|
Attribute 8 | KATR8 | ATTR8 | CHAR | 3 | — | TVK8 |
KATR9
|
Attribute 9 | KATR9 | ATTR9 | CHAR | 3 | — | TVK9 |
KATR10
|
Attribute 10 | KATR10 | ATTR10 | CHAR | 3 | — | TVK0 |
STKZN
|
Natural Person | STKZN | STKZN | CHAR | 1 | — | |
UMSA1
|
Annual sales | UMSA1 | UMSA1 | CURR | 15 | 2 | |
TXJCD
|
Tax Jurisdiction | TXJCD | TXJCD | CHAR | 15 | — | TTXJ |
PERIV
|
Fiscal Year Variant | PERIV | PERIV | CHAR | 2 | — | T009 |
ABRVW
|
Usage Indicator | ABRVW | ABRVW | CHAR | 3 | — | TVLV |
INSPBYDEBI
|
Inspection Carried Out By Customer (No Inspection Lot) | QINSPBYDEB | QKZ | CHAR | 1 | — | |
INSPATDEBI
|
Inspection for a Delivery Note After Outbound Delivery | QINSPATDEB | QKZ | CHAR | 1 | — | |
KTOCD
|
Reference Account Group for One-Time Account (Customer) | KTOCD | KTOKD | CHAR | 4 | — | T077D |
PFORT
|
PO Box city | PFORT_GP | TEXT35 | CHAR | 35 | — | |
WERKS
|
Plant | WERKS_D | WERKS | CHAR | 4 | — | T001W |
DTAMS
|
Recipient Code for Data Medium Exchange | DTAMS | DTAMS | CHAR | 1 | — | |
DTAWS
|
Instruction Key for Data Medium Exchange | DTAWS | DTAWS | CHAR | 2 | — | |
DUEFL
|
Status of Data Transfer into Subsequent Release | DUEFL_BKPF | DUEFL_BKPF | CHAR | 1 | — | |
HZUOR
|
Assignment to Hierarchy | HZUOR | HZUOR | NUMC | 2 | — | |
SPERZ
|
Payment Block | SPERZ | XFELD | CHAR | 1 | — | |
ETIKG
|
IS-R Labeling: customer/plant group | ETIKG | ETIKG | CHAR | 10 | — | TWEK |
CIVVE
|
ID for mainly non-military use | CIVVE | XFELD | CHAR | 1 | — | |
MILVE
|
ID for mainly military use | MILVE | XFELD | CHAR | 1 | — | |
KDKG1
|
Customer condition group 1 | KDKG1 | KDKGR | CHAR | 2 | — | TVKGG |
KDKG2
|
Customer condition group 2 | KDKG2 | KDKGR | CHAR | 2 | — | TVKGG |
KDKG3
|
Customer condition group 3 | KDKG3 | KDKGR | CHAR | 2 | — | TVKGG |
KDKG4
|
Customer condition group 4 | KDKG4 | KDKGR | CHAR | 2 | — | TVKGG |
KDKG5
|
Customer condition group 5 | KDKG5 | KDKGR | CHAR | 2 | — | TVKGG |
XKNZA
|
Indicator: Alternative payer using account number | XKNZA | XFELD | CHAR | 1 | — | |
FITYP
|
Tax Type | J_1AFITP_D | J_1AFITP | CHAR | 2 | — | J_1AFITP |
STCDT
|
Tax Number Type | J_1ATOID | J_1ATOID | CHAR | 2 | — | J_1ATODC |
STCD3
|
Tax Number 3 | STCD3 | CHAR18 | CHAR | 18 | — | |
STCD4
|
Tax Number 4 | STCD4 | CHAR18 | CHAR | 18 | — | |
STCD5
|
Tax Number 5 | STCD5 | CHAR60 | CHAR | 60 | — | |
STCD6
|
Tax Number 6 | STCD6 | CHAR20 | CHAR | 20 | — | |
XICMS
|
Customer is ICMS-exempt | J_1BTCICMS | XFELD | CHAR | 1 | — | |
XXIPI
|
Customer is IPI-exempt | J_1BTCIPI | XFELD | CHAR | 1 | — | |
XSUBT
|
Customer group for Substituiçao Tributária calculation | J_1BTCST | J_1BTCST1 | CHAR | 3 | — | J_1BTXSTG |
CFOPC
|
Customer's CFOP category | J_1BINDUS1 | J_1BINDUS1 | CHAR | 2 | — | |
TXLW1
|
Tax law: ICMS | J_1BTAXLW1 | J_1BTAXLW1 | CHAR | 3 | — | J_1BATL1 |
TXLW2
|
Tax law: IPI | J_1BTAXLW2 | J_1BTAXLW2 | CHAR | 3 | — | J_1BATL2 |
CCC01
|
Indicator for biochemical warfare for legal control | CCC01 | XFELD | CHAR | 1 | — | |
CCC02
|
Indicator for nuclear nonproliferation for legal control | CCC02 | XFELD | CHAR | 1 | — | |
CCC03
|
Indicator for national security for legal control | CCC03 | XFELD | CHAR | 1 | — | |
CCC04
|
Indicator for missile technology for legal control | CCC04 | XFELD | CHAR | 1 | — | |
BONDED_AREA_CONFIRM
|
Taiwan: Bonded Area Confirm in Business Partner Extension | TWVAT_BONDED_AREA_CONF | TWVAT_BONDED_AREA_CONF | CHAR | 1 | — | |
DONATE_MARK
|
Taiwan: Donate Mark in Business Partner Extension | TWVAT_DONATE_MARK | TWVAT_DONATE_MARK | CHAR | 1 | — | |
CONSOLIDATE_INVOICE
|
Consolidated Invoicing for Taiwan | TWGUI_CONSOLIDATE_INVOICE | TWGUI_CONSOLIDATE_INVOICE | CHAR | 1 | — | |
ALLOWANCE_TYPE
|
Taiwan: Allowance Type in Business Partner Extension | TWVAT_ALLOWANCE_TYPE | TWVAT_ALLOWANCE_TYPE | CHAR | 1 | — | |
EINVOICE_MODE
|
Taiwan: Mode in Business Partner Extension | TWVAT_EINVOICE_MODE | TWVAT_EINVOICE_MODE | CHAR | 1 | — | |
B2C_INDICATOR
|
Taiwan: B2C Invoicing in Business Partner Extension | TWVAT_B2C_INDICATOR | XFELD | CHAR | 1 | — | |
CASSD
|
Central sales block for customer | CASSD_X | CASSP | CHAR | 2 | — | |
KNURL
|
Uniform resource locator | URL | TEXT132 | CHAR | 132 | — | |
J_1KFREPRE
|
Name of Representative | REPRES | REPRES | CHAR | 10 | — | |
J_1KFTBUS
|
Type of Business | GESTYP | GESTYP | CHAR | 30 | — | BUSTYPE |
J_1KFTIND
|
Type of Industry | INDTYP | INDTYP | CHAR | 30 | — | INDUSTYPE |
CONFS
|
Status of Change Authorization (Central) | CONFS_X | CHAR1 | CHAR | 1 | — | |
UPDAT
|
Date on Which the Changes Were Confirmed | UPDAT_RF | DATUM | DATS | 8 | — | |
UPTIM
|
Time of Last Change Confirmation | UPTIM_RF | AS4TIME | TIMS | 6 | — | |
NODEL
|
Central deletion block for master record | NODEL_X | XFELD | CHAR | 1 | — | |
DEAR6
|
Indicator: Consumer | DEAR6 | XFELD | CHAR | 1 | — | |
DELIVERY_DATE_RULE
|
Delivery Date Rule | SD_DELIVERY_DATE_TYPE_RULE | SD_DELIVERY_DATE_TYPE_RULE | CHAR | 1 | — | |
CVP_XBLCK
|
Business Purpose Completed Flag | CVP_XBLCK | CVP_XBLCK | CHAR | 1 | — | |
SUFRAMA
|
Suframa Code | J_1BSUFRAMA | J_1BSUFRAMA | CHAR | 9 | — | |
RG
|
RG Number | J_1BRG | J_1BRG | CHAR | 11 | — | |
EXP
|
Issued by | J_1BEXP | J_1BEXP | CHAR | 3 | — | |
UF
|
State | J_1BUF | J_1BUF | CHAR | 2 | — | |
RGDATE
|
RG Issuing Date | J_1BRGDATE | DATUM | DATS | 8 | — | |
RIC
|
RIC Number | J_1BRIC | J_1BRIC | NUMC | 11 | — | |
RNE
|
Foreign National Registration | J_1BRNE | J_1BRNE | CHAR | 10 | — | |
RNEDATE
|
RNE Issuing Date | J_1BRNEDATE | DATUM | DATS | 8 | — | |
CNAE
|
CNAE | J_1BCNAE | J_1BCNAE | CHAR | 7 | — | J_1BTCNAE |
LEGALNAT
|
Legal Nature | J_1BLEGALNAT | J_1BLEGALNAT | NUMC | 4 | — | J_1BTLEGALNAT |
CRTN
|
CRT Number | J_1BCRTN | J_1BCRTN | CHAR | 1 | — | |
ICMSTAXPAY
|
ICMS Taxpayer | J_1BICMSTAXPAY | J_1BICMSTAXPAY | CHAR | 2 | — | J_1BTICMSTAXPAY |
INDTYP
|
Industry Main Type | J_1BINDTYP | J_1BINDTYP | CHAR | 2 | — | J_1BTINDTYP |
TDT
|
Tax Declaration Type | J_1BTDT | J_1BTDT | CHAR | 2 | — | J_1BTTDT |
COMSIZE
|
Company Size | J_1BCOMSIZE | J_1BCOMSIZE | CHAR | 2 | — | J_1BTCOMSIZE |
DECREGPC
|
Declaration Regimen for PIS/COFINS | J_1BDECREGPC | J_1BDECREGPC | CHAR | 2 | — | J_1BTDECREGPC |
PH_BIZ_STYLE
|
PH Business Style Text | PH_BIZ_STYLE | PH_BIZ_STYLE | CHAR | 140 | — | |
PAYTRSN
|
Payment Reason | FARP_PAYT_RSN | FARP_PAYT_RSN | CHAR | 4 | — | |
KNA1_EEW_CUST
|
data element for customer | KNA1_EEW_CUST | KNA1_EEW_CUST | CHAR | 1 | — | |
RULE_EXCLUSION
|
Account Excluded from Rule-Based Assignment | CRMT_BUS_RULE_EXCLUSION | CRM_BOOLEAN | CHAR | 1 | — | |
KNA1_ADDR_EEW_CUST
|
Customer General addr. dep. extensibility | KNA1_ADDR_EEW_CUST | KNA1_ADDR_EEW_CUST | CHAR | 1 | — | |
DATA_CTRLR1
|
BP: Data Controller (Internal Use Only) | BU_DATA_CONTROLLER | DCA_NAME_30 | CHAR | 30 | — | |
DATA_CTRLR2
|
BP: Data Controller (Internal Use Only) | BU_DATA_CONTROLLER | DCA_NAME_30 | CHAR | 30 | — | |
DATA_CTRLR3
|
BP: Data Controller (Internal Use Only) | BU_DATA_CONTROLLER | DCA_NAME_30 | CHAR | 30 | — | |
DATA_CTRLR4
|
BP: Data Controller (Internal Use Only) | BU_DATA_CONTROLLER | DCA_NAME_30 | CHAR | 30 | — | |
DATA_CTRLR5
|
BP: Data Controller (Internal Use Only) | BU_DATA_CONTROLLER | DCA_NAME_30 | CHAR | 30 | — | |
DATA_CTRLR6
|
BP: Data Controller (Internal Use Only) | BU_DATA_CONTROLLER | DCA_NAME_30 | CHAR | 30 | — | |
DATA_CTRLR7
|
BP: Data Controller (Internal Use Only) | BU_DATA_CONTROLLER | DCA_NAME_30 | CHAR | 30 | — | |
DATA_CTRLR8
|
BP: Data Controller (Internal Use Only) | BU_DATA_CONTROLLER | DCA_NAME_30 | CHAR | 30 | — | |
DATA_CTRLR9
|
BP: Data Controller (Internal Use Only) | BU_DATA_CONTROLLER | DCA_NAME_30 | CHAR | 30 | — | |
DATA_CTRLR10
|
BP: Data Controller (Internal Use Only) | BU_DATA_CONTROLLER | DCA_NAME_30 | CHAR | 30 | — | |
XDCSET
|
BP: Data Controller Set Flag | BU_XDCSET | BU_XDCSET | CHAR | 1 | — | |
/VSO/R_PALHGT
|
Maximum Stacking Height of the Packaging Material (VSO) | /VSO/R_PAL_BIN_HGT | MENG13 | QUAN | 13 | 3 | |
/VSO/R_PAL_UL
|
Unit of Length for Packaging Material (VSO) | /VSO/R_PAL_UNIT_L | MEINS | UNIT | 3 | — | T006 |
/VSO/R_PK_MAT
|
Customer-Related Packing for Each Packaging Material (VSO) | /VSO/M_PACK_BY_MAT | /VSO/M_XFIELD | CHAR | 1 | — | |
/VSO/R_MATPAL
|
Packaging Material of the Customer in VSO | /VSO/M_MATNR_PAL | MATNR | CHAR | 40 | — | MARA |
/VSO/R_I_NO_LYR
|
Number Layers Under an Inter-Pallet (VSO) | /VSO/M_IPAL_NO_LYR | /VSO/M_IPAL_NO_LYR | NUMC | 2 | — | |
/VSO/R_ONE_MAT
|
Packing Material-Specific for Each Packaging Material | /VSO/M_ONE_MAT | /VSO/M_XFIELD | CHAR | 1 | — | |
/VSO/R_ONE_SORT
|
Pack Only One Package Type for Each PKM (VSO) | /VSO/M_ONE_SORT | /VSO/M_XFIELD | CHAR | 1 | — | |
/VSO/R_ULD_SIDE
|
Side Preference of Loading/Unloading (VSO) | /VSO/M_UNLOAD_SIDE_PREF | /VSO/M_SIDE_PREF | NUMC | 1 | — | |
/VSO/R_LOAD_PREF
|
Front/Back Preference of Loading/Unloading (VSO) | /VSO/M_LOAD_PREF | /VSO/M_LOAD_PREF | NUMC | 1 | — | |
/VSO/R_DPOINT
|
Collective Unloading Point for VSO | /VSO/R_DELIVERYPOINT | /VSO/R_DELIVERYPOINT | CHAR | 10 | — | /VSO/R_DPOINT |
ALC
|
Agency Location Code | FMFG_ALC | FMFG_ALC | CHAR | 8 | — | FMFGT_ALC |
PMT_OFFICE
|
Payment Office | FMFG_PMT_OFF | FMFG_PMT_OFF | CHAR | 5 | — | FMFGT_PO |
FEE_SCHEDULE
|
Fee schedule | FM_FEE_SCHED | FM_FEE_SCHED | CHAR | 4 | — | |
DUNS
|
DUNS Number | FMCCRDUNS | — | CHAR | 9 | — | |
DUNS4
|
DUNS+4 | FMCCRDUNS4 | — | CHAR | 4 | — | |
SAM_UE_ID
|
System for Award Management Unique Entity Identifier | FMFG_UNIQUE_ENTITY_ID | — | CHAR | 12 | — | |
SAM_EFT_IND
|
System for Award Management Electronic Funds Transfer Ind | FMFG_EFT_IND | — | CHAR | 4 | — | |
PSOFG
|
Processor group | PSOFG | PSOFG | CHAR | 10 | — | PSO19 |
PSOIS
|
Subledger acct preprocessing procedure | PSOIS | CHAR20 | CHAR | 20 | — | |
PSON1
|
Name 1 | NAME1_GP | NAME | CHAR | 35 | — | |
PSON2
|
Name 2 | NAME2_GP | NAME | CHAR | 35 | — | |
PSON3
|
Name 3 | NAME3_GP | NAME | CHAR | 35 | — | |
PSOVN
|
First Name | PSOVN | NAME | CHAR | 35 | — | |
PSOTL
|
Title | PSOTL | FMPSOTL | CHAR | 20 | — | |
PSOHS
|
House number: is no longer used from Release 4.6B | PSOHS | CHAR06 | CHAR | 6 | — | |
PSOST
|
Street: No longer used from Release 4.6B | PSOST | PSOST | CHAR | 28 | — | |
PSOO1
|
Description | PSOO1 | TEXT50 | CHAR | 50 | — | |
PSOO2
|
Description | PSOO1 | TEXT50 | CHAR | 50 | — | |
PSOO3
|
Description | PSOO1 | TEXT50 | CHAR | 50 | — | |
PSOO4
|
Description | PSOO1 | TEXT50 | CHAR | 50 | — | |
PSOO5
|
Description | PSOO1 | TEXT50 | CHAR | 50 | — | |
J_1IEXCD
|
ECC Number | J_1IEXCD | CHAR40 | CHAR | 40 | — | |
J_1IEXRN
|
Excise Registration Number | J_1IEXRN | CHAR40 | CHAR | 40 | — | |
J_1IEXRG
|
Excise Range | J_1IEXRG | CHAR60 | CHAR | 60 | — | |
J_1IEXDI
|
Excise Division | J_1IEXDI | CHAR60 | CHAR | 60 | — | |
J_1IEXCO
|
Excise Commissionerate | J_1IEXCO | CHAR60 | CHAR | 60 | — | |
J_1ICSTNO
|
Central Sales Tax Number | J_1ICSTNO | CHAR40 | CHAR | 40 | — | |
J_1ILSTNO
|
Local Sales Tax Number | J_1ILSTNO | CHAR40 | CHAR | 40 | — | |
J_1IPANNO
|
Permanent Account Number | J_1IPANNO | CHAR40 | CHAR | 40 | — | |
J_1IEXCICU
|
Excise tax indicator for customer | J_1IEXCICU | J_1IINDTAX | CHAR | 1 | — | J_1ITAXIND |
AEDAT
|
(Obsolete) Last Changed On – do not use | J_1IAEDAT_OBSOLETE | DATUM | DATS | 8 | — | |
USNAM
|
(Obsolete) Changed by the user – do not use | J_1IUSNAM_OBSOLETE | CHAR12 | CHAR | 12 | — | |
J_1ISERN
|
Service Tax Registration Number | J_1ISERN | CHAR40 | CHAR | 40 | — | |
J_1IPANREF
|
PAN Reference Number | J_1IPANREF | CHAR40 | CHAR | 40 | — | |
GST_TDS
|
GST TDS Registration | J_1IGSTTDS | J_1IGSTCD3 | CHAR | 18 | — | |
J_3GETYP
|
Recipient Type | J_3GETYP | J_3GETYP | CHAR | 2 | — | J_3GZUETYP |
J_3GREFTYP
|
Reference Type for Recipient | J_3GREFTYP | J_3GREFTYP | CHAR | 2 | — | |
PSPNR
|
WBS Element | PS_POSNR | PS_POSNR | NUMC | 8 | — | PRPS |
COAUFNR
|
Order Number | AUFNR | AUFNR | CHAR | 12 | — | AUFK |
J_3GAGEXT
|
External Sold-to Party | J_3GAGEXT | KUNNR | CHAR | 10 | — | KNA1 |
J_3GAGINT
|
Customer Internal Settlement | J_3GAGINT | KUNNR | CHAR | 10 | — | KNA1 |
J_3GAGDUMI
|
Dummy Recipient | J_3GDEMPST | KUNNR | CHAR | 10 | — | KNA1 |
J_3GAGSTDI
|
Standard Recipient | J_3GAGSTDI | KUNNR | CHAR | 10 | — | KNA1 |
LGORT
|
Storage Location | LGORT_D | LGORT | CHAR | 4 | — | T001L |
KOKRS
|
Controlling Area | KOKRS | CACCD | CHAR | 4 | — | TKA01 |
KOSTL
|
Cost Center | KOSTL | KOSTL | CHAR | 10 | — | CSKS |
J_3GABGLG
|
Retirement Date Counts for Performance-Based Equipment | J_3GABGLG | X | CHAR | 1 | — | |
J_3GABGVG
|
Retirement Date Counts for Time-Based Equipment | J_3GABGVG | X | CHAR | 1 | — | |
J_3GABRART
|
Settlement Type | J_3GABRART | J_3GABRART | CHAR | 1 | — | |
J_3GSTDMON
|
Hours per Month | J_3GSTDMON | DEC03_2 | DEC | 5 | 2 | |
J_3GSTDTAG
|
Hours per Day | J_3GSTDTAG | DEC03_2 | DEC | 5 | 2 | |
J_3GTAGMON
|
Number of Days/Month | J_3GTAGMON | DEC3_2 | DEC | 5 | 2 | |
J_3GZUGTAG
|
Function for Settlement on Acquisition Date/PBE | J_3GZUGTAG | X | CHAR | 1 | — | |
J_3GMASCHB
|
"Fill PBE Documents" Indicator | J_3GMASCHB | J_3GMASCHB | CHAR | 1 | — | |
J_3GMEINSA
|
Indicator: Take Multiple Usage Periods into Account | J_3GMEINSA | X | CHAR | 1 | — | |
J_3GKEINSA
|
Indicator - Relevant to Short Operation Periods | J_3GKEINSA | X | CHAR | 1 | — | |
J_3GBLSPER
|
Blocking Indicator for Document Entry | J_3GBLSPER | X | CHAR | 1 | — | |
J_3GKLEIVO
|
Indicator: Calculate PBE as TBE | J_3GKLEIVO | X | CHAR | 1 | — | |
J_3GCALID
|
Calendar ID | J_3GCALID | WFCID | CHAR | 2 | — | TFACD |
J_3GVMONAT
|
Indicator for Complete Month | J_3GVMONAT | J_3GVMONAT | NUMC | 1 | — | |
J_3GABRKEN
|
Settlement Indicator | J_3GABRKEN | J_3GABRKEN | CHAR | 1 | — | |
J_3GLABRECH
|
Date of Last Settlement | J_3GLABRECH | DATUM | DATS | 8 | — | |
J_3GAABRECH
|
Date of Current Settlement | J_3GAABRECH | DATUM | DATS | 8 | — | |
J_3GZUTVHLG
|
Ind.: Acquisition Date Counts (as Daily Settlement for PBE) | J_3GZUTVHLG | X | CHAR | 1 | — | |
J_3GNEGMEN
|
Negative Quantities Allowed Even for Chronolog. Inv. Mgmt | J_3GNEGMEN | X | CHAR | 1 | — | |
J_3GFRISTLO
|
Indicator: Deadline Logic | J_3GFRISTLO | X | CHAR | 1 | — | |
J_3GEMINBE
|
Minimum Usage Period for Restricted Usage (Days) | J_3GEMINBE | NUMC | NUMC | 5 | — | |
J_3GFMGUE
|
Release Notification Allowance for Unrestricted Usage (Days) | J_3GFMGUE | NUMC | NUMC | 5 | — | |
J_3GZUSCHUE
|
Surcharge for Unrestricted Usage (Days) | J_3GZUSCHUE | NUMC | NUMC | 5 | — | |
J_3GSCHPRS
|
Indicator: Shift Price | J_3GSCHPRS | X | CHAR | 1 | — | |
J_3GINVSTA
|
Status of Construction Site Inventory | J_3GINVSTA | J_3GINVSTA | CHAR | 1 | — | |
/SAPCEM/DBER
|
Planning Area | /SAPCEM/DBER | /SAPCEM/DBER | CHAR | 8 | — | /SAPCEM/DISPOBER |
/SAPCEM/KVMEQ
|
Indicator: Settlement Qty Relevant to Equipment | /SAPCEM/KVMEQ | /SAPCEM/KVMEQ | CHAR | 1 | — |
No fields match the selected filters.
SAP KNA1 Table Availability
| SAP product | Verified release/system | Table availability | Verified on |
|---|---|---|---|
| SAP S/4HANA | 2023 - On-Premise - Initial Shipment Stack | Available |
Related SAP Tables
| Table | Description | Common Key Fields with KNA1 |
|---|---|---|
| KNB1 | Customer Master (Company Code) | MANDT, KUNNR |
| KNVP | Customer Master Partner Functions | MANDT, KUNNR |
| KNVV | Customer Master Sales Data | MANDT, KUNNR |
| KNB5 | Customer master (dunning data) | MANDT, KUNNR |
| KNBK | Customer Master (Bank Details) | MANDT, KUNNR |
Fields marked as primary keys in both tables. Additional fields or filters may be needed when joining records.
Editorial and verification
- Content editor
- ERPSAP Content Team
- Technical reviewer
- ERPSAP Technical Review Team
- Verified against
- SAP S/4HANA 2023 On-Premise system
- Last updated
- October 8, 2026
The information on this SAP KNA1 table page is based on the verified SAP S/4HANA 2023 on-premise system identified above. Table definitions, fields, and availability may differ across SAP releases and customer-specific systems.