SWW_SXMSCONFVL

DDL: SWW_SXMSCONFVL SQL: SWWSXMSCONFVL Type: view
9 Fields 1 Data Sources

Workflow: Private CDS for Workflow Header

SWW_SXMSCONFVL is a CDS View that provides data about "Workflow: Private CDS for Workflow Header" in SAP S/4HANA. It reads from 1 data source (sxmsconfvl) and exposes 9 fields with key fields area, param, subparam, generic.

Data Sources (1)

SourceAliasJoin Type
sxmsconfvl sxmsconfvl from

Parameters (1)

NameTypeDefault
timeZoneUpdate tznzone

Annotations (4)

NameValueLevelField
AbapCatalog.sqlViewName SWWSXMSCONFVL view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Workflow: Private CDS for Workflow Header view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY area area Settings Area
KEY param param Sourcing Project PLM Collaboration Configuration Parameter
KEY subparam subparam Subparameter
KEY generic generic Prefix
value value Value from table
clientNULLaschangedDateZonlo
clientNULLaschangedTimeZonlo
chgtstamp chgtstamp Time Stamp
chguser chguser User Name

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 SWW_SXMSCONFVL.
-- 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: SWWSXMSCONFVL
-- Parameters: timeZoneUpdate : tznzone

CREATE VIEW SWW_SXMSCONFVL AS
SELECT
  area,
  param,
  subparam,
  generic,
  value,
  tstmp_to_dats( sxmsconfvl.chgtstamp, $parameters.timeZoneUpdate, $session.client, 'NULL' ) as changedDateZonlo AS clientNULLaschangedDateZonlo,
  tstmp_to_tims( sxmsconfvl.chgtstamp, $parameters.timeZoneUpdate, $session.client, 'NULL' ) as changedTimeZonlo AS clientNULLaschangedTimeZonlo,
  chgtstamp,
  chguser
FROM sxmsconfvl
;

Learn More