| 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 | * | MANDT | Allow NULL? |
| 2 | OBJNR | Object number | nvarchar | 22 | 0 | CHAR | (N' ') | No | * | BP_OBJEKT | Allow NULL? |
| 3 | COCUR | Currency | nvarchar | 5 | 0 | CUKY | (N' ') | No | * | BP_WAERS | Allow NULL? |
| 4 | BELTP | Debit type | char | 1 | 0 | NUMC | (N'0') | No | | BP_INOUT | Allow NULL? |
| 5 | WRTTP | Value Type | nvarchar | 2 | 0 | CHAR | (N' ') | No | | CO_WRTTP | Allow NULL? |
| 6 | GJAHR | Fiscal Year | nvarchar | 4 | 0 | NUMC | (N'0000') | No | | GJAHR | Allow NULL? |
| 7 | ACPOS | Value category | nvarchar | 14 | 0 | CHAR | (N' ') | No | * | ACPOS | Allow NULL? |
| 8 | VERSN | Planning/budgeting version | nvarchar | 3 | 0 | CHAR | (N' ') | No | * | BP_VERSION | Allow NULL? |
| 9 | PERBL | Period block | nvarchar | 3 | 0 | NUMC | (N'000') | No | | PERBL | Allow NULL? |
| 10 | VORGA | Budget Type Budgeting/Planning | nvarchar | 4 | 0 | CHAR | (N' ') | No | * | BP_VORGANG | Allow NULL? |
| 11 | BEMOT | Accounting Indicator | nvarchar | 2 | 0 | CHAR | (N' ') | No | * | BEMOT | Allow NULL? |
| 12 | ABKAT | Category for Variance/Results Analysis | nvarchar | 2 | 0 | NUMC | (N'00') | No | | ABKAT | Allow NULL? |
| 13 | WRT00 | Period value in ledger currency | decimal | 15 | 2 | CURR | ((0)) | No | | BP_WPL | |
| 14 | WRT01 | Period value in ledger currency | decimal | 15 | 2 | CURR | ((0)) | No | | BP_WPL | |
| 15 | WRT02 | Period value in ledger currency | decimal | 15 | 2 | CURR | ((0)) | No | | BP_WPL | |
| 16 | WRT03 | Period value in ledger currency | decimal | 15 | 2 | CURR | ((0)) | No | | BP_WPL | |
| 17 | WRT04 | Period value in ledger currency | decimal | 15 | 2 | CURR | ((0)) | No | | BP_WPL | |
| 18 | WRT05 | Period value in ledger currency | decimal | 15 | 2 | CURR | ((0)) | No | | BP_WPL | |
| 19 | WRT06 | Period value in ledger currency | decimal | 15 | 2 | CURR | ((0)) | No | | BP_WPL | |
| 20 | WRT07 | Period value in ledger currency | decimal | 15 | 2 | CURR | ((0)) | No | | BP_WPL | |
| 21 | WRT08 | Period value in ledger currency | decimal | 15 | 2 | CURR | ((0)) | No | | BP_WPL | |
| 22 | WRT09 | Period value in ledger currency | decimal | 15 | 2 | CURR | ((0)) | No | | BP_WPL | |
| 23 | WRT10 | Period value in ledger currency | decimal | 15 | 2 | CURR | ((0)) | No | | BP_WPL | |
| 24 | WRT11 | Period value in ledger currency | decimal | 15 | 2 | CURR | ((0)) | No | | BP_WPL | |
| 25 | WRT12 | Period value in ledger currency | decimal | 15 | 2 | CURR | ((0)) | No | | BP_WPL | |
| 26 | WRT13 | Period value in ledger currency | decimal | 15 | 2 | CURR | ((0)) | No | | BP_WPL | |
| 27 | WRT14 | Period value in ledger currency | decimal | 15 | 2 | CURR | ((0)) | No | | BP_WPL | |
| 28 | WRT15 | Period value in ledger currency | decimal | 15 | 2 | CURR | ((0)) | No | | BP_WPL | |
| 29 | WRT16 | Period value in ledger currency | decimal | 15 | 2 | CURR | ((0)) | No | | BP_WPL | |
