ACTIVITY_H SAP (Auxiliary Structure: Do NOT Use!!!) Structure details

Dictionary Type: Structure
Description: Auxiliary Structure: Do NOT Use!!!




ABAP Code to SELECT data from ACTIVITY_H
Related tables to ACTIVITY_H
Access table ACTIVITY_H




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

ACTIVITY_H 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 "Auxiliary Structure: Do NOT Use!!!" 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_ACTIVITY_H TYPE ACTIVITY_H.

The ACTIVITY_H table consists of various fields, each holding specific information or linking keys about Auxiliary Structure: Do NOT Use!!! data available in SAP. These include CLIENT (Client), GUID (GUID of a CRM Order Object), CATEGORY (Activity Category (Communication Type)), PRIORITY (Activity Priority).. 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 (character-type or numeric)


SAP ACTIVITY_H 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
CLIENTClient MANDTCLNT3Assigned to domainMANDT
GUIDGUID of a CRM Order Object CRMT_OBJECT_GUIDRAW16SYSUUID
CATEGORYActivity Category (Communication Type) CRMT_ACTIVITY_CATEGORYCHAR3CRMC_ACT_CATEGORCRM_ACTIVITY_CATEGORY
PRIORITYActivity Priority CRMT_PRIORITYNUMC1SCPRIOSC_PRIO
OBJECTIVEGoal of an Activity CRMT_OBJECTIVECHAR3CRMC_ACT_OBJCRM_OBJECTIVE
DIRECTIONDirection of an Activity CRMT_DIRECTIONCHAR1CRM_DIRECTION
EXTERN_ACT_IDExternal Business Transaction Number CRMT_EXTERNAL_ACTIVITY_IDCHAR20CRM_EXTERNAL_ACTIVITY_ID
PRIVATE_FLAGIndicator: Task is Private CRMT_PRIVATCHAR1CRM_BOOLEAN
COMPLETIONCompletion Rate in Percent CRMT_COMPLETIONNUMC3CRM_COMPLETIONCRM_ACT_COMPLETION
CALENDARInclude Activity in Calendar CRMT_CALENDARCHAR1CRM_BOOLEAN
TASKIndicator: Activity is a Task CRMT_TASKCHAR1CRM_BOOLEAN
CLASSActivity Class CRMT_ACTIVITY_CLASSCHAR1CRM_ACTIVITY_CLASS
CATEGORY_TXTTexts for Category CRMT_REPORT_CATEGORY_TXTCHAR60DDTEXT
PRIORITY_TXTText Description for Priority CRMT_REPORT_PRIORITY_TXTCHAR60DDTEXT
OBJECTIVE_TXTText Description for Goal of an Activity CRMT_REPORT_OBJECTIVE_TXTCHAR60DDTEXT
DIRECTION_TXTText Description for Direction CRMT_REPORT_DIRECTION_TXTCHAR60DDTEXT
MAINPARTNERBusiness Partner Number BU_PARTNERCHAR10Assigned to domainALPHABU_PARTNERBPABUPA
MAINPARTNERFCTPartner func. CRMT_PARTNER_FCTCHAR8COM_PARTNER_FCT
PARTNER_FCT_TXTPartner Function: Long Text CRMT_REPORT_FNKT_LONGCHAR30TEXT30
PARTNER_FCT_SHOPartner Function: Short Text CRMT_REPORT_FNKT_SHORTCHAR4TEXT4
PLANNEDDATEFROMStart Date SC_DATEFRODATS8DATUM
PLANNEDDATETOEnd Date SC_DATETODATS8DATUM

Key field Non-key field



How do I retrieve data from SAP structure ACTIVITY_H using ABAP code?

As ACTIVITY_H 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 ACTIVITY_H as there is no data to select.

How to access SAP table ACTIVITY_H

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