P01W_DBKR SAP (Data Module: Remuneration Statement for Sick Pay) Table details

Dictionary Type: Table
Description: Data Module: Remuneration Statement for Sick Pay




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




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

P01W_DBKR is a standard SAP Table which is used to store Data Module: Remuneration Statement for Sick Pay data and is available within R/3 SAP systems depending on the version and release level.

The P01W_DBKR table consists of various fields, each holding specific information or linking keys about Data Module: Remuneration Statement for Sick Pay data available in SAP. These include PERNR (Personnel Number), MSGID (HR: Notification Type), DATUM (Key Date), MNR (Message 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: Cannot Be Enhanced


SAP P01W_DBKR 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 P01W_PERNRNUMC8Assigned to domainPERSNO
MSGIDHR: Notification Type P01W_MSGIDNUMC4PCAL_MSGID
DATUMKey Date P01W_DATUMDATS8DATS
MNRMessage Number P01W_MNRNUMC4NUMC04
KENNGIdentification P01W_KENNGCHAR4TEXT04
KNZSTReversal Indicator P01W_KNZSTCHAR1TEXT1
ABBEGUnable to Work/Rehabilitation Since P01W_ABBEGNUMC8NUMC08
WAERSCurrency P01W_WAERS_DCHAR3TEXT3
STELLEmployed as P01W_STELLCHAR20TEXT20
ENTRYEmployed Since P01W_ENTRYNUMC8NUMC08
FLEDTParticipation in Working Time Model Since/From P01W_FLEDTNUMC8NUMC08
KISTAChurch Tax P01W_KISTACHAR1TEXT1
STRKLEmployment Tax Class P01W_STRKLNUMC1NUMC01
FRB1MMonthly Tax-Free Amount P01W_FRB1MNUMC8NUMC08
FRBDTTax-Free Amount From P01W_FRBDTNUMC8NUMC08
LADAYLast Working Day P01W_LADAYNUMC8NUMC08
FIDAYReturn to Work P01W_FIDAYNUMC8NUMC08
KUWAGRHC/WC P01W_KUWAGNUMC1NUMC01
KUWADRHC/WC Since P01W_KUWADNUMC8NUMC08
WVLDTWinter Compensation Advance Benefit Since P01W_WVLDT_DNUMC8NUMC08
WALAZWC Advance Payment in (Last) Remuneration Period P01W_WALAZ_DCHAR1CHAR01
STWAGNo. of Hours for Which Winter Compensation Advance Was Paid P01W_STWAG_DNUMC5NUMC05
LFZEDContd Pay During WI/Rehab. Benefit or Release from Work To P01W_LFZEDNUMC8NUMC08
VBEG1Previous Illness: Period Start P01W_VOBEGNUMC8NUMC08
VEND1Previous Illness: Period End P01W_VOENDNUMC8NUMC08
VBEG2Previous Illness: Period Start P01W_VOBEGNUMC8NUMC08
VEND2Previous Illness: Period End P01W_VOENDNUMC8NUMC08
EFZGDContinued Pay <= 6 Weeks: Reasons P01W_EFZGDCHAR30TEXT30
AEBISAdditional Remuneration Until P01W_AEBIS_DNUMC8NUMC08
ZABRTGross Remuneration P01W_ZABRT_DNUMC8NUMC08
ZANTONet Remuneration P01W_ZANTO_DNUMC8NUMC08
ZLRHTPayment Type P01W_ZLRHT_DNUMC1NUMC01
VWBETCapital Formation Savings Payment P01W_VWBET_DNUMC8NUMC08
VWBISCapital Formation Savings Payments To P01W_VWBIS_DNUMC8NUMC08
VWRHTPayment Type for Capital Formation Savings Payments P01W_VWRHT_DNUMC1NUMC01
ZSBTGAmount of Payments in Kind P01W_ZSBTG_DNUMC8NUMC08
LBEG1Wage Compensation in Building Sector: Start of Period P01W_LABEG_DNUMC8NUMC08
LEND1Wage Compensation in Building Sector: End of Period P01W_LAEND_DNUMC8NUMC08
LBEG2Wage Compensation in Building Sector: Start of Period P01W_LABEG_DNUMC8NUMC08
LEND2Wage Compensation in Building Sector: End of Period P01W_LAEND_DNUMC8NUMC08
RVBEFWaiver of Pension Insurance Exemption P01W_RVBEFCHAR1CHAR01
KDZUMDissolution of Work Relationship on P01W_KDZUM_DNUMC8NUMC08
KDGAMDissolution of Work Relationship on P01W_KDGAM_DNUMC8NUMC08
KDGRDTermination Reason P01W_KDGRDCHAR30TEXT30
LRBEGLast Remuneration Period in Payroll Run: Start P01W_LRBEGNUMC8NUMC08
LRENDLast Remuneration Period in Payroll Run: End P01W_LRENDNUMC8NUMC08
LRBRTGross Remuneration P01W_LRBRTNUMC8NUMC08
LRNETNet Remuneration P01W_LRNETNUMC8NUMC08
ABARTFixed Monthly Salary/Monthly Remuneration P01W_ABARTCHAR1CHAR01
VRBRTAgreed Gross Remuneration P01W_VRBRTNUMC8NUMC08
VRNETAgreed Net Remuneration P01W_VRNETNUMC8NUMC08
UBEG1Gross Remuneration Differs from Regular: Period Start P01W_UNBEGNUMC8NUMC08
UEND1Gross Remuneration Differs from Regular: Period End P01W_UNENDNUMC8NUMC08
UBRT1Gross Remuneration Differs from Regular: Gross Remuneration P01W_UNBRTNUMC8NUMC08
UNET1Gross Remuneration Differs from Regular: Net Remuneration P01W_UNNETNUMC8NUMC08
UBEG2Gross Remuneration Differs from Regular: Period Start P01W_UNBEGNUMC8NUMC08
UEND2Gross Remuneration Differs from Regular: Period End P01W_UNENDNUMC8NUMC08
UBRT2Gross Remuneration Differs from Regular: Gross Remuneration P01W_UNBRTNUMC8NUMC08
UNET2Gross Remuneration Differs from Regular: Net Remuneration P01W_UNNETNUMC8NUMC08
UBEG3Gross Remuneration Differs from Regular: Period Start P01W_UNBEGNUMC8NUMC08
UEND3Gross Remuneration Differs from Regular: Period End P01W_UNENDNUMC8NUMC08
UBRT3Gross Remuneration Differs from Regular: Gross Remuneration P01W_UNBRTNUMC8NUMC08
UNET3Gross Remuneration Differs from Regular: Net Remuneration P01W_UNNETNUMC8NUMC08
XBEG1Irregular Remuneration: Start of Period P01W_XXBEGNUMC8NUMC08
XEND1Irregular Remuneration: End of Period P01W_XXENDNUMC8NUMC08
XBRT1Irregular Remuneration: Gross Remuneration P01W_XXBRTNUMC8NUMC08
XNET1Irregular Remuneration: Net Remuneration P01W_XXNETNUMC8NUMC08
XBEG2Irregular Remuneration: Start of Period P01W_XXBEGNUMC8NUMC08
XEND2Irregular Remuneration: End of Period P01W_XXENDNUMC8NUMC08
XBRT2Irregular Remuneration: Gross Remuneration P01W_XXBRTNUMC8NUMC08
XNET2Irregular Remuneration: Net Remuneration P01W_XXNETNUMC8NUMC08
XBEG3Irregular Remuneration: Start of Period P01W_XXBEGNUMC8NUMC08
XEND3Irregular Remuneration: End of Period P01W_XXENDNUMC8NUMC08
XBRT3Irregular Remuneration: Gross Remuneration P01W_XXBRTNUMC8NUMC08
XNET3Irregular Remuneration: Net Remuneration P01W_XXNETNUMC8NUMC08
EINKVNon-Recurring Payments Liable to Contributions in HI P01W_EINKVNUMC8NUMC08
EINRVNon-Recurring Payments Liable to Contributions in PI P01W_EINRVNUMC8NUMC08
ANSTDNumber of Hours in Which Gross Remuneration Was Earned P01W_ANSTDNUMC5NUMC05
WOSTDRegular Weekly Working Time P01W_WOSTDNUMC4NUMC04
MBEG1Overtime Hours: Period Start P01W_MEBEGNUMC8NUMC08
MEND1Overtime Hours: Period End P01W_MEENDNUMC8NUMC08
MSTD1Hours of Overtime P01W_MESTDNUMC5NUMC05
MBEG2Overtime Hours: Period Start P01W_MEBEGNUMC8NUMC08
MEND2Overtime Hours: Period End P01W_MEENDNUMC8NUMC08
MSTD2Hours of Overtime P01W_MESTDNUMC5NUMC05
MBEG3Overtime Hours: Period Start P01W_MEBEGNUMC8NUMC08
MEND3Overtime Hours: Period End P01W_MEENDNUMC8NUMC08
MSTD3Hours of Overtime P01W_MESTDNUMC5NUMC05
FBEG1Absence Times Without Remuneration: Start of Period P01W_FLBEGNUMC8NUMC08
FEND1Absence Times Without Remuneration: End of Period P01W_FLENDNUMC8NUMC08
FTAG1Absence Times Without Remuneration: No. of Days P01W_FLTAGNUMC2NUMC02
FBEG2Absence Times Without Remuneration: Start of Period P01W_FLBEGNUMC8NUMC08
FEND2Absence Times Without Remuneration: End of Period P01W_FLENDNUMC8NUMC08
FTAG2Absence Times Without Remuneration: No. of Days P01W_FLTAGNUMC2NUMC02
FBEG3Absence Times Without Remuneration: Start of Period P01W_FLBEGNUMC8NUMC08
FEND3Absence Times Without Remuneration: End of Period P01W_FLENDNUMC8NUMC08
FTAG3Absence Times Without Remuneration: No. of Days P01W_FLTAGNUMC2NUMC02
UFTAGAccident Date P01W_UFTAGNUMC8NUMC08
UVTRGName of Accident Insurance Institution P01W_UVTRGCHAR30TEXT30
LSTFZEmployment Tax-Free Bonuses in Last Remuneration Payt Period P01W_LSTFZNUMC8NUMC08
LSTB1Bonuses Exempt from Employment Tax: Start of Period P01W_LSTBGNUMC8NUMC08
LSTE1Bonuses Exempt from Employment Tax: End of Period P01W_LSTEDNUMC8NUMC08
LSTZ1Pymt Exempt fr. Empl. Tax P01W_LSTZUNUMC8NUMC08
LSTB2Bonuses Exempt from Employment Tax: Start of Period P01W_LSTBGNUMC8NUMC08
LSTE2Bonuses Exempt from Employment Tax: End of Period P01W_LSTEDNUMC8NUMC08
LSTZ2Pymt Exempt fr. Empl. Tax P01W_LSTZUNUMC8NUMC08
LSTB3Bonuses Exempt from Employment Tax: Start of Period P01W_LSTBGNUMC8NUMC08
LSTE3Bonuses Exempt from Employment Tax: End of Period P01W_LSTEDNUMC8NUMC08
LSTZ3Pymt Exempt fr. Empl. Tax P01W_LSTZUNUMC8NUMC08
SBKNASpecial Feature / Federal Miners' Insurance P01W_SBKNANUMC8NUMC8
AVMGGRemuneration Converted to Be Exempt from Contributions P01W_AVMGGNUMC8NUMC08

Key field Non-key field



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

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

SELECT SINGLE *
FROM P01W_DBKR
INTO CORRESPONDING FIELDS OF WA_P01W_DBKR
WHERE...

How to access SAP table P01W_DBKR

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