I_ValueChainType

DDL: I_VALUECHAINTYPE Type: view BASIC

Value Chain

I_ValueChainType is a Basic CDS View that provides data about "Value Chain" in SAP S/4HANA. It reads from 1 data source (vcm_chain_type) and exposes 7 fields with key fields ValueChainType, ValueChainTypeVersion. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
vcm_chain_type ChainType from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_ValueChainTypeText _Text $projection.ValueChainType = _Text.ValueChainType and $projection.ValueChainTypeVersion = _Text.ValueChainTypeVersion

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IVCM_CHAINTYPE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.representativeKey ValueChainType view
VDM.viewType #BASIC view
EndUserText.label Value Chain view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY ValueChainType value_chain_type Value Chain Type
KEY ValueChainTypeVersion version XML Vers.
CreationDateTime created_at Uploaded On
CreatedByUser created_by Version Created By
LastChangeDateTime last_changed_at Timestamp
LastChangedByUser last_changed_by Username
_Text _Text

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_ValueChainType.
-- 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_ValueChainType AS
SELECT
  value_chain_type AS ValueChainType,
  version AS ValueChainTypeVersion,
  created_at AS CreationDateTime,
  created_by AS CreatedByUser,
  last_changed_at AS LastChangeDateTime,
  last_changed_by AS LastChangedByUser
FROM vcm_chain_type AS ChainType
LEFT OUTER JOIN I_ValueChainTypeText AS _Text ON ValueChainType = _Text.ValueChainType AND ValueChainTypeVersion = _Text.ValueChainTypeVersion  -- association [0..*]
;