SAP table CPVTYPE (Customizing Table for the iPPE Variant Types)
SAP table CPVTYPE has 2 primary key fields being MANDT,PVTYPE.
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
MANDT
Client
CLNT
3
0
*
MANDT
PVTYPE
iPPE Variant Type
CHAR
8
0
PVS_POSV_TYPE
APPLOBJ_TYPE
iPPE Application Object Type
CHAR
4
0
CLICOMP_DEF
PPE_APPLOBJ_TYPE
PVSLAYER
iPPE Level
CHAR
1
0
PVS_LAYER
Possible values
E
Access Level
S
Structure Level
V
View Level
NODE_MIN
Minimum Number of Variant Assignments to a Node
CHAR
1
0
PVS_NODE_MIN
NODE_MAX
Maxmimum Number of Variant Assignments to Node
CHAR
1
0
PVS_NODE_MAX
CONF_FLG
PVS Indicator
CHAR
1
0
PVS_CONFFLG
CONTEXTENV
Context
CHAR
4
0
PPE_CONTEXT_ENV
Possible values
BAL
Line Balance
FOC
Focus
HISTREQ_FLG
Indicator for History Requirement
CHAR
1
0
PVS_HISTREQFLG
CLASS
Class
CHAR
18
0
PPE_KLASSE
KLART
Class Type
CHAR
3
0
*
PPE_KLASSENART_CUST
CLINT
Internal Class Number
NUMC
10
0
*
PPE_CLINT
REF_PVTYPE
Reference Variant Type
CHAR
8
0
CPVTYPE
PVS_REF_POSV_TYPE
HIDE_FLG
Indicator: Hide Object
CHAR
1
0
PVS_HIDEFLG
ICON
Icon for iPPE Objects
CHAR
4
0
ICON
PPE_ICON
CREADAT
Date of Application
DATS
8
0
PVS_ANDAT
CREABY
User who created record
CHAR
12
0
PVS_ANNAM
CHNGDAT
Date of Last Change
DATS
8
0
PVS_AEDAT
CHNGBY
Name of Person Who Changed Object
CHAR
12
0
PVS_AENAM
LOGSYS
Logical system
CHAR
10
0
*
LOGSYS
CPVTYPE foreign key relationships
Table
Field
Check Table
Check Field
0 CPVTYPE
APPLOBJ_TYPE
CLICOMP_DEF
Definition of Application Components for iPPE Engine
APPLOBJ_TYPE
1 CPVTYPE
ICON
ICON
Icons table
ID
0 CPVTYPE
REF_PVTYPE
CPVTYPE
Customizing Table for the iPPE Variant Types
MANDT