SAP table BDCP2 (Aggregated Change Pointers (BDCP, BDCPS))
SAP table BDCP2 has 3 primary key fields being MANDT,MESTYPE,CPIDENT.
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
MESTYPE
Message Type
CHAR
30
0
*
EDI_MESTYP
CPIDENT
Change pointer ID
NUMC
10
0
*
CPIDENT
PROCESS
ALE processing indicator
CHAR
1
0
ALE_PROCES
Not processed
X
Processed
TABNAME
Table Name
CHAR
30
0
*
TABNAME
TABKEY
Key of Modified Table Row
CHAR
254
0
CDTABKEYLO
FLDNAME
Field Name
CHAR
30
0
*
FIELDNAME
CRETIME
Creation time of a change pointer
CHAR
14
0
CPCRETIME
ACTTIME
Activation time of a change pointer
CHAR
14
0
CPACTTIME
USRNAME
User name of the person responsible in change document