LVC_S_FCAT_DB2 SAP (ALV Control: Field Catalog) Structure details
Description: ALV Control: Field Catalog
Related tables to LVC_S_FCAT_DB2
Access table LVC_S_FCAT_DB2
Structure field list including key, data, relationships and ABAP select examples
LVC_S_FCAT_DB2 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 "ALV Control: Field Catalog" 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_LVC_S_FCAT_DB2 TYPE LVC_S_FCAT_DB2.
The LVC_S_FCAT_DB2 table consists of various fields, each holding specific information or linking keys about ALV Control: Field Catalog data available in SAP. These include ROW_POS (ALV control: Output line (INTERNAL USE)), COL_POS (ALV control: Output column), FIELDNAME (ALV Control: Field Name of Internal Table Field), TABNAME (LVC tab 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: Can be enhanced (character-type or numeric)
SAP LVC_S_FCAT_DB2 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 |
ROW_POS | ALV control: Output line (INTERNAL USE) | LVC_ROWPOS | INT4 | 10 | |||||
COL_POS | ALV control: Output column | LVC_COLPOS | INT4 | 10 | |||||
FIELDNAME | ALV Control: Field Name of Internal Table Field | LVC_FNAME_DB2 | CHAR | 128 | CHAR128 | ||||
TABNAME | LVC tab name | LVC_TNAME | CHAR | 30 | |||||
CURRENCY | ALV control: Currency unit | LVC_CURR | CHAR | 5 | CHAR5 | ||||
CFIELDNAME | ALV control: Field name for currency unit referenced | LVC_CFNAME | CHAR | 30 | CHAR30 | ||||
QUANTITY | ALV control: Unit of measure | LVC_QUAN | CHAR | 3 | CHAR3 | ||||
QFIELDNAME | ALV control: Field name for unit of measure referenced | LVC_QFNAME | CHAR | 30 | CHAR30 | ||||
IFIELDNAME | ALV Control: Field Name of Internal Table Field | LVC_FNAME_DB2 | CHAR | 128 | CHAR128 | ||||
ROUND | ALV control: ROUND value | LVC_ROUND | INT4 | 10 | |||||
EXPONENT | ALV control: Exponent for float representation | LVC_EXPONT | CHAR | 3 | CHAR3 | ||||
KEY | ALV control: Key field | LVC_KEY | CHAR | 1 | CHAR1 | ||||
KEY_SEL | ALV control: Key column that may be hidden | LVC_KEYSEL | CHAR | 1 | CHAR1 | ||||
ICON | ALV control: Output as icon | LVC_ICON | CHAR | 1 | XFLAG | ||||
SYMBOL | ALV control: Output as symbol | LVC_SYMBOL | CHAR | 1 | CHAR1 | ||||
CHECKBOX | ALV control: Output as checkbox | LVC_CHECKB | CHAR | 1 | XFLAG | ||||
JUST | ALV control: Alignment | LVC_JUST | CHAR | 1 | CHAR1 | ||||
LZERO | ALV control: Output leading zeros | LVC_LZERO | CHAR | 1 | XFLAG | ||||
NO_SIGN | ALV Control: Suppress Signs for Output | LVC_NOSIGN | CHAR | 1 | XFLAG | ||||
NO_ZERO | ALV control: Suppress zeros for output | LVC_NOZERO | CHAR | 1 | XFLAG | ||||
NO_CONVEXT | ALV control: Do not consider conversion exit for output | LVC_NOCONV | CHAR | 1 | CHAR01 | ||||
EDIT_MASK | ALV control: EditMask for output | LVC_EDTMSK | CHAR | 60 | CHAR60 | ||||
EMPHASIZE | ALV control: Highlight column with color | LVC_EMPHSZ | CHAR | 4 | CHAR4 | ||||
FIX_COLUMN | ALV Control: Fix Column | LVC_FIXCOL | CHAR | 1 | XFLAG | ||||
DO_SUM | ALV control: Aggregate values of column | LVC_DOSUM | CHAR | 1 | XFLAG | ||||
NO_SUM | ALV control: No aggregation over values of column | LVC_NOSUM | CHAR | 1 | XFLAG | ||||
NO_OUT | ALV control: Column is not output | LVC_NOOUT | CHAR | 1 | CHAR1 | ||||
TECH | ALV control: Technical field | LVC_TECH | CHAR | 1 | XFLAG | ||||
OUTPUTLEN | ALV control: Column width in characters | LVC_OUTLEN | NUMC | 6 | DDLENG | ||||
CONVEXIT | Conversion Routine | CONVEXIT | CHAR | 5 | CONVEXIT | ||||
SELTEXT | ALV control: Column identifier for dialog functions | LVC_TXT | CHAR | 40 | TEXT40 | ||||
TOOLTIP | ALV control: Tool tip for column header | LVC_TIP | CHAR | 40 | TEXT40 | ||||
ROLLNAME | ALV control: Data element for F1 help | LVC_ROLL | CHAR | 30 | Assigned to domain | ROLLNAME | |||
DATATYPE | Data Type in ABAP Dictionary | DATATYPE_D | CHAR | 4 | DTYPE | DATATYPE | |||
INTTYPE | ABAP data type (C,D,N,...) | INTTYPE | CHAR | 1 | INTTYPE | ||||
INTLEN | Internal Length in Bytes | INTLEN | NUMC | 6 | DDLENG | ||||
LOWERCASE | Lowercase letters allowed/not allowed | LOWERCASE | CHAR | 1 | AS4FLAG | ||||
REPTEXT | Heading | REPTEXT | CHAR | 55 | REPTEXT | ||||
HIER_LEVEL | ALV control: Internal use | LVC_HIERL | INT4 | 10 | |||||
REPREP | ALV control: Value is selection criterion for rep./rep.intf. | LVC_CRPRP | CHAR | 1 | CHAR1 | ||||
DOMNAME | Domain name | DOMNAME | CHAR | 30 | Assigned to domain | DOMNAME | DD_DOMA | ||
SP_GROUP | Group key | LVC_SPGRP | CHAR | 4 | CHAR4 | ||||
HOTSPOT | ALV control: SingleClick-sensitive | LVC_HOTSPT | CHAR | 1 | CHAR1 | ||||
DFIELDNAME | ALV control: Field name for column group in database | LVCDBGFN | CHAR | 30 | CHAR30 | ||||
COL_ID | ALV control: Column ID | LVC_COLID | INT4 | 10 | |||||
F4AVAILABL | Does the field have an input help | DDF4AVAIL | CHAR | 1 | DDBOOL | ||||
AUTO_VALUE | ALV control: Automatic value copy | LVC_AUTO | CHAR | 1 | CHAR01 | ||||
CHECKTABLE | Table Name | TABNAME | CHAR | 30 | Assigned to domain | AS4TAB | DTB | ||
VALEXI | Existence of fixed values | VALEXI | CHAR | 1 | AS4FLAG | ||||
WEB_FIELD | ALV control: Field name of internal table field | LVC_FNAME | CHAR | 30 | CHAR30 | ||||
HREF_HNDL | Natural Number | INT4 | INT4 | 10 | INT4 | ||||
STYLE | ALV control: Style | LVC_STYLE | RAW | 4 | HEX4 | ||||
STYLE2 | ALV control: Style | LVC_STYLE | RAW | 4 | HEX4 | ||||
STYLE3 | ALV control: Style | LVC_STYLE | RAW | 4 | HEX4 | ||||
STYLE4 | ALV control: Style | LVC_STYLE | RAW | 4 | HEX4 | ||||
DRDN_HNDL | Natural Number | INT4 | INT4 | 10 | INT4 | ||||
DRDN_FIELD | ALV control: Field name of internal table field | LVC_FNAME | CHAR | 30 | CHAR30 | ||||
NO_MERGING | Character Field Length 1 | CHAR01 | CHAR | 1 | CHAR1 | ||||
H_FTYPE | ALV tree control: Functional type (sum, avg, max, min, ...) | LVC_FTYPE | CHAR | 3 | |||||
COL_OPT | Entry for Optional Column Optimization | LVC_COLOPT | CHAR | 1 | LVC_COLOPT | ||||
NO_INIT_CH | Character Field Length 1 | CHAR01 | CHAR | 1 | CHAR1 | ||||
DRDN_ALIAS | Character Field Length 1 | CHAR01 | CHAR | 1 | CHAR1 | ||||
REF_FIELD | ALV control: Reference field name for internal table field | LVC_RFNAME | CHAR | 30 | CHAR30 | ||||
REF_TABLE | ALV control: Reference table name for internal table field | LVC_RTNAME | CHAR | 30 | CHAR30 | ||||
TXT_FIELD | ALV control: Field name of internal table field | LVC_FNAME | CHAR | 30 | CHAR30 | ||||
ROUNDFIELD | ALV control: Field name with ROUND specification | LVC_RNDFN | CHAR | 30 | CHAR30 | ||||
DECIMALS_O | ALV control: Number of decimal places for output | LVC_DECMLS | CHAR | 6 | CHAR6 | ||||
DECMLFIELD | ALV control: Field name with DECIMALS specification | LVC_DFNAME | CHAR | 30 | CHAR30 | ||||
DD_OUTLEN | ALV control: Output length in characters | LVC_DDLEN | NUMC | 6 | DDLENG | ||||
DECIMALS | Number of Decimal Places | DECIMALS | NUMC | 6 | DDLENG | ||||
COLTEXT | ALV control: Column heading | LVC_TXTCOL | CHAR | 40 | TEXT40 | ||||
SCRTEXT_L | Long Field Label | SCRTEXT_L | CHAR | 40 | SCRTEXT_L | ||||
SCRTEXT_M | Medium Field Label | SCRTEXT_M | CHAR | 20 | SCRTEXT_M | ||||
SCRTEXT_S | Short Field Label | SCRTEXT_S | CHAR | 10 | SCRTEXT_S | ||||
COLDDICTXT | ALV control: Determine DDIC text reference | LVC_DDICT | CHAR | 1 | CHAR1 | ||||
SELDDICTXT | ALV control: Determine DDIC text reference | LVC_DDICT | CHAR | 1 | CHAR1 | ||||
TIPDDICTXT | ALV control: Determine DDIC text reference | LVC_DDICT | CHAR | 1 | CHAR1 | ||||
EDIT | ALV control: Ready for input | LVC_EDIT | CHAR | 1 | CHAR01 | ||||
TECH_COL | ALV control: Internal use | LVC_TCOL | INT4 | 10 | |||||
TECH_FORM | ALV control: Internal use | LVC_TFORM | INT4 | 10 | |||||
TECH_COMP | ALV control: Internal use | LVC_TCOMP | CHAR | 1 | XFLAG | ||||
HIER_CPOS | ALV control: Hierarchical column position | LVCHCOLPOS | INT2 | 5 | INT2 | ||||
H_COL_KEY | Tree Control: Column Name / Item Name | TV_ITMNAME | CHAR | 12 | TM_CHAR12 | ||||
H_SELECT | Indicates if a column in the tree control can be selected | LVC_SELECT | CHAR | 1 | CHAR1 | ||||
DD_ROLL | Data element (semantic domain) | ROLLNAME | CHAR | 30 | Assigned to domain | ROLLNAME | ROL | DD_DTEL | |
DRAGDROPID | ALV control: Drag&Drop handle for DragDrop object | LVC_DDID | INT4 | 10 | |||||
MAC | Character Field Length 1 | CHAR01 | CHAR | 1 | CHAR1 | ||||
INDX_FIELD | Natural Number | INT4 | INT4 | 10 | INT4 | ||||
INDX_CFIEL | Natural Number | INT4 | INT4 | 10 | INT4 | ||||
INDX_QFIEL | Natural Number | INT4 | INT4 | 10 | INT4 | ||||
INDX_IFIEL | Natural Number | INT4 | INT4 | 10 | INT4 | ||||
INDX_ROUND | Natural Number | INT4 | INT4 | 10 | INT4 | ||||
INDX_DECML | Natural Number | INT4 | INT4 | 10 | INT4 | ||||
GET_STYLE | Character Field Length 1 | CHAR01 | CHAR | 1 | CHAR1 | ||||
MARK | Character Field Length 1 | CHAR01 | CHAR | 1 | CHAR1 |
Key field | Non-key field |
How do I retrieve data from SAP structure LVC_S_FCAT_DB2 using ABAP code?
As LVC_S_FCAT_DB2 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 LVC_S_FCAT_DB2 as there is no data to select.How to access SAP table LVC_S_FCAT_DB2
Within an ECC or HANA version of SAP you can also view further information about LVC_S_FCAT_DB2 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