| 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 | Entry Document Number | nvarchar | 10 | 0 | NUMC | (N'0000000000') | No | | BP_DOCNR | Allow NULL? |
| 3 | CPUDT | Date Document Was Created | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | CO_CPUDT | Allow NULL? |
| 4 | BUDAT | Posting Date in the Document | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BUDAT | Allow NULL? |
| 5 | PERIO | Posting period | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | POPER | Allow NULL? |
| 6 | BLDAT | Document Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BP_BLDAT | Allow NULL? |
| 7 | VADAT | Planning/budgeting value date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BD_VADAT | Allow NULL? |
| 8 | VERANT | Person Responsible for Planning/Budgeting | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | BP_VERANT | Allow NULL? |
| 9 | USNAM | Name of Person who Created the Object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | ERNAM | Allow NULL? |
| 10 | VALKEY | Validation Key Budget/Planning | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | BP_VALKEY | Allow NULL? |
| 11 | BSTAT | Document/Document Line Item Status | char | 1 | 0 | CHAR | (N' ') | Yes | | BP_BSTAT | Allow NULL? |
| 12 | FCODE | Budgeting/planning function | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | | BP_FCODE | Allow NULL? |
| 13 | REASON | Reason for decision for workflow | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | FMREASON | Allow NULL? |
| 14 | RSTAT | Reversal status | char | 1 | 0 | CHAR | (N' ') | Yes | | BP_RSTAT | Allow NULL? |
| 15 | REV_DOCNR | Original document | nvarchar | 10 | 0 | NUMC | (N'0000000000') | Yes | * | REV_DOCNR | Allow NULL? |
| 16 | RPUBLAW | Public Law Cited | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | FM_PUBLAW | Allow NULL? |
| 17 | RLEGIS | Type of Legislation | char | 1 | 0 | CHAR | (N' ') | Yes | | FM_LEGIS | Allow NULL? |
| 18 | RCOHORT | Reporting Year for Cohort | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | FM_COHORT | Allow NULL? |
| 19 | DOCTYPE | Budget entry document type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | BUED_DOCTYPE | Allow NULL? |
| 20 | AWORG | Reference Organizational Units | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | AWORG | Allow NULL? |
| 21 | AWREF | Reference Document Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | AWREF | Allow NULL? |
| 22 | AWSYS | Logical system of source document | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | AWSYS | Allow NULL? |
| 23 | AWTYP | Reference Transaction | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | * | AWTYP | Allow NULL? |
| 24 | /SAPF15/STATUS | | char | 1 | 0 | | (N' ') | Yes | | | Allow NULL? |
| 25 | SRC_BELNR | Original document | nvarchar | 10 | 0 | NUMC | (N'0000000000') | Yes | * | REV_DOCNR | Allow NULL? |
