I_ConfignCharcGroupAllocTP

DDL: I_CONFIGNCHARCGROUPALLOCTP SQL: ICFGGROUPCSTICWD Type: view TRANSACTIONAL
15 Fields 1 Data Sources 1 Associations

OBSOLETE: Confign Charc Grp Alloc TP

I_ConfignCharcGroupAllocTP is a Transactional CDS View that provides data about "OBSOLETE: Confign Charc Grp Alloc TP" in SAP S/4HANA. It reads from 1 data source (I_ConfignCharcGroupAlloc) and exposes 15 fields with key fields ConfignCharacteristicGroup, ChangeNumber, CharcInternalID. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_ConfignCharcGroupAlloc ConfignCharcGroupAlloc from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_ConfignCharcGroupTP _ConfignCharacteristicGroup $projection.ConfignCharacteristicGroup = _ConfignCharacteristicGroup.ConfignCharacteristicGroup and $projection.ChangeNumber = _ConfignCharacteristicGroup.ChangeNumber

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName ICFGGROUPCSTICWD view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label OBSOLETE: Confign Charc Grp Alloc TP view
Search.searchable true view
VDM.viewType #TRANSACTIONAL view
ObjectModel.writeDraftPersistence VCH_HL_D_GRP_CST view
ObjectModel.createEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY ConfignCharacteristicGroup I_ConfignCharcGroupAlloc ConfignCharacteristicGroup UUID
KEY ChangeNumber I_ConfignCharcGroupAlloc ChangeNumber Change Number
KEY CharcInternalID I_ConfignCharcGroupAlloc CharcInternalID Characteristic Internal ID
ConfignCharcGroupForEdit I_ConfignCharcGroupAlloc ConfignCharacteristicGroup UUID
ChangeNumberForEdit I_ConfignCharcGroupAlloc ChangeNumber Change Number
CharcInternalIDForEdit I_ConfignCharcGroupAlloc CharcInternalID Characteristic Internal ID
TimeIntervalNumber I_ConfignCharcGroupAlloc TimeIntervalNumber Int. counter
SortingNumber I_ConfignCharcGroupAlloc SortingNumber Field of length 16
CreatedByUser I_ConfignCharcGroupAlloc CreatedByUser User Name
CreationDate I_ConfignCharcGroupAlloc CreationDate Time Stamp
CreationDateTime I_ConfignCharcGroupAlloc CreationDateTime Timestamp
LastChangedByUser I_ConfignCharcGroupAlloc LastChangedByUser User Name
LastChangeDate I_ConfignCharcGroupAlloc LastChangeDate Time Stamp
LastChangeDateTime I_ConfignCharcGroupAlloc LastChangeDateTime Timestamp
_ConfignCharacteristicGroup _ConfignCharacteristicGroup

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_ConfignCharcGroupAllocTP.
-- 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: ICFGGROUPCSTICWD

CREATE VIEW I_ConfignCharcGroupAllocTP AS
SELECT
  ConfignCharcGroupAlloc.ConfignCharacteristicGroup AS ConfignCharacteristicGroup,
  ConfignCharcGroupAlloc.ChangeNumber AS ChangeNumber,
  ConfignCharcGroupAlloc.CharcInternalID AS CharcInternalID,
  ConfignCharcGroupAlloc.ConfignCharacteristicGroup AS ConfignCharcGroupForEdit,
  ConfignCharcGroupAlloc.ChangeNumber AS ChangeNumberForEdit,
  ConfignCharcGroupAlloc.CharcInternalID AS CharcInternalIDForEdit,
  ConfignCharcGroupAlloc.TimeIntervalNumber AS TimeIntervalNumber,
  ConfignCharcGroupAlloc.SortingNumber AS SortingNumber,
  ConfignCharcGroupAlloc.CreatedByUser AS CreatedByUser,
  ConfignCharcGroupAlloc.CreationDate AS CreationDate,
  ConfignCharcGroupAlloc.CreationDateTime AS CreationDateTime,
  ConfignCharcGroupAlloc.LastChangedByUser AS LastChangedByUser,
  ConfignCharcGroupAlloc.LastChangeDate AS LastChangeDate,
  ConfignCharcGroupAlloc.LastChangeDateTime AS LastChangeDateTime
FROM I_ConfignCharcGroupAlloc AS ConfignCharcGroupAlloc
LEFT OUTER JOIN I_ConfignCharcGroupTP AS _ConfignCharacteristicGroup ON ConfignCharacteristicGroup = _ConfignCharacteristicGroup.ConfignCharacteristicGroup AND ChangeNumber = _ConfignCharacteristicGroup.ChangeNumber  -- association [1..1]
;

Learn More