SAP TABLES | Financial Services | Loans Management(FS-CML) SAP FS

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







VDBEPI_SHADOW is a standard SAP Table which is used to store Shadow Table for VDBEPI (Restrictions) data and is available within R/3 SAP systems depending on the version and release level.

Below is the standard documentation available and a few details of the fields which make up this Table. You can view further information about SAP VDBEPI_SHADOW Table and the data within it using relevant transactions such as SE11, SE80 or SE16. Also check out the Comments section below to view or add related contributions and example screen shots.

Delivery Class: A - Application table containing master and transaction data

Display/Maintenance via SM30: Yes but with Restrictions

Enhancement category i: Can be enhanced (character-type or numeric)
See here for more information about this and other SAP enhancement categories


SAP VDBEPI_SHADOW Table fields within data Dictionary





FieldData ElementData Typelength (Decimals)Check tableDescriptionConversion Routine
MANDTMANDTCLNT3
*
Client
.INCLUDEVDBEPI_KEY Flow Data (Key Fields VDBEPI)
BUKRSBUKRSCHAR4
*
Company Code
RBELKPFDRBELKPFDCHAR10 Document Number of Document Header (Loan)ALPHA
RPOSNRNVORGANGCHAR3 Activity number
.INCLUDEVDBEPI_FIELDS Include for VDBEPI
SBEWARTSBEWARTCHAR4
*
Flow Type
SREFBEWSREFBEWCHAR4
*
Reference flow type
SBEWZITISBEWZITICHAR4
*
Flow category
BNWHRBNWHRCURR13(2) Nominal amount
SNWHRSNWHRCUKY5
*
Currency of nominal amount
BBWHRBBWHRCURR13(2) Amount in position currency
SBWHRSBWHRCUKY5
*
Position Currency (Currency of Position Amount)
BCWHRBCWHRCURR13(2) Settlement Amount
SCWHRSCWHRCUKY5
*
Settlement Currency
BHWHRBHWHRCURR13(2) Amount in local currency
PKKURSPKKURSDEC10(7) Purchase Price of Borrower's Note
PRUCKPRUCKDEC10(7) Repayment rate in percent
KURS1VVKURSFDEC9(5) Exchange rateEXCRT
KURS2VVKURSFDEC9(5) Exchange rateEXCRT
DVALUTDVALUTDATS8 Calculation Date
DFAELLDFAELLDATS8 Due date
DDISPODDISPODATS8 Payment Date
DBESTANDDBESTANDDATS8 Position value date
DBERVONDBERVONDATS8 Start of Calculation Period
UMSKZUMSKZCHAR1
*
Special G/L Indicator
KOSTLKOSTLCHAR10
*
Cost CenterALPHA
SSPESENSSPESENCHAR1 Expenses key
SSOLHABVVSSOLHABCHAR1 Debit/credit indicator
RSOLLRSOLLCHAR10
*
Account for debit postingALPHA
RHABENRHABENCHAR10
*
Account for credit postingALPHA
RZKSOLLRZKSOLLCHAR10
*
Debit interim accountALPHA
RZKHABERZKHABECHAR10
*
Credit interim accountALPHA
SBSLSOLLBSCHLCHAR2
*
Posting Key
SBSLZKSOBSCHLCHAR2
*
Posting Key
SBSLZKHABSCHLCHAR2
*
Posting Key
SHSLHABENBSCHLCHAR2
*
Posting Key
BUCHTXTSGTXTCHAR50 Item Text
RBANKKRBANKKCHAR10
*
Bank accountALPHA


