I_PSDAlternativeResource

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_PSDAlternativeResource.
-- 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_PSDAlternativeResource AS
SELECT
  /sapapo/psdres.def_set_id AS ProductStorageDefinition,
  /sapapo/psdres.storprod_id AS PSDProduct,
  /sapapo/psdres.storres_id AS PSDAlternativeResource,
  /sapapo/psdres.resid AS ResourceUUID,
  cast( /sapapo/psdres.valid_to as /sapapo/psd_res_validto preserving type ) AS ResourceValidToDateTime,
  cast( /sapapo/psdres.valid_from as /sapapo/psd_res_validfrom preserving type ) AS ResourceValidFromDateTime,
  /sapapo/psdres.is_set_by_extsys AS PSDIsSetByExternalSystem,
  /sapapo/psdres.priority AS PSDResourcePriority,
  /sapapo/psdres.user_created AS CreatedByUserName,
  /sapapo/psdres.time_stamp_cre AS CreationDateTime,
  /sapapo/psdres.user_modified AS LastChangedByUser,
  /sapapo/psdres.time_stamp_mod AS LastChangeDateTime,
  /sapapo/psdres.var_duration AS PSDAltvRsceVariableDuration,
  /sapapo/psdres.var_dur_unit AS PSDAltvRsceVarblDurnUnit,
  /sapapo/psdres.fixed_duration AS PSDAltvRsceFixedDuration,
  /sapapo/psdres.fixed_dur_unit AS PSDAltvRsceFxdDurnUnit,
  /sapapo/psdres.tdpp_lnk AS TimeDepdntProcParamUUID,
  /sapapo/psdres.max_short_break AS PSDAltvRsceMaxShortBreak,
  /sapapo/res_head.name AS AdvncdPlngResourceName,
  /sapapo/res_txt.text AS AdvncdPlngResourceText,
  case when /sapapo/mrploc.locid is not initial then /sapapo/mrploc.locno else /sapapo/loc.locno end as Location AS locnoendasLocation,
  case when /sapapo/mrploct.descr40 is not initial then /sapapo/mrploct.descr40 else /sapapo/loct.descr40 end as LocationDescription AS descr40endasLocationDescription,
  case when /sapapo/mrploc.loctype is not initial then /sapapo/mrploc.loctype else /sapapo/loc.loctype end as LocationType AS loctypeendasLocationType,
  case when /sapapo/loc_sub.locid is not initial then /sapapo/loc_sub.locid else /sapapo/loc.locid end as AdvncdPlngLocationID AS locidendasAdvncdPlngLocationID,
  /sapapo/ressubl.subloc AS StorageLocation,
  t001l.lgobe AS StorageLocationDesc
FROM /sapapo/psdres
INNER JOIN /sapapo/res_head ON /* join condition not captured in parsed metadata */
INNER JOIN /sapapo/loc ON /* join condition not captured in parsed metadata */
;