SAP table ESKN (Account Assignment in Service Package)
SAP table ESKN has 3 primary key fields being MANDT,PACKNO,ZEKKN.
If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |
|---|---|---|---|---|---|---|---|
| MANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |
| PACKNO | Package number | NUMC | 10 | 0 | ESLH | PACKNO | |
| ZEKKN | Sequential Number of Account Assignment | NUMC | 2 | 0 | DZEKKN | ||
| BEKKN | Number of PO Account Assignment | NUMC | 2 | 0 | BEKKN | ||
| LOEKZ | Deletion Indicator: Purchasing Document Account Assignment | CHAR | 1 | 0 | KLOEK | ||
| AEDAT | Date on which the record was created | DATS | 8 | 0 | ERDAT | ||
| KFLAG | Change flag: Purchasing (currently not used) | CHAR | 1 | 0 | EFLAG | ||
| WPROZ | Percentage for Account Assignment Value Distribution | DEC | 4 | 1 | WPROZ | ||
| NETWR | Account Assignment Value | CURR | 11 | 2 | KNETWR | ||
| SAKTO | G/L Account Number | CHAR | 10 | 0 | SKA1 | SAKNR | |
| GSBER | Business Area | CHAR | 4 | 0 | TGSB | GSBER | |
| KOSTL | Cost Center | CHAR | 10 | 0 | CSKS | KOSTL | |
| VBELN | Sales and Distribution Document Number | CHAR | 10 | 0 | VBELN | ||
| VBELP | Sales Document Item | NUMC | 6 | 0 | POSNR_VA | ||
| VETEN | Schedule Line Number | NUMC | 4 | 0 | ETENR | ||
| ANLN1 | Main Asset Number | CHAR | 12 | 0 | ANLH | ANLN1 | |
| ANLN2 | Asset Subnumber | CHAR | 4 | 0 | ANLA | ANLN2 | |
| AUFNR | Order Number | CHAR | 12 | 0 | AUFK | AUFNR | |
| KOKRS | Controlling Area | CHAR | 4 | 0 | TKA01 | KOKRS | |
| XBKST | Posting to cost center? | CHAR | 1 | 0 | XBKST | ||
| XBAUF | Post To Order | CHAR | 1 | 0 | XBAUF | ||
| XBPRO | Post to project | CHAR | 1 | 0 | XBPRO | ||
| EREKZ | Final Invoice Indicator | CHAR | 1 | 0 | EREKZ | ||
| KSTRG | Cost Object | CHAR | 12 | 0 | CKPH | KSTRG | |
| PAOBJNR | Profitability Segment Number (CO-PA) | NUMC | 10 | 0 | RKEOBJNR | ||
| PRCTR | Profit Center | CHAR | 10 | 0 | CEPC | PRCTR | |
| PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | NUMC | 8 | 0 | PRPS | PS_PSP_PNR | |
| NPLNR | Network Number for Account Assignment | CHAR | 12 | 0 | AUFK | NPLNR | |
| AUFPL | Routing number of operations in the order | NUMC | 10 | 0 | CO_AUFPL | ||
| IMKEY | Internal Key for Real Estate Object | CHAR | 8 | 0 | IMKEY | ||
| APLZL | Internal counter | NUMC | 8 | 0 | CIM_COUNT | ||
| VPTNR | Partner account number | CHAR | 10 | 0 | KNA1 | JV_PART | |
| FIPOS | Commitment Item | CHAR | 14 | 0 | FMFPO | FIPOS | |
| RECID | Recovery Indicator | CHAR | 2 | 0 | JV_RECIND | ||
| DUMMY_INCL_EEW_COBL | Custom Fields: Dummy for Use in Extension Includes | CHAR | 1 | 0 | CFD_DUMMY | ||
| FISTL | Funds Center | CHAR | 16 | 0 | FISTL | ||
| GEBER | Fund | CHAR | 10 | 0 | BP_GEBER | ||
| FKBER | Functional Area | CHAR | 16 | 0 | FKBER | ||
| MWSKZ | Tax on sales/purchases code | CHAR | 2 | 0 | MWSKZ | ||
| TXJCD | Tax Jurisdiction | CHAR | 15 | 0 | TXJCD | ||
| NAVNW | Non-deductible input tax | CURR | 11 | 2 | NAVNW_SRV | ||
| KBLNR | Document Number for Earmarked Funds | CHAR | 10 | 0 | * | KBLNR | |
| KBLPOS | Earmarked Funds: Document Item | NUMC | 3 | 0 | * | KBLPOS | |
| DABRZ | Reference date for settlement | DATS | 8 | 0 | DABRBEZ | ||
| LSTAR | Activity Type | CHAR | 6 | 0 | CSLA | LSTAR | |
| PRZNR | Business Process | CHAR | 12 | 0 | CBPR | CO_PRZNR | |
| GRANT_NBR | Grant | CHAR | 20 | 0 | GM_GRANT_NBR | ||
| FM_SPLIT_BATCH | Batch to group results from an PSM assignment distribution | NUMC | 3 | 0 | FMSP_SPLIT_BATCH | ||
| FM_SPLIT_BEGRU | Authorization group for PSM account assignment distribution | CHAR | 4 | 0 | * | FMSP_SPLIT_AUTG | |
| BUDGET_PD | Budget Period | CHAR | 10 | 0 | FM_BUDGET_PERIOD | ||
| FMFGUS_KEY | United States Federal Government Fields | CHAR | 22 | 0 | FMFG_US_KEY | ||
| _DATAAGING | Data Filter Value for Data Aging | DATS | 8 | 0 | DATA_TEMPERATURE | ||
| TCOBJNR | Object number | CHAR | 22 | 0 | * | J_OBJNR | |
| DATEOFSERVICE | Date of Service | DATS | 8 | 0 | VVBEACTDATE | ||
| NOTAXCORR | Do Not Consider Item in Input Tax Correction | CHAR | 1 | 0 | VVREITNOTAXCORR | ||
| DIFFOPTRATE | Real Estate Option Rate | DEC | 9 | 6 | POPTSATZ | ||
| HASDIFFOPTRATE | Use Different Option Rate | CHAR | 1 | 0 | VVREITUSEDIFFOPTRATE |
ESKN foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 ESKN | ANLN1 | ANLH | Main asset number | BUKRS |
| 0 ESKN | ANLN1 | ANLH | Main asset number | ANLN1 |
| 1 ESKN | ANLN2 | ANLA | Asset Master Record Segment | BUKRS |
| 1 ESKN | ANLN2 | ANLA | Asset Master Record Segment | ANLN1 |
| 1 ESKN | ANLN2 | ANLA | Asset Master Record Segment | ANLN2 |
| 0 ESKN | AUFNR | AUFK | Order master data | AUFNR |
| 1 ESKN | FIPOS | FMFPO | FIFM: Commitment Item | MANDT |
| 1 ESKN | FIPOS | FMFPO | FIFM: Commitment Item | FIKRS |
| 1 ESKN | FIPOS | FMFPO | FIFM: Commitment Item | DATBIS |
| 0 ESKN | GSBER | TGSB | Business Areas | MANDT |
| 0 ESKN | GSBER | TGSB | Business Areas | GSBER |
| 1 ESKN | KOKRS | TKA01 | Controlling Areas | MANDT |
| 0 ESKN | KOSTL | CSKS | Cost Center Master Record | MANDT |
| 0 ESKN | KOSTL | CSKS | Cost Center Master Record | KOKRS |
| 0 ESKN | KOSTL | CSKS | Cost Center Master Record | KOSTL |
| 0 ESKN | KOSTL | CSKS | Cost Center Master Record | DATBI |
| 1 ESKN | KSTRG | CKPH | Master Record: Cost Object ID Number | MANDT |
| 1 ESKN | KSTRG | CKPH | Master Record: Cost Object ID Number | KSTRG |
| 1 ESKN | KSTRG | CKPH | Master Record: Cost Object ID Number | DATBI |
| 0 ESKN | LSTAR | CSLA | Activity master | MANDT |
| 0 ESKN | LSTAR | CSLA | Activity master | KOKRS |
| 0 ESKN | LSTAR | CSLA | Activity master | DATBI |
| 1 ESKN | MANDT | T000 | Clients | MANDT |
| 0 ESKN | NPLNR | AUFK | Order master data | AUFNR |
| 1 ESKN | PACKNO | ESLH | Service Package Header Data | PACKNO |
| 0 ESKN | PRCTR | CEPC | Profit Center Master Data Table | PRCTR |
| 0 ESKN | PRCTR | CEPC | Profit Center Master Data Table | DATBI |
| 0 ESKN | PRCTR | CEPC | Profit Center Master Data Table | KOKRS |
| 1 ESKN | PRZNR | CBPR | CO-ABC: Activity Master Table | KOKRS |
| 1 ESKN | PRZNR | CBPR | CO-ABC: Activity Master Table | PRZNR |
| 1 ESKN | PRZNR | CBPR | CO-ABC: Activity Master Table | DATBI |
| 0 ESKN | PS_PSP_PNR | PRPS | WBS (Work Breakdown Structure) Element Master Data | MANDT |
| 0 ESKN | PS_PSP_PNR | PRPS | WBS (Work Breakdown Structure) Element Master Data | PSPNR |
| 1 ESKN | SAKTO | SKA1 | G/L Account Master (Chart of Accounts) | MANDT |
| 1 ESKN | SAKTO | SKA1 | G/L Account Master (Chart of Accounts) | KTOPL |
| 1 ESKN | SAKTO | SKA1 | G/L Account Master (Chart of Accounts) | SAKNR |
| 0 ESKN | VPTNR | KNA1 | General Data in Customer Master | MANDT |
| 0 ESKN | VPTNR | KNA1 | General Data in Customer Master | KUNNR |