P_MaintOrderHistoryDuration

DDL: P_MAINTORDERHISTORYDURATION Type: view_entity BASIC
8 Fields 1 Data Sources 1 Associations

P_MaintOrderHistoryDuration is a Basic CDS View in SAP S/4HANA. It reads from 1 data source (hiko) and exposes 8 fields with key field MaintenanceOrder. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
hiko hiko from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_Plant _MaintenancePlanningPlant $projection.MaintenancePlanningPlant = _MaintenancePlanningPlant.Plant

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #BASIC view
VDM.private true view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY MaintenanceOrder hiko aufnr SettlementOrder
OrderCategory hiko autyp Order category
OrderType hiko auart Sales Doc. Type
MaintenancePlanningPlant hiko iwerk Planning Plant
FactoryCalendar _MaintenancePlanningPlant FactoryCalendar Factory Calendar
ActualStartDate hiko gstri Actual start
ConfirmedEndDate hiko getri Actual Finish
_MaintenancePlanningPlant _MaintenancePlanningPlant

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 P_MaintOrderHistoryDuration.
-- 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 P_MaintOrderHistoryDuration AS
SELECT
  hiko.aufnr AS MaintenanceOrder,
  hiko.autyp AS OrderCategory,
  hiko.auart AS OrderType,
  hiko.iwerk AS MaintenancePlanningPlant,
  _MaintenancePlanningPlant.FactoryCalendar AS FactoryCalendar,
  hiko.gstri AS ActualStartDate,
  hiko.getri AS ConfirmedEndDate
FROM hiko
LEFT OUTER JOIN I_Plant AS _MaintenancePlanningPlant ON MaintenancePlanningPlant = _MaintenancePlanningPlant.Plant  -- association [1..1]
;

Learn More