PSERB SAP (Inheritance data, Project System) Table details
Dictionary Type: Table
Description: Inheritance data, Project System
Description: Inheritance data, Project System
Table field list including key, data, relationships and ABAP select examples
PSERB is a standard SAP Table which is used to store Inheritance data, Project System data and is available within R/3 SAP systems depending on the version and release level.
The PSERB table consists of various fields, each holding specific information or linking keys about Inheritance data, Project System data available in SAP. These include OBJNR (Object number), TOP_OBJNR (Object number), POSID (Work Breakdown Structure Element (WBS Element)), PSPID (Project Definition).. 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. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP PSERB table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
OBJNR | Object number | J_OBJNR | CHAR | 22 | ONR00 | J_OBJNR | ONR | ||
TOP_OBJNR | Object number | J_OBJNR | CHAR | 22 | Assigned to domain | J_OBJNR | ONR | ||
POSID | Work Breakdown Structure Element (WBS Element) | PS_POSID | CHAR | 24 | PROJN | PS_POSID | PRO | ||
PSPID | Project Definition | PS_PSPID | CHAR | 24 | ABPSN | PS_PSPID | PSP | PD_DUMMY | |
POSKI | WBS element short identification | PS_POSKI | CHAR | 16 | PS_PROKI | ||||
VERNR | Number of the responsible person (project manager) | PS_VERNR | NUMC | 8 | TCJ04 | PS_VERNR | |||
VERNA | Name of responsible person (Project manager) | PS_VERNA | CHAR | 25 | PS_VERNA | ||||
ASTNR | Applicant number | PS_ASTNR | NUMC | 8 | TCJ05 | PS_ASTNR | |||
ASTNA | Applicant | PS_ASTNA | CHAR | 25 | PS_ASTNA | ||||
PBUKR | Company Code | BUKRS | CHAR | 4 | T001 | BUKRS | BUK | C_T001 | |
PGSBR | Business Area | GSBER | CHAR | 4 | TGSB | GSBER | GSB | ||
PKOKR | Controlling Area | KOKRS | CHAR | 4 | TKA01 | CACCD | CAC | ||
PRCTR | Profit Center | PRCTR | CHAR | 10 | CEPC | ALPHA | PRCTR | PRC | PRCTR_EMPTY |
PRART | Project type | PS_PRART | CHAR | 2 | TCJ1 | PS_PRART | |||
AKOKR | Controlling area of requesting cost center | PS_AKOKR | CHAR | 4 | TKA01 | CACCD | CAC | ||
AKSTL | Requesting cost center | PS_AKSTL | CHAR | 10 | Assigned to domain | ALPHA | KOSTL | KOS | |
FKOKR | Controlling area of responsible cost center | PS_FKOKR | CHAR | 4 | TKA01 | CACCD | CAC | ||
FKSTL | Responsible cost center | PS_FKSTL | CHAR | 10 | Assigned to domain | ALPHA | KOSTL | KOS | |
PWPOS | Currency Key | OWAER | CUKY | 5 | Assigned to domain | WAERS | OWS | ||
SCOPE | Object Class | SCOPE_CV | CHAR | 2 | SCOPE | SCOPE_CV | PCO | ||
WERKS | Plant | WERKS_D | CHAR | 4 | T001W | WERKS | WRK | H_T001W_C | |
USR00 | 1st user field for 20 characters - WBS element- | USR00PRPS | CHAR | 20 | USRCHAR20 | ||||
USR01 | 2nd user field 20 digits - WBS element | USR01PRPS | CHAR | 20 | USRCHAR20 | ||||
USR02 | 3rd user-defined field 10 digits -WBS element | USR02PRPS | CHAR | 10 | USRCHAR10 | ||||
USR03 | 4th user-defined field 10 digits -WBS element | USR03PRPS | CHAR | 10 | USRCHAR10 | ||||
USR08 | 1st user field for date -WBS element | USR08PRPS | DATS | 8 | USRDATE | ||||
USR09 | 2nd user field for date -WBS element | USR09PRPS | DATS | 8 | USRDATE | ||||
USR10 | 1st user field for 'Ind. for evaluations' WBS elem. | USR10PRPS | CHAR | 1 | FLAG | ||||
USR11 | 2nd user field for 'Indicator for eval.s' WBS elemnt | USR11PRPS | CHAR | 1 | FLAG | ||||
KOSTL | Cost Center | KOSTL | CHAR | 10 | Assigned to domain | ALPHA | KOSTL | KOS | |
IZWEK | Reason for investment | IZWEK | CHAR | 2 | T087I | IZWEK | |||
ISIZE | Scale of investment objects | IM_SIZECL | CHAR | 2 | TAIF5 | ALPHA | SIZECL | ||
IUMKZ | Reason for environmental investment | AM_UMWKZ | CHAR | 5 | T087K | AM_UMWKZ | |||
STORT | Location | PS_STORT | CHAR | 10 | T499S | AP_STAND |
Key field | Non-key field |
How do I retrieve data from SAP table PSERB using ABAP code
The following ABAP code Example will allow you to do a basic selection on PSERB to SELECT all data from the tableDATA: WA_PSERB TYPE PSERB.
SELECT SINGLE *
FROM PSERB
INTO CORRESPONDING FIELDS OF WA_PSERB
WHERE...
How to access SAP table PSERB
Within an ECC or HANA version of SAP you can also view further information about PSERB and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects