SAP CNISFIELDS Project Info System: Various Fields Table data and field list

CNISFIELDS 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 "Project Info System: Various Fields" 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_CNISFIELDS TYPE CNISFIELDS.

The CNISFIELDS table consists of various fields, each holding specific information or linking keys about Project Info System: Various Fields data available in SAP. These include FLG_STMDAT (Indicator: Master data should be transferred), FLG_CREATB (Indicator: Create table), FLG_DBDAT (Indicator: Data from database should be selected), FLG_ARCDAT (Indicator: Archive data is to be selected)... 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. .

CNISFIELDS structure Technical Details:

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type)


SAP CNISFIELDS structure fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the CNISFIELDS table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.
Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
FLG_STRUCIndicator: Work breakdown struct. should also be transported PS_STRUCCHAR1XFELD
FLG_STMDATIndicator: Master data should be transferred PS_STAMDATCHAR1XFELD
FLG_CREATBIndicator: Create table PS_CREATABCHAR1XFELD
FLG_DBDATIndicator: Data from database should be selected PS_DBDATCHAR1XFELD
FLG_ARCDATIndicator: Archive data is to be selected PS_ARCDATCHAR1XFELD
FLG_AKTDATIndicator: Current data should be selected PS_AKTDATCHAR1XFELD
FLG_VERDATIndicator: Version data is to be selected PS_VERDATCHAR1XFELD
FLG_AGGRIndicator: fields which can be aggregated are aggregated PS_FLG_AGRCHAR1XFELD
FLG_SHOW_PATHIndicator: display upward PS_PATHCHAR1XFELD
FLG_SAVEIndicator: Save profile PS_FLG_SAVCHAR1XFELD
FLG_GETIndicator: Retrieve profile/variant PS_FLG_GETCHAR1XFELD
FLG_VSSEL1Indicator: Structure-related set up (versions) PS_FLG_SE1CHAR1XFELD
FLG_VSSEL2Indicator: Object-related structure (versions) PS_FLG_SE2CHAR1XFELD
FLG_FILTERIndicator: Filter criteria must be met PS_EXP_FLTCHAR1XFELD
FLG_HRVOR1Indicator: Highlighting 1 must be met PS_EXP_HV1CHAR1XFELD
FLG_HRVOR2Indicator: Highlighting 2 must be met PS_EXP_HV2CHAR1XFELD
FLG_PRINTIndicator: Print overview PS_AKT_PRNCHAR1XFELD
FLG_MAILIndicator: Send mail PS_AKT_MLSCHAR1XFELD
FLG_EINSTIndicator: Send with current settings PSSO_EINSTCHAR1XFELD
FLG_AUTHIndicator: Send with own authorizations PSSO_AUTHCHAR1XFELD
FLG_DATENIndicator: Send with selected data PSSO_DATENCHAR1XFELD
FLG_SELVRSIndicator: Save selection version PS_AKT_SVSCHAR1XFELD
FLG_RCKLOEIndicator: Delete confirmation pool PS_AKT_RVLCHAR1XFELD
FLG_RCKVORIndicator: Create confirmation pool PS_AKT_RKVCHAR1XFELD
FLG_RCKWFLIndicator: Create confirmation workflow PS_AKT_RWFCHAR1XFELD
FLG_RCKDEZIndicator: export data to MS ACCESS for confirmation PS_AKT_RDZCHAR1XFELD
FLG_MS_ACCIndicator: export data to MS ACCESS for confirmation PS_AKT_MSACHAR1XFELD
FLG_PRJVSLIndicator: Delete project version PS_AKT_PVLCHAR1XFELD
FLG_PRJVRSIndicator: Save project version PS_AKT_PVSCHAR1XFELD
FLG_NXTFREIndicator: use next open number PS_NXT_FRECHAR1XFELD
FLG_MASSKey figure: carry out mass change PS_AKT_MASSCHAR1XFELD
FROM_DATEDate of Last Change AS4DATEDATS8AS4DATE
TO_DATEDate of Last Change AS4DATEDATS8AS4DATE
FLG_AKTREPIndicator: Selection versions for started report PS_AKTREPCHAR1XFELD
UNAMEUser Name UNAMECHAR12UNAME
SORT_DOWNSort in descending order FLAG_DOWNCHAR1XFELD
SORT_UPSort in ascending order FLAG_UPCHAR1XFELD
AGGREGATEGroup FLAG_GROUPCHAR1XFELD
GROUPINGSummarize FLAG_AGGRCHAR1XFELD
FLG_MIN_EHIndicator: Use smallest unit X_MINUNITCHAR1XFELD
FLG_MAX_EHIndicator: Use largest unit X_MAXUNITCHAR1XFELD
FLG_EXP_EHIndicator: Use specified unit X_EXPLUNITCHAR1XFELD
FLG_AKTGRPIndicator: Search in current group only X_AKT_GRPCHAR1XFELD
VSCMP_ADDIndicator: version comparison: filter created objects VSCMP_ADDCHAR1XFELD
VSCMP_HIEIndicator: version comparison: filter other hierarchy VSCMP_HIECHAR1XFELD
VSCMP_DIFIndicator: version comparison: filter changed objects VSCMP_DIFCHAR1XFELD
VSCMP_DBIndicator: compare all database fields VSCMP_DBCHAR1XFELD
VSCMP_ALLIndicator: compare all fields which can be displayed VSCMP_ALLCHAR1XFELD
VSCMP_ANZIndicator: compare all displayed fields VSCMP_ANZCHAR1XFELD
VSCMP_EXPIndicator: compare all selected fields VSCMP_EXPCHAR1XFELD
VSCMP_ADD1Indicator: version comparison: except 1, created objects VSCMP_ADD1CHAR1XFELD
VSCMP_HIE1Indicator: version comparison: exception 1 other hierarchy VSCMP_HIE1CHAR1XFELD
VSCMP_DIF1Indicator: version comparison: objects chgd in exception1 VSCMP_DIF1CHAR1XFELD
VSCMP_DB1Indicator: compare all database fields VSCMP_DBCHAR1XFELD
VSCMP_ALL1Indicator: compare all fields which can be displayed VSCMP_ALLCHAR1XFELD
VSCMP_ANZ1Indicator: compare all displayed fields VSCMP_ANZCHAR1XFELD
VSCMP_EXP1Indicator: compare all selected fields VSCMP_EXPCHAR1XFELD
VSCMP_ADD2Indicator: version comparison: objs created in exception 2 VSCMP_ADD2CHAR1XFELD
VSCMP_HIE2Indicator: version comparison: exception 2 other hierarchy VSCMP_HIE2CHAR1XFELD
VSCMP_DIF2Indicator: version comparison: exception 2 changed objects VSCMP_DIF2CHAR1XFELD
VSCMP_DB2Indicator: compare all database fields VSCMP_DBCHAR1XFELD
VSCMP_ALL2Indicator: compare all fields which can be displayed VSCMP_ALLCHAR1XFELD
VSCMP_ANZ2Indicator: compare all displayed fields VSCMP_ANZCHAR1XFELD
VSCMP_EXP2Indicator: compare all selected fields VSCMP_EXPCHAR1XFELD

Key field Non-key field



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

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

How to access SAP table CNISFIELDS

Within an ECC or HANA version of SAP you can also view further information about CNISFIELDS and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).