VTB_SFHAPO SAP (Forwards: Financial Transaction Flows) Structure details

Dictionary Type: Structure
Description: Forwards: Financial Transaction Flows




ABAP Code to SELECT data from VTB_SFHAPO
Related tables to VTB_SFHAPO
Access table VTB_SFHAPO




Structure field list including key, data, relationships and ABAP select examples

VTB_SFHAPO is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Forwards: Financial Transaction Flows" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_VTB_SFHAPO TYPE VTB_SFHAPO.

The VTB_SFHAPO table consists of various fields, each holding specific information or linking keys about Forwards: Financial Transaction Flows data available in SAP. These include MANDT (Client), BUKRS (Company Code), RFHA (Financial Transaction), RFHAZU (Transaction activity).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP VTB_SFHAPO structure fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3T000MANDT
BUKRSCompany Code BUKRSCHAR4T001BUKRSBUKC_T001
RFHAFinancial Transaction TB_RFHACHAR13VTBFHAALPHAT_RFHAFANVTBA
RFHAZUTransaction activity TB_RFHAZUNUMC5T_RFHAZUFAS
DCRDATEntered On TB_CRDATDATS8DATUM
TCRTIMEntry Time TB_TCRTIMTIMS6UZEIT
RFHAZBTransaction flow TB_RFHAZBNUMC4T_RFHAZB
CRUSEREntered by TB_CRUSERCHAR12SYCHAR12
UPUSERLast Changed by TB_UPUSERCHAR12SYCHAR12
DUPDATChanged on TB_DUPDATDATS8DATUM
TUPTIMTime changed TB_TUPTIMTIMS6UZEIT
RANTYPContract Type RANTYPCHAR1RANTYP
SFHAZBAFlow Type TB_SFHAZBACHAR4Assigned to domainSBEWART
SBKKLASClassification of flows and conditions TB_SBKKLASCHAR1T_SBKKLAS
SBKTYPCategory of Flows and Conditions TB_SBKTYPCHAR2Assigned to domainT_SBKTYP
SBERFIMACalculation category for cash flow calculator SBEWFIMACHAR4Assigned to domainSBEWFIMA
SSIGNDirection of flow TB_SSIGNCHAR1T_SSIGN
SHERKUNFTDisplay Area of Flow or Condition TB_SHERKCHAR4T_XFELD04
SABVERFProcedure to Generate Derived Flows TB_SABVERFCHAR5Assigned to domainT_SABVERF
RKONDGRDirection of Transaction TB_RKONDGRNUMC1T_RKONDGR
RKONDCondition TB_KONDNUMC4T_KOND
DGUEL_KPCondition Item Valid From DGUEL_KPDATS8DATUM
NSTUFELevel number of condition item for recurring payments NSTUFENUMC2NUMC2
SKOARTCondition Type (Smallest Subdivision of Condition Records) SKOARTNUMC4Assigned to domainSKOART
RREFKONTObsolete: Accnt Assignment Ref. in Fin. Assets Management RREFKONT_OBSOLETECHAR8Assigned to domainUSTRUKRE
SBZVABWAlternative payment details stated in flow TB_SBZVABWCHAR1XFELD
RAHABKIShort key for own house bank TB_RHABKICHAR5Assigned to domainHBKID
RAHKTIDShort key for house bank account TB_RHKTIDCHAR5Assigned to domainHKTID
RPZAHLPayer/payee TB_RPZAHL_NEWCHAR10Assigned to domainALPHABU_PARTNERBPABUPA
RPBANKPartner bank details TB_RPBANKCHAR4BVTYP
SZARTPayment transaction TB_SZARTCHAR1XFELD
ZLSCHPayment Method DZLSCHCHAR1Assigned to domainZLSCH
UZAWEPayment Method Supplement UZAWECHAR2Assigned to domainUZAWE
SPAYRQGenerate payment request TB_SPAYRQKCHAR1XFELD
SPRSNGIndividual payment TB_SPRSNGKCHAR1XFELD
SPRGRDDetermine grouping definition TB_SPRGRDCHAR1T_SPRGRD
SCSPAYSame direction necessary for joint payment? TB_SCSPAYCHAR1XFELD
ZWELSList of the Payment Methods to be Considered DZWELSCHAR10ZWELS
PAYGRGrouping Field for Automatic Payments PAYGRCHAR20CHAR20
SBEWEBEPosting Status of Flow TB_SBEWEBECHAR1T_SBEWEBE
SSPRGRDReason Why Flow Is Blocked for Posting TB_SSPRGRDNUMC1T_SSPRGRD
SBFREIRelease Given for Flow to Be Posted? TB_SBFREICHAR1XFELD
SSTORNOBWGFlow reversal in Treasury TB_SBWGSTOCHAR1XFELD
PRKEYKey Number for Payment Request PRQ_KEYNOCHAR10Assigned to domainALPHAPRQ_KEYNO
BELNRAccounting Document Number BELNR_DCHAR10ALPHABELNRBLN
BELNR2Doc. no. of a second accounting doc. for currency swap TB_BELNR2CHAR10ALPHABELNR
GJAHRFiscal Year GJAHRNUMC4GJAHRGJAHRGJR
DBUCHUNGPosting Date in the Document BUDATDATS8DATUM
DFAELLDue date TB_DFAELLDATS8DATUM
DZTERMPayment or Delivery Date TB_DZTERMDATS8DATUMT33
BZBETRPayment amount in payment currency TB_BZBETRCURR13(2) WERTV7
WZBETRPayment Currency TB_WZBETRCUKY5TCURCWAERS
BHWBETRPayment Amount in Local Currency TB_HWBETRCURR13(2) WERTV7
KHWKURSLocal currency rate TB_KHWKURSDEC9(5) EXCRTUKURS
ASTUECKNo. of Units for Financial Instruments TB_ASTUECKDEC15(5) ASTUECK
BPRICEPrice per unit TB_BPRICECURR13(2) WERTV7
WPRICEPrice currency TB_WPRICECUKY5Assigned to domainWAERS
BHWPREISPrice in local currency TB_HWPREISCURR13(2) WERTV7
BINDEXValue of a point TB_BINDEXCURR13(2) BWHR
VVBASISPrice in points TB_VVBASISDEC11(6) T_PKTKUR
PWKURSPrice as percentage quotation TB_PWKURSDEC10(7) DEC3_7
PRKKURSCurrency option premium with price in points TI_PRKURDEC13(9) TB_KKURS
BNWHRNominal amount TB_BNWHRCURR13(2) WERTV7
RHANDPLExchange VVRHANDPLCHAR10Assigned to domainVVRHANDPLWHP
SKURSARTRate/Price Type - Treasury Instruments TI_KURSARTCHAR2Assigned to domainVVSKURSARTRATETYPE_F4
DBERVONStart of Calculation Period DBERVONDATS8DATUM
DBERBISEnd of Calculation Period DBERBISDATS8DATUM
ATAGENumber of days VVATAGENUMC6INT6
ABASTAGENumber of base days in a calculation period ABASTAGENUMC6INT6
PKONDPercentage rate for condition items PKONDDEC10(7) DECV3_7
DPKONDDetermination date for percentage rate of condition items VVDPKONDDATS8DATUM
DZFESTInterest rate fixing date TB_DZFESTDATS8DATUM
SZBMETHInterest Calculation Method SZBMETHCHAR1SZBMETH
SKALIDWTInterest Calendar TFMSKALIDWTCHAR2Assigned to domainWFCIDH_TFACD
BBASISCalculation base amount BBASISCURR13(2) WERTV7
WBASISCurrency of calculation basis TB_WBASISCUKY5TCURCWAERS
JEXPOZINSExponential Interest Calculation TB_JZINSRECHAR1XFELD
SINCLInclusive indicator for beginning and end of a period VVSINCLNUMC1VVSINCL
SINCLBISInclusive Indicator for the End of a Calculation Period VVSINCLBISNUMC1VVSINCLBIS
SULTBISMonth-End Indicator for the End of a Calculation Period VVSULTBISCHAR1VVSULT
SEXCLVONExclusive Indicator for the Start of a Calculation Period VVSEXCLVONNUMC1VVSEXCLVON
SULTVONMonth-End Indicator for Start of a Calculation Period VVSULTVONCHAR1VVSULT
SAENDChange Indicator for FiMa Flow Records TFM_SAENDNUMC1TFM_SAEND
DVALUTCalculation Date DVALUTDATS8DATUM
SVINCLInclusive indicator for value date VVSVINCLNUMC1VVSINCL
SVULTMonth-End Indicator for Value Date VVSVULTCHAR1VVSULT
JSOFVERRIndicator for Immediate Settlement (Financial Mathematics) TFMSOFVERRCHAR1TFMSOFVERR
DVERRECHSettlement date VVDVERRECHDATS8DATUM
SINCLVERRInclusive Indicator for Clearing Date VVSINCLVERNUMC1VVSINCLVER
SULTVERRMonth-End Indicator for Clearing Date VVSULTVERRCHAR1VVSULT
SSTORNOMANManual reversal of flows posted in FI TB_SBWGSTMCHAR1T_SBWGSTM
SSTORNOARTType of manual reversal of flows posted in FI TB_SSTOARTCHAR2Assigned to domainT_SSTOART
SBWGARTREFReferenced flow type TB_SBWGREFCHAR4Assigned to domainSBEWART
SKHWFIXIndicator for translation into local currency TB_SKHWFIXCHAR1T_SKHWFIX
ZUONRAssignment Number DZUONRCHAR18ZUONR
RLDEPOSecurities Account RLDEPOCHAR10Assigned to domainRLDEPODEPACC_CCD_CORE
RANLSecurity ID Number VVRANLWCHAR13Assigned to domainALPHAWP_RANLRANSECURITY_F4
RTRBELNRInternal document number of derivatives document TPM_DEDOC_RDOCNRINTCHAR15ALPHATPM_DEDOC_RDOCNRINT
BUPRCSecurity Price Without Currency Ref. with Unit Quotation TB_BUPRCDEC15(6) VVPKTKUR
BPPRCSecurity Price for Percentage Quotation TB_BPPRCDEC15(6) VVPKTKUR
WBBETRCurrency of Position Amount TB_WBBETRCUKY5Assigned to domainWAERS
BBBETRAmount that Changes the Position TB_BBBETRCURR13(2) WERTV7
WEBETRPrice currency TB_WEBETRCUKY5Assigned to domainWAERS
BEBETRMarket Value in Quotation Currency TB_BEBETRCURR13(2) WERTV7
SRUNITCurrency Unit of the Rate TB_RUNITCHAR5Assigned to domainVVSRUNIT
KZWKURSPayment currency rate TB_KZWKURSDEC9(5) EXCRTUKURS
KBWKURSPosition currency rate TB_KBWKURSDEC9(5) EXCRTUKURS
WSBETRCurrency Key for Currency Conversion: Source Currency TB_WFROMCUKY5Assigned to domainWAERS
DBESTANDPosition Value Date TB_DBESTANDDATS8DATUM
SSTCKKZAccrued interest method SSTCKKZCHAR1SSTCKKZ
SSTCKTGAccrued interest: Daily method SSTCKTGCHAR1SZBMETH
SFLATIndicator 'Traded flat',i.e.no accrued interest calculation VVSFLATCHAR1XFELD
SCOUPONCoupon ID for interest and accrued interest calculation VVSCOUPONCHAR1VVSCOUPON
DCOUPONCoupon date of next delivered coupon VVDCOUPONDATS8DATUM
AWKEYReference Key AWKEYCHAR20AWKEY
INDEX_VALUEIndex Value (Independent of Basis) TIDX_INDEX_VALUE_NO_RATIODEC18(12) TIDX_INDEX_VALUE_NO_RATIO
SBASISCalculation base indicator SBASISCHAR4Assigned to domainVVSBASIS
REGI_STATEStatus of Interest Rate Adjustment TB_IRA_REGISTRATION_STATECHAR2T_IRA_REGISTRATION_STATE
RPCODERepetitive Code RPCODECHAR20Assigned to domainALPHARPCODEFIBL_RPCODE
RP_TEXTReference Text for Repetitive Code RPCODE_TEXTCHAR50XTEXT50
HEDGE_IDIdentification for Hedging Relationship TPM_HEDGE_IDCHAR10
DBPERIODPeriod start VVDBPERIODDATS8DATUM
SPAEXCLExclusive Indicator for Start Date of a Period TFMSPAEXCLNUMC1TFMSPAEXCL
SPAULTMonth-End Indicator for Start Date of a Period TFMSPAULTCHAR1VVSULT
DEPERIODPeriod End VVDEPERIODDATS8DATUM
SPEINCLInclusive Indicator for End Date of a Period TFMSPEINCLNUMC1TFMSPEINCL
SPEULTMonth-End Indicator for End of a Period TFMSPEULTCHAR1VVSULT
AMMRHYFrequency in months AMMRHYNUMC3NUMC03
PPAYMENTPayment Rate TFM_PPAYMENTDEC11(7) TFM_PPAYMENT
AMMRHYZVInterest Settlement Frequency for Exponential Interest Calc. TFM_AMMRHYZVNUMC2TFM_AMMRHYZV
LZBKZState Central Bank Indicator LZBKZCHAR3T015LLZBKZ
LANDLSupplying Country LANDLCHAR3T005LAND1
BDIRTYDirty Price TB_BDIRTYCURR13(2) WERTV7
BAMOUNTCOMPAmount to be Capitalized TB_AMOUNTCOMPCURR13(2) WERTV7
NOMINAL_ORG_AMTOrignal Nominal Amount TB_BNWHR_ORGCURR13(2) WERTV7
NOM_FACTORFactor RDPT_FACTOR_VALDEC12(9)
RLDEPO2Securities Account VRLDEPOCHAR10Assigned to domainRLDEPODEP
INDEX_PRICEIndicator: Security Price Including Price Index Value TB_INDEX_PRICECHAR1CHAR1
FLOWUUIDTransaction Flow UUID TB_FLOWUUIDRAW16UUID
FLAGBYTE1Indicator for Financial Transaction Flow (See Documentation) TB_FLAGBYTE1RAW1
QUANTITYQuantity FTR_QUANQUAN13(3) FTR_QUAN
UNIT_OF_MEASUREUnit of Measure for the Commodity TPM_CTY_UOMUNIT3Assigned to domainCUNITMEINS
CONTRACT_PRICECommodity Price FTR_COMPRICEDEC13(5) FTR_COMPRICE
SPOT_PRICECommodity Spot Price FTR_COMSPOTDEC13(5) FTR_COMPRICE
CONTANGO_BACKWRDCommodity Contango / Backwardation FTR_CONBACKDEC13(5) FTR_COMPRICE
BPRC_SPOT1Current Spot Rate in Percentage TB_BPPRC_SPOT1DEC15(6) VVPKTKUR
BPRC_SPOT2Spot Rate at Maturity in Percentage TB_BPPRC_SPOT_MATDEC15(6) VVPKTKUR
COST_FWDForward Rate Cost TB_COSTFWDDEC15(6) VVPKTKUR
INTEREST_FWDForward Rate Interest TB_INTERESTFWDDEC15(6) DECV9_6
REF_FLOWUUIDFlow Reference (UUID) TB_REFFLOWUUIDRAW16UUID
RGATTClass TI_RGATTCHAR13ALPHAT_RGATTT04
COMMODITY_IDCommodity ID TRCO_COMM_IDCHAR18TPM_CTY_IDCOMMODITY_IDF4_CTY_ID_CORE
QUOTATION_NAMEQuotation Name CPET_QUOTNAMECHAR18CPE_QUOTNAMECPE_QUOTNAME
QUOTATION_SOURCEQuotation Source TCR_CTY_QUOTSRCCHAR2TRCOCC_QUOTSRCTCR_CTY_QUOTSRC
QUOTATION_TYPECommodity Quotation Type TCR_CTY_QUOTTYPECHAR5TRCOCC_QUOTTYPETCR_CTY_QUOTTYPE
SPREADCommodity Spread FTR_COMSPREADDEC13(5) FTR_COMPRICE
PRICE_CURR_UNITCurrency Unit of the Rate TB_RUNITCHAR5TZUNIVVSRUNIT
PRICE_UOMUnit of Measure for the Commodity TPM_CTY_UOMUNIT3Assigned to domainCUNITMEINS
DIV_PCTC_OTCPercentage of Dividend agreed for Payment in OTC Instruments TB_DIV_PCTC_OTCDEC7(4) T_DIV_PCTC_OTC
TAINTEDManipulated Cash Flow TB_TAINTED_CASHFLOWCHAR1TB_TAINTED_CASHFLOW
CLEAREDClearing at Flow Level FTR_FLOW_CLEAREDCHAR1FTR_FLOW_CLEARED
DCSIDDerivative Contract Specification ID TBA_DCSIDCHAR6Assigned to domainTBA_DCSIDTBA_DCSIDTBAH_DCS
MICMarket Identifier Code TBA_MICCHAR4Assigned to domainTBA_MICTBA_MICTBAH_MIC
PRICE_TYPEType of Price Quotation TBA_PRICETYPECHAR2Assigned to domainVVSKURSARTRATETYPE_F4
TIME_TO_MATURITYTime to Maturity TBA_TENORCHAR10Assigned to domainTBA_TENORTBAH_TENOR
EXCH_RATE_TYPEExchange Rate Type KURST_CURRCHAR4Assigned to domainKURST
PRICE_PAYM_CURRCommodity Price in Payment Currency FTR_COMPRICE_PAYMENT_CURRDEC13(5) FTR_COMPRICE
SPREAD_PAYM_CURRCommodity Spread in Payment Currency FTR_COMSPREAD_PAYMENT_CURRDEC13(5) FTR_COMPRICE
FX_TRANSLATIONDefines when quotation crcy is converted into payment crcy FTR_CURRENCY_CONV_POINT_IN_TIMCHAR1FTR_CURRENCY_CONV_POINT_IN_TIM
MNDIDUnique Referene to Mandate per Payment Recipient SEPA_MNDIDCHAR35ID035
.INCLU--AP 0
IDCFM_USHA_TYPEHaircut Rate Type IDCFM_USHA_DEL_TYPECHAR1IDCFM_USHA_DOM_TYPE
IDCFM_USHA_PERCPercentage Value IDCFM_USHA_DEL_PERCDEC10(7) DECV3_7
IDCFM_USHA_TOTAEnter Haircut Amount in PC IDCFM_USHA_DEL_TOTACURR13(2) WERTV7
IDCFM_USHA_CURRCurrency of Haircut Amount IDCFM_USHA_DEL_CURRCUKY5Assigned to domainWAERS
IDCFM_USHA_FORMEuropean Formula Calculation IDCFM_USHA_DEL_FORMCHAR1IDCFM_USHA_DOM_FORM
XZTERMPayment date TM_XZTERMCHAR10T_XDATUM
XZBETRPayment Amount in Payment Currency as Text Field TB_XPAYM_AMT_ZWCHAR18T_XBETRG18
DBESTANDXPosition Date of Bond as Underlying of a Forward TB_XDBESTANDBCHAR10T_XDATUM
DVALUTXCalculation date TB_DVALUTXCHAR10T_XDATUM
BMARGINMargin Amount in Nominal Currency TB_MARGIN_AMTCURR13(2) WERTV7
XNWHRNominal Amount in Issue Currency TB_XNOM_FWCHAR18T_XBETRG18
XBSPOTSpot Price Amount in Issue Currency TB_XSPOT_FWCHAR18T_XBETRG18
BSPOTSpot Price Amount in Issue Currency TB_SPOT_FWCURR13(2) WERTV7
SPOTRATESpot Rate in Percentage TB_SPOTRATEDEC10(7) DEC3_7
BFORWForward Price in Issue Currency TB_FORW_FWCURR13(2) WERTV7
WHWBETRLocal currency TB_WHWBETRCUKY5Assigned to domainWAERS
XBBETRAmount as text field TM_XBETRAGCHAR18T_XBETRG18
XBEWARTName of flow type XBEWARTCHAR30TEXT30
SSELECTEDCheckbox XFELDCHAR1XFELD
XPRICEAmount as text field TM_XBETRAGCHAR18T_XBETRG18
XSTORNOARTName of manual reversal type for posted flows TB_XSTOARTCHAR30TEXT30
XKALIDWTName of interest rate calendar TB_XKALIDWTCHAR60TEXT60
XINCLIndicator date inclusive VVXINCLCHAR1XFELD
KZWKURS_FROMCurrency Key for Currency Conversion: Source Currency TB_WFROMCUKY5Assigned to domainWAERS
KZWKURS_TOCurrency key for curreny conversion: Target currency TB_WTOCUKY5Assigned to domainWAERS
KHWKURS_FROMCurrency Key for Currency Conversion: Source Currency TB_WFROMCUKY5Assigned to domainWAERS
KHWKURS_TOCurrency key for curreny conversion: Target currency TB_WTOCUKY5Assigned to domainWAERS
KBWKURS_FROMCurrency Key for Currency Conversion: Source Currency TB_WFROMCUKY5Assigned to domainWAERS
KBWKURS_TOCurrency key for curreny conversion: Target currency TB_WTOCUKY5Assigned to domainWAERS
XHBETRAmount as text field TM_XBETRAGCHAR18T_XBETRG18
XEBETRAmount as text field TM_XBETRAGCHAR18T_XBETRG18
XFLG_DEALFLOWCheckbox XFELDCHAR1XFELD
WZBETR_NEWPayment Currency TB_WZBETRCUKY5Assigned to domainWAERS
SRUNIT_NEWCurrency Unit of the Rate TB_RUNITCHAR5Assigned to domainVVSRUNIT
DEFECT_RATENegative interest rate DEFECTRATEDEC10(7) DECV3_7
DEFECT_RATE_NEWNegative interest rate DEFECTRATEDEC10(7) DECV3_7
ZUONR_NEWAssignment Number DZUONRCHAR18ZUONR
INDEX_VALUE_PIndex Value (Independent of Basis) TIDX_INDEX_VALUE_NO_RATIODEC18(12) TIDX_INDEX_VALUE_NO_RATIO
INDEX_VALUE_UIndex Value (Independent of Basis) TIDX_INDEX_VALUE_NO_RATIODEC18(12) TIDX_INDEX_VALUE_NO_RATIO
BPRC_SPOT1_PERCurrent Spot Rate, Percentage Quotation TB_BPPRC_SPOT1_PERDEC15(6) VVPKTKUR
BPRC_SPOT1_CURRCurrent Spot Rate, Unit Quotation TB_BPPRC_SPOT1_CURRDEC15(6) VVPKTKUR
BPRC_SPOT2_PERSpot Rate At Maturity, Percentage Quotation TB_BPPRC_SPOT_MAT_PERDEC15(6) VVPKTKUR
BPRC_SPOT2_CURRSpot Rate At Maturity, Unit Quotation TB_BPPRC_SPOT_MAT_CURRDEC15(6) VVPKTKUR
COST_FWD_PERForward Rate Cost, Percentage Quotation TB_COSTFWD_PERDEC15(6) VVPKTKUR
COST_FWD_CURRForward Rate Cost, Unit Quotation TB_COSTFWD_CURRDEC15(6) VVPKTKUR
INTEREST_FWD_PERForward Rate Interest, Percentage Quotation TB_INTERESTFWD_PERDEC15(6) DECV9_6
INTEREST_FWD_CURRForward Rate Interest, Unit Quotation TB_INTERESTFWD_CURRDEC15(6) DECV9_6
SRUNIT_COSTCurrency Unit of the Rate TB_RUNITCHAR5Assigned to domainVVSRUNIT
SRUNIT_INTCurrency Unit of the Rate TB_RUNITCHAR5Assigned to domainVVSRUNIT
SFHAZBA_RFlow Type TB_SFHAZBACHAR4Assigned to domainSBEWART
XBEWART_RName of flow type XBEWARTCHAR30TEXT30
BPPRC_RSecurity Price for Percentage Quotation TB_BPPRCDEC15(6) VVPKTKUR
BUPRC_RSecurity Price Without Currency Ref. with Unit Quotation TB_BUPRCDEC15(6) VVPKTKUR
SRUNIT_RCurrency Unit of the Rate TB_RUNITCHAR5Assigned to domainVVSRUNIT
DBESTANDX_RPosition Date of Bond as Underlying of a Forward TB_XDBESTANDBCHAR10T_XDATUM
DBESTAND_RPosition Value Date TB_DBESTANDDATS8DATUM
DVALUTX_RCalculation date TB_DVALUTXCHAR10T_XDATUM
DVALUT_RCalculation Date DVALUTDATS8DATUM
XZTERM_RPayment or Delivery Date TB_XZTERMCHAR10T_XDATUM
DZTERM_RPayment or Delivery Date TB_DZTERMDATS8DATUMT33
XEBETR_RAmount as text field TM_XBETRAGCHAR18T_XBETRG18
BEBETR_RMarket Value in Quotation Currency TB_BEBETRCURR13(2) WERTV7
WEBETR_RPrice currency TB_WEBETRCUKY5Assigned to domainWAERS
XZBETR_RPayment amount TB_XZBETRCHAR18T_XBETR
BZBETR_RPayment amount in payment currency TB_BZBETRCURR13(2) WERTV7
WZBETR_RPayment Currency TB_WZBETRCUKY5Assigned to domainWAERS
XHBETR_RAmount as text field TM_XBETRAGCHAR18T_XBETRG18
BHWBETR_RPayment Amount in Local Currency TB_HWBETRCURR13(2) WERTV7
WHWBETR_RLocal currency TB_WHWBETRCUKY5Assigned to domainWAERS
XBBETR_RAmount as text field TM_XBETRAGCHAR18T_XBETRG18
BBBETR_RAmount that Changes the Position TB_BBBETRCURR13(2) WERTV7
WBBETR_RCurrency of Position Amount TB_WBBETRCUKY5Assigned to domainWAERS
KZWKURS_RPayment currency rate TB_KZWKURSDEC9(5) EXCRTUKURS
KZWKURS_FROM_RCurrency Key for Currency Conversion: Source Currency TB_WFROMCUKY5Assigned to domainWAERS
KZWKURS_TO_RCurrency key for curreny conversion: Target currency TB_WTOCUKY5Assigned to domainWAERS
KHWKURS_RLocal currency rate TB_KHWKURSDEC9(5) EXCRTUKURS
KHWKURS_FROM_RCurrency Key for Currency Conversion: Source Currency TB_WFROMCUKY5Assigned to domainWAERS
KHWKURS_TO_RCurrency key for curreny conversion: Target currency TB_WTOCUKY5Assigned to domainWAERS
KBWKURS_RPosition currency rate TB_KBWKURSDEC9(5) EXCRTUKURS
KBWKURS_FROM_RCurrency Key for Currency Conversion: Source Currency TB_WFROMCUKY5Assigned to domainWAERS
KBWKURS_TO_RCurrency key for curreny conversion: Target currency TB_WTOCUKY5Assigned to domainWAERS
SBKTYP_RCategory of Flows and Conditions TB_SBKTYPCHAR2Assigned to domainT_SBKTYP
SSIGN_RDirection of flow TB_SSIGNCHAR1T_SSIGN
SHERKUNFT_RDisplay Area of Flow or Condition TB_SHERKCHAR4T_XFELD04
ASTUECK_RNumber of units for unit-quoted securities ASTUECKDEC15(5) ASTUECK
XNWHR_RNominal Amount in Issue Currency TB_XNOM_FWCHAR18T_XBETRG18
BNWHR_RNominal amount TB_BNWHRCURR13(2) WERTV7
SBKKLAS_RClassification of flows and conditions TB_SBKKLASCHAR1T_SBKKLAS
SBERFIMA_RCalculation category for cash flow calculator SBEWFIMACHAR4Assigned to domainSBEWFIMA
RFHAZU_RTransaction activity TB_RFHAZUNUMC5T_RFHAZUFAS
RFHAZB_RTransaction flow TB_RFHAZBNUMC4T_RFHAZB
DCRDAT_REntered On TB_CRDATDATS8DATUM
TCRTIM_REntry Time TB_TCRTIMTIMS6UZEIT
CRUSER_REntered by TB_CRUSERCHAR12SYCHAR12
UPUSER_RLast Changed by TB_UPUSERCHAR12SYCHAR12
DUPDAT_RChanged on TB_DUPDATDATS8DATUM
TUPTIM_RTime changed TB_TUPTIMTIMS6UZEIT
RANTYP_RContract Type RANTYPCHAR1RANTYP
SABVERF_RProcedure to Generate Derived Flows TB_SABVERFCHAR5Assigned to domainT_SABVERF
RKONDGR_RDirection of Transaction TB_RKONDGRNUMC1T_RKONDGR
RKOND_RCondition TB_KONDNUMC4T_KOND
DGUEL_KP_RCondition Item Valid From DGUEL_KPDATS8DATUM
NSTUFE_RLevel number of condition item for recurring payments NSTUFENUMC2NUMC2
SKOART_RCondition Type (Smallest Subdivision of Condition Records) SKOARTNUMC4Assigned to domainSKOART
RREFKONT_RObsolete: Accnt Assignment Ref. in Fin. Assets Management RREFKONT_OBSOLETECHAR8Assigned to domainUSTRUKRE
SBZVABW_RAlternative payment details stated in flow TB_SBZVABWCHAR1XFELD
RAHABKI_RShort key for own house bank TB_RHABKICHAR5Assigned to domainHBKID
RAHKTID_RShort key for house bank account TB_RHKTIDCHAR5Assigned to domainHKTID
RPZAHL_RPayer/payee TB_RPZAHL_NEWCHAR10Assigned to domainALPHABU_PARTNERBPABUPA
RPBANK_RPartner bank details TB_RPBANKCHAR4BVTYP
SZART_RPayment transaction TB_SZARTCHAR1XFELD
ZLSCH_RPayment Method DZLSCHCHAR1Assigned to domainZLSCH
UZAWE_RPayment Method Supplement UZAWECHAR2Assigned to domainUZAWE
SPAYRQ_RGenerate payment request TB_SPAYRQKCHAR1XFELD
SPRSNG_RIndividual payment TB_SPRSNGKCHAR1XFELD
SPRGRD_RDetermine grouping definition TB_SPRGRDCHAR1T_SPRGRD
SCSPAY_RSame direction necessary for joint payment? TB_SCSPAYCHAR1XFELD
ZWELS_RList of the Payment Methods to be Considered DZWELSCHAR10ZWELS
PAYGR_RGrouping Field for Automatic Payments PAYGRCHAR20CHAR20
SBEWEBE_RPosting Status of Flow TB_SBEWEBECHAR1T_SBEWEBE
SSPRGRD_RReason Why Flow Is Blocked for Posting TB_SSPRGRDNUMC1T_SSPRGRD
SBFREI_RRelease Given for Flow to Be Posted? TB_SBFREICHAR1XFELD
SSTORNOBWG_RFlow reversal in Treasury TB_SBWGSTOCHAR1XFELD
PRKEY_RKey Number for Payment Request PRQ_KEYNOCHAR10Assigned to domainALPHAPRQ_KEYNO
BELNR_RAccounting Document Number BELNR_DCHAR10ALPHABELNRBLN
BELNR2_RDoc. no. of a second accounting doc. for currency swap TB_BELNR2CHAR10ALPHABELNR
GJAHR_RFiscal Year GJAHRNUMC4GJAHRGJAHRGJR
DBUCHUNG_RPosting Date in the Document BUDATDATS8DATUM
DFAELL_RDue date TB_DFAELLDATS8DATUM
BPRICE_RPrice per unit TB_BPRICECURR13(2) WERTV7
WPRICE_RPrice currency TB_WPRICECUKY5Assigned to domainWAERS
BHWPREIS_RPrice in local currency TB_HWPREISCURR13(2) WERTV7
BINDEX_RValue of a point TB_BINDEXCURR13(2) BWHR
VVBASIS_RPrice in points TB_VVBASISDEC11(6) T_PKTKUR
PWKURS_RPrice as percentage quotation TB_PWKURSDEC10(7) DEC3_7
PRKKURS_RCurrency option premium with price in points TI_PRKURDEC13(9) TB_KKURS
RHANDPL_RExchange VVRHANDPLCHAR10Assigned to domainVVRHANDPLWHP
SKURSART_RRate/Price Type - Treasury Instruments TI_KURSARTCHAR2Assigned to domainVVSKURSARTRATETYPE_F4
DBERVON_RStart of Calculation Period DBERVONDATS8DATUM
DBERBIS_REnd of Calculation Period DBERBISDATS8DATUM
ATAGE_RNumber of days VVATAGENUMC6INT6
ABASTAGE_RNumber of base days in a calculation period ABASTAGENUMC6INT6
PKOND_RPercentage rate for condition items PKONDDEC10(7) DECV3_7
DPKOND_RDetermination date for percentage rate of condition items VVDPKONDDATS8DATUM
DZFEST_RInterest rate fixing date TB_DZFESTDATS8DATUM
SZBMETH_RInterest Calculation Method SZBMETHCHAR1SZBMETH
SKALIDWT_RInterest Calendar TFMSKALIDWTCHAR2Assigned to domainWFCIDH_TFACD
BBASIS_RCalculation base amount BBASISCURR13(2) WERTV7
WBASIS_RCurrency of calculation basis TB_WBASISCUKY5Assigned to domainWAERS
JEXPOZINS_RExponential Interest Calculation TB_JZINSRECHAR1XFELD
SINCL_RInclusive indicator for beginning and end of a period VVSINCLNUMC1VVSINCL
SINCLBIS_RInclusive Indicator for the End of a Calculation Period VVSINCLBISNUMC1VVSINCLBIS
SULTBIS_RMonth-End Indicator for the End of a Calculation Period VVSULTBISCHAR1VVSULT
SEXCLVON_RExclusive Indicator for the Start of a Calculation Period VVSEXCLVONNUMC1VVSEXCLVON
SULTVON_RMonth-End Indicator for Start of a Calculation Period VVSULTVONCHAR1VVSULT
SAEND_RChange Indicator for FiMa Flow Records TFM_SAENDNUMC1TFM_SAEND
SVINCL_RInclusive indicator for value date VVSVINCLNUMC1VVSINCL
SVULT_RMonth-End Indicator for Value Date VVSVULTCHAR1VVSULT
JSOFVERR_RIndicator for Immediate Settlement (Financial Mathematics) TFMSOFVERRCHAR1TFMSOFVERR
DVERRECH_RSettlement date VVDVERRECHDATS8DATUM
SINCLVERR_RInclusive Indicator for Clearing Date VVSINCLVERNUMC1VVSINCLVER
SULTVERR_RMonth-End Indicator for Clearing Date VVSULTVERRCHAR1VVSULT
SSTORNOMAN_RManual reversal of flows posted in FI TB_SBWGSTMCHAR1T_SBWGSTM
SSTORNOART_RType of manual reversal of flows posted in FI TB_SSTOARTCHAR2Assigned to domainT_SSTOART
SBWGARTREF_RReferenced flow type TB_SBWGREFCHAR4Assigned to domainSBEWART
SKHWFIX_RIndicator for translation into local currency TB_SKHWFIXCHAR1T_SKHWFIX
ZUONR_RAssignment Number DZUONRCHAR18ZUONR
RLDEPO_RSecurities Account RLDEPOCHAR10Assigned to domainRLDEPODEPACC_CCD_CORE
RANL_RSecurity ID Number VVRANLWCHAR13Assigned to domainALPHAWP_RANLRANSECURITY_F4
RTRBELNR_RInternal document number of derivatives document TPM_DEDOC_RDOCNRINTCHAR15ALPHATPM_DEDOC_RDOCNRINT
WSBETR_RCurrency Key for Currency Conversion: Source Currency TB_WFROMCUKY5Assigned to domainWAERS
SSTCKKZ_RAccrued interest method SSTCKKZCHAR1SSTCKKZ
SSTCKTG_RAccrued interest: Daily method SSTCKTGCHAR1SZBMETH
SFLAT_RIndicator 'Traded flat',i.e.no accrued interest calculation VVSFLATCHAR1XFELD
SCOUPON_RCoupon ID for interest and accrued interest calculation VVSCOUPONCHAR1VVSCOUPON
DCOUPON_RCoupon date of next delivered coupon VVDCOUPONDATS8DATUM
AWKEY_RReference Key AWKEYCHAR20AWKEY
INDEX_VALUE_RIndex Value (Independent of Basis) TIDX_INDEX_VALUE_NO_RATIODEC18(12) TIDX_INDEX_VALUE_NO_RATIO
SBASIS_RCalculation base indicator SBASISCHAR4Assigned to domainVVSBASIS
REGI_STATE_RRepetitive Code RPCODECHAR20Assigned to domainALPHARPCODEFIBL_RPCODE
RPCODE_RRepetitive Code RPCODECHAR20Assigned to domainALPHARPCODEFIBL_RPCODE
RP_TEXT_RReference Text for Repetitive Code RPCODE_TEXTCHAR50XTEXT50
HEDGE_ID_RIdentification for Hedging Relationship TPM_HEDGE_IDCHAR10
XINCL_RIndicator date inclusive VVXINCLCHAR1XFELD
XASTUECKNumber of Units as Text TB_XUNITSCHAR20T_XUNITS20
.INCLU--AP 0
IDCFM_USHA_FIXHaircut Percentage IDCFM_USHA_DEL_FIXCHAR1XFELD
IDCFM_USHA_AMOHaircut Amount in PC IDCFM_USHA_DEL_AMOCHAR1XFELD
IDCFM_USHA_TOTATHaircut Amount in PC IDCFM_USHA_DEL_TOTATCHAR18T_XBETRG18
IDCFM_USHA_PERCTPercentage Value IDCFM_USHA_DEL_PERCDEC10(7) DECV3_7
IDCFM_USHA_CURRTCurrency of Haircut Amount IDCFM_USHA_DEL_CURRCUKY5Assigned to domainWAERS

Key field Non-key field



How do I retrieve data from SAP structure VTB_SFHAPO using ABAP code?

As VTB_SFHAPO is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on VTB_SFHAPO as there is no data to select.

How to access SAP table VTB_SFHAPO

Within an ECC or HANA version of SAP you can also view further information about VTB_SFHAPO and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!