SAP VTBFHAPO_UNFIXED Non-Fixed Financial Transaction Flows Table

Overview

VTBFHAPO_UNFIXED is a standard SAP S/4HANA table that stores Non-Fixed Financial Transaction Flows data. There are total 224 fields in the VTBFHAPO_UNFIXED table. The following is a list of the fields that make up this table. Key fields are marked in blue.

The table VTBFHAPO_UNFIXED belongs to Transaction Manager (FIN-FSCM-TRM-TM) module and is located in the package R/3 appl. development for Treasury money,forex,forward gen (FTA).

In addition, following links provide an overview of foreign key relationships, if any, that link VTBFHAPO_UNFIXED to other SAP tables and standard CDS views available based on VTBFHAPO_UNFIXED table in S/4HANA 2020.

Techincal Settings of VTBFHAPO_UNFIXED

Below are technical details of the table VTBFHAPO_UNFIXED

  • Buffering not allowed
  • No buffering
  • Storage type is Column Store

List of VTBFHAPO_UNFIXED Fields

The following table gives you an overview of the fields available in VTBFHAPO_UNFIXED

FieldDescriptionData ElementCheck TableData TypeLength
MANDTClientMANDTCLNT3
BUKRSCompany CodeBUKRSCHAR4
RFHAFinancial TransactionTB_RFHACHAR13
RFHAZUTransaction ActivityTB_RFHAZUNUMC5
DCRDATEntered OnTB_CRDATDATS8
TCRTIMEntry TimeTB_TCRTIMTIMS6
RFHAZBTransaction FlowTB_RFHAZBNUMC4
CRUSEREntered ByTB_CRUSERCHAR12
UPUSERLast Changed ByTB_UPUSERCHAR12
DUPDATChanged OnTB_DUPDATDATS8
TUPTIMTime ChangedTB_TUPTIMTIMS6
RANTYPContract TypeRANTYPCHAR1
SFHAZBAFlow TypeTB_SFHAZBATZB0ACHAR4
SBKKLASClassification of Flows and ConditionsTB_SBKKLASCHAR1
SBKTYPCategory of Flows and ConditionsTB_SBKTYPAT07CHAR2
SBERFIMACalculation category for cash flow calculatorSBEWFIMAAT40CHAR4
SSIGNDirection of FlowTB_SSIGNCHAR1
SHERKUNFTDisplay Area of Flow or ConditionTB_SHERKCHAR4
SABVERFProcedure for Generating Derived FlowsTB_SABVERFAT22CHAR5
RKONDGRDirection of TransactionTB_RKONDGRNUMC1
RKONDConditionTB_KONDNUMC4
DGUEL_KPCondition Item Valid FromDGUEL_KPDATS8
NSTUFELevel number of condition item for recurring paymentsNSTUFENUMC2
SKOARTCondition Type (Smallest Subdivision of Condition Records)SKOARTTZK01NUMC4
RREFKONTObsolete: Accnt Assignment Ref. in Fin. Assets ManagementRREFKONT_OBSOLETET037SCHAR8
SBZVABWAlternative Payment Details Stated in FlowTB_SBZVABWCHAR1
RAHABKIShort Key for Own House BankTB_RHABKIT012CHAR5
RAHKTIDShort Key for House Bank AccountTB_RHKTIDT012KCHAR5
RPZAHLPayer/PayeeTB_RPZAHL_NEWCHAR10
RPBANKPartner Bank DetailsTB_RPBANKCHAR4
SZARTPayment TransactionTB_SZARTCHAR1
ZLSCHPayment MethodDZLSCHT042ZCHAR1
UZAWEPayment method supplementUZAWET042FCHAR2
SPAYRQGenerate Payment RequestTB_SPAYRQKCHAR1
SPRSNGIndividual PaymentTB_SPRSNGKCHAR1
SPRGRDDetermine Grouping DefinitionTB_SPRGRDCHAR1
SCSPAYSame Direction Necessary for Joint Payment?TB_SCSPAYCHAR1
ZWELSList of Respected Payment MethodsDZWELSCHAR10
PAYGRGrouping Field for Automatic PaymentsPAYGRCHAR20
SBEWEBEPosting Status of FlowTB_SBEWEBECHAR1
SSPRGRDReason Why Flow Is Blocked for PostingTB_SSPRGRDNUMC1
SBFREIRelease Given for Flow to Be Posted?TB_SBFREICHAR1
SSTORNOBWGFlow Reversal in TreasuryTB_SBWGSTOCHAR1
PRKEYKey Number for Payment RequestPRQ_KEYNO*CHAR10
BELNRAccounting Document NumberBELNR_DCHAR10
BELNR2Second Journal Entry No. for Currency SwapsTB_BELNR2CHAR10
GJAHRFiscal YearGJAHRNUMC4
DBUCHUNGPosting Date in the DocumentBUDATDATS8
DFAELLDue DateTB_DFAELLDATS8
DZTERMPayment or Delivery DateTB_DZTERMDATS8
BZBETRPayment Amount in Payment CurrencyTB_BZBETRCURR13
WZBETRPayment CurrencyTB_WZBETRTCURCCUKY5
BHWBETRPayment Amount in Local CurrencyTB_HWBETRCURR13
KHWKURSLocal Currency RateTB_KHWKURSDEC9
ASTUECKNo. of Units for Financial InstrumentsTB_ASTUECKDEC15
BPRICEPrice per UnitTB_BPRICECURR13
WPRICEPrice CurrencyTB_WPRICETCURCCUKY5
BHWPREISPrice in Local CurrencyTB_HWPREISCURR13
BINDEXValue of a PointTB_BINDEXCURR13
VVBASISPrice in PointsTB_VVBASISDEC11
PWKURSPrice as Percentage QuotationTB_PWKURSDEC10
PRKKURSCurrency Option Premium with Price in PointsTI_PRKURDEC13
BNWHRNominal AmountTB_BNWHRCURR13
RHANDPLExchangeVVRHANDPLTWH01CHAR10
SKURSARTRate/Price Type - Treasury InstrumentsTI_KURSARTTW56CHAR2
DBERVONStart of Calculation PeriodDBERVONDATS8
DBERBISEnd of Calculation PeriodDBERBISDATS8
ATAGENumber of DaysVVATAGENUMC6
ABASTAGENumber of base days in a calculation periodABASTAGENUMC6
PKONDPercentage rate for condition itemsPKONDDEC10
DPKONDFixing Date of Percentage Rate from ConditionVVDPKONDDATS8
DZFESTInterest rate fixing dateTB_DZFESTDATS8
SZBMETHInterest Calculation MethodSZBMETHCHAR1
SKALIDWTInterest CalendarTFMSKALIDWTCHAR2
BBASISCalculation Base AmountBBASISCURR13
WBASISCurrency of Calculation BasisTB_WBASISTCURCCUKY5
JEXPOZINSType of Compound Interest CalculationTFM_SINTCOMPCHAR1
SINCLInclusive indicator for beginning and end of a periodVVSINCLNUMC1
SINCLBISInclusive Indicator for the End of a Calculation PeriodVVSINCLBISNUMC1
SULTBISMonth-End Indicator for the End of a Calculation PeriodVVSULTBISCHAR1
SEXCLVONExclusive Indicator for the Start of a Calculation PeriodVVSEXCLVONNUMC1
SULTVONMonth-End Indicator for Start of a Calculation PeriodVVSULTVONCHAR1
SAENDChange Indicator for FiMa Flow RecordsTFM_SAENDNUMC1
DVALUTCalculation DateDVALUTDATS8
SVINCLInclusive indicator for value dateVVSVINCLNUMC1
SVULTMonth-End Indicator for Value DateVVSVULTCHAR1
JSOFVERRIndicator for Immediate Settlement (Financial Mathematics)TFMSOFVERRCHAR1
DVERRECHSettlement dateVVDVERRECHDATS8
SINCLVERRInclusive Indicator for Clearing DateVVSINCLVERNUMC1
SULTVERRMonth-End Indicator for Clearing DateVVSULTVERRCHAR1
SSTORNOMANManual Reversal of Flows Posted in FITB_SBWGSTMCHAR1
SSTORNOARTType of Manual Reversal of Flows Posted in FITB_SSTOARTAT90CHAR2
SBWGARTREFReferenced Flow TypeTB_SBWGREFTZB0ACHAR4
SKHWFIXIndicator for Translation into Local CurrencyTB_SKHWFIXCHAR1
ZUONRAssignment numberDZUONRCHAR18
RLDEPOSecurities AccountRLDEPOCHAR10
RANLSecurity Class ID NumberVVRANLWCHAR13
RTRBELNRInternal Document Number of Derivatives DocumentTPM_DEDOC_RDOCNRINTCHAR15
BUPRCSecurity Price Without Currency Ref. with Unit QuotationTB_BUPRCDEC15
BPPRCSecurity Price for Percentage QuotationTB_BPPRCDEC15
WBBETRCurrency of Position AmountTB_WBBETR*CUKY5
BBBETRAmount that Changes the PositionTB_BBBETRCURR13
WEBETRPrice CurrencyTB_WEBETR*CUKY5
BEBETRMarket Value in Quotation CurrencyTB_BEBETRCURR13
SRUNITCurrency Unit of the RateTB_RUNITTZUNICHAR5
KZWKURSPayment Currency RateTB_KZWKURSDEC9
KBWKURSPosition Currency RateTB_KBWKURSDEC9
WSBETRCurrency Key for Currency Conversion: Source CurrencyTB_WFROM*CUKY5
DBESTANDPosition Value DateTB_DBESTANDDATS8
SSTCKKZAccrued interest methodSSTCKKZCHAR1
SSTCKTGAccrued interest: Daily methodSSTCKTGCHAR1
SFLATIndicator 'Traded flat'i.e.no accrued interest calculationVVSFLATCHAR1
SCOUPONCoupon ID for interest and accrued interest calculationVVSCOUPONCHAR1
DCOUPONCoupon date of next delivered couponVVDCOUPONDATS8
AWKEYObject keyAWKEYCHAR20
INDEX_VALUEIndex Value (Independent of Basis)TIDX_INDEX_VALUE_NO_RATIODEC18
SBASISCalculation Base IndicatorSBASIS*CHAR4
REGI_STATEStatus of Interest Rate AdjustmentTB_IRA_REGISTRATION_STATECHAR2
RPCODERepetitive CodeRPCODECHAR20
RP_TEXTReference Text for Repetitive CodeRPCODE_TEXTCHAR50
DBPERIODPeriod startVVDBPERIODDATS8
SPAEXCLExclusive Indicator for Start Date of a PeriodTFMSPAEXCLNUMC1
SPAULTMonth-End Indicator for Start Date of a PeriodTFMSPAULTCHAR1
DEPERIODPeriod EndVVDEPERIODDATS8
SPEINCLInclusive Indicator for End Date of a PeriodTFMSPEINCLNUMC1
SPEULTMonth-End Indicator for End of a PeriodTFMSPEULTCHAR1
AMMRHYFrequency in monthsAMMRHYNUMC3
PPAYMENTPayment RateTFM_PPAYMENTDEC11
AMMRHYZVInterest Settlement Frequency for Exponential Interest Calc.TFM_AMMRHYZVNUMC2
LZBKZState Central Bank IndicatorLZBKZT015LCHAR3
LANDLSupplying CountryLANDLT005CHAR3
BDIRTYDirty PriceTB_BDIRTYCURR13
BAMOUNTCOMPAmount to be CapitalizedTB_AMOUNTCOMPCURR13
NOMINAL_ORG_AMTOriginal Nominal AmountTB_BNWHR_ORGCURR13
RLDEPO2Securities AccountVRLDEPO*CHAR10
INDEX_PRICEIndicator: Security Price Including Price Index ValueTB_INDEX_PRICECHAR1
FLOWUUIDTransaction Flow UUIDTB_FLOWUUIDRAW16
QUANTITYQuantityFTR_QUANQUAN13
UNIT_OF_MEASUREUnit of Measure for the CommodityTPM_CTY_UOM*UNIT3
CONTRACT_PRICECommodity PriceFTR_COMPRICEDEC13
SPOT_PRICECommodity Spot PriceFTR_COMSPOTDEC13
CONTANGO_BACKWRDCommodity Contango / BackwardationFTR_CONBACKDEC13
BPRC_SPOT1Current Spot Rate in PercentageTB_BPPRC_SPOT1DEC15
BPRC_SPOT2Spot Rate at Maturity in PercentageTB_BPPRC_SPOT_MATDEC15
COST_FWDForward Rate CostTB_COSTFWDDEC15
INTEREST_FWDForward Rate InterestTB_INTERESTFWDDEC15
REF_FLOWUUIDFlow Reference (UUID)TB_REFFLOWUUIDRAW16
RGATTClassTI_RGATTCHAR13
COMMODITY_IDCommodity ID (obsolete)TRCO_COMM_IDCHAR18
QUOTATION_NAMEQuotation NameCPET_QUOTNAMECHAR18
QUOTATION_SOURCEQuotation SourceTCR_CTY_QUOTSRCTRCOCC_QUOTSRCCHAR2
QUOTATION_TYPECommodity Quotation TypeTCR_CTY_QUOTTYPETRCOCC_QUOTTYPECHAR5
SPREADCommodity SpreadFTR_COMSPREADDEC13
PRICE_CURR_UNITCurrency Unit of the RateTB_RUNITTZUNICHAR5
PRICE_UOMUnit of Measure for the CommodityTPM_CTY_UOM*UNIT3
DIV_PCTC_OTCPercentage of Dividend agreed for Payment in OTC InstrumentsTB_DIV_PCTC_OTCDEC7
TAINTEDManipulated Cash FlowTB_TAINTED_CASHFLOWCHAR1
CLEAREDClearing at Flow LevelFTR_FLOW_CLEAREDCHAR1
DCSIDDerivative Contract Specification IDTBA_DCSIDCHAR20
MICMarket Identifier CodeTBA_MICCHAR4
PRICE_TYPEType of Price QuotationTBA_PRICETYPECHAR2
TIME_TO_MATURITYTime to MaturityTBA_TENORCHAR10
TIMINGTiming/Periodicity of Commodity Forward IndexesTBA_TIMINGNUMC2
EXCH_RATE_TYPEExchange rate typeKURST_CURR*CHAR4
PRICE_PAYM_CURRCommodity Price in Payment CurrencyFTR_COMPRICE_PAYMENT_CURRDEC13
SPREAD_PAYM_CURRCommodity Spread in Payment CurrencyFTR_COMSPREAD_PAYMENT_CURRDEC13
FX_TRANSLATIONDefines when quotation crcy is converted into payment crcyFTR_CURRENCY_CONV_POINT_IN_TIMCHAR1
MNDIDUnique Reference to Mandate for each PayeeSEPA_MNDIDCHAR35
BUGRENZLower Limit for AmountTFMBUGRENZCURR23
BOGRENZUpper Limit for AmtTFMBOGRENZCURR23
SSTAFFType of Scaled CalculationTFMSSTAFFNUMC1
LOGIC_RKONDCondition GroupFTR_COND_GRPNUMC4
RKONDREFConditionTB_KONDNUMC4
DGUEL_KPREFCondition Item Valid FromDGUEL_KPDATS8
PRESENT_DATEPresentation DateFTR_PRE_DATEDATS8
INTEREST_PAID_BYIdentify whether applicant or beneficiary pays interestFTR_INTEREST_PAY_BYCHAR1
SHIPMENT_DATEShipment DateFTR_SHIP_DATEDATS8
STATUSStatusFTR_STATUSCHAR2
PRESENT_IDPresentation ItemFTR_PERSENT_IDCHAR10
SSTOGRDReason for ReversalSSTOGRD*CHAR2
PRESENT_AMOUNTPresentation AmountFTR_PRESENT_AMTCURR13
PRESENT_BANKPresentation BankFTR_PRESENT_BANK*CHAR10
PRESENT_DISCREPANCYDiscrepancyFTR_DISCREPANCYCHAR1
PRESENT_DECREASE_AMOUNTPresentation Decreased AmountFTR_PRESENT_DEC_AMTCURR13
PRESENT_REA_CRE_LINEAmount of Released Credit LineFTR_PRESENT_REA_AMTCURR13
PRESENT_PAY_AMTPayment Amount in Payment CurrencyTB_BZBETRCURR13
SROUNDFACTORRounding Category of a FactorTFM_SROUNDFACTORCHAR1
ROUNDDECFACTORNumber of Rounding Decimal Places for a FactorTFM_ROUNDDECFACTORINT13
JEXPOINTFACTORExponential Interest Calculation with FactorTFM_JEXPOINTFACTORCHAR1
FLOWFACTORFlow FactorTFM_FLOWFACTORD34R34
BASEFACTORBase FactorTFM_BASEFACTORD34R34
SROUNDBASEFACTORRounding Category of a Base FactorTFM_SROUNDBASEFACTORCHAR1
ROUNDDECBASEFACTORNumber of Rounding Decimal Places for a Base FactorTFM_ROUNDDECBASEFACTORINT13
SKBWFIXIndicator for translation into position currencyTB_SKBWFIXCHAR1
GROUPING_TERMGrouping Term for Derived FlowsTB_DERIV_FLOW_GROUPINGCHAR16
SSEQUENCEProcessing Sequence of ConditionsTFM_SEQUENCENUMC2
SROUNDRATEFACTORRounding Category of Interest FactorTFM_SROUNDRATEFACTORCHAR1
ROUNDDECRATEFACTORNumber of Rounding Decimal Places for Interest FactorTFM_ROUNDDECRATEFACTORINT13
AAVGDAYSNo. of Days for Interest Calc. with Average Interest RateTFM_AAVGDAYSINT410
PAVGINTERESTAverage Interest RateTFM_PAVGINTERESTDEC15
STGBASISBase Days MethodVVSTGBASISCHAR1
JAVGCAPUse Upper Limit of Average Interest RateTFM_JAVGCAPCHAR1
PAVGCAPUpper Limit of Average Interest RateTFM_PAVGCAPDEC15
JAVGFLOORUse Lower Limit of Average Interest RateTFM_JAVGFLOORCHAR1
PAVGFLOORLower Limit of Average Interest RateTFM_PAVGFLOORDEC15
PAVGSPREADAverage Interest Rate SpreadTFM_PAVGSPREADDEC15
SROUNDAVGINTERESTRounding Category of Average Interest RateTFM_SROUNDAVGINTERESTCHAR1
ROUNDDECAVGINTERESTNumber of Rounding Decimal Places for Average Interest RateTFM_ROUNDDECAVGINTERESTINT13
AAVGWEIGHTWeighting of Interest RateTFM_AWEIGHTINT410
AAVGWEIGHTSUMCumulative Weighting of Interest RateTFM_AWEIGHTSUMINT410
FX_FIXING_DATEFixing DateTB_DFIXDATS8
FX_REGI_STATEStatus of FX Rate FixingFTR_FIXING_REF_REGI_STATECHAR2
FX_READ_DATEDate of the Exchange Rate ReadFTR_FIXING_REF_READ_DATEDATS8
TRADED_QUANTITYOTC Quantity ConversionTBA_TRADED_OTC_QUANTITYQUAN13
TRADED_QUANTITY_UOMOTC Quantity Conversion UoMTBA_TRADED_QUANTITY_UOM*UNIT3
CONV_FACTOR_TRADED_QTYQuantity Conversion Factor of Priced OTC TransactionTBA_CONV_FACTOR_TRADED_QTYDEC22
CONV_FACTOR_TRADED_QTY_UOMQuantity Conversion Factor of Priced OTC Transaction UoMTBA_CONV_FACTOR_TRADED_QTY_UOM*UNIT3
CONV_FACTOR_PRICED_QTYQuantity Conversion Factor for OTC TransactionTBA_CONV_FACTOR_PRICED_QTYDEC22
CONV_FACTOR_PRICED_QTY_UOMQuantity Conversion Factor for OTC Transaction UoMTBA_CONV_FACTOR_PRICED_QTY_UOM*UNIT3
IDCFM_USHA_TYPEHaircut Rate TypeIDCFM_USHA_DEL_TYPECHAR1
IDCFM_USHA_PERCPercentage ValueIDCFM_USHA_DEL_PERCDEC10
IDCFM_USHA_TOTAEnter Haircut Amount in PCIDCFM_USHA_DEL_TOTACURR13
IDCFM_USHA_CURRCurrency of Haircut AmountIDCFM_USHA_DEL_CURR*CUKY5
IDCFM_USHA_FORMEuropean Formula CalculationIDCFM_USHA_DEL_FORMCHAR1

