/SSB/RPT_CONF
Configuration table for Reports of Smart Business
/SSB/RPT_CONF is an SAP database table in S/4HANA. Configuration table for Reports of Smart Business. It contains 26 fields. 11 CDS views read from this table.
CDS Views using this table (11)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| /SSB/ALL_VIEWS_USED_IN_SSB | view | union_all | Views used already in SSB | |
| /SSB/CDS_VIEWS_WHERE_USED | view | union_all | list of objects where a cds view is used | |
| /SSB/COUNT_ALL_REPORTS | view | union_all | All Generic reports | |
| /SSB/COUNT_ALP_REPORT | view | union_all | Count for ALP Reports | |
| /SSB/Cust_Edited_Reports | view | from | List of all SAP Delivered Reports edited by customer | |
| /SSB/REPORT | view | union_all | All reports which are customer edited | |
| /SSB/REPORT_EXTENSION | view | left_outer | All reports which are customer edited | |
| /SSB/REPORT_EXTENSION | view | union_all | All reports which are customer edited | |
| /SSB/RUNTIME_REPORT_CONFIGS | view | left_outer | Reports data for App descriptor | |
| /SSB/RUNTIME_REPORT_CONFIGS | view | union_all | Reports data for App descriptor | |
| /SSB/UNION_REPORT_CONFIGS | view | union_all | Report Config after union of tables |
Fields (26)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | sap_client | /SSB/SAP_CLIENT | SAP Client | |||
| KEY | namespace | /SSB/NAMESPACE_DISCRIMINATOR | Namespace | |||
| KEY | id | /SSB/ID | Identifier | |||
| KEY | is_active | /SSB/IS_ACTIVE | Is Active | |||
| type | /SSB/REPORT_TYPE | Report T. | ||||
| evaluation_id | /SSB/ID | Identifier | ||||
| scaling | /SSB/SCALING | Scaling | ||||
| odata_url | /SSB/ODATA_URL | ODATA URL | ||||
| odata_entityset | /SSB/ODATA_ENTITYSET | Entityset | ||||
| cds_view_name | /SSB/CDS_VIEW_NAME | CDS View | ||||
| column_name | /SSB/COLUMN_NAME | Column | ||||
| decimal_precision | /SSB/DECIMAL_PRECISION | Decimal Precision | ||||
| owner_name | /SSB/OWNER_NAME | Name | ||||
| owner_e_mail | /SSB/OWNER_E_MAIL | E-Mail Addr. | ||||
| owner_id | /SSB/OWNER_ID | User ID | ||||
| created_by | /SSB/CREATED_BY_ID | Created By | ||||
| created_on | /SSB/CREATED_ON | Created On | ||||
| changed_by | /SSB/CHANGED_BY_ID | Changed By | ||||
| changed_on | /SSB/CHANGED_ON | Changed On | ||||
| application_component | /SSB/APPLCOMP | Appl. Component | ||||
| annotation_model | /SSB/ANNOTATION_MODEL | Annotation Model | ||||
| ref_id | /SSB/ID | Identifier | ||||
| is_extn_reverted | /SSB/IS_EXTN_REVERTED | Extension Reverted | ||||
| cds_annotation_name | /SSB/ANNOTATION_MODEL | Annotation Model | ||||
| cds_annotation_version | /SSB/ANNOTATION_VERSION | Annotation Version | ||||
| facet_threshold | /SSB/FACET_LIMIT | Facet threshold |
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.
-- Configuration table for Reports of Smart Business
-- Category TRANSPARENT · Delivery class E
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE /SSB/RPT_CONF (
SAP_CLIENT, -- SAP Client [/SSB/SAP_CLIENT]
NAMESPACE, -- Namespace [/SSB/NAMESPACE_DISCRIMINATOR]
ID, -- Identifier [/SSB/ID]
IS_ACTIVE, -- Is Active [/SSB/IS_ACTIVE]
TYPE, -- Report T. [/SSB/REPORT_TYPE]
EVALUATION_ID, -- Identifier [/SSB/ID]
SCALING, -- Scaling [/SSB/SCALING]
ODATA_URL, -- ODATA URL [/SSB/ODATA_URL]
ODATA_ENTITYSET, -- Entityset [/SSB/ODATA_ENTITYSET]
CDS_VIEW_NAME, -- CDS View [/SSB/CDS_VIEW_NAME]
COLUMN_NAME, -- Column [/SSB/COLUMN_NAME]
DECIMAL_PRECISION, -- Decimal Precision [/SSB/DECIMAL_PRECISION]
OWNER_NAME, -- Name [/SSB/OWNER_NAME]
OWNER_E_MAIL, -- E-Mail Addr. [/SSB/OWNER_E_MAIL]
OWNER_ID, -- User ID [/SSB/OWNER_ID]
CREATED_BY, -- Created By [/SSB/CREATED_BY_ID]
CREATED_ON, -- Created On [/SSB/CREATED_ON]
CHANGED_BY, -- Changed By [/SSB/CHANGED_BY_ID]
CHANGED_ON, -- Changed On [/SSB/CHANGED_ON]
APPLICATION_COMPONENT, -- Appl. Component [/SSB/APPLCOMP]
ANNOTATION_MODEL, -- Annotation Model [/SSB/ANNOTATION_MODEL]
REF_ID, -- Identifier [/SSB/ID]
IS_EXTN_REVERTED, -- Extension Reverted [/SSB/IS_EXTN_REVERTED]
CDS_ANNOTATION_NAME, -- Annotation Model [/SSB/ANNOTATION_MODEL]
CDS_ANNOTATION_VERSION, -- Annotation Version [/SSB/ANNOTATION_VERSION]
FACET_THRESHOLD, -- Facet threshold [/SSB/FACET_LIMIT]
PRIMARY KEY (SAP_CLIENT, NAMESPACE, ID, IS_ACTIVE)
);
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