SAP ABAP Table HRP1660 (DB Table for Infotype 1660)
Hierarchy
☛
SAP_HRCUS (Software Component) Sub component SAP_HRCUS of SAP_HR
⤷ PY-US-PS (Application Component) Öffentlicher Dienst
⤷ P10PA (Package) HR master data: Development Personnel Actions
⤷ PY-US-PS (Application Component) Öffentlicher Dienst
⤷ P10PA (Package) HR master data: Development Personnel Actions
Basic Data
Table Category | TRANSP | Transparent table |
Transparent table | HRP1660 | Table Relationship Diagram |
Short Description | DB Table for Infotype 1660 |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | C | Customizing table, maintenance only by cust., not SAP import |
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | .INCLUDE | 0 | 0 | Extended Key Definition of PD Infotypes | |||||
2 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
3 | PLVAR | PLVAR | PLVAR | CHAR | 2 | 0 | Plan Version | T778P | |
4 | OTYPE | OTYPE | OTYPE | CHAR | 2 | 0 | Object Type | T778O | |
5 | OBJID | HROBJID | HROBJID | NUMC | 8 | 0 | Object ID | PLOGI | |
6 | SUBTY | SUBTYP | SUBTYP | CHAR | 4 | 0 | Subtype | * | |
7 | ISTAT | ISTAT_D | ISTAT | CHAR | 1 | 0 | Planning Status | T778S | |
8 | BEGDA | BEGDATUM | DATUM | DATS | 8 | 0 | Start Date | ||
9 | ENDDA | ENDDATUM | DATUM | DATS | 8 | 0 | End Date | ||
10 | VARYF | VARYF | CHAR10 | CHAR | 10 | 0 | Variation Field for File PLOG | ||
11 | SEQNR | SEQNR | NUM03 | NUMC | 3 | 0 | Number of Infotype Record With Same Key | ||
12 | INFTY | INFOTYP | INFOTYP | CHAR | 4 | 0 | Infotype | T778T | |
13 | OTJID | OTJID | CHAR10 | CHAR | 10 | 0 | Concatenation of Object Type and Object ID | ||
14 | .INCLUDE | 0 | 0 | Infotype Administration Data | |||||
15 | AEDTM | AEDTM | DATUM | DATS | 8 | 0 | Changed on | ||
16 | UNAME | USRNAME | CHAR12 | CHAR | 12 | 0 | User Name | ||
17 | REASN | REASN | CHAR2 | CHAR | 2 | 0 | Reason | ||
18 | HISTO | HISTO | CHAR1 | CHAR | 1 | 0 | Historical Record Flag | ||
19 | ITXNR | ITXNR | NUM08 | NUMC | 8 | 0 | Text Module for Infotype | ||
20 | .INCLUDE | 0 | 0 | Fields for US Federal Position Attributes | |||||
21 | CMPAR | P10_CMPAR | P10_CMPAR | CHAR | 4 | 0 | Competitive Area | T5UPBSCOMPAR | |
22 | CMPLV | P10_CMPLV | P10_CMPLV | CHAR | 4 | 0 | Competitive Level | T5UPBSCMPLV | |
23 | STATE | P10_STATE | P10_STATE | CHAR | 2 | 0 | Duty Station State or Country | T5UPBSDSSTATE | |
24 | COUNTY | P10_CONTY | P10_CONTY | CHAR | 3 | 0 | Duty Station County | T5UPBSDSCOUNTY | |
25 | CITY | P10_CITY | P10_CITY | CHAR | 4 | 0 | Duty Station City | T5UPBSDSCITY | |
26 | PSOCC | P10_PSOCC | P10_PSOCC | CHAR | 1 | 0 | Position Occupied | * | |
27 | PSSEN | P10_PSSEN | P10_PSSEN | CHAR | 1 | 0 | Position Sensitivity | * | |
28 | SECCL | P10_SECCL | P10_SECCL | CHAR | 1 | 0 | Security Clearance | T5UPBSSECCL | |
29 | FINST | P10_FINST | P10_FINST | CHAR | 1 | 0 | Financial Statements Required | ||
30 | DRGTEST | P10_DRGTEST | XFELD | CHAR | 1 | 0 | Drug Test Designated Position | ||
31 | FUCLS | P10P_FUCLS | P10P_FUCLS | NUMC | 2 | 0 | Functional Classification Code | T5UPBSPA09 | |
32 | SUSTS | P10P_SUSTS | P10P_SUSTS | NUMC | 1 | 0 | Supervisory Status Code | T5UPBSPA10 | |
33 | BARUN | P10P_BARUN | P10P_BARUN | NUMC | 4 | 0 | Bargaining Unit | T5UPBSPA13 | |
34 | PEROF | P10P_PEROF | P10P_PEROF | NUMC | 4 | 0 | Personnel Office Identifier | T5UPBSPA31 |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | HRP1660 | BARUN | T5UPBSPA13 | BARUN | KEY | 1 | CN |
2 | HRP1660 | CITY | T5UPBSDSCITY | CITY | |||
3 | HRP1660 | CMPAR | T5UPBSCOMPAR | CMPAR | |||
4 | HRP1660 | CMPLV | T5UPBSCMPLV | CMPLV | |||
5 | HRP1660 | COUNTY | T5UPBSDSCOUNTY | CONTY | |||
6 | HRP1660 | FUCLS | T5UPBSPA09 | FUCLS | KEY | 1 | CN |
7 | HRP1660 | INFTY | T778T | INFTY | KEY | 1 | CN |
8 | HRP1660 | ISTAT | T778S | ISTAT | KEY | 1 | CN |
9 | HRP1660 | MANDT | T000 | MANDT | KEY | 1 | CN |
10 | HRP1660 | OBJID | PLOGI | OBJID | KEY | 1 | CN |
11 | HRP1660 | OTYPE | T778O | OTYPE | KEY | 1 | CN |
12 | HRP1660 | PEROF | T5UPBSPA31 | PEROF | KEY | 1 | CN |
13 | HRP1660 | PLVAR | T778P | PLVAR | KEY | 1 | CN |
14 | HRP1660 | SECCL | T5UPBSSECCL | SECCL | |||
15 | HRP1660 | STATE | T5UPBSDSSTATE | STATE | |||
16 | HRP1660 | SUSTS | T5UPBSPA10 | SUSTS | KEY | 1 | CN |
History
Last changed by/on | SAP | 20050219 |
SAP Release Created in | 470 |