VTB_S_BEW SAP (Data Structure for Flows (SWAP)) Structure details
Description: Data Structure for Flows (SWAP)
Structure field list including key, data, relationships and ABAP select examples
VTB_S_BEW 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 "Data Structure for Flows (SWAP)" 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_S_BEW TYPE VTB_S_BEW.
The VTB_S_BEW table consists of various fields, each holding specific information or linking keys about Data Structure for Flows (SWAP) data available in SAP. These include RFHA (Financial Transaction), RFHAZU (Transaction activity), SFHAZBA (Flow Type), SSIGN (Direction of flow).. 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_S_BEW 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 |
BUKRS | Company Code | BUKRS | CHAR | 4 | Assigned to domain | BUKRS | BUK | C_T001 | |
RFHA | Financial Transaction | TB_RFHA | CHAR | 13 | Assigned to domain | ALPHA | T_RFHA | FAN | VTBA |
RFHAZU | Transaction activity | TB_RFHAZU | NUMC | 5 | T_RFHAZU | FAS | |||
SFHAZBA | Flow Type | TB_SFHAZBA | CHAR | 4 | Assigned to domain | SBEWART | |||
SSIGN | Direction of flow | TB_SSIGN | CHAR | 1 | T_SSIGN | ||||
SALTSATZ | Checkbox | XFELD | CHAR | 1 | XFELD | ||||
SZSREF | Reference Interest Rate | SZSREF | CHAR | 10 | Assigned to domain | ZIREFKU | |||
SBEWEBE | Posting Status of Flow | TB_SBEWEBE | CHAR | 1 | T_SBEWEBE | ||||
PKOND | Percentage rate for condition items | PKOND | DEC | 10(7) | DECV3_7 | ||||
BBASIS | Calculation base amount | BBASIS | CURR | 13(2) | WERTV7 | ||||
WBASIS | Currency of calculation basis | TB_WBASIS | CUKY | 5 | Assigned to domain | WAERS | |||
RKONDGR | Direction of Transaction | TB_RKONDGR | NUMC | 1 | T_RKONDGR | ||||
NSTUFE | Two digit number | NUMC2 | NUMC | 2 | NUMC2 | ||||
SKOART | Condition Type (Smallest Subdivision of Condition Records) | SKOART | NUMC | 4 | Assigned to domain | SKOART | |||
RKOND | Condition | TB_KOND | NUMC | 4 | T_KOND | ||||
SBKTYP | Category of Flows and Conditions | TB_SBKTYP | CHAR | 2 | Assigned to domain | T_SBKTYP | |||
SBKKLAS | Classification of flows and conditions | TB_SBKKLAS | CHAR | 1 | T_SBKKLAS | ||||
DGUEL_KP | Condition Item Valid From | DGUEL_KP | DATS | 8 | DATUM | ||||
RREFKONT | Obsolete: Accnt Assignment Ref. in Fin. Assets Management | RREFKONT_OBSOLETE | CHAR | 8 | Assigned to domain | USTRU | KRE | ||
DFAELL | Due date | TB_DFAELL | DATS | 8 | DATUM | ||||
DZTERM | Payment or Delivery Date | TB_DZTERM | DATS | 8 | DATUM | T33 | |||
BZBETR | Payment amount in payment currency | TB_BZBETR | CURR | 13(2) | WERTV7 | ||||
WZBETR | Payment Currency | TB_WZBETR | CUKY | 5 | Assigned to domain | WAERS | |||
BNWHR | Nominal amount | TB_BNWHR | CURR | 13(2) | WERTV7 | ||||
ATAGE | Number of days | VVATAGE | NUMC | 6 | INT6 | ||||
ABASTAGE | Number of base days in a calculation period | ABASTAGE | NUMC | 6 | INT6 | ||||
SZBMETH | Interest Calculation Method | SZBMETH | CHAR | 1 | SZBMETH | ||||
DPKOND | Determination date for percentage rate of condition items | VVDPKOND | DATS | 8 | DATUM | ||||
DZFEST | Interest rate fixing date | TB_DZFEST | DATS | 8 | DATUM | ||||
DVALUT | Calculation Date | DVALUT | DATS | 8 | DATUM | ||||
BELNR | 0 | ||||||||
DBUCHUNG | Posting Date in the Document | BUDAT | DATS | 8 | DATUM | ||||
DBERVON | Start of Calculation Period | DBERVON | DATS | 8 | DATUM | ||||
DBERBIS | End of Calculation Period | DBERBIS | DATS | 8 | DATUM | ||||
SFORMREF | Formula Reference | TB_XFORMBE | CHAR | 4 | Assigned to domain | T_FORMBE | |||
FORMEL | 0 | ||||||||
KHWKURS | Local currency rate | TB_KHWKURS | DEC | 9(5) | EXCRT | UKURS | |||
SBERFIMA | Calculation category for cash flow calculator | SBEWFIMA | CHAR | 4 | Assigned to domain | SBEWFIMA | |||
PSTRIKE | Strike for cap/floor | TB_PSTRIKE | DEC | 10(7) | DECV3_7 | ||||
SKALIDWT | Interest Calendar | TFMSKALIDWT | CHAR | 2 | Assigned to domain | WFCID | H_TFACD | ||
SINCLBIS | Inclusive Indicator for the End of a Calculation Period | VVSINCLBIS | NUMC | 1 | VVSINCLBIS | ||||
SULTBIS | Month-End Indicator for the End of a Calculation Period | VVSULTBIS | CHAR | 1 | VVSULT | ||||
SEXCLVON | Exclusive Indicator for the Start of a Calculation Period | VVSEXCLVON | NUMC | 1 | VVSEXCLVON | ||||
SULTVON | Month-End Indicator for Start of a Calculation Period | VVSULTVON | CHAR | 1 | VVSULT | ||||
DCRDAT | Entered On | TB_DCRDAT | DATS | 8 | DATUM | ||||
DVERRECH | Settlement date | VVDVERRECH | DATS | 8 | DATUM | ||||
JEXPOZINS | Exponential Interest Calculation | TB_JZINSRE | CHAR | 1 | XFELD | ||||
AMMRHYZV | Interest Settlement Frequency for Exponential Interest Calc. | TFM_AMMRHYZV | NUMC | 2 | TFM_AMMRHYZV | ||||
SOFFSET | Fixer offset for variable interest rate reference | TV_SOFFSET | DEC | 10(7) | DECV3_7 | ||||
DBPERIOD | Period start | VVDBPERIOD | DATS | 8 | DATUM | ||||
DEPERIOD | Period End | VVDEPERIOD | DATS | 8 | DATUM | ||||
AMMRHY | Frequency in months | AMMRHY | NUMC | 3 | NUMC03 | ||||
JSOFVERR | Immediate settlement | JSOFVERR | CHAR | 1 | TFMSOFVERR | ||||
ASTUECK | No. of Units for Financial Instruments | TB_ASTUECK | DEC | 15(5) | ASTUECK | ||||
BPRICE | Price per unit | TB_BPRICE | CURR | 13(2) | WERTV7 | ||||
WPRICE | Price currency | TB_WPRICE | CUKY | 5 | Assigned to domain | WAERS | |||
RHANDPL | Exchange | VVRHANDPL | CHAR | 10 | Assigned to domain | VVRHANDPL | WHP | ||
DIV_PCTC_OTC | Percentage of Dividend agreed for Payment in OTC Instruments | TB_DIV_PCTC_OTC | DEC | 7(4) | T_DIV_PCTC_OTC | ||||
REGI_STATE | Status of Interest Rate Adjustment | TB_IRA_REGISTRATION_STATE | CHAR | 2 | T_IRA_REGISTRATION_STATE | ||||
PPAYMENT | Payment Rate | TFM_PPAYMENT | DEC | 11(7) | TFM_PPAYMENT | ||||
CTY_FLOW_CAT | Commodity Flow Leg Category | FTR_CTY_FLOW_CAT | NUMC | 1 | FTR_CTY_FLOW_CAT | ||||
COMMODITY_ID | Commodity ID | TRCO_COMM_ID | CHAR | 18 | Assigned to domain | TPM_CTY_ID | COMMODITY_ID | F4_CTY_ID_CORE | |
QUANTITY | Quantity | FTR_QUAN | QUAN | 13(3) | FTR_QUAN | ||||
UNIT_OF_MEASURE | Unit of Measure for the Commodity | TPM_CTY_UOM | UNIT | 3 | T006 | CUNIT | MEINS | ||
WEIGHTAGE | Weightage of the Pricing Item | FTR_PRICE_WEIGHT | DEC | 8(5) | FTR_PRICE_WEIGHTAGE | ||||
PAYMENT_DATE | Date on which the Payment will be made | FTR_PAYMENT_DATE | DATS | 8 | Assigned to domain | FTR_EXPOSURE_DATE | |||
PRICING_DATE | Date on which the Item will be priced | FTR_PRICING_DATE | DATS | 8 | Assigned to domain | FTR_EXPOSURE_DATE | |||
DELIVERY_DATE | Date on which the Item will be delivered | FTR_DELIVERY_DATE | DATS | 8 | Assigned to domain | FTR_EXPOSURE_DATE | |||
CTY_PRICE | Commodity Price | FTR_COMPRICE | DEC | 13(5) | FTR_COMPRICE | ||||
PRICE_CURR | Exposure Amount Currency | FTR_EXPOSURE_CURR | CUKY | 5 | TCURC | WAERS | |||
PRICE_UOQ | Price Unit of Quotation | FTR_PRICE_UNIT_OF_QUOT | DEC | 5 | FTR_PRICE_UNIT_OF_QUOT | ||||
PRICE_UOM | Unit of Measure for the Commodity | TPM_CTY_UOM | UNIT | 3 | T006 | CUNIT | MEINS | ||
SPREAD | Commodity Spread | FTR_COMSPREAD | DEC | 13(5) | FTR_COMPRICE | ||||
QUOT_SRC | Quotation Source | TCR_CTY_QUOTSRC | CHAR | 2 | TRCOCC_QUOTSRC | TCR_CTY_QUOTSRC | |||
QUOT_TYPE | Commodity Quotation Type | TCR_CTY_QUOTTYPE | CHAR | 5 | TRCOCC_QUOTTYPE | TCR_CTY_QUOTTYPE | |||
QUOT_TIME | Price Quotation Time | FTR_QUOTATION_TIME | TIMS | 6 | TIME | ||||
DCSID | Derivative Contract Specification ID | TBA_DCSID | CHAR | 6 | Assigned to domain | TBA_DCSID | TBA_DCSID | TBAH_DCS | |
MIC | Market Identifier Code | TBA_MIC | CHAR | 4 | Assigned to domain | TBA_MIC | TBA_MIC | TBAH_MIC | |
PRICETYPE | Type of Price Quotation | TBA_PRICETYPE | CHAR | 2 | Assigned to domain | VVSKURSART | RATETYPE_F4 | ||
TENOR | Time to Maturity | TBA_TENOR | CHAR | 10 | Assigned to domain | TBA_TENOR | TBAH_TENOR | ||
KEYDATE | DCS Key Date | TBA_KEYDATE | DATS | 8 | DATE |
Key field | Non-key field |
How do I retrieve data from SAP structure VTB_S_BEW using ABAP code?
As VTB_S_BEW 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_S_BEW as there is no data to select.How to access SAP table VTB_S_BEW
Within an ECC or HANA version of SAP you can also view further information about VTB_S_BEW and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects