PPMGAG_T_VTBFHAP - Transaction Flow

Transaction Flow information is stored in SAP table PPMGAG_T_VTBFHAP.
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_VTBFHAP

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
RFHA	Financial Transaction	X	PPMGAG_E_FINANCIAL_TRANS	CHAR	26
RFHAZU	Transaction Activity	X	PPMGAG_E_TRANSACTION_ACTIVITY	NUMC	10
CRDAT	Creation Date	X	PPMGAG_E_CREATED_DATE	DATS	16
TCRTIM	Creation Time	X	PPMGAG_E_CREATED_TIME	TIMS	12
RFHAZB	Transaction Flow	X	PPMGAG_E_TRANSACTION_FLOW	NUMC	8
.INCLUDE	TAB			PPMGAG_S_FTRS_VTBFHAPO1	0
CRUSER	Created By		PPMGAG_E_CREATED_BY	CHAR	24
UPUSER	Last Changed By		PPMGAG_E_LAST_CHANGED_BY	CHAR	24
DUPDAT	Changed On		PPMGAG_E_CHANGED_DATE	DATS	16
TUPTIM	Change Time		PPMGAG_E_CHANGED_TIME	TIMS	12
RANTYP	Contract Type		PPMGAG_E_CONTRACT_TYPE	CHAR	2
SFHAZBA	Flow Type		PPMGAG_E_FLOW_TYPE	CHAR	8
SBKKLAS	Classification of Flows and Conditions		PPMGAG_E_FLOW_CONDITIONS	CHAR	2
SBKTYP	Category of Flows and Conditions		PPMGAG_E_FLOW_CATEGORY	CHAR	4
SBERFIMA	Calculation category for cash flow calculator		SBEWFIMA	CHAR	8	*
SSIGN	Direction of Flow		PPMGAG_E_FLOW_DIRECTION	CHAR	2
SHERKUNFT	Display Area of Flow or Condition		PPMGAG_E_FLOW_DIPLAY_AREA	CHAR	8
SABVERF	Procedure to Generate Derived Flows		PPMGAG_E_PRCEDRE_DERIVED_FLOW	CHAR	10
RKONDGR	Direction of Transaction		PPMGAG_E_TRANS_DIRECTION	NUMC	2
RKOND	Condition		PPMGAG_E_CONDITION	NUMC	8
DGUEL_KP	Condition Item Effective From		DGUEL_KP	DATS	16
NSTUFE	Level number of condition item for recurring payments		NSTUFE	NUMC	4
SKOART	Condition Type (Smallest Subdivision of Condition Records)		PPMGAG_E_CONDITION_TYPE	NUMC	8
RREFKONT	Obsolete: Accnt Assignment Ref. in Fin. Assets Management		PPMGAG_E_ACCT_ASSIGN_REF	CHAR	16	*
SBZVABW	Alternative Payment Details Stated in Flow		PPMGAG_E_ALT_PAY_DETAILS	CHAR	2
RAHABKI	Short Key for Own House Bank		PPMGAG_E_HOUSE_BANK	CHAR	10	*
RAHKTID	Short Key for House Bank Account		PPMGAG_E_HOUSE_BANK_ACC	CHAR	10	*
RPZAHL	Payer/Payee		PPMGAG_E_PAYEE	CHAR	20	*
RPBANK	Partner Bank Details		PPMGAG_E_PARTNER_BANK	CHAR	8
SZART	Payment Transaction		PPMGAG_E_PAYMENT_TRANS	CHAR	2
UZAWE	Payment method supplement		UZAWE	CHAR	4	*
SPAYRQ	Generate Payment Request		PPMGAG_E_GENERATE_PYMT_REQ	CHAR	2
SPRSNG	Individual Payment		PPMGAG_E_INDIVIDUAL_PAYMENT	CHAR	2
SPRGRD	Determine Grouping Definition		PPMGAG_E_GROUP_DETERMINE	CHAR	2
SCSPAY	Same Direction Necessary for Joint Payment		PPMGAG_E_SAME_DIR_PAYMENT	CHAR	2
PAYGR	Grouping Field for Automatic Payments		PAYGR	CHAR	40
SBEWEBE	Posting Status of Flow		PPMGAG_E_PSTNG_STATUS_FLW	CHAR	2
SSPRGRD	Reason for Flow Blocked for Posting		PPMGAG_D_PSTNG_BLOCK_REASN	NUMC	2
SBFREI	Release Given for Flow to Be Posted		PPMGAG_E_PSTNG_REASN	CHAR	2
SSTORNOBWG	Flow Reversal in Treasury		PPMGAG_E_FLOW_REVERSL_TRESRY	CHAR	2
PRKEY	Key Number for Payment Request		PRQ_KEYNO	CHAR	20	*
BELNR	Document Number of an Accounting Document		BELNR_D	CHAR	20
BELNR2	Second Journal Entry Number for Currency Swaps		PPMGAG_E_JOURNAL_ENTRY2	CHAR	20
GJAHR	Fiscal Year		GJAHR	NUMC	8
DBUCHUNG	Posting Date in the Document		BUDAT	DATS	16
DFAELL	Due Date		PPMGAG_E_DUE_DATE	DATS	16
DZTERM	Payment or Delivery Date		PPMGAG_E_DELIVERY_DATE	DATS	16
BZBETR	Payment Amount in Payment Currency		PPMGAG_E_PAYMENT_AMOUNT	CURR	7
KHWKURS	Local Currency Rate		PPMGAG_E_LCL_RATE	DEC	5
WZBETR	Payment Currency		PPMGAG_E_PAYMENT_CURRENCY	CUKY	10	*
BHWBETR	Payment Amount in Local Currency		PPMGAG_E_PAYMENT_AMOUNT_LCL_CU	CURR	7
ASTUECK	No. of Units for Financial Instruments		PPMGAG_E_FIN_INTRUMENT_NUM	DEC	8
BPRICE	Price per Unit		PPMGAG_E_PRICE_PER_UNIT	CURR	7
WPRICE	Price Currency		PPMGAG_E_PRICE_CURR	CUKY	10	*
BHWPREIS	Price in Local Currency		PPMGAG_E_PRICE_CURR_LOCAL	CURR	7
BINDEX	Point Value		PPMGAG_E_CURR_POINT_VAL	CURR	7
VVBASIS	Price in Points		PPMGAG_E_PRICE_IN_PTS	DEC	6
PWKURS	Price as Percentage Quotation		PPMGAG_E_PRICE_AS_PERCENT	DEC	6
PRKKURS	Currency Option Premium with Price in Points - not used		PPMGAG_E_PRE_PRICE_IN_PTS	DEC	7
BNWHR	Nominal Amount		PPMGAG_E_NOMINAL_AMOUNT	CURR	7
RHANDPL	Exchange		VVRHANDPL	CHAR	20	*
SKURSART	Rate/Price Type - Treasury Instruments		TI_KURSART	CHAR	4
DBERVON	Start of Calculation Period		DBERVON	DATS	16
DBERBIS	End of Calculation Period		DBERBIS	DATS	16
ATAGE	Number of Days		PPMGAG_E_NO_OF_DAYS	NUMC	12
ABASTAGE	Number of base days in a calculation period		ABASTAGE	NUMC	12
PKOND	Percentage rate for condition items		PKOND	DEC	6
DPKOND	Fixing Date of Percentage Rate from Condition		VVDPKOND	DATS	16
DZFEST	Interest Rate Fixing Date		PPMGAG_E_INTSRT_FIX_DATE	DATS	16
SZBMETH	Interest Calculation Method		SZBMETH	CHAR	2
SKALIDWT	Interest Calendar		TFMSKALIDWT	CHAR	4
BBASIS	Calculation Base Amount		PPMGAG_E_CALC_BASE_AMT	CURR	7
WBASIS	Currency of Calculation Basis		PPMGAG_E_CALC_BASE_CURR	CUKY	10	*
JEXPOZINS	Type of Compound Interest Calculation		TFM_SINTCOMP	CHAR	2
SINCL	Inclusive indicator for beginning and end of a period		VVSINCL	NUMC	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
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
SAEND	Change Indicator for FiMa Flow Records		TFM_SAEND	NUMC	2
DVALUT	Calculation Date		DVALUT	DATS	16
SVINCL	Inclusive indicator for beginning and end of a period		VVSINCL	NUMC	2
SVULT	Month-End Indicator for Value Date		VVSVULT	CHAR	2
JSOFVERR	Indicator for Immediate Settlement (Financial Mathematics)		TFMSOFVERR	CHAR	2
DVERRECH	Settlement date		VVDVERRECH	DATS	16
SINCLVERR	Inclusive Indicator for Clearing Date		VVSINCLVER	NUMC	2
SULTVERR	Month-End Indicator for Clearing Date		VVSULTVERR	CHAR	2
SSTORNOMAN	Manual Reversal of Flows Posted in FI		PPMGAG_E_MANUAL_FLW_REV	CHAR	2
SSTORNOART	Type of Manual Reversal of Flows Posted in FI		PPMGAG_E_MANUAL_FLW_REV_TYP	CHAR	4
SBWGARTREF	Referenced Flow Type		PPMGAG_E_REF_FLOW_TYPE	CHAR	8
SKHWFIX	Method of Translation into Local Currency		PPMGAG_E_REF_TRANS_LCL_CURR	CHAR	2
RLDEPO	Securities Account		PPMGAG_E_LCL_SECURITIES_ACCT	CHAR	20
RANL	Character field 13 digits		CHAR13	CHAR	26
RTRBELNR	Internal Document Number of Derivatives Document		PPMGAG_E_INTERNAL_DERV_DOCNR	CHAR	30
BUPRC	Security Price Without Currency Ref. with Unit Quotation		PPMGAG_E_SECURITY_PRICE	DEC	8
BPPRC	Security Price for Percentage Quotation		PPMGAG_E_SECURITY_PRICE_PER_QO	DEC	8
WBBETR	Currency of Position Amount		PPMGAG_E_POS_AMNT_CURR	CUKY	10	*
BBBETR	Amount that Changes the Position		PPMGAG_E_POS_AMNT_CHNG	CURR	7
WEBETR	Price Currency		PPMGAG_E_PRICE_CURRENCY	CUKY	10	*
BEBETR	Market Value in Quotation Currency		PPMGAG_E_MARKTE_VALUE_QOT_CURR	CURR	7
SRUNIT	Currency Unit of Rate		PPMGAG_E_CURRENCY_UNIT	CHAR	10
KZWKURS	Payment Currency Rate		PPMGAG_E_PAYMENT_CURR_RATE	DEC	5
KBWKURS	Position Currency Rate		PPMGAG_E_POS_CURR_RATE	DEC	5
WSBETR	Prepayment Interest Amount Currency		PPMGAG_E_CURR_KEY_SRC	CUKY	10	*
DBESTAND	Position Value Date		PPMGAG_E_POS_VAL_DATE	DATS	16
SSTCKKZ	Accrued interest method		SSTCKKZ	CHAR	2
SSTCKTG	Accrued interest: Daily method		SSTCKTG	CHAR	2
SFLAT	Indicator 'Traded flat',i.e.no accrued interest calculation		VVSFLAT	CHAR	2
SCOUPON	Coupon ID for Interest and Accrued Interest Calculation		PPMGAG_E_COUPON_ID	CHAR	2
DCOUPON	Coupon Date of Next Delivered Coupon		PPMGAG_E_COUPON_DATE	DATS	16
AWKEY	Reference Key		AWKEY	CHAR	40
INDEX_VALUE	Index Value (Independent of Basis)		PPMGAG_E_IDX_VAL_RATIO	DEC	10
SBASIS	Calculation Base Indicator		PPMGAG_E_BASE_IND	CHAR	8
REGI_STATE	Status of Interest Rate Adjustment		PPMGAG_E_REG_STATE	CHAR	4
RPCODE	Repetitive Code		RPCODE	CHAR	40
RP_TEXT	Reference Text for Repetitive Code		RPCODE_TEXT	CHAR	100
HEDGE_ID	Identification for Hedging Relationship		PPMGAG_E_HEDGE_ID	CHAR	20
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
AMMRHY	Frequency in months		AMMRHY	NUMC	6
PPAYMENT	Payment Rate		TFM_PPAYMENT	DEC	6
AMMRHYZV	Interest Settlement Frequency for Exponential Interest Calc.		TFM_AMMRHYZV	NUMC	4
LZBKZ	State Central Bank Indicator		LZBKZ	CHAR	6	*
QUANTITY	Quantity		PPMGAG_E_QUANTITY	QUAN	7
UNIT_OF_MEASURE	Unit of Measure for the Commodity		TPM_CTY_UOM	UNIT	6	*
CONTRACT_PRICE	Commodity Price		PPMGAG_E_COMMODITY_PRICE	DEC	7
SPOT_PRICE	Commodity Spot Price		PPMGAG_E_COMMODITY_PRICE_SPOT	DEC	7
CONTANGO_BACKWRD	Commodity Spread		PPMGAG_E_COMMODITY_CONTAGNO	DEC	7
BPRC_SPOT1	Current Spot Rate in Percentage		PPMGAG_E_CURR_SPOT_PER	DEC	8
BPRC_SPOT2	Spot Rate at Maturity in Percentage		PPMGAG_E_CURR_SPOT_PER_MAT	DEC	8
COST_FWD	Forward Rate Cost		PPMGAG_E_FWD_RATE_COST	DEC	8
INTEREST_FWD	Forward Rate Interest		PPMGAG_E_FWD_RATE_INTRST	DEC	8
REF_FLOWUUID	Flow Reference (UUID)		PPMGAG_E_REF_FLW_UUID	RAW	16
RGATT	Class		PPMGAG_E_RGATT	CHAR	26
COMMODITY_ID	Commodity ID (obsolete)		PPMGAG_E_COMMODITY_ID	CHAR	36
QUOTATION_NAME	Quotation Name		CPET_QUOTNAME	CHAR	36
QUOTATION_SOURCE	Quotation Source		PPMGAG_E_QUOT_SRC	CHAR	4
QUOTATION_TYPE	Commodity Quotation Type		PPMGAG_E_QUOT_TYPE	CHAR	10
SPREAD	Commodity Spread		PPMGAG_E_COMM_SPREAD	DEC	7
PRICE_CURR_UNIT	Currency Unit of Rate		PPMGAG_E_CURRENCY_UNIT	CHAR	10
PRICE_UOM	Unit of Measure for the Commodity		TPM_CTY_UOM	UNIT	6	*
DIV_PCTC_OTC	Percentage of Dividend Agreed for Payment in OTC Instruments		PPMGAG_E_PER_DIVIDEND_PAY	DEC	4
TAINTED	Cash Flow Type		PPMGAG_E_TAINTED_CASHFLOW	CHAR	2
CLEARED	Clearing at Flow Level		PPMGAG_E_FLOW_CLEARED	CHAR	2
DCSID	Derivative Contract Specification ID		TBA_DCSID	CHAR	40
MIC	Market Identifier Code		TBA_MIC	CHAR	8
PRICE_TYPE	Type of Price Quotation		TBA_PRICETYPE	CHAR	4
TIME_TO_MATURITY	Time to Maturity		TBA_TENOR	CHAR	20
TIMING	Timing/Periodicity of Commodity Forward Indexes		TBA_TIMING	NUMC	4
EXCH_RATE_TYPE	Exchange Rate Type		KURST_CURR	CHAR	8	*
PRICE_PAYM_CURR	Commodity Price in Payment Currency		PPMGAG_E_COMPARE_PAYMNT	DEC	7
SPREAD_PAYM_CURR	Commodity Spread in Payment Currency		PPMGAG_E_COM_SPREAD_PAY	DEC	7
FX_TRANSLATION	When to Convert Price Currency into Payment Currency		PPMGAG_E_FX_TRANS	CHAR	2
MNDID	Unique Reference to Mandate for each Payee		SEPA_MNDID	CHAR	70
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
RKONDREF	Condition		PPMGAG_E_CONDITION	NUMC	8
DGUEL_KPREF	Condition Item Effective From		DGUEL_KP	DATS	16
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
FLOWFACTOR	Flow Factor		TFM_FLOWFACTOR	D34R	16
BASEFACTOR	Base Factor		TFM_BASEFACTOR	D34R	16
SROUNDBASEFACTOR	Rounding Category of a Base Factor		TFM_SROUNDBASEFACTOR	CHAR	2
ROUNDDECBASEFACTOR	Number of Rounding Decimal Places for a Base Factor		TFM_ROUNDDECBASEFACTOR	INT1	1
SKBWFIX	Translation into Position Currency		PPMGAG_E_IND_TRANS_CURR	CHAR	2
GROUPING_TERM	Grouping Term for Derived Flows		PPMGAG_E_FLW_GROUPING	CHAR	20
SSEQUENCE	Processing Sequence of Conditions		TFM_SEQUENCE	NUMC	4
SROUNDRATEFACTOR	Rounding Category of Interest Factor		TFM_SROUNDRATEFACTOR	CHAR	2
JAVGCAP	Use Upper Limit of Average Interest Rate		TFM_JAVGCAP	CHAR	2
PAVGCAP	Upper Limit of Average Interest Rate		TFM_PAVGCAP	DEC	8
PAVGFLOOR	Lower Limit of Average Interest Rate		TFM_PAVGFLOOR	DEC	8
JAVGFLOOR	Use Lower Limit of Average Interest Rate		TFM_JAVGFLOOR	CHAR	2
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
LANDL	Supplying Country/Region		LANDL	CHAR	6	*
BDIRTY	Dirty Price		PPMGAG_E_DIRTY_PRICE	CURR	7
BAMOUNTCOMP	Capitalization Amount		PPMGAG_E_AMNT_CAP	CURR	7
NOMINAL_ORG_AMT	Original Nominal Amount		PPMGAG_E_AMNT_NOM_ORG	CURR	7
NOM_FACTOR	Factor		PPMGAG_E_AMNT_NOM_FAC	DEC	7
ROUNDDECRATEFACTOR	Number of Rounding Decimal Places for Interest Factor		TFM_ROUNDDECRATEFACTOR	INT1	1
AAVGDAYS	No. of Days for Interest Calc. with Average Interest Rate		TFM_AAVGDAYS	INT4	4
PAVGINTEREST	Average Interest Rate		TFM_PAVGINTEREST	DEC	8
STGBASIS	Base Days Method		VVSTGBASIS	CHAR	2
AAVGWEIGHTSUM	Cumulative Weighting of Interest Rate		TFM_AWEIGHTSUM	INT4	4
RLDEPO2	Securities Account		PPMGAG_E_SECU_ACC	CHAR	20
INDEX_PRICE	Security Price Including Price Index Value		PPMGAG_E_IDX_PRICE	CHAR	2
FLOWUUID	Transaction Flow - Universally Unique Identifier (UUID)		PPMGAG_E_FLW_UUID	RAW	16
FLAGBYTE1	Indicator for Financial Transaction Flow		PPMGAG_E_FLG_BYTE	RAW	1
.INCLUDE				PPMGAG_S_LC_PRESENTATION	0
PRESENT_DATE	Presentation Date		PPMGAG_E_PRESETNT_DATE	DATS	16
INTEREST_PAID_BY	Interest Paid By		PPMGAG_E_INTRST_PAYED_BY	CHAR	2
SHIPMENT_DATE	Shipment Date		PPMGAG_E_SHIP_DATE	DATS	16
STATUS	Status		PPMGAG_E_PRSNT_STATUS	CHAR	4
PRESENT_ID	Presentation Item		PPMGAG_E_PRSNT_ID	CHAR	20
SSTOGRD	Reason for Reversal		PPMGAG_E_REV_REASON	CHAR	4
PRESENT_AMOUNT	Presentation Amount		PPMGAG_E_PRESETNT_AMNT	CURR	7
PRESENT_BANK	Presentation Bank		PPMGAG_E_PRESETNT_BANK	CHAR	20	*
PRESENT_DISCREPANCY	Discrepancy Amount		PPMGAG_E_DISCREPANCY	CHAR	2
PRESENT_DECREASE_AMOUNT	Presentation Decreased Amount		PPMGAG_E_DECRSE_AMNT	CURR	7
PRESENT_REA_CRE_LINE	Amount of Released Credit Line		PPMGAG_E_RELEASE_AMNT	CURR	7
PRESENT_PAY_AMT	Payment Amount in Payment Currency		PPMGAG_E_PAYMENT_AMOUNT	CURR	7