SAP Table PSTXR
PS Text Structure for Project Reporting
PSTXR (PS Text Structure for Project Reporting) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link PSTXR to other SAP tables.
Source: PSTXR (PS Text Structure for Project Reporting)
PSTXR table fields
Field | Data element | Checktable | Datatype | Length | Decimals | |||
---|---|---|---|---|---|---|---|---|
ARNUMMER | Archiving Session Number | ADMI_RUN_D | CHAR | 6 | 0 | |||
VSGRUPPE | Group for a project version | VSGRUPPE | CHAR | 20 | 0 | |||
VSNUMMER | Number or description of a version | VSNMR | CHAR | 12 | 0 | |||
PRCTR | Profit Center | PRCTR | CEPC | CHAR | 10 | 0 | ||
KDAUF | Sales and Distribution Document Number | VBELN | VBUK | CHAR | 10 | 0 | ||
KDPOS | Item number of the SD document | POSNR | VBUP | NUMC | 6 | 0 | ||
PSPID | Project Definition | PS_PSPID | CHAR | 24 | 0 | |||
POSID | Work Breakdown Structure Element (WBS Element) | PS_POSID | CHAR | 24 | 0 | |||
AUFNR | Network number | NW_AUFNR | AUFK | CHAR | 12 | 0 | ||
VORNR | Activity number in network and standard network | CN_VORNR | CHAR | 4 | 0 | |||
TXTAR | Text type | TXTAR | TCN03 | CHAR | 2 | 0 | ||
TXTTI | PS text description | TXTTI | CHAR | 20 | 0 | |||
TXTHU | PS Text created by | USERH | CHAR | 12 | 0 | |||
TXTHD | PS Text created on | DATEH | DATS | 8 | 0 | |||
TXTAU | PS Text changed by | USERV | CHAR | 12 | 0 | |||
TXTAD | PS text changed on | DATEV | DATS | 8 | 0 | |||
FORMAT | Text format for PS text | PSFORMAT | CHAR | 1 | 0 |
PSTXR foreign key relationships
Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
---|---|---|---|---|---|---|
PSTXR | AUFNR | SY | MANDT | AUFK | Order master data | MANDT |
PSTXR | AUFNR | PSTXR | AUFNR | AUFK | Order master data | AUFNR |
PSTXR | KDAUF | SY | MANDT | VBUK | Sales Document: Header Status and Administrative Data | MANDT |
PSTXR | KDAUF | PSTXR | KDAUF | VBUK | Sales Document: Header Status and Administrative Data | VBELN |
PSTXR | KDPOS | SY | MANDT | VBUP | Sales Document: Item Status | MANDT |
PSTXR | KDPOS | PSTXR | KDAUF | VBUP | Sales Document: Item Status | VBELN |
PSTXR | KDPOS | PSTXR | KDPOS | VBUP | Sales Document: Item Status | POSNR |
PSTXR | PRCTR | SY | MANDT | CEPC | Profit Center Master Data Table | MANDT |
PSTXR | PRCTR | PSTXR | PRCTR | CEPC | Profit Center Master Data Table | PRCTR |
PSTXR | PRCTR | PSTXR | TXTHD | CEPC | Profit Center Master Data Table | DATBI |
PSTXR | PRCTR | * | CEPC | Profit Center Master Data Table | KOKRS | |
PSTXR | TXTAR | PSTX | PSMANDT | TCN03 | PS Text Types | MANDT |
PSTXR | TXTAR | PSTXR | TXTAR | TCN03 | PS Text Types | TXTAR |