| 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 | REFDOCNO | Reference Document Number | nvarchar | 10 | 0 | CHAR | (N' ') | No | | CO_REFBN | Allow NULL? |
| 3 | REF_ORG_UN | Reference Organizational Units | nvarchar | 10 | 0 | CHAR | (N' ') | No | | AWORG | Allow NULL? |
| 4 | OBJ_TYPE | Reference Transaction | nvarchar | 5 | 0 | CHAR | (N' ') | No | * | AWTYP | Allow NULL? |
| 5 | CO_AREA | Controlling Area | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | KOKRS | Allow NULL? |
| 6 | DOCDATE | Document Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | CO_BLDAT | Allow NULL? |
| 7 | POSTGDATE | Posting Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | CO_BUDAT | Allow NULL? |
| 8 | VERSION | Version | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | VERSN | Allow NULL? |
| 9 | DOC_NO | Document Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | CO_BELNR | Allow NULL? |
| 10 | VARIANT | CO actual postings fast input: Variant | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | | CO_VARNR | Allow NULL? |
| 11 | DOC_HDR_TX | Document Header Text | nvarchar | 50 | 0 | CHAR | (N' ') | Yes | | CO_BLTXT | Allow NULL? |
| 12 | UNAME1 | User who wrote record to interface | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | PW_UNAME1 | Allow NULL? |
| 13 | DATUM1 | Date on which record was written to interface | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | PW_DATUM1 | Allow NULL? |
| 14 | UZEIT1 | Time at which record was written to interface | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | PW_UZEIT1 | Allow NULL? |
| 15 | PGMID1 | Write Record to Interface Report | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | PW_PGMID1 | Allow NULL? |
| 16 | UNAME2 | Name of user who initially accessed record | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | PW_UNAME2 | Allow NULL? |
| 17 | DATUM2 | Date on which record was initially accessed | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | PW_DATUM2 | Allow NULL? |
| 18 | UZEIT2 | Time at which record was initially accessed | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | PW_UZEIT2 | Allow NULL? |
| 19 | PGMID2 | Report used to access record initially | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | PW_PGMID2 | Allow NULL? |
| 20 | STATU2 | Log status at first access | char | 1 | 0 | CHAR | (N' ') | Yes | | HRAASTAT2 | Allow NULL? |
| 21 | UNAME3 | Last user to access record | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | PW_UNAME3 | Allow NULL? |
| 22 | DATUM3 | Date on which record was last accessed | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | PW_DATUM3 | Allow NULL? |
| 23 | UZEIT3 | Time at which record was last accessed | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | PW_UZEIT3 | Allow NULL? |
| 24 | PGMID3 | Last Used to Access Record Program | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | PW_PGMID3 | Allow NULL? |
| 25 | STATU3 | Log status when last accessed | char | 1 | 0 | CHAR | (N' ') | Yes | | HRAASTAT3 | Allow NULL? |
| 26 | LOGSYS3 | Logical system | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | LOGSYS | Allow NULL? |
