/SAPSRM/S_GEN_APV_ITM SAP (item overview structure) Structure details

Dictionary Type: Structure
Description: item overview structure




ABAP Code to SELECT data from /SAPSRM/S_GEN_APV_ITM
Related tables to /SAPSRM/S_GEN_APV_ITM
Access table /SAPSRM/S_GEN_APV_ITM




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

/SAPSRM/S_GEN_APV_ITM is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "item overview structure" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_/SAPSRM/S_GEN_APV_ITM TYPE /SAPSRM/S_GEN_APV_ITM.

The /SAPSRM/S_GEN_APV_ITM table consists of various fields, each holding specific information or linking keys about item overview structure data available in SAP. These include ITEM_NUMBER (Item Number used in Approval Process View), PRODUCT_DESCR (Product Description in Approval Process View), LEVEL_STATUS_DESCR (Description of Process Level Status), PROC_STEP_DESCR (Process Step Description Used in CLL Layer).. 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: Can Be Enhanced (Deep)


SAP /SAPSRM/S_GEN_APV_ITM structure 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
ITEM_NUMBERItem Number used in Approval Process View /SAPSRM/CLL_APV_ITEM_NUMBERNUMC6NUMC6
PRODUCT_DESCRProduct Description in Approval Process View /SAPSRM/CLL_APV_PRODUCT_DESCRCHAR60CHAR60
LEVEL_STATUS_DESCRDescription of Process Level Status /SAPSRM/CLL_APV_LEVEL_STAT_TXTCHAR60CHAR60
PROC_STEP_DESCRProcess Step Description Used in CLL Layer /SAPSRM/CLL_APV_PROC_STEP_DESCCHAR60CHAR60
PROCESSOR_NAMES_CONCProcessor /SAPSRM/CLL_APV_NAMES_CONCCHAR80CHAR80
ITEM_APPR_NOTE_TXTItem Approval Note (First Line) /SAPSRM/CLL_APV_ITM_NOTE_TXTCHAR60CHAR60
ITEM_STATUSStatus of a Decision Set Item (Referring to a PDO Item) /SAPSRM/WF_DS_ITEM_STATUSCHAR8/SAPSRM/PDO_APPROVALSTATUS
DECISIONSET_GUIDDecision Set Identifier /SAPSRM/WF_DS_GUIDRAW16
RESOLVER_NAME_TEXTText Field of Length 60 TEXT60CHAR60TEXT60
WI_CREATED_ATUTC Timestamp at Work Item Creation /SAPSRM/CLL_APV_WI_CREATED_ATDEC15TZNTSTMPS
WI_STARTED_ATUTC Timestamp at Work Item Start /SAPSRM/CLL_APV_WI_STARTED_ATDEC15TZNTSTMPS
WI_ENDED_ATUTC Timestamp at Work Item Start /SAPSRM/CLL_APV_WI_STARTED_ATDEC15TZNTSTMPS
LEAFElement Without Subelements /SAPSRM/LEAFCHAR1BOOLE
EXPANDEDData element for domain BOOLE: TRUE (='X') and FALSE (=' ') BOOLE_DCHAR1BOOLE
CHILDREN_LOADEDData element for domain BOOLE: TRUE (='X') and FALSE (=' ') BOOLE_DCHAR1BOOLE
CALC_DESCRIPTIONCalculated description for a hierarchical item /SAPSRM/CLL_CALC_DESCRIPTIONSTRG0/SAPSRM/CLL_CALC_DESCRIPTION
NOT_SELECTABLEData element for domain BOOLE: TRUE (='X') and FALSE (=' ') BOOLE_DCHAR1BOOLE
AGENT_ID_TAB 0
LEVEL_GUIDProcess Level ID /SAPSRM/WF_PROCESS_LEVEL_GUIDRAW16SYSUUID
LEVEL_SEQNRProcess Level Sequence Number /SAPSRM/WF_PROCESS_LEVEL_SEQNRNUMC3NUM03
LEVEL_TYPEProcess Level Type /SAPSRM/WF_PROCESS_LEVEL_TYPECHAR1/SAPSRM/WF_PROCESS_LEVEL_TYPE
TEMPLATE_IDWorkflow Template Identifier (Concatenatd PD-Org. Type & ID) /SAPSRM/WF_WORKFLOW_TEMPL_CIDCHAR14HROBJEC_14
APPROVAL_TASK_IDWorkflow Task Identifier (Concatenated PD-Org. Type and ID) /SAPSRM/WF_WORKFLOW_TASK_CIDCHAR14HROBJEC_14
DECISION_TYPEDecision Type /SAPSRM/WF_DECISION_TYPECHAR1/SAPSRM/WF_DECISION_TYPE
LEVEL_STATUSProcess Level Status /SAPSRM/WF_PROCESS_LEVEL_STATCHAR10/SAPSRM/WF_PROCESS_LEVEL_STAT
LEVEL_DECISION_STATUSStatus of a Decision /SAPSRM/WF_DECISIONCHAR8/SAPSRM/WF_DECISION
IS_ADHOC_LEVELProcess Level is Ad Hoc Level ('X', else ' ') /SAPSRM/WF_IS_ADHOC_LEVELCHAR1BOOLE
RESOLVER_NAMEResponsibility Resolver Name /SAPSRM/WF_RESP_RESOLVER_NAMECHAR32Assigned to domain/SAPSRM/WF_RESP_RESOLVER_NAME
GENERATED_GUIDGenerated GUID (Versioned ID for an Approval Level) /SAPSRM/PDO_GENERATED_GUIDRAW16SYSUUID
WI_IDWork Item Identifier /SAPSRM/CLL_APV_WORKITEM_IDNUMC12Assigned to domainSWW_WIID
WI_TYPEWork Item Type /SAPSRM/CLL_APV_WORKITEM_TYPECHAR6/SAPSRM/WF_WORKITEM_TYPE
WI_TEMPLATE_IDWorkflow Template ID /SAPSRM/CLL_APV_TEMPLATE_IDCHAR14HROBJEC_14
WI_TASK_IDWorkflow Task Identifier (Concatenated PD-Org. Type and ID) /SAPSRM/CLL_APV_TASK_IDCHAR14HROBJEC_14
DS_GUIDDecision Set GUID Used in CLL Layer for Approval Proc. View /SAPSRM/CLL_APV_DS_GUIDRAW16SYSUUID
AGENT_IDIdentification Number of Agent / Reviewer (PD-Org. ID) /SAPSRM/CLL_APV_AGENT_IDCHAR12HROBJID_12
AGENT_OTObject Type of Agent / Reviewer (PD-Org.) /SAPSRM/CLL_APV_AGENT_OTCHAR2Assigned to domainOTYPE
AGENT_TYPEAgent Type Indicating Rule-Based or Ad Hoc Agent /SAPSRM/CLL_APV_AGENT_TYPECHAR2/SAPSRM/D_REVIEWER_TYPE
REVIEWER_IDIdentification Number of Reviewer (PD-Org. ID) /SAPSRM/CLL_APV_REVIEWER_IDCHAR12HROBJID_12
REVIEWER_OTObject Type of Reviewer (PD-Org. Object Type) /SAPSRM/CLL_APV_REVIEWER_OTCHAR2Assigned to domainOTYPE
REVIEWER_TYPEIndicates if Reviewer Type is Rule-Based or Ad Hoc /SAPSRM/CLL_APV_REVIEWER_TYPECHAR2/SAPSRM/D_REVIEWER_TYPE
PARENT_KEYGenerated GUID (Versioned ID for an Approval Level) /SAPSRM/PDO_GENERATED_GUIDRAW16SYSUUID
ROW_KEYGenerated GUID (Versioned ID for an Approval Level) /SAPSRM/PDO_GENERATED_GUIDRAW16SYSUUID
DECISION_SET_DESCRDecision Set Description for Display on UI /SAPSRM/CLL_APV_DS_DESCRCHAR40CHAR40
FORWARDED_BYID of Business Partner Who Forwarded Work Item /SAPSRM/CLL_APV_FORWARDED_BYCHAR12HROBJID_12
FORWARDED_ATTime of Work Item Forwarding /SAPSRM/CLL_APV_FORWARDED_ATDEC15TZNTSTMPS
FORWARDER_NAMEFull Name of Business Partner Who Forwarded Work Item /SAPSRM/CLL_APV_FORW_BY_NAMECHAR60CHAR60
SEQNRInternal Sequence Number of Process Levels /SAPSRM/CLL_APV_SEQNRNUMC3NUMC3
GUIDGlobally Unique identifier BBP_GUIDRAW16SYSUUID
PARENTGlobally Unique identifier BBP_GUIDRAW16SYSUUID
MODEL 0
DOCUMENT_GUIDGUID of SRM Purchasing Document /SAPSRM/PDO_WF_DOCUMENT_GUIDRAW16
ITEM_GUIDItem GUID Used in CLL Layer /SAPSRM/CLL_APV_ITEM_GUIDRAW16SYSUUID

Key field Non-key field



How do I retrieve data from SAP structure /SAPSRM/S_GEN_APV_ITM using ABAP code?

As /SAPSRM/S_GEN_APV_ITM is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on /SAPSRM/S_GEN_APV_ITM as there is no data to select.

How to access SAP table /SAPSRM/S_GEN_APV_ITM

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