SAP VCH_COMPIL_ITEMS VCH compilation items Table

Overview

VCH_COMPIL_ITEMS is a standard SAP S/4HANA table that stores VCH compilation items data. There are total 22 fields in the VCH_COMPIL_ITEMS table. The following is a list of the fields that make up this table. Key fields are marked in blue.

The table VCH_COMPIL_ITEMS belongs to Variant Configuration (LO-VC) module and is located in the package Low Level Variant Configuration on HANA (VCH_LL).

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

Techincal Settings of VCH_COMPIL_ITEMS

Below are technical details of the table VCH_COMPIL_ITEMS

Buffering not allowed
No buffering
Storage type is Column Store

List of VCH_COMPIL_ITEMS Fields

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

Field	Description	Data Element	Data Type	Length
MANDT	Client	MANDT	CLNT	3
DEP_ID	Internal number of knowledge element	KNNUM	NUMC	10
VALID_FROM	Valid-From Date	DATUV	DATS	8
VALID_TO	Valid-to date	DATUB	DATS	8
COMPLEXITY_CATEGORY	Complexity Category	VCH_COMPLEXITY_CATEGORY	INT4	10
PURE_SIMPLE_CLAUSE	Only Simple Operations Indicator	VCH_SIMPLE_INDICATOR	CHAR	1
OP_TYPE	Operation Type	VCH_OPERATION_TYPE	CHAR	10
VARIANT_TABLE_ID	Internal number of variant table	VTINT	NUMC	10
OPERAND1_TYPE	Operand Type	VCH_OPERAND_TYPE	CHAR	10
OPERAND1_NUM	Internal floating point from	ATFLV	FLTP	16
OPERAND1_STRING	Characteristic Value	ATWRT	CHAR	70
OPERAND1_REF_LEVEL	Object Reference Level	VCH_REFERENCE_LEVEL	INT4	10
OPERAND1_CSTIC_ID	Internal characteristic	ATINN	NUMC	10
OPERAND1_TABLE_NAME	Table Name	ATTAB	CHAR	30
OPERAND1_FIELD_NAME	Field Name	ATFEL	CHAR	30
OPERAND2_TYPE	Operand Type	VCH_OPERAND_TYPE	CHAR	10
OPERAND2_NUM	Internal floating point from	ATFLV	FLTP	16
OPERAND2_STRING	Characteristic Value	ATWRT	CHAR	70
OPERAND2_REF_LEVEL	Object Reference Level	VCH_REFERENCE_LEVEL	INT4	10
OPERAND2_CSTIC_ID	Internal characteristic	ATINN	NUMC	10
OPERAND2_TABLE_NAME	Table Name	ATTAB	CHAR	30
OPERAND2_FIELD_NAME	Field Name	ATFEL	CHAR	30

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 VCH_COMPIL_ITEMS

SAP VCH_COMPIL_ITEMS VCH compilation items Table

Overview

Techincal Settings of VCH_COMPIL_ITEMS

List of VCH_COMPIL_ITEMS Fields

Foreign Key Relationships

Other References