| 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 | BELNR | Document number from budget allocation & structure planning | nvarchar | 10 | 0 | NUMC | (N'0000000000') | No | | BP_BELNR | Allow NULL? |
| 3 | GJAHR | Fiscal Year | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | GJAHR | Allow NULL? |
| 4 | VORGA | Budget Type Budgeting/Planning | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T022 | BP_VORGANG | Allow NULL? |
| 5 | CPUDT | Date Document Was Created | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | CO_CPUDT | Allow NULL? |
| 6 | USNAM | Name of Person who Created the Object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | ERNAM | Allow NULL? |
| 7 | SUMBZ | Number of posting lines for local objects | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | CO_SUMBZ | Allow NULL? |
| 8 | BUDAT | Posting Date in the Document | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BUDAT | Allow NULL? |
| 9 | PERIO | Posting period | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | POPER | Allow NULL? |
| 10 | BLDAT | Document Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BP_BLDAT | Allow NULL? |
| 11 | SGTEXT | Item Text | nvarchar | 50 | 0 | CHAR | (N' ') | Yes | | SGTXT | Allow NULL? |
| 12 | NAMTEXT | Text Name | nvarchar | 32 | 0 | CHAR | (N' ') | Yes | | TDNAM | Allow NULL? |
| 13 | DELBZ | Number of deleted line items | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | CO_DELBZ | Allow NULL? |
| 14 | SUM_BPJA | Number of posting lines for local objects | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | CO_SUMBZ | Allow NULL? |
| 15 | DEL_BPJA | Number of deleted line items | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | CO_DELBZ | Allow NULL? |
| 16 | SUM_BPGE | Number of posting lines for local objects | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | CO_SUMBZ | Allow NULL? |
| 17 | DEL_BPGE | Number of deleted line items | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | CO_DELBZ | Allow NULL? |
| 18 | SUM_BPPE | Number of posting lines for local objects | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | CO_SUMBZ | Allow NULL? |
| 19 | DEL_BPPE | Number of deleted line items | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | CO_DELBZ | Allow NULL? |
| 20 | FOBEL | Follow-On Document Number | nvarchar | 10 | 0 | NUMC | (N'0000000000') | Yes | BPBK | BP_FOBEL | Allow NULL? |
| 21 | VERANT | Person Responsible for Planning/Budgeting | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | BP_VERANT | Allow NULL? |
| 22 | SVERSN | Planning/budgeting source version | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | BP_SVERSN | Allow NULL? |
| 23 | VALKEY | Validation Key Budget/Planning | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | BP_VALKEY | Allow NULL? |
| 24 | BPDK_BELNR | Entry Document Number | nvarchar | 10 | 0 | NUMC | (N'0000000000') | Yes | * | BP_DOCNR | Allow NULL? |
