SAP WSTI_POS_EVENT Physical Inventory in an Opened Store: POS Trans by Receipt Table
Overview
WSTI_POS_EVENT is a standard SAP S/4HANA table that stores Physical Inventory in an Opened Store: POS Trans by Receipt data. There are total 29 fields in the WSTI_POS_EVENT table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table WSTI_POS_EVENT belongs to Store Operations (LO-RFM-STO) module and is located in the package SAP Retail Store: Internet Application Components (WOST).
In addition, following links provide an overview of foreign key relationships, if any, that link WSTI_POS_EVENT to other SAP tables and standard CDS views available based on WSTI_POS_EVENT table in S/4HANA 2020.
Techincal Settings of WSTI_POS_EVENT
Below are technical details of the table WSTI_POS_EVENT
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of WSTI_POS_EVENT Fields
The following table gives you an overview of the fields available in WSTI_POS_EVENT
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | * | CLNT | 3 |
| WERKS | Plant | WERKS_D | * | CHAR | 4 |
| MATNR | Material Number | MATNR | * | CHAR | 40 |
| LGORT | Storage location | LGORT_D | * | CHAR | 4 |
| VORGDATUM | Transaction Date | WSTI_POSDATE | DATS | 8 | |
| VORGZEIT | Transaction Time | WSTI_POSTIME | TIMS | 6 | |
| MBLNR | Number of Material Document | MBLNR | CHAR | 10 | |
| MJAHR | Material Document Year | MJAHR | NUMC | 4 | |
| ZEILE | Item in Material Document | MBLPO | NUMC | 4 | |
| CPUDT | Day On Which Accounting Document Was Entered | CPUDT | DATS | 8 | |
| CPUTM | Time of Entry | CPUTM | TIMS | 6 | |
| STATPI | Physical Inventory Status of POS Transaction | WSTI_STATUS_PI | CHAR | 1 | |
| ORIGIN | Origin of Transaction | WSTI_ORIGIN | CHAR | 1 | |
| STORNO | Reverse Posting | WSTI_STORNO | CHAR | 1 | |
| SIGN | Plus/Minus Sign of POS Transaction | WSTI_SIGN | CHAR | 1 | |
| ERFMG | Quantity in Unit of Entry | MB_ERFMG | QUAN | 13 | |
| ERFME | Unit of entry | ERFME | * | UNIT | 3 |
| MENGE | Quantity | MENGE_D | QUAN | 13 | |
| MEINS | Base Unit of Measure | MEINS | * | UNIT | 3 |
| EXVKW | Externally Entered Sales Value in Local Currency | EXVKW | CURR | 13 | |
| WAERS | Currency Key | WAERS | * | CUKY | 5 |
| BSTAR | Stock Type (Physical Inventory) | I_BSTAR | * | CHAR | 1 |
| SOBKZ | Special Stock Indicator | SOBKZ | * | CHAR | 1 |
| LIFNR | Vendor's account number | ELIFN | * | CHAR | 10 |
| CHARG | Batch Number | CHARG_D | * | CHAR | 10 |
| WAART | Indicates that material is a value-only material | WAART | CHAR | 1 | |
| EMATNR | Material Number | MATNR | * | CHAR | 40 |
| DOCNUM | IDoc number | EDI_DOCNUM | NUMC | 16 | |
| XBUIB_DONE | Indicator: Book Inventory Changed Using Standard Function | WSTI_XBUIB_DONE | 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 WSTI_POS_EVENT