SAP WSGR_HEAD_DB_TMP SRS GM: Temporary Persistence for Header Data Table data and field list

WSGR_HEAD_DB_TMP is a standard SAP Table which is used to store SRS GM: Temporary Persistence for Header Data data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The WSGR_HEAD_DB_TMP table consists of various fields, each holding specific information or linking keys about SRS GM: Temporary Persistence for Header Data data available in SAP. These include GUID_DB_TMP (Retail Store: Globally Unique Identifier Temp.Persistence), TIMESTAMP_DB_TMP (Retail Store: Temporary Persistence - Time Stamp), USERNAME (User Name), PLANT (Plant)... See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

WSGR_HEAD_DB_TMP table Technical Details:

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)

SAP WSGR_HEAD_DB_TMP table fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the WSGR_HEAD_DB_TMP table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.

Field	Description	Data Element	Data Type	length (Dec)	Check table	Conversion Routine	Domain Name	MemoryID	SHLP
MANDT	Client	MANDT	CLNT	3	Assigned to domain		MANDT
GUID_DB_TMP	Retail Store: Globally Unique Identifier Temp.Persistence	WSRS_GUID_DB_TMP	RAW	16
TIMESTAMP_DB_TMP	Retail Store: Temporary Persistence - Time Stamp	WSRS_TIMESTAMP_DB_TMP	DEC	15			TZNTSTMPS
USERNAME	User Name	SYUNAME	CHAR	12			SYCHAR12
PLANT	Plant	WERKS_D	CHAR	4	Assigned to domain		WERKS	WRK	H_T001W_C
REF_ID	SAP Retail Store: Numeric Key for Reference Document	STWB_REFNR	CHAR	4			REF_ID
REF_DOC_NO	Retail Store GR: Reference Document Number	WSGM_REF_DOC_NO	CHAR	20		ALPHA	WSGM_REF_DOC_NO
REF_DOC_YEAR	Material Document Year	MJAHR	NUMC	4		GJAHR	GJAHR	MJA
VNDR_ID	SAP Retail Store: Vendor or Plant Number	WSRS_VENDOR_SITE_ID	CHAR	10
VNDR_TYPE	SAP Retail Store: Indicator Vendor or Plant	WSRS_VENDOR_SITE_TYPE	CHAR	1			WSRS_VENDOR_SITE_TYPE
DELIVERY_NOTE	Number of External Delivery Note	LFSNR1	CHAR	16			XBLNR1
GR_GI_SLIP_NR	Goods Receipt/Issue Slip Number	XABLN	CHAR	10		ALPHA	BELNR
PSTNG_DATE	Posting Date in the Document	BUDAT	DATS	8			DATUM
DOC_DATE	Document Date in Document	BLDAT	DATS	8			DATUM
MOVE_REAS	Reason for Movement	MB_GRBEW	NUMC	4	Assigned to domain		MB_GRBEW
STGE_LOC	Storage Location	LGORT_D	CHAR	4	Assigned to domain		LGORT	LAG
SRS_CODE	SAP Retail Store Function Code	SRS_CODE	CHAR	4			SRS_CODE

Key field

Non-key field

< WSGM_WD_GR_REF_SRCH_CNTRL - Retail Store GR: Buttons/Controls in Result List ALV WSGR_ITEM_DB_TMP - SRS GR: Temporary Persistence for Item Data >

How do I retrieve data from SAP table WSGR_HEAD_DB_TMP using ABAP code

The following ABAP code Example will allow you to do a basic selection on WSGR_HEAD_DB_TMP to SELECT all data from the table
DATA: WA_WSGR_HEAD_DB_TMP TYPE WSGR_HEAD_DB_TMP.

SELECT SINGLE *
FROM WSGR_HEAD_DB_TMP
INTO CORRESPONDING FIELDS OF WA_WSGR_HEAD_DB_TMP
WHERE...

How to access SAP table WSGR_HEAD_DB_TMP

Within an ECC or HANA version of SAP you can also view further information about WSGR_HEAD_DB_TMP and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).