DRR_COMPRN
Table for Comparison Data for Draft Report Reconciliation
DRR_COMPRN is an SAP database table in S/4HANA. Table for Comparison Data for Draft Report Reconciliation. It contains 14 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_DrftRptComparisonHeaderBasic | view_entity | from | BASIC | Comparison Data for Reconcile Report |
Fields (14)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | MANDT | Client | |||
| KEY | activity_key | /BOBF/CONF_KEY | NodeID | |||
| KEY | document_id | SRF_DOCUMENT_ID | Document ID | |||
| run_uuid | DRR_RUN_UUID | Run UUID | ||||
| submission_uuid | DRR_SUBMISSION_RUN_UUID | Submission UUID | ||||
| file_id | DRR_COMM_FILE_ID | Comm File ID | ||||
| comparison_status | DRR_COMPARISON_STATUS | Comparison Status | ||||
| timestamp | DRR_COMPARISON_TIMESTAMP | Comprn Time Stamp | ||||
| loghandle | DRR_LOG_HANDLE | LogsHandle | ||||
| file_name | FILEP | Original | ||||
| created_on | SRF_SUBMITTED_ON | Submitted On | ||||
| report_run_status | SRF_REPORT_RUN_STATUS | Report Run Status | ||||
| requested_by | DRR_REQUESTED_BY | Requested By | ||||
| generated_by | DRR_GENERATED_BY | Generated By |
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.
-- Table for Comparison Data for Draft Report Reconciliation
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE DRR_COMPRN (
MANDT, -- Client [MANDT]
ACTIVITY_KEY, -- NodeID [/BOBF/CONF_KEY]
DOCUMENT_ID, -- Document ID [SRF_DOCUMENT_ID]
RUN_UUID, -- Run UUID [DRR_RUN_UUID]
SUBMISSION_UUID, -- Submission UUID [DRR_SUBMISSION_RUN_UUID]
FILE_ID, -- Comm File ID [DRR_COMM_FILE_ID]
COMPARISON_STATUS, -- Comparison Status [DRR_COMPARISON_STATUS]
TIMESTAMP, -- Comprn Time Stamp [DRR_COMPARISON_TIMESTAMP]
LOGHANDLE, -- LogsHandle [DRR_LOG_HANDLE]
FILE_NAME, -- Original [FILEP]
CREATED_ON, -- Submitted On [SRF_SUBMITTED_ON]
REPORT_RUN_STATUS, -- Report Run Status [SRF_REPORT_RUN_STATUS]
REQUESTED_BY, -- Requested By [DRR_REQUESTED_BY]
GENERATED_BY, -- Generated By [DRR_GENERATED_BY]
PRIMARY KEY (MANDT, ACTIVITY_KEY, DOCUMENT_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