P_RELEASEDCONFIGURATIONPROFILE

CDS View

Advanced Var Confign Released Profile

P_RELEASEDCONFIGURATIONPROFILE is a CDS View in S/4HANA. Advanced Var Confign Released Profile. It contains 14 fields. 4 CDS views read from this table.

Used by 4 CDS view(s) 14 fields

CDS Views using this table (4)

ViewTypeJoinVDMDescription
C_ProductConfigurationProfile view from CONSUMPTION Configuration Profile for Products
P_ConfignOvwPgSalesDocItem view inner CONSUMPTION
P_ConfigurableProduct view inner CONSUMPTION
P_ConfigurableProductPlantSmpl view inner CONSUMPTION

Fields (14)

KeyField CDS FieldsUsed in Views
KEY ConfigurationProfileNumber ConfigurationProfileNumber 1
KEY ProductConfiguration Product 1
BOMExplosionApplication BOMExplosionApplication 1
BOMExplosionLevel BOMExplosionLevel 1
ClassType ClassType 1
ConfigurationProfileName ConfigurationProfileName 1
ConfigurationProfileProcess ConfigurationProfileProcess 1
ConfigurationProfileStatus ConfigurationProfileStatus 1
ConfProfileValidityEndDate ConfProfileValidityEndDate 1
ConfProfileValidityStartDate ConfProfileValidityStartDate 1
DependencyObjectNumber ObjDpnAssignmentNumber 1
LastChangeDate LastChangeDate 1
LastChangedByUser LastChangedByUser 1
UserFullName UserDescription 1 
@AbapCatalog.sqlViewName: 'PRELCONFPROFL'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Advanced Var Confign Released Profile'

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

@ClientHandling.algorithm: #SESSION_VARIABLE
define view P_ReleasedConfigurationProfile
  as select from P_AVC_ConfigurationProfiles
{

  key ProductConfiguration,
  key ObjectDatabaseTable,
  key ConfigurationProfileNumber,
      ConfigurationProfileName,
      ConfigurationProfileStatus,
      LastChangedByUser,
      LastChangeDate,
      ConfigurationProfileProcess,
      BOMExplosionLevel,
      BOMExplosionApplication,
      ConfProfileValidityStartDate,
      ConfProfileValidityEndDate,
      DependencyObjectNumber,
      EngineProcessingMode,
      UserFullName,
      ClassType
}
where ConfigurationProfileStatus = '1' 
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_AVC_CONFIGURATIONPROFILES"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More