SAP COMM_PRWBIL_USER User Settings for Interlinkages in the Product Workbench Table data and field list

COMM_PRWBIL_USER is a standard SAP Table which is used to store User Settings for Interlinkages in the Product Workbench data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The COMM_PRWBIL_USER table consists of various fields, each holding specific information or linking keys about User Settings for Interlinkages in the Product Workbench data available in SAP. These include USER_GUID (GUID: User Settings), UNAME (User Name), RELTYPE (Relationship Type), DIRECTION (Defines the Direction of a Directed Relationship)... 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. .

COMM_PRWBIL_USER table Technical Details:

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced


SAP COMM_PRWBIL_USER 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 COMM_PRWBIL_USER 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
CLIENTClient MANDTCLNT3Assigned to domainMANDT
USER_GUIDGUID: User Settings COMT_PRWB_USER_GUIDRAW16SYSUUID
UNAMEUser Name UNAMECHAR12UNAME
RELTYPERelationship Type COMT_IL_RELTYPECHAR6
DIRECTIONDefines the Direction of a Directed Relationship COMT_IL_DIRECTIONCHAR1COM_ILDIRECTION
IL_ORDERSequence of Relationships in Product Maintenance COMT_PRWB_IL_ORDERNUMC2NUMC2
IL_INACTIVEHide Relationship Type in Product Maintenance COMT_PRWB_IL_INACTIVECHAR1XFELD

Key field Non-key field



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

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

SELECT SINGLE *
FROM COMM_PRWBIL_USER
INTO CORRESPONDING FIELDS OF WA_COMM_PRWBIL_USER
WHERE...

How to access SAP table COMM_PRWBIL_USER

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

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