RES47 SAP (Screen Fields for Detailed Price Display in Facts) Structure details
Description: Screen Fields for Detailed Price Display in Facts
Structure field list including key, data, relationships and ABAP select examples
RES47 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 "Screen Fields for Detailed Price Display in Facts" 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_RES47 TYPE RES47.
The RES47 table consists of various fields, each holding specific information or linking keys about Screen Fields for Detailed Price Display in Facts data available in SAP. These include TWAERS (Transaction Currency), PREIS (Price), PREISTYP (Price category), PREISTUF (Price level).. 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 RES47 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 |
MANDT | Client | MANDT | CLNT | 3 | Assigned to domain | MANDT | |||
TWAERS | Transaction Currency | TWAERS | CUKY | 5 | Assigned to domain | WAERS | PCU | ||
PREIS | Price | E_PREIS | CHAR | 10 | Assigned to domain | ALPHA | E_PREIS | PRX | ISU_F4_PREIS |
PREISTYP | Price category | PREISTYP | CHAR | 1 | PREISTYP | PRY | |||
PREISTUF | Price level | PREISTUF | CHAR | 10 | Assigned to domain | PREISTUF | PRZ | ||
FROMDATE | Date from which time slice is valid | ABZEITSCH | DATS | 8 | DATUM | ||||
TODATE | Date at Which a Time Slice Expires | BISZEITSCH | DATS | 8 | DATUM | ||||
BISDATUM | Date at Which a Time Slice Expires | BISZEITSCH | DATS | 8 | DATUM | ||||
VONZONE | From-block | VONZONE | NUMC | 10 | E_ZONE | ||||
BISZONE | To-block | BISZONE | NUMC | 10 | E_ZONE | ||||
ABDATUM | Date from which time slice is valid | ABZEITSCH | DATS | 8 | DATUM | ||||
PREISBTR | Price amount | PRSBTR | DEC | 17(8) | PRSBTR | ||||
MNGBASIS | Long quantity base for amount | MENGENBAS | DEC | 9(2) | MENGENBAS | ||||
ADJPRICE | Adjusted price | ADJPRICE | DEC | 17(8) | PRSBTR | ||||
PREIGKL | Price adjustment clause | PREIGKL | CHAR | 10 | Assigned to domain | PREIGKL | PAC | ||
KTEXT | Short text | KTEXT_CURT | CHAR | 15 | TEXT15 | ||||
MARK | Mark flag for navigation and Mark table | MRK | CHAR | 1 | MARK | ||||
RUNDART | Rounding Category | RUNDART | CHAR | 1 | RUNDART | ||||
RUNDUNG | Starting Point for Rounding | E_RUNDUNG | CHAR | 2 | E_RUNDUNG |
Key field | Non-key field |
How do I retrieve data from SAP structure RES47 using ABAP code?
As RES47 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 RES47 as there is no data to select.How to access SAP table RES47
Within an ECC or HANA version of SAP you can also view further information about RES47 and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects