SAP CPRTYPE Customizing: iPPE Relationships Table data and field list

CPRTYPE is a standard SAP Table which is used to store Customizing: iPPE Relationships data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The CPRTYPE table consists of various fields, each holding specific information or linking keys about Customizing: iPPE Relationships data available in SAP. These include PRTYPE (iPPE Relationship Type), CPRCNT (Internal Counter for iPPE Objects), PTYPE1 (iPPE Object Type 1 (Node, Alternative, Variant)), PTYPE2 (iPPE Object Type 2 (Node, Alternative, Variant))... See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

CPRTYPE table Technical Details:

Delivery Class: E - Control table, SAP and customer have separate key areas
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced

Text table = CPRTYPET


SAP CPRTYPE table fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the CPRTYPE table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.
Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3T000MANDT
PRTYPEiPPE Relationship Type PVS_PNREL_TYPECHAR8PVS_PNREL_TYPE
CPRCNTInternal Counter for iPPE Objects PVS_COUNTNUMC8NUMC8
PTYPE1iPPE Object Type 1 (Node, Alternative, Variant) PVS_OBJ_TYPE1CHAR8PVS_OBJ_TYPETS_PNTYPE
PTYPE2iPPE Object Type 2 (Node, Alternative, Variant) PVS_OBJ_TYPE2CHAR8PVS_OBJ_TYPETS_PNTYPE
OTYPE1iPPE Object Type 1 PVS_OTYPE1CHAR1PVS_OTYPE
OTYPE2iPPE Object Type 2 PVS_OTYPE2CHAR1PVS_OTYPE
PRCARD1_MINMinimum Cardinality for iPPE Relationship Object 1 PVS_PRCARD_MIN1CHAR1PVS_CARD_MIN
PRCARD1_MAXMaximum Cardinality for iPPE Relationship Object 1 PVS_PRCARD_MAX1CHAR1PVS_CARD_MAX
PRCARD2_MINMinimum Cardinality for iPPE Relationship Object 2 PVS_PRCARD_MIN2CHAR1PVS_CARD_MIN
PRCARD2_MAXMaximum Cardinality for iPPE Relationship Object 2 PVS_PRCARD_MAX2CHAR1PVS_CARD_MAX
CLCHKActivates the Class Hierarchy Check PVS_CLCHKCHAR1XFELD
APPLREL_TYPEiPPE Application Object Type PPE_APPLOBJ_TYPECHAR4CHAR4
PREL_TYPEiPPE Relationship Type PVS_REL_TYPECHAR1PVS_REL_TYPE
APPL_DATAIndicator for Application Data at the Relationship Type PPE_APPL_DATACHAR1XFELD
CALLBACK_FLGCallback in iPPE Application Objects PPE_CALLBACK_FLGCHAR1XFELD
OWNERAssignment to Function Groups PPE_OWNERCHAR1PPE_OWNER
HIDE_FLGIndicator: Hide Object PVS_HIDEFLGCHAR1XFELD
DB_OWNERRelationships: Responsible Database PPE_DB_OWNERCHAR1PPE_DB_OWNER
CONTEXTENVContext PPE_CONTEXT_ENVCHAR4PPE_CONTEXT_ENV
HIST_MODEHistory Maintenance for Relationships PPE_PRELID_HISTFLGCHAR1PPE_PRELID_HISTFLG
SORT_FLGSort Field in ID for iPPE Relation. Type can be Maintained PPE_SORT_FLGCHAR1XFELD
CREADATDate of Application PVS_ANDATDATS8DATUM
CREABYUser who created record PVS_ANNAMCHAR12USNAM
CHNGDATDate of Last Change PVS_AEDATDATS8DATUM
CHNGBYName of Person Who Changed Object PVS_AENAMCHAR12USNAM
LOGSYSLogical system LOGSYSCHAR10Assigned to domainALPHALOGSYS

Key field Non-key field



How do I retrieve data from SAP table CPRTYPE using ABAP code

The following ABAP code Example will allow you to do a basic selection on CPRTYPE to SELECT all data from the table
DATA: WA_CPRTYPE TYPE CPRTYPE.

SELECT SINGLE *
FROM CPRTYPE
INTO CORRESPONDING FIELDS OF WA_CPRTYPE
WHERE...

How to access SAP table CPRTYPE

Within an ECC or HANA version of SAP you can also view further information about CPRTYPE and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).