SAP VDBEPI_SHADOW Shadow Table for VDBEPI (Restrictions) Table data and field list

VDBEPI_SHADOW is a standard SAP Table which is used to store Shadow Table for VDBEPI (Restrictions) data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The VDBEPI_SHADOW table consists of various fields, each holding specific information or linking keys about Shadow Table for VDBEPI (Restrictions) data available in SAP. These include BUKRS (Company Code), RBELKPFD (Document Number of Document Header (Loan)), RPOSNR (Activity number), SBEWART (Flow Type)... 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. .

VDBEPI_SHADOW 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 VDBEPI_SHADOW 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 VDBEPI_SHADOW 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
BUKRS	Company Code	BUKRS	CHAR	4	Assigned to domain		BUKRS	BUK	C_T001
RBELKPFD	Document Number of Document Header (Loan)	RBELKPFD	CHAR	10		ALPHA	RBELKPFD
RPOSNR	Activity number	NVORGANG	CHAR	3			CHAR3
SBEWART	Flow Type	SBEWART	CHAR	4	Assigned to domain		SBEWART
SREFBEW	Reference flow type	SREFBEW	CHAR	4	Assigned to domain		SBEWART
SBEWZITI	Flow category	SBEWZITI	CHAR	4	Assigned to domain		SBEWZITI
BNWHR	Nominal amount	BNWHR	CURR	13(2)			WERTV7
SNWHR	Currency of nominal amount	SNWHR	CUKY	5	Assigned to domain		WAERS
BBWHR	Amount in position currency	BBWHR	CURR	13(2)			WERTV7
SBWHR	Position Currency (Currency of Position Amount)	SBWHR	CUKY	5	Assigned to domain		WAERS
BCWHR	Settlement Amount	BCWHR	CURR	13(2)			WERTV7
SCWHR	Settlement Currency	SCWHR	CUKY	5	Assigned to domain		WAERS
BHWHR	Amount in local currency	BHWHR	CURR	13(2)			WERTV7
PKKURS	Purchase Price of Borrower's Note	PKKURS	DEC	10(7)			PWKURS
PRUCK	Repayment rate in percent	PRUCK	DEC	10(7)			DEC3_7
KURS1	Exchange rate	VVKURSF	DEC	9(5)		EXCRT	KURSF
KURS2	Exchange rate	VVKURSF	DEC	9(5)		EXCRT	KURSF
DVALUT	Calculation Date	DVALUT	DATS	8			DATUM
DFAELL	Due date	DFAELL	DATS	8			DATUM
DDISPO	Payment Date	DDISPO	DATS	8			DATUM
DBESTAND	Position value date	DBESTAND	DATS	8			DATUM
DBERVON	Start of Calculation Period	DBERVON	DATS	8			DATUM
UMSKZ	Special G/L Indicator	UMSKZ	CHAR	1	Assigned to domain		UMSKZ
KOSTL	Cost Center	KOSTL	CHAR	10	Assigned to domain	ALPHA	KOSTL	KOS
SSPESEN	Expenses key	SSPESEN	CHAR	1			SSPESEN
SSOLHAB	Debit/credit indicator	VVSSOLHAB	CHAR	1			VVSSOLHAB
RSOLL	Account for debit posting	RSOLL	CHAR	10	Assigned to domain	ALPHA	SAKNR
RHABEN	Account for credit posting	RHABEN	CHAR	10	Assigned to domain	ALPHA	SAKNR
RZKSOLL	Debit interim account	RZKSOLL	CHAR	10	Assigned to domain	ALPHA	SAKNR
RZKHABE	Credit interim account	RZKHABE	CHAR	10	Assigned to domain	ALPHA	SAKNR
SBSLSOLL	Posting Key	BSCHL	CHAR	2	Assigned to domain		BSCHL
SBSLZKSO	Posting Key	BSCHL	CHAR	2	Assigned to domain		BSCHL
SBSLZKHA	Posting Key	BSCHL	CHAR	2	Assigned to domain		BSCHL
SHSLHABEN	Posting Key	BSCHL	CHAR	2	Assigned to domain		BSCHL
BUCHTXT	Item Text	SGTXT	CHAR	50			TEXT50
RBANKK	Bank account	RBANKK	CHAR	10	Assigned to domain	ALPHA	SAKNR	BKT
SFDLEV	Planning level	FDLEV	CHAR	2	Assigned to domain		FDLEV	FFE
JFDUPD	Record transferred to cash management and forecast	JFDUPD	CHAR	1			JANEI
JONLAEN	Indicator for fixing a flow record	JONLAEN	CHAR	1			VVSONLAEN
JZINSBAS	Flow in interest base	JZINSBAS	CHAR	1			JANEI
JZINSZPT	Interest date	JZINSZPT	CHAR	1			JANEI
PKOND	Percentage rate for condition items	PKOND	DEC	10(7)			DECV3_7
BBASIS	Calculation base amount	BBASIS	CURR	13(2)			WERTV7
SSORTZIT	Sort indicator for interest/repayment schedule calculations	SSORTZIT	CHAR	1			CHAR1
SWOHER	Source of flow record	SWOHER	CHAR	1			CHAR1
KUNNR	Customer Numbers	KUNNR	CHAR	10	Assigned to domain	ALPHA	KUNNR	KUN	C_KUNNR
BVTYP	Partner Bank Type	BVTYP	CHAR	4			BVTYP
ZLSCH	Payment Method	DZLSCH	CHAR	1	Assigned to domain		ZLSCH
MABER	Dunning Area	MABER	CHAR	2	Assigned to domain		MABER
ZAHLS	Block Key for Payment	DZAHLS	CHAR	1	Assigned to domain		ZAHLS
RPARTNR	Business Partner Number	BP_PARTNR_NEW	CHAR	10	Assigned to domain	ALPHA	BU_PARTNER	BPA	BUPA
SROLEXT	Dummy function	DUMMY_3	CHAR	3			CHAR3
JEINBEHALT	Indicator for Withholding of Amount During Disbursement	JEINBEHALT	CHAR	1			KENZX
JFIRUECK	Confirmation From FI Not Necessary	JFIRUECK	CHAR	1			JANEI
MWSKZ	Tax on sales/purchases code	MWSKZ	CHAR	2	Assigned to domain		MWSKZ
MWART	Tax Type	MWART	CHAR	1			MWART
DBERBIS	End of Calculation Period	DBERBIS	DATS	8			DATUM
ATAGE	Number of days	VVATAGE	NUMC	6			INT6
ABASTAGE	Number of base days in a calculation period	ABASTAGE	NUMC	6			INT6
SZBMETH	Interest Calculation Method	SZBMETH	CHAR	1			SZBMETH
JSTOCK	Premium reserve fund-relevant indicator	VVJSTOCK	CHAR	1			JANEI
SBUST	Posting control key	VVSBUST	NUMC	2			VVSBUST
DTRANS	Flow data key: System date	VVDTRANS	DATS	8			DATUM
TTRANS	Transaction data key: system time	VVTTRANS	TIMS	6			UZEIT
NTRANS	Transaction data key: Consecutive number	VVNTRANS	NUMC	4			NUMC4
GSBER	Business Area	GSBER	CHAR	4	Assigned to domain		GSBER	GSB
SKOART	Condition Type (Smallest Subdivision of Condition Records)	SKOART	NUMC	4	Assigned to domain		SKOART
SEXCLVON	Exclusive Indicator for the Start of a Calculation Period	VVSEXCLVON	NUMC	1			VVSEXCLVON
SULTVON	Month-End Indicator for Start of a Calculation Period	VVSULTVON	CHAR	1			VVSULT
SINCLBIS	Inclusive Indicator for the End of a Calculation Period	VVSINCLBIS	NUMC	1			VVSINCLBIS
SULTBIS	Month-End Indicator for the End of a Calculation Period	VVSULTBIS	CHAR	1			VVSULT
SINCL	Inclusive indicator for beginning and end of a period	VVSINCL	NUMC	1			VVSINCL
DVERRECH	Settlement date	VVDVERRECH	DATS	8			DATUM
DPKOND	Determination date for percentage rate of condition items	VVDPKOND	DATS	8			DATUM
SBUCHA	Indicator for postings to accruals/deferrals accounts	VVSBUCHA	CHAR	1			CHAR1
ZINKZ	Exempted from interest calculation	DZINKZ	CHAR	2			ZINKZ
SVULT	Month-End Indicator for Value Date	VVSVULT	CHAR	1			VVSULT
JSOFVERR	Immediate settlement	JSOFVERR	CHAR	1			TFMSOFVERR
SINCLVERR	Inclusive Indicator for Clearing Date	VVSINCLVER	NUMC	1			VVSINCLVER
SULTVERR	Month-End Indicator for Clearing Date	VVSULTVERR	CHAR	1			VVSULT
SREFZITI	Refer.flow category in accrual/deferral flow records	VVSREFZITI	CHAR	4	Assigned to domain		SBEWZITI
STGBASIS	Base Days Method	VVSTGBASIS	NUMC	1			VVSTGBASIS
STGMETH	Daily Method	VVSTGMETH	NUMC	1			VVSTGMETH
SBASIS	Calculation base reference	VVSBASIS	CHAR	4	Assigned to domain		VVSBASIS
SGTXT	Item Text	SGTXT	CHAR	50			TEXT50
SBERFIMA	Calculation category for cash flow calculator	SBEWFIMA	CHAR	4	Assigned to domain		SBEWFIMA
SVORGKZ	Activity indicator for debit/credit control	VVSVORGKZ	NUMC	2			VVSVORGKZ
MANSP	Dunning block	MANSP	CHAR	1	Assigned to domain		MANSP
DGUEL_KP	Condition Item Valid From	DGUEL_KP	DATS	8			DATUM
NSTUFE	Level number of condition item for recurring payments	NSTUFE	NUMC	2			NUMC2
DBPERIOD	Period start	VVDBPERIOD	DATS	8			DATUM
SPAEXCL	Exclusive Indicator for Start Date of a Period	TFMSPAEXCL	NUMC	1			TFMSPAEXCL
SPAULT	Month-End Indicator for Start Date of a Period	TFMSPAULT	CHAR	1			VVSULT
DEPERIOD	Period End	VVDEPERIOD	DATS	8			DATUM
SPEINCL	Inclusive Indicator for End Date of a Period	TFMSPEINCL	NUMC	1			TFMSPEINCL
SPEULT	Month-End Indicator for End of a Period	TFMSPEULT	CHAR	1			VVSULT
SSTCKKZ	Accrued interest method	SSTCKKZ	CHAR	1			SSTCKKZ
NORDER	Order Number	NORDER	NUMC	8			NUM8	ORD
RKONT	Quota number	RKONT	NUMC	6			RKONT	RKT
DAUSZ	Lead date for withholding amounts for disbursement	VVDAUSZ	DATS	8			DATUM
SSOLIST	Calculation using actual principle (or debit)	SSOLIST	CHAR	1			CHAR1
RDARNEHM	Borrower/Applicant Number	RDARNEHM_NEW	CHAR	10	Assigned to domain	ALPHA	BU_PARTNER	BPA	BUPA
BKOND	Condition item currency amount	BKOND	CURR	13(2)			WERTV7
SBERECH	Grace Period Interest Method	SBERECH	CHAR	1			XFELD
BKARZINS	Int.for days betw. redemption clear.and pmnt (FiMa-internal)	TFMBKAZINS	CURR	13(2)			TFM_WRTV7
BTITALK	Imputed annuity repayment amount (FiMa internal)	TFMBTIKALK	CURR	13(2)			TFM_WRTV7
RERF	Entered by	RERF	CHAR	12			SYCHAR12
DERF	First Entered on	DERF	DATS	8			DATUM
TERF	Time of Initial Entry	TERF	TIMS	6			TIMES
REHER	Source of initial entry	REHER	CHAR	10			CHAR10
RBEAR	Employee ID	RBEAR	CHAR	12			SYCHAR12
DBEAR	Last Edited on	DBEAR	DATS	8			DATUM
TBEAR	Last Edited at	TBEAR	TIMS	6			TIMES
RBHER	Editing Source	RBHER	CHAR	10			CHAR10
HDN_KUNNR	Main Borrower Customer Number	HDN_KUNNR	CHAR	10	Assigned to domain	ALPHA	KUNNR
SZART	Payment transaction	TB_SZART	CHAR	1			XFELD
RUZBEL	Accounting Document Number	BELNR_D	CHAR	10		ALPHA	BELNR	BLN
REBZJ	Fiscal Year of the Relevant Invoice (for Credit Memo)	REBZJ	NUMC	4		GJAHR	GJAHR
REBZG	Number of the Invoice the Transaction Belongs to	REBZG	CHAR	10		ALPHA	BELNR
REBZZ	Line Item in the Relevant Invoice	REBZZ	NUMC	3			BUZEI
S_SSDREF	Reference flow category in borrower's note loan flow records	VVS_SSDREF	CHAR	4	Assigned to domain		SBEWZITI
PWKURS	Security price for percentage quotation	PWKURS	DEC	10(7)			PWKURS
DZFEST	Interest rate fixing date	TB_DZFEST	DATS	8			DATUM
XPORE	Indicator: Individual Payment?	PRQ_XPORE	CHAR	1			XFELD
SPAYRQ	Generate payment request	TB_SPAYRQK	CHAR	1			XFELD
PRKEY	Key Number for Payment Request	PRQ_KEYNO	CHAR	10	Assigned to domain	ALPHA	PRQ_KEYNO
HBKID	Short Key for a House Bank	HBKID	CHAR	5	Assigned to domain		HBKID
HKTID	ID for account details	HKTID	CHAR	5	Assigned to domain		HKTID
VORGTYP	Activity Category (Posting Area)	VORGTYP_LO	CHAR	4			VORGTYP_LO
ACENV	Source in TR-LO posting area	ACENV_LO	NUMC	4			ACENV_LO
SSIGN	Direction of flow	TB_SSIGN	CHAR	1			T_SSIGN
SPRSNG	Individual payment	TB_SPRSNGK	CHAR	1			XFELD
UZAWE	Payment Method Supplement	UZAWE	CHAR	2	Assigned to domain		UZAWE
SPRGRD	Determine grouping definition	TB_SPRGRD	CHAR	1			T_SPRGRD
SCSPAY	Same direction necessary for joint payment?	TB_SCSPAY	CHAR	1			XFELD
PAYGR	Grouping Field for Automatic Payments	PAYGR	CHAR	20			CHAR20
JEXPOZINS	Exponential Interest Calculation	TB_JZINSRE	CHAR	1			XFELD
SREVALEXCL	Price gains w/o proportionate gains from deferral write-back	VVSREVALEXCL	CHAR	1			XFELD
SROUND	Rounding Category	TFM_SROUND	CHAR	1			TFM_SROUND
SKALIDWT	Interest Calendar	TFMSKALIDWT	CHAR	2	Assigned to domain		WFCID		H_TFACD
JVERF	Indicator whether drawings exist for the disbursement	JVERF	CHAR	1			JVERF
PPAYMENT	Payment Rate	TFM_PPAYMENT	DEC	11(7)			TFM_PPAYMENT
AMMRHYZV	Interest Settlement Frequency for Exponential Interest Calc.	TFM_AMMRHYZV	NUMC	2			TFM_AMMRHYZV
LC_CAPITALS	Effect of the Flow on Capital Amounts Status	TB_LC_CAPITALS	CHAR	2			T_LC_CASH_FLOW
LC_DISBURSE	Effect of the Flow on the Disbursement Status	TB_LC_DISBURSE	CHAR	2			T_LC_CASH_FLOW
DFAELL_OLD_EXT	Old Due Date	TB_EXTENS_DFAELL_OLD	DATS	8			DATUM
DDISPO_OLD_EXT	Old Payment Date	TB_EXTENS_DDISPO_OLD	DATS	8			DATUM
RBO_EXT	Business Operation Number (Loans)	RBO	CHAR	15			RBO
SBEWEGRP2	Flow Record Group in Cash Flow Calculator (Incoming Payment)	TB_FLOW_REC_GRP	NUMC	6			SBEWEGRP2
SUSP_REASON_TYPE	Key for Overpayment Reason	TB_SUSPREASON	NUMC	3	Assigned to domain		T_SUSPREASON
BILL_NUMBER	Bill Number	TB_BILL_NUMBER	CHAR	15		ALPHA	T_BILL_NUMBER
BILL_DUE_DATE	Due Date for Bill	TB_BILL_DUE_DATE	DATS	8			DATUM
MNDID	Unique Referene to Mandate per Payment Recipient	SEPA_MNDID	CHAR	35			ID035
REMIT_INFO	Payment Notes Info	TB_REMIT_INFO	CHAR	140			T_REMIT_INFO

Key field

Non-key field

< VDBEPI_KEY - Flow Data (Key Fields VDBEPI) VDBEPP - Flow Data - Planned Item >

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

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

SELECT SINGLE *
FROM VDBEPI_SHADOW
INTO CORRESPONDING FIELDS OF WA_VDBEPI_SHADOW
WHERE...

How to access SAP table VDBEPI_SHADOW

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

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