VDBEPI

Posted line items for document header | #header | Component: Loans Management

🔑 Keys (4)
💰 Amounts (8)
∑ Quantities
📅 Dates (25)
☰ Categorical (51)
Other (74)
🔗 Relations (28)

Column Name	Description
MANDT FK	Client
BUKRS FK	Company Code
RBELKPFD FK	Document Number of Document Header (Loan)
RPOSNR	Activity number

Column Name	Description
💲 Currency of nominal amount (SNWHR):
BNWHR	Nominal amount
BBASIS	Calculation Base Amount
BKOND	Condition Item Currency Amount
BKARZINS	Int.for days betw. redemption clear.and pmnt (FiMa-internal)
BTITALK	Imputed annuity repayment amount (FiMa internal)
💲 Position Currency (Currency of Position Amount) (SBWHR):
BBWHR	Amount in position currency
💲 Settlement Currency (SCWHR):
BCWHR	Settlement Amount
💲 Currency Key (T001.WAERS):
BHWHR	Amount in local currency

Column Name	Description

Column Name	Description
DVALUT	Calculation Date
DFAELL	Due date
DDISPO	Payment Date
DBESTAND	Position value date
DBERVON	Start of Calculation Period
DBERBIS	End of Calculation Period
DTRANS	Flow data key: System date
TTRANS	Transaction data key: system time
DVERRECH	Settlement date
DPKOND	Fixing Date of Percentage Rate from Condition
DGUEL_KP	Condition Item Effective From
DBPERIOD	Period start
DEPERIOD	Period End
DAUSZ	Lead date for withholding amounts for disbursement
DERF	First Entered On
TERF	Time of Creation
DBEAR	Last Edited On
TBEAR	Last Edited At
DZFEST	Interest rate fixing date
DFAELL_OLD_EXT	Old Due Date
DDISPO_OLD_EXT	Old Payment Date
BILL_DUE_DATE	Due Date for Bill
DIP_DATE	Date (Differentiated Incoming Payment)
CA_DTRANS	Flow data key: System date
CA_TTRANS	Transaction data key: system time

Column Name	Description
SSPESEN	Expenses key	Show values
SSOLHAB	Debit/credit indicator	Show values
JFDUPD	Record transferred to cash management and forecast	Show values
JONLAEN	Indicator for fixing a flow record	Show values
JZINSBAS	Flow in interest base	Show values
JZINSZPT	Interest date	Show values
JEINBEHALT	Indicator for Withholding of Amount During Disbursement	Show values
JFIRUECK	Confirmation From FI Not Necessary	Show values
MWART	Tax Type	Show values
SZBMETH	Interest Calculation Method	Show values
JSTOCK	Premium reserve fund-relevant indicator	Show values
SEXCLVON	Exclusive Indicator for the Start of a Calculation Period	Show values
SULTVON	Month-End Indicator for Start of a Calculation Period	Show values
SINCLBIS	Inclusive Indicator for the End of a Calculation Period	Show values
SULTBIS	Month-End Indicator for the End of a Calculation Period	Show values
SINCL	Inclusive indicator for beginning and end of a period	Show values
ZINKZ	Exempted from Interest Calculation	Show values
SVULT	Month-End Indicator for Value Date	Show values
JSOFVERR	Immediate settlement	Show values
SINCLVERR	Inclusive Indicator for Clearing Date	Show values
SULTVERR	Month-End Indicator for Clearing Date	Show values
STGBASIS	Base Days Method	Show values
STGMETH	Daily Method	Show values
SVORGKZ	Activity indicator for debit/credit control	Show values
SPAEXCL	Exclusive Indicator for Start Date of a Period	Show values
SPAULT	Month-End Indicator for Start Date of a Period	Show values
SPEINCL	Inclusive Indicator for End Date of a Period	Show values
SPEULT	Month-End Indicator for End of a Period	Show values
SSTCKKZ	Accrued interest method	Show values
SBERECH	Grace Period Interest Method	Show values
SZART	Payment Transaction	Show values
XPORE	Indicator: Individual Payment?	Show values
SPAYRQ	Generate Payment Request	Show values
VORGTYP	Activity Category (Posting Area)	Show values
ACENV	Source in TR-LO posting area	Show values
SSIGN	Direction of Flow	Show values
SPRSNG	Individual Payment	Show values
SPRGRD	Determine Grouping Definition	Show values
SCSPAY	Same Direction Necessary for Joint Payment?	Show values
JEXPOZINS	Type of Compound Interest Calculation	Show values
SREVALEXCL	Price gains w/o proportionate gains from deferral write-back	Show values
SROUND	Rounding Category	Show values
JVERF	Indicator whether drawings exist for the disbursement	Show values
AMMRHYZV	Interest Settlement Frequency for Exponential Interest Calc.	Show values
FLG_IP_CLI_NOTICE	Payment created by CLI notice	Show values
JAVGCAP	Use Upper Limit of Average Interest Rate	Show values
JAVGFLOOR	Use Lower Limit of Average Interest Rate	Show values
SROUNDAVGINTEREST	Rounding Category of Average Interest Rate	Show values
JEXPOINTFACTOR	Exponential Interest Calculation with Factor	Show values
SFACTORRESET	Event for Resetting Factor Calculation	Show values
CA_FLG_ORG	Flow is orginal flow for customer specific dependent flow(s)	Show values

