R_InternalOrderTP

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 R_InternalOrderTP.
-- 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 R_InternalOrderTP AS
SELECT
  InternalOrder,
  cast('00000000000000000000000000000000' as sysuuid_c32) AS InternalOrderDraftInternalUUID,
  InternalOrder AS InternalOrderForEdit,
  cast( InternalOrderDescription as kltxt ) AS InternalOrderDescription,
  OrderCategory,
  BusinessArea,
  ControllingArea,
  Plant,
  Currency,
  IsStatisticalOrder,
  ReferenceOrder,
  SalesOrder,
  SalesOrderItem,
  WBSElementInternalID,
  _WBSElementBasicData.WBSElementExternalID AS WBSElementExternalID,
  RequestingCostCenter,
  RequestingCompanyCode,
  RequestingOrder,
  InternalOrderLocation,
  LocationPlant,
  ExternalOrder,
  ActualPostedCostCenter,
  CostCenter,
  LogicalSystem,
  OrdIsUsedInIntegratedPlanning,
  ResultAnalysisInternalID,
  ConditionUsage,
  ConditionApplication,
  CostingSheet,
  OverheadCode,
  OrderInterestCalcProfile,
  IntOrderSettlementCostElement,
  BasicSettlementGLAccount,
  IntOrderIndividualField1Value,
  IntOrderIndividualField2Value,
  IntOrderIndividualField3Value,
  IntOrderIndividualField4Value,
  IntOrderIndividualField5Amount,
  IntOrderIndividualField6Date,
  IntOrderIndividualField7Value,
  IntOrderIndividualField8Date,
  IntOrderIndividualField9Date,
  cast ( IntOrderIndividualField10Value as fco_io_aufuser9 preserving type ) AS IntOrderIndividualField10Value,
  OrderProcessingGroup,
  InvestmentProfile,
  InvestmentScale,
  InvestmentReason,
  EnvironmentalInvestmentReason,
  JointVenture,
  JointVentureRecoveryCode,
  JointVentureEquityType,
  JointVentureOriginalCostObject,
  JointVentureObjectType,
  JointVentureClass,
  JointVentureSubClass,
  CreationDate,
  CreationTime,
  CreatedByUser,
  cast ( LastChangedByUser as fco_io_aufaenam preserving type ) AS LastChangedByUser,
  LastChangeDate,
  LastChangeTime,
  ControllingObject,
  CompanyCode,
  ProfitCenter,
  FunctionalArea,
  ControllingObjectClass,
  OrderType,
  ResponsibleCostCenter,
  InternalOrderResponsibleUser,
  _SystemStatus.ControllingObjectStatus AS ControllingObjectStatus,
  _SystemStatus._Text[1: Language = $session.system_language].SystemStatusShortName AS IntOrderSystemStatusShortName,
  _SystemStatus._Text[1: Language = $session.system_language].StatusName AS InternalOrderSystemStatusName,
  TaxJurisdiction
FROM I_InternalOrder
LEFT OUTER JOIN I_StatusObjectStatusBasic AS _InternalOrderIsLocked ON I_InternalOrder.ControllingObject = _InternalOrderIsLocked.StatusObject AND _InternalOrderIsLocked.StatusCode = 'I0043'  -- association [0..1]
LEFT OUTER JOIN I_StatusObjectStatusBasic AS _IntOrdSettlementRuleIsCreated ON I_InternalOrder.ControllingObject = _IntOrdSettlementRuleIsCreated.StatusObject AND ( _IntOrdSettlementRuleIsCreated.StatusCode = 'I0028' OR _IntOrdSettlementRuleIsCreated.StatusCode = 'I0027' ) AND _IntOrdSettlementRuleIsCreated.StatusIsInactive = ''  -- association [0..1]
LEFT OUTER JOIN I_StatusObjectStatusBasic AS _IntOrdDeletionFlagIsSet ON I_InternalOrder.ControllingObject = _IntOrdDeletionFlagIsSet.StatusObject AND _IntOrdDeletionFlagIsSet.StatusCode = 'I0076'  -- association [0..1]
LEFT OUTER JOIN I_StatusObjectStatusBasic AS _IntOrdIsMarkedForDeletion ON I_InternalOrder.ControllingObject = _IntOrdIsMarkedForDeletion.StatusObject AND _IntOrdIsMarkedForDeletion.StatusCode = 'I0013'  -- association [0..1]
LEFT OUTER JOIN I_TaxJurisdiction AS _TaxJurisdiction ON TaxJurisdiction = _TaxJurisdiction.TaxJurisdiction  -- association [0..1]
LEFT OUTER JOIN E_InternalOrder AS _IOExtention ON InternalOrder = _IOExtention.InternalOrder  -- association [1..1]
LEFT OUTER JOIN E_InternalOrderDraft AS _IOExtentionDraft ON InternalOrderDraftInternalUUID = _IOExtentionDraft.DraftUUID  -- association [1..1]
LEFT OUTER JOIN R_InternalOrderSystemStatusTP AS _InternalOrderSystemStatusTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_IntOrderNumberedUserStatusTP AS _IntOrderNumberedUserStatusTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_IntOrdUnnumberedUserStatusTP AS _IntOrdUnnumberedUserStatusTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_IntOrdOverallSystemStatusTP AS _IntOrdOverallSystemStatusTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_IntOrdLongDescriptionDraftTP AS _IntOrdLongDescriptionDraftTP ON /* condition not available in parsed metadata */  -- association [0..*]
;