P01W_DBAE SAP (Data Module: Statement of Earnings - Remuneration) Table details

Dictionary Type: Table
Description: Data Module: Statement of Earnings - Remuneration




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




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

P01W_DBAE is a standard SAP Table which is used to store Data Module: Statement of Earnings - Remuneration data and is available within R/3 SAP systems depending on the version and release level.

The P01W_DBAE table consists of various fields, each holding specific information or linking keys about Data Module: Statement of Earnings - Remuneration 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_DBAE 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 MANDTCLNT3Assigned to domainMANDT
PERNRPersonnel Number P01W_PERNRNUMC8Assigned to domainPERSNO
MSGIDHR: Notification Type P01W_MSGIDNUMC4PCAL_MSGID
DATUMKey Date P01W_DATUMDATS8DATS
MNRMessage Number P01W_MNRNUMC4NUMC04
KENNGIdentification P01W_KENNGCHAR4TEXT04
FRBTOGross Remuneration on First Day of Release from Work P01W_FRBTO_DNUMC8NUMC08
FRNTONet Remuneration, First Day of Release from Work P01W_FRNTO_DNUMC8NUMC08
ZABRTGross Remuneration P01W_ZABRT_DNUMC8NUMC08
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
AVMGGRemuneration Converted to Be Exempt from Contributions P01W_AVMGGNUMC8NUMC08
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
EINKVNon-Recurring Payments Liable to Contributions in HI P01W_EINKVNUMC8NUMC08
EINRVNon-Recurring Payments Liable to Contributions in PI P01W_EINRVNUMC8NUMC08
SBKNASpecial Feature / Federal Miners' Insurance P01W_SBKNANUMC8NUMC8
KESBGKey Figure See-BG P01W_KESBGNUMC4NUMC04
DHSBGAverage Pay See-BG P01W_DHSBGNUMC8NUMC08

Key field Non-key field



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

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

SELECT SINGLE *
FROM P01W_DBAE
INTO CORRESPONDING FIELDS OF WA_P01W_DBAE
WHERE...

How to access SAP table P01W_DBAE

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