SE11 ABAP Dictionary SE11 PSTX

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

PSTX

PS Texts (Header)
SAP SAP Transparent Table 9 Fields
Primary Key:
PSMANDT PSTXTKY

Dictionary Fields Fields

(9 dari 9 kolom)
# Field Name Key Field Label Type Length Dec Check Table Short Description
1
PSMANDT
KEY Client CLNT 3 - - Client
2
PSTXTKY
KEY Text no. CHAR 12 - - Internal text number (12-character)
3
PSTXTAR
- Text type CHAR 2 - - Text type
4
PSTXTTI
- Descrptn CHAR 20 - - PS text description
5
PSTXTHU
- Created CHAR 12 - - PS Text created by
6
PSTXTHD
- Created on DATS 8 - - PS Text created on
7
PSTXTAU
- Changed CHAR 12 - - PS Text changed by
8
PSTXTAD
- Changed on DATS 8 - - PS text changed on
9
PSFORMAT
- Format CHAR 1 - - Text format for PS text

Related References & SQL

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

Interactive ERD Diagrams
SAP PP - Project Planning → SAP PP / PS - Project Systems Table Mapping →
Standard T-Codes
SE11 SE16
Related Tables
PROJ PRPS PRTE PRHIS PRTX PSTT
ANSI SQL Query 
SELECT a.PSMANDT,
       a.PSTXTKY,
       a.PSTXTAR,
       a.PSTXTTI,
       a.PSTXTHU,
       a.PSTXTHD,
       a.PSTXTAU
FROM PSTX AS a
WHERE a.PSMANDT = '0001'
  AND a.PSTXTKY = '0001';
ABAP OpenSQL (7.40+) 
SELECT a~psmandt,
       a~pstxtky,
       a~pstxtar,
       a~pstxtti,
       a~pstxthu,
       a~pstxthd,
       a~pstxtau
  FROM pstx AS a
  WHERE a~psmandt = '0001'
  and a~pstxtky = '0001'
  INTO TABLE @DATA(lt_pstx)
  UP TO 100 ROWS.