/MRSS/D_DEM_INFO SAP (Informative Fields for Demand Items) Table details

Dictionary Type: Table
Description: Informative Fields for Demand Items




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




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

/MRSS/D_DEM_INFO is a standard SAP Table which is used to store Informative Fields for Demand Items data and is available within R/3 SAP systems depending on the version and release level.

The /MRSS/D_DEM_INFO table consists of various fields, each holding specific information or linking keys about Informative Fields for Demand Items data available in SAP. These include CLIENT (Client), GUID (GUID), PARTNER_NO (Business Partner Number), PRODUCT (Product Name Entered).. 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: Can be enhanced (character-type or numeric)


SAP /MRSS/D_DEM_INFO 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
PARTNER_NOBusiness Partner Number BU_PARTNERCHAR10Assigned to domainALPHABU_PARTNERBPABUPA
PRODUCTProduct Name Entered /MRSS/T_ORDERED_PRODCHAR54/MRSS/_ORDERED_PROD
KUNNRCustomer Number /MRSS/T_DEM_KUNNRCHAR10CHAR10
PROBABILITYDemand Probability /MRSS/T_DEM_PROBABILITYCHAR3ALPHA/MRSS/_DEM_PROBABILITY
SUPERVISORSite supervisor indicator of demand /MRSS/T_DEM_SUPERVISORCHAR1/MRSS/_DEM_SUPERVISOR
SUPERVISOR_NONumber of Site Supervisors for Demand /MRSS/T_DEM_SUPERVISOR_NONUMC3
FOUND_RESOURCESResources Found for Demand /MRSS/T_DEM_FOUND_RESOURCESCHAR200
AUTOMATIC_ASGNRelevant for automatic assignment creation /MRSS/T_DEM_AUTO_ASGNCHAR1/MRSS/_BOOLEAN
SCHED_INDICATORScheduling Indicator (Automatic Scheduling & Self Planning) /MRSS/T_SCHED_INDICATORCHAR1/MRSS/_SCHED_INDICATOR
SALES_ORGSales Org /MRSS/T_SALES_ORGCHAR4CHAR4
REQUESTER_EMAILE-Mail Address of Requester /MRSS/T_REQ_EMAILCHAR120TEXT120
REQUESTER_UNAMEUser Name of Requester /MRSS/T_REQ_UNAMECHAR12UNAME
REQUESTER_FNAMEName of Requester /MRSS/T_REQ_NAMECHAR132/MRSS/_SGD_FULL_NAME
REQUESTER_TLNUMTelephone Number of Requester /MRSS/T_REQ_TLNUMCHAR40CHAR40
DURATN_SRCDuration of Demand Source /MRSS/T_DURATION_SOURCEQUAN13(3) MENG13
DURATN_SRC_UNITUnit of Duration from Demand Source /MRSS/T_DURATION_SOURCE_UNITUNIT3Assigned to domainCUNITMEINS
TIME_CALC_CAPACalculation of Demand Duration Active /MRSS/T_SGE_TIME_CALC_CAPACHAR1XFELD
STATUS_GRP_IDID of status group /MRSS/T_STATUS_GROUP_IDCHAR10CHAR10
REF_GUID_HGUID /MRSS/T_GUIDRAW16SYSUUID
REF_GUID_IGUID /MRSS/T_GUIDRAW16SYSUUID
REF_EXT_IDProject Planning: External Identifier of an Element /MRSS/T_SGD_CGPL_EXTIDCHAR24/MRSS/_SGD_CGPL_EXTID
ACTIVITY_TYPEProcess Variant /MRSS/T_SGU_ACTIVITY_TYPECHAR1/MRSS/_SGU_ACTIVITY_TYPE
DUMMYSingle-Character Indicator CHAR1CHAR1CHAR1
RESOURCE_KEYGUID /MRSS/T_GUIDRAW16SYSUUID
APPT_EARL_STARTEarliest Start of the Appointment /MRSS/T_DEM_APPOINT_EARL_STARTDEC15TZNTSTMPS
APPT_LAT_STARTLatest Start of the Appointment /MRSS/T_DEM_APPOINT_LAT_STARTDEC15TZNTSTMPS
APPT_EARL_ENDEarliest End of the Appointment /MRSS/T_DEM_APPOINT_EARL_ENDDEC15TZNTSTMPS
APPT_LAT_ENDLatest End of the Appointment /MRSS/T_DEM_APPOINT_LAT_ENDDEC15TZNTSTMPS
.INCLU--AP 0

Key field Non-key field



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

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

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

How to access SAP table /MRSS/D_DEM_INFO

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