1. Home
  2. Resources
  3. SAP Tables
  4. ALV_S_FCAT_DB2 - Field Catalog (for LVC and for KKBLO)

SAP Table ALV_S_FCAT_DB2

Field Catalog (for LVC and for KKBLO)

ALV_S_FCAT_DB2 (Field Catalog (for LVC and for KKBLO)) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link ALV_S_FCAT_DB2 to other SAP tables.

ALV_S_FCAT_DB2 table fields

Field Data element Checktable Datatype Length Decimals
ROW_POS ALV control: Output line (INTERNAL USE) LVC_ROWPOS INT4 10 0
COL_POS ALV control: Output column LVC_COLPOS INT4 10 0
FIELDNAME ALV Control: Field Name of Internal Table Field LVC_FNAME_DB2 CHAR 128 0
TABNAME LVC tab name LVC_TNAME CHAR 30 0
CURRENCY ALV control: Currency unit LVC_CURR CHAR 5 0
CFIELDNAME ALV control: Field name for currency unit referenced LVC_CFNAME CHAR 30 0
QUANTITY ALV control: Unit of measure LVC_QUAN CHAR 3 0
QFIELDNAME ALV control: Field name for unit of measure referenced LVC_QFNAME CHAR 30 0
IFIELDNAME ALV Control: Field Name of Internal Table Field LVC_FNAME_DB2 CHAR 128 0
ROUND ALV control: ROUND value LVC_ROUND INT4 10 0
EXPONENT ALV control: Exponent for float representation LVC_EXPONT CHAR 3 0
KEY ALV control: Key field LVC_KEY CHAR 1 0
KEY_SEL ALV control: Key column that may be hidden LVC_KEYSEL CHAR 1 0
ICON ALV control: Output as icon LVC_ICON CHAR 1 0
NULL Blank
. Radio button
X Selection
SYMBOL ALV control: Output as symbol LVC_SYMBOL CHAR 1 0
CHECKBOX ALV control: Output as checkbox LVC_CHECKB CHAR 1 0
NULL Blank
. Radio button
X Selection
JUST ALV control: Alignment LVC_JUST CHAR 1 0
LZERO ALV control: Output leading zeros LVC_LZERO CHAR 1 0
NULL Blank
. Radio button
X Selection
NO_SIGN ALV Control: Suppress Signs for Output LVC_NOSIGN CHAR 1 0
NULL Blank
. Radio button
X Selection
NO_ZERO ALV control: Suppress zeros for output LVC_NOZERO CHAR 1 0
NULL Blank
. Radio button
X Selection
NO_CONVEXT ALV control: Do not consider conversion exit for output LVC_NOCONV CHAR 1 0
EDIT_MASK ALV control: EditMask for output LVC_EDTMSK CHAR 60 0
EMPHASIZE ALV control: Highlight column with color LVC_EMPHSZ CHAR 4 0
FIX_COLUMN ALV Control: Fix Column LVC_FIXCOL CHAR 1 0
NULL Blank
. Radio button
X Selection
DO_SUM ALV control: Aggregate values of column LVC_DOSUM CHAR 1 0
NULL Blank
. Radio button
X Selection
NO_SUM ALV control: No aggregation over values of column LVC_NOSUM CHAR 1 0
NULL Blank
. Radio button
X Selection
NO_OUT ALV control: Column is not output LVC_NOOUT CHAR 1 0
TECH ALV control: Technical field LVC_TECH CHAR 1 0
NULL Blank
. Radio button
X Selection
OUTPUTLEN ALV control: Column width in characters LVC_OUTLEN NUMC 6 0
CONVEXIT Conversion Routine CONVEXIT CHAR 5 0
SELTEXT ALV control: Column identifier for dialog functions LVC_TXT CHAR 40 0
TOOLTIP ALV control: Tool tip for column header LVC_TIP CHAR 40 0
ROLLNAME ALV control: Data element for F1 help LVC_ROLL CHAR 30 0
DATATYPE Data Type in ABAP Dictionary DATATYPE_D CHAR 4 0
ACCP Posting period YYYYMM
CHAR Character String
CLNT Client
CUKY Currency key, referenced by CURR fields
CURR Currency field, stored as DEC
D16D Decimal Floating Point, 16 Digits, DEC on Database
D16R Decimal Floating Point, 16 Digits, RAW on Database
D16S Decimal Floating Point. 16 Digits, with Scale Field
D34D Decimal Floating Point, 34 Digits, DEC on Database
D34R Decimal Floating Point, 34 Digits, RAW on Database
D34S Decimal Floating Point, 34 Digits, with Scale Field
DATS Date field (YYYYMMDD) stored as char(8)
DEC Counter or amount field with comma and sign
FLTP Floating point number, accurate to 8 bytes
INT1 1-byte integer, integer number <= 255
INT2 2-byte integer, only for length field before LCHR or LRAW
INT4 4-byte integer, integer number with sign
LANG Language key
LCHR Long character string, requires preceding INT2 field
LRAW Long byte string, requires preceding INT2 field
NUMC Character string with only digits
PREC Obsolete data type, do not use
QUAN Quantity field, points to a unit field with format UNIT
RAW Uninterpreted sequence of bytes
RSTR Byte String of Variable Length
SSTR Short Character String of Variable Length
STRG Character String of Variable Length
TIMS Time field (hhmmss), stored as char(6)
UNIT Unit key for QUAN fields
VARC Long character string, no longer supported from Rel. 3.0
INTTYPE ABAP data type (C,D,N,...) INTTYPE CHAR 1 0
C Character String
N Character String with Digits Only
D Date (Date: YYYYMMDD)
T Time (Time: HHMMSS)
X Byte Seq. (heXadecimal), in DDIC metadata also for INT1/2/4
I Integer number (4-byte integer with sign)
b 1-byte integer, integer number <= 254
s 2-byte integer, only for length field before LCHR or LRAW
P Packed number
F Floating point number to accuracy of 8 bytes
g Character string with variable length (ABAP type STRING)
y Byte sequence with variable length (ABAP type XSTRING)
u Structured type, flat
v Structured type, deep
h Table type
V Character string (old Dictionary type VARC)
r Reference to class/interface
l Reference to data object
a Decimal Floating Point Number, 16 Digits
e Decimal Floating Point Number, 34 Digits
j Static Boxed Components
k Generic Boxed Components
INTLEN Internal Length in Bytes INTLEN NUMC 6 0
LOWERCASE Lowercase letters allowed/not allowed LOWERCASE CHAR 1 0
NULL Do not set flag
X Set flag
REPTEXT Heading REPTEXT CHAR 55 0
HIER_LEVEL ALV control: Internal use LVC_HIERL INT4 10 0
REPREP ALV control: Value is selection criterion for rep./rep.intf. LVC_CRPRP CHAR 1 0
DOMNAME Domain name DOMNAME CHAR 30 0
SP_GROUP Group key LVC_SPGRP CHAR 4 0
HOTSPOT ALV control: SingleClick-sensitive LVC_HOTSPT CHAR 1 0
DFIELDNAME ALV control: Field name for column group in database LVCDBGFN CHAR 30 0
COL_ID ALV control: Column ID LVC_COLID INT4 10 0
F4AVAILABL Does the field have an input help DDF4AVAIL CHAR 1 0
NULL FALSE
X TRUE
AUTO_VALUE ALV control: Automatic value copy LVC_AUTO CHAR 1 0
CHECKTABLE Table Name TABNAME CHAR 30 0
VALEXI Existence of fixed values VALEXI CHAR 1 0
NULL Do not set flag
X Set flag
WEB_FIELD ALV control: Field name of internal table field LVC_FNAME CHAR 30 0
HREF_HNDL Natural Number INT4 INT4 10 0
STYLE ALV control: Style LVC_STYLE RAW 4 0
STYLE2 ALV control: Style LVC_STYLE RAW 4 0
STYLE3 ALV control: Style LVC_STYLE RAW 4 0
STYLE4 ALV control: Style LVC_STYLE RAW 4 0
DRDN_HNDL Natural Number INT4 INT4 10 0
DRDN_FIELD ALV control: Field name of internal table field LVC_FNAME CHAR 30 0
NO_MERGING Character Field Length 1 CHAR01 CHAR 1 0
H_FTYPE ALV tree control: Functional type (sum, avg, max, min, ...) LVC_FTYPE CHAR 3 0
COL_OPT Entry for Optional Column Optimization LVC_COLOPT CHAR 1 0
X Optimization Is Kept Until the First Interaction
A Optimization Is Kept Always
NULL No Optimization
NO_INIT_CH Character Field Length 1 CHAR01 CHAR 1 0
DRDN_ALIAS Character Field Length 1 CHAR01 CHAR 1 0