I_OrderBasic

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_OrderBasic.
-- 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: IORDERBASIC

CREATE VIEW I_OrderBasic AS
SELECT
  aufk.aufnr AS OrderID,
  cast(aufk.autyp as pph_autyp preserving type) AS OrderCategory,
  cast(aufk.auart as aufart preserving type) AS OrderType,
  cast(aufk.ktext as pph_auftext preserving type) AS OrderDescription,
  cast(aufk.ltext as pph_longtextlang) AS LongTextLanguage,
  aufk.loekz AS IsMarkedForDeletion,
  aufk.astkz AS IsStatisticalOrder,
  aufk.flg_mltps AS OrderHasMultipleItems,
  aufk.rsord AS OrderIsRefurbishmentOrder,
  cast(aufk.plint as fco_plint preserving type ) AS OrdIsUsedInIntegratedPlanning,
  cast(aufk.erdat as ordercreationdate preserving type) AS CreationDate,
  cast(aufk.erfzeit as ordercreationtime preserving type) AS CreationTime,
  aufk.ernam AS CreatedByUser,
  aufk.aedat AS LastChangeDate,
  aufk.aezeit AS LastChangeTime,
  aufk.aenam AS LastChangedByUser,
  cast(aufk.refnr as fis_aufrefnr preserving type) AS ReferenceOrder,
  aufk.werks AS Plant,
  aufk.vaplz AS MainWorkCenter,
  aufk.wawrk AS MainWorkCenterPlant,
  aufk.stort AS MaintenanceObjectLocation,
  aufk.sowrk AS LocationPlant,
  aufk.kdauf AS SalesOrder,
  aufk.kdpos AS SalesOrderItem,
  aufk.pspel AS WBSElementInternalID,
  cast(aufk.pspel as ps_s4_pspnr preserving type) AS WBSElementInternalID_2,
  cast(aufk.objnr as pph_objnr preserving type) AS ObjectInternalID,
  aufk.zschm AS ProjInterestCalcProfile,
  aufk.aufex AS ExternalOrder,
  aufk.gsber AS BusinessArea,
  aufk.bukrs AS CompanyCode,
  aufk.abukr AS RequestingCompanyCode,
  aufk.kokrs AS ControllingArea,
  aufk.prctr AS ProfitCenter,
  aufk.kostl AS CostCenter,
  aufk.akstl AS RequestingCostCenter,
  cast(aufk.kostv as pph_kostl preserving type) AS ResponsibleCostCenter,
  cast(aufk.kstar as pph_kstar preserving type) AS CostElement,
  aufk.saknr AS GLAccount,
  aufk.pkosa AS ProductCostCollector,
  aufk.kvewe AS ConditionUsage,
  aufk.kappl AS ConditionApplication,
  aufk.kalsm AS CostingSheet,
  cast(aufk.scope as pph_scope preserving type) AS ControllingObjectClass,
  aufk.func_area AS FunctionalArea,
  cast(aufk.abkrs as fco_aufabkrs preserving type) AS OrderProcessingGroup,
  cast(aufk.zschl as fco_aufzschl preserving type) AS OverheadCode,
  cast(aufk.cycle as fins_st_kostl preserving type) AS ActualPostedCostCenter,
  cast(aufk.txjcd as fis_txjcd preserving type) AS TaxJurisdiction,
  cast(aufk.abgsl as fco_abgr_schl preserving type) AS ResultAnalysisInternalID,
  aufk.awsls AS VarianceKey,
  aufk.eb_post AS EventBasedPostingMethod,
  aufk.ebw_key AS EventBasedProcessingKey,
  aufk.vname AS JointVenture,
  aufk.jv_jibcl AS JointVentureClass,
  aufk.jv_jibsa AS JointVentureSubClass,
  aufk.jv_oco AS JointVentureOriginalCostObject,
  aufk.otype AS JointVentureObjectType,
  aufk.izwek AS InvestmentReason,
  aufk.umwkz AS EnvironmentalInvestmentReason,
  aufk.pdat1 AS PlannedReleaseDate,
  aufk.pdat2 AS PlannedCompletionDate,
  aufk.idat1 AS OrderActualReleaseDate,
  aufk.idat2 AS TechnicalCompletionDate,
  aufk.idat3 AS OrderActualCloseDate,
  aufk.waers AS Currency,
  aufk.user4 AS EstimatedTotalOrderCost,
  aufk.phas0 AS OrderIsCreated,
  aufk.phas1 AS OrderIsReleased,
  aufk.phas2 AS OrderIsCompleted,
  aufk.phas3 AS OrderIsClosed,
  aufk.oba_active AS ObjBasedAuthorizationIsActive
