| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | T000 | MANDT | Allow NULL? |
| 2 | VERSIO | Version | nvarchar | 3 | 0 | CHAR | (N' ') | No | TKCVS | CFVERSION | Allow NULL? |
| 3 | PLACTI | Plan/Act. indicator (EC-EIS/EC-BP) | char | 1 | 0 | CHAR | (N' ') | No | | CFPLACT | Allow NULL? |
| 4 | YEARB | Fiscal Year | nvarchar | 4 | 0 | NUMC | (N'0000') | No | | CFYEARB | Allow NULL? |
| 5 | PERDE | Period | nvarchar | 3 | 0 | NUMC | (N'000') | No | | CFPERDE | Allow NULL? |
| 6 | VERSO | Data area (previously version) | nvarchar | 2 | 0 | NUMC | (N'00') | No | T242V | CFVERSO | Allow NULL? |
| 7 | COMPNY | Company | nvarchar | 6 | 0 | CHAR | (N' ') | No | T880 | RCOMP_D | Allow NULL? |
| 8 | BUKRS1 | Company Code | nvarchar | 4 | 0 | CHAR | (N' ') | No | T001 | BUKRS | Allow NULL? |
| 9 | BUSARE | Business Area | nvarchar | 4 | 0 | CHAR | (N' ') | No | TGSB | GSBER | Allow NULL? |
| 10 | CONARE | Controlling Area | nvarchar | 4 | 0 | CHAR | (N' ') | No | TKA01 | KOKRS | Allow NULL? |
| 11 | PRFCTR | Profit Center | nvarchar | 10 | 0 | CHAR | (N' ') | No | CEPC | PRCTR | Allow NULL? |
| 12 | COSCTR | Cost Center | nvarchar | 10 | 0 | CHAR | (N' ') | No | CSKS | KOSTL | Allow NULL? |
| 13 | PLANTL | Plant | nvarchar | 4 | 0 | CHAR | (N' ') | No | T001W | WERKS_D | Allow NULL? |
| 14 | INVPRG | Investment program name | nvarchar | 8 | 0 | CHAR | (N' ') | No | IMTP | IM_PRNAM | Allow NULL? |
| 15 | YEOAPR | Approval year of the investment program | nvarchar | 4 | 0 | NUMC | (N'0000') | No | | IM_GNJHR | Allow NULL? |
| 16 | RECNR | CO-BPC record number | nvarchar | 8 | 0 | NUMC | (N'00000000') | No | | CFRECNR | Allow NULL? |
| 17 | AEDTM | Changed On | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | CFAEDTM | Allow NULL? |
| 18 | UNAME | User name | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | CFUNAME | Allow NULL? |
| 19 | VALTY | Value type | char | 1 | 0 | CHAR | (N' ') | Yes | T242W | CFVALTY | Allow NULL? |
| 20 | BSVERS | Financial Statement Version | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T011 | VERSN_011 | Allow NULL? |
| 21 | FSTAKY | Financial Statement Item | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | ERGSL | Allow NULL? |
| 22 | CHACCT | Chart of Accounts | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T004 | KTOPL | Allow NULL? |
| 23 | GLACCT | G/L Account Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | SKA1 | SAKNR | Allow NULL? |
| 24 | CHODEP | Chart of depreciaton for asset valuation | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T096 | AFAPL | Allow NULL? |
| 25 | DEPARE | Real depreciation area | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | T093 | AFABE_D | Allow NULL? |
| 26 | ASSCLA | Asset Class | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | ANKA | ANLKL | Allow NULL? |
| 27 | DEPRKY | Depreciation key | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T090C | AFASL | Allow NULL? |
| 28 | REAINV | Reason for investment | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T087I | IZWEK | Allow NULL? |
| 29 | PRJTYP | Project type | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TCJ1 | PS_PRART | Allow NULL? |
| 30 | ORDTYP | Order Type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T003O | AUFART | Allow NULL? |
| 31 | OBJTYP | Object Type | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | J_OBART_LD | Allow NULL? |
| 32 | CLASCL | Scale of investment objects | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TAIGD | IM_SIZECL | Allow NULL? |
| 33 | PLYEUS | Planned useful life in years | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | NDJAR | Allow NULL? |
| 34 | BGYEAR | Starting fiscal year | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | IM_BEGJHR | Allow NULL? |
| 35 | BEGPER | Starting period | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | IM_BEGPER | Allow NULL? |
| 36 | EDYEAR | End fiscal year | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | IM_ENDJHR | Allow NULL? |
| 37 | ENDPER | End period | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | IM_ENDPER | Allow NULL? |
| 38 | CNTRY | Country Key | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T005 | LAND1 | Allow NULL? |
| 39 | ASSLOC | Asset location | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | T499S | STORT | Allow NULL? |
| 40 | PLALOC | Location plant | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T001W | AUFSOWRK | Allow NULL? |
| 41 | VERSO_WAERS | Currency | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | RKCG_CUKY | Allow NULL? |
| 42 | ACPRCO | Cumulative acquisition value at fiscal year start | decimal | 13 | 2 | CURR | ((0)) | Yes | | ANSW_GJA | |
| 43 | ACQUIS | Acquisitions and post-capitalization | decimal | 13 | 2 | CURR | ((0)) | Yes | | AM_EIS_ACQ | |
| 44 | DIVEST | Retirements for current year | decimal | 13 | 2 | CURR | ((0)) | Yes | | AM_EIS_RET | |
| 45 | TRAPOS | Transfers | decimal | 13 | 2 | CURR | ((0)) | Yes | | AM_EIS_TRA | |
| 46 | REVCUY | Revaluation for the current year (with planned values) | decimal | 13 | 2 | CURR | ((0)) | Yes | | AUFW_LFDP | |
| 47 | DEPBEY | Accumulated depreciation at fiscal year start | decimal | 13 | 2 | CURR | ((0)) | Yes | | AFA_GJA | |
| 48 | DEPCUY | Depreciation for the current year (with planned values) | decimal | 13 | 2 | CURR | ((0)) | Yes | | AFA_LFDP | |
| 49 | INVCUY | Current investment support | decimal | 13 | 2 | CURR | ((0)) | Yes | | INV_LFD | |
| 50 | REINVA | Replacement investment value | decimal | 13 | 2 | CURR | ((0)) | Yes | | AM_EIS_REI | |
| 51 | INSVAL | Current insurable value | decimal | 13 | 2 | CURR | ((0)) | Yes | | VSWRT | |
| 52 | INTRCY | Current interest | decimal | 13 | 2 | CURR | ((0)) | Yes | | SZINS_LFD | |
| 53 | TOMACO | Total(actual) maintenance costs | decimal | 15 | 2 | CURR | ((0)) | Yes | | DGESKOSIST | |
| 54 | INCOST | EIS: Actual internal costs | decimal | 15 | 2 | CURR | ((0)) | Yes | | PM_EIS_EIG | |
| 55 | EXCOST | EIS: Actual (external) costs | decimal | 15 | 2 | CURR | ((0)) | Yes | | PM_EIS_FRD | |
| 56 | IMTOVA | Overall Value in Reporting Currency | decimal | 15 | 2 | CURR | ((0)) | Yes | | IM_WGP | |
| 57 | IMVAYR | Annual Value in Reporting Currency | decimal | 15 | 2 | CURR | ((0)) | Yes | | IM_WJP | |
| 58 | IMTOCP | Total value to be capitalized in captl investmt prog.curr. | decimal | 15 | 2 | CURR | ((0)) | Yes | | IM_WGAP | |
| 59 | IMCPYR | Annual value to be capitalized in captl investmt prog.curr. | decimal | 15 | 2 | CURR | ((0)) | Yes | | IM_WJAP | |
| 60 | METOVA | Overall value in controlling area currency | decimal | 15 | 2 | CURR | ((0)) | Yes | | IM_WGK | |
| 61 | MEVAYR | Annual value in controlling area currency | decimal | 15 | 2 | CURR | ((0)) | Yes | | IM_WJK | |
| 62 | FCTOVA | Total expected value in controlling area currency | decimal | 15 | 2 | CURR | ((0)) | Yes | | IM_EWGK | |
| 63 | FCVAYR | Annual expected value in controlling area currency | decimal | 15 | 2 | CURR | ((0)) | Yes | | IM_EWJK | |