SFDLEVFDLEVCHAR2
*
Planning level
JFDUPDJFDUPDCHAR1 Record transferred to cash management and forecast
JONLAENJONLAENCHAR1 Indicator for fixing a flow record
JZINSBASJZINSBASCHAR1 Flow in interest base
JZINSZPTJZINSZPTCHAR1 Interest date
PKONDPKONDDEC10(7) Percentage rate for condition items
BBASISBBASISCURR13(2) Calculation base amount
SSORTZITSSORTZITCHAR1 Sort indicator for interest/repayment schedule calculations
SWOHERSWOHERCHAR1 Source of flow record
KUNNRKUNNRCHAR10
*
Customer NumberALPHA
BVTYPBVTYPCHAR4 Partner Bank Type
ZLSCHDZLSCHCHAR1
*
Payment Method
MABERMABERCHAR2
*
Dunning Area
ZAHLSDZAHLSCHAR1
*
Block Key for Payment
RPARTNRBP_PARTNR_NEWCHAR10
*
Business Partner NumberALPHA
SROLEXTDUMMY_3CHAR3 Dummy function
JEINBEHALTJEINBEHALTCHAR1 Indicator for Withholding of Amount During Disbursement
JFIRUECKJFIRUECKCHAR1 Confirmation From FI Not Necessary
MWSKZMWSKZCHAR2
*
Tax on sales/purchases code
MWARTMWARTCHAR1 Tax Type
DBERBISDBERBISDATS8 End of Calculation Period
ATAGEVVATAGENUMC6 Number of days
ABASTAGEABASTAGENUMC6 Number of base days in a calculation period
SZBMETHSZBMETHCHAR1 Interest Calculation Method
JSTOCKVVJSTOCKCHAR1 Premium reserve fund-relevant indicator
SBUSTVVSBUSTNUMC2 Posting control key
DTRANSVVDTRANSDATS8 Flow data key: System date
TTRANSVVTTRANSTIMS6 Transaction data key: system time
NTRANSVVNTRANSNUMC4 Transaction data key: Consecutive number
GSBERGSBERCHAR4
*
Business Area
SKOARTSKOARTNUMC4
*
Condition Type (Smallest Subdivision of Condition Records)
SEXCLVONVVSEXCLVONNUMC1 Exclusive Indicator for the Start of a Calculation Period
SULTVONVVSULTVONCHAR1 Month-End Indicator for Start of a Calculation Period
SINCLBISVVSINCLBISNUMC1 Inclusive Indicator for the End of a Calculation Period
SULTBISVVSULTBISCHAR1 Month-End Indicator for the End of a Calculation Period
SINCLVVSINCLNUMC1 Inclusive indicator for beginning and end of a period
DVERRECHVVDVERRECHDATS8 Settlement date
DPKONDVVDPKONDDATS8 Determination date for percentage rate of condition items
SBUCHAVVSBUCHACHAR1 Indicator for postings to accruals/deferrals accounts


ZINKZDZINKZCHAR2 Exempted from interest calculation
SVULTVVSVULTCHAR1 Month-End Indicator for Value Date
JSOFVERRJSOFVERRCHAR1 Immediate settlement
SINCLVERRVVSINCLVERNUMC1 Inclusive Indicator for Clearing Date
SULTVERRVVSULTVERRCHAR1 Month-End Indicator for Clearing Date
SREFZITIVVSREFZITICHAR4
*
Refer.flow category in accrual/deferral flow records
STGBASISVVSTGBASISNUMC1 Base Days Method
STGMETHVVSTGMETHNUMC1 Daily Method
SBASISVVSBASISCHAR4
*
Calculation base reference
SGTXTSGTXTCHAR50 Item Text
SBERFIMASBEWFIMACHAR4
*
Calculation category for cash flow calculator
SVORGKZVVSVORGKZNUMC2 Activity indicator for debit/credit control
MANSPMANSPCHAR1
*
Dunning block
DGUEL_KPDGUEL_KPDATS8 Condition Item Valid From
NSTUFENSTUFENUMC2 Level number of condition item for recurring payments
DBPERIODVVDBPERIODDATS8 Period start
SPAEXCLTFMSPAEXCLNUMC1 Exclusive Indicator for Start Date of a Period
SPAULTTFMSPAULTCHAR1 Month-End Indicator for Start Date of a Period
DEPERIODVVDEPERIODDATS8 Period End
SPEINCLTFMSPEINCLNUMC1 Inclusive Indicator for End Date of a Period
SPEULTTFMSPEULTCHAR1 Month-End Indicator for End of a Period
SSTCKKZSSTCKKZCHAR1 Accrued interest method
NORDERNORDERNUMC8 Order Number
RKONTRKONTNUMC6 Quota number
DAUSZVVDAUSZDATS8 Lead date for withholding amounts for disbursement
SSOLISTSSOLISTCHAR1 Calculation using actual principle (or debit)
RDARNEHMRDARNEHM_NEWCHAR10
*
Borrower/Applicant NumberALPHA
BKONDBKONDCURR13(2) Condition item currency amount
SBERECHSBERECHCHAR1 Grace Period Interest Method
BKARZINSTFMBKAZINSCURR13(2) Int.for days betw. redemption clear.and pmnt (FiMa-internal)
BTITALKTFMBTIKALKCURR13(2) Imputed annuity repayment amount (FiMa internal)
RERFRERFCHAR12 Entered by
DERFDERFDATS8 First Entered on
TERFTERFTIMS6 Time of Initial Entry
REHERREHERCHAR10 Source of initial entry
RBEARRBEARCHAR12 Employee ID
DBEARDBEARDATS8 Last Edited on
TBEARTBEARTIMS6 Last Edited at
RBHERRBHERCHAR10 Editing Source

