SAP VDESCROW0 TEMPORARY USE: Escrow-Specific Master Data Table data and field list

VDESCROW0 is a standard SAP Table which is used to store TEMPORARY USE: Escrow-Specific Master Data data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The VDESCROW0 table consists of various fields, each holding specific information or linking keys about TEMPORARY USE: Escrow-Specific Master Data data available in SAP. These include MGUID (GUID), RERF (Entered by), DERF (First Entered on), TERF (Time of Initial Entry)... 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. .

VDESCROW0 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 VDESCROW0 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 VDESCROW0 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
MANDTClient MANDTCLNT3Assigned to domainMANDT
MGUIDGUID TB_ESC_GUID16RAW16T_ESC_GUID_16
RERFEntered by RERFCHAR12SYCHAR12
DERFFirst Entered on DERFDATS8DATUM
TERFTime of Initial Entry TERFTIMS6TIMES
REHERSource of initial entry REHERCHAR10CHAR10
RBEAREmployee ID RBEARCHAR12SYCHAR12
DBEARLast Edited on DBEARDATS8DATUM
TBEARLast Edited at TBEARTIMS6TIMES
RBHEREditing Source RBHERCHAR10CHAR10
MSTATUSAccount Status TB_ESC_STATUSCHAR1T_ESC_STATUS
MSTATUS_DEFDefault Status TB_ESC_STATUS_DEFCHAR1T_ESC_STATUS_DEF
MSECURITYSecurity Level TB_ESC_SECURITYCHAR1T_ESC_SECURITY
MSTATELAWApplicable State Law TB_ESC_STATELAWCHAR3T_ESC_STATELAW
MREASONSETUPReason for Opening or Closing Account TB_ESC_REASONCHAR3T_ESC_REASON
MREASONCLOSEReason for Closing Account TB_ESC_REASON_CLCHAR3T_ESC_REASON
MPROPERTYIDObject Number (Main Object) TB_ESC_PROPIDNUMC10Assigned to domainSOBJNR
UCONTCURRCurrency SWHRCUKY5Assigned to domainWAERSWHR

Key field Non-key field



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

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

SELECT SINGLE *
FROM VDESCROW0
INTO CORRESPONDING FIELDS OF WA_VDESCROW0
WHERE...

How to access SAP table VDESCROW0

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

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