SAP Table REFON
References between object numbers (CO object no.)
REFON (References between object numbers (CO object no.)) 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 REFON to other SAP tables.
REFON table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||||||||||||
| REFTYP | Reference Category (Unit Category) | KL_TYP | ATR1 | CHAR | 3 | 0 | ||||||||||||||||
| REFNR | Reference number (unit no.) | KL_NR | REFH | CHAR | 10 | 0 | ||||||||||||||||
| OBJNR | Object number | J_OBJNR | ONR00 | CHAR | 22 | 0 | ||||||||||||||||
| STATUS | Active status of reference | KL_SAKTIV | NUMC | 1 | 0 |
Possible values
|
||||||||||||||||
| CRUSER | Entered by | TB_CRUSER | CHAR | 12 | 0 | |||||||||||||||||
| DCRDAT | Entered On | TB_DCRDAT | DATS | 8 | 0 | |||||||||||||||||
| TCRTIM | Entry Time | TB_TCRTIM | TIMS | 6 | 0 | |||||||||||||||||
| UPUSER | Last Changed by | TB_UPUSER | CHAR | 12 | 0 | |||||||||||||||||
| DUPDAT | Changed on | TB_DUPDAT | DATS | 8 | 0 | |||||||||||||||||
| TUPTIM | Time changed | TB_TUPTIM | TIMS | 6 | 0 | |||||||||||||||||
| RRANG | Ranking | KL_RRANG | CHAR | 1 | 0 | |||||||||||||||||
REFON foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| REFON | MANDT | REFON | MANDT | T000 | Clients | MANDT |
| REFON | OBJNR | REFON | MANDT | ONR00 | General Object Number | MANDT |
| REFON | OBJNR | REFON | OBJNR | ONR00 | General Object Number | OBJNR |
| REFON | REFNR | REFON | REFTYP | REFH | References between CO object numbers, header table | REFTYP |
| REFON | REFNR | REFON | REFNR | REFH | References between CO object numbers, header table | REFNR |
| REFON | REFNR | REFON | MANDT | REFH | References between CO object numbers, header table | MANDT |
| REFON | REFTYP | REFON | REFTYP | ATR1 | Check table for reference categories | REFTYP |
