SAP ARCH_DEF_RELA Relationship between tables through key fields Table

Overview

ARCH_DEF_RELA is a standard SAP S/4HANA table that stores Relationship between tables through key fields data. There are total 7 fields in the ARCH_DEF_RELA table. The following is a list of the fields that make up this table. Key fields are marked in blue.

The table ARCH_DEF_RELA belongs to DART (Data Retention Tool) (CA-GTF-DRT) module and is located in the package Archive Generation tool (ILM_ARCHIVE_GENERATION).

In addition, following links provide an overview of foreign key relationships, if any, that link ARCH_DEF_RELA to other SAP tables and standard CDS views available based on ARCH_DEF_RELA table in S/4HANA 2020.

Techincal Settings of ARCH_DEF_RELA

Below are technical details of the table ARCH_DEF_RELA

  • Buffering switched on
  • Single entries of table were buffered
  • Storage type is Not Defined

List of ARCH_DEF_RELA Fields

The following table gives you an overview of the fields available in ARCH_DEF_RELA

FieldDescriptionData ElementCheck TableData TypeLength
OBJECTArchiving ObjectIRW_OBJECTCHAR10
SEQ_NOSequence NumberIRW_SEQNOCHAR4
FATHERParent SegmentIRW_FATHERCHAR30
SONChild SegmentIRW_SONCHAR30
STRUCTUREStructure NameIRW_STRUCCHAR30
KEY_FIELDKey FieldsIRW_KEYCHAR255
FILE_BASEDFile BasedIRW_FILECHAR1

Foreign Key Relationships

A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for ARCH_DEF_RELA

Other References