| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | CLIENT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | * | MANDT | Allow NULL? |
| 2 | SFSF_USERID | USERID | nvarchar | 100 | 0 | CHAR | (N' ') | No | | HRSFI_USERID | Allow NULL? |
| 3 | ACTION | Action for Integrating Compensation Management with SFSF | char | 1 | 0 | CHAR | (N' ') | No | | HRSFI_COMP_ACTION | Allow NULL? |
| 4 | PROCESSING_STEP | SFSF Compensation Process Step | char | 1 | 0 | CHAR | (N' ') | No | | HRSFI_COMP_PROCESS_STEP | Allow NULL? |
| 5 | FIELD_SET | Field Set ID for Exporting Compensation Data to SFSF | nvarchar | 30 | 0 | CHAR | (N' ') | No | * | HRSFI_COMP_EXPORT_FIELD_SET | Allow NULL? |
| 6 | TEMPLATE_ID | SFSF Template ID | nvarchar | 30 | 0 | CHAR | (N' ') | No | * | HRSFI_COMP_SFI_TEMPLATE_ID | Allow NULL? |
| 7 | NBR | Numc3, internal use | nvarchar | 3 | 0 | NUMC | (N'000') | No | | NUMC3 | Allow NULL? |
| 8 | PERSONID | Technical Person Number | nvarchar | 8 | 0 | NUMC | (N'00000000') | Yes | | PERSONID | Allow NULL? |
| 9 | MAIN_PERNR | Personnel Number | nvarchar | 8 | 0 | NUMC | (N'00000000') | Yes | | PERNR_D | Allow NULL? |
| 10 | TRANSFER_DATE | System Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | SYDATUM | Allow NULL? |
| 11 | TRANSFER_TIME | System Time | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | SYUZEIT | Allow NULL? |
| 12 | MESSAGE_TYPE | Message type: S Success, E Error, W Warning, I Info, A Abort | char | 1 | 0 | CHAR | (N' ') | Yes | | BAPI_MTYPE | Allow NULL? |
| 13 | MESSAGE_ID | Message Class | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | * | SYMSGID | Allow NULL? |
| 14 | MESSAGE_NUMBER | Message Number | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | SYMSGNO | Allow NULL? |
| 15 | MSGV1 | Message Variable | nvarchar | 50 | 0 | CHAR | (N' ') | Yes | | SYMSGV | Allow NULL? |
| 16 | MSGV2 | Message Variable | nvarchar | 50 | 0 | CHAR | (N' ') | Yes | | SYMSGV | Allow NULL? |
| 17 | MSGV3 | Message Variable | nvarchar | 50 | 0 | CHAR | (N' ') | Yes | | SYMSGV | Allow NULL? |
| 18 | MSGV4 | Message Variable | nvarchar | 50 | 0 | CHAR | (N' ') | Yes | | SYMSGV | Allow NULL? |
| 19 | MESSAGE_TEXT | Message Text | nvarchar | 220 | 0 | CHAR | (N' ') | Yes | | BAPI_MSG | Allow NULL? |
| 20 | FIRST_CRT_DATE | System Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | SYDATUM | Allow NULL? |
| 21 | FIRST_CRT_TIME | System Time | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | SYUZEIT | Allow NULL? |
| 22 | STATUS | Error Status Values Unsolved (= ' ') and Solved (= 'X') | char | 1 | 0 | CHAR | (N' ') | Yes | | HRSFI_COMP_ERROR_STATUS | Allow NULL? |
| 23 | IMPORT_SOURCE | Import Source - Ad Hoc Report ID or CSV File Name | ntext | 1073741823 | 0 | | | Yes | | HRSFI_COMP_IMPORT_SOURCE | |
