| 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 | EXKEY | Official Document Number Key | nvarchar | 40 | 0 | CHAR | (N' ') | No | | EXKEY_KK | Allow NULL? |
| 3 | EXKID | Key Identification | nvarchar | 2 | 0 | CHAR | (N' ') | No | | EXKID_KK | Allow NULL? |
| 4 | OPBEL | Number of Contract Accts Rec. & Payable Doc. | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | * | OPBEL_KK | Allow NULL? |
| 5 | OPUPK | Item number in contract account document | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | OPUPK_KK | Allow NULL? |
| 6 | OPUPW | Repetition Item in Contract Account Document | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | OPUPW_KK | Allow NULL? |
| 7 | OPUPZ | Subitem for a Partial Clearing in Document | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | OPUPZ_KK | Allow NULL? |
| 8 | BLART | Document Type | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | BLART_KK | Allow NULL? |
| 9 | BUKRS | Company Code | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | BUKRS | Allow NULL? |
| 10 | BUDAT | Posting Date in the Document | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BUDAT | Allow NULL? |
| 11 | BLDAT | Document Date in Document | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BLDAT | Allow NULL? |
| 12 | GJAHR | Fiscal Year | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | GJAHR | Allow NULL? |
| 13 | NUM | Char 20 | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | CHAR20 | Allow NULL? |
| 14 | DS | Generate Digital Signature | char | 1 | 0 | CHAR | (N' ') | Yes | | DS_KK | Allow NULL? |
| 15 | LAND | Country | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | ODNCNTRY_KK | Allow NULL? |
| 16 | SEOCLSNAME | Object Type Name | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | SEOCLSNAME | Allow NULL? |
| 17 | ITEM_ODN | Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') | char | 1 | 0 | CHAR | (N' ') | Yes | | BOOLE_D | Allow NULL? |
| 18 | SOURCE | Single-Character Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | CHAR1 | Allow NULL? |
| 19 | ODNFORMAT | Official Document Number Format | nvarchar | 60 | 0 | CHAR | (N' ') | Yes | | ODNFORMAT_KK | Allow NULL? |
| 20 | SUBID | Generic Key Extension for Document Class Determination | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | DOCCLS_SUBID_KK | Allow NULL? |
| 21 | CHR_NUM | Chronological Numbering | char | 1 | 0 | CHAR | (N' ') | Yes | | ODN_CHR_KK | Allow NULL? |
| 22 | DOCCLS | Document Class for Official Document Numbers | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | DOCCLS_KK | Allow NULL? |
