| 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 | LEDNR | Ledger for Controlling objects | nvarchar | 2 | 0 | CHAR | (N' ') | No | | LEDNR | Allow NULL? |
| 3 | OBJNR | Object number | nvarchar | 22 | 0 | CHAR | (N' ') | No | ONR00 | J_OBJNR | Allow NULL? |
| 4 | GJAHR | Fiscal Year | nvarchar | 4 | 0 | NUMC | (N'0000') | No | | GJAHR | Allow NULL? |
| 5 | WRTTP | Value Type | nvarchar | 2 | 0 | CHAR | (N' ') | No | | CO_WRTTP | Allow NULL? |
| 6 | VERSN | Version | nvarchar | 3 | 0 | CHAR | (N' ') | No | TKA09 | VERSN | Allow NULL? |
| 7 | STAGR | Statistical key figure | nvarchar | 6 | 0 | CHAR | (N' ') | No | TKA03 | STAGR | Allow NULL? |
| 8 | HRKFT | CO key subnumber | nvarchar | 14 | 0 | CHAR | (N' ') | No | * | CO_SUBKEY | Allow NULL? |
| 9 | VRGNG | CO Business Transaction | nvarchar | 4 | 0 | CHAR | (N' ') | No | * | CO_VORGANG | Allow NULL? |
| 10 | PERBL | Period block | nvarchar | 3 | 0 | NUMC | (N'000') | No | | PERBL | Allow NULL? |
| 11 | MEINH | Unit of Measure: Statistical Key Figure | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | CO_MEINH_R | Allow NULL? |
| 12 | SME001 | Statistical quantity | decimal | 15 | 3 | QUAN | ((0)) | Yes | | SMEXXX | |
| 13 | SME002 | Statistical quantity | decimal | 15 | 3 | QUAN | ((0)) | Yes | | SMEXXX | |
| 14 | SME003 | Statistical quantity | decimal | 15 | 3 | QUAN | ((0)) | Yes | | SMEXXX | |
| 15 | SME004 | Statistical quantity | decimal | 15 | 3 | QUAN | ((0)) | Yes | | SMEXXX | |
| 16 | SME005 | Statistical quantity | decimal | 15 | 3 | QUAN | ((0)) | Yes | | SMEXXX | |
| 17 | SME006 | Statistical quantity | decimal | 15 | 3 | QUAN | ((0)) | Yes | | SMEXXX | |
| 18 | SME007 | Statistical quantity | decimal | 15 | 3 | QUAN | ((0)) | Yes | | SMEXXX | |
| 19 | SME008 | Statistical quantity | decimal | 15 | 3 | QUAN | ((0)) | Yes | | SMEXXX | |
| 20 | SME009 | Statistical quantity | decimal | 15 | 3 | QUAN | ((0)) | Yes | | SMEXXX | |
| 21 | SME010 | Statistical quantity | decimal | 15 | 3 | QUAN | ((0)) | Yes | | SMEXXX | |
| 22 | SME011 | Statistical quantity | decimal | 15 | 3 | QUAN | ((0)) | Yes | | SMEXXX | |
| 23 | SME012 | Statistical quantity | decimal | 15 | 3 | QUAN | ((0)) | Yes | | SMEXXX | |
| 24 | SME013 | Statistical quantity | decimal | 15 | 3 | QUAN | ((0)) | Yes | | SMEXXX | |
| 25 | SME014 | Statistical quantity | decimal | 15 | 3 | QUAN | ((0)) | Yes | | SMEXXX | |
| 26 | SME015 | Statistical quantity | decimal | 15 | 3 | QUAN | ((0)) | Yes | | SMEXXX | |
| 27 | SME016 | Statistical quantity | decimal | 15 | 3 | QUAN | ((0)) | Yes | | SMEXXX | |
| 28 | SMA001 | Maximum statistical quantity | decimal | 15 | 3 | QUAN | ((0)) | Yes | | SMAXXX | |
| 29 | SMA002 | Maximum statistical quantity | decimal | 15 | 3 | QUAN | ((0)) | Yes | | SMAXXX | |
| 30 | SMA003 | Maximum statistical quantity | decimal | 15 | 3 | QUAN | ((0)) | Yes | | SMAXXX | |
| 31 | SMA004 | Maximum statistical quantity | decimal | 15 | 3 | QUAN | ((0)) | Yes | | SMAXXX | |
| 32 | SMA005 | Maximum statistical quantity | decimal | 15 | 3 | QUAN | ((0)) | Yes | | SMAXXX | |
| 33 | SMA006 | Maximum statistical quantity | decimal | 15 | 3 | QUAN | ((0)) | Yes | | SMAXXX | |
| 34 | SMA007 | Maximum statistical quantity | decimal | 15 | 3 | QUAN | ((0)) | Yes | | SMAXXX | |
| 35 | SMA008 | Maximum statistical quantity | decimal | 15 | 3 | QUAN | ((0)) | Yes | | SMAXXX | |
| 36 | SMA009 | Maximum statistical quantity | decimal | 15 | 3 | QUAN | ((0)) | Yes | | SMAXXX | |
| 37 | SMA010 | Maximum statistical quantity | decimal | 15 | 3 | QUAN | ((0)) | Yes | | SMAXXX | |
| 38 | SMA011 | Maximum statistical quantity | decimal | 15 | 3 | QUAN | ((0)) | Yes | | SMAXXX | |
| 39 | SMA012 | Maximum statistical quantity | decimal | 15 | 3 | QUAN | ((0)) | Yes | | SMAXXX | |
| 40 | SMA013 | Maximum statistical quantity | decimal | 15 | 3 | QUAN | ((0)) | Yes | | SMAXXX | |
| 41 | SMA014 | Maximum statistical quantity | decimal | 15 | 3 | QUAN | ((0)) | Yes | | SMAXXX | |
| 42 | SMA015 | Maximum statistical quantity | decimal | 15 | 3 | QUAN | ((0)) | Yes | | SMAXXX | |
| 43 | SMA016 | Maximum statistical quantity | decimal | 15 | 3 | QUAN | ((0)) | Yes | | SMAXXX | |
| 44 | FKBER | Functional Area | nvarchar | 16 | 0 | CHAR | (N' ') | Yes | * | FKBER | Allow NULL? |
| 45 | SEGMENT | Segment for Segmental Reporting | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | FAGL_SEGM | FB_SEGMENT | Allow NULL? |
| 46 | GEBER | Fund | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | FM_FUND | Allow NULL? |
| 47 | GRANT_NBR | Grant | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | GM_GRANT_NBR | Allow NULL? |
| 48 | BUDGET_PD | FM: Budget Period | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | FM_BUDGET_PERIOD | Allow NULL? |