I_MaintOrdFactoryCalendarSel

DDL: I_MAINTORDFACTORYCALENDARSEL SQL: IMTORDFCSEL Type: view BASIC
6 Fields 1 Data Sources 3 Associations

Maintenance Order Factory Calendar Selection

I_MaintOrdFactoryCalendarSel is a Basic CDS View that provides data about "Maintenance Order Factory Calendar Selection" in SAP S/4HANA. It reads from 1 data source (afko_kal) and exposes 6 fields with key field MaintenanceOrder. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
afko_kal afko_kal from

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_MaintenanceOrder _MaintenanceOrder $projection.MaintenanceOrder = _MaintenanceOrder.MaintenanceOrder
[0..1] I_FactoryCalendar _FactoryCalendar $projection.FactoryCalendar = _FactoryCalendar.FactoryCalendar
[0..1] I_FactoryCalendarSelection _FactoryCalendarSelection $projection.FactoryCalendarSelection = _FactoryCalendarSelection.FactoryCalendarSelection

Annotations (8)

NameValueLevelField
EndUserText.label Maintenance Order Factory Calendar Selection view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XL view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.sqlViewName IMTORDFCSEL view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY MaintenanceOrder aufnr SettlementOrder
FactoryCalendar calid Factory Cal. ID
FactoryCalendarSelection kalsn Cal. Selection
_MaintenanceOrder _MaintenanceOrder
_FactoryCalendar _FactoryCalendar
_FactoryCalendarSelection _FactoryCalendarSelection

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 I_MaintOrdFactoryCalendarSel.
-- 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.
-- SQL view name: IMTORDFCSEL

CREATE VIEW I_MaintOrdFactoryCalendarSel AS
SELECT
  aufnr AS MaintenanceOrder,
  calid AS FactoryCalendar,
  kalsn AS FactoryCalendarSelection
FROM afko_kal
LEFT OUTER JOIN I_MaintenanceOrder AS _MaintenanceOrder ON MaintenanceOrder = _MaintenanceOrder.MaintenanceOrder  -- association [0..1]
LEFT OUTER JOIN I_FactoryCalendar AS _FactoryCalendar ON FactoryCalendar = _FactoryCalendar.FactoryCalendar  -- association [0..1]
LEFT OUTER JOIN I_FactoryCalendarSelection AS _FactoryCalendarSelection ON FactoryCalendarSelection = _FactoryCalendarSelection.FactoryCalendarSelection  -- association [0..1]
;

Learn More