Deprecated
This CDS view is deprecated in S/4HANA. Use I_ChangeMstrObjTypeRevisionLvl instead. View all deprecated CDS views →

C_Revisionleveltemp

DDL: C_REVISIONLEVELTEMP SQL: CREVISIONLEVELVH Type: view CONSUMPTION Package: VDM_MD_PRODUCT_OBSOLETE

Revision Level Value Help

C_Revisionleveltemp is a Consumption CDS View that provides data about "Revision Level Value Help" in SAP S/4HANA. It reads from 1 data source (tcc09) and exposes 3 fields with key fields ProductObjectCategory, RevisionLevelOrder, MaterialRevisionLevel. Part of development package VDM_MD_PRODUCT_OBSOLETE.

Data Sources (1)

SourceAliasJoin Type
tcc09 tcc09 from

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName CREVISIONLEVELVH view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Revision Level Value Help view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.status #DEPRECATED view
VDM.lifecycle.successor I_ChangeMstrObjTypeRevisionLvl view
Search.searchable true view
ObjectModel.representativeKey MaterialRevisionLevel view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MASTER view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY ProductObjectCategory tcc09 aetyp Object Category
KEY RevisionLevelOrder tcc09 ccsrf Order
KEY MaterialRevisionLevel tcc09 revlv Revision Level

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 C_Revisionleveltemp.
-- 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.
-- SQL view name: CREVISIONLEVELVH

CREATE VIEW C_Revisionleveltemp AS
SELECT
  tcc09.aetyp AS ProductObjectCategory,
  tcc09.ccsrf AS RevisionLevelOrder,
  tcc09.revlv AS MaterialRevisionLevel
FROM tcc09
;