VTBFHAPO
Transaction Flow
VTBFHAPO is an SAP database table in S/4HANA. Transaction Flow. It contains 241 fields. 13 CDS views read from this table.
CDS Views using this table (13)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_BrkrRecnclnTransFlowActivity | view | from | BASIC | Financial Transaction Flow |
| I_CmmdtyFinTransactionFlow | view | from | BASIC | Commodity Financial Transaction Flows |
| I_CmmdtyHdgTrdOrdTransFlowDet | view | from | BASIC | Commodity Hedge Constellation Deal Flow Details |
| I_CmmdtyHedgeTransactionFlow | view | from | BASIC | Financial Transaction flow details |
| P_CmmdtyHedgeTransFlowDetails | view | from | BASIC | Commodity Hedge Constellation Designated |
| P_FXTransactionNominal | view | inner | BASIC | |
| R_FinTransFlow | view | from | BASIC | Financial Transaction Flow |
| R_FinTransSecurityPaytFlow | view | from | BASIC | Fin Trans Security Payment Flow |
| R_FinTransSecurityQuantityFlow | view | from | BASIC | Fin Trans Security Quantity Flow |
| TOE_CDS_TRM_DEALS | view | inner | cds view for deal nominals in TOENE | |
| toe_cds_trm_deals_rfc | view_entity | inner | View for Deal Nominals with RiskFreeCurr | |
| toe_cds_trm_exp_deals | view_entity | inner | Deal Selection for OTC Exposures | |
| toe_cds_trm_exp_deals_rfc | view_entity | inner | OTC Exposures with Risk-Free Currency |
Fields (241)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | MANDT | Client | |||
| KEY | bukrs | BUKRS | Company Code | |||
| KEY | rfha | TB_RFHA | Transaction | |||
| KEY | rfhazu | TB_RFHAZU | Activity | |||
| KEY | dcrdat | TB_CRDAT | Entry Date | |||
| KEY | tcrtim | TB_TCRTIM | Entry Time | |||
| KEY | rfhazb | TB_RFHAZB | Flow | |||
| cruser | TB_CRUSER | Entered By | ||||
| upuser | TB_UPUSER | Changed By | ||||
| dupdat | TB_DUPDAT | Changed On | ||||
| tuptim | TB_TUPTIM | Time Changed | ||||
| rantyp | RANTYP | Contract Type | ||||
| sfhazba | TB_SFHAZBA | Flow Type | ||||
| sbkklas | TB_SBKKLAS | Classification | ||||
| sbktyp | TB_SBKTYP | Category | ||||
| sberfima | SBEWFIMA | Calc. Category | ||||
| ssign | TB_SSIGN | Direction | ||||
| sherkunft | TB_SHERK | Source | ||||
| sabverf | TB_SABVERF | Deriv.Procedure | ||||
| rkondgr | TB_RKONDGR | Direction | ||||
| rkond | TB_KOND | Condition | ||||
| dguel_kp | DGUEL_KP | Item Eff. From | ||||
| nstufe | NSTUFE | Level Number | ||||
| skoart | SKOART | Condition Type | ||||
| rrefkont | RREFKONT_OBSOLETE | Acct Assign.Ref | ||||
| sbzvabw | TB_SBZVABW | Alt.Pay.Details | ||||
| rahabki | TB_RHABKI | House Bank | ||||
| rahktid | TB_RHKTID | House Bank Acct | ||||
| rpzahl | TB_RPZAHL_NEW | Payer/Payee | ||||
| rpbank | TB_RPBANK | Partner Bank | ||||
| szart | TB_SZART | Pmnt Transact. | ||||
| zlsch | DZLSCH | Pymt Meth. | ||||
| uzawe | UZAWE | Pmnt Meth. Sup. | ||||
| spayrq | TB_SPAYRQK | Payment Request | ||||
| sprsng | TB_SPRSNGK | Individual Pmnt | ||||
| sprgrd | TB_SPRGRD | Group Determ. | ||||
| scspay | TB_SCSPAY | Same Direction | ||||
| zwels | DZWELS | Payment Methods | ||||
| paygr | PAYGR | Grouping | ||||
| sbewebe | TB_SBEWEBE | Posting Status | ||||
| ssprgrd | TB_SSPRGRD | Blocking Reason | ||||
| sbfrei | TB_SBFREI | Posting Release | ||||
| sstornobwg | TB_SBWGSTO | Flow Reversal | ||||
| prkey | PRQ_KEYNO | Key Number | ||||
| belnr | BELNR_D | Document Number | ||||
| belnr2 | TB_BELNR2 | JE No. 2 | ||||
| gjahr | GJAHR | Fiscal Year | ||||
| dbuchung | BUDAT | Posting Date | ||||
| dfaell | TB_DFAELL | Due Date | ||||
| dzterm | TB_DZTERM | Payment Date | ||||
| bzbetr | TB_BZBETR | Payment Amnt in PyC | ||||
| wzbetr | TB_WZBETR | Payment Currency | ||||
| bhwbetr | TB_HWBETR | Pmnt Amnt in LCurr | ||||
| khwkurs | TB_KHWKURS | Local Crcy Rate | ||||
| astueck | TB_ASTUECK_L | Number of Units | ||||
| bprice | TB_BPRICE | Price per Unit | ||||
| wprice | TB_WPRICE | Price Currency | ||||
| bhwpreis | TB_HWPREIS | Loc.Curr.Price | ||||
| bindex | TB_BINDEX | Point Value | ||||
| vvbasis | TB_VVBASIS | Price Points | ||||
| pwkurs | TB_PWKURS | PercentagePrice | ||||
| prkkurs | TI_PRKUR | Price in Points | ||||
| bnwhr | TB_BNWHR | Nominal Amnt | ||||
| rhandpl | VVRHANDPL | Exchange | ||||
| skursart | TI_KURSART | Rate/Price Type | ||||
| dbervon | DBERVON | CalculationFrom | ||||
| dberbis | DBERBIS | Calculation To | ||||
| atage | VVATAGE | Number of Days | ||||
| abastage | ABASTAGE | No. base days | ||||
| pkond | PKOND | Percentage Rate | ||||
| dpkond | VVDPKOND | Perc Fixing Dte | ||||
| dzfest | TB_DZFEST | Int.Fixing Date | ||||
| szbmeth | SZBMETH | Int.calc.method | ||||
| skalidwt | TFMSKALIDWT | Int. Calendar | ||||
| bbasis | BBASIS | Base Amount | ||||
| wbasis | TB_WBASIS | Calc.Basis Crcy | ||||
| jexpozins | TFM_SINTCOMP | Exponential | ||||
| sincl | VVSINCL | Inclusive Ind. | ||||
| sinclbis | VVSINCLBIS | Incl. End Date | ||||
| sultbis | VVSULTBIS | Month-End EndDt | ||||
| sexclvon | VVSEXCLVON | Exclusive Start | ||||
| sultvon | VVSULTVON | Mth-End StartDt | ||||
| saend | TFM_SAEND | Change ID | ||||
| dvalut | DVALUT | Calculat. date | ||||
| svincl | VVSVINCL | Inclusive_valDt | ||||
| svult | VVSVULT | Mon-End Val.Dte | ||||
| jsofverr | TFMSOFVERR | Immed.Settlemnt | ||||
| dverrech | VVDVERRECH | Settlem. date | ||||
| sinclverr | VVSINCLVER | Incl. Clrg Date | ||||
| sultverr | VVSULTVERR | MnthEndClearing | ||||
| sstornoman | TB_SBWGSTM | Manual Reversal | ||||
| sstornoart | TB_SSTOART | Reversal Type | ||||
| sbwgartref | TB_SBWGREF | Ref. Flow Type | ||||
| skhwfix | TB_SKHWFIX | Translation->LC | ||||
| zuonr | DZUONR | Assignment | ||||
| rldepo | RLDEPO | Securities Acct | ||||
| ranl | VVRANLW | Security Class | ||||
| rtrbelnr | TPM_DEDOC_RDOCNRINT | InternalDoc.No. | ||||
| buprc | TB_BUPRC_L | Price(UnitQuot) | ||||
| bpprc | TB_BPPRC_L | Price (%) | ||||
| wbbetr | TB_WBBETR | Position Crcy | ||||
| bbbetr | TB_BBBETR | Amt in Pos.Crcy | ||||
| webetr | TB_WEBETR | Price Currency | ||||
| bebetr | TB_BEBETR | Mkt Val. in QC | ||||
| srunit | TB_RUNIT | Currency Unit | ||||
| kzwkurs | TB_KZWKURS | PC Rate | ||||
| kbwkurs | TB_KBWKURS | PositionCurrRte | ||||
| wsbetr | TB_WFROM | Source Currency | ||||
| dbestand | TB_DBESTAND | Position Value Date | ||||
| sstckkz | SSTCKKZ | Acc.int.meth. | ||||
| sstcktg | SSTCKTG | Daily Method | ||||
| sflat | VVSFLAT | Traded flat | ||||
| scoupon | VVSCOUPON | Coupon | ||||
| dcoupon | VVDCOUPON | Coupon date | ||||
| awkey | AWKEY | Reference Key | ||||
| index_value | TIDX_INDEX_VALUE_NO_RATIO | Value W/o Basis | ||||
| sbasis | SBASIS | Calculat. Base | ||||
| regi_state | TB_IRA_REGISTRATION_STATE | Status | ||||
| rpcode | RPCODE | Repetitive Code | ||||
| rp_text | RPCODE_TEXT | Reference Text | ||||
| hedge_id | TPM_HEDGE_ID | Hedge ID | ||||
| dbperiod | VVDBPERIOD | Period start | ||||
| spaexcl | TFMSPAEXCL | Exclusive Start | ||||
| spault | TFMSPAULT | MonEndIndStPer | ||||
| deperiod | VVDEPERIOD | Period end | ||||
| speincl | TFMSPEINCL | InclusiveEndPer | ||||
| speult | TFMSPEULT | MthEndPerEnd | ||||
| ammrhy | AMMRHY | Freq. in months | ||||
| ppayment | TFM_PPAYMENT | Payment Rate | ||||
| ammrhyzv | TFM_AMMRHYZV | Int.Sttlm.Freq | ||||
| lzbkz | LZBKZ | SCB Ind. | ||||
| landl | LANDL | Supply C/R | ||||
| bdirty | TB_BDIRTY | Dirty Price | ||||
| bamountcomp | TB_AMOUNTCOMP | Cap. Amnt | ||||
| nominal_org_amt | TB_BNWHR_ORG | Orig. Nominal Amount | ||||
| nom_factor | RDPT_FACTOR_VAL | Factor | ||||
| rldepo2 | VRLDEPO | Securities Acct | ||||
| index_price | TB_INDEX_PRICE | Price incl. Index | ||||
| flowuuid | TB_FLOWUUID | Flow UUID | ||||
| flagbyte1 | TB_FLAGBYTE1 | Flag Byte 1 | ||||
| quantity | FTR_QUAN | Qty | ||||
| unit_of_measure | TPM_CTY_UOM | Unit of Measure | ||||
| contract_price | FTR_COMPRICE | Price | ||||
| spot_price | FTR_COMSPOT | SpotPrice | ||||
| contango_backwrd | FTR_CONBACK | Comm Contg | ||||
| bprc_spot1 | TB_BPPRC_SPOT1_L | Spot 1 | ||||
| bprc_spot2 | TB_BPPRC_SPOT_MAT_L | SpotRate at Mat | ||||
| cost_fwd | TB_COSTFWD | Cost | ||||
| interest_fwd | TB_INTERESTFWD | Interest | ||||
| ref_flowuuid | TB_REFFLOWUUID | Reference UUID | ||||
| rgatt | TI_RGATT | Class | ||||
| commodity_id | TRCO_COMM_ID | Cmdty ID (obsolete) | ||||
| quotation_name | CPET_QUOTNAME | Quotation Name | ||||
| quotation_source | TCR_CTY_QUOTSRC | Quot Source | ||||
| quotation_type | TCR_CTY_QUOTTYPE | Quotation Type | ||||
| spread | FTR_COMSPREAD | Spread | ||||
| price_curr_unit | TB_RUNIT | Currency Unit | ||||
| price_uom | TPM_CTY_UOM | Unit of Measure | ||||
| div_pctc_otc | TB_DIV_PCTC_OTC | Div. Percentage | ||||
| tainted | TB_TAINTED_CASHFLOW | Manipulated CF | ||||
| cleared | FTR_FLOW_CLEARED | Cleared | ||||
| dcsid | TBA_DCSID | DCS ID | ||||
| mic | TBA_MIC | MIC | ||||
| price_type | TBA_PRICETYPE | Price Type | ||||
| time_to_maturity | TBA_TENOR | Time to Maturity | ||||
| timing | TBA_TIMING | Timing | ||||
| exch_rate_type | KURST_CURR | Exch. Rate Type | ||||
| price_paym_curr | FTR_COMPRICE_PAYMENT_CURR | Price Paymt Crcy | ||||
| spread_paym_curr | FTR_COMSPREAD_PAYMENT_CURR | Spread in PymtC | ||||
| fx_translation | FTR_CURRENCY_CONV_POINT_IN_TIM | FX Translation | ||||
| mndid | SEPA_MNDID | Mandate Ref. | ||||
| bugrenz | TFMBUGRENZ | Lower Limit | ||||
| bogrenz | TFMBOGRENZ | Upper Limit | ||||
| sstaff | TFMSSTAFF | Scaled Calc. | ||||
| logic_rkond | FTR_COND_GRP | Condition Group | ||||
| rkondref | TB_KOND | Condition | ||||
| dguel_kpref | DGUEL_KP | Item Eff. From | ||||
| present_date | FTR_PRE_DATE | Presentatn Date | ||||
| interest_paid_by | FTR_INTEREST_PAY_BY | Interest Paid By | ||||
| shipment_date | FTR_SHIP_DATE | Shipment Date | ||||
| status | FTR_STATUS | Status | ||||
| present_id | FTR_PERSENT_ID | Presentatn Itm | ||||
| sstogrd | SSTOGRD | Reversal Reason | ||||
| present_amount | FTR_PRESENT_AMT | PresentationAmt | ||||
| present_bank | FTR_PRESENT_BANK | Pres. Bank | ||||
| present_discrepancy | FTR_DISCREPANCY | Discrepancy Amount | ||||
| present_decrease_amount | FTR_PRESENT_DEC_AMT | Decreased Amnt | ||||
| present_rea_cre_line | FTR_PRESENT_REA_AMT | Released Amount | ||||
| present_pay_amt | TB_BZBETR | Payment Amnt in PyC | ||||
| sroundfactor | TFM_SROUNDFACTOR | Factor RC | ||||
| rounddecfactor | TFM_ROUNDDECFACTOR | Dec. Fac. Round | ||||
| jexpointfactor | TFM_JEXPOINTFACTOR | Expo Int Factor | ||||
| flowfactor | TFM_FLOWFACTOR | Flow Factor | ||||
| basefactor | TFM_BASEFACTOR | Base Factor | ||||
| sroundbasefactor | TFM_SROUNDBASEFACTOR | Base Factor RC | ||||
| rounddecbasefactor | TFM_ROUNDDECBASEFACTOR | Dec. BF Round. | ||||
| skbwfix | TB_SKBWFIX | Translation->PC | ||||
| grouping_term | TB_DERIV_FLOW_GROUPING | Grouping Term | ||||
| ssequence | TFM_SEQUENCE | Sequence Number | ||||
| sroundratefactor | TFM_SROUNDRATEFACTOR | Int. Factor RC | ||||
| rounddecratefactor | TFM_ROUNDDECRATEFACTOR | Dec. Int. Fac. | ||||
| aavgdays | TFM_AAVGDAYS | Days AIR | ||||
| pavginterest | TFM_PAVGINTEREST | Aver. Int. Rate | ||||
| stgbasis | VVSTGBASIS | Base Days Meth. | ||||
| javgcap | TFM_JAVGCAP | Upper Limit | ||||
| pavgcap | TFM_PAVGCAP | Upper Limit | ||||
| javgfloor | TFM_JAVGFLOOR | Lower Limit | ||||
| pavgfloor | TFM_PAVGFLOOR | Lower Limit | ||||
| pavgspread | TFM_PAVGSPREAD | Spread | ||||
| sroundavginterest | TFM_SROUNDAVGINTEREST | RC of AIR | ||||
| rounddecavginterest | TFM_ROUNDDECAVGINTEREST | AIR Round. Dec. | ||||
| aavgweight | TFM_AWEIGHT | Weighting of IR | ||||
| aavgweightsum | TFM_AWEIGHTSUM | Cumul. Weight | ||||
| fx_fixing_date | TB_DFIX | Fixing Date | ||||
| fx_regi_state | FTR_FIXING_REF_REGI_STATE | Fixing Status | ||||
| fx_read_date | FTR_FIXING_REF_READ_DATE | Date of FX Rate | ||||
| priceindex_fix_date_low | TFM_INDEX_FIXDATELOW | IdxFixDateLow | ||||
| priceindex_read_date_low | FTR_PIDX_READ_DATE_LOW | Idx Read Low | ||||
| priceindex_fix_date_high | TFM_INDEX_FIXDATEHIGH | IdxFixDateHigh | ||||
| priceindex_read_date_high | FTR_PIDX_READ_DATE_HIGH | Idx Read High | ||||
| priceindex_regi_state | FTR_FIXING_REF_REGI_STATE | Fixing Status | ||||
| bbbetr_idxclean | TB_BBBETR_IDXCLEAN | Amt Index-Clean | ||||
| payment_reason | FARP_PAYT_RSN | Payment Reason | ||||
| payment_reason_changed | FTR_PAYMENT_REASON_CHANGED | ChangeIndPaymReason | ||||
| traded_quantity | TBA_TRADED_OTC_QUANTITY | Traded Quantity | ||||
| traded_quantity_uom | TBA_TRADED_QUANTITY_UOM | Unit of Measure | ||||
| conv_factor_traded_qty | TBA_CONV_FACTOR_TRADED_QTY | Qty Cnv Fct (Priced) | ||||
| conv_factor_traded_qty_uom | TBA_CONV_FACTOR_TRADED_QTY_UOM | Unit of Measure | ||||
| conv_factor_priced_qty | TBA_CONV_FACTOR_PRICED_QTY | Qty Cnv Fct | ||||
| conv_factor_priced_qty_uom | TBA_CONV_FACTOR_PRICED_QTY_UOM | Unit of Measure | ||||
| bkond | TFM_BKOND | Condition amnt | ||||
| ib_schedule_version | TRBA_VERSION_NUMBER | Version | ||||
| nominal_value_per_unit | FTR_NOMINAL_VALUE_PER_UNIT | Nominal Value | ||||
| sum_rkond | TB_SUM_RKOND | Accum. Cond.Grp | ||||
| sum_id_source | TB_SUM_ID_SOURCE | Rel.AccumFlowID | ||||
| sum_id_sum | TB_SUM_ID_SUM | Accum. Flow ID | ||||
| idcfm_usha_type | IDCFM_USHA_DEL_TYPE | Haircut Rate Type | ||||
| idcfm_usha_perc | IDCFM_USHA_DEL_PERC | Percentage Value | ||||
| idcfm_usha_tota | IDCFM_USHA_DEL_TOTA | Haircut Amount | ||||
| idcfm_usha_curr | IDCFM_USHA_DEL_CURR | Haircut Currency | ||||
| idcfm_usha_form | IDCFM_USHA_DEL_FORM | European Formula |
Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.
-- Transaction Flow
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE VTBFHAPO (
MANDT, -- Client [MANDT]
BUKRS, -- Company Code [BUKRS]
RFHA, -- Transaction [TB_RFHA]
RFHAZU, -- Activity [TB_RFHAZU]
DCRDAT, -- Entry Date [TB_CRDAT]
TCRTIM, -- Entry Time [TB_TCRTIM]
RFHAZB, -- Flow [TB_RFHAZB]
CRUSER, -- Entered By [TB_CRUSER]
UPUSER, -- Changed By [TB_UPUSER]
DUPDAT, -- Changed On [TB_DUPDAT]
TUPTIM, -- Time Changed [TB_TUPTIM]
RANTYP, -- Contract Type [RANTYP]
SFHAZBA, -- Flow Type [TB_SFHAZBA]
SBKKLAS, -- Classification [TB_SBKKLAS]
SBKTYP, -- Category [TB_SBKTYP]
SBERFIMA, -- Calc. Category [SBEWFIMA]
SSIGN, -- Direction [TB_SSIGN]
SHERKUNFT, -- Source [TB_SHERK]
SABVERF, -- Deriv.Procedure [TB_SABVERF]
RKONDGR, -- Direction [TB_RKONDGR]
RKOND, -- Condition [TB_KOND]
DGUEL_KP, -- Item Eff. From [DGUEL_KP]
NSTUFE, -- Level Number [NSTUFE]
SKOART, -- Condition Type [SKOART]
RREFKONT, -- Acct Assign.Ref [RREFKONT_OBSOLETE]
SBZVABW, -- Alt.Pay.Details [TB_SBZVABW]
RAHABKI, -- House Bank [TB_RHABKI]
RAHKTID, -- House Bank Acct [TB_RHKTID]
RPZAHL, -- Payer/Payee [TB_RPZAHL_NEW]
RPBANK, -- Partner Bank [TB_RPBANK]
SZART, -- Pmnt Transact. [TB_SZART]
ZLSCH, -- Pymt Meth. [DZLSCH]
UZAWE, -- Pmnt Meth. Sup. [UZAWE]
SPAYRQ, -- Payment Request [TB_SPAYRQK]
SPRSNG, -- Individual Pmnt [TB_SPRSNGK]
SPRGRD, -- Group Determ. [TB_SPRGRD]
SCSPAY, -- Same Direction [TB_SCSPAY]
ZWELS, -- Payment Methods [DZWELS]
PAYGR, -- Grouping [PAYGR]
SBEWEBE, -- Posting Status [TB_SBEWEBE]
SSPRGRD, -- Blocking Reason [TB_SSPRGRD]
SBFREI, -- Posting Release [TB_SBFREI]
SSTORNOBWG, -- Flow Reversal [TB_SBWGSTO]
PRKEY, -- Key Number [PRQ_KEYNO]
BELNR, -- Document Number [BELNR_D]
BELNR2, -- JE No. 2 [TB_BELNR2]
GJAHR, -- Fiscal Year [GJAHR]
DBUCHUNG, -- Posting Date [BUDAT]
DFAELL, -- Due Date [TB_DFAELL]
DZTERM, -- Payment Date [TB_DZTERM]
BZBETR, -- Payment Amnt in PyC [TB_BZBETR]
WZBETR, -- Payment Currency [TB_WZBETR]
BHWBETR, -- Pmnt Amnt in LCurr [TB_HWBETR]
KHWKURS, -- Local Crcy Rate [TB_KHWKURS]
ASTUECK, -- Number of Units [TB_ASTUECK_L]
BPRICE, -- Price per Unit [TB_BPRICE]
WPRICE, -- Price Currency [TB_WPRICE]
BHWPREIS, -- Loc.Curr.Price [TB_HWPREIS]
BINDEX, -- Point Value [TB_BINDEX]
VVBASIS, -- Price Points [TB_VVBASIS]
PWKURS, -- PercentagePrice [TB_PWKURS]
PRKKURS, -- Price in Points [TI_PRKUR]
BNWHR, -- Nominal Amnt [TB_BNWHR]
RHANDPL, -- Exchange [VVRHANDPL]
SKURSART, -- Rate/Price Type [TI_KURSART]
DBERVON, -- CalculationFrom [DBERVON]
DBERBIS, -- Calculation To [DBERBIS]
ATAGE, -- Number of Days [VVATAGE]
ABASTAGE, -- No. base days [ABASTAGE]
PKOND, -- Percentage Rate [PKOND]
DPKOND, -- Perc Fixing Dte [VVDPKOND]
DZFEST, -- Int.Fixing Date [TB_DZFEST]
SZBMETH, -- Int.calc.method [SZBMETH]
SKALIDWT, -- Int. Calendar [TFMSKALIDWT]
BBASIS, -- Base Amount [BBASIS]
WBASIS, -- Calc.Basis Crcy [TB_WBASIS]
JEXPOZINS, -- Exponential [TFM_SINTCOMP]
SINCL, -- Inclusive Ind. [VVSINCL]
SINCLBIS, -- Incl. End Date [VVSINCLBIS]
SULTBIS, -- Month-End EndDt [VVSULTBIS]
SEXCLVON, -- Exclusive Start [VVSEXCLVON]
SULTVON, -- Mth-End StartDt [VVSULTVON]
SAEND, -- Change ID [TFM_SAEND]
DVALUT, -- Calculat. date [DVALUT]
SVINCL, -- Inclusive_valDt [VVSVINCL]
SVULT, -- Mon-End Val.Dte [VVSVULT]
JSOFVERR, -- Immed.Settlemnt [TFMSOFVERR]
DVERRECH, -- Settlem. date [VVDVERRECH]
SINCLVERR, -- Incl. Clrg Date [VVSINCLVER]
SULTVERR, -- MnthEndClearing [VVSULTVERR]
SSTORNOMAN, -- Manual Reversal [TB_SBWGSTM]
SSTORNOART, -- Reversal Type [TB_SSTOART]
SBWGARTREF, -- Ref. Flow Type [TB_SBWGREF]
SKHWFIX, -- Translation->LC [TB_SKHWFIX]
ZUONR, -- Assignment [DZUONR]
RLDEPO, -- Securities Acct [RLDEPO]
RANL, -- Security Class [VVRANLW]
RTRBELNR, -- InternalDoc.No. [TPM_DEDOC_RDOCNRINT]
BUPRC, -- Price(UnitQuot) [TB_BUPRC_L]
BPPRC, -- Price (%) [TB_BPPRC_L]
WBBETR, -- Position Crcy [TB_WBBETR]
BBBETR, -- Amt in Pos.Crcy [TB_BBBETR]
WEBETR, -- Price Currency [TB_WEBETR]
BEBETR, -- Mkt Val. in QC [TB_BEBETR]
SRUNIT, -- Currency Unit [TB_RUNIT]
KZWKURS, -- PC Rate [TB_KZWKURS]
KBWKURS, -- PositionCurrRte [TB_KBWKURS]
WSBETR, -- Source Currency [TB_WFROM]
DBESTAND, -- Position Value Date [TB_DBESTAND]
SSTCKKZ, -- Acc.int.meth. [SSTCKKZ]
SSTCKTG, -- Daily Method [SSTCKTG]
SFLAT, -- Traded flat [VVSFLAT]
SCOUPON, -- Coupon [VVSCOUPON]
DCOUPON, -- Coupon date [VVDCOUPON]
AWKEY, -- Reference Key [AWKEY]
INDEX_VALUE, -- Value W/o Basis [TIDX_INDEX_VALUE_NO_RATIO]
SBASIS, -- Calculat. Base [SBASIS]
REGI_STATE, -- Status [TB_IRA_REGISTRATION_STATE]
RPCODE, -- Repetitive Code [RPCODE]
RP_TEXT, -- Reference Text [RPCODE_TEXT]
HEDGE_ID, -- Hedge ID [TPM_HEDGE_ID]
DBPERIOD, -- Period start [VVDBPERIOD]
SPAEXCL, -- Exclusive Start [TFMSPAEXCL]
SPAULT, -- MonEndIndStPer [TFMSPAULT]
DEPERIOD, -- Period end [VVDEPERIOD]
SPEINCL, -- InclusiveEndPer [TFMSPEINCL]
SPEULT, -- MthEndPerEnd [TFMSPEULT]
AMMRHY, -- Freq. in months [AMMRHY]
PPAYMENT, -- Payment Rate [TFM_PPAYMENT]
AMMRHYZV, -- Int.Sttlm.Freq [TFM_AMMRHYZV]
LZBKZ, -- SCB Ind. [LZBKZ]
LANDL, -- Supply C/R [LANDL]
BDIRTY, -- Dirty Price [TB_BDIRTY]
BAMOUNTCOMP, -- Cap. Amnt [TB_AMOUNTCOMP]
NOMINAL_ORG_AMT, -- Orig. Nominal Amount [TB_BNWHR_ORG]
NOM_FACTOR, -- Factor [RDPT_FACTOR_VAL]
RLDEPO2, -- Securities Acct [VRLDEPO]
INDEX_PRICE, -- Price incl. Index [TB_INDEX_PRICE]
FLOWUUID, -- Flow UUID [TB_FLOWUUID]
FLAGBYTE1, -- Flag Byte 1 [TB_FLAGBYTE1]
QUANTITY, -- Qty [FTR_QUAN]
UNIT_OF_MEASURE, -- Unit of Measure [TPM_CTY_UOM]
CONTRACT_PRICE, -- Price [FTR_COMPRICE]
SPOT_PRICE, -- SpotPrice [FTR_COMSPOT]
CONTANGO_BACKWRD, -- Comm Contg [FTR_CONBACK]
BPRC_SPOT1, -- Spot 1 [TB_BPPRC_SPOT1_L]
BPRC_SPOT2, -- SpotRate at Mat [TB_BPPRC_SPOT_MAT_L]
COST_FWD, -- Cost [TB_COSTFWD]
INTEREST_FWD, -- Interest [TB_INTERESTFWD]
REF_FLOWUUID, -- Reference UUID [TB_REFFLOWUUID]
RGATT, -- Class [TI_RGATT]
COMMODITY_ID, -- Cmdty ID (obsolete) [TRCO_COMM_ID]
QUOTATION_NAME, -- Quotation Name [CPET_QUOTNAME]
QUOTATION_SOURCE, -- Quot Source [TCR_CTY_QUOTSRC]
QUOTATION_TYPE, -- Quotation Type [TCR_CTY_QUOTTYPE]
SPREAD, -- Spread [FTR_COMSPREAD]
PRICE_CURR_UNIT, -- Currency Unit [TB_RUNIT]
PRICE_UOM, -- Unit of Measure [TPM_CTY_UOM]
DIV_PCTC_OTC, -- Div. Percentage [TB_DIV_PCTC_OTC]
TAINTED, -- Manipulated CF [TB_TAINTED_CASHFLOW]
CLEARED, -- Cleared [FTR_FLOW_CLEARED]
DCSID, -- DCS ID [TBA_DCSID]
MIC, -- MIC [TBA_MIC]
PRICE_TYPE, -- Price Type [TBA_PRICETYPE]
TIME_TO_MATURITY, -- Time to Maturity [TBA_TENOR]
TIMING, -- Timing [TBA_TIMING]
EXCH_RATE_TYPE, -- Exch. Rate Type [KURST_CURR]
PRICE_PAYM_CURR, -- Price Paymt Crcy [FTR_COMPRICE_PAYMENT_CURR]
SPREAD_PAYM_CURR, -- Spread in PymtC [FTR_COMSPREAD_PAYMENT_CURR]
FX_TRANSLATION, -- FX Translation [FTR_CURRENCY_CONV_POINT_IN_TIM]
MNDID, -- Mandate Ref. [SEPA_MNDID]
BUGRENZ, -- Lower Limit [TFMBUGRENZ]
BOGRENZ, -- Upper Limit [TFMBOGRENZ]
SSTAFF, -- Scaled Calc. [TFMSSTAFF]
LOGIC_RKOND, -- Condition Group [FTR_COND_GRP]
RKONDREF, -- Condition [TB_KOND]
DGUEL_KPREF, -- Item Eff. From [DGUEL_KP]
PRESENT_DATE, -- Presentatn Date [FTR_PRE_DATE]
INTEREST_PAID_BY, -- Interest Paid By [FTR_INTEREST_PAY_BY]
SHIPMENT_DATE, -- Shipment Date [FTR_SHIP_DATE]
STATUS, -- Status [FTR_STATUS]
PRESENT_ID, -- Presentatn Itm [FTR_PERSENT_ID]
SSTOGRD, -- Reversal Reason [SSTOGRD]
PRESENT_AMOUNT, -- PresentationAmt [FTR_PRESENT_AMT]
PRESENT_BANK, -- Pres. Bank [FTR_PRESENT_BANK]
PRESENT_DISCREPANCY, -- Discrepancy Amount [FTR_DISCREPANCY]
PRESENT_DECREASE_AMOUNT, -- Decreased Amnt [FTR_PRESENT_DEC_AMT]
PRESENT_REA_CRE_LINE, -- Released Amount [FTR_PRESENT_REA_AMT]
PRESENT_PAY_AMT, -- Payment Amnt in PyC [TB_BZBETR]
SROUNDFACTOR, -- Factor RC [TFM_SROUNDFACTOR]
ROUNDDECFACTOR, -- Dec. Fac. Round [TFM_ROUNDDECFACTOR]
JEXPOINTFACTOR, -- Expo Int Factor [TFM_JEXPOINTFACTOR]
FLOWFACTOR, -- Flow Factor [TFM_FLOWFACTOR]
BASEFACTOR, -- Base Factor [TFM_BASEFACTOR]
SROUNDBASEFACTOR, -- Base Factor RC [TFM_SROUNDBASEFACTOR]
ROUNDDECBASEFACTOR, -- Dec. BF Round. [TFM_ROUNDDECBASEFACTOR]
SKBWFIX, -- Translation->PC [TB_SKBWFIX]
GROUPING_TERM, -- Grouping Term [TB_DERIV_FLOW_GROUPING]
SSEQUENCE, -- Sequence Number [TFM_SEQUENCE]
SROUNDRATEFACTOR, -- Int. Factor RC [TFM_SROUNDRATEFACTOR]
ROUNDDECRATEFACTOR, -- Dec. Int. Fac. [TFM_ROUNDDECRATEFACTOR]
AAVGDAYS, -- Days AIR [TFM_AAVGDAYS]
PAVGINTEREST, -- Aver. Int. Rate [TFM_PAVGINTEREST]
STGBASIS, -- Base Days Meth. [VVSTGBASIS]
JAVGCAP, -- Upper Limit [TFM_JAVGCAP]
PAVGCAP, -- Upper Limit [TFM_PAVGCAP]
JAVGFLOOR, -- Lower Limit [TFM_JAVGFLOOR]
PAVGFLOOR, -- Lower Limit [TFM_PAVGFLOOR]
PAVGSPREAD, -- Spread [TFM_PAVGSPREAD]
SROUNDAVGINTEREST, -- RC of AIR [TFM_SROUNDAVGINTEREST]
ROUNDDECAVGINTEREST, -- AIR Round. Dec. [TFM_ROUNDDECAVGINTEREST]
AAVGWEIGHT, -- Weighting of IR [TFM_AWEIGHT]
AAVGWEIGHTSUM, -- Cumul. Weight [TFM_AWEIGHTSUM]
FX_FIXING_DATE, -- Fixing Date [TB_DFIX]
FX_REGI_STATE, -- Fixing Status [FTR_FIXING_REF_REGI_STATE]
FX_READ_DATE, -- Date of FX Rate [FTR_FIXING_REF_READ_DATE]
PRICEINDEX_FIX_DATE_LOW, -- IdxFixDateLow [TFM_INDEX_FIXDATELOW]
PRICEINDEX_READ_DATE_LOW, -- Idx Read Low [FTR_PIDX_READ_DATE_LOW]
PRICEINDEX_FIX_DATE_HIGH, -- IdxFixDateHigh [TFM_INDEX_FIXDATEHIGH]
PRICEINDEX_READ_DATE_HIGH, -- Idx Read High [FTR_PIDX_READ_DATE_HIGH]
PRICEINDEX_REGI_STATE, -- Fixing Status [FTR_FIXING_REF_REGI_STATE]
BBBETR_IDXCLEAN, -- Amt Index-Clean [TB_BBBETR_IDXCLEAN]
PAYMENT_REASON, -- Payment Reason [FARP_PAYT_RSN]
PAYMENT_REASON_CHANGED, -- ChangeIndPaymReason [FTR_PAYMENT_REASON_CHANGED]
TRADED_QUANTITY, -- Traded Quantity [TBA_TRADED_OTC_QUANTITY]
TRADED_QUANTITY_UOM, -- Unit of Measure [TBA_TRADED_QUANTITY_UOM]
CONV_FACTOR_TRADED_QTY, -- Qty Cnv Fct (Priced) [TBA_CONV_FACTOR_TRADED_QTY]
CONV_FACTOR_TRADED_QTY_UOM, -- Unit of Measure [TBA_CONV_FACTOR_TRADED_QTY_UOM]
CONV_FACTOR_PRICED_QTY, -- Qty Cnv Fct [TBA_CONV_FACTOR_PRICED_QTY]
CONV_FACTOR_PRICED_QTY_UOM, -- Unit of Measure [TBA_CONV_FACTOR_PRICED_QTY_UOM]
BKOND, -- Condition amnt [TFM_BKOND]
IB_SCHEDULE_VERSION, -- Version [TRBA_VERSION_NUMBER]
NOMINAL_VALUE_PER_UNIT, -- Nominal Value [FTR_NOMINAL_VALUE_PER_UNIT]
SUM_RKOND, -- Accum. Cond.Grp [TB_SUM_RKOND]
SUM_ID_SOURCE, -- Rel.AccumFlowID [TB_SUM_ID_SOURCE]
SUM_ID_SUM, -- Accum. Flow ID [TB_SUM_ID_SUM]
IDCFM_USHA_TYPE, -- Haircut Rate Type [IDCFM_USHA_DEL_TYPE]
IDCFM_USHA_PERC, -- Percentage Value [IDCFM_USHA_DEL_PERC]
IDCFM_USHA_TOTA, -- Haircut Amount [IDCFM_USHA_DEL_TOTA]
IDCFM_USHA_CURR, -- Haircut Currency [IDCFM_USHA_DEL_CURR]
IDCFM_USHA_FORM, -- European Formula [IDCFM_USHA_DEL_FORM]
PRIMARY KEY (MANDT, BUKRS, RFHA, RFHAZU, DCRDAT, TCRTIM, RFHAZB)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA