| 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 | PLVAR | Plan Version | nvarchar | 2 | 0 | CHAR | (N' ') | No | T778P | PLVAR | Allow NULL? |
| 3 | OTYPE | Object Type | nvarchar | 2 | 0 | CHAR | (N' ') | No | T778O | OTYPE | Allow NULL? |
| 4 | OBJID | Object ID | nvarchar | 8 | 0 | NUMC | (N'00000000') | No | PLOGI | HROBJID | Allow NULL? |
| 5 | SUBTY | Subtype | nvarchar | 4 | 0 | CHAR | (N' ') | No | * | SUBTYP | Allow NULL? |
| 6 | ISTAT | Planning Status | char | 1 | 0 | CHAR | (N' ') | No | T778S | ISTAT_D | Allow NULL? |
| 7 | BEGDA | Start Date | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | BEGDATUM | Allow NULL? |
| 8 | ENDDA | End Date | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | ENDDATUM | Allow NULL? |
| 9 | VARYF | Variation Field for File PLOG | nvarchar | 10 | 0 | CHAR | (N' ') | No | | VARYF | Allow NULL? |
| 10 | SEQNR | Number of Infotype Record with Same Key | nvarchar | 3 | 0 | NUMC | (N'000') | No | | SEQNR | Allow NULL? |
| 11 | INFTY | Infotype | nvarchar | 4 | 0 | CHAR | (N' ') | No | T778T | INFOTYP | Allow NULL? |
| 12 | OTJID | Concatenation of Object Type and Object ID | nvarchar | 10 | 0 | CHAR | (N' ') | No | | OTJID | Allow NULL? |
| 13 | AEDTM | Changed on | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | AEDTM | Allow NULL? |
| 14 | UNAME | User Name | nvarchar | 12 | 0 | CHAR | (N' ') | No | | USRNAME | Allow NULL? |
| 15 | REASN | Reason | nvarchar | 2 | 0 | CHAR | (N' ') | No | | REASN | Allow NULL? |
| 16 | HISTO | Historical Record Flag | char | 1 | 0 | CHAR | (N' ') | No | | HISTO | Allow NULL? |
| 17 | ITXNR | Text Module for Infotype | nvarchar | 8 | 0 | NUMC | (N'00000000') | No | | ITXNR | Allow NULL? |
| 18 | FREE_INPUT | Flag: Free Input for Appraisal Element Name | char | 1 | 0 | CHAR | (N' ') | Yes | | HAP_FREE_INPUT | Allow NULL? |
| 19 | LAYOUT_TEXT | Text Layout | char | 1 | 0 | CHAR | (N' ') | Yes | | HAP_LAYOUT_TEXT | Allow NULL? |
| 20 | LAYOUT_VALUES | Layout of Values (Dropdown List) | char | 1 | 0 | CHAR | (N' ') | Yes | | HAP_LAYOUT_VALUES | Allow NULL? |
| 21 | LAYOUT_NOTE_LINE | Layout: Lines Reserved for Note | char | 1 | 0 | NUMC | (N'0') | Yes | | HAP_LAYOUT_NOTE_LINE | Allow NULL? |
| 22 | LAYOUT_MAX_CHAR | Layout: Maximum Number of Characters in Note | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | HAP_LAYOUT_MAX_CHAR | Allow NULL? |
| 23 | EXIT_ADD_FIX | Enhancement: Fixed Enhancement | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | * | HAP_EXIT_ADD_FIX | Allow NULL? |
| 24 | EXIT_ADD_FREE | Enhancement: Free Enhancement | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | * | HAP_EXIT_ADD_FREE | Allow NULL? |
| 25 | EXIT_DELETE | Enhancement: Deletion of an Element | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | * | HAP_EXIT_DELETE | Allow NULL? |
| 26 | TABNR | Reference Number to Table Part | nvarchar | 32 | 0 | CHAR | (N' ') | No | HRITABNR | HRTABNR | Allow NULL? |
