I_InternalOrder

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_InternalOrder.
-- 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: IFIINTERNALORDER

CREATE VIEW I_InternalOrder AS
SELECT
  cast( aufnr as fins_int_aufnr preserving type ) AS InternalOrder,
  cast(ktext as fis_internalorder_text) AS InternalOrderDescription,
  autyp AS OrderCategory,
  cast(gsber as fis_rbusa) AS BusinessArea,
  cast(kokrs as fis_kokrs preserving type ) AS ControllingArea,
  werks AS Plant,
  waers AS Currency,
  cast (astkz as fins_co_xaufnr_stat preserving type ) AS IsStatisticalOrder,
  cast(refnr as fis_aufrefnr preserving type ) AS ReferenceOrder,
  kdauf AS SalesOrder,
  kdpos AS SalesOrderItem,
  pspel AS WBSElement,
  cast ( pspel as ps_s4_pspnr preserving type ) AS WBSElementInternalID,
  akstl AS RequestingCostCenter,
  abukr AS RequestingCompanyCode,
  anfaufnr AS RequestingOrder,
  cast( stort as fco_io_aufstort preserving type ) AS InternalOrderLocation,
  sowrk AS LocationPlant,
  aufex AS ExternalOrder,
  cast( cycle as fins_st_kostl preserving type ) AS ActualPostedCostCenter,
  plgkz AS PlanningWithLineItemsIsActive,
  cast(kostl as fis_kostl preserving type ) AS CostCenter,
  logsystem AS LogicalSystem,
  cast(plint as fco_plint preserving type ) AS OrdIsUsedInIntegratedPlanning,
  cast ( txjcd as fis_txjcd preserving type ) AS TaxJurisdiction,
  cast(abgsl as fco_abgr_schl preserving type ) AS ResultAnalysisInternalID,
  kvewe AS ConditionUsage,
  kappl AS ConditionApplication,
  kalsm AS CostingSheet,
  cast(zschl as fco_aufzschl preserving type ) AS OverheadCode,
  cast(zschm as fco_io_ps_zschm preserving type ) AS OrderInterestCalcProfile,
  cast(kstar as fco_aufkstar preserving type ) AS IntOrderSettlementCostElement,
  saknr AS BasicSettlementGLAccount,
  user0 AS IntOrderIndividualField1Value,
  user1 AS IntOrderIndividualField2Value,
  user2 AS IntOrderIndividualField3Value,
  user3 AS IntOrderIndividualField4Value,
  user4 AS IntOrderIndividualField5Amount,
  user5 AS IntOrderIndividualField6Date,
  user6 AS IntOrderIndividualField7Value,
  user7 AS IntOrderIndividualField8Date,
  user8 AS IntOrderIndividualField9Date,
  user9 AS IntOrderIndividualField10Value,
  cast(abkrs as fco_aufabkrs preserving type ) AS OrderProcessingGroup,
  cast(ivpro as fco_im_profil preserving type ) AS InvestmentProfile,
  cast(sizecl as fco_im_sizecl preserving type ) AS InvestmentScale,
  izwek AS InvestmentReason,
  umwkz AS EnvironmentalInvestmentReason,
  vname AS JointVenture,
  recid AS JointVentureRecoveryCode,
  etype AS JointVentureEquityType,
  jv_oco AS JointVentureOriginalCostObject,
  otype AS JointVentureObjectType,
  jv_jibcl AS JointVentureClass,
  jv_jibsa AS JointVentureSubClass,
  loekz AS IsDeleted,
  erdat AS CreationDate,
  erfzeit AS CreationTime,
  cast(ernam as fin_usnam preserving type ) AS CreatedByUser,
  aenam AS LastChangedByUser,
  aedat AS LastChangeDate,
  aezeit AS LastChangeTime,
  objnr AS ControllingObject,
  cast(bukrs as fis_bukrs preserving type ) AS CompanyCode,
  cast(prctr as fis_prctr) AS ProfitCenter,
  cast(func_area as fm_farea) AS FunctionalArea,
  cast(scope as fis_scope_cv_conv) AS ControllingObjectClass,
  auart AS OrderType,
  cast( kostv as fin_io_aufkostv preserving type ) AS ResponsibleCostCenter,
  cast( veraa_user as fco_veraa_user preserving type ) AS InternalOrderResponsibleUser,
  pdat1 AS IntOrderPlannedReleaseDate,
  pdat2 AS IntOrderPlannedCompletionDate,
  pdat3 AS IntOrderPlannedClosingDate,
  idat1 AS InternalOrderReleaseDate,
  idat2 AS InternalOrderCompletionDate,
  idat3 AS InternalOrderClosingDate,
  cckey AS CostCollector
