SWD_C_USER_ATTR_RedefState

DDL: SWD_C_USER_ATTR_REDEFSTATE Type: view_entity Package: SWD
19 Fields 2 Data Sources

Customer Attributes: Redefinition Status

SWD_C_USER_ATTR_RedefState is a CDS View that provides data about "Customer Attributes: Redefinition Status" in SAP S/4HANA. It reads from 2 data sources (swd_usratt, swddusratt) and exposes 19 fields with key fields task, nodeid. Part of development package SWD.

Data Sources (2)

SourceAliasJoin Type
swd_usratt customizing left_outer
swddusratt definition from

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Customer Attributes: Redefinition Status view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY task swddusratt task Task/Log Entry
KEY nodeid
scenario swddusratt scenario VAT Scenario
value_type swddusratt value_type Value Type
value_field swddusratt value_field
unit_expr swddusratt unit_expr Printout
active swddusratt active Usage Active
skip_initial swddusratt skip_initial Skip if INIT
on_error swddusratt on_error
operation swddusratt operation Transaction
exit_class swddusratt exit_class Reference to
changed_at swddusratt changed_at Timestamp
changed_by swddusratt changed_by User Name
masterlang swddusratt masterlang Single-Character Flag
rank swddusratt rank Sequence No.
cds_entity
xsd_type swddusratt xsd_type XSD Type
xsd_length swddusratt xsd_length XSD Length
xsd_decimals swddusratt xsd_decimals XSD Decimals

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 SWD_C_USER_ATTR_RedefState.
-- 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 SWD_C_USER_ATTR_RedefState AS
SELECT
  definition.task AS task,
  cast( definition.nodeid as swd_usratt_nodeid preserving type ) AS nodeid,
  definition.scenario AS scenario,
  definition.value_type AS value_type,
  definition.value_field AS value_field,
  definition.unit_expr AS unit_expr,
  definition.active AS active,
  definition.skip_initial AS skip_initial,
  definition.on_error AS on_error,
  definition.operation AS operation,
  definition.exit_class AS exit_class,
  definition.changed_at AS changed_at,
  definition.changed_by AS changed_by,
  definition.masterlang AS masterlang,
  definition.rank AS rank,
  cast( definition.cds_entity as swd_usratt_cds_entity preserving type ) AS cds_entity,
  definition.xsd_type AS xsd_type,
  definition.xsd_length AS xsd_length,
  definition.xsd_decimals AS xsd_decimals
FROM swddusratt AS definition
LEFT OUTER JOIN swd_usratt AS customizing ON /* join condition not captured in parsed metadata */
;

Learn More