PPMGAG_T_VTBFINK - Transaction Condition

Transaction Condition information is stored in SAP table PPMGAG_T_VTBFINK.
It is part of development package PPMG_INTEREST in software component CA-PPA. This development package consists of objects that can be grouped under "Prepayment Interest".

Fields for table PPMGAG_T_VTBFINK

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
MANDT	Client	X	MANDT	CLNT	6
BUKRS	Company Code	X	BUKRS	CHAR	8
RGATT	Class	X	PPMGAG_E_RGATT	CHAR	26
RFHA	Financial Transaction	X	PPMGAG_E_FINANCIAL_TRANS	CHAR	26
RFHAZU	Transaction Activity	X	PPMGAG_E_TRANSACTION_ACTIVITY	NUMC	10
RKONDGR	Direction of Transaction	X	PPMGAG_E_TRANS_DIRECTION	NUMC	2
RKOND	Condition	X	PPMGAG_E_CONDITION	NUMC	8
DGUEL_KP	Condition Item Effective From	X	DGUEL_KP	DATS	16
NSTUFE	Level number of condition item for recurring payments	X	NSTUFE	NUMC	4
.INCLUDE				PPMGAG_S_VTBFINKO	0
CRUSER	Created By		PPMGAG_E_CREATED_BY	CHAR	24
DCRDAT	Entered On		PPMGAG_E_ENTERED_ON	DATS	16
TCRTIM	Entry Time		PPMGAG_E_ENTERED_TIME	CHAR	12
UPUSER	Last Changed By		PPMGAG_E_LAST_CHANGED_BY	CHAR	24
DUPDAT	Changed On		PPMGAG_E_CHANGED_DATE	DATS	16
TUPTIM	Changed On		PPMGAG_E_CHANGED_DATE	DATS	16
SALTKOND	Unit for supplementary condition items		TB_SALKOND	NUMC	8
SZINSANP	Cross-referenced condition grp for interest rate adjustment		SZINSANP	NUMC	8
JNULLKON	Condition Form		JNULLKON	CHAR	2
SKOART	Condition Type (Smallest Subdivision of Condition Records)		PPMGAG_E_CONDITION_TYPE	NUMC	8
SSIGN	Direction of Flow		PPMGAG_E_FLOW_DIRECTION	CHAR	2
SBKKLAS	Classification of Flows and Conditions		PPMGAG_E_FLOW_CONDITIONS	CHAR	2
SBKTYP	Category of Flows and Conditions		PPMGAG_E_FLOW_CATEGORY	CHAR	4
PKOND	Percentage rate for condition items		PKOND	DEC	6
BKOND	Condition Item Currency Amount		PPMGAG_E_CONDITION_ITEM_AMNT	CURR	7
SWHRKOND	Currency of Condition Item		SWHRKOND	CUKY	10	*
SBASIS	Calculation Base Indicator		PPMGAG_E_BASE_IND	CHAR	8
BBASIS	Calculation Base Amount		TFM_BBASIS2	CURR	7
SZBMETH	Interest Calculation Method		SZBMETH	CHAR	2
SKALIDWT	Interest Calendar		TFMSKALIDWT	CHAR	4
SINCL	Inclusive indicator for beginning and end of a period		VVSINCL	NUMC	2
SZSREF	Reference Interest Rate		PPMGAG_E_REF_INTRST_RATE	CHAR	20	*
SFORMREF	Formula Reference		TB_XFORMBE	CHAR	8	*
SVARNAME	Variable Name		TB_VARNAME	CHAR	8
AMMRHY	Frequency in months		AMMRHY	NUMC	6
ATTRHY	Frequency in Days		ATTRHY	NUMC	6
DVALUT	Calculation Date		DVALUT	DATS	16
SVULT	Last Trading Day for Condition Calculation		PPMGAG_E_MNTH_END_IND	CHAR	2
SVWERK	Working Day Shift for Calculation Day		TB_SVWERK	NUMC	2
SVMETH	Method for determining the next value date		TB_SVMETH	NUMC	2
AVGSTAGE	No. of Days for Relative Determination of Interest Fixing		PPMGAG_E_NO_OF_DAYS_INTRST_DET	INT4	4
DFAELL	Due Date		PPMGAG_E_DUE_DATE	DATS	16
SFULT	Month-End Indicator for Due Date		SFULT	CHAR	2
SFWERK	Working Day Shift for Due Date		TB_SFWERK	NUMC	2
SFMETH	Method for determining the next due date		TB_SFMETH	NUMC	2
AFGSTAGE	Number of days for rel. determination of due date		TB_AFGSTAG	INT4	4
SDWERK	Working Day Shift for Payment Date		TB_SDWERK	NUMC	2
DZFEST	Interest Rate Fixing Date		PPMGAG_E_INTSRT_FIX_DATE	DATS	16
AZGSTAGE	No. of Days for Relative Determinatn of Interest Fixing		PPMGAG_E_NO_OF_WRK_DAYS	INT4	4
DZSREF	Reference Interest Rate Fixing Date		PPMGAG_E_REF_INTRST_DATE	DATS	16
SKALID	Factory calendar		SKALID	CHAR	4
SKALID2	Factory calendar		SKALID	CHAR	4
RANTYP	Contract Type		PPMGAG_E_CONTRACT_TYPE	CHAR	2
SHERKUNFT	Display Area of Flow or Condition		PPMGAG_E_FLOW_DIPLAY_AREA	CHAR	8
SRHYTHM	Frequency Indicator		PPMGAG_E_FREQ_IND	NUMC	2
SBERFIMA	Calculation category for cash flow calculator		SBEWFIMA	CHAR	8	*
SZWERK	Shift to Working Day for Interest Fixing Date		PPMGAG_E_BANK_WRK_DAY	NUMC	2
RHANDPL	Exchange		VVRHANDPL	CHAR	20	*
SKURSART	Rate/Price Type - Treasury Instruments		TI_KURSART	CHAR	4
SFVMETH	Update Method for Calculation Date/Due Date		PPMGAG_E_UPD_METH	NUMC	4
SERBTERM	FiMa indicator: Date and frequency inheritance for condition		TFMERBTERM	CHAR	2
SFRANZ	Shift Due Date		TFMSFRANZ	NUMC	2
SEXCLGUEL	Exclusive indicator for start date of condition position		TFMSEXCLKP	NUMC	2
JSOFVERR	Indicator for Immediate Settlement (Financial Mathematics)		TFMSOFVERR	CHAR	2
JEXPOZINS	Type of Compound Interest Calculation		TFM_SINTCOMP	CHAR	2
SKALID3	Factory calendar		SKALID	CHAR	4
PPAYMENT	Payment Rate		TFM_PPAYMENT	DEC	6
SZEITANT	Indicator for Pro Rata Temporis Calculations		VVSZEITANT	NUMC	2
PKOND1STPER	Interest Rate for the First Period		TFM_PKOND1STPER	DEC	6
SREFDISC	Referenced Condition Group Discounting		SREFDISC	NUMC	8
SDISCOUNT	Discounting Category		TFM_SDISCOUNT	NUMC	2
BROUNDUNIT	Rounding Unit		TFMPRUNIT	DEC	7
SROUND	Rounding Category		TFM_SROUND	CHAR	2
AMMRHYZV	Interest Settlement Frequency for Exponential Interest Calc.		TFM_AMMRHYZV	NUMC	4
FACILITYLINE	Line of Credit		PPMGAG_E_CREDIT_LINE	CHAR	6
BGUEL_KP	Condition Item Effective from Amount		PPMGAG_E_POST_AMNT	CURR	9
SULTGUEL	Month-end indicator for start date of condition position		TFMSULT_KP	CHAR	2
BBASISUNIT	Base Unit for Rounding		TFM_BBASISUNIT	CURR	9
RKONDREF	Reference Condition Type		PPMGAG_E_REF_CONDITION	NUMC	8
STTLM_FREQ	COMS: Settlement Frequency		PPMGAG_E_SETTLE_FREQ	INT1	1
STTLM_FREQ_UNIT	COMS: Settlement Frequency Unit		PPMGAG_E_SETTLE_FREQ_UNIT	CHAR	2
PAYDAT_OFFS_UNIT	COMS: Unit for Payment Date Offset		PPMGAG_E_PAY_DATE_OFF	CHAR	2
COMMON_PRICING	Common Pricing Used for Average Pricing		PPMGAG_E_AVG_PRICING	CHAR	2
FIXING_DATE_RULE	COMS: Fixing Date Rule for COMS		PPMGAG_E_FIX_DATE_RULE	CHAR	2
WEEKDAY_NUMBER	COMS: Frequency of Occurrence of Weekday in Period		PPMGAG_E_NO_OF_WEEK_DAY	INT1	1
WEEKDAY	COMS: Day of Week for Price Fixing		PPMGAG_E_DAY_WEEK	CHAR	2
AVERAGE_FREQ	COMS: Frequency for Average		PPMGAG_E_FREQ_AVG	INT2	2
QUAN	Quantity		PPMGAG_E_QUANTITY	QUAN	7
UNIT_OF_MEASURE	Unit of Measure for the Commodity		TPM_CTY_UOM	UNIT	6	*
QUAN_RELATED_TO	Quantity Related To		PPMGAG_E_VALID_QUAN	CHAR	2
REFERENCE	Reference		PPMGAG_E_FTR_REF	CHAR	64
FX_TRANSLATION	When to Convert Price Currency into Payment Currency		PPMGAG_E_FX_TRANS	CHAR	2
EXCH_RATE_TYPE	Exchange Rate Type		KURST_CURR	CHAR	8	*
CPCC_FLAG	COMS: Consideration of Payment Currency Calendar		PPMGAG_E_CKH_CURR_CAL	CHAR	2
JPROZR	Percentage Calculation		TB_JPROZR	CHAR	2
SFINCL	Inclusive Indicator for Due Date		VVSFINCL	NUMC	2
JBMONAT	Indicator for calculating amount per month		JBMONAT	CHAR	2
BUGRENZ	Lower Limit for Amount		TFMBUGRENZ	CURR	12
BOGRENZ	Upper Limit for Amt		TFMBOGRENZ	CURR	12
SSTAFF	Type of Scaled Calculation		TFMSSTAFF	NUMC	2
LOGIC_RKOND	Logical Condition Group		PPMGAG_E_CONDITION_GRP	NUMC	8
SKALID4	Factory calendar		SKALID	CHAR	4
SKALID5	Factory calendar		SKALID	CHAR	4
SROUNDFACTOR	Rounding Category of a Factor		TFM_SROUNDFACTOR	CHAR	2
ROUNDDECFACTOR	Number of Rounding Decimal Places for a Factor		TFM_ROUNDDECFACTOR	INT1	1
JEXPOINTFACTOR	Exponential Interest Calculation with Factor		TFM_JEXPOINTFACTOR	CHAR	2
SROUNDBASEFACTOR	Rounding Category of a Factor		TFM_SROUNDFACTOR	CHAR	2
ROUNDDECBASEFACTOR	Number of Rounding Decimal Places for a Factor		TFM_ROUNDDECFACTOR	INT1	1
SSEQUENCE	Processing Sequence of Conditions		TFM_SEQUENCE	NUMC	4
SROUNDRATEFACTOR	Rounding Category of Interest Factor		TFM_SROUNDRATEFACTOR	CHAR	2
ROUNDDECRATEFACTOR	Number of Rounding Decimal Places for Interest Factor		TFM_ROUNDDECRATEFACTOR	INT1	1
ADGSTAGE	Number of Days for Relative Payment Date Calculation		TFM_ADGSTAGE	INT4	4
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
SAVGWEIGHT	Weighting Category of Interest Rate		TFM_SWEIGHT	CHAR	2