PA0016
HR Master Record: Infotype 0016 (Contract Elements)
PA0016 is an SAP database table in S/4HANA. HR Master Record: Infotype 0016 (Contract Elements). It contains 47 fields. 2 CDS views read from this table.
CDS Views using this table (2)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| E_HCMContractElement | view_entity | from | EXTENSION | Contract Element - Extension |
| I_HCMContractElement | view_entity | from | BASIC | HCM Contract Element |
Fields (47)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | MANDT | Client | |||
| KEY | pernr | PERSNO | Personnel No. | |||
| KEY | subty | SUBTY | Subtype | |||
| KEY | objps | OBJPS | Object ID | |||
| KEY | sprps | SPRPS | Lock indicator | |||
| KEY | endda | ENDDA | End Date | |||
| KEY | begda | BEGDA | Start Date | |||
| KEY | seqnr | SEQNR | IT record no. | |||
| aedtm | AEDAT | Changed On | ||||
| uname | AENAM | Changed By | ||||
| histo | HISTO | Historical rec. | ||||
| itxex | ITXEX | Text exists | ||||
| refex | PRFEX | Ref. exists | ||||
| ordex | ORDEX | Conf.fields ex. | ||||
| itbld | ITBLD | Screen control | ||||
| preas | PREAS | Change Reason | ||||
| flag1 | NUSED | Reserved Field/Unused Field | ||||
| flag2 | NUSED | Reserved Field/Unused Field | ||||
| flag3 | NUSED | Reserved Field/Unused Field | ||||
| flag4 | NUSED | Reserved Field/Unused Field | ||||
| rese1 | NUSED2 | Reserved Field/Unused Field of Length 2 | ||||
| rese2 | NUSED2 | Reserved Field/Unused Field of Length 2 | ||||
| grpvl | PCCE_GPVAL | Grouping Value | ||||
| nbtgk | NBTGK | Sideline Job | ||||
| wttkl | WTTKL | Competition Clause | ||||
| lfzfr | LFZFR | Continued Pay | ||||
| lfzzh | LFZZH | Continued Pay | ||||
| lfzso | LFZSR | Special Rule | ||||
| kgzfr | KGZFR | Sick Pay | ||||
| kgzzh | KGZZH | Sick Pay Supplement Period (Unit) | ||||
| prbzt | PRBZT | Prob.Period | ||||
| prbeh | PRBEH | Probationary Period (Unit) | ||||
| kdgfr | KDGFR | ER Notice Period | ||||
| kdgf2 | KDGF2 | EE Notice Period | ||||
| arber | ARBER | Work Permit | ||||
| eindt | EINTR | Initial Entry | ||||
| kondt | KONDT | Entry into Group | ||||
| konsl | KOSL1 | Group Key | ||||
| cttyp | CTTYP | Contract Type | ||||
| ctedt | CTEDT | Valid Until | ||||
| persg | PERSG | EE group | ||||
| persk | PERSK | EE subgroup | ||||
| wrkpl | WRKPL | Wrk Locat. | ||||
| ctbeg | CTBEG | Contract Start | ||||
| ctnum | PCN_CTNUM | Contract no | ||||
| objnb | OBJNB | Object Number | ||||
| p0016_ei_dummy | DUMMY | Dummy function in length 1 |
Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.
-- HR Master Record: Infotype 0016 (Contract Elements)
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PA0016 (
MANDT, -- Client [MANDT]
PERNR, -- Personnel No. [PERSNO]
SUBTY, -- Subtype [SUBTY]
OBJPS, -- Object ID [OBJPS]
SPRPS, -- Lock indicator [SPRPS]
ENDDA, -- End Date [ENDDA]
BEGDA, -- Start Date [BEGDA]
SEQNR, -- IT record no. [SEQNR]
AEDTM, -- Changed On [AEDAT]
UNAME, -- Changed By [AENAM]
HISTO, -- Historical rec. [HISTO]
ITXEX, -- Text exists [ITXEX]
REFEX, -- Ref. exists [PRFEX]
ORDEX, -- Conf.fields ex. [ORDEX]
ITBLD, -- Screen control [ITBLD]
PREAS, -- Change Reason [PREAS]
FLAG1, -- Reserved Field/Unused Field [NUSED]
FLAG2, -- Reserved Field/Unused Field [NUSED]
FLAG3, -- Reserved Field/Unused Field [NUSED]
FLAG4, -- Reserved Field/Unused Field [NUSED]
RESE1, -- Reserved Field/Unused Field of Length 2 [NUSED2]
RESE2, -- Reserved Field/Unused Field of Length 2 [NUSED2]
GRPVL, -- Grouping Value [PCCE_GPVAL]
NBTGK, -- Sideline Job [NBTGK]
WTTKL, -- Competition Clause [WTTKL]
LFZFR, -- Continued Pay [LFZFR]
LFZZH, -- Continued Pay [LFZZH]
LFZSO, -- Special Rule [LFZSR]
KGZFR, -- Sick Pay [KGZFR]
KGZZH, -- Sick Pay Supplement Period (Unit) [KGZZH]
PRBZT, -- Prob.Period [PRBZT]
PRBEH, -- Probationary Period (Unit) [PRBEH]
KDGFR, -- ER Notice Period [KDGFR]
KDGF2, -- EE Notice Period [KDGF2]
ARBER, -- Work Permit [ARBER]
EINDT, -- Initial Entry [EINTR]
KONDT, -- Entry into Group [KONDT]
KONSL, -- Group Key [KOSL1]
CTTYP, -- Contract Type [CTTYP]
CTEDT, -- Valid Until [CTEDT]
PERSG, -- EE group [PERSG]
PERSK, -- EE subgroup [PERSK]
WRKPL, -- Wrk Locat. [WRKPL]
CTBEG, -- Contract Start [CTBEG]
CTNUM, -- Contract no [PCN_CTNUM]
OBJNB, -- Object Number [OBJNB]
P0016_EI_DUMMY, -- Dummy function in length 1 [DUMMY]
PRIMARY KEY (MANDT, PERNR, SUBTY, OBJPS, SPRPS, ENDDA, BEGDA, SEQNR)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA