SE11 ABAP Dictionary SE11 KNA1

Data SE16 SE16
Popular:
VBAK VBAP MARA MAKT BKPF BSEG BVOR EKKO EKPO KNA1 LFA1 LIKP VBRK

KNA1

General Data in Customer Master
SAP SD Transparent Table 168 Fields
Primary Key:
MANDT KUNNR

Dictionary Fields Fields

(168 dari 168 kolom)
# Field Name Key Field Label Type Length Dec Check Table Short Description
1
MANDT
KEY Client CLNT 3 - T000 Client
2
KUNNR
KEY Customer CHAR 10 - KNA1 Customer Number 1
3
LAND1
- Country CHAR 3 - T005 Country Key
4
NAME1
- Name CHAR 35 - - Name 1
5
NAME2
- Name 2 CHAR 35 - - Name 2
6
ORT01
- City CHAR 35 - - City
7
PSTLZ
- Post.Code CHAR 10 - - Postal Code
8
REGIO
- Region CHAR 3 - - Region (State, Province, County)
9
SORTL
- SearchTerm CHAR 10 - - Sort field
10
STRAS
- Street CHAR 35 - - House number and street
11
TELF1
- Telephone1 CHAR 16 - - First telephone number
12
TELFX
- Fax Number CHAR 31 - - Fax Number
13
XCPDK
- One-time CHAR 1 - - Indicator: Is the account a one-time account?
14
ADRNR
- Address CHAR 10 - - Address
15
MCOD1
- Name CHAR 25 - - Search term for matchcode search
16
MCOD2
- Name 2 CHAR 25 - - Search Term for Matchcode Search
17
MCOD3
- City CHAR 25 - - Search term for matchcode search
18
ANRED
- Title CHAR 15 - - Title
19
AUFSD
- Central CHAR 2 - - Central order block for customer
20
BAHNE
- Expr.stat. CHAR 25 - - Express train station
21
BAHNS
- Train stat CHAR 25 - - Train station
22
BBBNR
- Loc.no. 1 NUMC 7 - - International location number (part 1)
23
BBSNR
- Loc.no. 2 NUMC 5 - - International location number (Part 2)
24
BEGRU
- Authoriz. CHAR 4 - - Authorization Group
25
BRSCH
- Industry CHAR 4 - - Industry key
26
BUBKZ
- Chk.digit NUMC 1 - - Check digit for the international location number
27
DATLT
- Data line CHAR 14 - - Data communication line no.
28
ERDAT
- Creat.date DATS 8 - - Date on which the Record Was Created
29
ERNAM
- Created by CHAR 12 - - Name of Person who Created the Object
30
EXABL
- Unload.pt CHAR 1 - - Indicator: Unloading points exist
31
FAKSD
- Central CHAR 2 - - Central billing block for customer
32
FISKN
- Fisc.addr. CHAR 10 - - Account number of the master record with the fiscal address
33
KNAZK
- Work time CHAR 2 - - Working Time Calendar
34
KNRZA
- Alt.payer CHAR 10 - - Account number of an alternative payer
35
KONZS
- Group CHAR 10 - - Group key
36
KTOKD
- Acct Group CHAR 4 - - Customer Account Group
37
KUKLA
- Classific. CHAR 2 - - Customer classification
38
LIFNR
- Vendor CHAR 10 - LFA1 Account Number of Vendor or Creditor
39
LIFSD
- Central CHAR 2 - - Central delivery block for the customer
40
LOCCO
- Loc.code CHAR 10 - - City Coordinates
41
LOEVM
- Del.flag CHAR 1 - - Central Deletion Flag for Master Record
42
NAME3
- Name 3 CHAR 35 - - Name 3
43
NAME4
- Name 4 CHAR 35 - - Name 4
44
NIELS
- Nielsen ID CHAR 2 - - Nielsen ID
45
ORT02
- District CHAR 35 - - District
46
PFACH
- PO Box CHAR 10 - - PO Box
47
PSTL2
- PO Box pcd CHAR 10 - - P.O. Box Postal Code
48
COUNC
- County cde CHAR 3 - - County Code
49
CITYC
- City code CHAR 4 - - City Code
50
RPMKR
- Reg.Market CHAR 5 - - Regional Market
51
SPERR
- PstBlock CHAR 1 - - Central posting block
52
SPRAS
- Language LANG 1 - T002 Language Key
53
STCD1
- Tax No. 1 CHAR 16 - - Tax Number 1
54
STCD2
- Tax No. 2 CHAR 11 - - Tax Number 2
55
STKZA
- Equal.tax CHAR 1 - - Indicator: Business Partner Subject to Equalization Tax?
56
STKZU
- VAT CHAR 1 - - Liable for VAT
57
TELBX
- Telebox CHAR 15 - - Telebox number
58
TELF2
- Telephone2 CHAR 16 - - Second telephone number
59
TELTX
- Teletex CHAR 30 - - Teletex number
60
TELX1
- Telex CHAR 30 - - Telex number
61
LZONE
- Zone CHAR 10 - - Transportation zone to or from which the goods are delivered
62
XZEMP
- Payer/doc. CHAR 1 - - Indicator: Is an alternative payer allowed in document?
63
VBUND
- Tradg Part CHAR 6 - - Company ID of trading partner
64
STCEG
- VAT Reg.No CHAR 20 - - VAT Registration Number
65
DEAR1
- Competitor CHAR 1 - - Indicator: Competitor
66
DEAR2
- SlsPartner CHAR 1 - - Indicator: Sales partner
67
DEAR3
- Prospect CHAR 1 - - Indicator: Sales prospect
68
DEAR4
- CustType 4 CHAR 1 - - Indicator for customer type 4
69
DEAR5
- Dflt SP CHAR 1 - - ID for default sold-to party
70
GFORM
- LegalStat. CHAR 2 - - Legal status
71
BRAN1
- Ind.Code 1 CHAR 10 - - Industry Code 1
72
BRAN2
- Ind.code 2 CHAR 10 - - Industry code 2
73
BRAN3
- Ind.code 3 CHAR 10 - - Industry code 3
74
BRAN4
- Ind.code 4 CHAR 10 - - Industry code 4
75
BRAN5
- Ind.code 5 CHAR 10 - - Industry code 5
76
EKONT
- InitContct CHAR 10 - - Initial contact
77
UMSAT
- Ann.sales CURR 8 2 - Annual sales
78
UMJAH
- Year NUMC 4 - - Year For Which Sales are Given
79
UWAER
- Currency CUKY 5 - - Currency of sales figure
80
JMZAH
- Employees NUMC 6 - - Yearly number of employees
81
JMJAH
- Year NUMC 4 - - Year for which the number of employees is given
82
KATR1
- Attribute CHAR 2 - - Attribute 1
83
KATR2
- Attrib. 2 CHAR 2 - - Attribute 2
84
KATR3
- Attrib. 3 CHAR 2 - - Attribute 3
85
KATR4
- Attrib. 4 CHAR 2 - - Attribute 4
86
KATR5
- Attrib. 5 CHAR 2 - - Attribute 5
87
KATR6
- Attrib. 6 CHAR 3 - - Attribute 6
88
KATR7
- Attrib. 7 CHAR 3 - - Attribute 7
89
KATR8
- Attrib. 8 CHAR 3 - - Attribute 8
90
KATR9
- Attrib. 9 CHAR 3 - - Attribute 9
91
KATR10
- Attrib.10 CHAR 3 - - Attribute 10
92
STKZN
- Nat.Person CHAR 1 - - Natural Person
93
UMSA1
- Ann.sales CURR 15 2 - Annual sales
94
TXJCD
- Tax Jur. CHAR 15 - - Tax Jurisdiction
95
PERIV
- FY Variant CHAR 2 - - Fiscal Year Variant
96
ABRVW
- Usage CHAR 3 - - Usage Indicator
97
INSPBYDEBI
- ByCustomer CHAR 1 - - Inspection Carried Out By Customer (No Inspection Lot)
98
INSPATDEBI
- AfterDeliv CHAR 1 - - Inspection for a Delivery Note After Outbound Delivery
99
KTOCD
- Ref.ActGr. CHAR 4 - - Reference Account Group for One-Time Account (Customer)
100
PFORT
- P.O.Bx cty CHAR 35 - - PO Box city
101
WERKS
- Plant CHAR 4 - T001W Plant
102
DTAMS
- DME Ind. CHAR 1 - - Indicator for Data Medium Exchange
103
DTAWS
- Instr.key CHAR 2 - - Instruction key for data medium exchange
104
DUEFL
- Status CHAR 1 - - Status of Data Transfer into Subsequent Release
105
HZUOR
- HierAssign NUMC 2 - - Assignment to Hierarchy
106
SPERZ
- Pmnt block CHAR 1 - - Payment Block
107
ETIKG
- LabCustGrp CHAR 10 - - IS-R Labeling: customer/plant group
108
CIVVE
- Non-milit. CHAR 1 - - ID for mainly non-military use
109
MILVE
- Milit. use CHAR 1 - - ID for mainly military use
110
KDKG1
- CondGrp 1 CHAR 2 - - Customer condition group 1
111
KDKG2
- CondGrp 2 CHAR 2 - - Customer condition group 2
112
KDKG3
- CondGrp 3 CHAR 2 - - Customer condition group 3
113
KDKG4
- CondGrp 4 CHAR 2 - - Customer condition group 4
114
KDKG5
- CondGrp 5 CHAR 2 - - Customer condition group 5
115
XKNZA
- AltPayerAc CHAR 1 - - Indicator: Alternative payer using account number
116
FITYP
- Tax type CHAR 2 - - Tax type
117
STCDT
- Tax no.ty. CHAR 2 - - Tax Number Type
118
STCD3
- Tax No. 3 CHAR 18 - - Tax Number 3
119
STCD4
- Tax No. 4 CHAR 18 - - Tax Number 4
120
XICMS
- No ICMS CHAR 1 - - Customer is ICMS-exempt
121
XXIPI
- No IPI CHAR 1 - - Customer is IPI-exempt
122
XSUBT
- SubT grp. CHAR 3 - - Customer group for Substituiçao Tributária calculation
123
CFOPC
- CFOP cat. CHAR 2 - - Customer's CFOP category
124
TXLW1
- ICMS text CHAR 3 - - Tax law: ICMS
125
TXLW2
- IPI text CHAR 3 - - Tax law: IPI
126
CCC01
- BCW CHAR 1 - - Indicator for biochemical warfare for legal control
127
CCC02
- Nucl.nonp. CHAR 1 - - Indicator for nuclear nonproliferation for legal control
128
CCC03
- Natl sec. CHAR 1 - - Indicator for national security for legal control
129
CCC04
- Miss.tech. CHAR 1 - - Indicator for missile technology for legal control
130
CASSD
- Central CHAR 2 - - Central sales block for customer
131
KNURL
- URL CHAR 132 - - Uniform Resource Locator
132
J_1KFREPRE
- Rep's Name CHAR 10 - - Name of Representative
133
J_1KFTBUS
- TOB CHAR 30 - - Type of Business
134
J_1KFTIND
- TOI CHAR 30 - - Type of Industry
135
CONFS
- Conf.St. CHAR 1 - - Status of Change Authorization (Central)
136
UPDAT
- Conf.date DATS 8 - - Date on Which the Changes Were Confirmed
137
UPTIM
- Conf.time TIMS 6 - - Time of Last Change Confirmation
138
NODEL
- Del.block CHAR 1 - - Central deletion block for master record
139
DEAR6
- Consumer CHAR 1 - - Indicator: Consumer
140
/VSO/R_PALHGT
- Max.StackH QUAN 13 3 - Maximum Stacking Height of the Packaging Material (VSO)
141
/VSO/R_PAL_UL
- LengthUnit UNIT 3 - - Unit of Length for Packaging Material (VSO)
142
/VSO/R_PK_MAT
- CustRelate CHAR 1 - - Customer-Related Packing for Each Packaging Material (VSO)
143
/VSO/R_MATPAL
- PKM Cust. CHAR 18 - - Packaging Material of the Customer in VSO
144
/VSO/R_I_NO_LYR
- No.IntPal NUMC 2 - - Number Layers Under an Inter-Pallet (VSO)
145
/VSO/R_ONE_MAT
- Mat.-Spec. CHAR 1 - - Packing Material-Specific for Each Packaging Material
146
/VSO/R_ONE_SORT
- Pack Pck CHAR 1 - - Pack Only One Package Type for Each PKM (VSO)
147
/VSO/R_ULD_SIDE
- Side Pref. NUMC 1 - - Side Preference of Loading/Unloading (VSO)
148
/VSO/R_LOAD_PREF
- F/B Pref. NUMC 1 - - Front/Back Preference of Loading/Unloading (VSO)
149
/VSO/R_DPOINT
- CollUnlPnt CHAR 10 - - Collective Unloading Point for VSO
150
ALC
- ALC CHAR 8 - - Agency Location Code
151
PMT_OFFICE
- Pmt Off CHAR 5 - - Payment Office
152
FEE_SCHEDULE
- Schedule CHAR 4 - - Fee schedule
153
DUNS
- DUNS No. CHAR 9 - - DUNS Number
154
DUNS4
- DUNS+4 CHAR 4 - - DUNS+4
155
PSOFG
- Process.gp CHAR 10 - - Processor group
156
PSOIS
- SLA PreprP CHAR 20 - - Subledger acct preprocessing procedure
157
PSON1
- Name CHAR 35 - - Name 1
158
PSON2
- Name 2 CHAR 35 - - Name 2
159
PSON3
- Name 3 CHAR 35 - - Name 3
160
PSOVN
- First Name CHAR 35 - - First Name
161
PSOTL
- Title CHAR 20 - - Title
162
PSOHS
- House no. CHAR 6 - - House number: is no longer used from Release 4.6B
163
PSOST
- Street CHAR 28 - - Street: No longer used from Release 4.6B
164
PSOO1
- Descr. CHAR 50 - - Description
165
PSOO2
- Descr. CHAR 50 - - Description
166
PSOO3
- Descr. CHAR 50 - - Description
167
PSOO4
- Descr. CHAR 50 - - Description
168
PSOO5
- Descr. CHAR 50 - - Description

Related References & SQL

Diagram ERD, T-Code standar, tabel terkait, dan contoh query untuk KNA1.

Interactive ERD Diagrams
SAP PM & SD - Plant Maintenance Main Tables Relation → SAP SD - Links to FI Tables →
Standard T-Codes
XD03 XD01 XD02 VD03 FD03 FBL5N
Related Tables
T005 LFA1 T002 T001W EQUI EQKT EQUZ EQST
ANSI SQL Query 
SELECT a.KUNNR,
       a.LAND1,
       a.NAME1,
       a.NAME2,
       a.ORT01,
       a.PSTLZ
FROM KNA1 AS a
WHERE a.KUNNR = '0000100025';
ABAP OpenSQL (7.40+) 
SELECT a~kunnr,
       a~land1,
       a~name1,
       a~name2,
       a~ort01,
       a~pstlz
  FROM kna1 AS a
  WHERE a~kunnr = '0000100025'
  INTO TABLE @DATA(lt_kna1)
  UP TO 100 ROWS.