PPTS_MD_D_DMRAT3 SAP (DMR-AT.3 detail) Structure details

Dictionary Type: Structure
Description: DMR-AT.3 detail




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




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

PPTS_MD_D_DMRAT3 is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "DMR-AT.3 detail" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_PPTS_MD_D_DMRAT3 TYPE PPTS_MD_D_DMRAT3.

The PPTS_MD_D_DMRAT3 table consists of various fields, each holding specific information or linking keys about DMR-AT.3 detail data available in SAP. These include LNUM (Line number), NIFSP (Tax no.), ANTREND (Income from previous years - values), ANOREAN (Income from previous years - year).. 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:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced


SAP PPTS_MD_D_DMRAT3 structure 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
TREGAnnual income declaration - record type PPT_TSJRECHAR3TEXT3
LNUMLine number PPT_LNUM1NUMC7NUMC07
NIFSPTax no. PPT_FINUMCHAR9CHAR9
ANTRENDIncome from previous years - values PPT_ANRENCHAR14CHAR14
ANOREANIncome from previous years - year PPT_ANREANUMC4NUMC4
TOTRENDIncome from year PPT_TOREACHAR14CHAR14
TIPRENDAD - Income type PPT_ADIITCHAR3CHAR3
LOCRENDAID - Income origin PPT_ADLRECHAR2PPT_ADLRE
TOTREIRSIRS retention PPT_REIRSCHAR13CHAR13
COOBRVAMandatory contributions - values PPT_COBVACHAR13CHAR13
COOBRE1Mandatory contributions - entity 1 PPT_COBE1NUMC9NUM9
COOBRE2Mandatory contributions - entity 2 PPT_COBE2NUMC9NUM9
COOBRE3Mandatory contributions - entity 3 PPT_COBE3NUMC9NUM9
UNIDEDUnion quote arrangs. PPT_QUSINCHAR13CHAR13
SOBEXSurcharge retent. PPT_RESOBCHAR13CHAR13
PERNRPersonnel Number PERNR_DNUMC8PERNRPER

Key field Non-key field



How do I retrieve data from SAP structure PPTS_MD_D_DMRAT3 using ABAP code?

As PPTS_MD_D_DMRAT3 is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on PPTS_MD_D_DMRAT3 as there is no data to select.

How to access SAP table PPTS_MD_D_DMRAT3

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