I_ConfignPrflCharcGroupAllocTP

DDL: I_CONFIGNPRFLCHARCGROUPALLOCTP SQL: IVCHHLPRFLGRPWD Type: view TRANSACTIONAL Package: VCH_HL_GRP

TP view for Group to Profile

I_ConfignPrflCharcGroupAllocTP is a Transactional CDS View that provides data about "TP view for Group to Profile" in SAP S/4HANA. It reads from 1 data source (I_ConfignPrflCharcGroupAlloc) and exposes 12 fields with key fields ProductConfiguration, ConfigurationProfileName, ConfigurationProfileCounter, ConfignCharacteristicGroup. It has 1 association to related views. Part of development package VCH_HL_GRP.

Data Sources (1)

SourceAliasJoin Type
I_ConfignPrflCharcGroupAlloc Alloc from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_ConfigurationProfileTP _ConfigurationProfile $projection.ProductConfiguration = _ConfigurationProfile.ProductConfiguration and $projection.ConfigurationProfileName = _ConfigurationProfile.ConfigurationProfileName and $projection.ConfigurationProfileCounter = _ConfigurationProfile.ConfigurationProfileCounter

Annotations (16)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName IVCHHLPRFLGRPWD view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label TP view for Group to Profile view
Search.searchable true view
VDM.viewType #TRANSACTIONAL view
ObjectModel.writeDraftPersistence VCH_HL_D_PRFLGRP view
ObjectModel.transactionalProcessingEnabled true view
ObjectModel.createEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.representativeKey ConfignCharacteristicGroup view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY ProductConfiguration I_ConfignPrflCharcGroupAlloc ProductConfiguration Object
KEY ConfigurationProfileName I_ConfignPrflCharcGroupAlloc ConfigurationProfileName Rate Profile
KEY ConfigurationProfileCounter I_ConfignPrflCharcGroupAlloc ConfigurationProfileCounter Int. counter
KEY ConfignCharacteristicGroup I_ConfignPrflCharcGroupAlloc ConfignCharacteristicGroup UUID
ProductConfigurationForEdit I_ConfignPrflCharcGroupAlloc ProductConfiguration Object
ConfignProfileNameForEdit I_ConfignPrflCharcGroupAlloc ConfigurationProfileName Rate Profile
ConfignProfileCounterForEdit I_ConfignPrflCharcGroupAlloc ConfigurationProfileCounter Int. counter
CharacteristicGroupForEdit I_ConfignPrflCharcGroupAlloc ConfignCharacteristicGroup UUID
ObjectDatabaseTable I_ConfignPrflCharcGroupAlloc ObjectDatabaseTable Table
SortingNumber I_ConfignPrflCharcGroupAlloc SortingNumber Field of length 16
ConfignCharacteristicGroupDesc I_ConfignPrflCharcGroupAlloc ConfignCharacteristicGroupDesc
_ConfigurationProfile _ConfigurationProfile

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_ConfignPrflCharcGroupAllocTP.
-- 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: IVCHHLPRFLGRPWD

CREATE VIEW I_ConfignPrflCharcGroupAllocTP AS
SELECT
  Alloc.ProductConfiguration AS ProductConfiguration,
  Alloc.ConfigurationProfileName AS ConfigurationProfileName,
  Alloc.ConfigurationProfileCounter AS ConfigurationProfileCounter,
  Alloc.ConfignCharacteristicGroup AS ConfignCharacteristicGroup,
  Alloc.ProductConfiguration AS ProductConfigurationForEdit,
  Alloc.ConfigurationProfileName AS ConfignProfileNameForEdit,
  Alloc.ConfigurationProfileCounter AS ConfignProfileCounterForEdit,
  Alloc.ConfignCharacteristicGroup AS CharacteristicGroupForEdit,
  Alloc.ObjectDatabaseTable AS ObjectDatabaseTable,
  Alloc.SortingNumber AS SortingNumber,
  Alloc.ConfignCharacteristicGroupDesc AS ConfignCharacteristicGroupDesc
FROM I_ConfignPrflCharcGroupAlloc AS Alloc
LEFT OUTER JOIN I_ConfigurationProfileTP AS _ConfigurationProfile ON ProductConfiguration = _ConfigurationProfile.ProductConfiguration AND ConfigurationProfileName = _ConfigurationProfile.ConfigurationProfileName AND ConfigurationProfileCounter = _ConfigurationProfile.ConfigurationProfileCounter  -- association [1..1]
;