I_ClfnObjectCharcValForKeyDate

DDL: I_CLFNOBJECTCHARCVALFORKEYDATE SQL: INGCCLFN8 Type: view COMPOSITE Package: NGC_CORE_VDM

Clfn Charc Val of Obj for Key Date

I_ClfnObjectCharcValForKeyDate is a Composite CDS View that provides data about "Clfn Charc Val of Obj for Key Date" in SAP S/4HANA. It reads from 1 data source (I_ClfnObjectCharcValue) and exposes 29 fields with key fields ClfnObjectID, ClfnObjectTable, CharcInternalID, CharcValuePositionNumber, ClfnObjectType. It has 2 associations to related views. Part of development package NGC_CORE_VDM.

1 data source(s) 29 fields

Data Sources (1)

SourceAliasJoin Type
I_ClfnObjectCharcValue Valuation from

Parameters (1)

NameTypeDefault
P_KeyDate sydate

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_ClfnCharacteristicForKeyDate _Characteristic $projection.CharcInternalID = _Characteristic.CharcInternalID
[0..*] I_ClfnCharcValueForKeyDate _CharacteristicValue _CharacteristicValue.CharcInternalID = $projection.CharcInternalID and _CharacteristicValue.CharcValue = $projection.CharcValue

Annotations (12)

NameValueLevelField
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName INGCCLFN8 view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Clfn Charc Val of Obj for Key Date view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view

Fields (29)

KeyFieldSource TableSource FieldDescription
KEY ClfnObjectID I_ClfnObjectCharcValue ClfnObjectID
KEY ClfnObjectTable I_ClfnObjectCharcValue ClfnObjectTable
KEY CharcInternalID I_ClfnObjectCharcValue CharcInternalID
KEY CharcValuePositionNumber I_ClfnObjectCharcValue CharcValuePositionNumber
KEY ClfnObjectType I_ClfnObjectCharcValue ClfnObjectType
KEY ClassType I_ClfnObjectCharcValue ClassType
ClfnObjectInternalID I_ClfnObjectCharcValue ClfnObjectInternalID
CharcValueDependency I_ClfnObjectCharcValue CharcValueIntervalType
CharcValue I_ClfnObjectCharcValue CharcValue
CharcFromNumericValue I_ClfnObjectCharcValue CharcFromNumericValue
CharcFromNumericValueUnit I_ClfnObjectCharcValue CharcFromNumericValueUnit
CharcToNumericValue I_ClfnObjectCharcValue CharcToNumericValue
CharcToNumericValueUnit I_ClfnObjectCharcValue CharcToNumericValueUnit
CharcFromDecimalValue I_ClfnObjectCharcValue CharcFromDecimalValue
CharcToDecimalValue I_ClfnObjectCharcValue CharcToDecimalValue
CharcFromAmount I_ClfnObjectCharcValue CharcFromAmount
CharcToAmount I_ClfnObjectCharcValue CharcToAmount
Currency I_ClfnObjectCharcValue Currency
CharcFromDate I_ClfnObjectCharcValue CharcFromDate
CharcToDate I_ClfnObjectCharcValue CharcToDate
CharcFromTime I_ClfnObjectCharcValue CharcFromTime
CharcToTime I_ClfnObjectCharcValue CharcToTime
CharacteristicAuthor I_ClfnObjectCharcValue CharacteristicAuthor
ChangeNumber I_ClfnObjectCharcValue ChangeNumber
ValidityStartDate I_ClfnObjectCharcValue ValidityStartDate
ValidityEndDate I_ClfnObjectCharcValue ValidityEndDate
LastChangeDateTime I_ClfnObjectCharcValue LastChangeDateTime
_Characteristic _Characteristic
_CharacteristicValue _CharacteristicValue 
@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