I_TaskPlanningDesignBasic

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_TaskPlanningDesignBasic.
-- 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 I_TaskPlanningDesignBasic AS
SELECT
  desguid AS TaskPlanningDesignUUID,
  cast(desnum as /cum/desnum preserving type) AS TaskPlanningDesignNumber,
  cast(destyp as /cum/destyp preserving type) AS TaskPlanningDesignType,
  descat AS TaskPlanningDesignCategory,
  objnr AS TaskPlanningDesignInternalID,
  cast(prfid as /cum/prfid_ord preserving type) AS TaskPlanningDesignProfile,
  cast(begru as iautg preserving type) AS TechObjAuthorizationGroup,
  cast(iwerk as iwerk preserving type) AS MaintenancePlanningPlant,
  cast(auart as aufart preserving type) AS MaintenanceOrderType,
  cast(ilart as ila preserving type) AS MaintenanceActivityType,
  cast(priok as priok preserving type) AS MaintPriority,
  cast(anlzu as anlzu preserving type) AS OperationSystemCondition,
  cast(ingrp as ingrp preserving type) AS MaintenancePlannerGroup,
  cast(vaplz as gewrk preserving type) AS MainWorkCenter,
  txjcd AS TaxJurisdiction,
  cast(posid as ps_posid_edit preserving type) AS WBSElement,
  cast(gsber as gsber preserving type) AS BusinessArea,
  gstrp AS MaintOrdBasicStartDate,
  gltrp AS MaintOrdBasicEndDate,
  cast(tplnr as tplnr_unconverted) AS FunctionalLocation,
  equnr AS Equipment,
  cast(bautl as bautl preserving type) AS Assembly,
  ktext AS TaskPlanningDesignDescription,
  cast(cmnum as /cum/cmnum preserving type) AS ConstructionMeasure,
  cast(aufnr as aufnr preserving type) AS MaintenanceOrder,
  erdat AS RecordCreatedDate,
  ernam AS RecordCreatedByUser,
  aedat AS LastChangedDate,
  aenam AS ChangedByName,
  local_last_changed_at AS LoclInstanceLastChangeDateTime,
  last_changed_at AS LastChangeDateTime,
  last_changed_by AS LastChangedByUser
FROM /cum/cudesign
;