R_VarConfignCharcGroupAlloc

DDL: R_VARCONFIGNCHARCGROUPALLOC Type: view_entity COMPOSITE
11 Fields 3 Data Sources

OBSOLETE: Confign Charc Grp Cstic Alloc

R_VarConfignCharcGroupAlloc is a Composite CDS View that provides data about "OBSOLETE: Confign Charc Grp Cstic Alloc" in SAP S/4HANA. It reads from 3 data sources (I_ClfnCharcBasic, I_ConfignCharcGroupAlloc, I_ConfignCharacteristicGroup) and exposes 11 fields with key fields ConfignCharacteristicGroup, ChangeNumber, CharacteristicInternalID.

Data Sources (3)

SourceAliasJoin Type
I_ClfnCharcBasic _CsticDef left_outer
I_ConfignCharcGroupAlloc CsticAlloc from
I_ConfignCharacteristicGroup GroupDef inner

Annotations (11)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label OBSOLETE: Confign Charc Grp Cstic Alloc view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MASTER view
VDM.viewType #COMPOSITE view
VDM.private false view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.modelCategory #BUSINESS_OBJECT view
ObjectModel.dataCategory #TEXT view
ObjectModel.representativeKey ConfignCharacteristicGroup view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY ConfignCharacteristicGroup I_ConfignCharcGroupAlloc ConfignCharacteristicGroup UUID
KEY ChangeNumber I_ConfignCharacteristicGroup ChangeNumber Change Number
KEY CharacteristicInternalID I_ConfignCharcGroupAlloc CharcInternalID Characteristic Internal ID
TimeIntervalNumber I_ConfignCharcGroupAlloc TimeIntervalNumber Int. counter
SortingNumber I_ConfignCharcGroupAlloc SortingNumber Field of length 16
Characteristic I_ClfnCharcBasic Characteristic Field Name
CreatedByUser I_ConfignCharcGroupAlloc CreatedByUser User Name
CreationDate I_ConfignCharcGroupAlloc CreationDate Time Stamp
LastChangedByUser I_ConfignCharcGroupAlloc LastChangedByUser User Name
LastChangeDate I_ConfignCharcGroupAlloc LastChangeDate Time Stamp
_GroupDef _GroupDef

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_VarConfignCharcGroupAlloc.
-- 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_VarConfignCharcGroupAlloc AS
SELECT
  CsticAlloc.ConfignCharacteristicGroup AS ConfignCharacteristicGroup,
  GroupDef.ChangeNumber AS ChangeNumber,
  CsticAlloc.CharcInternalID AS CharacteristicInternalID,
  CsticAlloc.TimeIntervalNumber AS TimeIntervalNumber,
  CsticAlloc.SortingNumber AS SortingNumber,
  _CsticDef.Characteristic AS Characteristic,
  CsticAlloc.CreatedByUser AS CreatedByUser,
  CsticAlloc.CreationDate AS CreationDate,
  CsticAlloc.LastChangedByUser AS LastChangedByUser,
  CsticAlloc.LastChangeDate AS LastChangeDate
FROM I_ConfignCharcGroupAlloc AS CsticAlloc
INNER JOIN I_ConfignCharacteristicGroup AS GroupDef ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ClfnCharcBasic AS _CsticDef ON /* join condition not captured in parsed metadata */
;

Learn More