SAP Table EKKN
Account Assignment in Purchasing Document
EKKN (Account Assignment in Purchasing Document) 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 EKKN to other SAP tables.
EKKN table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
MANDT
Client
|
MANDT | T000 |
CLNT
|
3 | 0 | |||||||
|
EBELN
Purchasing Document Number
|
EBELN | EKKO |
CHAR
|
10 | 0 | |||||||
|
EBELP
Item Number of Purchasing Document
|
EBELP | EKPO |
NUMC
|
5 | 0 | |||||||
|
ZEKKN
Sequential Number of Account Assignment
|
DZEKKN |
NUMC
|
2 | 0 | ||||||||
|
LOEKZ
Deletion Indicator: Purchasing Document Account Assignment
|
KLOEK |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
AEDAT
Date on Which Record Was Created
|
ERDAT |
DATS
|
8 | 0 | ||||||||
|
KFLAG
Change flag: Purchasing (currently not used)
|
EFLAG |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
MENGE
Quantity
|
MENGE_D |
QUAN
|
13 | 3 | ||||||||
|
VPROZ
Distribution Percentage in Case of Multiple Account Assgt
|
VPROZ |
DEC
|
3 | 1 | ||||||||
|
NETWR
Net Order Value in PO Currency
|
BWERT |
CURR
|
13 | 2 | ||||||||
|
SAKTO
G/L Account Number
|
SAKNR | SKA1 |
CHAR
|
10 | 0 | |||||||
|
GSBER
Business Area
|
GSBER | TGSB |
CHAR
|
4 | 0 | |||||||
|
KOSTL
Cost Center
|
KOSTL | CSKS |
CHAR
|
10 | 0 | |||||||
|
PROJN
Old: Project number : No longer used --> PS_POSNR
|
PROJN |
CHAR
|
16 | 0 | ||||||||
|
VBELN
Sales and Distribution Document Number
|
VBELN_CO | VBUK |
CHAR
|
10 | 0 | |||||||
|
VBELP
Sales Document Item
|
POSNR_CO | VBUP |
NUMC
|
6 | 0 | |||||||
|
VETEN
Delivery Schedule Line Number
|
ETENR | VBEP |
NUMC
|
4 | 0 | |||||||
|
KZBRB
Gross requirements indicator
|
KZBRB |
CHAR
|
1 | 0 | ||||||||
|
ANLN1
Main Asset Number
|
ANLN1 | ANLH |
CHAR
|
12 | 0 | |||||||
|
ANLN2
Asset Subnumber
|
ANLN2 | ANLA |
CHAR
|
4 | 0 | |||||||
|
AUFNR
Order Number
|
AUFNR | AUFK |
CHAR
|
12 | 0 | |||||||
|
WEMPF
Goods Recipient/Ship-To Party
|
WEMPF |
CHAR
|
12 | 0 | ||||||||
|
ABLAD
Unloading Point
|
ABLAD |
CHAR
|
25 | 0 | ||||||||
|
KOKRS
Controlling Area
|
KOKRS | TKA01 |
CHAR
|
4 | 0 | |||||||
|
XBKST
Posting to cost center?
|
XBKST |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
XBAUF
Post To Order
|
XBAUF |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
XBPRO
Post to project
|
XBPRO |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
EREKZ
Final Invoice Indicator
|
EREKZ |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
KSTRG
Cost Object
|
KSTRG |
CHAR
|
12 | 0 | ||||||||
|
PAOBJNR
Profitability Segment Number (CO-PA)
|
RKEOBJNR |
NUMC
|
10 | 0 | ||||||||
|
PRCTR
Profit Center
|
PRCTR |
CHAR
|
10 | 0 | ||||||||
|
PS_PSP_PNR
Work Breakdown Structure Element (WBS Element)
|
PS_PSP_PNR | PRPS |
NUMC
|
8 | 0 | |||||||
|
NPLNR
Network Number for Account Assignment
|
NPLNR | AUFK |
CHAR
|
12 | 0 | |||||||
|
AUFPL
Routing number of operations in the order
|
CO_AUFPL |
NUMC
|
10 | 0 | ||||||||
|
IMKEY
Internal Key for Real Estate Object
|
IMKEY |
CHAR
|
8 | 0 | ||||||||
|
APLZL
Internal counter
|
CIM_COUNT |
NUMC
|
8 | 0 | ||||||||
|
VPTNR
Partner account number
|
JV_PART | KNA1 |
CHAR
|
10 | 0 | |||||||
|
FIPOS
Commitment Item
|
FIPOS | FMFPO |
CHAR
|
14 | 0 | |||||||
|
RECID
Recovery Indicator
|
JV_RECIND |
CHAR
|
2 | 0 | ||||||||
|
FISTL
Funds Center
|
FISTL |
CHAR
|
16 | 0 | ||||||||
|
GEBER
Fund
|
BP_GEBER |
CHAR
|
10 | 0 | ||||||||
|
FKBER
Functional Area
|
FKBER |
CHAR
|
16 | 0 | ||||||||
|
DABRZ
Reference Date for Settlement
|
DABRBEZ |
DATS
|
8 | 0 | ||||||||
|
AUFPL_ORD
Routing number of operations in the order
|
CO_AUFPL |
NUMC
|
10 | 0 | ||||||||
|
APLZL_ORD
General counter for order
|
CO_APLZL |
NUMC
|
8 | 0 | ||||||||
|
MWSKZ
Tax on sales/purchases code
|
MWSKZ |
CHAR
|
2 | 0 | ||||||||
|
TXJCD
Tax Jurisdiction
|
TXJCD |
CHAR
|
15 | 0 | ||||||||
|
NAVNW
Non-deductible input tax
|
NAVNW |
CURR
|
13 | 2 | ||||||||
|
KBLNR
Document Number for Earmarked Funds
|
KBLNR |
CHAR
|
10 | 0 | ||||||||
|
KBLPOS
Earmarked Funds: Document Item
|
KBLPOS |
NUMC
|
3 | 0 | ||||||||
|
LSTAR
Activity Type
|
LSTAR | CSLA |
CHAR
|
6 | 0 | |||||||
|
PRZNR
Business Process
|
CO_PRZNR | CBPR |
CHAR
|
12 | 0 | |||||||
|
GRANT_NBR
Grant
|
GM_GRANT_NBR |
CHAR
|
20 | 0 | ||||||||
|
BUDGET_PD
FM: Budget Period
|
FM_BUDGET_PERIOD |
CHAR
|
10 | 0 | ||||||||
|
FM_SPLIT_BATCH
Batch to group results from an PSM assignment distribution
|
FMSP_SPLIT_BATCH |
NUMC
|
3 | 0 | ||||||||
|
FM_SPLIT_BEGRU
Authorization group for PSM account assignment distribution
|
FMSP_SPLIT_AUTG |
CHAR
|
4 | 0 | ||||||||
|
AA_FINAL_IND
Final Account Assignment Indicator
|
AA_FINAL_IND |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
AA_FINAL_REASON
Final Account Assignment Reason Code
|
AA_FINAL_REASON | T163RC |
CHAR
|
2 | 0 | |||||||
|
AA_FINAL_QTY
Final Account Assignment Quantity
|
AA_FINAL_QTY |
QUAN
|
13 | 3 | ||||||||
|
AA_FINAL_QTY_F
Final Account Assignment Quantity (Floating Point Number)
|
AA_FINAL_QTY_F |
FLTP
|
16 | 16 | ||||||||
|
MENGE_F
Quantity (Floating Point Number - Internal Field)
|
MENGE_F |
FLTP
|
16 | 16 | ||||||||
|
EGRUP
Equity group
|
JV_EGROUP |
CHAR
|
3 | 0 | ||||||||
|
VNAME
Joint Venture
|
JV_NAME |
CHAR
|
6 | 0 | ||||||||
|
TCOBJNR
Object number
|
J_OBJNR |
CHAR
|
22 | 0 | ||||||||
|
DATEOFSERVICE
Date of Service
|
VVBEACTDATE |
DATS
|
8 | 0 | ||||||||
|
NOTAXCORR
Do Not Consider Item in Input Tax Correction
|
VVREITNOTAXCORR |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
DIFFOPTRATE
Real estate option rate
|
POPTSATZ |
DEC
|
9 | 6 | ||||||||
|
HASDIFFOPTRATE
Use Different Option Rate
|
VVREITUSEDIFFOPTRATE |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
EKKN foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| EKKN | AA_FINAL_REASON | SYST | MANDT |
T163RC
Reason for Final Account Assignment Indicator
|
MANDT |
| EKKN | AA_FINAL_REASON | EKKN | AA_FINAL_REASON |
T163RC
Reason for Final Account Assignment Indicator
|
AA_FINAL_REASON |
| EKKN | ANLN1 | EKKN | ANLN1 |
ANLH
Main asset number
|
ANLN1 |
| EKKN | ANLN1 | EKKN | MANDT |
ANLH
Main asset number
|
MANDT |
| EKKN | ANLN1 | T001 | BUKRS |
ANLH
Main asset number
|
BUKRS |
| EKKN | ANLN2 | EKKN | MANDT |
ANLA
Asset Master Record Segment
|
MANDT |
| EKKN | ANLN2 | T001 | BUKRS |
ANLA
Asset Master Record Segment
|
BUKRS |
| EKKN | ANLN2 | EKKN | ANLN1 |
ANLA
Asset Master Record Segment
|
ANLN1 |
| EKKN | ANLN2 | EKKN | ANLN2 |
ANLA
Asset Master Record Segment
|
ANLN2 |
| EKKN | AUFNR | EKKN | MANDT |
AUFK
Order master data
|
MANDT |
| EKKN | AUFNR | EKKN | AUFNR |
AUFK
Order master data
|
AUFNR |
| EKKN | EBELN | EKKN | MANDT |
EKKO
Purchasing Document Header
|
MANDT |
| EKKN | EBELN | EKKN | EBELN |
EKKO
Purchasing Document Header
|
EBELN |
| EKKN | EBELP | EKKN | EBELP |
EKPO
Purchasing Document Item
|
EBELP |
| EKKN | EBELP | EKKN | MANDT |
EKPO
Purchasing Document Item
|
MANDT |
| EKKN | EBELP | EKKN | EBELN |
EKPO
Purchasing Document Item
|
EBELN |
| EKKN | FIPOS | EKKN | MANDT |
FMFPO
FIFM: Commitment Item
|
MANDT |
| EKKN | FIPOS | T001 | FIKRS |
FMFPO
FIFM: Commitment Item
|
FIKRS |
| EKKN | FIPOS | EKKN | FIPOS |
FMFPO
FIFM: Commitment Item
|
FIPOS |
| EKKN | FIPOS | EKKN | AEDAT |
FMFPO
FIFM: Commitment Item
|
DATBIS |
| EKKN | GSBER | EKKN | MANDT |
TGSB
Business Areas
|
MANDT |
| EKKN | GSBER | EKKN | GSBER |
TGSB
Business Areas
|
GSBER |
| EKKN | KOKRS | EKKN | KOKRS |
TKA01
Controlling Areas
|
KOKRS |
| EKKN | KOKRS | EKKN | MANDT |
TKA01
Controlling Areas
|
MANDT |
| EKKN | KOSTL | EKKN | KOKRS |
CSKS
Cost Center Master Data
|
KOKRS |
| EKKN | KOSTL | EKKN | KOSTL |
CSKS
Cost Center Master Data
|
KOSTL |
| EKKN | KOSTL | EKKN | AEDAT |
CSKS
Cost Center Master Data
|
DATBI |
| EKKN | KOSTL | EKKN | MANDT |
CSKS
Cost Center Master Data
|
MANDT |
| EKKN | LSTAR | * |
CSLA
Activity master
|
DATBI | |
| EKKN | LSTAR | EKKN | MANDT |
CSLA
Activity master
|
MANDT |
| EKKN | LSTAR | EKKN | KOKRS |
CSLA
Activity master
|
KOKRS |
| EKKN | LSTAR | EKKN | LSTAR |
CSLA
Activity master
|
LSTAR |
| EKKN | MANDT | EKKN | MANDT |
T000
Clients
|
MANDT |
| EKKN | NPLNR | EKKN | MANDT |
AUFK
Order master data
|
MANDT |
| EKKN | NPLNR | EKKN | NPLNR |
AUFK
Order master data
|
AUFNR |
| EKKN | PRZNR | EKKN | MANDT |
CBPR
CO-ABC: Activity Master Table
|
MANDT |
| EKKN | PRZNR | EKKN | KOKRS |
CBPR
CO-ABC: Activity Master Table
|
KOKRS |
| EKKN | PRZNR | EKKN | PRZNR |
CBPR
CO-ABC: Activity Master Table
|
PRZNR |
| EKKN | PRZNR | * |
CBPR
CO-ABC: Activity Master Table
|
DATBI | |
| EKKN | PS_PSP_PNR | EKKN | MANDT |
PRPS
WBS (Work Breakdown Structure) Element Master Data
|
MANDT |
| EKKN | PS_PSP_PNR | EKKN | PS_PSP_PNR |
PRPS
WBS (Work Breakdown Structure) Element Master Data
|
PSPNR |
| EKKN | SAKTO | EKKN | SAKTO |
SKA1
G/L Account Master (Chart of Accounts)
|
SAKNR |
| EKKN | SAKTO | EKKN | MANDT |
SKA1
G/L Account Master (Chart of Accounts)
|
MANDT |
| EKKN | SAKTO | T001 | KTOPL |
SKA1
G/L Account Master (Chart of Accounts)
|
KTOPL |
| EKKN | VBELN | EKKN | VBELN |
VBUK
Sales Document: Header Status and Administrative Data
|
VBELN |
| EKKN | VBELN | EKKN | MANDT |
VBUK
Sales Document: Header Status and Administrative Data
|
MANDT |
| EKKN | VBELP | EKKN | MANDT |
VBUP
Sales Document: Item Status
|
MANDT |
| EKKN | VBELP | EKKN | VBELN |
VBUP
Sales Document: Item Status
|
VBELN |
| EKKN | VBELP | EKKN | VBELP |
VBUP
Sales Document: Item Status
|
POSNR |
| EKKN | VETEN | EKKN | MANDT |
VBEP
Sales Document: Schedule Line Data
|
MANDT |
| EKKN | VETEN | EKKN | VBELN |
VBEP
Sales Document: Schedule Line Data
|
VBELN |
| EKKN | VETEN | EKKN | VBELP |
VBEP
Sales Document: Schedule Line Data
|
POSNR |
| EKKN | VETEN | EKKN | VETEN |
VBEP
Sales Document: Schedule Line Data
|
ETENR |
| EKKN | VPTNR | EKKN | MANDT |
KNA1
General Data in Customer Master
|
MANDT |
| EKKN | VPTNR | EKKN | VPTNR |
KNA1
General Data in Customer Master
|
KUNNR |
| EKKN | ZZREGION | SYST | MANDT |
ZREG
User Defined Regions
|
MANDT |
| EKKN | ZZREGION | EKKN | ZZREGION |
ZREG
User Defined Regions
|
ZZREGION |
| EKKN | ZZSPREG | SYST | MANDT |
ZZSPREG
Check table for ZZSPREG = Special Region
|
MANDT |
| EKKN | ZZSPREG | EKKN | ZZSPREG |
ZZSPREG
Check table for ZZSPREG = Special Region
|
ZZSPREG |
| EKKN | ZZSTATE | SYST | MANDT |
T005S
Taxes: Region (Province) Key
|
MANDT |
| EKKN | ZZSTATE | * |
T005S
Taxes: Region (Province) Key
|
LAND1 | |
| EKKN | ZZSTATE | EKKN | ZZSTATE |
T005S
Taxes: Region (Province) Key
|
BLAND |
| EKKN | ZZUSERFLD1 | EKKN | ZZUSERFLD1 |
ZFU1
Check Table for User Field 1
|
ZZUSERFLD1 |
| EKKN | ZZUSERFLD1 | SYST | MANDT |
ZFU1
Check Table for User Field 1
|
MANDT |