/1FB/MD___M80114 SAP (Netz: USMD_S_HRY_ATTR fuer Fin. Reporting Structure Item) Table details
Description: Netz: USMD_S_HRY_ATTR fuer Fin. Reporting Structure Item
Related tables to /1FB/MD___M80114
Access table /1FB/MD___M80114
Table field list including key, data, relationships and ABAP select examples
/1FB/MD___M80114 is a standard SAP Table which is used to store Netz: USMD_S_HRY_ATTR fuer Fin. Reporting Structure Item data and is available within R/3 SAP systems depending on the version and release level.
The /1FB/MD___M80114 table consists of various fields, each holding specific information or linking keys about Netz: USMD_S_HRY_ATTR fuer Fin. Reporting Structure Item data available in SAP. These include HRY_VERSION (Hierarchy version), FROMYEAR (Effective from Fiscal Year), FROMPERIOD (Effective from Period), PARENT_FIELDNAME (FIN Master Data: Field Name).. 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: C - Customising table, maintenance only by custDisplay/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced
SAP /1FB/MD___M80114 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 |
| MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
| HRY_VERSION | Hierarchy version | RSVERSION | CHAR | 3 | RSVERSION | ||||
| FROMYEAR | Effective from Fiscal Year | UG_FROMYEAR | NUMC | 4 | FYINV | UG_FISCYEAR_INV | |||
| FROMPERIOD | Effective from Period | UG_FROMPERIOD | NUMC | 3 | FPINV | UG_FISCPERIOD_INV | |||
| PARENT_FIELDNAME | FIN Master Data: Field Name | UG_FIELDNAME | CHAR | 30 | Assigned to domain | FDNAME | UG_FIELDNAME_BASIC | ||
| PARENT_VALUE | Characteristic Value | UG_VALUE | CHAR | 45 | UG_VALUE | ||||
| CHILD_FIELDNAME | FIN Master Data: Field Name | UG_FIELDNAME | CHAR | 30 | Assigned to domain | FDNAME | UG_FIELDNAME_BASIC | ||
| CHILD_VALUE | Characteristic Value | UG_VALUE | CHAR | 45 | UG_VALUE | ||||
| USMD_EDTN_NUMBER | Edition Number | USMD_EDITION_NUMBER | NUMC | 6 | USMD_EDITION_NUMBER | ||||
| USMD_ACTIVE | Active/Inactive Data Record | USMD_ACTIVE | CHAR | 1 | USMD_ACTIVE | ||||
| HRY_STRUCT_SID | FIN Master Data: Surrogate ID | UG_SID | INT4 | 10 | Assigned to domain | UG_SID | |||
| TOYEAR | Fiscal Year | UG_FISCYEAR | NUMC | 4 | GJAHR | GJAHR | |||
| TOPERIOD | Fiscal Period | UG_FISCPERIOD | NUMC | 3 | POPER | ||||
| PARENT_RVSID | FIN Master Data: Surrogate ID | UG_SID | INT4 | 10 | Assigned to domain | UG_SID | |||
| CHILD_RVSID | FIN Master Data: Surrogate ID | UG_SID | INT4 | 10 | Assigned to domain | UG_SID | |||
| USMD_OBSOLETE | Obsolete Data Record | USMD_OBSOLETE | CHAR | 1 | USMD_FLG | ||||
| USMD_HRY_SEQNR | Sequence Number of Child Node | USMD_HRY_SEQNR | INT4 | 10 | INT4 |
| Key field | Non-key field |
How do I retrieve data from SAP table /1FB/MD___M80114 using ABAP code
The following ABAP code Example will allow you to do a basic selection on /1FB/MD___M80114 to SELECT all data from the tableDATA: WA_/1FB/MD___M80114 TYPE /1FB/MD___M80114.
SELECT SINGLE *
FROM /1FB/MD___M80114
INTO CORRESPONDING FIELDS OF WA_/1FB/MD___M80114
WHERE...
How to access SAP table /1FB/MD___M80114
Within an ECC or HANA version of SAP you can also view further information about /1FB/MD___M80114 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