SAP WSTI_DB_TMP_HEAD SAP Retail Store temporay persistence header table Table
Overview
WSTI_DB_TMP_HEAD is a standard SAP S/4HANA table that stores SAP Retail Store temporay persistence header table data. There are total 19 fields in the WSTI_DB_TMP_HEAD 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_HEAD 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_HEAD to other SAP tables and standard CDS views available based on WSTI_DB_TMP_HEAD table in S/4HANA 2020.
Techincal Settings of WSTI_DB_TMP_HEAD
Below are technical details of the table WSTI_DB_TMP_HEAD
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of WSTI_DB_TMP_HEAD Fields
The following table gives you an overview of the fields available in WSTI_DB_TMP_HEAD
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| CLIENT | Client | MANDT | * | CLNT | 3 |
| PHYSINVENTORY | Physical Inventory Document | IBLNR | CHAR | 10 | |
| FISC_YEAR | Fiscal Year | GJAHR | NUMC | 4 | |
| PHYSINV_DESC | Description of Physical Inventory Document | IM_PI_DOC_DESCRIPTION | CHAR | 40 | |
| DOCUMENTTYPE | SRS PI for Handheld Document Type | WSTI_DE_DOCUMENTTYPE | NUMC | 1 | |
| PLANT | Plant | WERKS_D | * | CHAR | 4 |
| STGE_LOC | Storage location | LGORT_D | * | CHAR | 4 |
| DESCR_STGE_LOC | Description of Storage Location | LGOBE | CHAR | 16 | |
| STOCK_TYPE | Stock Type (Physical Inventory) | I_BSTAR | * | CHAR | 1 |
| DESCR_STOCK_TYPE | Text for stock type | BTEXT | CHAR | 20 | |
| COUNT_DATE | Date of Last Count | DZLDAT | DATS | 8 | |
| COUNT_STATUS | Count Status | DZSTAT | CHAR | 1 | |
| WSTI_COUNTSTATUS | SRS PI for Handheld Count Status | WSTI_DE_COUNTSTATUS | NUMC | 1 | |
| SPEC_STOCK | Special Stock Indicator | SOBKZ | * | CHAR | 1 |
| USER_NAME | User Name | USNAM | * | CHAR | 12 |
| PHYS_INV_NO | Physical Inventory Number | INVNU1 | CHAR | 16 | |
| PLAN_DATE | Planned Date of Inventory Count | GIDAT | DATS | 8 | |
| COUNTTIMESTAMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TIMESTAMP | DEC | 15 | |
| PHYS_INV_REF | Reference Number for Physical Inventory | XBLNI1 | CHAR | 16 |
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_HEAD