SAP Table EKKNU
Work Structure for Account Assignments in Purchasing Doc.-
EKKNU (Work Structure for Account Assignments in Purchasing Doc.-) 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 EKKNU to other SAP tables.
Source: EKKNU (Work Structure for Account Assignments in Purchasing Doc.-)
EKKNU table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 |
Possible values
|
||||||||||||
| AEDAT | Date on Which Record Was Created | ERDAT | DATS | 8 | 0 | |||||||||||||
| KFLAG | Change flag: Purchasing (currently not used) | EFLAG | CHAR | 1 | 0 |
Possible values
|
||||||||||||
| 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 |
Possible values
|
||||||||||||
| XBAUF | Post To Order | XBAUF | CHAR | 1 | 0 |
Possible values
|
||||||||||||
| XBPRO | Post to project | XBPRO | CHAR | 1 | 0 |
Possible values
|
||||||||||||
| EREKZ | Final Invoice Indicator | EREKZ | CHAR | 1 | 0 |
Possible values
|
||||||||||||
| 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 |
Possible values
|
||||||||||||
| 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 |
Possible values
|
||||||||||||
| DIFFOPTRATE | Real estate option rate | POPTSATZ | DEC | 9 | 6 | |||||||||||||
| HASDIFFOPTRATE | Use Different Option Rate | VVREITUSEDIFFOPTRATE | CHAR | 1 | 0 |
Possible values
|
||||||||||||
| UPDKZ | Change Type (U, I, S, D) | CDCHNGIND | CHAR | 1 | 0 |
Possible values
|
||||||||||||
| ITEM_WITH_ERROR | Checkbox | XFELD | CHAR | 1 | 0 |
Possible values
|
||||||||||||
| ID | Natural Number | INT4 | INT4 | 10 | 0 | |||||||||||||
| SWENR | Site Number | SWENR | CHAR | 8 | 0 | |||||||||||||
| SGENR | Building Number | SGENR | CHAR | 8 | 0 | |||||||||||||
| SGRNR | Property Number for BE | SGRNR | CHAR | 8 | 0 | |||||||||||||
| SMENR | Number of Rental Unit | SMENR | CHAR | 8 | 0 | |||||||||||||
| SMIVE | Lease-Out Number | SMIVE | CHAR | 13 | 0 | |||||||||||||
| SNKSL | Service Charge Key | SNKSL | CHAR | 4 | 0 | |||||||||||||
| SEMPSL | Settlement Unit | SEMPSL | CHAR | 5 | 0 | |||||||||||||
| SVWNR | Management Contract Number | VVSVWNR | CHAR | 13 | 0 | |||||||||||||
| RECNNR | Real Estate Contract Number | RECNNR | CHAR | 13 | 0 | |||||||||||||
| SBERI | Correction item number | SBERI | CHAR | 10 | 0 | |||||||||||||
| TCNO | RE-FX: Number of Correction Object | VVREITTCNO | CHAR | 16 | 0 | |||||||||||||
| VORNR | Operation/Activity Number | VORNR | CHAR | 4 | 0 | |||||||||||||
| PSP_PNR | Work breakdown structure element (WBS element) | PSP_PNR | CHAR | 24 | 0 | |||||||||||||
| SHARE_F | Quantity Share Account Assignment Line for Item | SHARE_F | FLTP | 16 | 16 | |||||||||||||
| MEASURE | Funded Program | FM_MEASURE | CHAR | 24 | 0 | |||||||||||||
EKKNU foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| EKKNU | AA_FINAL_REASON | SYST | MANDT | T163RC | Reason for Final Account Assignment Indicator | MANDT |
| EKKNU | AA_FINAL_REASON | EKKNU | AA_FINAL_REASON | T163RC | Reason for Final Account Assignment Indicator | AA_FINAL_REASON |
| EKKNU | ANLN1 | EKKNU | MANDT | ANLH | Main asset number | MANDT |
| EKKNU | ANLN1 | T001 | BUKRS | ANLH | Main asset number | BUKRS |
| EKKNU | ANLN1 | EKKNU | ANLN1 | ANLH | Main asset number | ANLN1 |
| EKKNU | ANLN2 | T001 | BUKRS | ANLA | Asset Master Record Segment | BUKRS |
| EKKNU | ANLN2 | EKKNU | MANDT | ANLA | Asset Master Record Segment | MANDT |
| EKKNU | ANLN2 | EKKNU | ANLN1 | ANLA | Asset Master Record Segment | ANLN1 |
| EKKNU | ANLN2 | EKKNU | ANLN2 | ANLA | Asset Master Record Segment | ANLN2 |
| EKKNU | AUFNR | EKKNU | MANDT | AUFK | Order master data | MANDT |
| EKKNU | AUFNR | EKKNU | AUFNR | AUFK | Order master data | AUFNR |
| EKKNU | EBELN | EKKNU | EBELN | EKKO | Purchasing Document Header | EBELN |
| EKKNU | EBELN | EKKNU | MANDT | EKKO | Purchasing Document Header | MANDT |
| EKKNU | EBELP | EKKNU | EBELP | EKPO | Purchasing Document Item | EBELP |
| EKKNU | EBELP | EKKNU | EBELN | EKPO | Purchasing Document Item | EBELN |
| EKKNU | EBELP | EKKNU | MANDT | EKPO | Purchasing Document Item | MANDT |
| EKKNU | FIPOS | T001 | FIKRS | FMFPO | FIFM: Commitment Item | FIKRS |
| EKKNU | FIPOS | EKKNU | MANDT | FMFPO | FIFM: Commitment Item | MANDT |
| EKKNU | FIPOS | EKKNU | AEDAT | FMFPO | FIFM: Commitment Item | DATBIS |
| EKKNU | FIPOS | EKKNU | FIPOS | FMFPO | FIFM: Commitment Item | FIPOS |
| EKKNU | GSBER | EKKNU | MANDT | TGSB | Business Areas | MANDT |
| EKKNU | GSBER | EKKNU | GSBER | TGSB | Business Areas | GSBER |
| EKKNU | KOKRS | EKKNU | KOKRS | TKA01 | Controlling Areas | KOKRS |
| EKKNU | KOKRS | EKKNU | MANDT | TKA01 | Controlling Areas | MANDT |
| EKKNU | KOSTL | EKKNU | KOSTL | CSKS | Cost Center Master Data | KOSTL |
| EKKNU | KOSTL | EKKNU | KOKRS | CSKS | Cost Center Master Data | KOKRS |
| EKKNU | KOSTL | EKKNU | AEDAT | CSKS | Cost Center Master Data | DATBI |
| EKKNU | KOSTL | EKKNU | MANDT | CSKS | Cost Center Master Data | MANDT |
| EKKNU | LSTAR | * | CSLA | Activity master | DATBI | |
| EKKNU | LSTAR | EKKNU | LSTAR | CSLA | Activity master | LSTAR |
| EKKNU | LSTAR | EKKNU | KOKRS | CSLA | Activity master | KOKRS |
| EKKNU | LSTAR | EKKNU | MANDT | CSLA | Activity master | MANDT |
| EKKNU | MANDT | EKKNU | MANDT | T000 | Clients | MANDT |
| EKKNU | NPLNR | EKKNU | MANDT | AUFK | Order master data | MANDT |
| EKKNU | NPLNR | EKKNU | NPLNR | AUFK | Order master data | AUFNR |
| EKKNU | PRZNR | * | CBPR | CO-ABC: Activity Master Table | DATBI | |
| EKKNU | PRZNR | EKKNU | MANDT | CBPR | CO-ABC: Activity Master Table | MANDT |
| EKKNU | PRZNR | EKKNU | KOKRS | CBPR | CO-ABC: Activity Master Table | KOKRS |
| EKKNU | PRZNR | EKKNU | PRZNR | CBPR | CO-ABC: Activity Master Table | PRZNR |
| EKKNU | PS_PSP_PNR | EKKNU | MANDT | PRPS | WBS (Work Breakdown Structure) Element Master Data | MANDT |
| EKKNU | PS_PSP_PNR | EKKNU | PS_PSP_PNR | PRPS | WBS (Work Breakdown Structure) Element Master Data | PSPNR |
| EKKNU | SAKTO | EKKNU | MANDT | SKA1 | G/L Account Master (Chart of Accounts) | MANDT |
| EKKNU | SAKTO | T001 | KTOPL | SKA1 | G/L Account Master (Chart of Accounts) | KTOPL |
| EKKNU | SAKTO | EKKNU | SAKTO | SKA1 | G/L Account Master (Chart of Accounts) | SAKNR |
| EKKNU | VBELN | EKKNU | VBELN | VBUK | Sales Document: Header Status and Administrative Data | VBELN |
| EKKNU | VBELN | EKKNU | MANDT | VBUK | Sales Document: Header Status and Administrative Data | MANDT |
| EKKNU | VBELP | EKKNU | VBELN | VBUP | Sales Document: Item Status | VBELN |
| EKKNU | VBELP | EKKNU | VBELP | VBUP | Sales Document: Item Status | POSNR |
| EKKNU | VBELP | EKKNU | MANDT | VBUP | Sales Document: Item Status | MANDT |
| EKKNU | VETEN | EKKNU | VETEN | VBEP | Sales Document: Schedule Line Data | ETENR |
| EKKNU | VETEN | EKKNU | VBELP | VBEP | Sales Document: Schedule Line Data | POSNR |
| EKKNU | VETEN | EKKNU | MANDT | VBEP | Sales Document: Schedule Line Data | MANDT |
| EKKNU | VETEN | EKKNU | VBELN | VBEP | Sales Document: Schedule Line Data | VBELN |
| EKKNU | VPTNR | EKKNU | MANDT | KNA1 | General Data in Customer Master | MANDT |
| EKKNU | VPTNR | EKKNU | VPTNR | KNA1 | General Data in Customer Master | KUNNR |
| EKKNU | ZZREGION | SYST | MANDT | ZREG | User Defined Regions | MANDT |
| EKKNU | ZZREGION | EKKNU | ZZREGION | ZREG | User Defined Regions | ZZREGION |
| EKKNU | ZZSPREG | SYST | MANDT | ZZSPREG | Check table for ZZSPREG = Special Region | MANDT |
| EKKNU | ZZSPREG | EKKNU | ZZSPREG | ZZSPREG | Check table for ZZSPREG = Special Region | ZZSPREG |
| EKKNU | ZZSTATE | EKKNU | ZZSTATE | T005S | Taxes: Region (Province) Key | BLAND |
| EKKNU | ZZSTATE | * | T005S | Taxes: Region (Province) Key | LAND1 | |
| EKKNU | ZZSTATE | SYST | MANDT | T005S | Taxes: Region (Province) Key | MANDT |
| EKKNU | ZZUSERFLD1 | SYST | MANDT | ZFU1 | Check Table for User Field 1 | MANDT |
| EKKNU | ZZUSERFLD1 | EKKNU | ZZUSERFLD1 | ZFU1 | Check Table for User Field 1 | ZZUSERFLD1 |
