I_ClfnCharcValueForKeyDate

DDL: I_CLFNCHARCVALUEFORKEYDATE SQL: INGCCHR8 Type: view COMPOSITE Package: NGC_CORE_VDM

Value of Clfn Charc for Key Date

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

1 data source(s) 30 fields

Data Sources (1)

SourceAliasJoin Type
I_ClfnCharcValue CharacteristicValue from

Parameters (1)

NameTypeDefault
P_KeyDate sydate

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_ClfnCharacteristicForKeyDate _Characteristic $projection.CharcInternalID = _Characteristic.CharcInternalID
[0..*] I_ClfnCharcValueDescForKeyDate _CharacteristicValueDesc $projection.CharcInternalID = _CharacteristicValueDesc.CharcInternalID and $projection.CharcValuePositionNumber = _CharacteristicValueDesc.CharcValuePositionNumber

Annotations (13)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName INGCCHR8 view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Value of Clfn Charc for Key Date view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.representativeKey CharcValuePositionNumber view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.dataClass #MASTER view

Fields (30)

KeyFieldSource TableSource FieldDescription
KEY CharcInternalID I_ClfnCharcValue CharcInternalID
KEY CharcValuePositionNumber I_ClfnCharcValue CharcValuePositionNumber
CharcValueParentPositionNumber I_ClfnCharcValue CharcValueParentPositionNumber
CharcValueHasChild I_ClfnCharcValue CharcValueHasChild
CharcValueDependency I_ClfnCharcValue CharcValueIntervalType
CharcValue I_ClfnCharcValue CharcValue
CharcFromNumericValue I_ClfnCharcValue CharcFromNumericValue
CharcToNumericValue I_ClfnCharcValue CharcToNumericValue
IsDefaultValue I_ClfnCharcValue IsDefaultValue
CharcFromNumericValueUnit I_ClfnCharcValue CharcFromNumericValueUnit
CharcToNumericValueUnit I_ClfnCharcValue CharcToNumericValueUnit
CharcFromDecimalValue I_ClfnCharcValue CharcFromDecimalValue
CharcToDecimalValue I_ClfnCharcValue CharcToDecimalValue
CharcFromDate I_ClfnCharcValue CharcFromDate
CharcToDate I_ClfnCharcValue CharcToDate
CharcFromTime I_ClfnCharcValue CharcFromTime
CharcToTime I_ClfnCharcValue CharcToTime
CharcFromAmount I_ClfnCharcValue CharcFromAmount
CharcToAmount I_ClfnCharcValue CharcToAmount
Currency I_ClfnCharcValue Currency
LongTextID I_ClfnCharcValue LongTextID
ChangeNumber I_ClfnCharcValue ChangeNumber
ValidityStartDate I_ClfnCharcValue ValidityStartDate
ValidityEndDate I_ClfnCharcValue ValidityEndDate
DocumentInfoRecordDocNumber I_ClfnCharcValue DocumentInfoRecordDocNumber
DocumentInfoRecordDocPart I_ClfnCharcValue DocumentInfoRecordDocPart
DocumentInfoRecordDocVersion I_ClfnCharcValue DocumentInfoRecordDocVersion
DocumentInfoRecordDocType I_ClfnCharcValue DocumentInfoRecordDocType
_Characteristic _Characteristic
_CharacteristicValueDesc _CharacteristicValueDesc 
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.sqlViewName: 'INGCCHR8'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Value of Clfn Charc for Key Date'
@VDM.viewType: #COMPOSITE
@VDM.lifecycle.contract.type: #PUBLIC_LOCAL_API
@Metadata.ignorePropagatedAnnotations: true

@ObjectModel.representativeKey: 'CharcValuePositionNumber'
@ObjectModel.usageType.sizeCategory: #M
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.supportedCapabilities:
  [  #CDS_MODELING_DATA_SOURCE,
     #CDS_MODELING_ASSOCIATION_TARGET,
     #SQL_DATA_SOURCE                  ]
/*+[hideWarning] { "IDS" : [ "KEY_CHECK" ] } */
define view I_ClfnCharcValueForKeyDate
  with parameters
    @Consumption.hidden: true
    @Environment.systemField: #SYSTEM_DATE
    P_KeyDate : sydate
  as select from I_ClfnCharcValue as CharacteristicValue        

      association [1..1] to I_ClfnCharacteristicForKeyDate as _Characteristic
        on  $projection.CharcInternalID          = _Characteristic.CharcInternalID   
      
      association [0..*] to I_ClfnCharcValueDescForKeyDate as _CharacteristicValueDesc
        on  $projection.CharcInternalID          = _CharacteristicValueDesc.CharcInternalID
        and $projection.CharcValuePositionNumber = _CharacteristicValueDesc.CharcValuePositionNumber
{
      @ObjectModel.foreignKey.association: '_Characteristic'
  key CharacteristicValue.CharcInternalID,
  key CharacteristicValue.CharcValuePositionNumber,
      CharacteristicValue.CharcValueParentPositionNumber,
      CharacteristicValue.CharcValueHasChild,
      CharacteristicValue.CharcValueIntervalType as CharcValueDependency,   //to keep compatibility

      CharacteristicValue.CharcValue,
      CharacteristicValue.CharcFromNumericValue,
      CharacteristicValue.CharcToNumericValue,
      CharacteristicValue.IsDefaultValue,
      CharacteristicValue.CharcFromNumericValueUnit,
      CharacteristicValue.CharcToNumericValueUnit,
      CharacteristicValue.CharcFromDecimalValue,
      CharacteristicValue.CharcToDecimalValue,
      CharacteristicValue.CharcFromDate,
      CharacteristicValue.CharcToDate,
      CharacteristicValue.CharcFromTime,
      CharacteristicValue.CharcToTime,
      @Semantics.amount.currencyCode: 'Currency'
      CharacteristicValue.CharcFromAmount,
      @Semantics.amount.currencyCode: 'Currency'
      CharacteristicValue.CharcToAmount,
      @Semantics.currencyCode: true
      CharacteristicValue.Currency,        
      CharacteristicValue.LongTextID,
      CharacteristicValue.ChangeNumber,
      @Semantics.businessDate.from: true
      CharacteristicValue.ValidityStartDate,
      @Semantics.businessDate.to: true
      CharacteristicValue.ValidityEndDate,   
      CharacteristicValue.DocumentInfoRecordDocNumber,
      CharacteristicValue.DocumentInfoRecordDocPart,
      CharacteristicValue.DocumentInfoRecordDocVersion,    
      CharacteristicValue.DocumentInfoRecordDocType,  
      
      _Characteristic,
      _CharacteristicValueDesc
}
where CharacteristicValue.ValidityStartDate   <= $parameters.P_KeyDate
and   CharacteristicValue.ValidityEndDate     >= $parameters.P_KeyDate
and   CharacteristicValue.IsDeleted = ''

Learn More