Foreign Key Relationships

A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for VTBFHAPO_UNFIXED

Table NameFieldCardinalityCheck Table
VTBFHAPO_UNFIXEDLANDL:T005
VTBFHAPO_UNFIXEDLZBKZ:T015L
VTBFHAPO_UNFIXEDPRICE_CURR_UNIT:TZUNI
VTBFHAPO_UNFIXEDPRICE_UOM:*
VTBFHAPO_UNFIXEDQUOTATION_SOURCE:TRCOCC_QUOTSRC
VTBFHAPO_UNFIXEDQUOTATION_TYPE:TRCOCC_QUOTTYPE
VTBFHAPO_UNFIXEDRAHABKI1: CNT012
VTBFHAPO_UNFIXEDRAHKTID1: CNT012K
VTBFHAPO_UNFIXEDRHANDPL1: CNTWH01
VTBFHAPO_UNFIXEDRREFKONT1: CNT037S
VTBFHAPO_UNFIXEDSABVERFC: CNAT22
VTBFHAPO_UNFIXEDSBERFIMA:AT40
VTBFHAPO_UNFIXEDSBKTYP1: CNAT07
VTBFHAPO_UNFIXEDSBWGARTREFC: CNTZB0A
VTBFHAPO_UNFIXEDSFHAZBA1: CNTZB0A
VTBFHAPO_UNFIXEDSKOART1: CNTZK01
VTBFHAPO_UNFIXEDSKURSART1: CNTW56
VTBFHAPO_UNFIXEDSRUNIT:TZUNI
VTBFHAPO_UNFIXEDSSTORNOART1: CNAT90
VTBFHAPO_UNFIXEDUZAWE1: CNT042F
VTBFHAPO_UNFIXEDWBASIS1: CNTCURC
VTBFHAPO_UNFIXEDWPRICE1: CNTCURC
VTBFHAPO_UNFIXEDWZBETR1: CNTCURC
VTBFHAPO_UNFIXEDZLSCH1: CNT042Z

Other References