SAP ABAP Table FTRS_VTBFHAPO (Structure for Financial Transaction Flows (Without Key))
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷ CRM (Application Component) Customer Relationship Management
⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
⤷ FTA (Package) R/3 appl. development for Treasury money,forex,forward gen
⤷ CRM (Application Component) Customer Relationship Management
⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
⤷ FTA (Package) R/3 appl. development for Treasury money,forex,forward gen
Basic Data
Table Category | INTTAB | Structure |
Structure | FTRS_VTBFHAPO | Table Relationship Diagram |
Short Description | Structure for Financial Transaction Flows (Without Key) |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | ||
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | CRUSER | TB_CRUSER | SYCHAR12 | CHAR | 12 | 0 | Entered by | ||
2 | UPUSER | TB_UPUSER | SYCHAR12 | CHAR | 12 | 0 | Last Changed by | ||
3 | DUPDAT | TB_DUPDAT | DATUM | DATS | 8 | 0 | Changed on | ||
4 | TUPTIM | TB_TUPTIM | UZEIT | TIMS | 6 | 0 | Time changed | ||
5 | RANTYP | RANTYP | RANTYP | CHAR | 1 | 0 | Contract Type | ||
6 | SFHAZBA | TB_SFHAZBA | SBEWART | CHAR | 4 | 0 | Flow Type | TZB0A | |
7 | SBKKLAS | TB_SBKKLAS | T_SBKKLAS | CHAR | 1 | 0 | Classification of flows and conditions | ||
8 | SBKTYP | TB_SBKTYP | T_SBKTYP | CHAR | 2 | 0 | Category of Flows and Conditions | AT07 | |
9 | SBERFIMA | SBEWFIMA | SBEWFIMA | CHAR | 4 | 0 | Calculation category for cash flow calculator | AT40 | |
10 | SSIGN | TB_SSIGN | T_SSIGN | CHAR | 1 | 0 | Direction of flow | ||
11 | SHERKUNFT | TB_SHERK | T_XFELD04 | CHAR | 4 | 0 | Display Area of Flow or Condition | ||
12 | SABVERF | TB_SABVERF | T_SABVERF | CHAR | 5 | 0 | Procedure to Generate Derived Flows | AT22 | |
13 | RKONDGR | TB_RKONDGR | T_RKONDGR | NUMC | 1 | 0 | Direction of Transaction | ||
14 | RKOND | TB_KOND | T_KOND | NUMC | 4 | 0 | Condition | ||
15 | DGUEL_KP | DGUEL_KP | DATUM | DATS | 8 | 0 | Condition Item Valid From | ||
16 | NSTUFE | NSTUFE | NUMC2 | NUMC | 2 | 0 | Level number of condition item for recurring payments | ||
17 | SKOART | SKOART | SKOART | NUMC | 4 | 0 | Condition Type (Smallest Subdivision of Condition Records) | TZK01 | |
18 | RREFKONT | RREFKONT_OBSOLETE | USTRU | CHAR | 8 | 0 | Obsolete: Accnt Assignment Ref. in Fin. Assets Management | T037S | |
19 | SBZVABW | TB_SBZVABW | XFELD | CHAR | 1 | 0 | Alternative payment details stated in flow | ||
20 | RAHABKI | TB_RHABKI | HBKID | CHAR | 5 | 0 | Short key for own house bank | T012 | |
21 | RAHKTID | TB_RHKTID | HKTID | CHAR | 5 | 0 | Short key for house bank account | T012K | |
22 | RPZAHL | TB_RPZAHL_NEW | BU_PARTNER | CHAR | 10 | 0 | Payer/payee | * | |
23 | RPBANK | TB_RPBANK | BVTYP | CHAR | 4 | 0 | Partner bank details | ||
24 | SZART | TB_SZART | XFELD | CHAR | 1 | 0 | Payment transaction | ||
25 | ZLSCH | DZLSCH | ZLSCH | CHAR | 1 | 0 | Payment method | T042Z | |
26 | UZAWE | UZAWE | UZAWE | CHAR | 2 | 0 | Payment method supplement | T042F | |
27 | SPAYRQ | TB_SPAYRQK | XFELD | CHAR | 1 | 0 | Generate payment request | ||
28 | SPRSNG | TB_SPRSNGK | XFELD | CHAR | 1 | 0 | Individual payment | ||
29 | SPRGRD | TB_SPRGRD | T_SPRGRD | CHAR | 1 | 0 | Determine grouping definition | ||
30 | SCSPAY | TB_SCSPAY | XFELD | CHAR | 1 | 0 | Same direction necessary for joint payment? | ||
31 | ZWELS | DZWELS | ZWELS | CHAR | 10 | 0 | List of the Payment Methods to be Considered | ||
32 | PAYGR | PAYGR | CHAR20 | CHAR | 20 | 0 | Grouping Field for Automatic Payments | ||
33 | SBEWEBE | TB_SBEWEBE | T_SBEWEBE | CHAR | 1 | 0 | Posting Status of Flow | ||
34 | SSPRGRD | TB_SSPRGRD | T_SSPRGRD | NUMC | 1 | 0 | Reason Why Flow Is Blocked for Posting | ||
35 | SBFREI | TB_SBFREI | XFELD | CHAR | 1 | 0 | Release Given for Flow to Be Posted? | ||
36 | SSTORNOBWG | TB_SBWGSTO | XFELD | CHAR | 1 | 0 | Flow reversal in Treasury | ||
37 | PRKEY | PRQ_KEYNO | PRQ_KEYNO | CHAR | 10 | 0 | Key Number for Payment Request | * | |
38 | BELNR | BELNR_D | BELNR | CHAR | 10 | 0 | Accounting Document Number | ||
39 | BELNR2 | TB_BELNR2 | BELNR | CHAR | 10 | 0 | Doc. no. of a second accounting doc. for currency swap | ||
40 | GJAHR | GJAHR | GJAHR | NUMC | 4 | 0 | Fiscal Year | ||
41 | DBUCHUNG | BUDAT | DATUM | DATS | 8 | 0 | Posting Date in the Document | ||
42 | DFAELL | TB_DFAELL | DATUM | DATS | 8 | 0 | Due date | ||
43 | DZTERM | TB_DZTERM | DATUM | DATS | 8 | 0 | Payment or Delivery Date | ||
44 | BZBETR | TB_BZBETR | WERTV7 | CURR | 13 | 2 | Payment amount in payment currency | ||
45 | WZBETR | TB_WZBETR | WAERS | CUKY | 5 | 0 | Payment Currency | TCURC | |
46 | BHWBETR | TB_HWBETR | WERTV7 | CURR | 13 | 2 | Payment Amount in Local Currency | ||
47 | KHWKURS | TB_KHWKURS | UKURS | DEC | 9 | 5 | Local currency rate | ||
48 | ASTUECK | TB_ASTUECK | ASTUECK | DEC | 15 | 5 | No. of Units for Financial Instruments | ||
49 | BPRICE | TB_BPRICE | WERTV7 | CURR | 13 | 2 | Price per unit | ||
50 | WPRICE | TB_WPRICE | WAERS | CUKY | 5 | 0 | Price currency | TCURC | |
51 | BHWPREIS | TB_HWPREIS | WERTV7 | CURR | 13 | 2 | Price in local currency | ||
52 | BINDEX | TB_BINDEX | BWHR | CURR | 13 | 2 | Value of a point | ||
53 | VVBASIS | TB_VVBASIS | T_PKTKUR | DEC | 11 | 6 | Price in points | ||
54 | PWKURS | TB_PWKURS | DEC3_7 | DEC | 10 | 7 | Price as percentage quotation | ||
55 | PRKKURS | TI_PRKUR | TB_KKURS | DEC | 13 | 9 | Currency option premium with price in points | ||
56 | BNWHR | TB_BNWHR | WERTV7 | CURR | 13 | 2 | Nominal amount | ||
57 | RHANDPL | VVRHANDPL | VVRHANDPL | CHAR | 10 | 0 | Exchange | TWH01 | |
58 | SKURSART | TI_KURSART | VVSKURSART | CHAR | 2 | 0 | Rate/Price Type - Treasury Instruments | TW56 | |
59 | DBERVON | DBERVON | DATUM | DATS | 8 | 0 | Start of Calculation Period | ||
60 | DBERBIS | DBERBIS | DATUM | DATS | 8 | 0 | End of Calculation Period | ||
61 | ATAGE | VVATAGE | INT6 | NUMC | 6 | 0 | Number of days | ||
62 | ABASTAGE | ABASTAGE | INT6 | NUMC | 6 | 0 | Number of base days in a calculation period | ||
63 | PKOND | PKOND | DECV3_7 | DEC | 10 | 7 | Percentage rate for condition items | ||
64 | DPKOND | VVDPKOND | DATUM | DATS | 8 | 0 | Determination date for percentage rate of condition items | ||
65 | DZFEST | TB_DZFEST | DATUM | DATS | 8 | 0 | Interest rate fixing date | ||
66 | SZBMETH | SZBMETH | SZBMETH | CHAR | 1 | 0 | Interest Calculation Method | ||
67 | SKALIDWT | TFMSKALIDWT | WFCID | CHAR | 2 | 0 | Interest Calendar | * | |
68 | BBASIS | BBASIS | WERTV7 | CURR | 13 | 2 | Calculation base amount | ||
69 | WBASIS | TB_WBASIS | WAERS | CUKY | 5 | 0 | Currency of calculation basis | TCURC | |
70 | JEXPOZINS | TB_JZINSRE | XFELD | CHAR | 1 | 0 | Exponential Interest Calculation | ||
71 | SINCL | VVSINCL | VVSINCL | NUMC | 1 | 0 | Inclusive indicator for beginning and end of a period | ||
72 | SINCLBIS | VVSINCLBIS | VVSINCLBIS | NUMC | 1 | 0 | Inclusive Indicator for the End of a Calculation Period | ||
73 | SULTBIS | VVSULTBIS | VVSULT | CHAR | 1 | 0 | Month-End Indicator for the End of a Calculation Period | ||
74 | SEXCLVON | VVSEXCLVON | VVSEXCLVON | NUMC | 1 | 0 | Exclusive Indicator for the Start of a Calculation Period | ||
75 | SULTVON | VVSULTVON | VVSULT | CHAR | 1 | 0 | Month-End Indicator for Start of a Calculation Period | ||
76 | SAEND | TFM_SAEND | TFM_SAEND | NUMC | 1 | 0 | Change Indicator for FiMa Flow Records | ||
77 | DVALUT | DVALUT | DATUM | DATS | 8 | 0 | Calculation Date | ||
78 | SVINCL | VVSVINCL | VVSINCL | NUMC | 1 | 0 | Inclusive indicator for value date | ||
79 | SVULT | VVSVULT | VVSULT | CHAR | 1 | 0 | Month-End Indicator for Value Date | ||
80 | JSOFVERR | TFMSOFVERR | TFMSOFVERR | CHAR | 1 | 0 | Indicator for Immediate Settlement (Financial Mathematics) | ||
81 | DVERRECH | VVDVERRECH | DATUM | DATS | 8 | 0 | Settlement date | ||
82 | SINCLVERR | VVSINCLVER | VVSINCLVER | NUMC | 1 | 0 | Inclusive Indicator for Clearing Date | ||
83 | SULTVERR | VVSULTVERR | VVSULT | CHAR | 1 | 0 | Month-End Indicator for Clearing Date | ||
84 | SSTORNOMAN | TB_SBWGSTM | T_SBWGSTM | CHAR | 1 | 0 | Manual reversal of flows posted in FI | ||
85 | SSTORNOART | TB_SSTOART | T_SSTOART | CHAR | 2 | 0 | Type of manual reversal of flows posted in FI | AT90 | |
86 | SBWGARTREF | TB_SBWGREF | SBEWART | CHAR | 4 | 0 | Referenced flow type | TZB0A | |
87 | SKHWFIX | TB_SKHWFIX | T_SKHWFIX | CHAR | 1 | 0 | Indicator for translation into local currency | ||
88 | ZUONR | DZUONR | ZUONR | CHAR | 18 | 0 | Assignment number | ||
89 | RLDEPO | RLDEPO | RLDEPO | CHAR | 10 | 0 | Securities Account | * | |
90 | RANL | VVRANLW | WP_RANL | CHAR | 13 | 0 | Security ID Number | * | |
91 | RTRBELNR | TPM_DEDOC_RDOCNRINT | TPM_DEDOC_RDOCNRINT | CHAR | 15 | 0 | Internal document number of derivatives document | ||
92 | BUPRC | TB_BUPRC | VVPKTKUR | DEC | 15 | 6 | Security Price Without Currency Ref. with Unit Quotation | ||
93 | BPPRC | TB_BPPRC | VVPKTKUR | DEC | 15 | 6 | Security Price for Percentage Quotation | ||
94 | WBBETR | TB_WBBETR | WAERS | CUKY | 5 | 0 | Currency of Position Amount | * | |
95 | BBBETR | TB_BBBETR | WERTV7 | CURR | 13 | 2 | Amount that Changes the Position | ||
96 | WEBETR | TB_WEBETR | WAERS | CUKY | 5 | 0 | Price currency | * | |
97 | BEBETR | TB_BEBETR | WERTV7 | CURR | 13 | 2 | Market Value in Quotation Currency | ||
98 | SRUNIT | TB_RUNIT | VVSRUNIT | CHAR | 5 | 0 | Currency unit of rate | TZUNI | |
99 | KZWKURS | TB_KZWKURS | UKURS | DEC | 9 | 5 | Payment currency rate | ||
100 | KBWKURS | TB_KBWKURS | UKURS | DEC | 9 | 5 | Position currency rate | ||
101 | WSBETR | TB_WFROM | WAERS | CUKY | 5 | 0 | Currency Key for Currency Conversion: Source Currency | * | |
102 | DBESTAND | TB_DBESTAND | DATUM | DATS | 8 | 0 | Position Value Date | ||
103 | SSTCKKZ | SSTCKKZ | SSTCKKZ | CHAR | 1 | 0 | Accrued interest method | ||
104 | SSTCKTG | SSTCKTG | SZBMETH | CHAR | 1 | 0 | Accrued interest: Daily method | ||
105 | SFLAT | VVSFLAT | XFELD | CHAR | 1 | 0 | Indicator 'Traded flat',i.e.no accrued interest calculation | ||
106 | SCOUPON | VVSCOUPON | VVSCOUPON | CHAR | 1 | 0 | Coupon ID for interest and accrued interest calculation | ||
107 | DCOUPON | VVDCOUPON | DATUM | DATS | 8 | 0 | Coupon date of next delivered coupon | ||
108 | AWKEY | AWKEY | AWKEY | CHAR | 20 | 0 | Object key | ||
109 | INDEX_VALUE | TIDX_INDEX_VALUE_NO_RATIO | TIDX_INDEX_VALUE_NO_RATIO | DEC | 18 | 12 | Index Value (Independent of Basis) | ||
110 | SBASIS | SBASIS | VVSBASIS | CHAR | 4 | 0 | Calculation base indicator | * | |
111 | REGI_STATE | TB_IRA_REGISTRATION_STATE | T_IRA_REGISTRATION_STATE | CHAR | 2 | 0 | Status of Interest Rate Adjustment | ||
112 | RPCODE | RPCODE | RPCODE | CHAR | 20 | 0 | Repetitive Code | * | |
113 | RP_TEXT | RPCODE_TEXT | XTEXT50 | CHAR | 50 | 0 | Reference Text for Repetitive Code | ||
114 | HEDGE_ID | TPM_HEDGE_ID | CHAR | 10 | 0 | Identification for Hedging Relationship | |||
115 | DBPERIOD | VVDBPERIOD | DATUM | DATS | 8 | 0 | Period start | ||
116 | SPAEXCL | TFMSPAEXCL | TFMSPAEXCL | NUMC | 1 | 0 | Exclusive Indicator for Start Date of a Period | ||
117 | SPAULT | TFMSPAULT | VVSULT | CHAR | 1 | 0 | Month-End Indicator for Start Date of a Period | ||
118 | DEPERIOD | VVDEPERIOD | DATUM | DATS | 8 | 0 | Period End | ||
119 | SPEINCL | TFMSPEINCL | TFMSPEINCL | NUMC | 1 | 0 | Inclusive Indicator for End Date of a Period | ||
120 | SPEULT | TFMSPEULT | VVSULT | CHAR | 1 | 0 | Month-End Indicator for End of a Period | ||
121 | AMMRHY | AMMRHY | NUMC03 | NUMC | 3 | 0 | Frequency in months | ||
122 | PPAYMENT | TFM_PPAYMENT | TFM_PPAYMENT | DEC | 11 | 7 | Payment Rate | ||
123 | AMMRHYZV | TFM_AMMRHYZV | TFM_AMMRHYZV | NUMC | 2 | 0 | Interest Settlement Frequency for Exponential Interest Calc. | ||
124 | LZBKZ | LZBKZ | LZBKZ | CHAR | 3 | 0 | State central bank indicator | T015L | |
125 | LANDL | LANDL | LAND1 | CHAR | 3 | 0 | Supplying Country | T005 | |
126 | BDIRTY | TB_BDIRTY | WERTV7 | CURR | 13 | 2 | Dirty Price | ||
127 | BAMOUNTCOMP | TB_AMOUNTCOMP | WERTV7 | CURR | 13 | 2 | Amount to be Capitalized | ||
128 | NOMINAL_ORG_AMT | TB_BNWHR_ORG | WERTV7 | CURR | 13 | 2 | Orignal Nominal Amount | ||
129 | NOM_FACTOR | RDPT_FACTOR_VAL | DEC | 12 | 9 | Factor | |||
130 | RLDEPO2 | VRLDEPO | RLDEPO | CHAR | 10 | 0 | Securities Account | * | |
131 | INDEX_PRICE | TB_INDEX_PRICE | CHAR1 | CHAR | 1 | 0 | Indicator for Security Price Including Index Value |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | FTRS_VTBFHAPO | LANDL | T005 | LAND1 | |||
2 | FTRS_VTBFHAPO | LZBKZ | T015L | LZBKZ | |||
3 | FTRS_VTBFHAPO | RAHABKI | T012 | HBKID | KEY | 1 | CN |
4 | FTRS_VTBFHAPO | RAHKTID | T012K | HKTID | KEY | 1 | CN |
5 | FTRS_VTBFHAPO | RHANDPL | TWH01 | RHANDPL | KEY | 1 | CN |
6 | FTRS_VTBFHAPO | RREFKONT | T037S | RREFKONT | KEY | 1 | CN |
7 | FTRS_VTBFHAPO | SABVERF | AT22 | SABVERF | C | CN | |
8 | FTRS_VTBFHAPO | SBERFIMA | AT40 | SBERFIMA | |||
9 | FTRS_VTBFHAPO | SBKTYP | AT07 | SBKTYP | KEY | 1 | CN |
10 | FTRS_VTBFHAPO | SBWGARTREF | TZB0A | SBEWART | REF | C | CN |
11 | FTRS_VTBFHAPO | SFHAZBA | TZB0A | SBEWART | KEY | 1 | CN |
12 | FTRS_VTBFHAPO | SKOART | TZK01 | SKOART | KEY | 1 | CN |
13 | FTRS_VTBFHAPO | SKURSART | TW56 | SKURSART | KEY | 1 | CN |
14 | FTRS_VTBFHAPO | SRUNIT | TZUNI | SRUNIT | |||
15 | FTRS_VTBFHAPO | SSTORNOART | AT90 | SSTORNOART | KEY | 1 | CN |
16 | FTRS_VTBFHAPO | UZAWE | T042F | UZAWE | KEY | 1 | CN |
17 | FTRS_VTBFHAPO | WBASIS | TCURC | WAERS | KEY | 1 | CN |
18 | FTRS_VTBFHAPO | WPRICE | TCURC | WAERS | KEY | 1 | CN |
19 | FTRS_VTBFHAPO | WZBETR | TCURC | WAERS | KEY | 1 | CN |
20 | FTRS_VTBFHAPO | ZLSCH | T042Z | ZLSCH | KEY | 1 | CN |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in | 462_10 |