I_CONFIGURATIONPROFILE

CDS View

Configuration Profile

I_CONFIGURATIONPROFILE is a CDS View in S/4HANA. Configuration Profile. It contains 15 fields. 4 CDS views read from this table.

Used by 4 CDS view(s) 15 fields

CDS Views using this table (4)

ViewTypeJoinVDMDescription
I_ConfigurationProfileTP view from TRANSACTIONAL Transactional view Config Profile
P_AVC_ConfigurationProfiles view from CONSUMPTION Configuration Profile for Products
P_ConfigurationCount view from CONSUMPTION Simulation - Configurations count
P_SimulationObjectUnion view inner CONSUMPTION Simulation - Simulation Objects Union

Fields (15)

KeyField CDS FieldsUsed in Views
KEY ConfigurationProfileNumber ConfigurationProfileNumber 1
KEY ObjectDatabaseTable ObjectDatabaseTable 1
KEY ProductConfiguration ProductConfiguration 2
BOMExplosionApplication BOMExplosionApplication 1
BOMExplosionLevel BOMExplosionLevel 1
ClassType ClassType 1
ConfigurationProfileName ConfigurationProfileName 1
ConfigurationProfileProcess ConfigurationProfileProcess 2
ConfigurationProfileStatus ConfigurationProfileStatus 1
ConfProfileValidityEndDate ConfProfileValidityEndDate 1
ConfProfileValidityStartDate ConfProfileValidityStartDate 1
DependencyObjectNumber DependencyObjectNumber 1
EngineProcessingMode EngineProcessingMode 1
LastChangeDate LastChangeDate 1
LastChangedByUser LastChangedByUser 1 
@AbapCatalog.sqlViewName: 'ICONFPROFILE'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Configuration Profile'

@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #MASTER

@ClientHandling.algorithm: #SESSION_VARIABLE

@VDM.viewType: #BASIC
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API

@Search.searchable: true
define view I_ConfigurationProfile
  as select from cuco as ConfigurationProfiles

{
          @Search.defaultSearchElement: true
          @Search.ranking: #HIGH
  key     ConfigurationProfiles.objek                        as ProductConfiguration,

  key     ConfigurationProfiles.zaehl                        as ConfigurationProfileNumber,

  key     ConfigurationProfiles.obtab                        as ObjectDatabaseTable,

          ConfigurationProfiles.prfid                        as ConfigurationProfileName,

          ConfigurationProfiles.status                       as ConfigurationProfileStatus,

          @Semantics.user.lastChangedBy: true
          case
            when ConfigurationProfiles.aesbn = '' or ConfigurationProfiles.aedat = ''
                then ConfigurationProfiles.ersnu
            else
                ConfigurationProfiles.aesbn
          end                                                as LastChangedByUser,

          @Semantics.systemTime.lastChangedAt: true
          case
          when ConfigurationProfiles.aesbn = '' or ConfigurationProfiles.aedat = ''
                then ConfigurationProfiles.ersdt
          else
                ConfigurationProfiles.aedat
          end                                                as LastChangeDate,

          //Process

          case
          when  ConfigurationProfiles.kdset = ''
            and ConfigurationProfiles.stlkd = ''
                then 'PORD' // Plnd/Prod. Order

          when  ConfigurationProfiles.kdset = 'X'
                then 'SORD' // Sales Order (SET)

          when  ConfigurationProfiles.stlkd = 'X'
            and ConfigurationProfiles.eoasl = ''
                then 'KBOB' // Knowl.-Based Order BOM

          when ConfigurationProfiles.stlkd = 'X'
           and ConfigurationProfiles.eoasl = 'X'
                then 'ROOB' // Result-Oriented Order BOM

          else ''
          end                                                as ConfigurationProfileProcess,

          //BOM Explosion

          case
          when ConfigurationProfiles.stldy  = 'X'
                then 'N' // None

          when ConfigurationProfiles.single = 'X'
                then 'S' // Single-Level

          when ConfigurationProfiles.valev  = 'X'
                then 'M' // Multilevel

          else ''
          end                                                as BOMExplosionLevel,

          //BOM Application

          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

}
where
  kzloe != 'X' //Deletion marker

Learn More