R_VarCnfCharcGroupTP_2

DDL: R_VARCNFCHARCGROUPTP_2 Type: view_entity TRANSACTIONAL Package: VCH_RAP_MD_GRP
16 Fields 1 Data Sources 5 Associations

Variant Confign Characteristic Group

R_VarCnfCharcGroupTP_2 is a Transactional CDS View that provides data about "Variant Confign Characteristic Group" in SAP S/4HANA. It reads from 1 data source (I_ConfignCharacteristicGroup) and exposes 16 fields with key fields ConfignCharacteristicGroup, ChangeNumber. It has 5 associations to related views. Part of development package VCH_RAP_MD_GRP.

Data Sources (1)

SourceAliasJoin Type
I_ConfignCharacteristicGroup Grp from

Associations (5)

CardinalityTargetAliasCondition
[0..1] R_VarCnfUIExtensionTP _VarCnfUIExtension $projection.VarCnfUIExtensionUUID = _VarCnfUIExtension.VarCnfUIExtensionUUID
[0..1] R_VarCnfCharcGroupTextTP_2 _ConfignCharcGroupDescSysLang $projection.ConfignCharacteristicGroup = _ConfignCharcGroupDescSysLang.ConfignCharacteristicGroup and $projection.ChangeNumber = _ConfignCharcGroupDescSysLang.ChangeNumber and _ConfignCharcGroupDescSysLang.Language = $session.system_language
[0..1] I_ConfignCharcGrpAllocCount _CsticCount $projection.ConfignCharacteristicGroup = _CsticCount.ConfignCharacteristicGroup and $projection.ChangeNumber = _CsticCount.ChangeNumber
[0..*] R_VarCnfCharcGroupTextTP_2 _Text
[0..*] R_VarCnfCharcGroupAllocTP_2 _CharcAllocation

Annotations (10)

NameValueLevelField
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #TRANSACTIONAL view
VDM.private false view
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.representativeKey ConfignCharacteristicGroup view
ObjectModel.sapObjectNodeType.name VarConfignCharacteristicGroup view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
EndUserText.label Variant Confign Characteristic Group view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY ConfignCharacteristicGroup I_ConfignCharacteristicGroup ConfignCharacteristicGroup UUID
KEY ChangeNumber I_ConfignCharacteristicGroup ChangeNumber Change Number
TimeIntervalNumber I_ConfignCharacteristicGroup TimeIntervalNumber Int. counter
ConfignCharcGroupIsDefault I_ConfignCharacteristicGroup ConfignCharcGroupIsDefault Truth Value
VarCnfUIExtensionUUID I_ConfignCharacteristicGroup VarCnfUIExtensionUUID UI Ext ID
ConfignCharacteristicGroupDesc _ConfignCharcGroupDescSysLang ConfignCharacteristicGroupDesc
NumberOfCharacteristics _CsticCount NumberOfCharacteristics
ValidityStartDate I_ConfignCharacteristicGroup ValidityStartDate Validity Start Date
ValidityEndDate I_ConfignCharacteristicGroup ValidityEndDate ValidTo
CreatedByUser I_ConfignCharacteristicGroup CreatedByUser User Name
CreationDateTime I_ConfignCharacteristicGroup CreationDateTime Timestamp
LastChangedByUser I_ConfignCharacteristicGroup LastChangedByUser User Name
LastChangeDateTime I_ConfignCharacteristicGroup LastChangeDateTime Timestamp
_Text _Text
_CharcAllocation _CharcAllocation
_VarCnfUIExtension _VarCnfUIExtension

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 R_VarCnfCharcGroupTP_2.
-- 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 R_VarCnfCharcGroupTP_2 AS
SELECT
  Grp.ConfignCharacteristicGroup AS ConfignCharacteristicGroup,
  Grp.ChangeNumber AS ChangeNumber,
  Grp.TimeIntervalNumber AS TimeIntervalNumber,
  Grp.ConfignCharcGroupIsDefault AS ConfignCharcGroupIsDefault,
  Grp.VarCnfUIExtensionUUID AS VarCnfUIExtensionUUID,
  _ConfignCharcGroupDescSysLang.ConfignCharacteristicGroupDesc AS ConfignCharacteristicGroupDesc,
  _CsticCount.NumberOfCharacteristics AS NumberOfCharacteristics,
  Grp.ValidityStartDate AS ValidityStartDate,
  Grp.ValidityEndDate AS ValidityEndDate,
  Grp.CreatedByUser AS CreatedByUser,
  Grp.CreationDateTime AS CreationDateTime,
  Grp.LastChangedByUser AS LastChangedByUser,
  Grp.LastChangeDateTime AS LastChangeDateTime
FROM I_ConfignCharacteristicGroup AS Grp
LEFT OUTER JOIN R_VarCnfUIExtensionTP AS _VarCnfUIExtension ON VarCnfUIExtensionUUID = _VarCnfUIExtension.VarCnfUIExtensionUUID  -- association [0..1]
LEFT OUTER JOIN R_VarCnfCharcGroupTextTP_2 AS _ConfignCharcGroupDescSysLang ON ConfignCharacteristicGroup = _ConfignCharcGroupDescSysLang.ConfignCharacteristicGroup AND ChangeNumber = _ConfignCharcGroupDescSysLang.ChangeNumber AND _ConfignCharcGroupDescSysLang.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_ConfignCharcGrpAllocCount AS _CsticCount ON ConfignCharacteristicGroup = _CsticCount.ConfignCharacteristicGroup AND ChangeNumber = _CsticCount.ChangeNumber  -- association [0..1]
LEFT OUTER JOIN R_VarCnfCharcGroupTextTP_2 AS _Text ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_VarCnfCharcGroupAllocTP_2 AS _CharcAllocation ON /* condition not available in parsed metadata */  -- association [0..*]
;

Learn More