VDBEPI_SHADOW SAP (Shadow Table for VDBEPI (Restrictions)) Table details
Dictionary Type: Table
Description: Shadow Table for VDBEPI (Restrictions)
Description: Shadow Table for VDBEPI (Restrictions)
ABAP Code to SELECT data from VDBEPI_SHADOW
Related tables to VDBEPI_SHADOW
Access table VDBEPI_SHADOW
Related tables to VDBEPI_SHADOW
Access table VDBEPI_SHADOW
Table field list including key, data, relationships and ABAP select examples
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.
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. .
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
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 |
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 tableDATA: 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 asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects