A_MaintPlanClfnCharValue

DDL: A_MAINTPLANCLFNCHARVALUE Type: view_entity CONSUMPTION Package: VDM_EAM_MAINTENANCEPLAN
31 Fields 1 Data Sources 2 Associations 2 OData Services

Maintenance Plan Classification Class Characteristics Value

A_MaintPlanClfnCharValue is a Consumption CDS View that provides data about "Maintenance Plan Classification Class Characteristics Value" in SAP S/4HANA. It reads from 1 data source (R_MaintPlanClfnCharValueTP) and exposes 31 fields with key fields MaintenancePlan, ClassType, ClfnCharcValuePositionNumber, CharcInternalID. It has 2 associations to related views. It is exposed through 2 OData services (API_MAINTENANCEPLAN, ASQL_F8664). Part of development package VDM_EAM_MAINTENANCEPLAN.

Data Sources (1)

SourceAliasJoin Type
R_MaintPlanClfnCharValueTP R_MaintPlanClfnCharValueTP from

Associations (2)

CardinalityTargetAliasCondition
[1..1] A_MaintPlanClfnClassChar _Characteristic _Characteristic.MaintenancePlan = $projection.MaintenancePlan and _Characteristic.ClassInternalID = $projection.ClassInternalID and _Characteristic.CharcInternalID = $projection.CharcInternalID
[1..1] A_MaintPlanClfnClass _MaintPlanClass $projection.ClfnObjectID = _MaintPlanClass.MaintenancePlan and $projection.ClassInternalID = _MaintPlanClass.ClassInternalID and $projection.ClassType = _MaintPlanClass.ClassType

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Maintenance Plan Classification Class Characteristics Value view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #CONSUMPTION view
Metadata.ignorePropagatedAnnotations true view

OData Services (2)

ServiceBindingVersionContractRelease
API_MAINTENANCEPLAN API_MAINTENANCEPLAN V2 C2 C1
ASQL_F8664 ASQL_F8664 C2 NOT_RELEASED

Fields (31)

KeyFieldSource TableSource FieldDescription
KEY MaintenancePlan MaintenancePlan MaintenancePlan
KEY ClassType ClassType X Flag
KEY ClfnCharcValuePositionNumber ClfnCharcValuePositionNumber Counter
KEY CharcInternalID CharcInternalID Characteristic Internal ID
Characteristic Characteristic Field Name
CharcDataType CharcDataType Format
Class Class User Group
ClassInternalID ClassInternalID Int class no.
KeyDate KeyDate Maturity Key Date
ChangeNumber ChangeNumber Change Number
CharcValueIntervalType CharcValueIntervalType Code
CharcValue CharcValue Char. Value
CharcFromNumericValue CharcFromNumericValue Value from
CharcFromNumericValueUnit CharcFromNumericValueUnit Internal UoM
CharcToNumericValue CharcToNumericValue Value to
CharcToNumericValueUnit CharcToNumericValueUnit Internal UoM
CharcFromDecimalValue CharcFromDecimalValue LowrBndry Nmrc
CharcToDecimalValue CharcToDecimalValue UprBndry Nmrc
ClfnObjectID ClfnObjectID
CharcFromAmount CharcFromAmount LowrBndry Crcy
CharcToAmount CharcToAmount UprBndry Crcy
Currency Currency Valuation Crcy
CharcFromDate CharcFromDate LowrBndry Date
CharcToDate CharcToDate UprBndry Date
CharcFromTime CharcFromTime LowrBndry Time
CharcToTime CharcToTime UprBndry Time
CharcMaintAuthGrp CharcMaintAuthGrp
ClassMaintAuthGrp ClassMaintAuthGrp
ClassClassfctnAuthGrp ClassClassfctnAuthGrp
_Characteristic _Characteristic
_MaintPlanClass _MaintPlanClass

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_MaintPlanClfnCharValue.
-- 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_MaintPlanClfnCharValue AS
SELECT
  MaintenancePlan,
  ClassType,
  ClfnCharcValuePositionNumber,
  CharcInternalID,
  Characteristic,
  CharcDataType,
  Class,
  ClassInternalID,
  KeyDate,
  ChangeNumber,
  CharcValueIntervalType,
  CharcValue,
  CharcFromNumericValue,
  CharcFromNumericValueUnit,
  CharcToNumericValue,
  CharcToNumericValueUnit,
  CharcFromDecimalValue,
  CharcToDecimalValue,
  ClfnObjectID,
  CharcFromAmount,
  CharcToAmount,
  Currency,
  CharcFromDate,
  CharcToDate,
  CharcFromTime,
  CharcToTime,
  CharcMaintAuthGrp,
  ClassMaintAuthGrp,
  ClassClassfctnAuthGrp
FROM R_MaintPlanClfnCharValueTP
LEFT OUTER JOIN A_MaintPlanClfnClassChar AS _Characteristic ON _Characteristic.MaintenancePlan = MaintenancePlan AND _Characteristic.ClassInternalID = ClassInternalID AND _Characteristic.CharcInternalID = CharcInternalID  -- association [1..1]
LEFT OUTER JOIN A_MaintPlanClfnClass AS _MaintPlanClass ON ClfnObjectID = _MaintPlanClass.MaintenancePlan AND ClassInternalID = _MaintPlanClass.ClassInternalID AND ClassType = _MaintPlanClass.ClassType  -- association [1..1]
;

Learn More