VDBEPI - Posted line items for document header
Posted line items for document header information is stored in SAP table VDBEPI.
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".
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
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
---|---|---|---|---|---|---|
MANDT | Client | X | MANDT | CLNT | 6 | T000 |
BUKRS | Company Code | X | BUKRS | CHAR | 8 | T001 |
RBELKPFD | Document Number of Document Header (Loan) | X | RBELKPFD | CHAR | 20 | VDBEKI |
RPOSNR | Activity number | X | NVORGANG | CHAR | 6 | |
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 | SKA1 | |
RHABEN | Account for credit posting | RHABEN | CHAR | 20 | SKA1 | |
RZKSOLL | Debit interim account | RZKSOLL | CHAR | 20 | SKA1 | |
RZKHABE | Credit interim account | RZKHABE | CHAR | 20 | SKA1 | |
SBSLSOLL | Posting Key | BSCHL | CHAR | 4 | TBSL | |
SBSLZKSO | Posting Key | BSCHL | CHAR | 4 | TBSL | |
SBSLZKHA | Posting Key | BSCHL | CHAR | 4 | TBSL | |
SHSLHABEN | Posting Key | BSCHL | CHAR | 4 | TBSL | |
BUCHTXT | Item Text | SGTXT | CHAR | 100 | ||
RBANKK | Bank account | RBANKK | CHAR | 20 | SKB1 | |
SFDLEV | Planning Level | FDLEV | CHAR | 4 | T036 | |
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 | KNA1 | |
BVTYP | Partner bank type | BVTYP | CHAR | 8 | ||
MABER | Dunning Area | MABER | CHAR | 4 | T047M | |
RPARTNR | Business Partner Number | BP_PARTNR_NEW | CHAR | 20 | BUT000 | |
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 | TZB09 | |
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 | TGSB | |
SKOART | Condition Type (Smallest Subdivision of Condition Records) | SKOART | NUMC | 8 | TZK01 | |
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 | AT40 | |
SVORGKZ | Activity indicator for debit/credit control | VVSVORGKZ | NUMC | 4 | ||
MANSP | Dunning Block | MANSP | CHAR | 2 | T040S | |
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 | T012 | |
HKTID | ID for Account Details | HKTID | CHAR | 10 | T012K | |
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 | T042F | |
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 | ||
SBEWEGRP | Flow record group in cash flow calculator | SBEWEGRP | NUMC | 8 | ||
.INCLUDE | RSEPA_INFO | 0 | ||||
REMIT_INFO | Payment Notes Info | TB_REMIT_INFO | CHAR | 280 | ||
.INCLUDE | FVD_DIP | 0 | ||||
.INCLUDE | FVD_DIP_KEY | 0 | ||||
DIP_KUKEY | DIP Short Key | FVD_DIP_KUKEY | NUMC | 16 | FEBEP | |
DIP_ESNUM | DIP Line Item Number | FVD_DIP_ESNUM | NUMC | 10 | FEBEP | |
.INCLUDE | FVD_DIP_DATA | 0 | ||||
DIP_ID | ID (Differentiated Incominmg Payment) | TB_DIP_ID | CHAR | 8 | VDDIP_ID | |
DIP_DATE | Date (Differentiated Incoming Payment) | TB_DIP_DATE | DATS | 16 | ||
.INCLUDE | FVD_CLI | 0 | ||||
FLG_IP_CLI_NOTICE | Payment created by CLI notice | TB_FLG_IP_CLI_NOTICE | CHAR | 2 | ||
.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 | ||
.INCLU--AP | FVD_CUST_ADDFLOWS_VDBEPI | 0 | ||||
CA_DTRANS | Flow data key: System date | VVDTRANS | DATS | 16 | ||
CA_TTRANS | Transaction data key: system time | VVTTRANS | TIMS | 12 | ||
CA_NTRANS | Transaction data key: Consecutive number | VVNTRANS | NUMC | 8 | ||
CA_FLG_ORG | Flow is orginal flow for customer specific dependent flow(s) | TB_FLG_CUST_ORG | CHAR | 2 | ||
.INCLU--AP | FVD_PLI_VDBEPI | 0 | ||||
MAIN_TRANS | Main Transaction for Line Item (G/L item) | FVD_HVORG_KK | CHAR | 8 | ||
SUB_TRANS | Subtransaction for Line Item (G/L item) | FVD_TVORG_KK | CHAR | 8 | ||
BP_MAIN_TRANS | Main Transaction for Line Item (BP open item) | FVD_HVORG_KK_BP | CHAR | 8 | ||
BP_SUB_TRANS | Subtransaction for Line Item (BP open item) | FVD_TVORG_KK_BP | CHAR | 8 | ||
.INCLU--AP | FVD_VDBEPI_CUST | 0 | ||||
CUST_EXT1 | Data element 1 for customer enhancements (VDBEPI) | TB_CUST_EXT1 | CHAR | 60 | ||
CUST_EXT2 | Data element 2 for customer enhancements (VDBEPI) | TB_CUST_EXT2 | CHAR | 60 | ||
CUST_EXT3 | Data element 3 for customer enhancements (VDBEPI) | TB_CUST_EXT3 | CHAR | 60 | ||
.INCLU--AP | RAVDBEPI_LOC | 0 | ||||
BROUNDUNIT | Rounding Unit for Amounts | TB_BROUNDUNIT_A | DEC | 7 |