P05T_JLO_DATA SAP (Data for Annual Wage Return) Table details

Dictionary Type: Table
Description: Data for Annual Wage Return




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




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

P05T_JLO_DATA is a standard SAP Table which is used to store Data for Annual Wage Return data and is available within R/3 SAP systems depending on the version and release level.

The P05T_JLO_DATA table consists of various fields, each holding specific information or linking keys about Data for Annual Wage Return data available in SAP. These include LHNR (Wage Return: Wage Tax Number), JAAR (Year of Annual Wage Return), DATAANVTV (Start Date), SEQNO (Wage Return: Sequence Number).. 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 P05T_JLO_DATA 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
LHNRWage Return: Wage Tax Number P05T_LHNRCHAR12CHAR12
JAARYear of Annual Wage Return P05T_JLO_YEARNUMC4GJAHRGJAHR
DATAANVTVStart Date BEGDADATS8DATUM
SEQNOWage Return: Sequence Number P05T_SEQNONUMC4NUMC4
PERNRPersonnel Number P_PERNRNUMC8PERNR
BEGDAIVStart Date BEGDADATS8DATUM
ENDDAIVEnd Date ENDDADATS8DATUM
AANDIVWage Return: Income Relationship Code P05T_AANDIVCHAR35TEXT35
SOFINRWage return: CSN/SoFi Number P05T_SOFINRNUMC9
SIGNMWage Return: Significant Part of Last Name P05T_SIGNMCHAR200TEXT200
GEBDATDate of Birth GBDATDATS8PDATEGBDAT
SRTIVWage Return: Income Relationship P05T_SRTIVCHAR2P05T_SRTIV
CDAARDWage Return: Type of Work Relationship Code P05T_CDAARDCHAR2T5N72P05_CAARD
CDINVLVPLInsurance Obligation Influence Code P05_CIVPLCHAR3T5N74P05_CIVPL
CDBEPTDWage Return: Open-Ended/Fixed-Term Contract Code P05T_CDBEPTDCHAR1P05T_CDBEPTD
FSINDFZWage Return: F & S Phase Categorization Code P05T_FSINDFZCHAR2T5N75P05_CFIFZ
CDAGHContribution Reduction Code P05T_CDAGHCHAR1P05T_CDAGH
INDLHKORTWage Return: Wage Tax Reduction Code P05T_INDLHKORTCHAR1P05_INDIC
GEBRAUTOWage Return: Reason for No Add.to Taxab.Income for Car Code P05T_GEBRAUTOCHAR1P05T_GEBRAUTO
LBTABWage Return: Employment Tax Table Code P05T_LBTABCHAR3CHAR3
INDWAOWage Return: 'WAO' Insured Code P05T_INDWAOCHAR1P05_INDIC
INDWWWage Return: 'WW' Insured Code P05T_INDWWCHAR1P05_INDIC
INDZWWage Return: 'ZW' Insured Code P05T_INDZWCHAR1P05_INDIC
CDZVWWage Return: 'Zvw' Insurance Situation Code P05T_CDZVWCHAR1P05_CDZVW
INDSA71Wage Return: Code P05T_INDICATORCHAR1P05_INDIC
INDSA72Wage Return: Code P05T_INDICATORCHAR1P05_INDIC
INDSA43Wage Return: Code P05T_INDICATORCHAR1P05_INDIC
INDSA03Wage Return: Code P05T_INDICATORCHAR1P05_INDIC
SECTSector P05_SECTCHAR3T5N15P05_SECT
RISGRPRisk Group Indicator P05_RISGRPCHAR2T5N13P05_RISGRP
LNLBPHAmount P05T_AMOUNTCURR15(2) P05T_AMOUNT
LNSVAmount P05T_AMOUNTCURR15(2) P05T_AMOUNT
LNTABBBAmount P05T_AMOUNTCURR15(2) P05T_AMOUNT
INGLBPHAmount P05T_AMOUNTCURR15(2) P05T_AMOUNT
PRWAOAOFAmount P05T_AMOUNTCURR15(2) P05T_AMOUNT
PRWAOAOKAmount P05T_AMOUNTCURR15(2) P05T_AMOUNT
PRAWFAmount P05T_AMOUNTCURR15(2) P05T_AMOUNT
PRWGFAmount P05T_AMOUNTCURR15(2) P05T_AMOUNT
PRUFOAmount P05T_AMOUNTCURR15(2) P05T_AMOUNT
BIJDRZVWAmount P05T_AMOUNTCURR15(2) P05T_AMOUNT
VERGZVWAmount P05T_AMOUNTCURR15(2) P05T_AMOUNT
WRDPRGEBRAUTAmount P05T_AMOUNTCURR15(2) P05T_AMOUNT
WRKNBIJDRAUTAmount P05T_AMOUNTCURR15(2) P05T_AMOUNT
LVLPREGAmount P05T_AMOUNTCURR15(2) P05T_AMOUNT
REISKAmount P05T_AMOUNTCURR15(2) P05T_AMOUNT
VERRARBKRTAmount P05T_AMOUNTCURR15(2) P05T_AMOUNT
BEDRZDAFTRAmount P05T_AMOUNTCURR15(2) P05T_AMOUNT
BEDRALINWWBAmount P05T_AMOUNTCURR15(2) P05T_AMOUNT
BEDRRCHTALAmount P05T_AMOUNTCURR15(2) P05T_AMOUNT
NUMIVIR Number P05T_NUMIVNUMC4NUM4
LVLPREGTOEGAmount P05T_AMOUNTCURR15(2) P05T_AMOUNT
INDPKAGHPremium Reduction Work Disability P05T_INDPKAGHCHAR1P05_INDIC
INDPKNAOWPremium Reduction Hiring Elderly Employee P05T_INDPKNAOWCHAR1P05_INDIC
INDPKIDOWPremium Reduction Employing Elderly Employee P05T_INDPKIDOWCHAR1P05_INDIC
INDPMAPMA (Ex-Social Benefits Recipient) P05T_INDPMACHAR1P05_INDIC
INDWORReduced Pay Old Regulation P05T_INDWORCHAR1P05_INDIC
PRLNWAOAOFAmount P05T_AMOUNTCURR15(2) P05T_AMOUNT
PRLNPRSECTFNDSAmount P05T_AMOUNTCURR15(2) P05T_AMOUNT
PRLNWAOAOKAmount P05T_AMOUNTCURR15(2) P05T_AMOUNT
PRLNAWFAmount P05T_AMOUNTCURR15(2) P05T_AMOUNT
PRLNUFOAmount P05T_AMOUNTCURR15(2) P05T_AMOUNT

Key field Non-key field



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

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

SELECT SINGLE *
FROM P05T_JLO_DATA
INTO CORRESPONDING FIELDS OF WA_P05T_JLO_DATA
WHERE...

How to access SAP table P05T_JLO_DATA

Within an ECC or HANA version of SAP you can also view further information about P05T_JLO_DATA 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!