/MRSS/D_DEM_ADM SAP (Administrative Demand Item Data) Table details

Dictionary Type: Table
Description: Administrative Demand Item Data




ABAP Code to SELECT data from /MRSS/D_DEM_ADM
Related tables to /MRSS/D_DEM_ADM
Access table /MRSS/D_DEM_ADM




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

/MRSS/D_DEM_ADM is a standard SAP Table which is used to store Administrative Demand Item Data data and is available within R/3 SAP systems depending on the version and release level.

The /MRSS/D_DEM_ADM table consists of various fields, each holding specific information or linking keys about Administrative Demand Item Data data available in SAP. These include CLIENT (Client), GUID (GUID), PARENT (GUID), HEADER (GUID).. 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 /MRSS/D_DEM_ADM 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
CLIENTClient MANDTCLNT3Assigned to domainMANDT
GUIDGUID /MRSS/T_GUIDRAW16SYSUUID
PARENTGUID /MRSS/T_GUIDRAW16SYSUUID
HEADERGUID /MRSS/T_GUIDRAW16SYSUUID
DEM_TYPE_IDemand Item Category /MRSS/T_DEM_TYPE_ICHAR4
IDDemand Item ID /MRSS/T_DEM_I_IDCHAR25CHAR25
SUBIDSub ID of Demand Item /MRSS/T_DEM_I_SUBIDCHAR4CHAR4
DESCRIPTIONDescription of Demand Item /MRSS/T_DEM_I_DESCRIPTIONCHAR40TEXT40
DISPO_FLGRelevancy for Resource Planning /MRSS/T_DISPO_FLGCHAR1/MRSS/_BOOLEAN
CAPA_FLGRelevance for Capacity Planning /MRSS/T_SGE_CAPA_FLGCHAR1/MRSS/_BOOLEAN
STAT_COMPLIndicate Demand as Completed (Reversible) /MRSS/T_DEM_STAT_COMPLCHAR1/MRSS/_BOOLEAN
STAT_COMPL_FINALIndicate Demand as Completed (Not Reversible) /MRSS/T_DEM_STAT_COMPL_FINALCHAR1/MRSS/_BOOLEAN
IS_COPY_FROMGUID /MRSS/T_GUIDRAW16SYSUUID
IS_SPLIT_FROMGUID /MRSS/T_GUIDRAW16SYSUUID
ORIG_ITEM_TYPEDemand Item Category /MRSS/T_DEM_TYPE_ICHAR4
HAS_SUCCESSORBoolean Variable /MRSS/T_BOOLEANCHAR1/MRSS/_BOOLEAN
DEMAND_ORIGINSource System of Demand /MRSS/T_DEM_LOGSYSCHAR10Assigned to domainALPHALOGSYS
WORKCENTER_IDWork center ID of operation or item /MRSS/T_DEM_WORKCENTER_IDNUMC8NUM08
WORKCENTER_TYPEWork center type of operation or item /MRSS/T_DEM_WORKCENTER_TYPECHAR2/MRSS/_SGE_CR_OBJTY
WORKCENTER_PLANTPlant of Work Center /MRSS/T_DEM_WORKCENTER_PLANTCHAR4Assigned to domainWERKS
WORKCENTER_GUIDGUID of Planning Node /MRSS/T_NODE_GUIDRAW16SYSUUID
ORGUNIT_GUIDGUID of Planning Node /MRSS/T_NODE_GUIDRAW16SYSUUID
CREATED_BYCreated By /MRSS/T_DEM_CREATED_BYCHAR12USNAM
CREATED_ATUTC Time Stamp in Short Form (YYYYMMDDhhmmss) TIMESTAMPDEC15TZNTSTMPS
CHANGED_BYLast Changed By /MRSS/T_DEM_CHANGED_BYCHAR12USNAM
CHANGED_ATUTC Time Stamp in Short Form (YYYYMMDDhhmmss) TIMESTAMPDEC15TZNTSTMPS

Key field Non-key field



How do I retrieve data from SAP table /MRSS/D_DEM_ADM using ABAP code

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

SELECT SINGLE *
FROM /MRSS/D_DEM_ADM
INTO CORRESPONDING FIELDS OF WA_/MRSS/D_DEM_ADM
WHERE...

How to access SAP table /MRSS/D_DEM_ADM

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