SWDDUSRATT
Workflow Definition: User Attributes
SWDDUSRATT is an SAP database table in S/4HANA. Workflow Definition: User Attributes. It contains 23 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 (23)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | task | swd_usratt_task | Aufgabe | |||
| KEY | nodeid | swd_usratt_nodeid | ||||
| KEY | attribute_name | swd_usratt_name | ||||
| scenario | swd_usecase | |||||
| value_expr | swa_expr | Printout | ||||
| value_type | swc_type | ABAP type | ||||
| value_field | abap.char | C = CHAR , I = INT4, D = Decimal Floating Point Number | ||||
| unit_expr | swa_expr | Printout | ||||
| active | swd_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 Field | ||||
| type | swd_usratt_type | |||||
| ref_attribute_name | swd_usratt_name | |||||
| ref_attribute_path | swd_usratt_ref_attr_path | |||||
| text_arrangement | swd_usratt_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, -- Aufgabe [swd_usratt_task]
NODEID, -- swd_usratt_nodeid
ATTRIBUTE_NAME, -- swd_usratt_name
SCENARIO, -- swd_usecase
VALUE_EXPR, -- Printout [swa_expr]
VALUE_TYPE, -- ABAP type [swc_type]
VALUE_FIELD, -- C = CHAR , I = INT4, D = Decimal Floating Point Number [abap.char]
UNIT_EXPR, -- Printout [swa_expr]
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 Field [swd_usratt_cds_entity_field]
TYPE, -- swd_usratt_type
REF_ATTRIBUTE_NAME, -- swd_usratt_name
REF_ATTRIBUTE_PATH, -- swd_usratt_ref_attr_path
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