WECD_PERS_USER SAP table for – User Personalization

Here we would like to draw your attention to WECD_PERS_USER table in SAP. As we know it is being mainly used with the SAP WEC (Web Channel in WEC) component which is coming under WEC module (Web Channel). WECD_PERS_USER is a SAP standard transp table used for storing User Personalization related data in SAP. It comes under the package ERP_WEC_PERS.

SAP WECD_PERS_USER table

Table WECD_PERS_USER technical data

TableWECD_PERS_USER
Data storingUser Personalization
ModuleWEC
Sub ModuleWEC-APP-PER
SAP PackageERP_WEC_PERS
Delivery ClassA – Application table (master and transaction data)
ComponentSAP_APPL
Table CategoryTRANSP

SAP WECD_PERS_USER Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in WECD_PERS_USER table.

  • CLIENT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • PERS_GUID : Personalization Guid
    Its a key field. Its data type is CHAR (Character String) with field length 32
  • APP_ID : Holds Shop ID
    Its data type is CHAR (Character String) with field length 40
  • MODULE_ID : ERP Web Channel Module ID
    Its data type is CHAR (Character String) with field length 255
  • USER_ID : User Name in User Master Record
    Its data type is CHAR (Character String) with field length 12
  • PERS_TYPE : ERP Personalization Type
    Its data type is CHAR (Character String) with field length 10
  • PERS_NAME : Personalization Name
    Its data type is CHAR (Character String) with field length 255
  • PREF_KEY : Personalization Preference Key
    Its data type is STRG (Character String of Variable Length) with field length 0
  • CREATED_AT : Created At (Output in User Time Zone)
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • CREATED_BY : User that Created the Transaction
    Its data type is CHAR (Character String) with field length 12
  • CHANGED_AT : Changed At (Output in User Time Zone)
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • CHANGED_BY : Transaction Last Changed By
    Its data type is CHAR (Character String) with field length 12