1. Home
  2. Resources
  3. SAP Tables
  4. FINB_GN_INDX_SOURCE - Source Data of a Secondary Index

SAP Table FINB_GN_INDX_SOURCE

Source Data of a Secondary Index

FINB_GN_INDX_SOURCE (Source Data of a Secondary Index) 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 FINB_GN_INDX_SOURCE to other SAP tables.

FINB_GN_INDX_SOURCE table fields

Field Data element Checktable Datatype Length Decimals
HEADER DD12V STRU 0 0
SQLTAB Table Name TABNAME CHAR 30 0
INDEXNAME Unique Index ID in a Table INDEXID CHAR 3 0
AS4LOCAL Activation Status of a Repository Object AS4LOCAL CHAR 1 0
A Entry activated or generated in this form
L Lock entry (first N version)
N Entry edited, but not activated
S Previously active entry, backup copy
T Temporary version when editing
AS4VERS Version of the entry (not used) AS4VERS NUMC 4 0
DDLANGUAGE Language Key DDLANGUAGE LANG 1 0
AUTHCLASS Activation type AUTHCLASS_ NUMC 2 0
01 Nametab generation not in online (only via C program)
02 C structures must be adapted when tables are changed
10 Initial table required before R3TRANS runs
00 No classification
UNIQUEFLAG Flag for UNIQUE indexes UNIQUEFLAG CHAR 1 0
NULL Do not set flag
X Set flag
AS4USER Last Changed by AS4USER CHAR 12 0
AS4DATE Date of Last Change AS4DATE DATS 8 0
AS4TIME Last changed at AS4TIME TIMS 6 0
ACTFLAG Activation flag ACTFLAG CHAR 1 0
NULL Start of activation or activation successful
I Internal checks successful
U External checks for object OK or table as dependent faulty
DBINDEX Database index DBINDEX_D CHAR 18 0
DBSTATE Status of index on the database DDIXDBSTAT CHAR 1 0
NULL Create on database
O Do not create on database
D Create on database depending on DB system
DBINCLEXCL List of DB systems used as list of inclusions/exclusions DDIXINCEX CHAR 1 0
I List of inclusions: Create index on these DB systems
E List of exclusions: Do not create index on these DB systems
DBSYSSEL1 Choose a database system for DB-specific indexes DDIXDBSEL CHAR 3 0
ADA ADABAS D
DB2 DB2 for MVS
DB4 DB2 for AS/400
DB6 DB2 common server
INF INFORMIX
MSS MSS SQL Server
ORA ORACLE
SYB SYBASE
HDB SAP HANA Database
DBSYSSEL2 Choose a database system for DB-specific indexes DDIXDBSEL CHAR 3 0
ADA ADABAS D
DB2 DB2 for MVS
DB4 DB2 for AS/400
DB6 DB2 common server
INF INFORMIX
MSS MSS SQL Server
ORA ORACLE
SYB SYBASE
HDB SAP HANA Database
DBSYSSEL3 Choose a database system for DB-specific indexes DDIXDBSEL CHAR 3 0
ADA ADABAS D
DB2 DB2 for MVS
DB4 DB2 for AS/400
DB6 DB2 common server
INF INFORMIX
MSS MSS SQL Server
ORA ORACLE
SYB SYBASE
HDB SAP HANA Database
DBSYSSEL4 Choose a database system for DB-specific indexes DDIXDBSEL CHAR 3 0
ADA ADABAS D
DB2 DB2 for MVS
DB4 DB2 for AS/400
DB6 DB2 common server
INF INFORMIX
MSS MSS SQL Server
ORA ORACLE
SYB SYBASE
HDB SAP HANA Database
DDTEXT Explanatory short text DDTEXT CHAR 60 0
ISEXTIND DD: Flag if index is extension index DDISEXTIND CHAR 1 0
FULL_TEXT DD: Full Text Index DDFULLTEXT CHAR 1 0
HEADER_CHANGED Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') BOOLE_D CHAR 1 0
X TRUE
NULL FALSE
T_FIELDS FINB_GN_T_INDX_FIELDS TTYP 0 0
FIELDS_CHANGED Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') BOOLE_D CHAR 1 0
X TRUE
NULL FALSE