FROM aufk
LEFT OUTER JOIN I_OrderCategory AS _OrderCategory ON OrderCategory = _OrderCategory.OrderCategory  -- association [1..1]
LEFT OUTER JOIN I_OrderType AS _OrderType ON OrderType = _OrderType.OrderType  -- association [1..1]
LEFT OUTER JOIN I_OrderLongText AS _LongText ON OrderID = _LongText.OrderID  -- association [0..1]
LEFT OUTER JOIN I_Order AS _ReferenceOrder ON ReferenceOrder= _ReferenceOrder.OrderID  -- association [1..1]
LEFT OUTER JOIN I_LogisticsOrderBasic AS _LogisticsOrder ON OrderID = _LogisticsOrder.OrderID  -- association [1..1]
LEFT OUTER JOIN I_OrderHierarchyNode AS _OrderHierarchyNode ON OrderID = _OrderHierarchyNode.OrderID  -- association [0..*]
LEFT OUTER JOIN I_User AS _CreatedByUser ON CreatedByUser = _CreatedByUser.UserID  -- association [1..1]
LEFT OUTER JOIN I_User AS _LastChangedByUser ON LastChangedByUser = _LastChangedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _Currency ON Currency = _Currency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Language AS _LongTextLanguage ON LongTextLanguage = _LongTextLanguage.Language  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [1..1]
LEFT OUTER JOIN I_Plant AS _MainWorkCenterPlant ON MainWorkCenterPlant = _MainWorkCenterPlant.Plant  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _LocationPlant ON LocationPlant = _LocationPlant.Plant  -- association [0..1]
LEFT OUTER JOIN I_WorkCenterBySemanticKey AS _MainWorkCenter ON MainWorkCenter = _MainWorkCenter.WorkCenter AND MainWorkCenterPlant = _MainWorkCenter.Plant  -- association [0..1]
LEFT OUTER JOIN I_Location AS _MaintenanceObjectLocation ON LocationPlant = _MaintenanceObjectLocation.Plant AND MaintenanceObjectLocation = _MaintenanceObjectLocation.Location  -- association [0..1]
LEFT OUTER JOIN I_SalesOrder AS _SalesOrder ON SalesOrder = _SalesOrder.SalesOrder  -- association [0..1]
LEFT OUTER JOIN I_SalesOrderItem AS _SalesOrderItem ON SalesOrder = _SalesOrderItem.SalesOrder AND SalesOrderItem = _SalesOrderItem.SalesOrderItem  -- association [0..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElementBasicData ON WBSElementInternalID = _WBSElementBasicData.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElementBasicData2 ON WBSElementInternalID_2 = _WBSElementBasicData2.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_StatusObject AS _StatusObject ON ObjectInternalID = _StatusObject.StatusObject  -- association [1..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _RequestingCompanyCode ON RequestingCompanyCode = _RequestingCompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_BusinessArea AS _BusinessArea ON BusinessArea = _BusinessArea.BusinessArea  -- association [0..1]
LEFT OUTER JOIN I_ProfitCenter AS _ProfitCenter ON ControllingArea = _ProfitCenter.ControllingArea AND ProfitCenter = _ProfitCenter.ProfitCenter  -- association [0..*]
LEFT OUTER JOIN I_CostCenter AS _CostCenter ON ControllingArea = _CostCenter.ControllingArea AND CostCenter = _CostCenter.CostCenter  -- association [0..*]
LEFT OUTER JOIN I_CostCenter AS _ResponsibleCostCenter ON ControllingArea = _ResponsibleCostCenter.ControllingArea AND ResponsibleCostCenter = _ResponsibleCostCenter.CostCenter  -- association [0..*]
LEFT OUTER JOIN I_CostCenter AS _RequestingCostCenter ON RequestingCostCenter = _RequestingCostCenter.CostCenter AND ControllingArea = _RequestingCostCenter.ControllingArea  -- association [0..*]
LEFT OUTER JOIN I_ProductCostCtrlgOrder AS _ProductCostCtrlgOrder ON ProductCostCollector = _ProductCostCtrlgOrder.OrderID  -- association [0..1]
LEFT OUTER JOIN I_GLAccount AS _GLAccount ON GLAccount = _GLAccount.GLAccount AND CompanyCode = _GLAccount.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_CostElement AS _CostElement ON ControllingArea = _CostElement.ControllingArea AND CostElement = _CostElement.CostElement  -- association [0..1]
LEFT OUTER JOIN I_ControllingArea AS _ControllingArea ON ControllingArea = _ControllingArea.ControllingArea  -- association [0..1]
LEFT OUTER JOIN I_ControllingObjectClass AS _ControllingObjectClass ON ControllingObjectClass = _ControllingObjectClass.ControllingObjectClass  -- association [0..1]
LEFT OUTER JOIN I_FunctionalArea AS _FunctionalArea ON FunctionalArea = _FunctionalArea.FunctionalArea  -- association [0..1]
LEFT OUTER JOIN I_ConditionUsage AS _ConditionUsage ON ConditionUsage = _ConditionUsage.ConditionUsage  -- association [0..1]
LEFT OUTER JOIN I_ConditionApplication AS _ConditionApplication ON ConditionApplication = _ConditionApplication.ConditionApplication  -- association [0..1]
LEFT OUTER JOIN I_CostingSheetProcedure AS _CostingSheetProcedure ON ConditionUsage = _CostingSheetProcedure.ConditionUsage AND ConditionApplication = _CostingSheetProcedure.ConditionApplication AND CostingSheet = _CostingSheetProcedure.CostingSheetProcedure  -- association [0..1]
LEFT OUTER JOIN I_OrderProcessingGroup AS _OrderProcessingGroup ON ControllingArea = _OrderProcessingGroup.ControllingArea AND OrderProcessingGroup = _OrderProcessingGroup.OrderProcessingGroup  -- association [0..1]
;