SAP VERELATION Table for maintaining relationship between VE objects Table

Overview

VERELATION is a standard SAP S/4HANA table that stores Table for maintaining relationship between VE objects data. There are total 5 fields in the VERELATION table. The following is a list of the fields that make up this table. Key fields are marked in blue.

The table VERELATION belongs to DMS Integration for Viewer/CAD intergration (CA-DMS-CNV) module and is located in the package DMS integration for Extraction of Visual Enterprise Objects (CV_VE_OBJECTS).

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

Techincal Settings of VERELATION

Below are technical details of the table VERELATION

  • Buffering switched on
  • Full table is passed to buffer
  • Storage type is Column Store

List of VERELATION Fields

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

FieldDescriptionData ElementCheck TableData TypeLength
MANDTClientMANDT*CLNT3
OBJ_GUIDUUID in character formSYSUUID_CVEOBJECTCHAR32
REL_OBJ_GUIDUUID in character formSYSUUID_CCHAR32
LO_OBJIDLogical documentSDOK_LOIDDMS_LO_CD1CHAR32
REL_TYPEMaintaining the relation type for VE objectsVE_REL_TYPECHAR20

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 VERELATION

Table NameFieldCardinalityCheck Table
VERELATIONLO_OBJID:DMS_LO_CD1
VERELATIONOBJ_GUID:VEOBJECT

Other References