SAP Table P9901
Infotype 9901: eQuest Posting Information
P9901 (Infotype 9901: eQuest Posting Information) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link P9901 to other SAP tables.
Source: P9901 (Infotype 9901: eQuest Posting Information)
P9901 table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||||
| PLVAR | Plan Version | PLVAR | T778P | CHAR | 2 | 0 | ||||||||
| OTYPE | Object Type | OTYPE | T778O | CHAR | 2 | 0 | ||||||||
| OBJID | Object ID | OBJEKTID | NUMC | 8 | 0 | |||||||||
| INFTY | Infotype | INFOTYP | T778T | CHAR | 4 | 0 | ||||||||
| SUBTY | Subtype | SUBTYP | CHAR | 4 | 0 | |||||||||
| ISTAT | Planning Status | ISTAT_D | T778S | CHAR | 1 | 0 | ||||||||
| PRIOX | Priority | PRIOX | CHAR | 2 | 0 | |||||||||
| BEGDA | Start Date | BEGDATUM | DATS | 8 | 0 | |||||||||
| ENDDA | End Date | ENDDATUM | DATS | 8 | 0 | |||||||||
| VARYF | Variation Field for File PLOG | VARYF | CHAR | 10 | 0 | |||||||||
| SEQNR | Number of Infotype Record with Same Key | SEQNR | NUMC | 3 | 0 | |||||||||
| AEDTM | Changed on | AEDTM | DATS | 8 | 0 | |||||||||
| UNAME | User Name | USRNAME | CHAR | 12 | 0 | |||||||||
| REASN | Reason | REASN | CHAR | 2 | 0 | |||||||||
| HISTO | Historical Record Flag | HISTO | CHAR | 1 | 0 | |||||||||
| ITXNR | Text Module for Infotype | ITXNR | NUMC | 8 | 0 | |||||||||
| REQUISTION_ID | Object ID | HROBJID | NUMC | 8 | 0 | |||||||||
| JOBTITLE | Internal Job Title | RCF_JOBTITLE | CHAR | 80 | 0 | |||||||||
| ERR_RPLY_EMAIL | Error Reply Email address for eQuest | /ERPSOLUT/ERR_RPLY_EMAIL | CHAR | 40 | 0 | |||||||||
| COMPANY_NAME | Description of Company | RCF_COMPANY_TXT | CHAR | 40 | 0 | |||||||||
| COMPANY_DESC | Description of Company Description for eQuest (Pointer) | /ERPSOLUT/COMPANY_DESC | NUMC | 6 | 0 | |||||||||
| COMPANY_DIV | Company Division | /ERPSOLUT/EQ_DIVISION | CHAR | 25 | 0 | |||||||||
| COMPANY_DEPT | Department | /ERPSOLUT/EQ_DEPT | CHAR | 25 | 0 | |||||||||
| COMPANY_ADDR | Address Line | /ERPSOLUT/EQ_ADDR | CHAR | 40 | 0 | |||||||||
| COMPANY_CITY | City | AD_CITY1 | CHAR | 40 | 0 | |||||||||
| COMPANY_STATE | Character Field Length = 10 | CHAR10 | CHAR | 10 | 0 | |||||||||
| COMPANY_ZIP | City postal code | AD_PSTCD1 | CHAR | 10 | 0 | |||||||||
| COMPANY_CNTRY | Branch Country | RCF_COUNTRY_OF_BRANCH | CHAR | 3 | 0 | |||||||||
| COMPANY_PH | Phone number | /ERPSOLUT/EQ_PHONE_NO | CHAR | 15 | 0 | |||||||||
| COMPANY_FAX | fax number | /ERPSOLUT/EQ_FAX_NO | CHAR | 15 | 0 | |||||||||
| RECRUITER_NAME | eQuest Person's Name | /ERPSOLUT/EQ_ENAME | CHAR | 40 | 0 | |||||||||
| RECRUITER_EMAIL | Recruiter Email address for eQuest | /ERPSOLUT/RECRUITER_EMAIL | CHAR | 40 | 0 | |||||||||
| RECRUITER_ORG | Object Name | STEXT | CHAR | 40 | 0 | |||||||||
| CONTACT_NAME | eQuest Person's Name | /ERPSOLUT/EQ_ENAME | CHAR | 40 | 0 | |||||||||
| CONTACT_EMAIL | Recruiter Email address for eQuest | /ERPSOLUT/RECRUITER_EMAIL | CHAR | 40 | 0 | |||||||||
| JOB_LOC_COUNTRY | Country ISO code | INTCA | CHAR | 2 | 0 | |||||||||
| JOB_LOC_CITY | City | AD_CITY1 | CHAR | 40 | 0 | |||||||||
| JOB_LOC_ZIP | City postal code | AD_PSTCD1 | CHAR | 10 | 0 | |||||||||
| JOB_LOC_ACODE | Area Code | /ERPSOLUT/EQ_AREA_CODE | CHAR | 3 | 0 | |||||||||
| JOB_LOC_STATE | Character Field Length = 10 | CHAR10 | CHAR | 10 | 0 | |||||||||
| CONTRACT_TYPE | positon pay rate (hourly/annual salary) | /ERPSOLUT/EQ_CONTRACT_TYPE | CHAR | 20 | 0 | |||||||||
| WORKING_TIME | positon pay rate (hourly/annual salary) | /ERPSOLUT/EQ_WORKING_TIME | CHAR | 20 | 0 | |||||||||
| EQ_FUNC_CODE | eQuest function code | /ERPSOLUT/EQ_FUNCTION_CODE | CHAR | 10 | 0 | |||||||||
| INDUSTRY | eQuest Industry Code | /ERPSOLUT/EQ_INDUSTRY | CHAR | 8 | 0 | |||||||||
| BRANCH | Branch | RCF_BRANCH | CHAR | 10 | 0 | |||||||||
| COUNTRY | Branch Country | RCF_COUNTRY_OF_BRANCH | CHAR | 3 | 0 | |||||||||
| CITY | City of Branch | RCF_CITY_OF_BRANCH | CHAR | 40 | 0 | |||||||||
| REGION | Region of Branch | RCF_REGION_OF_BRANCH | CHAR | 3 | 0 | |||||||||
| POSTALCODE | Postal Code of Branch | RCF_POSTALCODE_OF_BRANCH | CHAR | 10 | 0 | |||||||||
| TRAVEL_RATIO | Tele Commute Ratio | /ERPSOLUT/EQ_TRAV_RATIO | NUMC | 3 | 0 | |||||||||
| TEL_COM_RATIO | Tele Commute Ratio | /ERPSOLUT/EQ_COMM_RATIO | NUMC | 3 | 0 | |||||||||
| COMP_TYPE | positon pay rate (hourly/annual salary) | /ERPSOLUT/EQ_PAY_RATE | CHAR | 20 | 0 | |||||||||
| COMP_AMT | Annual Basic Salary | /ERPSOLUT/EQ_ANNUAL_PAY | CURR | 15 | 2 | |||||||||
| COMP_MIN | Annual Basic Salary Minimum | RCF_ANNUAL_SALARY_MIN | CURR | 15 | 2 | |||||||||
| COMP_MAX | Annual Basic Salary (Maximum) | RCF_ANNUAL_SALARY_MAX | CURR | 15 | 2 | |||||||||
| CURRENCY | Currency Key | WAERS | CUKY | 5 | 0 | |||||||||
| COMPENS_DESC | Description of Additional Compensation (Pointer) | RCF_COMPENSATION_DESC | NUMC | 6 | 0 | |||||||||
| EMPL_START_DATE | Employment Start Date | RCF_EMPLOYMENT_START_DATE | DATS | 8 | 0 | |||||||||
| EMPL_END_DATE | Employment End Date | RCF_EMPLOYMENT_END_DATE | DATS | 8 | 0 | |||||||||
| EDUCATION | Educational Institution | /ERPSOLUT/EQ_EDU_INSTITUTE | CHAR | 30 | 0 | |||||||||
| POST_DESC | Description of Posting for eQuest (Pointer) | /ERPSOLUT/EQ_POST_DESC | NUMC | 6 | 0 | |||||||||
| SKILL_DESC | Description of Posting Skill Required for eQuest (Pointer) | /ERPSOLUT/EQ_SKILL_DESC | NUMC | 6 | 0 | |||||||||
| POSTED_BOARDS | Description of Posted job boards from eQuest (Pointer) | /ERPSOLUT/EQ_POSTED_JOB_BOARD | NUMC | 6 | 0 | |||||||||
| JOB_BENEFIT | Description of Job Benefit for eQuest (Pointer) | /ERPSOLUT/JOB_BENEFIT | NUMC | 6 | 0 | |||||||||
| EQ_POST_STATUS | eQuest Posting Status | /ERPSOLUT/EQ_POST_STATUS | CHAR | 25 | 0 |
Possible values
|
||||||||
| CREATOR | User Name | USRNAME | CHAR | 12 | 0 | |||||||||
P9901 foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| P9901 | INFTY | P9901 | MANDT | T778T | Infotypes | MANDT |
| P9901 | INFTY | P9901 | INFTY | T778T | Infotypes | INFTY |
| P9901 | ISTAT | P9901 | MANDT | T778S | Planning Status | MANDT |
| P9901 | ISTAT | P9901 | ISTAT | T778S | Planning Status | ISTAT |
| P9901 | MANDT | P9901 | MANDT | T000 | Clients | MANDT |
| P9901 | OTYPE | P9901 | MANDT | T778O | Object Types | MANDT |
| P9901 | OTYPE | P9901 | OTYPE | T778O | Object Types | OTYPE |
| P9901 | PLVAR | P9901 | MANDT | T778P | Plan Versions | MANDT |
| P9901 | PLVAR | P9901 | PLVAR | T778P | Plan Versions | PLVAR |
