SAP Table EPPOS
Program Position with Short Text
EPPOS (Program Position with Short Text) 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 EPPOS to other SAP tables.
EPPOS table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | CLNT | 3 | 0 | |||||||||
| POSNR | Position number | IM_POSNR | NUMC | 8 | 0 | |||||||||
| GJAHR | Approval year of the investment program | IM_GNJHR | NUMC | 4 | 0 | |||||||||
| POSID | Identification for an investment program position | IM_POSID | CHAR | 24 | 0 | |||||||||
| ABJHR | Valid From Fiscal Year | IM_ABJHR | NUMC | 4 | 0 | |||||||||
| BIJHR | Valid to fiscal year | IM_BIJHR | NUMC | 4 | 0 | |||||||||
| PRNAM | Investment program name | IM_PRNAM | IMTP | CHAR | 8 | 0 | ||||||||
| PPRIO | Priority of the appropriation request | IMA_PRIOR | TCN07 | CHAR | 1 | 0 | ||||||||
| IZWEK | Reason for investment | IZWEK | T087I | CHAR | 2 | 0 | ||||||||
| OBJNR | CO object number for inv. prog. position | IM_OBJNR | CHAR | 22 | 0 | |||||||||
| VERNR | Person responsible | IM_VERNR | TCJ04 | NUMC | 8 | 0 | ||||||||
| VERNA | Name of person responsible | IM_VERNA | CHAR | 25 | 0 | |||||||||
| ERNAM | Name of Person who Created the Object | ERNAM | CHAR | 12 | 0 | |||||||||
| ERDAT | Date on Which Record Was Created | ERDAT | DATS | 8 | 0 | |||||||||
| AENAM | Name of Person Who Changed Object | AENAM | CHAR | 12 | 0 | |||||||||
| AEDAT | Date on which object was last changed | UPDAT | DATS | 8 | 0 | |||||||||
| ERGSO | IM: Balance sheet item (credit) | IM_ERGSO | CHAR | 10 | 0 | |||||||||
| BUKRS | Company Code | BUKRS | T001 | CHAR | 4 | 0 | ||||||||
| GSBER | Business Area | GSBER | TGSB | CHAR | 4 | 0 | ||||||||
| KOKRS | Controlling Area | KOKRS | TKA01 | CHAR | 4 | 0 | ||||||||
| KOSTL | Cost Center | KOSTL | CHAR | 10 | 0 | |||||||||
| WERKS | Plant | WERKS_D | CHAR | 4 | 0 | |||||||||
| PRCTR | Profit Center | PRCTR | CHAR | 10 | 0 | |||||||||
| BEBER | Plant section | BEBER | CHAR | 3 | 0 | |||||||||
| TPLNR | Functional Location | TPLNR | IFLOT | CHAR | 30 | 0 | ||||||||
| XPLAN | - free - | IM_XPLAN | CHAR | 1 | 0 |
Possible values
|
||||||||
| XBUDG | - free - | IM_XBUDG | CHAR | 1 | 0 |
Possible values
|
||||||||
| PARNR | Parent position number | IM_PARNR | NUMC | 8 | 0 | |||||||||
| LEFNR | Position number left brother (in hierarchy) | IM_LEFNR | NUMC | 8 | 0 | |||||||||
| XAKTB | Budget distrib. of overall values only from prog.position | IM_XAKTB | CHAR | 1 | 0 |
Possible values
|
||||||||
| LOGSYV | Logical system of the sub-tree of the investment program | IM_LOGSYV | CHAR | 10 | 0 | |||||||||
| RCOMP | Company | RCOMP_D | T880 | CHAR | 6 | 0 | ||||||||
| SIZECL | Scale of investment objects | IM_SIZECL | TAIF5 | CHAR | 2 | 0 | ||||||||
| LAND1 | Country for Which Approp. Request Is Planned | IMA_LAND1 | T005 | CHAR | 3 | 0 | ||||||||
| OWAERS | Object Currency of the Investment Program Item | IM_OWAERS | TCURC | CUKY | 5 | 0 | ||||||||
| USR00 | User field 1 (20 characters) | IMA_USR00 | CHAR | 20 | 0 | |||||||||
| USR01 | User field 2 (20 characters) | IMA_USR01 | CHAR | 20 | 0 | |||||||||
| USR02 | User field 3 (10 characters) | IMA_USR02 | TAIF9 | CHAR | 10 | 0 | ||||||||
| USR03 | User field 4 (10 characters) | IMA_USR03 | TAIF9 | CHAR | 10 | 0 | ||||||||
| USR04 | User field 5 for quantity - IM | IMA_USR04 | QUAN | 13 | 3 | |||||||||
| USE04 | User field 5 for unit for quantity field 5 - IM | IMA_USE04 | T006 | UNIT | 3 | 0 | ||||||||
| USR05 | User field 6 for quantity - IM | IMA_USR05 | QUAN | 13 | 3 | |||||||||
| USE05 | User field 6 for unit of quantity field 6 -IM- | IMA_USE05 | T006 | UNIT | 3 | 0 | ||||||||
| USR06 | User field 7 for values - IM | IMA_USR06 | CURR | 13 | 3 | |||||||||
| USE06 | User field 7 for currency for user field 7 | IMA_USE06 | TCURC | CUKY | 5 | 0 | ||||||||
| USR07 | User field 8 for values - IM | IMA_USR07 | CURR | 13 | 3 | |||||||||
| USE07 | User field 8 for currency for user field 8 | IMA_USE07 | TCURC | CUKY | 5 | 0 | ||||||||
| USR08 | User field 9 as date for IM | IMA_USR08 | DATS | 8 | 0 | |||||||||
| USR09 | User field 10 as date for IM | IMA_USR09 | DATS | 8 | 0 | |||||||||
| USR10 | User field 11 as indicator for IM reports | IMA_USR10 | CHAR | 1 | 0 |
Possible values
|
||||||||
| USR11 | User field 12 as indicator for IM reports | IMA_USR11 | CHAR | 1 | 0 |
Possible values
|
||||||||
| USR12 | User field 13 for period and fiscal year | IMA_USR12 | ACCP | 6 | 0 | |||||||||
| USR13 | User field 14 for period and fiscal year | IMA_USR13 | ACCP | 6 | 0 | |||||||||
| POST1 | Short description | IM_POST1 | CHAR | 40 | 0 | |||||||||
| XLGTX | Ind. "Long text exists" | IM_XLGTX | CHAR | 1 | 0 |
Possible values
|
||||||||
| RHIER | Role of Position within Investment Program Hierarchy | IM_RHIER | CHAR | 1 | 0 |
Possible values
|
||||||||
EPPOS foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| EPPOS | BUKRS | EPPOS | BUKRS | T001 | Company Codes | BUKRS |
| EPPOS | BUKRS | SYST | MANDT | T001 | Company Codes | MANDT |
| EPPOS | GSBER | SYST | MANDT | TGSB | Business Areas | MANDT |
| EPPOS | GSBER | EPPOS | GSBER | TGSB | Business Areas | GSBER |
| EPPOS | IZWEK | SYST | MANDT | T087I | Reason for investment | MANDT |
| EPPOS | IZWEK | EPPOS | IZWEK | T087I | Reason for investment | IZWEK |
| EPPOS | KOKRS | EPPOS | KOKRS | TKA01 | Controlling Areas | KOKRS |
| EPPOS | KOKRS | SYST | MANDT | TKA01 | Controlling Areas | MANDT |
| EPPOS | LAND1 | SYST | MANDT | T005 | Countries | MANDT |
| EPPOS | LAND1 | EPPOS | LAND1 | T005 | Countries | LAND1 |
| EPPOS | OWAERS | SYST | MANDT | TCURC | Currency Codes | MANDT |
| EPPOS | OWAERS | EPPOS | OWAERS | TCURC | Currency Codes | WAERS |
| EPPOS | PPRIO | SYST | MANDT | TCN07 | Priority | MANDT |
| EPPOS | PPRIO | EPPOS | PPRIO | TCN07 | Priority | NPRIO |
| EPPOS | PRNAM | SYST | MANDT | IMTP | Investment programs | MANDT |
| EPPOS | PRNAM | EPPOS | PRNAM | IMTP | Investment programs | PRNAM |
| EPPOS | PRNAM | EPPOS | GJAHR | IMTP | Investment programs | GJAHR |
| EPPOS | RCOMP | EPPOS | RCOMP | T880 | Global Company Data (for KONS Ledger) | RCOMP |
| EPPOS | RCOMP | SYST | MANDT | T880 | Global Company Data (for KONS Ledger) | MANDT |
| EPPOS | SIZECL | SYST | MANDT | TAIF5 | Scale of investment objects | MANDT |
| EPPOS | SIZECL | EPPOS | SIZECL | TAIF5 | Scale of investment objects | SIZECL |
| EPPOS | TPLNR | SYST | MANDT | IFLOT | Functional Location (Table) | MANDT |
| EPPOS | TPLNR | EPPOS | TPLNR | IFLOT | Functional Location (Table) | TPLNR |
| EPPOS | USE04 | SYST | MANDT | T006 | Units of Measurement | MANDT |
| EPPOS | USE04 | EPPOS | USE04 | T006 | Units of Measurement | MSEHI |
| EPPOS | USE05 | SYST | MANDT | T006 | Units of Measurement | MANDT |
| EPPOS | USE05 | EPPOS | USE05 | T006 | Units of Measurement | MSEHI |
| EPPOS | USE06 | EPPOS | USE06 | TCURC | Currency Codes | WAERS |
| EPPOS | USE06 | SYST | MANDT | TCURC | Currency Codes | MANDT |
| EPPOS | USE07 | SYST | MANDT | TCURC | Currency Codes | MANDT |
| EPPOS | USE07 | EPPOS | USE07 | TCURC | Currency Codes | WAERS |
| EPPOS | USR02 | SYST | MANDT | TAIF9 | Value table for user fields | MANDT |
| EPPOS | USR02 | '1' | TAIF9 | Value table for user fields | USRNR | |
| EPPOS | USR02 | EPPOS | USR02 | TAIF9 | Value table for user fields | USR02 |
| EPPOS | USR03 | SYST | MANDT | TAIF9 | Value table for user fields | MANDT |
| EPPOS | USR03 | '2' | TAIF9 | Value table for user fields | USRNR | |
| EPPOS | USR03 | EPPOS | USR03 | TAIF9 | Value table for user fields | USR02 |
| EPPOS | VERNR | SYST | MANDT | TCJ04 | Person in Responsible for Project | MANDT |
| EPPOS | VERNR | EPPOS | VERNR | TCJ04 | Person in Responsible for Project | VERNR |
