I_ChFiExClfnObjCharcForKeyDate

DDL: I_CHFIEXCLFNOBJCHARCFORKEYDATE SQL: ICHFIEXCLFNKD Type: view COMPOSITE

Classification Obj Charac for Key date

I_ChFiExClfnObjCharcForKeyDate is a Composite CDS View that provides data about "Classification Obj Charac for Key date" in SAP S/4HANA. It reads from 1 data source (I_ClfnObjectCharcValForKeyDate) and exposes 29 fields with key fields ClfnObjectID, ClfnObjectTable, CharcInternalID, CharcValuePositionNumber, ClfnObjectType.

1 data source(s) 29 fields

Data Sources (1)

SourceAliasJoin Type
I_ClfnObjectCharcValForKeyDate I_ClfnObjectCharcValForKeyDate from

Parameters (1)

NameTypeDefault
P_KeyDate sydate

Annotations (10)

NameValueLevelField
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName ICHFIEXCLFNKD view
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Classification Obj Charac for Key date view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view

Fields (29)

KeyFieldSource TableSource FieldDescription
KEY ClfnObjectID ClfnObjectID
KEY ClfnObjectTable ClfnObjectTable
KEY CharcInternalID CharcInternalID
KEY CharcValuePositionNumber CharcValuePositionNumber
KEY ClfnObjectType ClfnObjectType
KEY ClassType ClassType
ClfnObjectInternalID ClfnObjectInternalID
CharcValueIntervalType CharcValueDependency
CharcValue CharcValue
CharcFromNumericValue CharcFromNumericValue
CharcFromNumericValueUnit CharcFromNumericValueUnit
CharcToNumericValue CharcToNumericValue
CharcToNumericValueUnit CharcToNumericValueUnit
CharcFromDecimalValue CharcFromDecimalValue
CharcToDecimalValue CharcToDecimalValue
CharcFromAmount CharcFromAmount
CharcToAmount CharcToAmount
Currency Currency
CharcFromDate CharcFromDate
CharcToDate CharcToDate
CharcFromTime CharcFromTime
CharcToTime CharcToTime
CharacteristicAuthor CharacteristicAuthor
ChangeNumber ChangeNumber
ValidityStartDate ValidityStartDate
ValidityEndDate ValidityEndDate
LastChangeDateTime LastChangeDateTime
Characteristic
_Characteristic _Characteristic 
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.sqlViewName: 'ICHFIEXCLFNKD'
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Classification Obj Charac for Key date'
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.dataClass: #MIXED
@VDM.viewType: #COMPOSITE

define view I_ChFiExClfnObjCharcForKeyDate 
   with parameters
    @Consumption.hidden: true
    @Environment.systemField: #SYSTEM_DATE
    P_KeyDate : sydate
  as select from I_ClfnObjectCharcValForKeyDate
  (P_KeyDate : $parameters.P_KeyDate)
  
    {    
    key ClfnObjectID,
    key ClfnObjectTable,
    key CharcInternalID,
    key CharcValuePositionNumber,
    key ClfnObjectType,
    key ClassType,
    ClfnObjectInternalID,
    CharcValueDependency as CharcValueIntervalType,  //old name is deprecated and kept only in released views for compatibility

    CharcValue,
    CharcFromNumericValue,
    CharcFromNumericValueUnit,
    CharcToNumericValue,
    CharcToNumericValueUnit,
    CharcFromDecimalValue,
    CharcToDecimalValue,
    CharcFromAmount,
    CharcToAmount,
    Currency,
    CharcFromDate,
    CharcToDate,
    CharcFromTime,
    CharcToTime,
    CharacteristicAuthor,
    ChangeNumber,
    ValidityStartDate,
    ValidityEndDate,
    LastChangeDateTime,
    /* Associations */
    //I_ClfnObjectCharcValForKeyDate

    _Characteristic( P_KeyDate: $parameters.P_KeyDate).Characteristic as Characteristic,
    _Characteristic    
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CLFNCHARACTERISTICFORKEYDATE",
"I_CLFNOBJECTCHARCVALFORKEYDATE"
],
"ASSOCIATED":
[
"I_CLFNCHARACTERISTICFORKEYDATE"
],
"BASE":
[
"I_CLFNOBJECTCHARCVALFORKEYDATE"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More