CDR_SCOPE_SGRP
CDR Scope Selection Group
CDR_SCOPE_SGRP is an SAP database table in S/4HANA. CDR Scope Selection Group. It contains 11 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| CDR_I_SCOPE_SGRP_U | view_entity | from | CDR Scope Selection Group |
Fields (11)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | client | MANDT | Client | |||
| KEY | scope_name | CDR_SCOPE_NAME | Scope Name | |||
| KEY | obj_type | CDR_SCOPE_OBJ_TYP | Obj Type | |||
| KEY | obj_name | CDR_SCOPE_OBJ_NAME | Obj Name | |||
| KEY | sgrp_name | CDR_SGRP_NAME | Selection Group Name | |||
| KEY | active | BOOLEAN | Boolean Variable (X = True, - = False, Space = Unknown) | |||
| KEY | setid | CDR_SEL_SETID | SETID | |||
| KEY | valnum | NUMC4 | Counter | |||
| smbr_name | CDR_SMBR_NAME | Member Name | ||||
| fieldname | CDR_FIELD_NAME | Field Name | ||||
| likelyhood | NUMC4 | Counter |
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.
-- CDR Scope Selection Group
-- Category TRANSPARENT · Delivery class L
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CDR_SCOPE_SGRP (
CLIENT, -- Client [MANDT]
SCOPE_NAME, -- Scope Name [CDR_SCOPE_NAME]
OBJ_TYPE, -- Obj Type [CDR_SCOPE_OBJ_TYP]
OBJ_NAME, -- Obj Name [CDR_SCOPE_OBJ_NAME]
SGRP_NAME, -- Selection Group Name [CDR_SGRP_NAME]
ACTIVE, -- Boolean Variable (X = True, - = False, Space = Unknown) [BOOLEAN]
SETID, -- SETID [CDR_SEL_SETID]
VALNUM, -- Counter [NUMC4]
SMBR_NAME, -- Member Name [CDR_SMBR_NAME]
FIELDNAME, -- Field Name [CDR_FIELD_NAME]
LIKELYHOOD, -- Counter [NUMC4]
PRIMARY KEY (CLIENT, SCOPE_NAME, OBJ_TYPE, OBJ_NAME, SGRP_NAME, ACTIVE, SETID, VALNUM)
);
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