I_VarCnfTemplateBasic

DDL: I_VARCNFTEMPLATEBASIC Type: view_entity BASIC Package: ODATA_LO_VCHCLF_VCH
15 Fields 1 Data Sources

Variant Configuration Template Basic

I_VarCnfTemplateBasic is a Basic CDS View that provides data about "Variant Configuration Template Basic" in SAP S/4HANA. It reads from 1 data source (vch_template) and exposes 15 fields with key field VarCnfTemplateUUID. Part of development package ODATA_LO_VCHCLF_VCH.

Data Sources (1)

SourceAliasJoin Type
vch_template template from

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
EndUserText.label Variant Configuration Template Basic view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #BASIC view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY VarCnfTemplateUUID id WorklistID
VarCnfTemplateName name Zone name
VarCnfTemplateDescription description Well Code Des.
Plant plant Valuation Area
Product product Product Sold
BOMExplosionDate explosion_date Explosion Date
VariantConfigurationQuantity quantity_amount
VarConfignQuantityUnit quantity_unit Unit of Measure
VarConfignQuantityISOUnit quantity_unit_iso ISO Code
ConfigurationNumber cuobj Object Number
CreatedByUser created_by Version Created By
CreationDate created_on Variant created on
LastChangedByUser last_changed_by Username
LastChangeDate last_changed_on Time Stamp
LastChangeDateTime last_change_date_time Time Stamp

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_VarCnfTemplateBasic.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW I_VarCnfTemplateBasic AS
SELECT
  id AS VarCnfTemplateUUID,
  name AS VarCnfTemplateName,
  description AS VarCnfTemplateDescription,
  Plant,
  Product,
  explosion_date AS BOMExplosionDate,
  quantity_amount AS VariantConfigurationQuantity,
  quantity_unit AS VarConfignQuantityUnit,
  quantity_unit_iso AS VarConfignQuantityISOUnit,
  cuobj AS ConfigurationNumber,
  created_by AS CreatedByUser,
  created_on AS CreationDate,
  last_changed_by AS LastChangedByUser,
  last_changed_on AS LastChangeDate,
  last_change_date_time AS LastChangeDateTime
FROM vch_template AS template
;

Learn More