A_EquipmentClfnCharValue

DDL: A_EQUIPMENTCLFNCHARVALUE Type: view_entity COMPOSITE

Equipment Characteristic Values

A_EquipmentClfnCharValue is a Composite CDS View that provides data about "Equipment Characteristic Values" in SAP S/4HANA. It reads from 3 data sources (I_ClfnObjectCharc, I_ClfnObjectCharcValForKeyDate, I_Equipment) and exposes 30 fields with key fields Equipment, ClassType, CharcValuePositionNumber, CharacteristicInternalID. It has 1 association to related views.

3 data source(s) 30 fields

Data Sources (3)

SourceAliasJoin Type
I_ClfnObjectCharc I_ClfnObjectCharc inner
I_ClfnObjectCharcValForKeyDate I_ClfnObjectCharcValForKeyDate from
I_Equipment I_Equipment inner

Associations (1)

CardinalityTargetAliasCondition
[1..1] A_Equipment _Equipment $projection.Equipment = _Equipment.Equipment and $projection.ValidityEndDate = _Equipment.ValidityEndDate

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Equipment Characteristic Values view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view

Fields (30)

KeyFieldSource TableSource FieldDescription
KEY Equipment I_Equipment Equipment
KEY ClassType Valuation ClassType
KEY CharcValuePositionNumber Valuation CharcValuePositionNumber
KEY CharacteristicInternalID Valuation CharcInternalID
Characteristic
CharcDataType
ClassInternalID I_ClfnObjectCharc ClassInternalID
KeyDate
ChangeNumber Valuation ChangeNumber
CharcValueDependency Valuation CharcValueDependency
CharcValue Valuation CharcValue
CharcFromNumericValue Valuation CharcFromNumericValue
CharcFromNumericValueUnit Valuation CharcFromNumericValueUnit
CharcToNumericValue Valuation CharcToNumericValue
CharcToNumericValueUnit Valuation CharcToNumericValueUnit
CharcFromDecimalValue Valuation CharcFromDecimalValue
CharcToDecimalValue Valuation CharcToDecimalValue
CharcFromAmount Valuation CharcFromAmount
CharcToAmount Valuation CharcToAmount
Currency Valuation Currency
CharcFromDate Valuation CharcFromDate
CharcToDate Valuation CharcToDate
CharcFromTime Valuation CharcFromTime
CharcToTime Valuation CharcToTime
ValidityEndDate I_Equipment ValidityEndDate
CharcMaintAuthGrp
ClassMaintAuthGrp _Characteristic ClassMaintAuthGrp
ClassClassfctnAuthGrp _Characteristic ClassClassfctnAuthGrp
_Characteristic _Characteristic
_Equipment _Equipment 
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Equipment Characteristic Values'

@VDM.viewType: #COMPOSITE
@VDM.lifecycle.contract.type: #PUBLIC_REMOTE_API
@Metadata.ignorePropagatedAnnotations: true

@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.dataClass: #MIXED
define view entity A_EquipmentClfnCharValue 
  as select from I_ClfnObjectCharcValForKeyDate(P_KeyDate: $session.system_date) as Valuation  
                  inner join I_Equipment on I_Equipment.Equipment = Valuation.ClfnObjectID 
                  inner join I_ClfnObjectCharc on  Valuation.ClfnObjectID = I_ClfnObjectCharc.ClfnObjectID
                                               and Valuation.CharcInternalID = I_ClfnObjectCharc.CharcInternalID
                                               and Valuation.ClassType = I_ClfnObjectCharc.ClassType   
  association [1..1] to A_Equipment as _Equipment on $projection.Equipment = _Equipment.Equipment  
                                                     and $projection.ValidityEndDate = _Equipment.ValidityEndDate                                           
  association to parent A_EquipmentClfnClassChar as _Characteristic on $projection.Equipment = _Characteristic.Equipment
                                                                   and $projection.CharacteristicInternalID  = _Characteristic.CharacteristicInternalID
                                                                   and $projection.ClassInternalID  = _Characteristic.ClassInternalID                                                                                                                                          
    {
    key I_Equipment.Equipment as Equipment,  
    key Valuation.ClassType,
    key Valuation.CharcValuePositionNumber,
    key Valuation.CharcInternalID as CharacteristicInternalID ,    
    Valuation._Characteristic(P_KeyDate: $session.system_date).Characteristic,
    Valuation._Characteristic(P_KeyDate: $session.system_date).CharcDataType,
    I_ClfnObjectCharc.ClassInternalID,      
    $session.system_date as KeyDate,
    Valuation.ChangeNumber,
    Valuation.CharcValueDependency,
    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,
    Valuation.Currency,                           
    Valuation.CharcFromDate,
    Valuation.CharcToDate,
    Valuation.CharcFromTime,
    Valuation.CharcToTime, 
    @Consumption.hidden: true 
    I_Equipment.ValidityEndDate,
    @Consumption.hidden: true
    Valuation._Characteristic(P_KeyDate: $session.system_date).CharcMaintAuthGrp,
    @Consumption.hidden: true
    _Characteristic.ClassMaintAuthGrp,
    @Consumption.hidden: true
    _Characteristic.ClassClassfctnAuthGrp, 
    _Characteristic,
    _Equipment          
  
}where
      Valuation.ClfnObjectTable = 'EQUI' and
      Valuation.ClfnObjectType = 'O'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"A_EQUIPMENTCLFNCLASSCHAR",
"I_CLFNCHARACTERISTICFORKEYDATE",
"I_CLFNOBJECTCHARC",
"I_CLFNOBJECTCHARCVALFORKEYDATE",
"I_EQUIPMENT"
],
"ASSOCIATED":
[
"A_EQUIPMENT",
"A_EQUIPMENTCLFNCLASSCHAR"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More