R_FuncnlLocClfnCharValueTP

DDL: R_FUNCNLLOCCLFNCHARVALUETP Type: view_entity TRANSACTIONAL Package: IEQM
30 Fields 2 Data Sources 1 Associations

Characteristic Values

R_FuncnlLocClfnCharValueTP is a Transactional CDS View that provides data about "Characteristic Values" in SAP S/4HANA. It reads from 2 data sources (I_ClfnObjectCharc, I_ClfnObjectCharcValForKeyDate) and exposes 30 fields with key fields FunctionalLocation, ClassType, CharcValuePositionNumber, CharcInternalID. It has 1 association to related views. Part of development package IEQM.

Data Sources (2)

SourceAliasJoin Type
I_ClfnObjectCharc I_ClfnObjectCharc inner
I_ClfnObjectCharcValForKeyDate I_ClfnObjectCharcValForKeyDate from

Associations (1)

CardinalityTargetAliasCondition
[0..1] R_FunctionalLocationTP _FunctionalLocation $projection.FunctionalLocation = _FunctionalLocation.FunctionalLocation

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label 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 FunctionalLocation Values ClfnObjectID
KEY ClassType Values ClassType X Flag
KEY CharcValuePositionNumber Values CharcValuePositionNumber
KEY CharcInternalID Values CharcInternalID Characteristic Internal ID
FunctionalLocationLabelName _Characteristic FunctionalLocationLabelName Functional Loc.
Characteristic
CharcDataType
ClassInternalID I_ClfnObjectCharc ClassInternalID Int class no.
KeyDate
ChangeNumber Values ChangeNumber Change Number
CharcValueDependency Values CharcValueDependency Code
CharcValue Values CharcValue Char. Value
CharcFromNumericValue Values CharcFromNumericValue Value from
CharcFromNumericValueUnit Values CharcFromNumericValueUnit Internal UoM
CharcToNumericValue Values CharcToNumericValue Value to
CharcToNumericValueUnit Values CharcToNumericValueUnit Internal UoM
CharcFromDecimalValue Values CharcFromDecimalValue LowrBndry Nmrc
CharcToDecimalValue Values CharcToDecimalValue UprBndry Nmrc
CharcFromAmount Values CharcFromAmount LowrBndry Crcy
CharcToAmount Values CharcToAmount UprBndry Crcy
Currency Values Currency Valuation Crcy
CharcFromDate Values CharcFromDate LowrBndry Date
CharcToDate Values CharcToDate UprBndry Date
CharcFromTime Values CharcFromTime LowrBndry Time
CharcToTime Values CharcToTime UprBndry Time
CharcMaintAuthGrp
ClassMaintAuthGrp _Characteristic ClassMaintAuthGrp
ClassClassfctnAuthGrp _Characteristic ClassClassfctnAuthGrp
_Characteristic _Characteristic
_FunctionalLocation _FunctionalLocation

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_FuncnlLocClfnCharValueTP.
-- 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_FuncnlLocClfnCharValueTP AS
SELECT
  Values.ClfnObjectID AS FunctionalLocation,
  Values.ClassType AS ClassType,
  Values.CharcValuePositionNumber AS CharcValuePositionNumber,
  Values.CharcInternalID AS CharcInternalID,
  _Characteristic.FunctionalLocationLabelName AS FunctionalLocationLabelName,
  Values._Characteristic(P_KeyDate: $session.system_date).Characteristic AS Characteristic,
  Values._Characteristic(P_KeyDate: $session.system_date).CharcDataType AS CharcDataType,
  I_ClfnObjectCharc.ClassInternalID AS ClassInternalID,
  $session.system_date AS KeyDate,
  Values.ChangeNumber AS ChangeNumber,
  Values.CharcValueDependency AS CharcValueDependency,
  Values.CharcValue AS CharcValue,
  Values.CharcFromNumericValue AS CharcFromNumericValue,
  Values.CharcFromNumericValueUnit AS CharcFromNumericValueUnit,
  Values.CharcToNumericValue AS CharcToNumericValue,
  Values.CharcToNumericValueUnit AS CharcToNumericValueUnit,
  Values.CharcFromDecimalValue AS CharcFromDecimalValue,
  Values.CharcToDecimalValue AS CharcToDecimalValue,
  Values.CharcFromAmount AS CharcFromAmount,
  Values.CharcToAmount AS CharcToAmount,
  Values.Currency AS Currency,
  Values.CharcFromDate AS CharcFromDate,
  Values.CharcToDate AS CharcToDate,
  Values.CharcFromTime AS CharcFromTime,
  Values.CharcToTime AS CharcToTime,
  Values._Characteristic(P_KeyDate: $session.system_date).CharcMaintAuthGrp AS CharcMaintAuthGrp,
  _Characteristic.ClassMaintAuthGrp AS ClassMaintAuthGrp,
  _Characteristic.ClassClassfctnAuthGrp AS ClassClassfctnAuthGrp
FROM I_ClfnObjectCharcValForKeyDate
INNER JOIN I_ClfnObjectCharc ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN R_FunctionalLocationTP AS _FunctionalLocation ON FunctionalLocation = _FunctionalLocation.FunctionalLocation  -- association [0..1]
;

Learn More