C_VarConfignCharacteristic

DDL: C_VARCONFIGNCHARACTERISTIC Type: view_entity CONSUMPTION

Variant Configuration Characteristic

C_VarConfignCharacteristic is a Consumption CDS View that provides data about "Variant Configuration Characteristic" in SAP S/4HANA. It reads from 1 data source (R_VarConfignCharacteristicTP) and exposes 14 fields with key fields VarConfigurationRootInstance, VarConfigurationBusObjectKey, VarConfigurationBusObjectType, VarConfignInstceInternalID, Characteristic. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
R_VarConfignCharacteristicTP R_VarConfignCharacteristicTP from

Associations (2)

CardinalityTargetAliasCondition
[0..*] C_VarConfignAssignedValue _AssignedValue
[0..*] C_VarConfignPossibleValue _PossibleValue

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Variant Configuration Characteristic view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #CONSUMPTION view
ObjectModel.query.implementedBy ABAP:CL_VCR_RAP_STICKY_QRY view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY VarConfigurationRootInstance
KEY VarConfigurationBusObjectKey VarConfigurationBusObjectKey
KEY VarConfigurationBusObjectType VarConfigurationBusObjectType
KEY VarConfignInstceInternalID VarConfignInstceInternalID
KEY Characteristic Characteristic Field Name
IsReadOnly IsReadOnly Checkbox
EntryIsRequired EntryIsRequired
CharcIsHidden CharcIsHidden
AdditionalValueIsAllowed AdditionalValueIsAllowed
VarConfignStatus VarConfignStatus
_Root _VariantConfiguration
_Instance _Instance
_AssignedValue _AssignedValue
_PossibleValue _PossibleValue

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_VarConfignCharacteristic.
-- 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 C_VarConfignCharacteristic AS
SELECT
  cast('' as ib_root) AS VarConfigurationRootInstance,
  VarConfigurationBusObjectKey,
  VarConfigurationBusObjectType,
  VarConfignInstceInternalID,
  Characteristic,
  IsReadOnly,
  EntryIsRequired,
  CharcIsHidden,
  AdditionalValueIsAllowed,
  VarConfignStatus
FROM R_VarConfignCharacteristicTP
LEFT OUTER JOIN C_VarConfignAssignedValue AS _AssignedValue ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN C_VarConfignPossibleValue AS _PossibleValue ON /* condition not available in parsed metadata */  -- association [0..*]
;