/XFT/SRM_REC000 SAP (Generated Table for View) Table View details

Dictionary Type: Table View
Description: Generated Table for View




ABAP Code to SELECT data from /XFT/SRM_REC000
Related tables to /XFT/SRM_REC000
Access table /XFT/SRM_REC000




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

/XFT/SRM_REC000 is a standard SAP Table View which is used to store Generated Table for View data and is available within R/3 SAP systems depending on the version and release level.

The /XFT/SRM_REC000 table consists of various fields, each holding specific information or linking keys about Generated Table for View data available in SAP. These include AREC_ID (Record ID), AREC_SPS_ID (Element Type ID), AREC_RMS_ID (RMS ID), ACREATED_AT (Created (timestamp)).. 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: Not classified


SAP /XFT/SRM_REC000 table view 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
AMANDTClient MANDTCLNT3MANDT
AREC_IDRecord ID /XFT/SRM_DYN_REC_REC_IDCHAR32/XFT/SRM_DYN_REC_REC_ID
AREC_SPS_IDElement Type ID SRMSPSIDCHAR32SRMID
AREC_RMS_IDRMS ID SRMRMSIDCHAR32SRMID
ACREATED_ATCreated (timestamp) /XFT/TIMESTAMPS_CREATEDDEC15TZNTSTMPS
ACHANGED_ATChanged (timestamp) /XFT/TIMESTAMPS_CHANGEDDEC15TZNTSTMPS
ACREATED_BYCreated by user /XFT/USER_CREATEDCHAR12USERNAME
ACHANGED_BYChange - User /XFT/USER_CHANGEDCHAR12USERNAME
ALATEST_STARTUTC Time Stamp in Short Form (YYYYMMDDhhmmss) TIMESTAMPDEC15TZNTSTMPS
AREQUIRED_ENDUTC Time Stamp in Short Form (YYYYMMDDhhmmss) TIMESTAMPDEC15TZNTSTMPS
ASTATE_SYSTStatus: System /XFT/SRM_DYN_REC_STATE_SYSTCHAR2/XFT/SRM_DYN_REC_STATE_SYST
ASTATE_APPLStatus: Application /XFT/SRM_DYN_REC_STATE_APPLCHAR32/XFT/SRM_DYN_REC_STATE_APPL
BMANDTClient MANDTCLNT3MANDT
BLANGUAGELanguage Key SPRASLANG1T002ISOLASPRASSPRH_T002
BREC_IDRecord ID /XFT/SRM_DYN_REC_REC_IDCHAR32/XFT/SRM_DYN_REC_REC_ID
BDESCR_UPPER128 character CHAR128CHAR128CHAR128
CMANDTClient MANDTCLNT3MANDT
CREC_IDRecord ID /XFT/SRM_DYN_REC_REC_IDCHAR32/XFT/SRM_DYN_REC_REC_ID
CAGENT_TYPEAgent Type /XFT/SRM_DYN_REC_AGENT_TYPECHAR2/XFT/SRM_DYN_REC_AGENT_TYPE
CAGENT_IDAgent ID /XFT/SRM_DYN_REC_AGENT_IDCHAR32/XFT/SRM_DYN_REC_AGENT_ID
CAGENT_QUERYAgent Query: Concatenate /XFT/SRM_DYN_REC_TD_AGENT /XFT/SRM_DYN_REC_AGENT_QUERYCHAR34
DMANDTClient MANDTCLNT3MANDT
DREC_IDRecord ID /XFT/SRM_DYN_REC_REC_IDCHAR32/XFT/SRM_DYN_REC_REC_ID
DNODE_IDNode ID /XFT/SRM_DYN_REC_NODE_IDCHAR32/XFT/SRM_DYN_REC_NODE_ID
DCREATED_ATCreated (timestamp) /XFT/TIMESTAMPS_CREATEDDEC15TZNTSTMPS
DCHANGED_ATChanged (timestamp) /XFT/TIMESTAMPS_CHANGEDDEC15TZNTSTMPS
DCREATED_BYCreated by user /XFT/USER_CREATEDCHAR12USERNAME
DCHANGED_BYChange - User /XFT/USER_CHANGEDCHAR12USERNAME
DLATEST_STARTUTC Time Stamp in Short Form (YYYYMMDDhhmmss) TIMESTAMPDEC15TZNTSTMPS
DREQUIRED_ENDUTC Time Stamp in Short Form (YYYYMMDDhhmmss) TIMESTAMPDEC15TZNTSTMPS
DSTATE_SYSTStatus: System /XFT/SRM_DYN_REC_STATE_SYSTCHAR2/XFT/SRM_DYN_REC_STATE_SYST
DSTATE_APPLStatus: Application /XFT/SRM_DYN_REC_STATE_APPLCHAR32/XFT/SRM_DYN_REC_STATE_APPL
DIS_HIDDENIS HIDDEN: Nodes are not displayed /XFT/SRM_DYN_REC_NODE_FLAG07CHAR1/XFT/BOOLEAN
EMANDTClient MANDTCLNT3MANDT
ELANGUAGELanguage Key SPRASLANG1T002ISOLASPRASSPRH_T002
EREC_IDRecord ID /XFT/SRM_DYN_REC_REC_IDCHAR32/XFT/SRM_DYN_REC_REC_ID
ENODE_IDNode ID /XFT/SRM_DYN_REC_NODE_IDCHAR32/XFT/SRM_DYN_REC_NODE_ID
EDESCR_UPPER128 character CHAR128CHAR128CHAR128
FMANDTClient MANDTCLNT3MANDT
FREC_IDRecord ID /XFT/SRM_DYN_REC_REC_IDCHAR32/XFT/SRM_DYN_REC_REC_ID
FNODE_IDNode ID /XFT/SRM_DYN_REC_NODE_IDCHAR32/XFT/SRM_DYN_REC_NODE_ID
FAGENT_TYPEAgent Type /XFT/SRM_DYN_REC_AGENT_TYPECHAR2/XFT/SRM_DYN_REC_AGENT_TYPE
FAGENT_IDAgent ID /XFT/SRM_DYN_REC_AGENT_IDCHAR32/XFT/SRM_DYN_REC_AGENT_ID
FAGENT_QUERYAgent Query: Concatenate /XFT/SRM_DYN_REC_TD_AGENT /XFT/SRM_DYN_REC_AGENT_QUERYCHAR34
NMANDTClient MANDTCLNT3MANDT
NREC_IDRecord ID /XFT/SRM_DYN_REC_REC_IDCHAR32/XFT/SRM_DYN_REC_REC_ID
NNODE_IDNode ID /XFT/SRM_DYN_REC_NODE_IDCHAR32/XFT/SRM_DYN_REC_NODE_ID
NROLE_NAMERole Name AGR_NAMECHAR30AGR_NAMEAGR_NAME

Key field Non-key field



How do I retrieve data from SAP table /XFT/SRM_REC000 using ABAP code

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

SELECT SINGLE *
FROM /XFT/SRM_REC000
INTO CORRESPONDING FIELDS OF WA_/XFT/SRM_REC000
WHERE...

How to access SAP table /XFT/SRM_REC000

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