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

Dictionary Type: Table View
Description: Generated Table for View




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




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

/XFT/SOP_Q003D 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/SOP_Q003D table consists of various fields, each holding specific information or linking keys about Generated Table for View data available in SAP. These include REC_ID (Record ID), BLANGUAGE (Language Key), ESCOPE_USER (User Name), REC_SPS_ID (Element Type ID).. 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/SOP_Q003D 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
MANDTClient MANDTCLNT3MANDT
REC_IDRecord ID /XFT/SRM_DYN_REC_REC_IDCHAR32/XFT/SRM_DYN_REC_REC_ID
BLANGUAGELanguage Key SPRASLANG1T002ISOLASPRASSPRH_T002
ESCOPE_USERUser Name UNAMECHAR12UNAME
REC_SPS_IDElement Type ID SRMSPSIDCHAR32SRMID
REC_RMS_IDRMS ID SRMRMSIDCHAR32SRMID
CREATED_ATCreated (timestamp) /XFT/TIMESTAMPS_CREATEDDEC15TZNTSTMPS
CHANGED_ATChanged (timestamp) /XFT/TIMESTAMPS_CHANGEDDEC15TZNTSTMPS
CREATED_BYCreated by user /XFT/USER_CREATEDCHAR12USERNAME
CHANGED_BYChange - User /XFT/USER_CHANGEDCHAR12USERNAME
STATE_SYSTStatus: System /XFT/SRM_DYN_REC_STATE_SYSTCHAR2/XFT/SRM_DYN_REC_STATE_SYST
STATE_APPLStatus: Application /XFT/SRM_DYN_REC_STATE_APPLCHAR32/XFT/SRM_DYN_REC_STATE_APPL
BDESCRIPTIONDescription /XFT/DESCRIPTIONCHAR128/XFT/DESCRIPTION
BDESCR_UPPER128 character CHAR128CHAR128CHAR128
CSOP_TYPESOP type /XFT/SOP_TYPECHAR32SRMID
CSOP_IDSOP number /XFT/SOP_IDCHAR64/XFT/CM_CID
CSOP_ID_UPPERSOP number (upper case for search) /XFT/SOP_ID_UPPERCHAR64CHAR64
CSOP_AUTHORMain Author /XFT/SOP_AUTHORCHAR12UNAME/XFT/USER_001_A
CSOP_LANGUAGESOP language /XFT/SOP_LANGUAGELANG1ISOLALANGUH_T002
CUSER_RESPONSIPerson responsible /XFT/SOP_USER_RESPONSIBLECHAR12XUBNAME/XFT/USER_001_A
CORGU_RESPONSIResponsible area /XFT/SOP_ORGU_RESPONSIBLENUMC8HROBJIDHRBAS00OBJID
CKNOW_HOW_PROT /XFT/SOP_KNOW_HOW_PROTECTIONCHAR3/XFT/SOP_KNOW_HOW_PROTECTION
CID_EXTERNExternal SOP number /XFT/SOP_ID_EXTERNCHAR64/XFT/SOP_ID
CID_EXTERN_UPPERExternal SOP number (upper case for search) /XFT/SOP_ID_EXTERN_UPPERCHAR64CHAR64
CACTIVE_DATE_FROSOP Date Active From /XFT/SOP_ACTIVE_DATE_FROMDATS8DATS
CACTIVE_DATE_TOSOP Date Active To /XFT/SOP_ACTIVE_DATE_TODATS8DATS
CACTIVE_MAJOR_VENode ID /XFT/SRM_DYN_REC_NODE_IDCHAR32/XFT/SRM_DYN_REC_NODE_ID
CACTIVE_MINOR_VENode ID /XFT/SRM_DYN_REC_NODE_IDCHAR32/XFT/SRM_DYN_REC_NODE_ID
MAJOR_VERNode ID /XFT/SRM_DYN_REC_NODE_IDCHAR32/XFT/SRM_DYN_REC_NODE_ID

Key field Non-key field



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

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

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

How to access SAP table /XFT/SOP_Q003D

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