HDN_KUNNRHDN_KUNNRCHAR10
*
Main Borrower Customer NumberALPHA
SZARTTB_SZARTCHAR1 Payment transaction
RUZBELBELNR_DCHAR10 Accounting Document NumberALPHA
REBZJREBZJNUMC4 Fiscal Year of the Relevant Invoice (for Credit Memo)GJAHR
REBZGREBZGCHAR10 Number of the Invoice the Transaction Belongs toALPHA
REBZZREBZZNUMC3 Line Item in the Relevant Invoice
S_SSDREFVVS_SSDREFCHAR4
*
Reference flow category in borrower's note loan flow records
PWKURSPWKURSDEC10(7) Security price for percentage quotation
DZFESTTB_DZFESTDATS8 Interest rate fixing date
XPOREPRQ_XPORECHAR1 Indicator: Individual Payment?
SPAYRQTB_SPAYRQKCHAR1 Generate payment request
PRKEYPRQ_KEYNOCHAR10
*
Key Number for Payment RequestALPHA
HBKIDHBKIDCHAR5
*
Short Key for a House Bank
HKTIDHKTIDCHAR5
*
ID for account details
VORGTYPVORGTYP_LOCHAR4 Activity Category (Posting Area)
ACENVACENV_LONUMC4 Source in TR-LO posting area
SSIGNTB_SSIGNCHAR1 Direction of flow
SPRSNGTB_SPRSNGKCHAR1 Individual payment
UZAWEUZAWECHAR2
*
Payment Method Supplement
SPRGRDTB_SPRGRDCHAR1 Determine grouping definition
SCSPAYTB_SCSPAYCHAR1 Same direction necessary for joint payment?
PAYGRPAYGRCHAR20 Grouping Field for Automatic Payments
JEXPOZINSTB_JZINSRECHAR1 Exponential Interest Calculation
SREVALEXCLVVSREVALEXCLCHAR1 Price gains w/o proportionate gains from deferral write-back
SROUNDTFM_SROUNDCHAR1 Rounding Category
SKALIDWTTFMSKALIDWTCHAR2
*
Interest Calendar
JVERFJVERFCHAR1 Indicator whether drawings exist for the disbursement
PPAYMENTTFM_PPAYMENTDEC11(7) Payment Rate
AMMRHYZVTFM_AMMRHYZVNUMC2 Interest Settlement Frequency for Exponential Interest Calc.
LC_CAPITALSTB_LC_CAPITALSCHAR2 Effect of the Flow on Capital Amounts Status
LC_DISBURSETB_LC_DISBURSECHAR2 Effect of the Flow on the Disbursement Status
DFAELL_OLD_EXTTB_EXTENS_DFAELL_OLDDATS8 Old Due Date
DDISPO_OLD_EXTTB_EXTENS_DDISPO_OLDDATS8 Old Payment Date
RBO_EXTRBOCHAR15 Business Operation Number (Loans)
SBEWEGRP2TB_FLOW_REC_GRPNUMC6 Flow Record Group in Cash Flow Calculator (Incoming Payment)
SUSP_REASON_TYPETB_SUSPREASONNUMC3
*
Key for Overpayment Reason
BILL_NUMBERTB_BILL_NUMBERCHAR15 Bill NumberALPHA
BILL_DUE_DATETB_BILL_DUE_DATEDATS8 Due Date for Bill
MNDIDSEPA_MNDIDCHAR35 Unique Referene to Mandate per Payment Recipient
.INCLUDERSEPA_INFO Payment Notes Info
REMIT_INFOTB_REMIT_INFOCHAR140 Payment Notes Info



Key field
Non-key field