ALV_S_FCAT_DB2 SAP (Field Catalog (for LVC and for KKBLO)) Structure details
Description: Field Catalog (for LVC and for KKBLO)
Related tables to ALV_S_FCAT_DB2
Access table ALV_S_FCAT_DB2
Structure field list including key, data, relationships and ABAP select examples
ALV_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 "Field Catalog (for LVC and for KKBLO)" 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_ALV_S_FCAT_DB2 TYPE ALV_S_FCAT_DB2.
The ALV_S_FCAT_DB2 table consists of various fields, each holding specific information or linking keys about Field Catalog (for LVC and for KKBLO) data available in SAP. These include COL_POS (ALV control: Output column), FIELDNAME (ALV Control: Field Name of Internal Table Field), TABNAME (LVC tab name), CURRENCY (ALV control: Currency unit).. 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 ALV_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 |
Key field | Non-key field |
How do I retrieve data from SAP structure ALV_S_FCAT_DB2 using ABAP code?
As ALV_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 ALV_S_FCAT_DB2 as there is no data to select.How to access SAP table ALV_S_FCAT_DB2
Within an ECC or HANA version of SAP you can also view further information about ALV_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