R_EquipmentClfnCharValueTP

DDL: R_EQUIPMENTCLFNCHARVALUETP Type: view_entity TRANSACTIONAL
30 Fields 3 Data Sources 1 Associations

Equipment Characteristic Values

R_EquipmentClfnCharValueTP is a Transactional 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, ClfnCharcValuePositionNumber, CharcInternalID. 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] R_EquipmentTP _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 #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_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 ClfnCharcValuePositionNumber Valuation CharcValuePositionNumber
KEY CharcInternalID Valuation CharcInternalID Characteristic Internal ID
Characteristic
CharcDataType
ClassInternalID I_ClfnObjectCharc ClassInternalID Int class no.
KeyDate
ChangeNumber Valuation ChangeNumber Change Number
CharcValueIntervalType 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 R_EquipmentClfnCharValueTP.
-- 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 R_EquipmentClfnCharValueTP AS
SELECT
  I_Equipment.Equipment AS Equipment,
  Valuation.ClassType AS ClassType,
  Valuation.CharcValuePositionNumber AS ClfnCharcValuePositionNumber,
  Valuation.CharcInternalID AS CharcInternalID,
  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 CharcValueIntervalType,
  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 R_EquipmentTP AS _Equipment ON Equipment = _Equipment.Equipment AND ValidityEndDate = _Equipment.ValidityEndDate  -- association [1..1]
;

Learn More