| 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 | HEADER | Job Posting Title (Pointer) | nvarchar | 6 | 0 | NUMC | (N'000000') | Yes | | RCF_POSITION_HEADER | Allow NULL? |
| 19 | ORG_WEBSITE | URL of Hiring Organization | nvarchar | 200 | 0 | CHAR | (N' ') | Yes | | RCF_HIRING_ORG_WEBSITE | Allow NULL? |
| 20 | ORG_NAME | Name of Hiring Organization (Pointer) | nvarchar | 6 | 0 | NUMC | (N'000000') | Yes | | RCF_HIRING_ORG_NAME | Allow NULL? |
| 21 | POSTAL_CODE | City postal code | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | AD_PSTCD1 | Allow NULL? |
| 22 | REGION | Region (State, Province, County) | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | REGIO | Allow NULL? |
| 23 | COUNTRY | Country Key | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | LAND1 | Allow NULL? |
| 24 | FUNCTIONAL_AREA | Functional Area | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | * | RCF_FUNCTIONAL_AREA | Allow NULL? |
| 25 | INDUSTRY | Industry | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | * | RCF_INDUSTRY | Allow NULL? |
| 26 | WORKING_TIME | Working Time in Hours per Week | decimal | 4 | 2 | DEC | ((0)) | Yes | | RCF_WORKING_TIME | |
| 27 | CONTRACT_TYPE | Work Contract Type | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | * | RCF_WORK_CONTRACT_TYPE | Allow NULL? |
| 28 | STATUS | Posting Status | char | 1 | 0 | NUMC | (N'0') | Yes | | RCF_POSTING_STATUS | Allow NULL? |
| 29 | COMPANY_DESC | Description of Company (Pointer) | nvarchar | 6 | 0 | NUMC | (N'000000') | Yes | | RCF_COMPANY_DESC | Allow NULL? |
| 30 | DEPARTMENT_DESC | Name of Department (Pointer) | nvarchar | 6 | 0 | NUMC | (N'000000') | Yes | | RCF_DEPARTMENT_DESC | Allow NULL? |
| 31 | PROJECT_DESC | Description of Project (Pointer) | nvarchar | 6 | 0 | NUMC | (N'000000') | Yes | | RCF_PROJECT_DESC | Allow NULL? |
| 32 | TASK_DESC | Name of Tasks (Pointer) | nvarchar | 6 | 0 | NUMC | (N'000000') | Yes | | RCF_TASK_DESC | Allow NULL? |
| 33 | REQUIREMENT_DESC | Description of Requirements (Pointer) | nvarchar | 6 | 0 | NUMC | (N'000000') | Yes | | RCF_REQUIREMENT_DESC | Allow NULL? |
| 34 | REQUESTED_STATUS | Status Requested for Job Posting | char | 1 | 0 | CHAR | (N' ') | Yes | | RCF_POSTING_REQUESTED_STATUS | Allow NULL? |
| 35 | REASON_CODE | Status Reason | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | * | RCF_REASON_CODE | Allow NULL? |
| 36 | REQUESTED_RSNCD | Requested Status Reason | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | RCF_REQUESTED_RSN_CODE | Allow NULL? |
| 37 | TEXT | Posting Text | nvarchar | 25 | 0 | CHAR | (N' ') | Yes | | RCF_POSTING_TEXT | Allow NULL? |
