SAP WSTI_DB_TMP_ITEM SAP Retail Store temporary persistence item table Table
Overview
WSTI_DB_TMP_ITEM is a standard SAP S/4HANA table that stores SAP Retail Store temporary persistence item table data. There are total 18 fields in the WSTI_DB_TMP_ITEM table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table WSTI_DB_TMP_ITEM belongs to Store Operations (LO-RFM-STO) module and is located in the package SAP Retail Store: Count Doc. for Multiple Stock Placement (WOST_WSTI_MLT_MODEL).
In addition, following links provide an overview of foreign key relationships, if any, that link WSTI_DB_TMP_ITEM to other SAP tables and standard CDS views available based on WSTI_DB_TMP_ITEM table in S/4HANA 2020.
Techincal Settings of WSTI_DB_TMP_ITEM
Below are technical details of the table WSTI_DB_TMP_ITEM
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of WSTI_DB_TMP_ITEM Fields
The following table gives you an overview of the fields available in WSTI_DB_TMP_ITEM
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| CLIENT | Client | MANDT | * | CLNT | 3 |
| WSTI_ITEMNO | SRS PI for Handheld Item Number | WSTI_DE_ITEMNO | NUMC | 3 | |
| WSTI_LINENO | SRS PI for Handheld Line Number | WSTI_DE_LINENO | NUMC | 3 | |
| PHYSINVENTORY | Physical Inventory Document | IBLNR | CHAR | 10 | |
| FISC_YEAR | Fiscal Year | GJAHR | NUMC | 4 | |
| ITEM | Line Number | DZEILE | NUMC | 3 | |
| MATERIAL | Material Number | MATNR | * | CHAR | 40 |
| MATL_DESC | Material Description | MAKTX | CHAR | 40 | |
| EAN_UPC | International Article Number (EAN/UPC) | EAN11 | CHAR | 18 | |
| STOCK_TYPE | Stock Type (Physical Inventory) | I_BSTAR | * | CHAR | 1 |
| DESCR_STOCK_TYPE | Text for stock type | BTEXT | CHAR | 20 | |
| COUNT_STATUS | Item has been counted | XZAEL | CHAR | 1 | |
| ZERO_COUNT | Zero Count | XNULL | CHAR | 1 | |
| ENTRYQUANTITY | Quantity in Unit of Entry (Physical Inventory) | I_ERFMG | QUAN | 13 | |
| ENTRYUOM | Unit of Entry (Physical Inventory) | I_ERFME | * | UNIT | 3 |
| STGE_BIN | SAP Retail Store Physical Inventory Storage Bin | WSTI_STGE_BIN | CHAR | 30 | |
| COUNTTIMESTAMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TIMESTAMP | DEC | 15 | |
| USER_NAME | User Name | USNAM | * | CHAR | 12 |
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_DB_TMP_ITEM