P_AVC_ConfigurationProfiles

DDL: P_AVC_CONFIGURATIONPROFILES SQL: PAVCCONFPROFILE Type: view CONSUMPTION

P_AVC_ConfigurationProfiles is a Consumption CDS View in SAP S/4HANA. It reads from 2 data sources (P_ConfigurationCount, I_ConfigurationProfile) and exposes 16 fields with key fields ProductConfiguration, ObjectDatabaseTable, ConfigurationProfileNumber. It has 1 association to related views.

2 data source(s) 16 fields

Data Sources (2)

SourceAliasJoin Type
P_ConfigurationCount _ConfigurationCount inner
I_ConfigurationProfile ConfigurationProfiles from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_User _UserFullName $projection.LastChangedByUser = _UserFullName.UserID

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PAVCCONFPROFILE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #CONSUMPTION view
VDM.private true view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY ProductConfiguration I_ConfigurationProfile ProductConfiguration
KEY ObjectDatabaseTable I_ConfigurationProfile ObjectDatabaseTable
KEY ConfigurationProfileNumber I_ConfigurationProfile ConfigurationProfileNumber
ConfigurationProfileName I_ConfigurationProfile ConfigurationProfileName
ConfigurationProfileStatus I_ConfigurationProfile ConfigurationProfileStatus
LastChangedByUser I_ConfigurationProfile LastChangedByUser
LastChangeDate I_ConfigurationProfile LastChangeDate
ConfigurationProfileProcess I_ConfigurationProfile ConfigurationProfileProcess
BOMExplosionLevel I_ConfigurationProfile BOMExplosionLevel
BOMExplosionApplication I_ConfigurationProfile BOMExplosionApplication
ConfProfileValidityStartDate I_ConfigurationProfile ConfProfileValidityStartDate
ConfProfileValidityEndDate I_ConfigurationProfile ConfProfileValidityEndDate
DependencyObjectNumber I_ConfigurationProfile DependencyObjectNumber
EngineProcessingMode I_ConfigurationProfile EngineProcessingMode
UserFullName _UserFullName UserDescription
ClassType ClassType 
@AbapCatalog.sqlViewName: 'PAVCCONFPROFILE'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED


@VDM.viewType: #CONSUMPTION
@VDM.private: true

@ClientHandling.algorithm: #SESSION_VARIABLE

define view P_AVC_ConfigurationProfiles
  as select from I_ConfigurationProfile as ConfigurationProfiles
    inner join   P_ConfigurationCount   as _ConfigurationCount on ConfigurationProfiles.ProductConfiguration = _ConfigurationCount.ProductConfiguration
    
    association [1..1] to I_User as _UserFullName on $projection.LastChangedByUser = _UserFullName.UserID
{
  key ConfigurationProfiles.ProductConfiguration,
  key ConfigurationProfiles.ObjectDatabaseTable,
  key ConfigurationProfiles.ConfigurationProfileNumber,

      ConfigurationProfiles.ConfigurationProfileName,
      ConfigurationProfiles.ConfigurationProfileStatus,
      ConfigurationProfiles.LastChangedByUser,
      ConfigurationProfiles.LastChangeDate,
      ConfigurationProfiles.ConfigurationProfileProcess,
      ConfigurationProfiles.BOMExplosionLevel,
      ConfigurationProfiles.BOMExplosionApplication,
      ConfigurationProfiles.ConfProfileValidityStartDate,
      ConfigurationProfiles.ConfProfileValidityEndDate,
      ConfigurationProfiles.DependencyObjectNumber,
      ConfigurationProfiles.EngineProcessingMode,
      _UserFullName.UserDescription as UserFullName,
      
      //Authority Checks related

      ClassType

} //There can only Configuration Profile for Advanced Variant Configuration 

where
      _ConfigurationCount.ConfigurationProfileCount  is not null
  and ConfigurationProfiles.EngineProcessingMode       = 'A'

Learn More