I_ConfigurationProfile

DDL: I_CONFIGURATIONPROFILE SQL: ICONFPROFILE Type: view BASIC Package: ODATA_LO_VCHCLF_SIMULATION
15 Fields 1 Data Sources

Configuration Profile

I_ConfigurationProfile is a Basic CDS View that provides data about "Configuration Profile" in SAP S/4HANA. It reads from 1 data source (cuco) and exposes 15 fields with key fields ProductConfiguration, ConfigurationProfileNumber, ObjectDatabaseTable. Part of development package ODATA_LO_VCHCLF_SIMULATION.

Data Sources (1)

SourceAliasJoin Type
cuco ConfigurationProfiles from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName ICONFPROFILE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Configuration Profile view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
Search.searchable true view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY ProductConfiguration cuco objek Object
KEY ConfigurationProfileNumber cuco zaehl Sort pos.
KEY ObjectDatabaseTable cuco obtab Table
ConfigurationProfileName cuco prfid Rate Profile
ConfigurationProfileStatus cuco status Workflow Status
aesbnendasLastChangedByUser
aedatendasLastChangeDate
valevXthenMelseendasBOMExplosionLevel
BOMExplosionApplication cuco apids BOM Application
ChangeNumber cuco aennr Change Number
ConfProfileValidityStartDate cuco datuv Valid-from date
ConfProfileValidityEndDate cuco datub Valid to
DependencyObjectNumber cuco knobj Assgmt no.
EngineProcessingMode cuco proc_mode Processing Mode
ClassType cuco klart Class Type

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_ConfigurationProfile.
-- 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: ICONFPROFILE

CREATE VIEW I_ConfigurationProfile AS
SELECT
  ConfigurationProfiles.objek AS ProductConfiguration,
  ConfigurationProfiles.zaehl AS ConfigurationProfileNumber,
  ConfigurationProfiles.obtab AS ObjectDatabaseTable,
  ConfigurationProfiles.prfid AS ConfigurationProfileName,
  ConfigurationProfiles.status AS ConfigurationProfileStatus,
  case when ConfigurationProfiles.aesbn = '' or ConfigurationProfiles.aedat = '' then ConfigurationProfiles.ersnu else ConfigurationProfiles.aesbn end as LastChangedByUser AS aesbnendasLastChangedByUser,
  case when ConfigurationProfiles.aesbn = '' or ConfigurationProfiles.aedat = '' then ConfigurationProfiles.ersdt else ConfigurationProfiles.aedat end as LastChangeDate AS aedatendasLastChangeDate,
  case when ConfigurationProfiles.stldy = 'X' then 'N' when ConfigurationProfiles.single = 'X' then 'S' when ConfigurationProfiles.valev = 'X' then 'M' else '' end as BOMExplosionLevel AS valevXthenMelseendasBOMExplosionLevel,
  ConfigurationProfiles.apids AS BOMExplosionApplication,
  ConfigurationProfiles.aennr AS ChangeNumber,
  ConfigurationProfiles.datuv AS ConfProfileValidityStartDate,
  ConfigurationProfiles.datub AS ConfProfileValidityEndDate,
  ConfigurationProfiles.knobj AS DependencyObjectNumber,
  ConfigurationProfiles.proc_mode AS EngineProcessingMode,
  ConfigurationProfiles.klart AS ClassType
FROM cuco AS ConfigurationProfiles
;

Learn More