The EMDUSDRQITEM table in SAP ERP or S/4HANA stores Subrequest for Request data. There are total 28 fields in EMDUSDRQITEM table. The Subrequest for Request table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of EMDUSDRQITEM table. It is in MDUS Integration (EE_MDUS) ABAP package and is part of the Contract Billing (IS-U-BI) module.
SAP EMDUSDRQITEM Table Fields
Following is the list of fields that are available in SAP EMDUSDRQITEM table. The primary key fields of the table are MANDT (Client), MDUSREQUESTID (MDUS Request ID), RQITEMID (MDUS Request Item).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | * | CLNT (3) |
| MDUSREQUESTID | MDUS Request ID | E_MDUSREQUESTID | CHAR (22) | |
| RQITEMID | MDUS Request Item | E_MDUSREQUESTITEMID | NUMC (4) | |
| FORMULA | Time-of-Use Formula | E_MDUSFORM | * | CHAR (10) |
| MDUSID | Formula ID in MDUS | E_MDUSFORMID | NUMC (5) | |
| DATEFROM | Start Date | E_MDUSDATEFROM | DATS (8) | |
| TIMEFROM | Start Time | E_MDUSTIMEFROM | TIMS (6) | |
| DATETO | End Date | E_MDUSDATETO | DATS (8) | |
| TIMETO | End Time | E_MDUSTIMETO | TIMS (6) | |
| TOUFROM | Start of Time-of-Use Period | E_MDUSTOUFROM | TIMS (6) | |
| TOUTO | End of Time-of-Use Period | E_MDUSTOUTO | TIMS (6) | |
| REPLVALUE | Allow Replacement Values | E_MDUSREPLVALFLAG | CHAR (1) | |
| LOCKINDICATOR | Lock Indicator for MDUS | E_MDUSRQLOCKINDICATOR | CHAR (1) | |
| MONDAY | Monday | E_MDUSMONDAY | CHAR (1) | |
| TUESDAY | Tuesday | E_MDUSTUESDAY | CHAR (1) | |
| WEDNESDAY | Wednesday | E_MDUSWEDNESDAY | CHAR (1) | |
| THURSDAY | Thursday | E_MDUSTHURSDAY | CHAR (1) | |
| FRIDAY | Friday | E_MDUSFRIDAY | CHAR (1) | |
| SATURDAY | Saturday | E_MDUSSATURDAY | CHAR (1) | |
| SUNDAY | Sunday | E_MDUSSUNDAY | CHAR (1) | |
| TARIFNR | Rate key | TARIFNR | * | CHAR (10) |
| INTERFACE | Time-of-Use Interface | E_MDUSIFACE | EMDUSDIFACEHEAD | CHAR (10) |
| LOGIKZW | Logical register number | LOGIKZW | NUMC (18) | |
| RQASSIGN | Allocation of Request to Interface Level | E_MDUSRQASSIGN | NUMC (2) | |
| SEASON | Season type | E_SEASON | * | CHAR (10) |
| DAYGROUP | Day Group | E_MDUSDAYGRP | CHAR (10) | |
| PUBHOLIDAY | Public Holiday | E_MDUSPUBHOLFLAG | CHAR (1) | |
| EXDAY | Exception Day | E_MDUSEXDAYFLAG | CHAR (1) |
