A_EquipmentClfnCharValue

DDL: A_EQUIPMENTCLFNCHARVALUE Type: view_entity COMPOSITE
30 Fields 3 Data Sources 1 Associations

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.

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 Equipment check
KEY ClassType Valuation ClassType X Flag
KEY CharcValuePositionNumber Valuation CharcValuePositionNumber
KEY CharacteristicInternalID Valuation CharcInternalID Characteristic Internal ID
Characteristic
CharcDataType
ClassInternalID I_ClfnObjectCharc ClassInternalID Int class no.
KeyDate
ChangeNumber Valuation ChangeNumber Change Number
CharcValueDependency Valuation CharcValueDependency Code
CharcValue Valuation CharcValue Char. Value
CharcFromNumericValue Valuation CharcFromNumericValue Value from
CharcFromNumericValueUnit Valuation CharcFromNumericValueUnit Internal UoM
CharcToNumericValue Valuation CharcToNumericValue Value to
CharcToNumericValueUnit Valuation CharcToNumericValueUnit Internal UoM
CharcFromDecimalValue Valuation CharcFromDecimalValue LowrBndry Nmrc
CharcToDecimalValue Valuation CharcToDecimalValue UprBndry Nmrc
CharcFromAmount Valuation CharcFromAmount LowrBndry Crcy
CharcToAmount Valuation CharcToAmount UprBndry Crcy
Currency Valuation Currency Valuation Crcy
CharcFromDate Valuation CharcFromDate LowrBndry Date
CharcToDate Valuation CharcToDate UprBndry Date
CharcFromTime Valuation CharcFromTime LowrBndry Time
CharcToTime Valuation CharcToTime UprBndry Time
ValidityEndDate I_Equipment ValidityEndDate ValidTo
CharcMaintAuthGrp
ClassMaintAuthGrp _Characteristic ClassMaintAuthGrp
ClassClassfctnAuthGrp _Characteristic ClassClassfctnAuthGrp
_Characteristic _Characteristic
_Equipment _Equipment

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view A_EquipmentClfnCharValue.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW A_EquipmentClfnCharValue AS
SELECT
  I_Equipment.Equipment AS Equipment,
  Valuation.ClassType AS ClassType,
  Valuation.CharcValuePositionNumber AS CharcValuePositionNumber,
  Valuation.CharcInternalID AS CharacteristicInternalID,
  Valuation._Characteristic(P_KeyDate: $session.system_date).Characteristic AS Characteristic,
  Valuation._Characteristic(P_KeyDate: $session.system_date).CharcDataType AS CharcDataType,
  I_ClfnObjectCharc.ClassInternalID AS ClassInternalID,
  $session.system_date AS KeyDate,
  Valuation.ChangeNumber AS ChangeNumber,
  Valuation.CharcValueDependency AS CharcValueDependency,
  Valuation.CharcValue AS CharcValue,
  Valuation.CharcFromNumericValue AS CharcFromNumericValue,
  Valuation.CharcFromNumericValueUnit AS CharcFromNumericValueUnit,
  Valuation.CharcToNumericValue AS CharcToNumericValue,
  Valuation.CharcToNumericValueUnit AS CharcToNumericValueUnit,
  Valuation.CharcFromDecimalValue AS CharcFromDecimalValue,
  Valuation.CharcToDecimalValue AS CharcToDecimalValue,
  Valuation.CharcFromAmount AS CharcFromAmount,
  Valuation.CharcToAmount AS CharcToAmount,
  Valuation.Currency AS Currency,
  Valuation.CharcFromDate AS CharcFromDate,
  Valuation.CharcToDate AS CharcToDate,
  Valuation.CharcFromTime AS CharcFromTime,
  Valuation.CharcToTime AS CharcToTime,
  I_Equipment.ValidityEndDate AS ValidityEndDate,
  Valuation._Characteristic(P_KeyDate: $session.system_date).CharcMaintAuthGrp AS CharcMaintAuthGrp,
  _Characteristic.ClassMaintAuthGrp AS ClassMaintAuthGrp,
  _Characteristic.ClassClassfctnAuthGrp AS ClassClassfctnAuthGrp
FROM I_ClfnObjectCharcValForKeyDate
INNER JOIN I_Equipment ON /* join condition not captured in parsed metadata */
INNER JOIN I_ClfnObjectCharc ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN A_Equipment AS _Equipment ON Equipment = _Equipment.Equipment AND ValidityEndDate = _Equipment.ValidityEndDate  -- association [1..1]
;

Learn More