SAP WSTN_PP_PURCH Prepack definition - Purchasing price table Table
Overview
WSTN_PP_PURCH is a standard SAP S/4HANA table that stores Prepack definition - Purchasing price table data. There are total 10 fields in the WSTN_PP_PURCH table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table WSTN_PP_PURCH belongs to Obsolete Functionality (LO-RFM-OBS) module and is located in the package Prepack Allocation Planning Dialog (WSTRN).
In addition, following links provide an overview of foreign key relationships, if any, that link WSTN_PP_PURCH to other SAP tables and standard CDS views available based on WSTN_PP_PURCH table in S/4HANA 2020.
Techincal Settings of WSTN_PP_PURCH
Below are technical details of the table WSTN_PP_PURCH
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of WSTN_PP_PURCH Fields
The following table gives you an overview of the fields available in WSTN_PP_PURCH
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 |
| PPNR | Material Number of the Prepack Material | WSTR_LOTNR | MARA | CHAR | 40 |
| EKORG | Purchasing organization | EKORG | T024E | CHAR | 4 |
| WERKS | Plant | EWERK | T001W | CHAR | 4 |
| LIFNR | Account Number of Vendor or Creditor | LIFNR | LFA1 | CHAR | 10 |
| ACTUAL_PR | Current prepack purchasing price | WSTN_ACTUAL_PR | CURR | 11 | |
| CALC_PR | Calculated prepack purchasing price | WSTN_CALC_PR | CURR | 11 | |
| OVR_PR | Overridden prepack purchasing price | WSTN_OVR_PR | CURR | 11 | |
| WAERS | Currency Key | WAERS | TCURC | CUKY | 5 |
| FRC_RECALC | Update Purchasing Price for Prepack | WSTN_FRC_RECALC | CHAR | 1 |
Foreign Key Relationships
A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for WSTN_PP_PURCH
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| WSTN_PP_PURCH | EKORG | : | T024E |
| WSTN_PP_PURCH | LIFNR | : | LFA1 |
| WSTN_PP_PURCH | MANDT | 1: CN | T000 |
| WSTN_PP_PURCH | PPNR | : | MARA |
| WSTN_PP_PURCH | WAERS | : | TCURC |
| WSTN_PP_PURCH | WERKS | : | T001W |