SAP WSGM_ITEM_DB_TMP SRS GM: Temporary Persistence for Item Data Table
Overview
WSGM_ITEM_DB_TMP is a standard SAP S/4HANA table that stores SRS GM: Temporary Persistence for Item Data data. There are total 15 fields in the WSGM_ITEM_DB_TMP table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table WSGM_ITEM_DB_TMP belongs to Store Operations (LO-RFM-STO) module and is located in the package Retail Store: Goods Movements - Model Components (WOST_WSGM_GM_MODEL).
In addition, following links provide an overview of foreign key relationships, if any, that link WSGM_ITEM_DB_TMP to other SAP tables and standard CDS views available based on WSGM_ITEM_DB_TMP table in S/4HANA 2020.
Techincal Settings of WSGM_ITEM_DB_TMP
Below are technical details of the table WSGM_ITEM_DB_TMP
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of WSGM_ITEM_DB_TMP Fields
The following table gives you an overview of the fields available in WSGM_ITEM_DB_TMP
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | * | CLNT | 3 |
| MATERIAL | Material Number | MATNR | * | CHAR | 40 |
| EAN_UPC | International Article Number (EAN/UPC) | EAN11 | CHAR | 18 | |
| ITEM_TEXT | Item Text | SGTXT | CHAR | 50 | |
| ENTRY_QNT | Quantity in unit of entry | ERFMG | QUAN | 13 | |
| ENTRY_UOM | Unit of entry | ERFME | * | UNIT | 3 |
| MOVE_PLANT | Receiving plant/issuing plant | UMWRK | * | CHAR | 4 |
| STGE_LOC | Storage location | LGORT_D | * | CHAR | 4 |
| MOVE_STLOC | Receiving/issuing storage location | UMLGO | * | CHAR | 4 |
| MOVE_REAS | Reason for Movement | MB_GRBEW | * | NUMC | 4 |
| MOVE_MATL | Receiving/Issuing Material | UMMAT | * | CHAR | 40 |
| EXPIRYDATE | Shelf Life Expiration or Best-Before Date | VFDAT | DATS | 8 | |
| PROD_DATE | Date of Manufacture | HSDAT | DATS | 8 | |
| COSTCENTER | Cost Center | KOSTL | * | CHAR | 10 |
| GL_ACCOUNT | G/L Account Number | SAKNR | * | CHAR | 10 |
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 WSGM_ITEM_DB_TMP