IPUTS_A_SCOPE_SM
Scope Proposal Statistics
IPUTS_A_SCOPE_SM is an SAP database table in S/4HANA. Scope Proposal Statistics. It contains 35 fields. 2 CDS views read from this table.
CDS Views using this table (2)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_IPUTSCheckScopeProposal | view_entity | from | BASIC | Check Test Scope Proposal |
| I_IPUTSResult | view_entity | from | BASIC | IPUTS Test Scope Proposal |
Fields (35)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | mandt | Client | |||
| KEY | scope_id | iputs_dte_scope_summary_id | Scope Summary ID | |||
| tpgroup_id | iputs_dte_testplan_group_uuid | Test Plan Group | ||||
| tpgroup_name | iputs_dte_testplan_group_name | Test Plan Group | ||||
| scope_duration | iputs_dte_cloud_release | Cloud Release | ||||
| from_date | iputs_dte_from_to_date | From/To Date | ||||
| to_date | iputs_dte_from_to_date | From/To Date | ||||
| target_release | iputs_dte_planned_delivery | |||||
| appl_comp_group_id | iputs_dte_appl_comp_group_uuid | ACG UUID | ||||
| appl_comp_id | iputs_dte_appl_comp_id | Applic. Component | ||||
| appl_comp | iputs_dte_appl_comp | Applic. Component | ||||
| testplan_id | iputs_dte_testplan_id | Test Plan ID | ||||
| process_id | iputs_dte_process_id | Process ID | ||||
| tpname_id | iputs_dte_testplan_uuid | Test Plan | ||||
| total_testplans | iputs_dte_total_testplan | Total Test Plans | ||||
| proposed_testplans | iputs_dte_proposed_testplan | Proposed Test Plans | ||||
| only_touched | iputs_dte_only_touched | Only Touched | ||||
| only_changed | iputs_dte_only_changed | Only Changed Objects | ||||
| only_bsp_objects | iputs_dte_only_bsp | Only BSP Objects | ||||
| touched_changed | iputs_dte_touched_changed | Touched & Changed | ||||
| touched_changed_bsp | iputs_dte_touched_chaged_bsp | Touched Changed BSP | ||||
| max_scope | iputs_dte_max_scope | Max Scope | ||||
| max_scope_touched | iputs_dte_max_scope_touched | Max Scope Touched | ||||
| max_scope_changed | iputs_dte_max_scope_changed | Max Scope Changed | ||||
| max_scope_touched_changed | iputs_dte_max_scope_tc | Max Scope TC Objects | ||||
| max_scope_touched_changed_bsp | iputs_dte_max_scope_tcb | MaxScope TCB Objects | ||||
| max_scope_bsp | iputs_dte_max_scope_bsp | Max Scope BSP Object | ||||
| system_id | iputs_dte_system_id | System ID | ||||
| created_by | iputs_dte_created_by | Created By | ||||
| created_at | iputs_dte_created_at | Created At | ||||
| in_process | iputs_dte_in_process_flag | |||||
| area_id | iputs_dte_area_uuid | Area ID | ||||
| optimal_scope_percentage | iputs_optimal_scope_percentage | |||||
| minimum_scope | iputs_minimum_scope | |||||
| optimal_scope | iputs_optimal_scope |
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.
-- Scope Proposal Statistics
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE IPUTS_A_SCOPE_SM (
MANDT, -- Client [mandt]
SCOPE_ID, -- Scope Summary ID [iputs_dte_scope_summary_id]
TPGROUP_ID, -- Test Plan Group [iputs_dte_testplan_group_uuid]
TPGROUP_NAME, -- Test Plan Group [iputs_dte_testplan_group_name]
SCOPE_DURATION, -- Cloud Release [iputs_dte_cloud_release]
FROM_DATE, -- From/To Date [iputs_dte_from_to_date]
TO_DATE, -- From/To Date [iputs_dte_from_to_date]
TARGET_RELEASE, -- iputs_dte_planned_delivery
APPL_COMP_GROUP_ID, -- ACG UUID [iputs_dte_appl_comp_group_uuid]
APPL_COMP_ID, -- Applic. Component [iputs_dte_appl_comp_id]
APPL_COMP, -- Applic. Component [iputs_dte_appl_comp]
TESTPLAN_ID, -- Test Plan ID [iputs_dte_testplan_id]
PROCESS_ID, -- Process ID [iputs_dte_process_id]
TPNAME_ID, -- Test Plan [iputs_dte_testplan_uuid]
TOTAL_TESTPLANS, -- Total Test Plans [iputs_dte_total_testplan]
PROPOSED_TESTPLANS, -- Proposed Test Plans [iputs_dte_proposed_testplan]
ONLY_TOUCHED, -- Only Touched [iputs_dte_only_touched]
ONLY_CHANGED, -- Only Changed Objects [iputs_dte_only_changed]
ONLY_BSP_OBJECTS, -- Only BSP Objects [iputs_dte_only_bsp]
TOUCHED_CHANGED, -- Touched & Changed [iputs_dte_touched_changed]
TOUCHED_CHANGED_BSP, -- Touched Changed BSP [iputs_dte_touched_chaged_bsp]
MAX_SCOPE, -- Max Scope [iputs_dte_max_scope]
MAX_SCOPE_TOUCHED, -- Max Scope Touched [iputs_dte_max_scope_touched]
MAX_SCOPE_CHANGED, -- Max Scope Changed [iputs_dte_max_scope_changed]
MAX_SCOPE_TOUCHED_CHANGED, -- Max Scope TC Objects [iputs_dte_max_scope_tc]
MAX_SCOPE_TOUCHED_CHANGED_BSP, -- MaxScope TCB Objects [iputs_dte_max_scope_tcb]
MAX_SCOPE_BSP, -- Max Scope BSP Object [iputs_dte_max_scope_bsp]
SYSTEM_ID, -- System ID [iputs_dte_system_id]
CREATED_BY, -- Created By [iputs_dte_created_by]
CREATED_AT, -- Created At [iputs_dte_created_at]
IN_PROCESS, -- iputs_dte_in_process_flag
AREA_ID, -- Area ID [iputs_dte_area_uuid]
OPTIMAL_SCOPE_PERCENTAGE, -- iputs_optimal_scope_percentage
MINIMUM_SCOPE, -- iputs_minimum_scope
OPTIMAL_SCOPE, -- iputs_optimal_scope
PRIMARY KEY (MANDT, SCOPE_ID)
);
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