CFTRACE SAP (Structure to save an analysis path (forwards)) Structure details
Description: Structure to save an analysis path (forwards)
Structure field list including key, data, relationships and ABAP select examples
CFTRACE 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 "Structure to save an analysis path (forwards)" 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_CFTRACE TYPE CFTRACE.
The CFTRACE table consists of various fields, each holding specific information or linking keys about Structure to save an analysis path (forwards) data available in SAP. These include ACTIVE (Function/field active), DISPL (Display report page), TFLAG (Flag to indicate text), COBJID (Folder Entry ID (Obj+Fol+Forwarder Name)).. 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 CFTRACE 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 |
CODE | Function in drill-down reporting | CFCODE | CHAR | 4 | CHAR4 | ||||
ACTIVE | Function/field active | CFACTIVE | CHAR | 1 | CHAR1 | ||||
DISPL | Display report page | CFDISPL | CHAR | 1 | CHAR1 | ||||
TFLAG | Flag to indicate text | CFTFLAG | CHAR | 1 | CHAR1 | ||||
COBJID | Folder Entry ID (Obj+Fol+Forwarder Name) | SO_ENTRYID | CHAR | 46 | SO_ENTRYID | ||||
SELFINV | Function: Identical in whichever order performed | CFSELFINV | CHAR | 1 | CHAR1 | ||||
IND_BACK | Pointer to corresponding entry in BACK_TAB | CFIND_BACK | NUMC | 8 | NUM8 | ||||
IND_SORT | Pointer to corresponding entry in SORT_TAB | CFIND_SORT | NUMC | 8 | NUM8 | ||||
FELD | Field name/cursor position | CFFELD | CHAR | 30 | CHAR30 | ||||
AUSPS | Lower Limit of Characteristic Value | RKE_LOW_L | CHAR | 50 | KEYID | ||||
L_TFLAG | Flag to indicate text | CFTFLAG | CHAR | 1 | CHAR1 | ||||
P_ZWERT | Line in ZWERT | CFZWERT | INT4 | 10 | CFINT4 | ||||
SPRINT | Sort column in PRINT | CFSPRINT | INT4 | 10 | CFINT4 | ||||
SDIR | Sort direction | RKE_ASCDES | CHAR | 1 | RKE_ASCDES | ||||
SKTW | Sort order: Key, Text, Value | RKE_SKTW | CHAR | 1 | RKE_SKTW | ||||
BDIR | Sort direction for condition in SEIG | RKE_BDIR | CHAR | 1 | RKE_ASCDES | ||||
BWRT | Conditional value with 3 decimal places | RKE_BWRT9 | DEC | 17(3) | RKE_WERTV9 | ||||
BPRINT | Condition Column in PRINT | CFBPRINT | INT4 | 10 | CFINT4 | ||||
ASCDESC | Sort direction | RKE_ASCDES | CHAR | 1 | RKE_ASCDES | ||||
TOPN | Top n condition | RKE_TOPN | NUMC | 3 | NUMC3 | ||||
TOPP | Top % condition | RKE_TOPP | DEC | 4(2) | RKE_WERT3 | ||||
BOPE | Condition | RKE_BOPE | CHAR | 2 | RKE_BOPE | ||||
FNAM | Field Name | FIELDNAME | CHAR | 30 | Assigned to domain | FDNAME | DFD | ||
SOURCE | Field Name | FIELDNAME | CHAR | 30 | Assigned to domain | FDNAME | DFD | ||
DECIM | Decimal places for quantities | RKE_DECIM | NUMC | 1 | NUMC1 | ||||
ROUND | Quantity display factor | RKE_ROUNM | NUMC | 1 | NUMC1 | ||||
CUKYD | Foreign currency key | FRWAE | CUKY | 5 | TCURC | WAERS | |||
NUMBR | Number of translation key in currency translation | CFNUMBR | NUMC | 3 | Assigned to domain | CFNUMBR | NBR | ||
BERNA | Report | CFREPID2 | CHAR | 12 | Assigned to domain | BERNA2 | REI | ||
SCOLS | Screen Columns | SYSCOLS | INT4 | 10 | SYST_BYTE | ||||
BEG_T1 | Begin table 1 | CFBEG_T1 | INT4 | 10 | SYST_LONG | ||||
END_T1 | End table 1 | CFEND_T1 | INT4 | 10 | SYST_LONG | ||||
BEG_T2 | Begin table 2 | CFBEG_T2 | INT4 | 10 | SYST_LONG | ||||
END_T2 | End table 2 | CFEND_T2 | INT4 | 10 | SYST_LONG | ||||
BEG_T3 | Begin table 3 | CFBEG_T3 | INT4 | 10 | SYST_LONG | ||||
END_T3 | End table 3 | CFEND_T3 | INT4 | 10 | SYST_LONG | ||||
BEG_T4 | Begin table 4 | CFBEG_T4 | INT4 | 10 | SYST_LONG | ||||
END_T4 | End table 4 | CFEND_T4 | INT4 | 10 | SYST_LONG | ||||
BEG_T5 | Begin table 5 | CFBEG_T5 | INT4 | 10 | SYST_LONG | ||||
END_T5 | End table 5 | CFEND_T5 | INT4 | 10 | SYST_LONG | ||||
ARBGB | Application Area | ARBGB | CHAR | 20 | Assigned to domain | ARBGB | MAG | ||
MSGNR | Message number | MSGNR | CHAR | 3 | Assigned to domain | MSGNR | |||
MSGV1 | Message variable 01 | MSGV1 | CHAR | 50 | CHAR50 | ||||
MSGV2 | Message variable 02 | MSGV2 | CHAR | 50 | CHAR50 | ||||
MSGV3 | Message variable 03 | MSGV3 | CHAR | 50 | CHAR50 | ||||
MSGV4 | Message variable 04 | MSGV4 | CHAR | 50 | CHAR50 | ||||
WTYPE | Window Type | CFWTYPE | CHAR | 4 | CHAR4 | ||||
TITL | Title of graphic | CFTITL | CHAR | 60 | TXT60 | ||||
VALT | Scale description (Qty or currency unit) | CFVALT | CHAR | 5 | TEXT5 | ||||
DIM1 | Description of 1st dimension in graphic | CFDIM1 | CHAR | 20 | TXT20 | ||||
DIM2 | Description of 2nd dimension in graphic | CFDIM2 | CHAR | 20 | TXT20 | ||||
MAX1 | Number of char. values in 1st dimension (graphic) | CFMAX1 | NUMC | 2 | NUM2 | ||||
MAX2 | Number of char. values in 2nd dimension (graphic) | CFMAX2 | NUMC | 2 | NUM2 | ||||
ATYPE | Statistic type (Statistic graphics) | CFATYPE | CHAR | 4 | CHAR4 | ||||
ZMODE | Reference axis subdivision | CFZMODE | CHAR | 3 | CHAR3 | ||||
XCTKS | Number of sections along X-axis | CFXCTKS | NUMC | 8 | NUM8 | ||||
TAXIS | Text for reference axis (statistic graphics) | CFTAXIS | CHAR | 20 | TEXT20 | ||||
TUNIT | Unit | CFUNIT | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
TABL_X | X coordinates for row/column str. | RKE_TABL_X | INT4 | 10 | INT4 | ||||
TABL_Y | Y coordinates for row/column str. | RKE_TABL_Y | INT4 | 10 | INT4 | ||||
FZWERT | Field Name | FIELDNAME | CHAR | 30 | Assigned to domain | FDNAME | DFD | ||
BTABL_X | X coordinates for row/column str. | RKE_TABL_X | INT4 | 10 | INT4 | ||||
BTABL_Y | Y coordinates for row/column str. | RKE_TABL_Y | INT4 | 10 | INT4 | ||||
BFZWERT | Field Name | FIELDNAME | CHAR | 30 | Assigned to domain | FDNAME | DFD | ||
XY | Flag: X-axis or Y-axis | CFXY | CHAR | 1 | CHAR1 | ||||
BKZ | Row type | CFBKZ | CHAR | 1 | CHAR1 | ||||
OTABL_X | X coordinates for row/column str. | RKE_TABL_X | INT4 | 10 | INT4 | ||||
OTABL_Y | Y coordinates for row/column str. | RKE_TABL_Y | INT4 | 10 | INT4 | ||||
OFZWERT | Field Name | FIELDNAME | CHAR | 30 | Assigned to domain | FDNAME | DFD | ||
DIMPR | Characteristic display | CGSDIMPRN | NUMC | 1 | NUMC1 | ||||
OBJFORM | Possible shapes of portfolio graphic element | CFOBJFORM | CHAR | 20 | TEXT20 | OFM | |||
FILLCLR | Filler color for portfolio graphic elements | CFFILLCLR | CHAR | 20 | TEXT20 | FLC | |||
TEXTCLR | Text color for portfolio graphic elements | CFTEXTCLR | CHAR | 20 | TEXT20 | ||||
SEGMENT_1 | Row/column number for values in first segment | CFSEGM_1 | INT4 | 10 | CFINT4 | SE1 | |||
SEGMENT_2 | Row/column number for values in second segment | CFSEGM_2 | INT4 | 10 | CFINT4 | SE2 | |||
SEGMENT_3 | Row/column number for values in third segment | CFSEGM_3 | INT4 | 10 | CFINT4 | SE3 | |||
SEGMENT_4 | Row/column number for values in fourth segment | CFSEGM_4 | INT4 | 10 | CFINT4 | SE4 | |||
WBNR_GR | Ref. row/column number for the size of the portfolio object | CFSPNR_GR | INT4 | 10 | INT4 | NRG | |||
WBNR_XACHS | Row/column number of X-axis values | CFSPNR_X | INT4 | 10 | CFINT4 | NRX | |||
WBNR_YACHS | Row/column number of Y-axis values | CFSPNR_Y | INT4 | 10 | CFINT4 | NRY | |||
TREND_X | X values for trend display | CFTREND_X | INT4 | 10 | CFINT4 | TRX | |||
TREND_Y | Y values for trend | CFTREND_Y | INT4 | 10 | CFINT4 | TRY | |||
GRID_X | Horizontal grid lines for X-axis | CFGRID_X | CHAR | 3 | CHAR3 | G_X | |||
GRID_Y | Vertical grid lines for Y-axis | CFGRID_Y | CHAR | 3 | CHAR3 | G_Y | |||
WB_POS | Value Base for the Portfolio Graphics | CFWERTBEZ | CHAR | 1 | CFBEZUG | WBE | |||
FIXGROESSE | Basic size for portfolio objects | CFFIXGR | CHAR | 2 | CFFIX | FIX | |||
HDAR | BRST Presentation type for hierarchies | RSTPRSTN | NUMC | 1 | RSTPRSTN | ||||
HDIR | Sort direction | RKE_ASCDES | CHAR | 1 | RKE_ASCDES | ||||
BST | Table flag | CFBST | CHAR | 1 | CHAR1 | ||||
TYPE | Node type | SEU_TYPE | CHAR | 4 | SEU_TYPE | ||||
TABNM | Table Name | TABNAME | CHAR | 30 | Assigned to domain | AS4TAB | DTB | ||
FIENM | Field Name | FIELDNAME | CHAR | 30 | Assigned to domain | FDNAME | DFD | ||
SLEVEL | BRST start level for hierarchy display | RSTSLEVEL | NUMC | 2 | RSTSLEVEL | ||||
COLOR | Color in hierarchy graphic | CFCOLORHIE | CHAR | 2 | COLORHIE | ||||
SUMME | Position of results row | CFSUMME | CHAR | 1 | CFSUMME | ||||
PARTIALSUM | Subtotal and remainder display | CFPARTIALSUM | CHAR | 1 | CFPARTIALSUM | ||||
HCLASS | BRST Class of hierarchies (Sets, etc.) | RSTHCLASS | CHAR | 4 | Assigned to domain | RSTHCLASS | |||
HIENM | Name of hierarchy | HIERANM | CHAR | 30 | Assigned to domain | HIERANM | |||
IND_OPT_FROM | From index for table of graphic options | CFINDOPTFROM | NUMC | 8 | NUMC8 | ||||
IND_OPT_TO | To index for table of graphic options | CFINDOPTTO | NUMC | 8 | NUMC8 | ||||
DVORZE | +/- sign display in drill down reporting | CFDVORZE | CHAR | 1 | CFDVORZE | ||||
UNITLENGTH | Output length of unit | CFUNITLENGTH | INT4 | 10 | CFINT4 | ||||
ON_OFF | Unit Display (Currency Unit/Unit of Measure) | CFDISPUNIT | CHAR | 1 | XFELD |
Key field | Non-key field |
How do I retrieve data from SAP structure CFTRACE using ABAP code?
As CFTRACE 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 CFTRACE as there is no data to select.How to access SAP table CFTRACE
Within an ECC or HANA version of SAP you can also view further information about CFTRACE and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects