SE11 ABAP Dictionary SE11 PRHIS

Data SE16 SE16
Popular:
VBAK VBAP MARA MAKT BKPF BSEG BVOR EKKO EKPO KNA1 LFA1 LIKP VBRK

PRHIS

Standard WBS, Edges (Hierarchy pointers)
SAP SAP Transparent Table 7 Fields
Primary Key:
MANDT POSNR

Dictionary Fields Fields

(7 dari 7 kolom)
# Field Name Key Field Label Type Length Dec Check Table Short Description
1
MANDT
KEY Client CLNT 3 - T000 Client
2
POSNR
KEY SWBS elem. NUMC 8 - - Std WBS: Internal project item number (w/exit on ID)
3
PSPHI
- Curr. proj NUMC 8 - - Current number for standard project
4
UP
- Superior NUMC 8 - - No. of the superior standard WBS element
5
DOWN
- 1st sub. NUMC 8 - - No. of the first subordinate standard WBS element
6
LEFT
- Left NUMC 8 - - No. of the left adjacent position in standard WBS
7
RIGHT
- Right NUMC 8 - - No. of the right adjacent position in standard WBS

Related References & SQL

Diagram ERD, T-Code standar, tabel terkait, dan contoh query untuk PRHIS.

Interactive ERD Diagrams
SAP PP - Project Planning → SAP PP / PS - Project Systems Table Mapping →
Standard T-Codes
SE11 SE16
Related Tables
PROJ PRPS PRTE PRTX PSTX PSTT
ANSI SQL Query 
SELECT a.POSNR,
       a.PSPHI,
       a.UP,
       a.DOWN,
       a.LEFT,
       a.RIGHT
FROM PRHIS AS a
WHERE a.POSNR = '0001';
ABAP OpenSQL (7.40+) 
SELECT a~posnr,
       a~psphi,
       a~up,
       a~down,
       a~left,
       a~right
  FROM prhis AS a
  WHERE a~posnr = '0001'
  INTO TABLE @DATA(lt_prhis)
  UP TO 100 ROWS.