PA0335
HR Master Data: Infotype 0335 (infotype 21 view - PT)
PA0335 is an SAP database table in S/4HANA. HR Master Data: Infotype 0335 (infotype 21 view - PT). It contains 46 fields. 2 CDS views read from this table.
CDS Views using this table (2)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| E_PT_HCMFamilyMemberSupplement | view_entity | from | EXTENSION | PT HCM Family Member - Extension |
| I_PT_HCMFamilyMemberSupplement | view_entity | from | BASIC | HCM Family Member Supplement PT |
Fields (46)
| 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 | ||||
| fulna | PPT_FULNA | Full name | ||||
| finum | PPT_FINUM | Tax no. | ||||
| ssnum | PPT_SSNUM | SS no. | ||||
| ssins | PPT_SSINS2 | SS institution | ||||
| relco | PPT_RELCO | Rel.with company | ||||
| dadea | PPT_DADEA | Date of death | ||||
| famal | PPT_FAMAL | Family allow. | ||||
| disbo | PPT_DISBO | Challenge bonus | ||||
| spcer | PPT_SPCER | Registr.subm. | ||||
| llmbn | PPT_LLMBN | Month.living all. | ||||
| ssa3p | PPT_SSA3P | Entitl.nurs.all. | ||||
| benef | PPT_NUBEN | ADSE beneficiary | ||||
| certa | PPT_CERTA | Registr.valid to | ||||
| spben | PPT_SALOW | Scholarship | ||||
| vadse | PPT_VADSE | ADSE card validity | ||||
| nsers | PPT_NSERS | Social services no. | ||||
| pcdef | PPT_PCDEF | Disability % | ||||
| cerdt | PPTP_CVALD | Reg.subm.date | ||||
| bfa_alwtp | HRPAYPT_BFA_ALWT | Allowance type | ||||
| bfa_grade | HRPAYPT_BFA_GRD | Education level | ||||
| bfa_valdt | HRPAYPT_BFA_VALD | Valid.school certif. | ||||
| bfa_pares | HRPAYPT_BFA_PRES | Parental resp. | ||||
| bfa_fpaym | HRPAYPT_BFA_FPAY | Force payment |
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 Data: Infotype 0335 (infotype 21 view - PT)
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PA0335 (
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]
FULNA, -- Full name [PPT_FULNA]
FINUM, -- Tax no. [PPT_FINUM]
SSNUM, -- SS no. [PPT_SSNUM]
SSINS, -- SS institution [PPT_SSINS2]
RELCO, -- Rel.with company [PPT_RELCO]
DADEA, -- Date of death [PPT_DADEA]
FAMAL, -- Family allow. [PPT_FAMAL]
DISBO, -- Challenge bonus [PPT_DISBO]
SPCER, -- Registr.subm. [PPT_SPCER]
LLMBN, -- Month.living all. [PPT_LLMBN]
SSA3P, -- Entitl.nurs.all. [PPT_SSA3P]
BENEF, -- ADSE beneficiary [PPT_NUBEN]
CERTA, -- Registr.valid to [PPT_CERTA]
SPBEN, -- Scholarship [PPT_SALOW]
VADSE, -- ADSE card validity [PPT_VADSE]
NSERS, -- Social services no. [PPT_NSERS]
PCDEF, -- Disability % [PPT_PCDEF]
CERDT, -- Reg.subm.date [PPTP_CVALD]
BFA_ALWTP, -- Allowance type [HRPAYPT_BFA_ALWT]
BFA_GRADE, -- Education level [HRPAYPT_BFA_GRD]
BFA_VALDT, -- Valid.school certif. [HRPAYPT_BFA_VALD]
BFA_PARES, -- Parental resp. [HRPAYPT_BFA_PRES]
BFA_FPAYM, -- Force payment [HRPAYPT_BFA_FPAY]
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