PA0038 SAP (HR Master Record: Infotype 0038 (Fiscal Data CH)) Table details

Dictionary Type: Table
Description: HR Master Record: Infotype 0038 (Fiscal Data CH)




ABAP Code to SELECT data from PA0038
Related tables to PA0038
Access table PA0038




Table field list including key, data, relationships and ABAP select examples

PA0038 is a standard SAP Table which is used to store HR Master Record: Infotype 0038 (Fiscal Data CH) data and is available within R/3 SAP systems depending on the version and release level.

The PA0038 table consists of various fields, each holding specific information or linking keys about HR Master Record: Infotype 0038 (Fiscal Data CH) data available in SAP. These include PERNR (Personnel number), SUBTY (Subtype), OBJPS (Object Identification), SPRPS (Lock Indicator for HR Master Data Record).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP PA0038 table fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3T000MANDT
PERNRPersonnel number PERSNONUMC8PA0003PERSNOPER
SUBTYSubtype SUBTYCHAR4SUBTYSUB
OBJPSObject Identification OBJPSCHAR2OBJPSOPS
SPRPSLock Indicator for HR Master Data Record SPRPSCHAR1SPRPS
ENDDAEnd Date ENDDADATS8DATUM
BEGDAStart Date BEGDADATS8DATUM
SEQNRNumber of Infotype Record with Same Key SEQNRNUMC3NUM03
AEDTMChanged On AEDATDATS8DATUM
UNAMEName of Person Who Changed Object AENAMCHAR12USNAM
HISTOHistorical Record Flag HISTOCHAR1CHAR1
ITXEXText Exists for Infotype ITXEXCHAR1XFELD
REFEXReference Fields Exist (Primary/Secondary Costs) PRFEXCHAR1XFELD
ORDEXConfirmation Fields Exist ORDEXCHAR1XFELD
ITBLDInfotype Screen Control ITBLDCHAR2CHAR2
PREASReason for Changing Master Data PREASCHAR2T530EPREAS
FLAG1Reserved Field/Unused Field NUSEDCHAR1NUSED
FLAG2Reserved Field/Unused Field NUSEDCHAR1NUSED
FLAG3Reserved Field/Unused Field NUSEDCHAR1NUSED
FLAG4Reserved Field/Unused Field NUSEDCHAR1NUSED
RESE1Reserved Field/Unused Field of Length 2 NUSED2CHAR2NUSED2
RESE2Reserved Field/Unused Field of Length 2 NUSED2CHAR2NUSED2
GRPVLGrouping Value for Personnel Assignments PCCE_GPVALCHAR4PCCE_GPVAL
KANTOCanton Indicator KANTOCHAR2CHAR2
GEMNDMunicipality GEMNDCHAR4T5C1OGEMND
QSTPFTax liability QSTPFCHAR1Assigned to domainP02_QSTPF
LAUWGFlat-rate cost reimbursement P02_LAUWGCHAR1P02_LAUWG
ARBORWork location P02_ARBORCHAR25TEXT25
BEMZ1Comments: Line 1 (LAW Switz.) HRCHBEMZ1CHAR100TEXT100
BEMZ2Remarks: line 2 (LAW Switz.) HRCHBEMZ2CHAR100TEXT100
BEMZ3Comments: Line 3 (LAW Switz.) HRCHBEMZ3CHAR100TEXT100
QSTABWithholding Tax Scale P02_CQTABCHAR6T5C2KP02_CQTAB
QSPROWithholding Tax Percentage QSPRODEC5(2) DEC3_2
QSBTRWithholding tax amount QSBTRCURR9(2) WERT5
ACL01HR-CH: EE Attributes Class P02_ACLASCHAR2T5CAPP02_ACLAS
EMA01HR-CH: EE Attribute P02_ATTRINUMC2T5CA0P02_ATTRI
ACL02HR-CH: EE Attributes Class P02_ACLASCHAR2T5CAPP02_ACLAS
EMA02HR-CH: EE Attribute P02_ATTRINUMC2T5CA0P02_ATTRI
ACL03HR-CH: EE Attributes Class P02_ACLASCHAR2T5CAPP02_ACLAS
EMA03HR-CH: EE Attribute P02_ATTRINUMC2T5CA0P02_ATTRI
ACL04HR-CH: EE Attributes Class P02_ACLASCHAR2T5CAPP02_ACLAS
EMA04HR-CH: EE Attribute P02_ATTRINUMC2T5CA0P02_ATTRI
ACL05HR-CH: EE Attributes Class P02_ACLASCHAR2T5CAPP02_ACLAS
EMA05HR-CH: EE Attribute P02_ATTRINUMC2T5CA0P02_ATTRI
ACL06HR-CH: EE Attributes Class P02_ACLASCHAR2T5CAPP02_ACLAS
EMA06HR-CH: EE Attribute P02_ATTRINUMC2T5CA0P02_ATTRI
ACL07HR-CH: EE Attributes Class P02_ACLASCHAR2T5CAPP02_ACLAS
EMA07HR-CH: EE Attribute P02_ATTRINUMC2T5CA0P02_ATTRI
ACL08HR-CH: EE Attributes Class P02_ACLASCHAR2T5CAPP02_ACLAS
EMA08HR-CH: EE Attribute P02_ATTRINUMC2T5CA0P02_ATTRI
WGMGEMunicip. Code in WHT Statement for Residences in Canton GE P02_GETIS_WGMGENUMC2T5C2P_LOCCDP02_GETIS_LOCCD
AGMGEMunicipal. Code in WHT Statement for Work Place in Canton GE P02_GETIS_ARB_0038NUMC2T5C2P_LOCCDP02_GETIS_LOCCD
NMSRCEmployee's WHT Number P02_NMSRCCHAR20P02_NMSRC
AKANTCanton of Place of Work P02_AKANTCHAR2P02_AKANT

Key field Non-key field



How do I retrieve data from SAP table PA0038 using ABAP code

The following ABAP code Example will allow you to do a basic selection on PA0038 to SELECT all data from the table
DATA: WA_PA0038 TYPE PA0038.

SELECT SINGLE *
FROM PA0038
INTO CORRESPONDING FIELDS OF WA_PA0038
WHERE...

How to access SAP table PA0038

Within an ECC or HANA version of SAP you can also view further information about PA0038 and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!