I_ControllingOrder

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_ControllingOrder.
-- 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: ICTRLGORDER

CREATE VIEW I_ControllingOrder AS
SELECT
  cast(aufk.aufnr as fis_order_number) AS OrderID,
  cast(aufk.ktext as fis_order_text) AS OrderDescription,
  aufk.auart AS OrderType,
  cast(aufk.autyp as fis_auftyp) AS OrderCategory,
  aufk.refnr AS ReferenceOrder,
  cast(aufk.aufex as fis_external_order_number) AS ExternalOrder,
  aufk.objnr AS ObjectInternalID,
  aufk.waers AS Currency,
  aufk.werks AS Plant,
  afko.gmein AS BaseUnit,
  aufk.kokrs AS ControllingArea,
  aufk.bukrs AS CompanyCode,
  _CompanyCode.Currency AS CompanyCodeCurrency,
  aufk.gsber AS BusinessArea,
  aufk.prctr AS ProfitCenter,
  cast(aufk.kostv as fis_resp_cctr) AS ResponsibleCostCenter,
  cast(pspel as fis_wbsint_no_conv) AS WBSElementInternalID,
  aufk.loekz AS IsMarkedForDeletion,
  cast(aufk.flg_mltps as fis_co_mltps) AS MfgOrderHasMultipleItems,
  cast(afko.klvari as fis_kalkvarist) AS ActualCostsCostingVariant,
  cast(afko.klvarp as kalkvarpln ) AS PlannedCostsCostingVariant,
  aufk.eb_post AS OrderIsEventBasedPosting,
  aufk.eb_post AS EventBasedPostingMethod,
  aufk.eb_post_type AS OrderSettlementTriggerType,
  cast(afko.aufpl as pph_aufpl preserving type) AS MfgOrderInternalID,
  cast(aufk.pdat2 as fis_aufpdat2) AS PlannedCompletionDate,
  cast(aufk.ernam as fclm_bam_created_by) AS CreatedByUser,
  cast(aufk.erdat as fis_auferfdat) AS CreationDate,
  cast(aufk.aenam as fis_aufaenam) AS LastChangedByUser,
  cast(aufk.aedat as fis_aufaedat) AS LastChangeDate,
  cast(aufk.idat2 as fis_aufidat2) AS TechnicalCompletionDate,
  cast(afko.gltrs as fis_co_gltrs) AS ScheduledBasicEndDate,
  cast(afko.ftrms as fis_co_ftrms) AS ScheduledReleaseDate,
  cast(afko.gstri as fis_co_gstri) AS ActualStartDate,
  cast(afko.getri as fis_getri) AS ConfirmedEndDate,
  cast(afko.ftrmi as fis_co_ftrmi) AS ActualReleasedDate,
  aufk.astkz AS IsStatisticalOrder,
  aufk.akstl AS RequestingCostCenter,
  aufk.kostl AS CostCenter,
  aufk.cycle AS ActualPostedCostCenter,
  aufk.abgsl AS ResultAnalysisInternalID,
  aufk.ebw_key AS EventBasedProcessingKey,
  aufk.kdauf AS SalesOrder,
  aufk.kdpos AS SalesOrderItem,
  aufk.kalsm AS CostingSheet
FROM aufk
LEFT OUTER JOIN I_ProductCostCtrlgOrderItem AS _RepresentativeOrderItem ON OrderID = _RepresentativeOrderItem.OrderID AND _RepresentativeOrderItem.OrderItem = '0001'  -- association [0..1]
LEFT OUTER JOIN I_ControllingArea AS _ControllingArea ON ControllingArea = _ControllingArea.ControllingArea  -- association [1..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN E_ProductCostCtrlgOrder AS _Extension ON OrderID = _Extension.OrderID  -- association [1..1]
LEFT OUTER JOIN I_OrderType AS _OrderType ON OrderType = _OrderType.OrderType  -- association [1..1]
LEFT OUTER JOIN I_OrderCategory AS _OrderCategory ON OrderCategory = _OrderCategory.OrderCategory  -- association [1..1]
LEFT OUTER JOIN I_FiscCalendarDateForCompCode AS _FiscCalendarDateForCompCode ON CreationDate = _FiscCalendarDateForCompCode.CalendarDate AND CompanyCode = _FiscCalendarDateForCompCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_MaintenanceOrder AS _MaintenanceOrder ON OrderID = _MaintenanceOrder.MaintenanceOrder  -- association [0..1]
;