SWDDUSRATT
Workflow Definition: User Attributes
SWDDUSRATT is an SAP database table in S/4HANA. Workflow Definition: User Attributes. It contains 26 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| SWD_C_USER_ATTR_RedefState | view_entity | from | Customer Attributes: Redefinition Status |
Fields (26)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | task | SWD_USRATT_TASK | Task | |||
| KEY | nodeid | SWD_USRATT_NODEID | Step ID | |||
| KEY | attribute_name | SWD_USRATT_NAME | Name of Attribute | |||
| scenario | SWD_USECASE | Use Case | ||||
| value_expr | SWA_EXPR | Printout | ||||
| value_type | SWC_TYPE | ABAP type | ||||
| value_field | abap.char | |||||
| unit_expr | SWA_EXPR | Printout | ||||
| active | SWD_ACTIVE | Active | ||||
| skip_initial | SWFBNDSKPI | Skip if INIT | ||||
| on_error | abap.char | |||||
| operation | SWFBNDOP | Operation | ||||
| exit_class | CLASSNAME | Reference to | ||||
| changed_at | SWFUTLCREATST | Created At | ||||
| changed_by | SYUNAME | User Name | ||||
| masterlang | SYLANGU | Language Key | ||||
| rank | SWD_TASK_RANK | Rank | ||||
| cds_entity | SWD_USRATT_CDS_ENTITY | CDS Entity | ||||
| cds_entity_field | SWD_USRATT_CDS_ENTITY_FIELD | CDS Entity Element | ||||
| xsd_type | SWD_XSD_TYPE | XSD Type | ||||
| xsd_length | SWD_XSD_LENGTH | XSD Length | ||||
| xsd_decimals | SWD_XSD_DECIMALS | XSD Decimals | ||||
| type | SWD_USRATT_TYPE | Type of Attribute | ||||
| ref_attribute_name | SWD_USRATT_NAME | Name of Attribute | ||||
| ref_attribute_path | SWD_USRATT_REF_ATTR_PATH | RefAttribute Path | ||||
| text_arrangement | SWD_USRATT_TEXT_ARRANGEMENT | Text Arrangement |
Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.
-- Workflow Definition: User Attributes
-- Category TRANSPARENT · Delivery class S
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SWDDUSRATT (
TASK, -- Task [SWD_USRATT_TASK]
NODEID, -- Step ID [SWD_USRATT_NODEID]
ATTRIBUTE_NAME, -- Name of Attribute [SWD_USRATT_NAME]
SCENARIO, -- Use Case [SWD_USECASE]
VALUE_EXPR, -- Printout [SWA_EXPR]
VALUE_TYPE, -- ABAP type [SWC_TYPE]
VALUE_FIELD, -- abap.char
UNIT_EXPR, -- Printout [SWA_EXPR]
ACTIVE, -- Active [SWD_ACTIVE]
SKIP_INITIAL, -- Skip if INIT [SWFBNDSKPI]
ON_ERROR, -- abap.char
OPERATION, -- Operation [SWFBNDOP]
EXIT_CLASS, -- Reference to [CLASSNAME]
CHANGED_AT, -- Created At [SWFUTLCREATST]
CHANGED_BY, -- User Name [SYUNAME]
MASTERLANG, -- Language Key [SYLANGU]
RANK, -- Rank [SWD_TASK_RANK]
CDS_ENTITY, -- CDS Entity [SWD_USRATT_CDS_ENTITY]
CDS_ENTITY_FIELD, -- CDS Entity Element [SWD_USRATT_CDS_ENTITY_FIELD]
XSD_TYPE, -- XSD Type [SWD_XSD_TYPE]
XSD_LENGTH, -- XSD Length [SWD_XSD_LENGTH]
XSD_DECIMALS, -- XSD Decimals [SWD_XSD_DECIMALS]
TYPE, -- Type of Attribute [SWD_USRATT_TYPE]
REF_ATTRIBUTE_NAME, -- Name of Attribute [SWD_USRATT_NAME]
REF_ATTRIBUTE_PATH, -- RefAttribute Path [SWD_USRATT_REF_ATTR_PATH]
TEXT_ARRANGEMENT, -- Text Arrangement [SWD_USRATT_TEXT_ARRANGEMENT]
PRIMARY KEY (TASK, NODEID, ATTRIBUTE_NAME)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA