I_OrderType

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_OrderType.
-- 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: IPPORDERTYPE

CREATE VIEW I_OrderType AS
SELECT
  typ.auart AS OrderType,
  cast(typ.autyp as pph_autyp preserving type) AS OrderCategory,
  typ.numkr AS OrderNumberRange,
  typ.obligo AS CommitmentsMgmtActvtnStatus,
  typ.stsma AS StatusProfile,
  cast(typ.vrg_stsma as vdm_stsma_op preserving type) AS OperationStatusProfile,
  typ.aprof AS ControllingSettlementProfile,
  typ.pprof AS PlanningProfile,
  typ.bprof AS BudgetProfile,
  typ.exec_profile AS ExecutionServiceProfile,
  cast(typ.scope as pph_scope preserving type) AS ControllingObjectClass,
  typ.func_area AS FunctionalArea,
  typ.copar AS CtrlgTotalsRecordActvtnStatus,
  typ.resz1 AS ResidenceTime1,
  typ.resz2 AS ResidenceTime2,
  typ.layout AS OrderMasterDataLayout,
  typ.tdform AS TextObjectForm,
  typ.configurationdeprecationcode AS ConfigDeprecationCode,
  typ.aufkl AS OrderIsToBeClassified,
  typ.relkz AS OrderIsReleasedUponCreation,
  typ.chgkz AS OrderHasStatusChangeDocuments,
  typ.nabpf AS SettlementIsNotRequired,
  typ.plint AS OrdIsUsedInIntegratedPlanning,
  typ.vorpl AS NetworkIsForPlanning,
  cast(typ.erloese as vdm_pp_erloese preserving type) AS RevenuePostingIsAllowed,
  cast(typ.colordproc as vdm_colordproc preserving type) AS CollectiveOrderHasAutoGoodsMvt
FROM t003o AS typ
LEFT OUTER JOIN I_OrderTypeText AS _Text ON OrderType = _Text.OrderType  -- association [0..*]
LEFT OUTER JOIN I_OrderCategory AS _OrderCategory ON OrderCategory = _OrderCategory.OrderCategory  -- association [0..1]
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_StatusProfile AS _OrderStatusProfile ON StatusProfile = _OrderStatusProfile.StatusProfile  -- association [0..1]
LEFT OUTER JOIN I_StatusProfile AS _OperationStatusProfile ON OperationStatusProfile = _OperationStatusProfile.StatusProfile  -- association [0..1]
;