C_ProductConfigurationProfile

DDL: C_PRODUCTCONFIGURATIONPROFILE SQL: CPRDCONFPROFILE Type: view CONSUMPTION
14 Fields 1 Data Sources

Configuration Profile for Products

C_ProductConfigurationProfile is a Consumption CDS View that provides data about "Configuration Profile for Products" in SAP S/4HANA. It reads from 1 data source (P_ReleasedConfigurationProfile) and exposes 14 fields with key fields Product, ConfigurationProfileNumber.

Data Sources (1)

SourceAliasJoin Type
P_ReleasedConfigurationProfile ConfigurationProfiles from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName CPRDCONFPROFILE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Configuration Profile for Products view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
Search.searchable true view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY Product P_ReleasedConfigurationProfile ProductConfiguration
KEY ConfigurationProfileNumber P_ReleasedConfigurationProfile ConfigurationProfileNumber
ConfigurationProfileName P_ReleasedConfigurationProfile ConfigurationProfileName
BOMExplosionApplication P_ReleasedConfigurationProfile BOMExplosionApplication BOM Application
UserDescription P_ReleasedConfigurationProfile UserFullName
LastChangedByUser P_ReleasedConfigurationProfile LastChangedByUser User Name
LastChangeDate P_ReleasedConfigurationProfile LastChangeDate Time Stamp
ConfigurationProfileStatus P_ReleasedConfigurationProfile ConfigurationProfileStatus
ConfigurationProfileProcess P_ReleasedConfigurationProfile ConfigurationProfileProcess
BOMExplosionLevel P_ReleasedConfigurationProfile BOMExplosionLevel
ObjDpnAssignmentNumber P_ReleasedConfigurationProfile DependencyObjectNumber Assgmt no.
ConfProfileValidityStartDate P_ReleasedConfigurationProfile ConfProfileValidityStartDate
ConfProfileValidityEndDate P_ReleasedConfigurationProfile ConfProfileValidityEndDate
ClassType P_ReleasedConfigurationProfile ClassType X Flag

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 C_ProductConfigurationProfile.
-- 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: CPRDCONFPROFILE

CREATE VIEW C_ProductConfigurationProfile AS
SELECT
  ConfigurationProfiles.ProductConfiguration AS Product,
  ConfigurationProfiles.ConfigurationProfileNumber AS ConfigurationProfileNumber,
  ConfigurationProfiles.ConfigurationProfileName AS ConfigurationProfileName,
  ConfigurationProfiles.BOMExplosionApplication AS BOMExplosionApplication,
  ConfigurationProfiles.UserFullName AS UserDescription,
  ConfigurationProfiles.LastChangedByUser AS LastChangedByUser,
  ConfigurationProfiles.LastChangeDate AS LastChangeDate,
  ConfigurationProfiles.ConfigurationProfileStatus AS ConfigurationProfileStatus,
  ConfigurationProfiles.ConfigurationProfileProcess AS ConfigurationProfileProcess,
  ConfigurationProfiles.BOMExplosionLevel AS BOMExplosionLevel,
  ConfigurationProfiles.DependencyObjectNumber AS ObjDpnAssignmentNumber,
  ConfigurationProfiles.ConfProfileValidityStartDate AS ConfProfileValidityStartDate,
  ConfigurationProfiles.ConfProfileValidityEndDate AS ConfProfileValidityEndDate,
  ConfigurationProfiles.ClassType AS ClassType
FROM P_ReleasedConfigurationProfile AS ConfigurationProfiles
;

Learn More