SAP Table VDBEPP - Flow Data - Planned Item

Field Key Data Element Type Offset Leng Decimals Check Table Text
MANDT X MANDT CLNT 0 3 0 T000 Client
BUKRS X BUKRS CHAR 3 4 0 T001 Company Code
RANL X RANL CHAR 7 13 0 Contract Number
DTRANS X VVDTRANS DATS 20 8 0 Flow data key: System date
TTRANS X VVTTRANS TIMS 28 6 0 Transaction data key: system time
NTRANS X VVNTRANS NUMC 34 4 0 Transaction data key: Consecutive number
RERF RERF CHAR 38 12 0 Entered by
DERF DERF DATS 50 8 0 First Entered on
TERF TERF TIMS 58 6 0 Time of Initial Entry
REHER REHER CHAR 64 10 0 Source of initial entry
RBEAR RBEAR CHAR 74 12 0 Employee ID
DBEAR DBEAR DATS 86 8 0 Last Edited on
TBEAR TBEAR TIMS 94 6 0 Last Edited at
RBHER RBHER CHAR 100 10 0 Editing Source
DVORGANG DVORGANG DATS 110 8 0 Activity date
SVORGANG SVORFALL CHAR 118 4 0 Business Operation (Activity)
NVORGANG NVORGANG CHAR 122 3 0 Activity number
SBEWART SBEWART CHAR 125 4 0 TZB0A Flow Type
SREFBEW SREFBEW CHAR 129 4 0 TZB0A Reference flow type
SBEWZITI SBEWZITI CHAR 133 4 0 TZB03 Flow category
SPLANIST SPLANIST CHAR 137 1 0 Plan/actual record/record to be released indicator
SSOLHAB VVSSOLHAB CHAR 138 1 0 Debit/credit indicator
SSTORNO SSTORNO CHAR 139 1 0 Reversal indicator
SSTOGRD SSTOGRD CHAR 140 2 0 Reason for Reversal
ZUONR DZUONR CHAR 142 18 0 Assignment Number
RSTBLG STBLG CHAR 160 10 0 Reverse Document Number
SGTXT SGTXT CHAR 170 50 0 Item Text
SANLF SANLF NUMC 220 3 0 TZAF Product Category
DGUEL_KK DGUEL DATS 223 8 0 Date Condition Effective from
NLFD_ANG NLFD_ANG NUMC 231 3 0 Offer consecutive number
SSTATI SSTATI NUMC 234 2 0 TZC37 Status of data record
GSART VVSART CHAR 236 3 0 TZPA Product Type
RREFKONT RREFKONT CHAR 239 8 0 T037S Account Assignment Reference in Financial Assets Management
GSBER GSBER CHAR 247 4 0 TGSB Business Area
DORDER DORDER DATS 251 8 0 Order day
NORDER NORDER NUMC 259 8 0 Order Number
BNWHR BNWHR CURR 267 13 2 Nominal amount
SNWHR SNWHR CUKY 274 5 0 TCURC Currency of nominal amount
BBWHR BBWHR CURR 279 13 2 Amount in position currency
SBWHR SBWHR CUKY 286 5 0 TCURC Position Currency (Currency of Position Amount)
BCWHR BCWHR CURR 291 13 2 Settlement Amount
SCWHR SCWHR CUKY 298 5 0 TCURC Settlement Currency
BHWHR BHWHR CURR 303 13 2 Amount in local currency
KURS1 VVKURSF DEC 310 9 5 Exchange rate
KURS2 VVKURSF DEC 315 9 5 Exchange rate
DVALUT DVALUT DATS 320 8 0 Calculation Date
DFAELL DFAELLIG DATS 328 8 0 Due date/calculation date
DDISPO DDISPO DATS 336 8 0 Payment Date
DBESTAND DBESTAND DATS 344 8 0 Position value date
DBERVON DBERVON DATS 352 8 0 Start of Calculation Period
DBERBIS DBERBIS DATS 360 8 0 End of Calculation Period
ATAGE VVATAGE NUMC 368 6 0 Number of days
ABASTAGE ABASTAGE NUMC 374 6 0 Number of base days in a calculation period
SZBMETH SZBMETH CHAR 380 1 0 Interest Calculation Method
UMSKZ UMSKZ CHAR 381 1 0 Special G/L Indicator
KOSTL KOSTL CHAR 382 10 0 Cost Center
SSPESEN SSPESEN CHAR 392 1 0 Expenses key
RSOLL RSOLL CHAR 393 10 0 Account for debit posting
RHABEN RHABEN CHAR 403 10 0 Account for credit posting
RZKSOLL RZKSOLL CHAR 413 10 0 Debit interim account
RZKHABE RZKHABE CHAR 423 10 0 Credit interim account
SBSLSOLL BSCHL CHAR 433 2 0 TBSL Posting Key
SBSLZKSO BSCHL CHAR 435 2 0 TBSL Posting Key
SBSLZKHA BSCHL CHAR 437 2 0 TBSL Posting Key
SHSLHABEN BSCHL CHAR 439 2 0 TBSL Posting Key
RBANKK RBANKK CHAR 441 10 0 Bank account
SFDLEV FDLEV CHAR 451 2 0 T036 Planning Level
JFDUPD JFDUPD CHAR 453 1 0 Record transferred to cash management and forecast
JONLAEN JONLAEN CHAR 454 1 0 Indicator for fixing a flow record
JZINSBAS JZINSBAS CHAR 455 1 0 Flow in interest base
JZINSZPT JZINSZPT CHAR 456 1 0 Interest date
PKOND PKOND DEC 457 10 7 Percentage rate for condition items
BBASIS BBASIS CURR 463 13 2 Calculation base amount
SSORTZIT SSORTZIT CHAR 470 1 0 Sort indicator for interest/repayment schedule calculations
SWOHER SWOHER CHAR 471 1 0 Source of flow record
SSTCKKZ SSTCKKZ CHAR 472 1 0 Accrued interest method
SSTCKTG SSTCKTG CHAR 473 1 0 Accrued interest: Daily method
PEFFZINS PEFFZINS DEC 474 10 7 Effective Interest Rate
SEFFMETH SEFFMETH NUMC 480 1 0 Effective Interest Method (Financial Mathematics)
JVERF JVERF CHAR 481 1 0 Indicator whether drawings exist for the disbursement
KUNNR KUNNR CHAR 482 10 0 KNA1 Customer Number
BVTYP BVTYP CHAR 492 4 0 Partner Bank Type
ZLSCH DZLSCH CHAR 496 1 0 T042E Payment Method
MABER MABER CHAR 497 2 0 T047M Dunning Area
ZAHLS DZAHLS CHAR 499 1 0 Block Key for Payment
RPARTNR BP_PARTNR_NEW CHAR 500 10 0 Business Partner Number
SROLEXT DUMMY_3 CHAR 510 3 0 Dummy function
RKLAMMER RKLAMMER CHAR 513 13 0 Classification Number for Finance Projects
JEINBEHALT VVJEINBE CHAR 526 1 0 Indicator for withholding of amount during disbursement
SZEGEN SZEGEN NUMC 527 2 0 TD21 Generate incoming payment immediately
MWSKZ MWSKZ CHAR 529 2 0 Sales Tax Code
DTRANSREF VVDTRANS DATS 531 8 0 Flow data key: System date
TTRANSREF VVTTRANS TIMS 539 6 0 Transaction data key: system time
NTRANSREF VVNTRANS NUMC 545 4 0 Transaction data key: Consecutive number
RPNNR VVRPNNR CHAR 549 10 0 Daybook no.
HBKID HBKID CHAR 559 5 0 T012 Short Key for a House Bank
SBUST VVSBUST NUMC 564 2 0 TZB09 Posting control key
PWKURS PWKURS DEC 566 10 7 Security price for percentage quotation
DSTOCK VVDSTOCK DATS 572 8 0 Premium reserve fund date
JVORAUS VVJVORAUS CHAR 580 1 0 ID for planned record reference to an advance payment
AMMRHY AMMRHY NUMC 581 3 0 Frequency in months
SKOART SKOART NUMC 584 4 0 TZK01 Condition Type (Smallest Subdivision of Condition Records)
SEXCLVON VVSEXCLVON NUMC 588 1 0 Exclusive Indicator for the Start of a Calculation Period
SULTVON VVSULTVON CHAR 589 1 0 Month-End Indicator for Start of a Calculation Period
SINCLBIS VVSINCLBIS NUMC 590 1 0 Inclusive Indicator for the End of a Calculation Period
SULTBIS VVSULTBIS CHAR 591 1 0 Month-End Indicator for the End of a Calculation Period
SINCL VVSINCL NUMC 592 1 0 Inclusive indicator for beginning and end of a period
DVERRECH VVDVERRECH DATS 593 8 0 Settlement date
DPKOND VVDPKOND DATS 601 8 0 Determination date for percentage rate of condition items
RUMBLG UMBLG CHAR 609 10 0 Reference transfer document number
ZINKZ DZINKZ CHAR 619 2 0 Exempted from Interest Calculation
SVULT VVSVULT CHAR 621 1 0 Month-End Indicator for Value Date
JSOFVERR JSOFVERR CHAR 622 1 0 Immediate settlement
SINCLVERR VVSINCLVER NUMC 623 1 0 Inclusive Indicator for Clearing Date
SULTVERR VVSULTVERR CHAR 624 1 0 Month-End Indicator for Clearing Date
SREFZITI VVSREFZITI CHAR 625 4 0 TZB03 Refer.flow category in accrual/deferral flow records
STGBASIS VVSTGBASIS NUMC 629 1 0 Base Days Method
STGMETH VVSTGMETH NUMC 630 1 0 Daily Method
SBASIS VVSBASIS CHAR 631 4 0 TZFB Calculation base reference
SBERFIMA SBEWFIMA CHAR 635 4 0 Calculation Category for Cash Flow Calculator
SVORGKZ VVSVORGKZ NUMC 639 2 0 Activity indicator for debit/credit control
MANSP MANSP CHAR 641 1 0 T040S Dunning Block
DGUEL_KP DGUEL_KP DATS 642 8 0 Condition Item Effecitve from
NSTUFE NSTUFE NUMC 650 2 0 Level number of condition item for recurring payments
DBPERIOD VVDBPERIOD DATS 652 8 0 Period start
SPAEXCL TFMSPAEXCL NUMC 660 1 0 Exclusive Indicator for Start Date of a Period
SPAULT TFMSPAULT CHAR 661 1 0 Month-End Indicator for Start Date of a Period
DEPERIOD VVDEPERIOD DATS 662 8 0 Period End
SPEINCL TFMSPEINCL NUMC 670 1 0 Inclusive Indicator for End Date of a Period
SPEULT TFMSPEULT CHAR 671 1 0 Month-End Indicator for End of a Period
RKONT RKONT NUMC 672 6 0 Quota number
DAUSZ VVDAUSZ DATS 678 8 0 Lead date for withholding amounts for disbursement
SSOLIST SSOLIST CHAR 686 1 0 Calculation using actual principle (or debit)
RDARNEHM RDARNEHM_NEW CHAR 687 10 0 Borrower/Applicant Number
BKOND BKOND CURR 697 13 2 Condition item currency amount
RZEBEL VEBLGNR CHAR 704 10 0 Document number of waiver/write-off document
ZFBDT DDISPO DATS 714 8 0 Payment Date
DZFEST TB_DZFEST DATS 722 8 0 Interest rate fixing date
SBERECH SBERECH CHAR 730 1 0 Grace Period Interest Method
BKARZINS TFMBKAZINS CURR 731 13 2 Int.for days betw. redemption clear.and pmnt (FiMa-internal)
BTITALK TFMBTIKALK CURR 738 13 2 Imputed annuity repayment amount (FiMa internal)
HDN_KUNNR HDN_KUNNR CHAR 745 10 0 KNA1 Main Borrower Customer Number
SZART TB_SZART CHAR 755 1 0 Payment transaction
RUZBEL BELNR_D CHAR 756 10 0 Accounting Document Number
REBZJ REBZJ NUMC 766 4 0 Fiscal Year of the Relevant Invoice (for Credit Memo)
REBZG REBZG CHAR 770 10 0 Number of the Invoice the Transaction Belongs to
REBZZ REBZZ NUMC 780 3 0 Line Item in the Relevant Invoice
S_SSDREF VVS_SSDREF CHAR 783 4 0 TZB03 Reference flow category in borrower's note loan flow records
SAEND TFM_SAEND NUMC 787 1 0 Change Indicator for FiMa Flow Records
XPORE PRQ_XPORE CHAR 788 1 0 Indicator: Individual Payment?
SPAYRQ TB_SPAYRQK CHAR 789 1 0 Generate payment request
PRKEY PRQ_KEYNO CHAR 790 10 0 Key Number for Payment Request
HKTID HKTID CHAR 800 5 0 T012K ID for Account Details
VORGTYP VORGTYP_LO CHAR 805 4 0 Activity Category (Posting Area)
ACENV ACENV_LO NUMC 809 4 0 Source in TR-LO posting area
SSIGN TB_SSIGN CHAR 813 1 0 Direction of flow
SPRSNG TB_SPRSNGK CHAR 814 1 0 Individual payment
UZAWE UZAWE CHAR 815 2 0 Payment Method Supplement
SPRGRD TB_SPRGRD CHAR 817 1 0 Determine grouping definition
SCSPAY TB_SCSPAY CHAR 818 1 0 Same direction necessary for joint payment?
ZWELS DZWELS CHAR 819 10 0 List of the Payment Methods to be Considered
PAYGR PAYGR CHAR 829 20 0 Grouping Field for Automatic Payments
JEXPOZINS TB_JZINSRE CHAR 849 1 0 Exponential Interest Calculation
SREVALEXCL VVSREVALEXCL CHAR 850 1 0 Price gains w/o proportionate gains from deferral write-back
RBO RBO CHAR 851 15 0 Business Operation Number (Loans)
SROUND TFM_SROUND CHAR 866 1 0 Rounding Category
SKALIDWT TFMSKALIDWT CHAR 867 2 0 TFACD Interest Calendar
PPAYMENT TFM_PPAYMENT DEC 869 11 7 Payment Rate
AMMRHYZV TFM_AMMRHYZV NUMC 875 2 0 Interest Settlement Frequency for Exponential Interest Calc.
LC_CAPITALS TB_LC_CAPITALS CHAR 877 2 0 Effect of the Flow on Capital Amounts Status
LC_DISBURSE TB_LC_DISBURSE CHAR 879 2 0 Effect of the Flow on the Disbursement Status
OP_APPLICATION TB_OPAPPL NUMC 881 2 0 Open Item Tool: Application Key
OP_RBO TB_OP_RBO CHAR 883 15 0 OI Tool: Locking Business Operation
DFAELL_OLD_EXT TB_EXTENS_DFAELL_OLD DATS 898 8 0 Old Due Date
DDISPO_OLD_EXT TB_EXTENS_DDISPO_OLD DATS 906 8 0 Old Payment Date
RBO_EXT RBO CHAR 914 15 0 Business Operation Number (Loans)
SBEWEGRP2 TB_FLOW_REC_GRP NUMC 929 6 0 Flow Record Group in Cash Flow Calculator (Incoming Payment)
SUSP_REASON_TYPE TB_SUSPREASON NUMC 935 3 0 Key for Overpayment Reason
MNDID SEPA_MNDID CHAR 938 35 0 SEPA Mandate: Unique Referene to Mandate per Vendor
REMIT_INFO TB_REMIT_INFO CHAR 973 140 0 SEPA Payment Notes Information
BROUNDUNIT TB_BROUNDUNIT_A DEC 1113 13 7 Rounding Unit for Amounts

969396Convert table VDBEPI to Oracle Index Organized Table (IOT)
990035Additional information: Transferring posted data
1153029Parallel debit position run/update for planned loan records
1490576BUC: Enhancing FVD_LOAN_POST
1130933POS: Customer-specific checks in debit position
1051095Release and Unicode systems
875596BUC: Error LZBKZ/LANDL in the payment request
102007Customizing : Update Settings