PSTX
PS Texts (Header)
PSTX is an SAP database table in S/4HANA. PS Texts (Header). It contains 11 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_ProjectTextObject | view | from | BASIC | Project System Text Object |
Fields (11)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | psmandt | MANDT | Client | |||
| KEY | pstxtky | TXTKY | Text number | |||
| pstxtar | TXTAR | Text type | ||||
| pstxtti | TXTTI | Description | ||||
| pstxthu | USERH | Created by | ||||
| pstxthd | DATEH | Created on | ||||
| pstxtau | USERV | Changed by | ||||
| pstxtad | DATEV | Changed on | ||||
| psformat | PSFORMAT | Text format | ||||
| lastchangedon | LSTCHGAT | Changed At | ||||
| sdm_version | PS_S4_SDM_VERSION_PS_TEXT | PS S4 SDM Version field for PS Text |
Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.
-- PS Texts (Header)
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PSTX (
PSMANDT, -- Client [MANDT]
PSTXTKY, -- Text number [TXTKY]
PSTXTAR, -- Text type [TXTAR]
PSTXTTI, -- Description [TXTTI]
PSTXTHU, -- Created by [USERH]
PSTXTHD, -- Created on [DATEH]
PSTXTAU, -- Changed by [USERV]
PSTXTAD, -- Changed on [DATEV]
PSFORMAT, -- Text format [PSFORMAT]
LASTCHANGEDON, -- Changed At [LSTCHGAT]
SDM_VERSION, -- PS S4 SDM Version field for PS Text [PS_S4_SDM_VERSION_PS_TEXT]
PRIMARY KEY (PSMANDT, PSTXTKY)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA