SAP Table CNS_CP

CNS: Change Pointer

CNS_CP (CNS: Change Pointer) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link CNS_CP to other SAP tables.

CNS_CP table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT CLNT 3 0
CP_ID Change Pointer ID CNS_DTE_CP_ID RAW 16 0
APPL_ID Application ID CNS_DTE_APPL_ID TCNS_APPL CHAR 4 0
EXPOBJTYPE Export Object Type CNS_DTE_EXPOBJTYPE TCNS_EXPOBJ CHAR 5 0
EXPOBJKEY Export Object Key CNS_DTE_EXPOBJKEY CHAR 70 0
VALID_FROM DB Time Stamp: Change Pointer Valid From CNS_DTE_DB_TIMST_VALID_FROM NUMC 15 0
CREATED_ON DB Time Stamp: Creation Time of Change Pointer CNS_DTE_DB_TIMST_CREATED_ON NUMC 15 0
USERID User Name SYUNAME CHAR 12 0
SOURCE ABAP Program Name PROGNAME CHAR 40 0
CHGTYPE Change Pointer: Change Category CNS_DTE_CHGTYPE CHAR 1 0
I Insert
U Update
D Delete
GROUP_ID Grouping ID CNS_DTE_GROUP_ID CHAR 2 0
STATUS Change Pointer Status CNS_DTE_CP_STATUS CHAR 1 0
C Created
P Edited
E Incorrect
STATU_CHANGED_AT DB Time Stamp: Time Stamp of Last Status Change CNS_DTE_DB_TIMST_CHANGED_AT NUMC 15 0
HAS_IMAGE Does the Change Pointer Have an Image? CNS_DTE_HAS_IMAGE CHAR 1 0
X Yes
NULL No
HAS_INFO Does the Change Pointer Have Additional Information? CNS_DTE_HAS_INFO CHAR 1 0
X Yes
NULL No
BUNDLE_ID Package ID CNS_DTE_CP_BUNDLE_ID CHAR 40 0
PROCESS_ID Business Process ID CNS_DTE_PROCESS_ID CHAR 32 0
ADD_SEL Application-Specific Selection Criteria CNS_DTE_ADD_SEL CHAR 4 0

CNS_CP foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
CNS_CP APPL_ID CNS_CP APPL_ID TCNS_APPL CNS: Applications APPL_ID
CNS_CP EXPOBJTYPE CNS_CP EXPOBJTYPE TCNS_EXPOBJ CNS: Export Object Types EXPOBJTYPE
CNS_CP EXPOBJTYPE CNS_CP APPL_ID TCNS_EXPOBJ CNS: Export Object Types APPL_ID