| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | CAREA | Compensation Area | nvarchar | 2 | 0 | | | | Allow NULL? |
| 3 | CITEM | Compensation Review Item | nvarchar | 4 | 0 | | | | Allow NULL? |
| 4 | ELKDT | Key Date for Eligibility Checks | nvarchar | 8 | 0 | | | | Allow NULL? |
| 5 | EVBEG | Begin Date of Evaluation Period | nvarchar | 8 | 0 | | | | Allow NULL? |
| 6 | EVEND | End Date of Evaluation Period | nvarchar | 8 | 0 | | | | Allow NULL? |
| 7 | THRNO | Threshold Period for Eligibility (Number) | decimal | 4 | 0 | | | | |
| 8 | THRUN | Threshold Period for Eligibility (Unit) | nvarchar | 3 | 0 | | | | Allow NULL? |
| 9 | EFFIN | Default Effective Date Indicator | char | 1 | 0 | | | | Allow NULL? |
| 10 | EFFDT | Default Effective Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 11 | EFFTY | Date Type for Anniversary Default Effective Date | nvarchar | 2 | 0 | | | | Allow NULL? |
| 12 | EDBEG | Effective Date Period Begin Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 13 | EDEND | Effective Date Period End Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 14 | XEDCH | Indicator: Effective Date is Display-Only | char | 1 | 0 | | | | Allow NULL? |
| 15 | GLDIN | Guideline Key Date Indicator | char | 1 | 0 | | | | Allow NULL? |
| 16 | GLKDT | Key Date for Guideline Evaluation | nvarchar | 8 | 0 | | | | Allow NULL? |
| 17 | BSEDT | Key Date for Evaluation of Calculation Base Salary | nvarchar | 8 | 0 | | | | Allow NULL? |
| 18 | CNVDT | Key Date for Currency Conversion | nvarchar | 8 | 0 | | | | Allow NULL? |
| 19 | BUTYP | Budget Type for Compensation Management | nvarchar | 4 | 0 | | | | Allow NULL? |
| 20 | BUMTP | Message Type for Budget Check | char | 1 | 0 | | | | Allow NULL? |
| 21 | GLMTP | Message Type for Guideline Check | char | 1 | 0 | | | | Allow NULL? |
| 22 | ACMTP | Message Type for Employee Activity Status Check | char | 1 | 0 | | | | Allow NULL? |
| 23 | PREAS | Reason for Changing Infotype on Activation of Comp. Process | nvarchar | 2 | 0 | | | | Allow NULL? |
| 24 | FREQU | Unit of Time | nvarchar | 2 | 0 | | | | Allow NULL? |
| 25 | FINYR | Budget period | nvarchar | 10 | 0 | | | | Allow NULL? |
