KNA1 is a standard Customer Master Transparent Table in SAP Logistics application, which stores General Data in Customer Master data. Below you can view the Table Structure, columns(fields), SAP Wiki pages, discussion threads, related TCodes, FMs, ABAP Reports, BW Datasources, and Authorization Objects for KNA1. You can use the transaction code SE16 to view the data in this table, and SE11 TCode for the table structure and definition.

KNA1 — Meta Data

Description: General Data in Customer Master
Main Category: Logistics
Sub Category: Customer Master
Table type: Transparent Table (TRANSP)

KNA1 — Table Structure, Fields(Columns) and Definitions

    Position Column Name Description Primary Key Data Type Length Check Table
    1 MANDT Client X CLNT 3 T000
    2 KUNNR Customer X CHAR 10
    3 LAND1 Country CHAR 3 T005
    4 NAME1 Name 1 CHAR 35
    5 NAME2 Name 2 CHAR 35
    6 ORT01 City CHAR 35
    7 PSTLZ P.Code/City CHAR 10
    8 REGIO Region (State CHAR 3 T005S
    9 SORTL Sort field CHAR 10
    10 STRAS House number and street CHAR 35
    11 TELF1 First telephone number CHAR 16
    12 TELFX Fax Number CHAR 31
    13 XCPDK Indicator: Is the account a one-time account? CHAR 1
    14 ADRNR Address CHAR 10
    15 MCOD1 Search term for matchcode search CHAR 25
    16 MCOD2 Search term for matchcode search CHAR 25
    17 MCOD3 Search term for matchcode search CHAR 25
    18 .INCLUDE 0
    19 ANRED Form of address CHAR 15
    20 AUFSD Single-Character Flag CHAR 2 TVAST
    21 BAHNE Single-Character Flag CHAR 25
    22 BAHNS Train station CHAR 25
    23 BBBNR International location number (part 1) NUMC 7
    24 BBSNR International location number (Part 2) NUMC 5
    25 BEGRU Authorization Group CHAR 4 *
    26 BRSCH Industry key CHAR 4 T016
    27 BUBKZ Check digit for the international location number NUMC 1
    28 DATLT Data communication line no. CHAR 14
    29 ERDAT Created on DATS 8
    30 ERNAM Created by CHAR 12
    31 EXABL Indicator: Unloading points exist CHAR 1
    32 FAKSD Single-Character Flag CHAR 2 TVFS
    33 FISKN Account number of the master record with fiscal address CHAR 10 KNA1
    34 KNAZK Working Time Calendar CHAR 2 TFACD
    35 KNRZA Account Number of an Alternative Payer CHAR 10 KNA1
    36 KONZS Group key CHAR 10
    37 KTOKD Customer Account Group CHAR 4 T077D
    38 KUKLA Single-Character Flag CHAR 2 TKUKL
    39 LIFNR Vendor CHAR 10 LFA1
    40 LIFSD Single-Character Flag CHAR 2 TVLS
    41 LOCCO Single-Character Flag CHAR 10
    42 LOEVM Deletion Indicator CHAR 1
    43 NAME3 Name 3 CHAR 35
    44 NAME4 Name 4 CHAR 35
    45 NIELS Single-Character Flag CHAR 2 TNLS
    46 ORT02 District CHAR 35
    47 PFACH PO Box CHAR 10
    48 PSTL2 P.O. Box Postal Code CHAR 10
    49 COUNC County code CHAR 3 T005E
    50 CITYC City Code CHAR 4 T005G
    51 RPMKR Regional market CHAR 5
    52 SPERR Central posting block CHAR 1
    53 SPRAS Language Key LANG 1 T002
    54 STCD1 Tax Number 1 CHAR 16
    55 STCD2 Tax Number 2 CHAR 11
    56 STKZA Indicator: Business Partner Subject to Equalization Tax? CHAR 1
    57 STKZU Liable for VAT CHAR 1
    58 TELBX Telebox number CHAR 15
    59 TELF2 Second telephone number CHAR 16
    60 TELTX Teletex number CHAR 30
    61 TELX1 Telex number CHAR 30
    62 LZONE Transportation zone to or from which the goods are delivered CHAR 10 TZONE
    63 XZEMP Indicator: Alternative payee in document allowed ? CHAR 1
    64 VBUND Trading Partner CHAR 6 T880
    65 STCEG VAT registration number CHAR 20
    66 DEAR1 Indicator: Competitor CHAR 1
    67 DEAR2 Indicator: Sales partner CHAR 1
    68 DEAR3 Indicator: Sales prospect CHAR 1
    69 DEAR4 Indicator for customer type 4 CHAR 1
    70 DEAR5 ID for default sold-to party CHAR 1
    71 GFORM Transaction Form CHAR 2 TVGF
    72 BRAN1 Single-Character Flag CHAR 10 TBRC
    73 BRAN2 Single-Character Flag CHAR 10 TBRC
    74 BRAN3 Single-Character Flag CHAR 10 TBRC
    75 BRAN4 Single-Character Flag CHAR 10 TBRC
    76 BRAN5 Single-Character Flag CHAR 10 TBRC
    77 EKONT Initial contact CHAR 10
    78 UMSAT Character Field Length = 10 CURR 8
    79 UMJAH Single-Character Flag NUMC 4
    80 UWAER Single-Character Flag CUKY 5 TCURC
    81 JMZAH Single-Character Flag NUMC 6
    82 JMJAH Single-Character Flag NUMC 4
    83 KATR1 Single-Character Flag CHAR 2 TVK1
    84 KATR2 Single-Character Flag CHAR 2 TVK2
    85 KATR3 Single-Character Flag CHAR 2 TVK3
    86 KATR4 Single-Character Flag CHAR 2 TVK4
    87 KATR5 Single-Character Flag CHAR 2 TVK5
    88 KATR6 Single-Character Flag CHAR 3 TVK6
    89 KATR7 Single-Character Flag CHAR 3 TVK7
    90 KATR8 Single-Character Flag CHAR 3 TVK8
    91 KATR9 Single-Character Flag CHAR 3 TVK9
    92 KATR10 Single-Character Flag CHAR 3 TVK0
    93 STKZN Natural Person CHAR 1
    94 UMSA1 Single-Character Flag CURR 15
    95 TXJCD Jurisdiction for Tax Calculation - Tax Jurisdiction Code CHAR 15 TTXJ
    96 PERIV Fi.Year Variant CHAR 2 T009
    97 ABRVW Usage Indicator CHAR 3 TVLV
    98 INSPBYDEBI Inspection Carried Out By Customer (No Inspection Lot) CHAR 1
    99 INSPATDEBI Inspection for a Delivery Note After Outbound Delivery CHAR 1
    100 KTOCD Reference Account Group for One-Time Account (Customer) CHAR 4 T077D
    101 PFORT PO Box city CHAR 35
    102 WERKS Plant CHAR 4 T001W
    103 DTAMS Report key for data medium exchange CHAR 1
    104 DTAWS Instruction key for data medium exchange CHAR 2 *
    105 DUEFL Status of data transfer into subsequent release CHAR 1
    106 HZUOR Assignment to Hierarchy NUMC 2
    107 SPERZ Payment Block CHAR 1
    108 ETIKG IS-R Labeling: customer/plant group CHAR 10 TWEK
    109 CIVVE Single-Character Flag CHAR 1
    110 MILVE Single-Character Flag CHAR 1
    111 KDKG1 Single-Character Flag CHAR 2 TVKGG
    112 KDKG2 Single-Character Flag CHAR 2 TVKGG
    113 KDKG3 Single-Character Flag CHAR 2 TVKGG
    114 KDKG4 Single-Character Flag CHAR 2 TVKGG
    115 KDKG5 Single-Character Flag CHAR 2 TVKGG
    116 XKNZA Indicator: Alternative payer using account number CHAR 1
    117 FITYP Tax type CHAR 2 J_1AFITP
    118 STCDT Tax Number Type CHAR 2 J_1ATODC
    119 STCD3 Tax Number 3 CHAR 18
    120 STCD4 Tax Number 4 CHAR 18
    121 STCD5 Tax Number 5 CHAR 60
    122 XICMS Single-Character Flag CHAR 1
    123 XXIPI Single-Character Flag CHAR 1
    124 XSUBT Single-Character Flag CHAR 3 J_1BTXSTG
    125 CFOPC Single-Character Flag CHAR 2
    126 TXLW1 Tax law: ICMS CHAR 3 J_1BATL1
    127 TXLW2 Tax law: IPI CHAR 3 J_1BATL2
    128 CCC01 Single-Character Flag CHAR 1
    129 CCC02 Single-Character Flag CHAR 1
    130 CCC03 Single-Character Flag CHAR 1
    131 CCC04 Single-Character Flag CHAR 1
    132 .INCLUDE 0
    133 BONDED_AREA_CONFIRM CHAR 1
    134 DONATE_MARK CHAR 1
    135 CASSD Single-Character Flag CHAR 2
    136 KNURL Uniform resource locator CHAR 132
    137 J_1KFREPRE Name of Representative CHAR 10
    138 J_1KFTBUS Type of Business CHAR 30 BUSTYPE
    139 J_1KFTIND Type of Industry CHAR 30 INDUSTYPE
    140 CONFS Status of Change Authorization (Central) CHAR 1
    141 UPDAT Update DATS 8
    142 UPTIM Time of Last Change (in UTC) TIMS 6
    143 NODEL Central deletion block for master record CHAR 1
    144 DEAR6 Indicator: Consumer CHAR 1
    145 CVP_XBLCK Business Purpose Completed Flag CHAR 1
    146 .INCLUDE 0
    147 SUFRAMA [OBSOLETE] SUFRAMA Code CHAR 9
    148 RG RG Number CHAR 11
    149 EXP Issued by CHAR 3
    150 UF State CHAR 2
    151 RGDATE RG Issuing Date DATS 8
    152 RIC RIC Number NUMC 11
    153 RNE Foreign National Registration CHAR 10
    154 RNEDATE RNE Issuing Date DATS 8
    155 CNAE CNAE CHAR 7 J_1BTCNAE
    156 LEGALNAT Legal Nature NUMC 4 J_1BTLEGALNAT
    157 CRTN CRT Number CHAR 1
    158 ICMSTAXPAY ICMS Taxpayer CHAR 2 J_1BTICMSTAXPAY
    159 INDTYP Industry Main Type CHAR 2 J_1BTINDTYP
    160 TDT Tax Declaration Type CHAR 2 J_1BTTDT
    161 COMSIZE Company Size CHAR 2 J_1BTCOMSIZE
    162 DECREGPC Declaration Regimen for PIS/COFINS CHAR 2 J_1BTDECREGPC
    163 .INCLUDE 0
    164 KNA1_EEW_CUST CHAR 1
    165 .INCLU--AP 0
    166 .INCLUDE 0
    167 /VSO/R_PALHGT Maximum Stacking Height of the Packaging Material (VSO) QUAN 13
    168 /VSO/R_PAL_UL Unit of Length for Packaging Material (VSO) UNIT 3 T006
    169 /VSO/R_PK_MAT Customer-Related Packing for Each Packaging Material (VSO) CHAR 1
    170 /VSO/R_MATPAL Packaging Material of the Customer in VSO CHAR 40 MARA
    171 /VSO/R_I_NO_LYR Number Layers Under an Inter-Pallet (VSO) NUMC 2
    172 /VSO/R_ONE_MAT Packing Material-Specific for Each Packaging Material CHAR 1
    173 /VSO/R_ONE_SORT Pack Only One Package Type for Each PKM (VSO) CHAR 1
    174 /VSO/R_ULD_SIDE Side Preference of Loading/Unloading (VSO) NUMC 1
    175 /VSO/R_LOAD_PREF Front/Back Preference of Loading/Unloading (VSO) NUMC 1
    176 /VSO/R_DPOINT Collective Unloading Point for VSO CHAR 10 /VSO/R_DPOINT
    177 .INCLU--AP 0
    178 ALC Agency Location Code CHAR 8 FMFGT_ALC
    179 PMT_OFFICE Payment Office CHAR 5 FMFGT_PO
    180 .INCLUDE 0
    181 FEE_SCHEDULE Updated information in related user data field CHAR 4
    182 DUNS Data Universal Numbering System CHAR 9
    183 DUNS4 Obsolete as of AP 7.0 D-U-N-S+4 number CHAR 4
    184 .INCLU--AP 0
    185 PSOFG Processor group CHAR 10 PSO19
    186 PSOIS Subledger acct preprocessing procedure CHAR 20
    187 .INCLUDE 0
    188 PSON1 Name 1 CHAR 35
    189 PSON2 Name 2 CHAR 35
    190 PSON3 Name 3 CHAR 35
    191 PSOVN First Name CHAR 35
    192 PSOTL Title CHAR 20
    193 PSOHS House number: is no longer used from Release 4.6B CHAR 6
    194 PSOST Street: No longer used from Release 4.6B CHAR 28
    195 .INCLUDE 0
    196 PSOO1 Description CHAR 50
    197 PSOO2 Description CHAR 50
    198 PSOO3 Description CHAR 50
    199 PSOO4 Description CHAR 50
    200 PSOO5 Description CHAR 50
    201 .INCLU--AP 0
    202 J_1IEXCD ECC Number CHAR 40
    203 J_1IEXRN Excise Registration Number CHAR 40
    204 J_1IEXRG Excise Range CHAR 60
    205 J_1IEXDI Excise Division CHAR 60
    206 J_1IEXCO Excise Commissionerate CHAR 60
    207 J_1ICSTNO Central Sales Tax Number CHAR 40
    208 J_1ILSTNO Local Sales Tax Number CHAR 40
    209 J_1IPANNO Permanent Account Number CHAR 40
    210 J_1IEXCICU Excise tax indicator for customer CHAR 1 J_1ITAXIND
    211 AEDAT Changed on DATS 8
    212 USNAM User name CHAR 12
    213 J_1ISERN Service Tax Registration Number CHAR 40
    214 J_1IPANREF PAN Reference Number CHAR 40
    215 .INCLU--AP 0
    216 .INCLUDE 0
    217 J_3GETYP Recipient Type (do not use) CHAR 2 J_3GZUETYP
    218 J_3GREFTYP Reference Type for Recipient CHAR 2
    219 PSPNR Project definition (internal) NUMC 8 PRPS
    220 COAUFNR Order Number (QM Order) CHAR 12 AUFK
    221 J_3GAGEXT External Sold-to Party CHAR 10 KNA1
    222 J_3GAGINT Customer Internal Settlement CHAR 10 KNA1
    223 J_3GAGDUMI Dummy Recipient CHAR 10 KNA1
    224 J_3GAGSTDI Standard Recipient CHAR 10 KNA1
    225 LGORT Stor. Location CHAR 4 T001L
    226 KOKRS CO Area CHAR 4 TKA01
    227 KOSTL Cost Center CHAR 10 CSKS
    228 J_3GABGLG Retirement Date Counts for Performance-Based Equipment CHAR 1
    229 J_3GABGVG Retirement Date Counts for Time-Based Equipment CHAR 1
    230 J_3GABRART Settlement Type CHAR 1
    231 J_3GSTDMON Character Field Length = 10 DEC 5
    232 J_3GSTDTAG Character Field Length = 10 DEC 5
    233 J_3GTAGMON Character Field Length = 10 DEC 5
    234 J_3GZUGTAG Function for Settlement on Acquisition Date/PBE CHAR 1
    235 J_3GMASCHB Fill PBE Documents Indicator CHAR 1
    236 J_3GMEINSA Indicator: Take Multiple Usage Periods into Account CHAR 1
    237 J_3GKEINSA Indicator - Relevant to Short Operation Periods CHAR 1
    238 J_3GBLSPER Blocking Indicator for Document Entry CHAR 1
    239 J_3GKLEIVO Indicator: Calculate PBE as TBE CHAR 1
    240 J_3GCALID Calendar ID CHAR 2 TFACD
    241 J_3GVMONAT Single-Character Flag NUMC 1
    242 J_3GABRKEN Settlement Indicator CHAR 1
    243 J_3GLABRECH Character Field Length = 10 DATS 8
    244 J_3GAABRECH Character Field Length = 10 DATS 8
    245 J_3GZUTVHLG Ind.: Acquisition Date Counts (as Daily Settlement for PBE) CHAR 1
    246 J_3GNEGMEN Negative Quantities Allowed Even for Chronolog. Inv. Mgmt CHAR 1
    247 J_3GFRISTLO Indicator: Deadline Logic CHAR 1
    248 J_3GEMINBE R/2 table NUMC 5
    249 J_3GFMGUE R/2 table NUMC 5
    250 J_3GZUSCHUE R/2 table NUMC 5
    251 J_3GSCHPRS Indicator: Shift Price CHAR 1
    252 J_3GINVSTA Status of Construction Site Inventory CHAR 1
    253 /SAPCEM/DBER Planning Area CHAR 8 /SAPCEM/DISPOBER
    254 /SAPCEM/KVMEQ Indicator: Settlement Qty Relevant to Equipment CHAR 1
    255 .INCLU--AP 0
    256 OIDRC Updated information in related user data field CHAR 5 OICDC
    257 .INCLU--AP 0
    258 OID_POREQD Updated information in related user data field CHAR 1
    259 .INCLU--AP 0
    260 OIPBL Updated information in related user data field CHAR 10 OIFSPBL
    261 .INCLU--AP 0
    262 RES_CNTRY unused, will be deleted in the future CHAR 3
    263 CCODE unused, will be deleted in the future CHAR 4

SAP Help, Wiki Resources, and Forum Discussions on KNA1

Click the above link for the full list of resources and help pages, only the first few are posted below


Related Tables

TABLE Description Functional Area
VBAK Sales Document: Header Data SD - Sales
MARA General Material Data Logistics - Material Master
LFA1 Vendor Master (General Section) FI - Financial Accounting
VBRK Billing Document: Header Data SD - Billing
KNB1 Customer Master (Company Code) FI - Financial Accounting
VBPA Sales Document: Partner SD - Basic Functions
KNVV Customer Master Sales Data Logistics - Customer Master

Transaction Codes for SAP Table KNA1

TCODE Description Functional Area
SPRO Customizing - Edit Project Basis - Customizing Project Management (IMG)
SE11 ABAP Dictionary Maintenance Basis - Dictionary Maintenance
SLIS FI-SL Spec.Purpose Ledg. Info.System FI - Information System
SE16 Data Browser Basis - Workbench Utilities
SE38 ABAP Editor Basis - ABAP Editor
XD01 Create Customer (Centrally) FI - Basic Functions
VA01 Create Sales Order SD - Sales
SE37 ABAP Function Modules Basis - Function Builder

FMs for SAP Table KNA1

FM Description Functional Area
REUSE_ALV_GRID_DISPLAY Output of a simple list (single-line) Basis - SAP List Viewer
REUSE_ALV_COMMENTARY_WRITE List body comment block output BC - SAP List Viewer
GUI_UPLOAD Upload for Data Provider Basis - Graphical User Interface
GUI_DOWNLOAD Download an Internal Table to the PC Basis - Graphical User Interface
REUSE_ALV_EVENTS_GET Returns table of possible events for a list type BC - SAP List Viewer
REUSE_ALV_FIELDCATALOG_MERGE Create field catalog from dictionary structure or internal table BC - SAP List Viewer
READ_TEXT SAPscript: Read text BC - SAPscript
REUSE_ALV_LIST_DISPLAY Output a simple list (single line or several lines) BC - SAP List Viewer

ABAP Reports for SAP Table KNA1

ABAP REPORT Description Functional Area
SAPMF02D Customer Master Data Logistics - Customer Master
RFBIDE00 Batch Input Interface for Customers FI - Financial Accounting
BDCRECX1 Include f Basis - UI Services, Screen, Batch Input
SAPMV45A Sales Order Processing SD - Sales
SAPLKKBL Dynamic List Display
RSCONN01 SAPconnect: Start Send Process Basis - Communication Services: Mail, Fax, SMS, Telephony
SAPLSPO1 ?...
SAPMF02K Vendor Master Data FI - Basic Functions

BW Datasources for SAP Table KNA1

BW DATASOURCE Description Functional Area
0CUSTOMER_ATTR Customer Number Logistics - Logistics - General
2LIS_11_VAITM Sales Document Item Data SD - Sales and Distribution
0CONSUMER_ATTR Consumer SD - Sales and Distribution
2LIS_13_VDITM Billing Document Item Data SD - Sales and Distribution
2LIS_03_BF Goods Movements From Inventory Management MM - Materials Management
2LIS_13_VDHDR Billing Doc. Header Data SD - Sales and Distribution
0FI_GL_4 General Ledger: Line Items with Delta Extraction FI - General Ledger Accounting
0CONSUMER_TEXT Consumer SD - Sales and Distribution

Authorization Objects for SAP Table KNA1

AUTHORIZATION OBJECT Description Functional Area
P_PERNR HR: Master Data - Personnel Number Check
S_CARRID Authorization Object for Airlines
F_KNA1_AEN Customer: Change Authorization for Certain Fields
S_TCODE Transaction Code Check at Transaction Start
F_KNA1_BED Customer: Account Authorization
S_TABU_DIS Table Maintenance (via standard tools such as SM30)
I_TCODE PM: Transaction Code
F_BKPF_KOA Accounting Document: Authorization for Account Types