CNVSTATE
Conversion: Status of programs
CNVSTATE is an SAP database table in S/4HANA. Conversion: Status of programs. It contains 34 fields. 4 CDS views read from this table.
CDS Views using this table (4)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| CNV_2010C_COUNT_FINISH | view | from | Count of finsished steps for a package | |
| CNV_2010C_COUNT_TOTAL_PROG | view | from | Total number of steps for a package | |
| CNV_2010C_JOB_STATUS | view | from | Get job status of background activity | |
| CNV_2010C_PACK_LOG_STATUS | view | left_outer | Package activity status with phase text |
Fields (34)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | MANDT | Client | |||
| KEY | packid | CNV_PACK | Pack.no. | |||
| KEY | phase | CNV_PHASE | Phase | |||
| KEY | tabname | TABNAME | Table Name | |||
| KEY | progname | PROGRAMM | Program Name | |||
| KEY | taskid | CNV_RCNT | Task ID | |||
| rerun | CNV_RERUN | repeatable | ||||
| precursor | CNV_PREC | Predecessor | ||||
| pretabname | CNV_PRECTAB | Table predecessor | ||||
| jobname | BTCJOB | Job Name | ||||
| jobcount | BTCJOBCNT | Job No. | ||||
| server | BTCSRVNAME | Server | ||||
| runmode | CNV_RMODE | Run type | ||||
| state_tec | CNV_RUNS | Program phase | ||||
| state_log | CNV_STATE | Status | ||||
| starttime | CNV_TSTART | Start time | ||||
| endtime | CNV_TEND | Finish Time | ||||
| duration | BTCRUNTIME | Runtime | ||||
| recselect | CNV_RECORDS | Table records | ||||
| rectotal | CNV_RTOT | Table records | ||||
| recread | CNV_RECREAD | Number records read | ||||
| recupd | CNV_RUPD | Changed | ||||
| recdumwrite | CNV_RECDUMWRITE | Table recs. DUM | ||||
| recdumread | CNV_RECDUMREAD | Table recs. DUM | ||||
| reccount1 | RECCOUNT | Counted records | ||||
| reccount2 | RECCOUNT | Counted records | ||||
| rerunarg | CNV_REARG | Restart arg. | ||||
| tabid | abap.int4 | |||||
| cluid_min | abap.int4 | |||||
| cluid_max | abap.int4 | |||||
| progtype | CNV_PROGTYPE | Program ty. | ||||
| updtype | CNV_UPDTYPE | Update scenario | ||||
| multiprog | CNV_MULTIPROG | More than one program generated for a given table | ||||
| gentype | CNV_GENTYPE | Used generator |
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.
-- Conversion: Status of programs
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CNVSTATE (
MANDT, -- Client [MANDT]
PACKID, -- Pack.no. [CNV_PACK]
PHASE, -- Phase [CNV_PHASE]
TABNAME, -- Table Name [TABNAME]
PROGNAME, -- Program Name [PROGRAMM]
TASKID, -- Task ID [CNV_RCNT]
RERUN, -- repeatable [CNV_RERUN]
PRECURSOR, -- Predecessor [CNV_PREC]
PRETABNAME, -- Table predecessor [CNV_PRECTAB]
JOBNAME, -- Job Name [BTCJOB]
JOBCOUNT, -- Job No. [BTCJOBCNT]
SERVER, -- Server [BTCSRVNAME]
RUNMODE, -- Run type [CNV_RMODE]
STATE_TEC, -- Program phase [CNV_RUNS]
STATE_LOG, -- Status [CNV_STATE]
STARTTIME, -- Start time [CNV_TSTART]
ENDTIME, -- Finish Time [CNV_TEND]
DURATION, -- Runtime [BTCRUNTIME]
RECSELECT, -- Table records [CNV_RECORDS]
RECTOTAL, -- Table records [CNV_RTOT]
RECREAD, -- Number records read [CNV_RECREAD]
RECUPD, -- Changed [CNV_RUPD]
RECDUMWRITE, -- Table recs. DUM [CNV_RECDUMWRITE]
RECDUMREAD, -- Table recs. DUM [CNV_RECDUMREAD]
RECCOUNT1, -- Counted records [RECCOUNT]
RECCOUNT2, -- Counted records [RECCOUNT]
RERUNARG, -- Restart arg. [CNV_REARG]
TABID, -- abap.int4
CLUID_MIN, -- abap.int4
CLUID_MAX, -- abap.int4
PROGTYPE, -- Program ty. [CNV_PROGTYPE]
UPDTYPE, -- Update scenario [CNV_UPDTYPE]
MULTIPROG, -- More than one program generated for a given table [CNV_MULTIPROG]
GENTYPE, -- Used generator [CNV_GENTYPE]
PRIMARY KEY (MANDT, PACKID, PHASE, TABNAME, PROGNAME, TASKID)
);
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