I_CLFNOBJECTCHARCFORKEYDATE

CDS View

Clfn Object Characteristic For Key Date

I_CLFNOBJECTCHARCFORKEYDATE is a CDS View in S/4HANA. Clfn Object Characteristic For Key Date. 12 CDS views read from this table.

Used by 12 CDS view(s)

CDS Views using this table (12)

ViewTypeJoinVDMDescription
A_ChangeMasterClassCharc view from COMPOSITE Change Number Class and Characteristic Assignments
A_DocumentInfoRecordCharc view from COMPOSITE Classification Characteristics
A_DocumentInfoRecordClassCharc view from COMPOSITE Classification Class Characteristics
A_EquipmentClfnClassChar view_entity from COMPOSITE Equipment Class Characteristics
A_ProductClassCharc view from COMPOSITE Class Characteristics
A_RecProcEquipRqmtClassCharc view from CONSUMPTION Recipe Equipment Requirement Classification Assignments
A_RecProcParamValClassCharc view from CONSUMPTION Recipe Process Parameter Value Classification Assignments
I_RecipeClassCharcTP view from TRANSACTIONAL TP for Recipe Class Charcs
R_BatchCharacteristicTP view_entity from TRANSACTIONAL Batch Characteristic
R_EquipmentClfnClassCharTP view_entity from TRANSACTIONAL Equipment Class Characteristics
R_FuncnlLocClfnClassCharTP view_entity from TRANSACTIONAL Class Characteristics
R_MaintPlanClfnClassCharTP view from TRANSACTIONAL Maintenance Plan Classification Class Characteristics 
@AbapCatalog.preserveKey: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.sqlViewName: 'INGCCLFN16'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Clfn Object Characteristic For Key Date'
@VDM.viewType: #COMPOSITE
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API

@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.dataClass: #MIXED
define view I_ClfnObjectCharcForKeyDate 
  with parameters
    @Consumption.hidden: true
    @Environment.systemField: #SYSTEM_DATE
    P_KeyDate : sydate
  as select from I_ClfnObjectCharc as ObjectCharc 
  
      association [1..1] to I_ClfnClassForKeyDate as _Class 
        on $projection.ClassInternalID = _Class.ClassInternalID 
      association [1..1] to I_ClfnCharacteristicForKeyDate as _Characteristic 
        on $projection.CharcInternalID = _Characteristic.CharcInternalID 
{
  key ObjectCharc.ClfnObjectID,
  key ObjectCharc.ClfnObjectTable,
  key ObjectCharc.ClfnObjectType,
  key ObjectCharc.ClassInternalID,
  key ObjectCharc.CharcInternalID,
      ObjectCharc.ClfnObjectInternalID,      
      ObjectCharc.ClassType,
      ObjectCharc.ChangeNumber,
      @Semantics.businessDate.from: true
      ObjectCharc.ValidityStartDate,
      @Semantics.businessDate.to: true
      ObjectCharc.ValidityEndDate,
      ObjectCharc.LastChangeDateTime,
      
      _Class,
      _Characteristic     
}
  where ValidityStartDate   <= $parameters.P_KeyDate
    and ValidityEndDate     >= $parameters.P_KeyDate
    and IsDeleted           = ''

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CLFNOBJECTCHARC"
],
"ASSOCIATED":
[
"I_CLFNCHARACTERISTICFORKEYDATE",
"I_CLFNCLASSFORKEYDATE"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More