1. Home
  2. Resources
  3. SAP Tables
  4. RGFKEY - FI-SL Installation: Foreign Key Relationship

SAP Table RGFKEY

FI-SL Installation: Foreign Key Relationship

RGFKEY (FI-SL Installation: Foreign Key Relationship) 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 RGFKEY to other SAP tables.

RGFKEY table fields

Field Data element Checktable Datatype Length Decimals
FRKART Dependency factor for semantic foreign keys FRKART CHAR 4 0
OPT Optional foreign key
OBL Mandatory foreign key
ID Identifying foreign key
TEXT Foreign key for a text table
CARD Cardinality of a relationship CARD CHAR 2 0
CN Each record in check table has any no. of dependent records
C Each record in check table has max. of one dependent record
N Each record in check table has at least one dependent record
1 Each record in check table has exactly one dependent record
CHECKTABLE Check table name of the foreign key CHECKTABLE CHAR 30 0
FORTABLE Table of the foreign key field FORTABLE CHAR 30 0
FORKEY Names of Foreign Key Fields FORKEY CHAR 30 0
CHECKFIELD Field Name FIELDNAME CHAR 30 0
CHECKFLAG No check in Screen Painter CHECKFLAG CHAR 1 0
NULL Do not set flag
X Set flag
DDTEXT Explanatory short text DDTEXT CHAR 60 0
DOMNAME Domain name DOMNAME CHAR 30 0
PRIMPOS Position of corresp. foreign key field in primary key PRIMPOS NUMC 4 0
CARDLEFT Cardinality of a relationship CARDLEFT CHAR 2 0
1 Entry in check field must exist
C Entry in check field can exist
D_FRKART Foreign key field type: not specified D_FRKART CHAR 1 0
NULL No
. Default
X Selection
N_FRKART Foreign key field type: non-key-fields/candidates N_FRKART CHAR 1 0
NULL No
. Default
X Selection
K_FRKART Foreign key field type: key fields/candidates K_FRKART CHAR 1 0
NULL No
. Default
X Selection
T_FRKART Foreign key field type: key fields of a text table T_FRKART CHAR 1 0
NULL No
. Default
X Selection