EKKN is a standard Purchasing Transparent Table in SAP MM application, which stores Account Assignment in Purchasing Document 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 EKKN. You can use the transaction code SE16 to view the data in this table, and SE11 TCode for the table structure and definition.
EKKN — Meta Data
Description: | Account Assignment in Purchasing Document |
Main Category: | MM |
Sub Category: | Purchasing |
Table type: | Transparent Table (TRANSP) |
EKKN — 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 | EBELN | Purchasing Doc. | X | CHAR | 10 | EKKO |
3 | EBELP | ARIBA item number | X | NUMC | 5 | EKPO |
4 | ZEKKN | Sequential Number of Account Assignment | X | NUMC | 2 | |
5 | LOEKZ | Deletion flag for BOMs | CHAR | 1 | ||
6 | AEDAT | Changed on | DATS | 8 | ||
7 | KFLAG | Acct.asst.modifiable | CHAR | 1 | ||
8 | MENGE | Quantity in base unit of measure | QUAN | 13 | ||
9 | VPROZ | Distribution Percentage in Case of Multiple Account Assgt | DEC | 3 | ||
10 | NETWR | Net value | CURR | 13 | ||
11 | SAKTO | Cost element | CHAR | 10 | SKA1 | |
12 | GSBER | Business Area | CHAR | 4 | TGSB | |
13 | KOSTL | Cost Center | CHAR | 10 | CSKS | |
14 | PROJN | Old: Project number : No longer used --> PS_POSNR | CHAR | 16 | ||
15 | VBELN | Sales Document | CHAR | 10 | ||
16 | VBELP | Updated information in related user data field | NUMC | 6 | ||
17 | VETEN | Schedule line | NUMC | 4 | VBEP | |
18 | KZBRB | Gross requirements indicator | CHAR | 1 | ||
19 | ANLN1 | Asset | CHAR | 12 | ANLH | |
20 | ANLN2 | Asset Subnumber | CHAR | 4 | ANLA | |
21 | AUFNR | Order | CHAR | 12 | AUFK | |
22 | WEMPF | Goods recipient | CHAR | 12 | ||
23 | ABLAD | Unloading Point | CHAR | 25 | ||
24 | KOKRS | CO Area | CHAR | 4 | TKA01 | |
25 | XBKST | Posting to cost center? | CHAR | 1 | ||
26 | XBAUF | Post To Order | CHAR | 1 | ||
27 | XBPRO | Post to project | CHAR | 1 | ||
28 | EREKZ | Final Invoice | CHAR | 1 | ||
29 | KSTRG | Cost Object | CHAR | 12 | ||
30 | PAOBJNR | Profitability Segment Number (CO-PA) | NUMC | 10 | ||
31 | PRCTR | Profit Center | CHAR | 10 | ||
32 | PS_PSP_PNR | WBS Element | NUMC | 8 | PRPS | |
33 | NPLNR | Network Number for Account Assignment | CHAR | 12 | AUFK | |
34 | AUFPL | Routing number of operations in the order | NUMC | 10 | ||
35 | IMKEY | Real Estate Key | CHAR | 8 | ||
36 | APLZL | General counter for order | NUMC | 8 | ||
37 | VPTNR | Partner account number | CHAR | 10 | KNA1 | |
38 | FIPOS | Commitment Item | CHAR | 14 | FMFPO | |
39 | RECID | Recovery Indicator | CHAR | 2 | ||
40 | .INCLUDE | 0 | ||||
41 | .INCLUDE | 0 | ||||
42 | DUMMY_INCL_EEW_COBL | CHAR | 1 | |||
43 | FISTL | Funds Center | CHAR | 16 | ||
44 | GEBER | Fund | CHAR | 10 | ||
45 | FKBER | Functional Area | CHAR | 16 | ||
46 | DABRZ | Reference Date | DATS | 8 | ||
47 | AUFPL_ORD | Routing number of operations in the order | NUMC | 10 | ||
48 | APLZL_ORD | Updated information in related user data field | NUMC | 8 | ||
49 | MWSKZ | Tax code | CHAR | 2 | ||
50 | TXJCD | Jurisdiction for Tax Calculation - Tax Jurisdiction Code | CHAR | 15 | ||
51 | NAVNW | Char 15 | CURR | 13 | ||
52 | .INCLUDE | 0 | ||||
53 | KBLNR | Document number for earmarked funds | CHAR | 10 | * | |
54 | KBLPOS | Earmarked Funds: Document Item | NUMC | 3 | * | |
55 | LSTAR | Activity Type | CHAR | 6 | CSLA | |
56 | PRZNR | Business Process | CHAR | 12 | CBPR | |
57 | GRANT_NBR | Grant | CHAR | 20 | ||
58 | BUDGET_PD | Budget Period | CHAR | 10 | ||
59 | .INCLUDE | 0 | ||||
60 | FM_SPLIT_BATCH | Updated information in related user data field | NUMC | 3 | ||
61 | FM_SPLIT_BEGRU | Updated information in related user data field | CHAR | 4 | * | |
62 | .INCLUDE | 0 | ||||
63 | AA_FINAL_IND | Updated information in related user data field | CHAR | 1 | ||
64 | AA_FINAL_REASON | Updated information in related user data field | CHAR | 2 | T163RC | |
65 | AA_FINAL_QTY | Final Account Assignment Quantity | QUAN | 13 | ||
66 | AA_FINAL_QTY_F | Final Account Assignment Quantity (Floating Point Number) | FLTP | 16 | ||
67 | MENGE_F | Quantity (Floating Point Number - Internal Field) | FLTP | 16 | ||
68 | FMFGUS_KEY | United States Federal Government Fields | CHAR | 22 | ||
69 | _DATAAGING | Data Filter Value for Data Aging | DATS | 8 | ||
70 | .INCLU--AP | 0 | ||||
71 | EGRUP | Equity Group | CHAR | 3 | * | |
72 | VNAME | Joint venture | CHAR | 6 | * | |
73 | .INCLU--AP | 0 | ||||
74 | .INCLUDE | 0 | ||||
75 | KBLNR_CAB | Updated information in related user data field | CHAR | 10 | * | |
76 | KBLPOS_CAB | Earmarked Funds: Document Item | NUMC | 3 | * | |
77 | .INCLU--AP | 0 | ||||
78 | .INCLUDE | 0 | ||||
79 | TCOBJNR | Object number | CHAR | 22 | * | |
80 | DATEOFSERVICE | Date of Service | DATS | 8 | ||
81 | NOTAXCORR | Updated information in related user data field | CHAR | 1 | ||
82 | DIFFOPTRATE | Real Estate Option Rate | DEC | 9 | ||
83 | HASDIFFOPTRATE | Use Different Option Rate | CHAR | 1 |
SAP Help, Wiki Resources, and Forum Discussions on EKKN
Click the above link for the full list of resources and help pages, only the first few are posted below
-
Usage of tables EKKN,ESLL,ESLH,ESKL and FMIOI in Service PO's
We have a multi-line service PO. Each overview line has multiple service lines. Please provide a brief explanation of the role the following tables play in defining the PO structure and contents.
http://scn.sap.com/thread/450452
-
Purchase Orders (source data from EKKO-EKPO-EKKN) | SCN
Hi,
I need data from these tables, exist some infocubes or ODS in BC 3.5.2?
Thanks
http://scn.sap.com/message/567441
-
Relation between EKPO and EKKN | SCN
I want to retrieve the requestor name (EKKN-WEMPF) for all open orders in EKPO. But I dont find any matching data between these two tables.
http://scn.sap.com/message/1961166
-
EKKO and EKKN | SCN
Here in EKKO table the purchasing document header fields details will be available like Company code, Pur org, PO no, Pur grp, Inco terms.
http://scn.sap.com/message/6869676
-
EKKN Table Issue | SCN
-> On the List it's showing one value & when double clicking showing other value
http://scn.sap.com/message/6540594
-
EKKN TABLE | SCN
I am saving Pos.But Data is not saving in EKKN Table.plz tell me where saved pos Data.
http://scn.sap.com/message/7928981
-
Why AEDAT field is empty in EKKN Table. | SCN
Can please tell, why the AEDAT field is empty for some of the purchase documents in EKKN table.
http://scn.sap.com/message/6224214
-
EKKN is not updated while creating PO | SCN
EKKN table is not get updated with tax code details but successfully PO created
http://scn.sap.com/message/4449544
-
Using tables ekko,ekpo,EKKN problem with code plz check once
i am able to fetch data from ekko,ekpo and able to append it also but in the output fieldcat i not able to get data from EKKN i checked it with the normal process the data is coming but not transfering to the fieldcat please see to it
http://scn.sap.com/message/6752020
-
Runtime error accessing table EKKN in se16 | SCN
When i access the tx SE16 to access table EKKN, i am getting dump as soon as I execute
http://scn.sap.com/message/10966529
-
Read into EKKN in EXIT_SAPMM06E_022 (PO Create - Text fields).
I did a change to exit EXIT_SAPMM06E_022 (PO create). Now, what I need to do is for each line on the PO, I need to go get info from the original order. This info is stored in EKKN so I'm using this in my exit:
http://scn.sap.com/message/5944528
Related Tables
TABLE | Description | Functional Area |
---|---|---|
EKPO | Purchasing Document Item | MM - Purchasing |
EKBE | History per Purchasing Document | MM - Purchasing |
EKET | Scheduling Agreement Schedule Lines | MM - Purchasing |
MKPF | Header: Material Document | MM - Inventory Management |
EBAN | Purchase Requisition | MM - Purchasing |
MARA | General Material Data | Logistics - Material Master |
EBKN | Purchase Requisition Account Assignment | MM - Purchasing |
Transaction Codes for SAP Table EKKN
TCODE | Description | Functional Area |
---|---|---|
ME21N | Create Purchase Order | MM - Purchasing |
MIRO | Enter Incoming Invoice | MM - Invoice Verification |
SPRO | Customizing - Edit Project | Basis - Customizing Project Management (IMG) |
MIGO | Goods Movement | MM - Inventory Management |
MB1A | Goods Withdrawal | MM - Inventory Management |
ME41 | Create Request For Quotation | MM - Purchasing |
ME47 | Create Quotation | MM - Purchasing |
ME49 | Price Comparison List | MM - Purchasing |
FMs for SAP Table EKKN
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 |
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 |
REUSE_ALV_LIST_DISPLAY | Output a simple list (single line or several lines) | BC - SAP List Viewer |
BAPI_TRANSACTION_COMMIT | Execute external Commit when using BAPIs | Basis - ALE Integration Technology |
BAPI_PO_CREATE1 | Create Purchase Order | MM - Purchasing |
BAPI_PO_CHANGE | Change Purchase Order | MM - Purchasing |
ABAP Reports for SAP Table EKKN
ABAP REPORT | Description | Functional Area |
---|---|---|
SAPMM06E | Module Pool: PO History | MM - Purchasing |
RM06EAAW | Report: General Analyses | MM - Purchasing |
FM06PTOP | Purchasing Print Program: Data Declarations | MM - Purchasing |
SAPLMLSK | Function Group MLSK Account Assignment Specification: Service | |
RSAP0001 | Program for object type SAP0001 : BapiService | Basis - BW Service API |
SPRSL | TEXT | 630 - Workbench Tools: Editors |
RM06EN00 | Purchasing Documents per Document Number | MM - Purchasing |
RM06EK00 | Purchasing Documents per Account Assignment | MM - Purchasing |
BW Datasources for SAP Table EKKN
BW DATASOURCE | Description | Functional Area |
---|---|---|
2LIS_02_ITM | Purchasing Data (Item Level) | MM - Materials Management |
2LIS_02_SCL | Purchasing Data (Schedule Line Level) | MM - Materials Management |
2LIS_02_ACC | Purchasing Data (Account Level) | MM - Materials Management |
2LIS_02_HDR | Purchasing Data (Header Level) | MM - Materials Management |
2LIS_13_VDITM | Billing Document Item Data | SD - Sales and Distribution |
2LIS_02_SGR | Produced Activity: Delivery of Schedule Lines | MM - Materials Management |
2LIS_03_BF | Goods Movements From Inventory Management | MM - Materials Management |
2LIS_11_VAITM | Sales Document Item Data | SD - Sales and Distribution |
Authorization Objects for SAP Table EKKN
AUTHORIZATION OBJECT | Description | Functional Area |
---|---|---|
E_GRID | Authorization Object for Grid | |
C_SIGN | Authorization for Digital Signature | |
C_LINE | LD: Processing Lines | |
C_EKORG | Transfer of Purchasing Organization Data | |
CMS_CAG | Authorization object for CAG | |
J_1ITDS | Authorization object for TDS transaction J1IN | |
M_BEST_WRK | Plant in Purchase Order | |
M_EINK_FRG | Release Code and Group (Purchasing) |
Most searched SAP Materials Management Tables
- Purchase Order Tables
- Invoice Tables
- Purchase Requisition Tables
- Purchasing Organization Tables
- Purchasing Group Tables
- Purchase Info Record Tables
- Release Strategy Tables
- Scheduling Agreement Tables
- Document Flow Tables
- Movement Type Tables
- Purchase Order History Tables
- Service Master Tables
- Purchase Invoice Tables
- Goods Receipt Table Tables
- Miro Tables
- Goods Movement Tables
- Service Order Tables
- Po Item Tables
- Service Entry Sheet Tables
- Goods Receipt Tables
- Migo Tables
- Mb51 Tables