SAP WSGR_ITEM_DB_TMP SRS GR: Temporary Persistence for Item Data Table
Overview
WSGR_ITEM_DB_TMP is a standard SAP S/4HANA table that stores SRS GR: Temporary Persistence for Item Data data. There are total 15 fields in the WSGR_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 WSGR_ITEM_DB_TMP belongs to Store Operations (LO-RFM-STO) module and is located in the package Retail Store: Goods Receipt - Model Components (WOST_WSGM_GR_MODEL).
In addition, following links provide an overview of foreign key relationships, if any, that link WSGR_ITEM_DB_TMP to other SAP tables and standard CDS views available based on WSGR_ITEM_DB_TMP table in S/4HANA 2020.
Techincal Settings of WSGR_ITEM_DB_TMP
Below are technical details of the table WSGR_ITEM_DB_TMP
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of WSGR_ITEM_DB_TMP Fields
The following table gives you an overview of the fields available in WSGR_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_QUANTITY | Quantity in unit of entry | ERFMG | QUAN | 13 | |
| ENTRY_QTY_UNIT | Unit of entry | ERFME | * | UNIT | 3 |
| EXPIRY_DATE | Shelf Life Expiration or Best-Before Date | VFDAT | DATS | 8 | |
| PROD_DATE | Date of Manufacture | HSDAT | DATS | 8 | |
| RETURN_ITEM | Returns Item | RETPO | CHAR | 1 | |
| STORAGE_LOCATION | Storage location | LGORT_D | * | CHAR | 4 |
| MOVEMENT_REASON | Reason for Movement | MB_GRBEW | * | NUMC | 4 |
| COSTCENTER | Cost Center | KOSTL | * | CHAR | 10 |
| GL_ACCOUNT | G/L Account Number | SAKNR | * | CHAR | 10 |
| SALES_VAL | Externally Entered Sales Value in Local Currency | EXVKW | CURR | 13 | |
| CURRENCY | Currency Key | WAERS | * | CUKY | 5 |
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 WSGR_ITEM_DB_TMP