SCA_ATTR_MD
CI Finding attributes
SCA_ATTR_MD is an SAP database table in S/4HANA. CI Finding attributes. It contains 11 fields. 2 CDS views read from this table.
CDS Views using this table (2)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| SATC_AC_ATT_FOR_DISPL_ID_DDLV | view_entity | inner | Attribute names for a given display ID | |
| SCA_ATTR_DDLV | view | from | Attributes |
Fields (11)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | attribute_name | SYCHAR30 | CHAR30 for SYST | |||
| attribute_data_element | ROLLNAME | Data Element | ||||
| referenced_attr_name | SYCHAR30 | CHAR30 for SYST | ||||
| is_active | BOOLE_D | TRUE | ||||
| is_label | BOOLE_D | TRUE | ||||
| has_multiple_values | BOOLE_D | TRUE | ||||
| filter_function | BOOLE_D | TRUE | ||||
| statistic_function | BOOLE_D | TRUE | ||||
| navigation_handler | SEOCLSNAME | Type Name | ||||
| uri_template | AGR_URL | Internet link | ||||
| statistic_descr_handler | SEOCLSNAME | Type Name |
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.
-- CI Finding attributes
-- Category TRANSPARENT · Delivery class E
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SCA_ATTR_MD (
ATTRIBUTE_NAME, -- CHAR30 for SYST [SYCHAR30]
ATTRIBUTE_DATA_ELEMENT, -- Data Element [ROLLNAME]
REFERENCED_ATTR_NAME, -- CHAR30 for SYST [SYCHAR30]
IS_ACTIVE, -- TRUE [BOOLE_D]
IS_LABEL, -- TRUE [BOOLE_D]
HAS_MULTIPLE_VALUES, -- TRUE [BOOLE_D]
FILTER_FUNCTION, -- TRUE [BOOLE_D]
STATISTIC_FUNCTION, -- TRUE [BOOLE_D]
NAVIGATION_HANDLER, -- Type Name [SEOCLSNAME]
URI_TEMPLATE, -- Internet link [AGR_URL]
STATISTIC_DESCR_HANDLER, -- Type Name [SEOCLSNAME]
PRIMARY KEY (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