| 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 | Budget/Planning Ledger | nvarchar | 4 | 0 | CHAR | (N' ') | No | | BP_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 | PERBL | Period block | nvarchar | 3 | 0 | NUMC | (N'000') | No | | PERBL | Allow NULL? |
| 6 | GEBER | Fund | nvarchar | 10 | 0 | CHAR | (N' ') | No | * | BP_GEBER | Allow NULL? |
| 7 | WRTTP | Value Type | nvarchar | 2 | 0 | CHAR | (N' ') | No | | CO_WRTTP | Allow NULL? |
| 8 | TRGKZ | Object indicator | char | 1 | 0 | CHAR | (N' ') | No | | BP_TRGKZ | Allow NULL? |
| 9 | VORGA | CO Business Transaction | nvarchar | 4 | 0 | CHAR | (N' ') | No | * | CO_VORGANG | Allow NULL? |
| 10 | POSIT | Internal commitment item (8 chars) | nvarchar | 8 | 0 | CHAR | (N' ') | No | | BP_POSIT | Allow NULL? |
| 11 | TWAER | Transaction Currency | nvarchar | 5 | 0 | CUKY | (N' ') | No | TCURC | TWAER | Allow NULL? |
| 12 | BUKRS | Company Code | nvarchar | 4 | 0 | CHAR | (N' ') | No | T001 | BUKRS | Allow NULL? |
| 13 | GSBER | Business Area | nvarchar | 4 | 0 | CHAR | (N' ') | No | TGSB | GSBER | Allow NULL? |
| 14 | OBJNRZ | Object number | nvarchar | 22 | 0 | CHAR | (N' ') | No | * | J_OBJNR | Allow NULL? |
| 15 | BTR001 | Amount, period 1 | decimal | 15 | 2 | CURR | ((0)) | No | | BTR001 | |
| 16 | BTR002 | Amount, period 2 | decimal | 15 | 2 | CURR | ((0)) | No | | BTR002 | |
| 17 | BTR003 | Amount, period 3 | decimal | 15 | 2 | CURR | ((0)) | No | | BTR003 | |
| 18 | BTR004 | Amount, period 4 | decimal | 15 | 2 | CURR | ((0)) | No | | BTR004 | |
| 19 | BTR005 | Amount, period 5 | decimal | 15 | 2 | CURR | ((0)) | No | | BTR005 | |
| 20 | BTR006 | Amount, period 6 | decimal | 15 | 2 | CURR | ((0)) | No | | BTR006 | |
| 21 | BTR007 | Amount, period 7 | decimal | 15 | 2 | CURR | ((0)) | No | | BTR007 | |
| 22 | BTR008 | Amount, period 8 | decimal | 15 | 2 | CURR | ((0)) | No | | BTR008 | |
| 23 | BTR009 | Amount, period 9 | decimal | 15 | 2 | CURR | ((0)) | No | | BTR009 | |
| 24 | BTR010 | Amount, period 10 | decimal | 15 | 2 | CURR | ((0)) | No | | BTR010 | |
| 25 | BTR011 | Amount, period 11 | decimal | 15 | 2 | CURR | ((0)) | No | | BTR011 | |
| 26 | BTR012 | Amount, period 12 | decimal | 15 | 2 | CURR | ((0)) | No | | BTR012 | |
| 27 | BTR013 | Amount, period 13 | decimal | 15 | 2 | CURR | ((0)) | No | | BTR013 | |
| 28 | BTR014 | Amount, period 14 | decimal | 15 | 2 | CURR | ((0)) | No | | BTR014 | |
| 29 | BTR015 | Period 15 amount | decimal | 15 | 2 | CURR | ((0)) | No | | BTR015 | |
| 30 | BTR016 | Period 16 amount | decimal | 15 | 2 | CURR | ((0)) | No | | BTR016 | |
| 31 | BTRT01 | Period 1 amount in transaction currency | decimal | 15 | 2 | CURR | ((0)) | No | | BTRT01 | |
| 32 | BTRT02 | Period 2 amount in transaction currency | decimal | 15 | 2 | CURR | ((0)) | No | | BTRT02 | |
| 33 | BTRT03 | Period 3 amount in transaction currency | decimal | 15 | 2 | CURR | ((0)) | No | | BTRT03 | |
| 34 | BTRT04 | Period 4 amount in transaction currency | decimal | 15 | 2 | CURR | ((0)) | No | | BTRT04 | |
| 35 | BTRT05 | Period 5 amount in transaction currency | decimal | 15 | 2 | CURR | ((0)) | No | | BTRT05 | |
| 36 | BTRT06 | Period 6 amount in transaction currency | decimal | 15 | 2 | CURR | ((0)) | No | | BTRT06 | |
| 37 | BTRT07 | Period 7 amount in transaction currency | decimal | 15 | 2 | CURR | ((0)) | No | | BTRT07 | |
| 38 | BTRT08 | Period 8 amount in transaction currency | decimal | 15 | 2 | CURR | ((0)) | No | | BTRT08 | |
| 39 | BTRT09 | Period 9 amount in transaction currency | decimal | 15 | 2 | CURR | ((0)) | No | | BTRT09 | |
| 40 | BTRT10 | Period 10 amount in transaction currency | decimal | 15 | 2 | CURR | ((0)) | No | | BTRT10 | |
| 41 | BTRT11 | Period 12 amount in transaction currency | decimal | 15 | 2 | CURR | ((0)) | No | | BTRT11 | |
| 42 | BTRT12 | Period 12 amount in transaction currency | decimal | 15 | 2 | CURR | ((0)) | No | | BTRT12 | |
| 43 | BTRT13 | Period 13 amount in transaction currency | decimal | 15 | 2 | CURR | ((0)) | No | | BTRT13 | |
| 44 | BTRT14 | Period 14 amount in transaction currency | decimal | 15 | 2 | CURR | ((0)) | No | | BTRT14 | |
| 45 | BTRT15 | Period 15 amount in transaction currency | decimal | 15 | 2 | CURR | ((0)) | No | | BTRT15 | |
| 46 | BTRT16 | Period 16 amount in transaction currency | decimal | 15 | 2 | CURR | ((0)) | No | | BTRT16 | |