Column Name	Description	Domain name
SBEWART	Flow Type	SBEWART
SREFBEW	Reference flow type	SBEWART
SBEWZITI	Flow category	SBEWZITI
PKKURS	Purchase Price of Borrower's Note	PWKURS
PRUCK	Repayment rate in percent	DEC3_7
KURS1	Exchange rate	KURSF
KURS2	Exchange rate	KURSF
UMSKZ	Special G/L Indicator	UMSKZ
KOSTL	Cost Center	KOSTL
BUCHTXT	Item Text	TEXT50
PKOND	Percentage rate for condition items	DECV3_7
SSORTZIT	Sort indicator for interest/repayment schedule calculations	CHAR1
SWOHER	Source of flow record	CHAR1
BVTYP	Partner bank type	BVTYP
ZLSCH	Payment Method	ZLSCH
SROLEXT	Dummy function	CHAR3
MWSKZ	Tax on sales/purchases code	MWSKZ
ATAGE	Number of Days	INT6
ABASTAGE	Number of base days in a calculation period	INT6
NTRANS	Transaction data key: Consecutive number	NUMC4
SBUCHA	Indicator for postings to accruals/deferrals accounts	CHAR1
SREFZITI	Refer.flow category in accrual/deferral flow records	SBEWZITI
SBASIS	Calculation base reference	VVSBASIS
SGTXT	Item Text	TEXT50
NSTUFE	Level number of condition item for recurring payments	NUMC2
NORDER	Order Number	NUM8
RKONT	Quota number	RKONT
SSOLIST	Calculation using actual principle (or debit)	CHAR1
RDARNEHM	Borrower/Applicant Number	BU_PARTNER
RERF	Entered By	SYCHAR12
REHER	Source of Initial Entry	CHAR10
RBEAR	Employee ID	SYCHAR12
RBHER	Editing Source	CHAR10
HDN_KUNNR	Main Borrower Customer Number	KUNNR
RUZBEL	Document Number of an Accounting Document	BELNR
REBZJ	Fiscal Year of the Relevant Invoice (for Credit Memo)	GJAHR
REBZG	Document No. of the Invoice to Which the Transaction Belongs	BELNR
REBZZ	Line Item in the Relevant Invoice	BUZEI
S_SSDREF	Reference flow category in borrower's note loan flow records	SBEWZITI
PWKURS	Security price for percentage quotation	PWKURS
PRKEY	Key Number for Payment Request	PRQ_KEYNO
ZWELS	List of Respected Payment Methods	ZWELS
PAYGR	Grouping Field for Automatic Payments	CHAR20
SKALIDWT	Interest Calendar	WFCID
PPAYMENT	Payment Rate	TFM_PPAYMENT
LC_CAPITALS	Effect of the Flow on Capital Amounts Status	T_LC_CASH_FLOW
LC_DISBURSE	Effect of the Flow on the Disbursement Status	T_LC_CASH_FLOW
RBO_EXT	Business Operation Number (Loans)	RBO
SBEWEGRP2	Flow Record Group in Cash Flow Calculator (Incoming Payment)	SBEWEGRP2
SUSP_REASON_TYPE	Key for Overpayment Reason	T_SUSPREASON
BILL_NUMBER	Bill Number	T_BILL_NUMBER
MNDID	Unique Reference to Mandate for each Payee	ID035
SBEWEGRP	Flow record group in cash flow calculator	SBEWEGRP
REMIT_INFO	Payment Notes Info	T_REMIT_INFO_LC
AAVGDAYS	No. of Days for Interest Calc. with Average Interest Rate	INT4
PAVGINTEREST	Average Interest Rate	DECV5_10
PAVGCAP	Upper Limit of Average Interest Rate	DECV5_10
PAVGFLOOR	Lower Limit of Average Interest Rate	DECV5_10
PAVGSPREAD	Average Interest Rate Spread	DECV5_10
ROUNDDECAVGINTEREST	Number of Rounding Decimal Places for Average Interest Rate	TFM_ROUNDDECIMALS
AAVGWEIGHT	Weighting of Interest Rate	INT4
AAVGWEIGHTSUM	Cumulative Weighting of Interest Rate	INT4
FLOWFACTOR	Flow Factor	TFM_FACTOR
BASEFACTOR	Base Factor	TFM_FACTOR
PNON_CUMULATIVE_RATE	Non Cumulative Rate	DECV5_10
CA_NTRANS	Transaction data key: Consecutive number	NUMC4
MAIN_TRANS	Main Transaction for Line Item (G/L item)
SUB_TRANS	Subtransaction for Line Item (G/L item)
BP_MAIN_TRANS	Main Transaction for Line Item (BP open item)
BP_SUB_TRANS	Subtransaction for Line Item (BP open item)
CUST_EXT1	Data element 1 for customer enhancements (VDBEPI)	TB_CUST_EXT1_DOM
CUST_EXT2	Data element 2 for customer enhancements (VDBEPI)	TB_CUST_EXT2_DOM
CUST_EXT3	Data element 3 for customer enhancements (VDBEPI)	TB_CUST_EXT3_DOM
BROUNDUNIT	Rounding Unit for Amounts	TFMSRUNIT

