I_ConfignCharcGroupTP

DDL: I_CONFIGNCHARCGROUPTP SQL: ICFGGROUPWD Type: view TRANSACTIONAL Package: VCH_HL_GRP
17 Fields 1 Data Sources 2 Associations

OBSOLETE: Configuration Charc Grp TP

I_ConfignCharcGroupTP is a Transactional CDS View that provides data about "OBSOLETE: Configuration Charc Grp TP" in SAP S/4HANA. It reads from 1 data source (I_ConfignCharacteristicGroup) and exposes 17 fields with key fields ConfignCharacteristicGroup, ChangeNumber. It has 2 associations to related views. Part of development package VCH_HL_GRP.

Data Sources (1)

SourceAliasJoin Type
I_ConfignCharacteristicGroup ConfignCharacteristicGroup from

Associations (2)

CardinalityTargetAliasCondition
[0..*] I_ConfignCharcGroupDescTP _ConfignCharcGroupDesc $projection.ConfignCharacteristicGroup = _ConfignCharcGroupDesc.ConfignCharacteristicGroup and $projection.ChangeNumber = _ConfignCharcGroupDesc.ChangeNumber
[0..*] I_ConfignCharcGroupAllocTP _ConfignCharcGroupAlloc $projection.ConfignCharacteristicGroup = _ConfignCharcGroupAlloc.ConfignCharacteristicGroup and $projection.ChangeNumber = _ConfignCharcGroupAlloc.ChangeNumber

Annotations (21)

NameValueLevelField
AbapCatalog.sqlViewName ICFGGROUPWD view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label OBSOLETE: Configuration Charc Grp TP view
Search.searchable true view
VDM.viewType #TRANSACTIONAL view
ObjectModel.modelCategory #BUSINESS_OBJECT view
ObjectModel.compositionRoot true view
ObjectModel.transactionalProcessingEnabled true view
ObjectModel.writeDraftPersistence VCH_HL_D_GRP view
ObjectModel.draftEnabled true view
ObjectModel.semanticKey ConfignCharacteristicGroup view
ObjectModel.createEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.entityChangeStateId LastChangeDate view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.representativeKey ConfignCharacteristicGroup view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY ConfignCharacteristicGroup I_ConfignCharacteristicGroup ConfignCharacteristicGroup UUID
KEY ChangeNumber I_ConfignCharacteristicGroup ChangeNumber Change Number
ConfignCharcGroupForEdit I_ConfignCharacteristicGroup ConfignCharacteristicGroup UUID
ChangeNumberForEdit I_ConfignCharacteristicGroup ChangeNumber Change Number
TimeIntervalNumber I_ConfignCharacteristicGroup TimeIntervalNumber Int. counter
ConfignCharcGroupIsDefault I_ConfignCharacteristicGroup ConfignCharcGroupIsDefault Truth Value
CreatedByUser I_ConfignCharacteristicGroup CreatedByUser User Name
CreationDate I_ConfignCharacteristicGroup CreationDate Time Stamp
CreationDateTime I_ConfignCharacteristicGroup CreationDateTime Timestamp
LastChangedByUser I_ConfignCharacteristicGroup LastChangedByUser User Name
LastChangeDate I_ConfignCharacteristicGroup LastChangeDate Time Stamp
LastChangeDateTime I_ConfignCharacteristicGroup LastChangeDateTime Timestamp
ValidityStartDate I_ConfignCharacteristicGroup ValidityStartDate Validity Start Date
ValidityEndDate I_ConfignCharacteristicGroup ValidityEndDate ValidTo
VarCnfUIExtensionUUID I_ConfignCharacteristicGroup VarCnfUIExtensionUUID UI Ext ID
_ConfignCharcGroupDesc _ConfignCharcGroupDesc
_ConfignCharcGroupAlloc _ConfignCharcGroupAlloc

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_ConfignCharcGroupTP.
-- 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: ICFGGROUPWD

CREATE VIEW I_ConfignCharcGroupTP AS
SELECT
  ConfignCharacteristicGroup.ConfignCharacteristicGroup AS ConfignCharacteristicGroup,
  ConfignCharacteristicGroup.ChangeNumber AS ChangeNumber,
  ConfignCharacteristicGroup.ConfignCharacteristicGroup AS ConfignCharcGroupForEdit,
  ConfignCharacteristicGroup.ChangeNumber AS ChangeNumberForEdit,
  ConfignCharacteristicGroup.TimeIntervalNumber AS TimeIntervalNumber,
  ConfignCharacteristicGroup.ConfignCharcGroupIsDefault AS ConfignCharcGroupIsDefault,
  ConfignCharacteristicGroup.CreatedByUser AS CreatedByUser,
  ConfignCharacteristicGroup.CreationDate AS CreationDate,
  ConfignCharacteristicGroup.CreationDateTime AS CreationDateTime,
  ConfignCharacteristicGroup.LastChangedByUser AS LastChangedByUser,
  ConfignCharacteristicGroup.LastChangeDate AS LastChangeDate,
  ConfignCharacteristicGroup.LastChangeDateTime AS LastChangeDateTime,
  ConfignCharacteristicGroup.ValidityStartDate AS ValidityStartDate,
  ConfignCharacteristicGroup.ValidityEndDate AS ValidityEndDate,
  ConfignCharacteristicGroup.VarCnfUIExtensionUUID AS VarCnfUIExtensionUUID
FROM I_ConfignCharacteristicGroup AS ConfignCharacteristicGroup
LEFT OUTER JOIN I_ConfignCharcGroupDescTP AS _ConfignCharcGroupDesc ON ConfignCharacteristicGroup = _ConfignCharcGroupDesc.ConfignCharacteristicGroup AND ChangeNumber = _ConfignCharcGroupDesc.ChangeNumber  -- association [0..*]
LEFT OUTER JOIN I_ConfignCharcGroupAllocTP AS _ConfignCharcGroupAlloc ON ConfignCharacteristicGroup = _ConfignCharcGroupAlloc.ConfignCharacteristicGroup AND ChangeNumber = _ConfignCharcGroupAlloc.ChangeNumber  -- association [0..*]
;

Learn More