FROM aufk
LEFT OUTER JOIN I_ControllingArea AS _ControllingAreaText ON ControllingArea = _ControllingAreaText.ControllingArea  -- association [0..1]
LEFT OUTER JOIN I_InternalOrderTypeText AS _InternalOrderTypeText ON OrderType = _InternalOrderTypeText.OrderType  -- association [0..*]
LEFT OUTER JOIN I_ControllingArea AS _ControllingArea ON ControllingArea = _ControllingArea.ControllingArea  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_ProfitCenter AS _ProfitCenter ON ControllingArea = _ProfitCenter.ControllingArea AND ProfitCenter = _ProfitCenter.ProfitCenter  -- association [0..*]
LEFT OUTER JOIN I_FunctionalArea AS _FunctionalArea ON FunctionalArea = _FunctionalArea.FunctionalArea  -- association [0..1]
LEFT OUTER JOIN I_ControllingObjectClass AS _ControllingObjectClass ON ControllingObjectClass = _ControllingObjectClass.ControllingObjectClass  -- association [0..1]
LEFT OUTER JOIN I_InternalOrderType AS _InternalOrderType ON OrderType = _InternalOrderType.OrderType  -- association [0..1]
LEFT OUTER JOIN I_CostCenter AS _CostCenter ON ControllingArea = _CostCenter.ControllingArea AND ResponsibleCostCenter = _CostCenter.CostCenter  -- association [0..*]
LEFT OUTER JOIN I_InternalOrderSystemStatus AS _SystemStatus ON ControllingObject = _SystemStatus.ControllingObject  -- association [0..*]
LEFT OUTER JOIN E_LogisticsOrder AS _Extension ON InternalOrder = _Extension.OrderID  -- association [1..1]
LEFT OUTER JOIN I_ProfitCenterText AS _CurProfitCenterText ON ControllingArea = _CurProfitCenterText.ControllingArea AND ProfitCenter = _CurProfitCenterText.ProfitCenter AND _CurProfitCenterText.ValidityStartDate <= $session.system_date AND _CurProfitCenterText.ValidityEndDate >= $session.system_date  -- association [0..*]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [0..1]
LEFT OUTER JOIN I_User AS _User ON InternalOrderResponsibleUser = _User.UserID  -- association [0..1]
LEFT OUTER JOIN I_BusinessArea AS _BusinessArea ON BusinessArea = _BusinessArea.BusinessArea  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _Currency ON Currency = _Currency.Currency  -- association [0..1]
LEFT OUTER JOIN I_OrderCategory AS _OrderCategory ON OrderCategory = _OrderCategory.OrderCategory  -- association [0..1]
LEFT OUTER JOIN I_CostCenterText AS _CurRespCostCenterText ON ControllingArea = _CurRespCostCenterText.ControllingArea AND ResponsibleCostCenter = _CurRespCostCenterText.CostCenter AND _CurRespCostCenterText.ValidityStartDate <= $session.system_date AND _CurRespCostCenterText.ValidityEndDate >= $session.system_date  -- association [0..*]
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElementBasicData ON WBSElementInternalID = _WBSElementBasicData.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_CostCenter AS _RequestingCostCenter ON RequestingCostCenter = _RequestingCostCenter.CostCenter AND ControllingArea = _RequestingCostCenter.ControllingArea  -- association [0..*]
LEFT OUTER JOIN I_CostCenterText AS _CurRequestingCostCenterText ON ControllingArea = _CurRequestingCostCenterText.ControllingArea AND RequestingCostCenter = _CurRequestingCostCenterText.CostCenter AND _CurRequestingCostCenterText.ValidityStartDate <= $session.system_date AND _CurRequestingCostCenterText.ValidityEndDate >= $session.system_date  -- association [0..*]
LEFT OUTER JOIN I_CompanyCode AS _RequestingCompanyCode ON RequestingCompanyCode = _RequestingCompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_Order AS _RequestingOrder ON RequestingOrder = _RequestingOrder.OrderID  -- association [0..1]
LEFT OUTER JOIN I_Location AS _Location ON InternalOrderLocation = _Location.Location AND LocationPlant = _Location.Plant  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _LocationPlant ON LocationPlant = _LocationPlant.Plant  -- association [0..1]
LEFT OUTER JOIN I_CostCenter AS _ActualPostedCostCenter ON ControllingArea = _ActualPostedCostCenter.ControllingArea AND ActualPostedCostCenter = _ActualPostedCostCenter.CostCenter  -- association [0..*]
LEFT OUTER JOIN I_CostCenterText AS _CurActualPostedCostCenterText ON ControllingArea = _CurActualPostedCostCenterText.ControllingArea AND ActualPostedCostCenter = _CurActualPostedCostCenterText.CostCenter AND _CurActualPostedCostCenterText.ValidityStartDate <= $session.system_date AND _CurActualPostedCostCenterText.ValidityEndDate >= $session.system_date  -- association [0..*]
LEFT OUTER JOIN I_CostCenter AS _CostCenterData ON ControllingArea = _CostCenterData.ControllingArea AND CostCenter = _CostCenterData.CostCenter  -- association [0..*]
LEFT OUTER JOIN I_CostCenterText AS _CurCostCenterDataText ON ControllingArea = _CurCostCenterDataText.ControllingArea AND CostCenter = _CurCostCenterDataText.CostCenter AND _CurCostCenterDataText.ValidityStartDate <= $session.system_date AND _CurCostCenterDataText.ValidityEndDate >= $session.system_date  -- association [0..*]
LEFT OUTER JOIN I_LogicalSystem AS _LogicalSystem ON LogicalSystem = _LogicalSystem.LogicalSystem  -- 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_CostElementOnControllingArea AS _IntOrderSettlementCostElement ON ControllingArea = _IntOrderSettlementCostElement.ControllingArea AND IntOrderSettlementCostElement = _IntOrderSettlementCostElement.CostElement  -- association [0..*]
LEFT OUTER JOIN I_GLAccountInCompanyCode AS _BasicSettlementGLAccount ON CompanyCode = _BasicSettlementGLAccount.CompanyCode AND BasicSettlementGLAccount = _BasicSettlementGLAccount.GLAccount  -- association [0..1]
LEFT OUTER JOIN I_OrderProcessingGroup AS _OrderProcessingGroup ON ControllingArea = _OrderProcessingGroup.ControllingArea AND OrderProcessingGroup = _OrderProcessingGroup.OrderProcessingGroup  -- association [0..1]
LEFT OUTER JOIN I_InvestmentProfile AS _InvestmentProfile ON InvestmentProfile = _InvestmentProfile.InvestmentProfile  -- association [0..1]
LEFT OUTER JOIN I_InvestmentReason AS _InvestmentReason ON InvestmentReason = _InvestmentReason.InvestmentReason  -- association [0..1]
LEFT OUTER JOIN I_EnvrnmtlInvestmentReason AS _EnvrnmtlInvestmentReason ON EnvironmentalInvestmentReason = _EnvrnmtlInvestmentReason.EnvrnmtlInvestmentReason  -- association [0..1]
LEFT OUTER JOIN I_JointVentureMaster AS _JointVentureMaster ON CompanyCode = _JointVentureMaster.CompanyCode AND JointVenture = _JointVentureMaster.JointVenture  -- association [0..1]
LEFT OUTER JOIN I_JointVentureRecovery AS _JointVentureRecovery ON JointVentureRecoveryCode = _JointVentureRecovery.JointVentureRecoveryCode AND CompanyCode = _JointVentureRecovery.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_JntVntrEquityTypeMaster AS _JntVntrEquityTypeMaster ON JointVentureEquityType = _JntVntrEquityTypeMaster.JointVentureEquityType AND CompanyCode = _JntVntrEquityTypeMaster.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_JntVntrCostCtrType AS _JntVntrCostCtrType ON JointVentureObjectType = _JntVntrCostCtrType.JntVntrCostCtrType AND CompanyCode = _JntVntrCostCtrType.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_JntIntrstBillgClass AS _JntIntrstBillgClass ON JointVentureClass = _JntIntrstBillgClass.JntIntrstBillgClass AND CompanyCode = _JntIntrstBillgClass.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_JntIntrstBillgSubclass AS _JntIntrstBillgSubclass ON CompanyCode = _JntIntrstBillgSubclass.CompanyCode AND JointVentureClass = _JntIntrstBillgSubclass.JntIntrstBillgClass AND JointVentureSubClass = _JntIntrstBillgSubclass.JntIntrstBillgSubClass  -- association [0..1]
LEFT OUTER JOIN I_UserContactCard AS _ResponsibleUser ON InternalOrderResponsibleUser = _ResponsibleUser.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_UserContactCard AS _CreatedByUser ON CreatedByUser = _CreatedByUser.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_UserContactCard AS _LastChangedByUser ON LastChangedByUser = _LastChangedByUser.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_ResultsAnalysisKey AS _ResultsAnalysisKey ON ResultAnalysisInternalID = _ResultsAnalysisKey.ResultAnalysisInternalID  -- association [0..1]
LEFT OUTER JOIN I_InvestmentObjectScale AS _InvestmentObjectScale ON InvestmentScale = _InvestmentObjectScale.InvestmentScale  -- association [0..1]
LEFT OUTER JOIN I_IntOrderActiveSystemStatus AS _IntOrderActiveSystemStatus ON ControllingObject = _IntOrderActiveSystemStatus.StatusObject  -- association [0..*]
LEFT OUTER JOIN I_IntOrderActiveUserStatus AS _IntOrderActiveUserStatus ON ControllingObject = _IntOrderActiveUserStatus.StatusObject  -- association [0..*]
;