1. Home
  2. Resources
  3. SAP Tables
  4. ZFDB_RGCNSEQ4 - SMX: FDB Clinical Formulation ID Attributes

SAP Table ZFDB_RGCNSEQ4

SMX: FDB Clinical Formulation ID Attributes

ZFDB_RGCNSEQ4 (SMX: FDB Clinical Formulation ID Attributes) 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 ZFDB_RGCNSEQ4 to other SAP tables.

ZFDB_RGCNSEQ4 table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT CLNT 3 0
GCN_SEQNO SMX: FDB GCN - Clinical Formulation ID ( (Stable ID) ZFDB_GCN_SEQNO CHAR 6 0
HIC3 SMX: FDB Hier. Specific Therapeutic Class Code (Stable ID) ZFDB_HIC3 CHAR 3 0
HICL_SEQNO SMX: FDB Ingredient List Identifier ZFDB_HICL_SEQNO ZFDB_RHICLSQ1 CHAR 6 0
GCDF SMX: FDB Dosage Form Code (2 character) ZFDB_GCDF ZFDB_RDOSED2 CHAR 2 0
GCRT SMX: FDB Route of Administration Code ZFDB_GCRT ZFDB_RROUTED3 CHAR 1 0
STR SMX: FDB Drug Strength Description ZFDB_STR CHAR 10 0
GTC SMX: FDB Therapeutic Class Code, Generic ZFDB_GTC CHAR 2 0
02 ANALGESICS
03 ANALGESIC AND ANTIHISTAMINE COMBINATION
05 ANESTHETICS
08 ANTI-OBESTITY DRUGS
09 ANTIDOTES
11 ANTIARTHRITICS
14 ANTIASTHMATICS
17 ANTIHISTAMINES
18 ANTIHISTAMINE AND DECONGESTANT COMBINATION
20 ANTIINFECTIVES
23 ANTIINFECTIVES/MISCELLANEOUS
26 ANTINEOPLASTICS
29 ANTIPARKINSON DRUGS
32 AUTONOMIC DRUGS
35 BLOOD
38 CARDIAC DRUGS
41 CARDIOVASCULAR
44 CNS DRUGS
47 CONTRACEPTIVES
50 COUGH/COLD PREPARATIONS
53 DIAGNOSTIC
56 DIURETICS
59 ELECT/CALORIC/H2O
62 EENT PREPS
65 GASTROINTESTINAL
68 HORMONES
71 HYPOGLYCEMICS
72 IMMUNOSUPPRESANT
74 MISCELLANEOUS MEDICAL SUPPLIES, DEVICES, NON-DRUG
77 MUSCLE RELAXANTS
80 PSYCHOTHERAPEUTIC DRUGS
83 SEDATIVE/HYPNOTICS
86 SKIN PREPS
89 THYROID PREPS
92 BIOLOGICALS
94 PRE-NATAL VITAMINS
95 VITAMINS
97 SMOKING DETERRENTS
98 HERBALS
99 UNCLASSIFIED DRUG PRODUCTS
TC SMX: FDB Therapeutic Class Code, , Standard ZFDB_TC ZFDB_RTCD0 CHAR 2 0
DCC SMX: FDB Drug Category Code ZFDB_DCC CHAR 1 0
0 UNSPECIFIED
1 DRUGS TO TREAT IMPOTENCY
2 GROWTH HORMONE, GHRH, AND RELATED AGENTS
3 NARCOLEPSY AND SLEEP DISORDER THERAPY
A ANTI-ANXIETY AGENTS
B FERTILITY AGENTS
C CONTRACEPTIVES, ORAL
D DIAGNOSTICS
E FLUORIDE PREPARATIONS (EXCL.VIT.COMB.)
F ANTIOBESITY DRUGS
G ANTACIDS
H HEMATINICS
I INSULINS
J SMOKING DETERRENTS
K AIDS RELATED
L LAXATIVES
M REUSABLE NEEDLES (ALL)
N DISPOSABLE NEEDLES (ALL)
O REUS.SYRINGES W/WO NEEDLES (NON-INSULIN)
P DISP.SYRINGES W/WO NEEDLES (NON-INSULIN)
Q REUSABLE SYRINGES W/WO NEEDLES (INSULIN)
R DISP.SYRINGES W/WO NEEDLES (INSULIN)
S DIABETIC SUPPLIES, MISC.
T CONTRACEPTIVES, TOPICAL
U NON-REIMBURSABLE COSMETIC INDICATIONS
V VITAMINS, COMMONLY EXCLUDED
W CONTRACEPTIVES, SYSTEMIC, NON-ORAL
Y OSTOMY SUPPLIES
Z ATTENTION DEFICIT DISORDER/NARCOLEPSY
GCNSEQ_GI SMX: FDB GCN_SEQNO-Level Multi-Source/Single Source Ind. ZFDB_GCNSEQ_GI CHAR 1 0
0 Unassigned
1 Multiple source
2 Single source
GENDER SMX: FDB Gender-Specific Drug Indicator ZFDB_GENDER CHAR 1 0
0 Neutral; not gender specific (default)
1 Used exclusively in males
2 Most likely used in males
3 Used exclusively in females
4 Most likely used in females
HIC3_SEQN SMX: FDB Hierarchical Specific Therapeutic Class Code Seq. # ZFDB_HIC3_SEQN CHAR 6 0
STR60 SMX: FDB Drug Strength Description - 60 ZFDB_STR60 ZFDB_RSTR1 CHAR 60 0

ZFDB_RGCNSEQ4 foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
ZFDB_RGCNSEQ4 GCDF ZFDB_RGCNSEQ4 MANDT ZFDB_RDOSED2 SMX: FDB Dosage Form Description SH ZFDBRDOSED2 deleted MANDT
ZFDB_RGCNSEQ4 GCDF ZFDB_RGCNSEQ4 GCDF ZFDB_RDOSED2 SMX: FDB Dosage Form Description SH ZFDBRDOSED2 deleted GCDF
ZFDB_RGCNSEQ4 GCDF * ZFDB_RDOSED2 SMX: FDB Dosage Form Description SH ZFDBRDOSED2 deleted DOSE
ZFDB_RGCNSEQ4 GCRT ZFDB_RGCNSEQ4 GCRT ZFDB_RROUTED3 SMX: FDB Route of Administration Description GCRT
ZFDB_RGCNSEQ4 GCRT ZFDB_RGCNSEQ4 MANDT ZFDB_RROUTED3 SMX: FDB Route of Administration Description MANDT
ZFDB_RGCNSEQ4 HICL_SEQNO ZFDB_RGCNSEQ4 MANDT ZFDB_RHICLSQ1 SMX: FDB Ingredient List Identifier Description MANDT
ZFDB_RGCNSEQ4 HICL_SEQNO ZFDB_RGCNSEQ4 HICL_SEQNO ZFDB_RHICLSQ1 SMX: FDB Ingredient List Identifier Description HICL_SEQNO
ZFDB_RGCNSEQ4 STR60 ZFDB_RGCNSEQ4 MANDT ZFDB_RSTR1 SMX: FDB Drug Strength Components MANDT
ZFDB_RGCNSEQ4 STR60 ZFDB_RGCNSEQ4 STR60 ZFDB_RSTR1 SMX: FDB Drug Strength Components STR60
ZFDB_RGCNSEQ4 TC ZFDB_RGCNSEQ4 MANDT ZFDB_RTCD0 SMX: FDB Standard Therapeutic Class Description MANDT
ZFDB_RGCNSEQ4 TC ZFDB_RGCNSEQ4 TC ZFDB_RTCD0 SMX: FDB Standard Therapeutic Class Description TC