P_IBINVALIDCONFIGURATIONS

CDS View

P_IBINVALIDCONFIGURATIONS is a CDS View in S/4HANA. It contains 4 fields. 3 CDS views read from this table.

Used by 3 CDS view(s) 4 fields

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_VariantConfigurationSimln view inner BASIC Simulation Database Interface View
P_ConfignOvwPgSalesDocItem view inner CONSUMPTION
P_SimulationObjectUnion view inner CONSUMPTION

Fields (4)

KeyField CDS FieldsUsed in Views
ConfigurationProfileNumber ConfigurationProfileNumber 3
cstatus ConfigurationStatus 2
instance ProductConfiguration 1
LastChangeDate VariantConfigurationSimlnDate 1 
@AbapCatalog.sqlViewName: 'PIBINVALIDCONF'
@AbapCatalog.preserveKey: true
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED

@ClientHandling.algorithm: #SESSION_VARIABLE

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

define view P_IbinValidConfigurations
  as select from P_Ibin as _IBaseInstance
{

  key _IBaseInstance.mandt,
  key _IBaseInstance.in_recno,
      _IBaseInstance.instance,
      _IBaseInstance.cstatus,

      _IBaseInstance.LastChangeDate,
      _IBaseInstance.ConfigurationProfileNumber
// Only select those that are still valid

} where _IBaseInstance.valto > tstmp_current_utctimestamp()
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_IBIN"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More