LVC_S_FCAT_DB2 SAP (ALV Control: Field Catalog) Structure details

Dictionary Type: Structure
Description: ALV Control: Field Catalog




ABAP Code to SELECT data from LVC_S_FCAT_DB2
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_POSALV control: Output line (INTERNAL USE) LVC_ROWPOSINT410
COL_POSALV control: Output column LVC_COLPOSINT410
FIELDNAMEALV Control: Field Name of Internal Table Field LVC_FNAME_DB2CHAR128CHAR128
TABNAMELVC tab name LVC_TNAMECHAR30
CURRENCYALV control: Currency unit LVC_CURRCHAR5CHAR5
CFIELDNAMEALV control: Field name for currency unit referenced LVC_CFNAMECHAR30CHAR30
QUANTITYALV control: Unit of measure LVC_QUANCHAR3CHAR3
QFIELDNAMEALV control: Field name for unit of measure referenced LVC_QFNAMECHAR30CHAR30
IFIELDNAMEALV Control: Field Name of Internal Table Field LVC_FNAME_DB2CHAR128CHAR128
ROUNDALV control: ROUND value LVC_ROUNDINT410
EXPONENTALV control: Exponent for float representation LVC_EXPONTCHAR3CHAR3
KEYALV control: Key field LVC_KEYCHAR1CHAR1
KEY_SELALV control: Key column that may be hidden LVC_KEYSELCHAR1CHAR1
ICONALV control: Output as icon LVC_ICONCHAR1XFLAG
SYMBOLALV control: Output as symbol LVC_SYMBOLCHAR1CHAR1
CHECKBOXALV control: Output as checkbox LVC_CHECKBCHAR1XFLAG
JUSTALV control: Alignment LVC_JUSTCHAR1CHAR1
LZEROALV control: Output leading zeros LVC_LZEROCHAR1XFLAG
NO_SIGNALV Control: Suppress Signs for Output LVC_NOSIGNCHAR1XFLAG
NO_ZEROALV control: Suppress zeros for output LVC_NOZEROCHAR1XFLAG
NO_CONVEXTALV control: Do not consider conversion exit for output LVC_NOCONVCHAR1CHAR01
EDIT_MASKALV control: EditMask for output LVC_EDTMSKCHAR60CHAR60
EMPHASIZEALV control: Highlight column with color LVC_EMPHSZCHAR4CHAR4
FIX_COLUMNALV Control: Fix Column LVC_FIXCOLCHAR1XFLAG
DO_SUMALV control: Aggregate values of column LVC_DOSUMCHAR1XFLAG
NO_SUMALV control: No aggregation over values of column LVC_NOSUMCHAR1XFLAG
NO_OUTALV control: Column is not output LVC_NOOUTCHAR1CHAR1
TECHALV control: Technical field LVC_TECHCHAR1XFLAG
OUTPUTLENALV control: Column width in characters LVC_OUTLENNUMC6DDLENG
CONVEXITConversion Routine CONVEXITCHAR5CONVEXIT
SELTEXTALV control: Column identifier for dialog functions LVC_TXTCHAR40TEXT40
TOOLTIPALV control: Tool tip for column header LVC_TIPCHAR40TEXT40
ROLLNAMEALV control: Data element for F1 help LVC_ROLLCHAR30Assigned to domainROLLNAME
DATATYPEData Type in ABAP Dictionary DATATYPE_DCHAR4DTYPEDATATYPE
INTTYPEABAP data type (C,D,N,...) INTTYPECHAR1INTTYPE
INTLENInternal Length in Bytes INTLENNUMC6DDLENG
LOWERCASELowercase letters allowed/not allowed LOWERCASECHAR1AS4FLAG
REPTEXTHeading REPTEXTCHAR55REPTEXT
HIER_LEVELALV control: Internal use LVC_HIERLINT410
REPREPALV control: Value is selection criterion for rep./rep.intf. LVC_CRPRPCHAR1CHAR1
DOMNAMEDomain name DOMNAMECHAR30Assigned to domainDOMNAMEDD_DOMA
SP_GROUPGroup key LVC_SPGRPCHAR4CHAR4
HOTSPOTALV control: SingleClick-sensitive LVC_HOTSPTCHAR1CHAR1
DFIELDNAMEALV control: Field name for column group in database LVCDBGFNCHAR30CHAR30
COL_IDALV control: Column ID LVC_COLIDINT410
F4AVAILABLDoes the field have an input help DDF4AVAILCHAR1DDBOOL
AUTO_VALUEALV control: Automatic value copy LVC_AUTOCHAR1CHAR01
CHECKTABLETable Name TABNAMECHAR30Assigned to domainAS4TABDTB
VALEXIExistence of fixed values VALEXICHAR1AS4FLAG
WEB_FIELDALV control: Field name of internal table field LVC_FNAMECHAR30CHAR30
HREF_HNDLNatural Number INT4INT410INT4
STYLEALV control: Style LVC_STYLERAW4HEX4
STYLE2ALV control: Style LVC_STYLERAW4HEX4
STYLE3ALV control: Style LVC_STYLERAW4HEX4
STYLE4ALV control: Style LVC_STYLERAW4HEX4
DRDN_HNDLNatural Number INT4INT410INT4
DRDN_FIELDALV control: Field name of internal table field LVC_FNAMECHAR30CHAR30
NO_MERGINGCharacter Field Length 1 CHAR01CHAR1CHAR1
H_FTYPEALV tree control: Functional type (sum, avg, max, min, ...) LVC_FTYPECHAR3
COL_OPTEntry for Optional Column Optimization LVC_COLOPTCHAR1LVC_COLOPT
NO_INIT_CHCharacter Field Length 1 CHAR01CHAR1CHAR1
DRDN_ALIASCharacter Field Length 1 CHAR01CHAR1CHAR1
REF_FIELDALV control: Reference field name for internal table field LVC_RFNAMECHAR30CHAR30
REF_TABLEALV control: Reference table name for internal table field LVC_RTNAMECHAR30CHAR30
TXT_FIELDALV control: Field name of internal table field LVC_FNAMECHAR30CHAR30
ROUNDFIELDALV control: Field name with ROUND specification LVC_RNDFNCHAR30CHAR30
DECIMALS_OALV control: Number of decimal places for output LVC_DECMLSCHAR6CHAR6
DECMLFIELDALV control: Field name with DECIMALS specification LVC_DFNAMECHAR30CHAR30
DD_OUTLENALV control: Output length in characters LVC_DDLENNUMC6DDLENG
DECIMALSNumber of Decimal Places DECIMALSNUMC6DDLENG
COLTEXTALV control: Column heading LVC_TXTCOLCHAR40TEXT40
SCRTEXT_LLong Field Label SCRTEXT_LCHAR40SCRTEXT_L
SCRTEXT_MMedium Field Label SCRTEXT_MCHAR20SCRTEXT_M
SCRTEXT_SShort Field Label SCRTEXT_SCHAR10SCRTEXT_S
COLDDICTXTALV control: Determine DDIC text reference LVC_DDICTCHAR1CHAR1
SELDDICTXTALV control: Determine DDIC text reference LVC_DDICTCHAR1CHAR1
TIPDDICTXTALV control: Determine DDIC text reference LVC_DDICTCHAR1CHAR1
EDITALV control: Ready for input LVC_EDITCHAR1CHAR01
TECH_COLALV control: Internal use LVC_TCOLINT410
TECH_FORMALV control: Internal use LVC_TFORMINT410
TECH_COMPALV control: Internal use LVC_TCOMPCHAR1XFLAG
HIER_CPOSALV control: Hierarchical column position LVCHCOLPOSINT25INT2
H_COL_KEYTree Control: Column Name / Item Name TV_ITMNAMECHAR12TM_CHAR12
H_SELECTIndicates if a column in the tree control can be selected LVC_SELECTCHAR1CHAR1
DD_ROLLData element (semantic domain) ROLLNAMECHAR30Assigned to domainROLLNAMEROLDD_DTEL
DRAGDROPIDALV control: Drag&Drop handle for DragDrop object LVC_DDIDINT410
MACCharacter Field Length 1 CHAR01CHAR1CHAR1
INDX_FIELDNatural Number INT4INT410INT4
INDX_CFIELNatural Number INT4INT410INT4
INDX_QFIELNatural Number INT4INT410INT4
INDX_IFIELNatural Number INT4INT410INT4
INDX_ROUNDNatural Number INT4INT410INT4
INDX_DECMLNatural Number INT4INT410INT4
GET_STYLECharacter Field Length 1 CHAR01CHAR1CHAR1
MARKCharacter Field Length 1 CHAR01CHAR1CHAR1

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 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!