I_CLFNOBJECTCHARCVALFORKEYDATE

CDS View

Clfn Charc Val of Obj for Key Date

I_CLFNOBJECTCHARCVALFORKEYDATE is a CDS View in S/4HANA. Clfn Charc Val of Obj for Key Date. 17 CDS views read from this table.

Used by 17 CDS view(s)

CDS Views using this table (17)

ViewTypeJoinVDMDescription
A_ChangeMasterCharcValue view_entity from COMPOSITE Change Number Characteristic Values
A_DocumentInfoRecordCharcValue view from COMPOSITE Classification Characteristic Values
A_EquipmentClfnCharValue view_entity from COMPOSITE Equipment Characteristic Values
A_ProductCharcValue view from COMPOSITE Characteristic Valuations
A_RecProcEquipRqmtCharcValue view from CONSUMPTION Recipe Equipment Requirement Characteristic Values
A_RecProcParamValCharcValue view from CONSUMPTION Recipe Process Parameter Value Characteristic Values
C_EquipmentClfnCharcValueDEX view_entity from CONSUMPTION Equipment Charac Values Data Extraction
C_FuncnlLocClfnCharcValueDEX view_entity from CONSUMPTION Floc Charc Values Data Extraction
I_ChFiExClfnObjCharcForKeyDate view from COMPOSITE Classification Obj Charac for Key date
I_ClfnObjectCharcValueTP view_entity from TRANSACTIONAL TP for Clfn Obj Charc With Value
I_RecipeCharcValueTP view from TRANSACTIONAL TP for Recipe Charc Valuation
P_RelStratCharValues view from COMPOSITE Classification for Release Strategy
P_ZA_CharacteristicsValue view from CONSUMPTION Get the Characteristics Values for ZA BBBEE
R_BatchCharacteristicValueTP view_entity from TRANSACTIONAL Batch Characteristics Valuation
R_EquipmentClfnCharValueTP view_entity from TRANSACTIONAL Equipment Characteristic Values
R_FuncnlLocClfnCharValueTP view_entity from TRANSACTIONAL Characteristic Values
R_MaintPlanClfnCharValueTP view from TRANSACTIONAL Maintenance Plan Classification Class Characteristics Value 
@AbapCatalog.preserveKey: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.sqlViewName: 'INGCCLFN8'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Clfn Charc Val of Obj for Key Date'
@VDM.viewType: #COMPOSITE
@VDM.lifecycle.contract.type: #PUBLIC_LOCAL_API
@Metadata.ignorePropagatedAnnotations: true

@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.supportedCapabilities:
  [  #CDS_MODELING_DATA_SOURCE,
     #CDS_MODELING_ASSOCIATION_TARGET,
     #SQL_DATA_SOURCE                  ]
define view I_ClfnObjectCharcValForKeyDate
  with parameters
    @Consumption.hidden: true
    @Environment.systemField: #SYSTEM_DATE
    P_KeyDate : sydate
  as select from I_ClfnObjectCharcValue as Valuation
      association [1..1] to I_ClfnCharacteristicForKeyDate as _Characteristic 
        on $projection.CharcInternalID = _Characteristic.CharcInternalID   
      association [0..*] to I_ClfnCharcValueForKeyDate as _CharacteristicValue
        on _CharacteristicValue.CharcInternalID    = $projection.CharcInternalID 
        and _CharacteristicValue.CharcValue        = $projection.CharcValue            
{
  key Valuation.ClfnObjectID,
  key Valuation.ClfnObjectTable,
  key Valuation.CharcInternalID,
  key Valuation.CharcValuePositionNumber,
  key Valuation.ClfnObjectType,
  key Valuation.ClassType,
      Valuation.ClfnObjectInternalID,       
      Valuation.CharcValueIntervalType as CharcValueDependency,       // old name is kept for compatibility

      Valuation.CharcValue,
      Valuation.CharcFromNumericValue,  
      Valuation.CharcFromNumericValueUnit,
      Valuation.CharcToNumericValue,     
      Valuation.CharcToNumericValueUnit,
      Valuation.CharcFromDecimalValue,
      Valuation.CharcToDecimalValue,
      @Semantics.amount.currencyCode: 'Currency'
      Valuation.CharcFromAmount,
      @Semantics.amount.currencyCode: 'Currency'
      Valuation.CharcToAmount,
      @Semantics.currencyCode: true
      Valuation.Currency,
      Valuation.CharcFromDate,
      Valuation.CharcToDate,
      Valuation.CharcFromTime,
      Valuation.CharcToTime, 
      Valuation.CharacteristicAuthor,      
      Valuation.ChangeNumber, 
      @Semantics.businessDate.from: true
      Valuation.ValidityStartDate,
      @Semantics.businessDate.to: true
      Valuation.ValidityEndDate,
      Valuation.LastChangeDateTime,
      
      _Characteristic,
      _CharacteristicValue
}
  where ValidityStartDate   <= $parameters.P_KeyDate
    and ValidityEndDate     >= $parameters.P_KeyDate
    and IsDeleted           = ''

Learn More