SAP WP3ROLEDEFT Portal Roles: Short and Long Texts Table

Overview

WP3ROLEDEFT is a standard SAP S/4HANA table that stores Portal Roles: Short and Long Texts data. There are total 5 fields in the WP3ROLEDEFT table. The following is a list of the fields that make up this table. Key fields are marked in blue.

The table WP3ROLEDEFT belongs to User Administration (BC-SEC-USR) module and is located in the package Workplace 3.0 Role Management (WP3ROLES).

In addition, following links provide an overview of foreign key relationships, if any, that link WP3ROLEDEFT to other SAP tables and standard CDS views available based on WP3ROLEDEFT table in S/4HANA 2020.

Techincal Settings of WP3ROLEDEFT

Below are technical details of the table WP3ROLEDEFT

  • Buffering switched on
  • Full buffering as specified by generic key
  • Storage type is Column Store

List of WP3ROLEDEFT Fields

The following table gives you an overview of the fields available in WP3ROLEDEFT

FieldDescriptionData ElementCheck TableData TypeLength
MANDTClientMANDTT000CLNT3
LANGULanguage KeyLANGUT002LANG1
ROLENAMEHHash Value of Portal RoleWP3ROLENAMEHWP3ROLEDEFCHAR32
COUNTERCounter fieldWP3COUNTERNUMC6
RTEXTPortal Role TextWP3RTEXTCHAR132

Foreign Key Relationships

A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for WP3ROLEDEFT

Table NameFieldCardinalityCheck Table
WP3ROLEDEFTLANGU1: CNT002
WP3ROLEDEFTMANDT1: CNT000
WP3ROLEDEFTROLENAMEH1: CNWP3ROLEDEF

Other References