CNSE_ACTY SAP (Fields for Expert Document Search (Activity)) Structure details

Dictionary Type: Structure
Description: Fields for Expert Document Search (Activity)




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




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

CNSE_ACTY 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 "Fields for Expert Document Search (Activity)" 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_CNSE_ACTY TYPE CNSE_ACTY.

The CNSE_ACTY table consists of various fields, each holding specific information or linking keys about Fields for Expert Document Search (Activity) data available in SAP. These include VORNR (Activity number in network and standard network), LTXA1 (Operation short text), WERKS (Plant), KOKRS (Controlling Area).. 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 CNSE_ACTY 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
AUFNROrder Number AUFNRCHAR12Assigned to domainALPHAAUFNRANR
VORNRActivity number in network and standard network CN_VORNRCHAR4NUMCVVORNR
LTXA1Operation short text LTXA1CHAR40TEXT40
WERKSPlant WERKS_DCHAR4Assigned to domainWERKSWRKH_T001W_C
KOKRSControlling Area KOKRSCHAR4Assigned to domainCACCDCAC
PSPIDProject Definition PS_PSPIDCHAR24ABPSNPS_PSPIDPSPPD_DUMMY
POSIDWork Breakdown Structure Element (WBS Element) PS_POSIDCHAR24PROJNPS_POSIDPRO
WAERSCurrency Key WAERSCUKY5Assigned to domainWAERSFWS
INFNRNumber of Purchasing Info Record INFNRCHAR10Assigned to domainALPHAINFNRINFMEIN_C
DISPOMRP Controller (Materials Planner) DISPOCHAR3Assigned to domainDISPODGRHS_T024D
EKORGPurchasing Organization EKORGCHAR4Assigned to domainEKORGEKO
MATKLMaterial Group MATKLCHAR9Assigned to domainMATKLMKLS_WBWG
NPRIOPriority NW_PRIOCHAR1Assigned to domainNW_PRIO
BUKRSCompany Code BUKRSCHAR4Assigned to domainBUKRSBUKC_T001
ANFKORequesting cost center ANFKOCHAR10Assigned to domainALPHAKOSTL
SAKTOCost Element KSTARCHAR10Assigned to domainALPHAKSTARKAT
LARNTActivity Type LSTARCHAR6Assigned to domainLSTARLARLART_EMPTY
GSBERBusiness Area GSBERCHAR4Assigned to domainGSBERGSB
PRCTRProfit Center PRCTRCHAR10Assigned to domainALPHAPRCTRPRCPRCTR_EMPTY
STTXT_INTSystem Status CO_STTXTCHAR40CHAR40
STTXT_EXTField for user status display CO_STTXTUCHAR40CHAR40
FSAVDEarliest scheduled start: Execution (date) FSAVDDATS8DATUM
USR01User field with 20 characters USRCHAR20CHAR20USRCHAR20
USR02User field with 10 characters USRCHAR10CHAR10USRCHAR10
USR03User field with 10 characters USRCHAR10CHAR10USRCHAR10
USR04User field for quantity (length 10.3) USRQUAN13QUAN13(3) USRQUAN13
USE04User field: Unit for quantity fields USRUNITUNIT3Assigned to domainCUNITMEINS
USR05User field for quantity (length 10.3) USRQUAN13QUAN13(3) USRQUAN13
USE05User field: Unit for quantity fields USRUNITUNIT3Assigned to domainCUNITMEINS
USR06User-defined field for values (length 10,3) USRCURR13CURR13(3) USRCURR13
USE06User field: Unit for value fields USRCUKYCUKY5Assigned to domainWAERS
USR07User-defined field for values (length 10,3) USRCURR13CURR13(3) USRCURR13
USE07User field: Unit for value fields USRCUKYCUKY5Assigned to domainWAERS
USR08User field for date USRDATEDATS8USRDATE
USR09User field for date USRDATEDATS8USRDATE
USR10User-defined field: Indicator for reports USRFLAGCHAR1FLAG
USR11User-defined field: Indicator for reports USRFLAGCHAR1FLAG
DUMMY_CI_AFVUSingle-Character Indicator CHAR1CHAR1CHAR1
.INCLU--AP 0
/MRSS/ID_PROFILERequirements Profile Was Changed Manually /MRSS/T_REQU_UPDCHAR1/MRSS/_HCM_BOOLEAN
/MRSS/PROF_KEYProfile Key /MRSS/T_RSG_REQUIDCHAR10ALPHA/MRSS/RSG_REQUID
/MRSS/PROF_GUIDCharacter field, length 32 CHAR32CHAR32CHAR32
/MRSS/ACT_TYPEProcess variant /MRSS/T_ACTIVITY_TYPECHAR1/MRSS/_ACTIVITY_TYPE
/MRSS/ORDER_PROBOrder probability in percent /MRSS/T_ORDER_PROBCHAR3OPROB/MRSS/_ORDER_PROB
/MRSS/INIT_DONEInternal initialization carried out once /MRSS/T_INIT_DONECHAR1FLAG
/MRSS/DATACHANGEData was changed in the controls on the user screen /MRSS/T_USCREENCTL_DATACHANGEDCHAR1FLAG
/MRSS/DEM_COUNTCounter for Demands in Operation /MRSS/T_DEM_COUNTNUMC4NUMC4
/MRSS/SUPERV_CNTNumber of Site Supervisors /MRSS/T_RAP_SUPERVISOR_COUNTCHAR2ALPHA/MRSS/_RAP_SUPERVISOR_COUNT
/MRSS/RULE_IDTime Rule Id /MRSS/T_RSG_TIME_RULE_IDCHAR25TEXT25
/MRSS/SALES_ORGSales Organization VKORGCHAR4Assigned to domainVKORGVKOC_VKORG
/MRSS/REFF_RCNTDetermination of Remaining Demand: No. of Resources /MRSS/T_REM_EFFORT_RES_COUNTNUMC3NUMC3
/MRSS/REFF_E_BEGTime stamp: start /MRSS/T_TIMESTAMP_BEGINNUMC14TSTLC/MRSS/_TIMESTAMP
/MRSS/REFF_E_ENDTime stamp: end /MRSS/T_TIMESTAMP_ENDNUMC14TSTLC/MRSS/_TIMESTAMP
/MRSS/REFF_L_BEGTime stamp: start /MRSS/T_TIMESTAMP_BEGINNUMC14TSTLC/MRSS/_TIMESTAMP
/MRSS/REFF_L_ENDTime stamp: end /MRSS/T_TIMESTAMP_ENDNUMC14TSTLC/MRSS/_TIMESTAMP
/MRSS/RELEVANTOperation Set as MRS-Relevant /MRSS/T_RELEVANT_FOR_MRSCHAR1FLAG
/MRSS/TEAM_PLANTeam Planning flag for Demand /MRSS/T_RSG_TEAM_PLANNINGCHAR1/MRSS/_RSG_TEAM_PLANNING
/MRSS/SINGL_RESIndicator for Forcing a Single Resource /MRSS/T_RSG_FORCE_SINGLE_RESCHAR1/MRSS/_BOOLEAN
/MRSS/TO_BEGDATField of type DATS DATSDATS8DATS
/MRSS/TO_BEGTIMField of type TIMS TIMSTIMS6TIME
/MRSS/TO_ENDDATField of type DATS DATSDATS8DATS
/MRSS/TO_ENDTIMField of type TIMS TIMSTIMS6TIME
/MRSS/TO_DURATCharacter Field Length = 10 CHAR10CHAR10CHAR10
/MRSS/TO_DUNITBase Unit of Measure MEINSUNIT3Assigned to domainCUNITMEINS
/MRSS/TO_DISTAN19 Characters CHAR19CHAR19CHAR19
/MRSS/TO_MANUALBoolean Variable /MRSS/T_RSG_BOOLEANCHAR1/MRSS/_RSG_BOOLEAN
/MRSS/FR_BEGDATField of type DATS DATSDATS8DATS
/MRSS/FR_BEGTIMField of type TIMS TIMSTIMS6TIME
/MRSS/FR_ENDDATField of type DATS DATSDATS8DATS
/MRSS/FR_ENDTIMField of type TIMS TIMSTIMS6TIME
/MRSS/FR_DURATCharacter Field Length = 10 CHAR10CHAR10CHAR10
/MRSS/FR_DUNITBase Unit of Measure MEINSUNIT3Assigned to domainCUNITMEINS
/MRSS/FR_DISTAN19 Characters CHAR19CHAR19CHAR19
/MRSS/FR_MANUALBoolean Variable /MRSS/T_RSG_BOOLEANCHAR1/MRSS/_RSG_BOOLEAN

Key field Non-key field



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

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

How to access SAP table CNSE_ACTY

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