VDBEPI_SHADOW - Shadow Table for VDBEPI (Restrictions)

Shadow Table for VDBEPI (Restrictions) information is stored in SAP table VDBEPI_SHADOW.
It is part of development package FVVD in software component FS-CML. This development package consists of objects that can be grouped under "Treasury Loans".

Fields for table VDBEPI_SHADOW

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
MANDT	Client	X	MANDT	CLNT	6
.INCLUDE		X		VDBEPI_KEY	0
BUKRS	Company Code	X	BUKRS	CHAR	8
RBELKPFD	Document Number of Document Header (Loan)	X	RBELKPFD	CHAR	20
RPOSNR	Activity number	X	NVORGANG	CHAR	6
.INCLUDE				VDBEPI_FIELDS	0
SBEWART	Flow Type		SBEWART	CHAR	8	*
SREFBEW	Reference flow type		SREFBEW	CHAR	8	*
SBEWZITI	Flow category		SBEWZITI	CHAR	8	*
BNWHR	Nominal amount		BNWHR	CURR	7
SNWHR	Currency of nominal amount		SNWHR	CUKY	10	*
BBWHR	Amount in position currency		BBWHR	CURR	7
SBWHR	Position Currency (Currency of Position Amount)		SBWHR	CUKY	10	*
BCWHR	Settlement Amount		BCWHR	CURR	7
SCWHR	Settlement Currency		SCWHR	CUKY	10	*
BHWHR	Amount in local currency		BHWHR	CURR	7
PKKURS	Purchase Price of Borrower's Note		PKKURS	DEC	6
PRUCK	Repayment rate in percent		PRUCK	DEC	6
KURS1	Exchange rate		VVKURSF	DEC	5
KURS2	Exchange rate		VVKURSF	DEC	5
DVALUT	Calculation Date		DVALUT	DATS	16
DFAELL	Due date		DFAELL	DATS	16
DDISPO	Payment Date		DDISPO	DATS	16
DBESTAND	Position value date		DBESTAND	DATS	16
DBERVON	Start of Calculation Period		DBERVON	DATS	16
UMSKZ	Special G/L Indicator		UMSKZ	CHAR	2	*
KOSTL	Cost Center		KOSTL	CHAR	20	*
SSPESEN	Expenses key		SSPESEN	CHAR	2
SSOLHAB	Debit/credit indicator		VVSSOLHAB	CHAR	2
RSOLL	Account for debit posting		RSOLL	CHAR	20	*
RHABEN	Account for credit posting		RHABEN	CHAR	20	*
RZKSOLL	Debit interim account		RZKSOLL	CHAR	20	*
RZKHABE	Credit interim account		RZKHABE	CHAR	20	*
SBSLSOLL	Posting Key		BSCHL	CHAR	4	*
SBSLZKSO	Posting Key		BSCHL	CHAR	4	*
SBSLZKHA	Posting Key		BSCHL	CHAR	4	*
SHSLHABEN	Posting Key		BSCHL	CHAR	4	*
BUCHTXT	Item Text		SGTXT	CHAR	100
RBANKK	Bank account		RBANKK	CHAR	20	*
SFDLEV	Planning Level		FDLEV	CHAR	4	*
JFDUPD	Record transferred to cash management and forecast		JFDUPD	CHAR	2
JONLAEN	Indicator for fixing a flow record		JONLAEN	CHAR	2
JZINSBAS	Flow in interest base		JZINSBAS	CHAR	2
JZINSZPT	Interest date		JZINSZPT	CHAR	2
PKOND	Percentage rate for condition items		PKOND	DEC	6
BBASIS	Calculation Base Amount		BBASIS	CURR	7
SSORTZIT	Sort indicator for interest/repayment schedule calculations		SSORTZIT	CHAR	2
SWOHER	Source of flow record		SWOHER	CHAR	2
KUNNR	Customer Number		KUNNR	CHAR	20
BVTYP	Partner bank type		BVTYP	CHAR	8
MABER	Dunning Area		MABER	CHAR	4	*
RPARTNR	Business Partner Number		BP_PARTNR_NEW	CHAR	20
SROLEXT	Dummy function		DUMMY_3	CHAR	6
JEINBEHALT	Indicator for Withholding of Amount During Disbursement		JEINBEHALT	CHAR	2
JFIRUECK	Confirmation From FI Not Necessary		JFIRUECK	CHAR	2
MWSKZ	Tax on sales/purchases code		MWSKZ	CHAR	4	*
MWART	Tax Type		MWART	CHAR	2
DBERBIS	End of Calculation Period		DBERBIS	DATS	16
ATAGE	Number of Days		VVATAGE	NUMC	12
ABASTAGE	Number of base days in a calculation period		ABASTAGE	NUMC	12
SZBMETH	Interest Calculation Method		SZBMETH	CHAR	2
JSTOCK	Premium reserve fund-relevant indicator		VVJSTOCK	CHAR	2
SBUST	Posting Control Key		VVSBUST	NUMC	4
DTRANS	Flow data key: System date		VVDTRANS	DATS	16
TTRANS	Transaction data key: system time		VVTTRANS	TIMS	12
NTRANS	Transaction data key: Consecutive number		VVNTRANS	NUMC	8
GSBER	Business Area		GSBER	CHAR	8	*
SKOART	Condition Type (Smallest Subdivision of Condition Records)		SKOART	NUMC	8	*
SEXCLVON	Exclusive Indicator for the Start of a Calculation Period		VVSEXCLVON	NUMC	2
SULTVON	Month-End Indicator for Start of a Calculation Period		VVSULTVON	CHAR	2
SINCLBIS	Inclusive Indicator for the End of a Calculation Period		VVSINCLBIS	NUMC	2
SULTBIS	Month-End Indicator for the End of a Calculation Period		VVSULTBIS	CHAR	2
SINCL	Inclusive indicator for beginning and end of a period		VVSINCL	NUMC	2
DVERRECH	Settlement date		VVDVERRECH	DATS	16
DPKOND	Fixing Date of Percentage Rate from Condition		VVDPKOND	DATS	16
SBUCHA	Indicator for postings to accruals/deferrals accounts		VVSBUCHA	CHAR	2
SVULT	Month-End Indicator for Value Date		VVSVULT	CHAR	2
JSOFVERR	Immediate settlement		JSOFVERR	CHAR	2
SINCLVERR	Inclusive Indicator for Clearing Date		VVSINCLVER	NUMC	2
SULTVERR	Month-End Indicator for Clearing Date		VVSULTVERR	CHAR	2
SREFZITI	Refer.flow category in accrual/deferral flow records		VVSREFZITI	CHAR	8	*
STGBASIS	Base Days Method		VVSTGBASIS	CHAR	2
STGMETH	Daily Method		VVSTGMETH	NUMC	2
SBASIS	Calculation base reference		VVSBASIS	CHAR	8	*
SGTXT	Item Text		SGTXT	CHAR	100
SBERFIMA	Calculation category for cash flow calculator		SBEWFIMA	CHAR	8	*
SVORGKZ	Activity indicator for debit/credit control		VVSVORGKZ	NUMC	4
MANSP	Dunning Block		MANSP	CHAR	2	*
DGUEL_KP	Condition Item Effective From		DGUEL_KP	DATS	16
NSTUFE	Level number of condition item for recurring payments		NSTUFE	NUMC	4
DBPERIOD	Period start		VVDBPERIOD	DATS	16
SPAEXCL	Exclusive Indicator for Start Date of a Period		TFMSPAEXCL	NUMC	2
SPAULT	Month-End Indicator for Start Date of a Period		TFMSPAULT	CHAR	2
DEPERIOD	Period End		VVDEPERIOD	DATS	16
SPEINCL	Inclusive Indicator for End Date of a Period		TFMSPEINCL	NUMC	2
SPEULT	Month-End Indicator for End of a Period		TFMSPEULT	CHAR	2
SSTCKKZ	Accrued interest method		SSTCKKZ	CHAR	2
NORDER	Order Number		NORDER	NUMC	16
RKONT	Quota number		RKONT	NUMC	12
DAUSZ	Lead date for withholding amounts for disbursement		VVDAUSZ	DATS	16
SSOLIST	Calculation using actual principle (or debit)		SSOLIST	CHAR	2
RDARNEHM	Borrower/Applicant Number		RDARNEHM_NEW	CHAR	20
BKOND	Condition Item Currency Amount		BKOND	CURR	7
SBERECH	Grace Period Interest Method		SBERECH	CHAR	2
BKARZINS	Int.for days betw. redemption clear.and pmnt (FiMa-internal)		TFMBKAZINS	CURR	7
BTITALK	Imputed annuity repayment amount (FiMa internal)		TFMBTIKALK	CURR	7
RERF	Entered By		RERF	CHAR	24
DERF	First Entered On		DERF	DATS	16
TERF	Time of Creation		TERF	TIMS	12
REHER	Source of Initial Entry		REHER	CHAR	20
RBEAR	Employee ID		RBEAR	CHAR	24
DBEAR	Last Edited On		DBEAR	DATS	16
TBEAR	Last Edited At		TBEAR	TIMS	12
RBHER	Editing Source		RBHER	CHAR	20
HDN_KUNNR	Main Borrower Customer Number		HDN_KUNNR	CHAR	20	*
SZART	Payment Transaction		TB_SZART	CHAR	2
RUZBEL	Document Number of an Accounting Document		BELNR_D	CHAR	20
REBZJ	Fiscal Year of the Relevant Invoice (for Credit Memo)		REBZJ	NUMC	8
REBZG	Document No. of the Invoice to Which the Transaction Belongs		REBZG	CHAR	20
REBZZ	Line Item in the Relevant Invoice		REBZZ	NUMC	6
S_SSDREF	Reference flow category in borrower's note loan flow records		VVS_SSDREF	CHAR	8	*
PWKURS	Security price for percentage quotation		PWKURS	DEC	6
DZFEST	Interest rate fixing date		TB_DZFEST	DATS	16
XPORE	Indicator: Individual Payment?		PRQ_XPORE	CHAR	2
SPAYRQ	Generate Payment Request		TB_SPAYRQK	CHAR	2
PRKEY	Key Number for Payment Request		PRQ_KEYNO	CHAR	20	*
HBKID	Short Key for a House Bank		HBKID	CHAR	10	*
HKTID	ID for Account Details		HKTID	CHAR	10	*
VORGTYP	Activity Category (Posting Area)		VORGTYP_LO	CHAR	8
ACENV	Source in TR-LO posting area		ACENV_LO	NUMC	8
SSIGN	Direction of Flow		TB_SSIGN	CHAR	2
SPRSNG	Individual Payment		TB_SPRSNGK	CHAR	2
UZAWE	Payment method supplement		UZAWE	CHAR	4	*
SPRGRD	Determine Grouping Definition		TB_SPRGRD	CHAR	2
SCSPAY	Same Direction Necessary for Joint Payment?		TB_SCSPAY	CHAR	2
PAYGR	Grouping Field for Automatic Payments		PAYGR	CHAR	40
JEXPOZINS	Type of Compound Interest Calculation		TFM_SINTCOMP	CHAR	2
SREVALEXCL	Price gains w/o proportionate gains from deferral write-back		VVSREVALEXCL	CHAR	2
SROUND	Rounding Category		TFM_SROUND	CHAR	2
SKALIDWT	Interest Calendar		TFMSKALIDWT	CHAR	4
JVERF	Indicator whether drawings exist for the disbursement		JVERF	CHAR	2
PPAYMENT	Payment Rate		TFM_PPAYMENT	DEC	6
AMMRHYZV	Interest Settlement Frequency for Exponential Interest Calc.		TFM_AMMRHYZV	NUMC	4
LC_CAPITALS	Effect of the Flow on Capital Amounts Status		TB_LC_CAPITALS	CHAR	4
LC_DISBURSE	Effect of the Flow on the Disbursement Status		TB_LC_DISBURSE	CHAR	4
DFAELL_OLD_EXT	Old Due Date		TB_EXTENS_DFAELL_OLD	DATS	16
DDISPO_OLD_EXT	Old Payment Date		TB_EXTENS_DDISPO_OLD	DATS	16
RBO_EXT	Business Operation Number (Loans)		RBO	CHAR	30
SBEWEGRP2	Flow Record Group in Cash Flow Calculator (Incoming Payment)		TB_FLOW_REC_GRP	NUMC	12
SUSP_REASON_TYPE	Key for Overpayment Reason		TB_SUSPREASON	NUMC	6	*
BILL_NUMBER	Bill Number		TB_BILL_NUMBER	CHAR	30
BILL_DUE_DATE	Due Date for Bill		TB_BILL_DUE_DATE	DATS	16
MNDID	Unique Reference to Mandate for each Payee		SEPA_MNDID	CHAR	70
.INCLUDE				RSEPA_INFO	0
REMIT_INFO	Payment Notes Info		TB_REMIT_INFO	CHAR	280
.INCLUDE				FVD_FIMA_FIELDS_FLOWS	0
AAVGDAYS	No. of Days for Interest Calc. with Average Interest Rate		TFM_AAVGDAYS	INT4	4
PAVGINTEREST	Average Interest Rate		TFM_PAVGINTEREST	DEC	8
JAVGCAP	Use Upper Limit of Average Interest Rate		TFM_JAVGCAP	CHAR	2
PAVGCAP	Upper Limit of Average Interest Rate		TFM_PAVGCAP	DEC	8
JAVGFLOOR	Use Lower Limit of Average Interest Rate		TFM_JAVGFLOOR	CHAR	2
PAVGFLOOR	Lower Limit of Average Interest Rate		TFM_PAVGFLOOR	DEC	8
PAVGSPREAD	Average Interest Rate Spread		TFM_PAVGSPREAD	DEC	8
SROUNDAVGINTEREST	Rounding Category of Average Interest Rate		TFM_SROUNDAVGINTEREST	CHAR	2
ROUNDDECAVGINTEREST	Number of Rounding Decimal Places for Average Interest Rate		TFM_ROUNDDECAVGINTEREST	INT1	1
AAVGWEIGHT	Weighting of Interest Rate		TFM_AWEIGHT	INT4	4
AAVGWEIGHTSUM	Cumulative Weighting of Interest Rate		TFM_AWEIGHTSUM	INT4	4
JEXPOINTFACTOR	Exponential Interest Calculation with Factor		TFM_JEXPOINTFACTOR	CHAR	2
FLOWFACTOR	Flow Factor		TFM_FLOWFACTOR	D34R	16
BASEFACTOR	Base Factor		TFM_BASEFACTOR	D34R	16
SFACTORRESET	Event for Resetting Factor Calculation		TFM_SFACTORRESET	CHAR	2