Master Data Relations	Join Conditions
Company Code	`VDBEPI.MANDT == T001.MANDT` `VDBEPI.BUKRS == T001.BUKRS`
ID (Differentiated Incominmg Payment) ID (Differentiated Incominmg Payment) Client	`VDBEPI.DIP_ID == VDDIP_ID.DIP_ID` `VDBEPI.MANDT == VDDIP_ID.MANDT`
Business Area	`VDBEPI.MANDT == TGSB.MANDT` `VDBEPI.GSBER == TGSB.GSBER`
Short Key for a House Bank Short Key for a House Bank Company Code	`VDBEPI.MANDT == T012.MANDT` `VDBEPI.HBKID == T012.HBKID` `VDBEPI.BUKRS == T012.BUKRS`
ID for Account Details Company Code ID for Account Details Client Short Key for a House Bank	`VDBEPI.BUKRS == T012K.BUKRS` `VDBEPI.HKTID == T012K.HKTID` `VDBEPI.MANDT == T012K.MANDT` `VDBEPI.HBKID == T012K.HBKID`
Customer Number is Customer Account Number Here	`VDBEPI.MANDT == KNA1.MANDT` `VDBEPI.KUNNR == KNA1.KUNNR`
Dunning Area Dunning Area Company Code	`VDBEPI.MANDT == T047M.MANDT` `VDBEPI.MABER == T047M.MABER` `VDBEPI.BUKRS == T047M.BUKRS`
Client	`VDBEPI.MANDT == T000.MANDT`
Dunning Block	`VDBEPI.MANDT == T040S.MANDT` `VDBEPI.MANSP == T040S.MANSP`
Bank Account Company Code Client Bank account	`VDBEPI.BUKRS == SKB1.BUKRS` `VDBEPI.MANDT == SKB1.MANDT` `VDBEPI.RBANKK == SKB1.SAKNR`
Account Credit Posting ? Client Account for credit posting	`VDBEPI.[column in domain "KTOPL"] == SKA1.KTOPL` `VDBEPI.MANDT == SKA1.MANDT` `VDBEPI.RHABEN == SKA1.SAKNR`
Business Partner Number Business Partner Number Client	`VDBEPI.RPARTNR == BUT000.PARTNER` `VDBEPI.MANDT == BUT000.CLIENT`
Account Debit Posting ? Client Account for debit posting	`VDBEPI.[column in domain "KTOPL"] == SKA1.KTOPL` `VDBEPI.MANDT == SKA1.MANDT` `VDBEPI.RSOLL == SKA1.SAKNR`
Credit Interim Account ? Client Credit interim account	`VDBEPI.[column in domain "KTOPL"] == SKA1.KTOPL` `VDBEPI.MANDT == SKA1.MANDT` `VDBEPI.RZKHABE == SKA1.SAKNR`
Debit Interim Account ? Client Debit interim account	`VDBEPI.[column in domain "KTOPL"] == SKA1.KTOPL` `VDBEPI.MANDT == SKA1.MANDT` `VDBEPI.RZKSOLL == SKA1.SAKNR`
FiMa Calculation Category	`VDBEPI.SBERFIMA == AT40.SBERFIMA`
Debit Posting Key	`VDBEPI.MANDT == TBSL.MANDT` `VDBEPI.SBSLSOLL == TBSL.BSCHL`
Posting Key Interim Account Credit	`VDBEPI.MANDT == TBSL.MANDT` `VDBEPI.SBSLZKHA == TBSL.BSCHL`
Posting Key Interim Account Debit	`VDBEPI.MANDT == TBSL.MANDT` `VDBEPI.SBSLZKSO == TBSL.BSCHL`
Posting Control Key ? Posting Control Key	`VDBEPI.[column in domain "RANTYP"] == TZB09.RANTYP` `VDBEPI.SBUST == TZB09.SBUST`
Planning Level	`VDBEPI.MANDT == T036.MANDT` `VDBEPI.SFDLEV == T036.EBENE`
Credit Posting Key	`VDBEPI.MANDT == TBSL.MANDT` `VDBEPI.SHSLHABEN == TBSL.BSCHL`
Condition Type Condition Type (Smallest Subdivision of Condition Records) ?	`VDBEPI.MANDT == TZK01.MANDT` `VDBEPI.SKOART == TZK01.SKOART` `VDBEPI.[column in domain "RANTYP"] == TZK01.RANTYP`
Payment method supplement	`VDBEPI.MANDT == T042F.MANDT` `VDBEPI.UZAWE == T042F.UZAWE`
Block Key for Payment Block Key for Payment Client	`VDBEPI.ZAHLS == T008.ZAHLS` `VDBEPI.MANDT == T008.MANDT`