SAP table CNVTABLES (Conversion: Tables for processing by package)
SAP table CNVTABLES has 3 primary key fields being MANDT,PACKID,TABNAME.
If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.
Field
Description
Data Type
Length
Decimals
Checktable
Data Element
Client
CLNT
3
0
T000
MANDT
Conversion: Conversion package number
CHAR
5
0
CNVPACK
CNV_PACK
Table Name
CHAR
30
0
DD02L
TABNAME
SUMUP
Method of duplicate table keys handling
CHAR
1
0
CNV_SUM
Possible values
No special duplicate entries processing
A
Ignore Duplicate Entries
G
Aggregate Function
I
No duplicate processing necessary
P
Custom Priority Routine
S
Sum all CURR and QUAN fields
COPYROWS
Conversion: Copy indicator for table records
CHAR
1
0
CNV_COPY
KEYCHVIEWS
Conversion: No temporary duplicates during conversion
CHAR
1
0
CNV_KCV
NOVIEW
Conversion: Indicator for non-use of views
CHAR
1
0
CNV_NOV
SEQNUM
Conversion: Sequence Number
NUMC
2
0
CNV_ORD
MASTERTAB
Conversion: Indicator for header table
CHAR
1
0
CNV_MTAB
NOTUSE
Exclusion from conversion indication
CHAR
1
0
CNV_NOT
USECLTECH
Conversion: Indicator that cluster technique is used
CHAR
1
0
CNV_UCLT
USEDROPINS
Conversion: Indicator for usage of drop-insert method
CHAR
1
0
CNV_DROPINS
GETDUPREC
Indic. for returning the target record if duplicates occur
CHAR
1
0
CNV_GETDUP
MULTICOPY
Indicates if multiple copies of the data should be created
CHAR
1
0
CNV_MULTICOPY
NODATA
Conversion: No data in the table
CHAR
1
0
CNV_NODATA
STANDARD
Indicator for SAP standard tables
CHAR
1
0
CNV_STANDARD
CREATED
Creator of control data
CHAR
40
0
CNV_00001_CTRL_DATA_CREATOR
CRDATE
Creation date
DATS
8
0
CNV_00001_CREATE_DATE
CRTIME
Creation Time
TIMS
6
0
CNV_00001_CREATE_TIME
CRUSER
Creating user
CHAR
12
0
CNV_00001_CREATE_USER
CHANGED
Modifier of control data
CHAR
40
0
CNV_00001_CTRL_DATA_MODIFIER
CHDATE
Change Date
DATS
8
0
CNV_00001_CHANGE_DATE
CHTIME
Change Time
TIMS
6
0
CNV_00001_CHANGE_TIME
CHUSER
Changed By
CHAR
12
0
CNV_00001_CHANGE_USER
SOURCE
Control data source
CHAR
1
0
CNV_00001_CTRL_DATA_SOURCE
Possible values
Delivered in package
C
Inserted manually
P
Inserted by program
S
Found during standard search functionality
CNVTABLES foreign key relationships
Table
Field
Check Table
Check Field
0 CNVTABLES
MANDT
T000 Clients
MANDT
1 CNVTABLES
PACKID
CNVPACK Conversion: Conversion packages
PACKID
0 CNVTABLES
TABNAME
DD02L SAP Tables
TABNAME
0 CNVTABLES
TABNAME
DD02L SAP Tables
AS4LOCAL
0 CNVTABLES
TABNAME
DD02L SAP Tables
AS4VERS