SAP Table ESKN
Account Assignment in Service Package
ESKN (Account Assignment in Service Package) 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 ESKN to other SAP tables.
ESKN table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||
| PACKNO | Package number | PACKNO | ESLH | NUMC | 10 | 0 | ||||||
| ZEKKN | Sequential Number of Account Assignment | DZEKKN | NUMC | 2 | 0 | |||||||
| BEKKN | Number of PO Account Assignment | BEKKN | 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
|
||||||
| WPROZ | Percentage for Account Assignment Value Distribution | WPROZ | DEC | 4 | 1 | |||||||
| NETWR | Account Assignment Value | KNETWR | CURR | 11 | 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 | ||||||
| VBELN | Sales and Distribution Document Number | VBELN | VBUK | CHAR | 10 | 0 | ||||||
| VBELP | Sales Document Item | POSNR_VA | VBUP | NUMC | 6 | 0 | ||||||
| VETEN | Delivery Schedule Line Number | ETENR | NUMC | 4 | 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 | ||||||
| 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 | CKPH | CHAR | 12 | 0 | ||||||
| PAOBJNR | Profitability Segment Number (CO-PA) | RKEOBJNR | NUMC | 10 | 0 | |||||||
| PRCTR | Profit Center | PRCTR | CEPC | 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 | |||||||
| MWSKZ | Tax on sales/purchases code | MWSKZ | CHAR | 2 | 0 | |||||||
| TXJCD | Tax Jurisdiction | TXJCD | CHAR | 15 | 0 | |||||||
| NAVNW | Non-deductible input tax | NAVNW_SRV | CURR | 11 | 2 | |||||||
| KBLNR | Document Number for Earmarked Funds | KBLNR | CHAR | 10 | 0 | |||||||
| KBLPOS | Earmarked Funds: Document Item | KBLPOS | NUMC | 3 | 0 | |||||||
| DABRZ | Reference Date for Settlement | DABRBEZ | DATS | 8 | 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 | |||||||
| 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 | |||||||
| BUDGET_PD | FM: Budget Period | FM_BUDGET_PERIOD | CHAR | 10 | 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
|
||||||
ESKN foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| ESKN | ANLN1 | ESKN | ANLN1 | ANLH | Main asset number | ANLN1 |
| ESKN | ANLN1 | ESKN | MANDT | ANLH | Main asset number | MANDT |
| ESKN | ANLN1 | T001 | BUKRS | ANLH | Main asset number | BUKRS |
| ESKN | ANLN2 | ESKN | MANDT | ANLA | Asset Master Record Segment | MANDT |
| ESKN | ANLN2 | T001 | BUKRS | ANLA | Asset Master Record Segment | BUKRS |
| ESKN | ANLN2 | ESKN | ANLN1 | ANLA | Asset Master Record Segment | ANLN1 |
| ESKN | ANLN2 | ESKN | ANLN2 | ANLA | Asset Master Record Segment | ANLN2 |
| ESKN | AUFNR | ESKN | MANDT | AUFK | Order master data | MANDT |
| ESKN | AUFNR | ESKN | AUFNR | AUFK | Order master data | AUFNR |
| ESKN | FIPOS | ESKN | MANDT | FMFPO | FIFM: Commitment Item | MANDT |
| ESKN | FIPOS | T001 | FIKRS | FMFPO | FIFM: Commitment Item | FIKRS |
| ESKN | FIPOS | ESKN | FIPOS | FMFPO | FIFM: Commitment Item | FIPOS |
| ESKN | FIPOS | ESKN | AEDAT | FMFPO | FIFM: Commitment Item | DATBIS |
| ESKN | GSBER | ESKN | GSBER | TGSB | Business Areas | GSBER |
| ESKN | GSBER | ESKN | MANDT | TGSB | Business Areas | MANDT |
| ESKN | KOKRS | ESKN | MANDT | TKA01 | Controlling Areas | MANDT |
| ESKN | KOKRS | ESKN | KOKRS | TKA01 | Controlling Areas | KOKRS |
| ESKN | KOSTL | ESKN | MANDT | CSKS | Cost Center Master Data | MANDT |
| ESKN | KOSTL | ESKN | KOKRS | CSKS | Cost Center Master Data | KOKRS |
| ESKN | KOSTL | ESKN | KOSTL | CSKS | Cost Center Master Data | KOSTL |
| ESKN | KOSTL | ESKN | AEDAT | CSKS | Cost Center Master Data | DATBI |
| ESKN | KSTRG | ESKN | MANDT | CKPH | Master Record: Cost Object ID Number | MANDT |
| ESKN | KSTRG | ESKN | KSTRG | CKPH | Master Record: Cost Object ID Number | KSTRG |
| ESKN | KSTRG | ESKN | AEDAT | CKPH | Master Record: Cost Object ID Number | DATBI |
| ESKN | LSTAR | ESKN | KOKRS | CSLA | Activity master | KOKRS |
| ESKN | LSTAR | ESKN | LSTAR | CSLA | Activity master | LSTAR |
| ESKN | LSTAR | * | CSLA | Activity master | DATBI | |
| ESKN | LSTAR | ESKN | MANDT | CSLA | Activity master | MANDT |
| ESKN | MANDT | ESKN | MANDT | T000 | Clients | MANDT |
| ESKN | NPLNR | ESKN | MANDT | AUFK | Order master data | MANDT |
| ESKN | NPLNR | ESKN | NPLNR | AUFK | Order master data | AUFNR |
| ESKN | PACKNO | ESKN | MANDT | ESLH | Service Package Header Data | MANDT |
| ESKN | PACKNO | ESKN | PACKNO | ESLH | Service Package Header Data | PACKNO |
| ESKN | PRCTR | ESKN | PRCTR | CEPC | Profit Center Master Data Table | PRCTR |
| ESKN | PRCTR | ESKN | AEDAT | CEPC | Profit Center Master Data Table | DATBI |
| ESKN | PRCTR | ESKN | KOKRS | CEPC | Profit Center Master Data Table | KOKRS |
| ESKN | PRCTR | ESKN | MANDT | CEPC | Profit Center Master Data Table | MANDT |
| ESKN | PRZNR | ESKN | MANDT | CBPR | CO-ABC: Activity Master Table | MANDT |
| ESKN | PRZNR | ESKN | KOKRS | CBPR | CO-ABC: Activity Master Table | KOKRS |
| ESKN | PRZNR | ESKN | PRZNR | CBPR | CO-ABC: Activity Master Table | PRZNR |
| ESKN | PRZNR | * | CBPR | CO-ABC: Activity Master Table | DATBI | |
| ESKN | PS_PSP_PNR | ESKN | MANDT | PRPS | WBS (Work Breakdown Structure) Element Master Data | MANDT |
| ESKN | PS_PSP_PNR | ESKN | PS_PSP_PNR | PRPS | WBS (Work Breakdown Structure) Element Master Data | PSPNR |
| ESKN | SAKTO | ESKN | MANDT | SKA1 | G/L Account Master (Chart of Accounts) | MANDT |
| ESKN | SAKTO | T001 | KTOPL | SKA1 | G/L Account Master (Chart of Accounts) | KTOPL |
| ESKN | SAKTO | ESKN | SAKTO | SKA1 | G/L Account Master (Chart of Accounts) | SAKNR |
| ESKN | VBELN | ESKN | MANDT | VBUK | Sales Document: Header Status and Administrative Data | MANDT |
| ESKN | VBELN | ESKN | VBELN | VBUK | Sales Document: Header Status and Administrative Data | VBELN |
| ESKN | VBELP | ESKN | VBELN | VBUP | Sales Document: Item Status | VBELN |
| ESKN | VBELP | ESKN | VBELP | VBUP | Sales Document: Item Status | POSNR |
| ESKN | VBELP | ESKN | MANDT | VBUP | Sales Document: Item Status | MANDT |
| ESKN | VPTNR | ESKN | MANDT | KNA1 | General Data in Customer Master | MANDT |
| ESKN | VPTNR | ESKN | VPTNR | KNA1 | General Data in Customer Master | KUNNR |
| ESKN | ZZREGION | ESKN | ZZREGION | ZREG | User Defined Regions | ZZREGION |
| ESKN | ZZREGION | SYST | MANDT | ZREG | User Defined Regions | MANDT |
| ESKN | ZZSPREG | SYST | MANDT | ZZSPREG | Check table for ZZSPREG = Special Region | MANDT |
| ESKN | ZZSPREG | ESKN | ZZSPREG | ZZSPREG | Check table for ZZSPREG = Special Region | ZZSPREG |
| ESKN | ZZSTATE | SYST | MANDT | T005S | Taxes: Region (Province) Key | MANDT |
| ESKN | ZZSTATE | * | T005S | Taxes: Region (Province) Key | LAND1 | |
| ESKN | ZZSTATE | ESKN | ZZSTATE | T005S | Taxes: Region (Province) Key | BLAND |
| ESKN | ZZUSERFLD1 | SYST | MANDT | ZFU1 | Check Table for User Field 1 | MANDT |
| ESKN | ZZUSERFLD1 | ESKN | ZZUSERFLD1 | ZFU1 | Check Table for User Field 1 | ZZUSERFLD1 |
