| 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 | PERNR | Personnel Number | nvarchar | 8 | 0 | NUMC | (N'00000000') | No | | PERNR_D | Allow NULL? |
| 3 | REINR | Trip Number | nvarchar | 10 | 0 | NUMC | (N'0000000000') | No | | REINR | Allow NULL? |
| 4 | PERIO | Trip Period Number | nvarchar | 3 | 0 | NUMC | (N'000') | No | | PTRV_PEROD | Allow NULL? |
| 5 | PDVRS | Sequential Number of Period | nvarchar | 2 | 0 | NUMC | (N'00') | No | | PTRV_PDVRS | Allow NULL? |
| 6 | LAST_CHANGE | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | DEC | ((0)) | No | | TIMESTAMP | |
| 7 | CHANGE_TYPE | Type of Change Entry in Table PTRV_CHANGE | char | 1 | 0 | CHAR | (N' ') | Yes | | PTRV_CHANGE_TYPE | Allow NULL? |
| 8 | UNAME | Name of Person Who Changed Object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | AENAM | Allow NULL? |
| 9 | REPID | Change Report | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | AEREP | Allow NULL? |
| 10 | DRUCK | Trip Print Status | char | 1 | 0 | CHAR | (N' ') | Yes | | P_PRINT | Allow NULL? |
| 11 | ANTRG | Travel Request or Trip Approved (Indicator) | char | 1 | 0 | CHAR | (N' ') | Yes | | ANTRG | Allow NULL? |
| 12 | ABREC | Open / To be Settled / Settled (Indicator) | char | 1 | 0 | CHAR | (N' ') | Yes | | ABREC | Allow NULL? |
| 13 | UEBLG | HR Payroll Transfer (Indicator) | char | 1 | 0 | CHAR | (N' ') | Yes | | UEBLG | Allow NULL? |
| 14 | UEBRF | FI Transfer (Indicator) | char | 1 | 0 | CHAR | (N' ') | Yes | | UEBRF | Allow NULL? |
| 15 | UEBDT | Data Medium Exchange Transfer (Indicator) | char | 1 | 0 | CHAR | (N' ') | Yes | | UEBDT | Allow NULL? |
| 16 | RUNID | Sequential number of posting run | nvarchar | 10 | 0 | NUMC | (N'0000000000') | Yes | | TR_EVNUM | Allow NULL? |
| 17 | STATU | Status of Travel Expense Posting Runs | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | TR_EVSTS | Allow NULL? |