SAP ABAP Table VTBPFHAPO (Treasury: Flow Shells)
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 | TRANSP | Transparent table |
Transparent table | VTBPFHAPO | Table Relationship Diagram |
Short Description | Treasury: Flow Shells |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | A | Application Table (Master- and Transaction Data) |
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 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
2 | BUKRS | BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | T001 | |
3 | RFHA | TB_RFHA | T_RFHA | CHAR | 13 | 0 | Financial Transaction | VTBFHA | |
4 | RFHAZU | TB_RFHAZU | T_RFHAZU | NUMC | 5 | 0 | Transaction activity | ||
5 | DCRDAT | TB_CRDAT | DATUM | DATS | 8 | 0 | Entered On | ||
6 | TCRTIM | TB_TCRTIM | UZEIT | TIMS | 6 | 0 | Entry Time | ||
7 | RFHAZB | TB_RFHAZB | T_RFHAZB | NUMC | 4 | 0 | Transaction flow | ||
8 | CRUSER | TB_CRUSER | SYCHAR12 | CHAR | 12 | 0 | Entered by | ||
9 | UPUSER | TB_UPUSER | SYCHAR12 | CHAR | 12 | 0 | Last Changed by | ||
10 | DUPDAT | TB_DUPDAT | DATUM | DATS | 8 | 0 | Changed on | ||
11 | TUPTIM | TB_TUPTIM | UZEIT | TIMS | 6 | 0 | Time changed | ||
12 | RANTYP | RANTYP | RANTYP | CHAR | 1 | 0 | Contract Type | ||
13 | SFHAZBA | TB_SFHAZBA | SBEWART | CHAR | 4 | 0 | Flow Type | TZB0A | |
14 | SBKKLAS | TB_SBKKLAS | T_SBKKLAS | CHAR | 1 | 0 | Classification of flows and conditions | ||
15 | SBKTYP | TB_SBKTYP | T_SBKTYP | CHAR | 2 | 0 | Category of Flows and Conditions | AT07 | |
16 | SBERFIMA | SBEWFIMA | SBEWFIMA | CHAR | 4 | 0 | Calculation category for cash flow calculator | AT40 | |
17 | SSIGN | TB_SSIGN | T_SSIGN | CHAR | 1 | 0 | Direction of flow | ||
18 | SHERKUNFT | TB_SHERK | T_XFELD04 | CHAR | 4 | 0 | Display Area of Flow or Condition | ||
19 | RKONDGR | TB_RKONDGR | T_RKONDGR | NUMC | 1 | 0 | Direction of Transaction | ||
20 | RKOND | TB_KOND | T_KOND | NUMC | 4 | 0 | Condition | ||
21 | DGUEL_KP | DGUEL_KP | DATUM | DATS | 8 | 0 | Condition Item Valid From | ||
22 | NSTUFE | NSTUFE | NUMC2 | NUMC | 2 | 0 | Level number of condition item for recurring payments | ||
23 | SKOART | SKOART | SKOART | NUMC | 4 | 0 | Condition Type (Smallest Subdivision of Condition Records) | TZK01 | |
24 | RREFKONT | RREFKONT_OBSOLETE | USTRU | CHAR | 8 | 0 | Obsolete: Accnt Assignment Ref. in Fin. Assets Management | T037S | |
25 | SBZVABW | TB_SBZVABW | XFELD | CHAR | 1 | 0 | Alternative payment details stated in flow | ||
26 | RAHABKI | TB_RHABKI | HBKID | CHAR | 5 | 0 | Short key for own house bank | T012 | |
27 | RAHKTID | TB_RHKTID | HKTID | CHAR | 5 | 0 | Short key for house bank account | T012K | |
28 | RPZAHL | TB_RPZAHL_NEW | BU_PARTNER | CHAR | 10 | 0 | Payer/payee | BUT000 | |
29 | RPBANK | TB_RPBANK | BVTYP | CHAR | 4 | 0 | Partner bank details | ||
30 | SZART | TB_SZART | XFELD | CHAR | 1 | 0 | Payment transaction | ||
31 | ZLSCH | DZLSCH | ZLSCH | CHAR | 1 | 0 | Payment method | T042Z | |
32 | UZAWE | UZAWE | UZAWE | CHAR | 2 | 0 | Payment method supplement | T042F | |
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 | BELNR | BELNR_D | BELNR | CHAR | 10 | 0 | Accounting Document Number | ||
37 | GJAHR | GJAHR | GJAHR | NUMC | 4 | 0 | Fiscal Year | ||
38 | DBUCHUNG | BUDAT | DATUM | DATS | 8 | 0 | Posting Date in the Document | ||
39 | DFAELL | TB_DFAELL | DATUM | DATS | 8 | 0 | Due date | ||
40 | DZTERM | TB_DZTERM | DATUM | DATS | 8 | 0 | Payment or Delivery Date | ||
41 | BZBETR | TB_BZBETR | WERTV7 | CURR | 13 | 2 | Payment amount in payment currency | ||
42 | WZBETR | TB_WZBETR | WAERS | CUKY | 5 | 0 | Payment Currency | TCURC | |
43 | BHWBETR | TB_HWBETR | WERTV7 | CURR | 13 | 2 | Payment Amount in Local Currency | ||
44 | KHWKURS | TB_KHWKURS | UKURS | DEC | 9 | 5 | Local currency rate | ||
45 | ASTUECK | TB_ASTUECK | ASTUECK | DEC | 15 | 5 | No. of Units for Financial Instruments | ||
46 | BPRICE | TB_BPRICE | WERTV7 | CURR | 13 | 2 | Price per unit | ||
47 | WPRICE | TB_WPRICE | WAERS | CUKY | 5 | 0 | Price currency | TCURC | |
48 | BHWPREIS | TB_HWPREIS | WERTV7 | CURR | 13 | 2 | Price in local currency | ||
49 | BINDEX | TB_BINDEX | BWHR | CURR | 13 | 2 | Value of a point | ||
50 | VVBASIS | TB_VVBASIS | T_PKTKUR | DEC | 11 | 6 | Price in points | ||
51 | PWKURS | TB_PWKURS | DEC3_7 | DEC | 10 | 7 | Price as percentage quotation | ||
52 | BNWHR | TB_BNWHR | WERTV7 | CURR | 13 | 2 | Nominal amount | ||
53 | RHANDPL | VVRHANDPL | VVRHANDPL | CHAR | 10 | 0 | Exchange | TWH01 | |
54 | SKURSART | TI_KURSART | VVSKURSART | CHAR | 2 | 0 | Rate/Price Type - Treasury Instruments | TW56 | |
55 | DBERVON | DBERVON | DATUM | DATS | 8 | 0 | Start of Calculation Period | ||
56 | DBERBIS | DBERBIS | DATUM | DATS | 8 | 0 | End of Calculation Period | ||
57 | ATAGE | VVATAGE | INT6 | NUMC | 6 | 0 | Number of days | ||
58 | ABASTAGE | ABASTAGE | INT6 | NUMC | 6 | 0 | Number of base days in a calculation period | ||
59 | PKOND | PKOND | DECV3_7 | DEC | 10 | 7 | Percentage rate for condition items | ||
60 | SZSREF | SZSREF | ZIREFKU | CHAR | 10 | 0 | Reference Interest Rate | T056R | |
61 | SFORMREF | TB_XFORMBE | T_FORMBE | CHAR | 4 | 0 | Formula Reference | AT30 | |
62 | SVARNAME | TB_VARNAME | T_XFELD04 | CHAR | 4 | 0 | Variable Name | ||
63 | DPKOND | VVDPKOND | DATUM | DATS | 8 | 0 | Determination date for percentage rate of condition items | ||
64 | DZFEST | TB_DZFEST | DATUM | DATS | 8 | 0 | Interest rate fixing date | ||
65 | SZBMETH | SZBMETH | SZBMETH | CHAR | 1 | 0 | Interest Calculation Method | ||
66 | SKALIDWT | TFMSKALIDWT | WFCID | CHAR | 2 | 0 | Interest Calendar | * | |
67 | BBASIS | BBASIS | WERTV7 | CURR | 13 | 2 | Calculation base amount | ||
68 | WBASIS | TB_WBASIS | WAERS | CUKY | 5 | 0 | Currency of calculation basis | TCURC | |
69 | SINCL | VVSINCL | VVSINCL | NUMC | 1 | 0 | Inclusive indicator for beginning and end of a period | ||
70 | SINCLBIS | VVSINCLBIS | VVSINCLBIS | NUMC | 1 | 0 | Inclusive Indicator for the End of a Calculation Period | ||
71 | SULTBIS | VVSULTBIS | VVSULT | CHAR | 1 | 0 | Month-End Indicator for the End of a Calculation Period | ||
72 | SEXCLVON | VVSEXCLVON | VVSEXCLVON | NUMC | 1 | 0 | Exclusive Indicator for the Start of a Calculation Period | ||
73 | SULTVON | VVSULTVON | VVSULT | CHAR | 1 | 0 | Month-End Indicator for Start of a Calculation Period | ||
74 | SAEND | TFM_SAEND | TFM_SAEND | NUMC | 1 | 0 | Change Indicator for FiMa Flow Records | ||
75 | DVALUT | DVALUT | DATUM | DATS | 8 | 0 | Calculation Date | ||
76 | SVINCL | VVSVINCL | VVSINCL | NUMC | 1 | 0 | Inclusive indicator for value date | ||
77 | SVULT | VVSVULT | VVSULT | CHAR | 1 | 0 | Month-End Indicator for Value Date | ||
78 | SALTSATZ | XFELD | XFELD | CHAR | 1 | 0 | Checkbox | ||
79 | REGI_STATE | TB_IRA_REGISTRATION_STATE | T_IRA_REGISTRATION_STATE | CHAR | 2 | 0 | Status of Interest Rate Adjustment |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | VTBPFHAPO | BUKRS | T001 | BUKRS | KEY | 1 | CN |
2 | VTBPFHAPO | MANDT | T000 | MANDT | KEY | 1 | CN |
3 | VTBPFHAPO | RAHABKI | T012 | HBKID | REF | C | CN |
4 | VTBPFHAPO | RAHKTID | T012K | HKTID | REF | C | CN |
5 | VTBPFHAPO | RFHA | VTBFHA | RFHA | KEY | 1 | CN |
6 | VTBPFHAPO | RHANDPL | TWH01 | RHANDPL | REF | C | CN |
7 | VTBPFHAPO | RPZAHL | BUT000 | PARTNER | REF | C | CN |
8 | VTBPFHAPO | RREFKONT | T037S | RREFKONT | REF | C | CN |
9 | VTBPFHAPO | SBERFIMA | AT40 | SBERFIMA | |||
10 | VTBPFHAPO | SBKTYP | AT07 | SBKTYP | KEY | 1 | CN |
11 | VTBPFHAPO | SFHAZBA | TZB0A | SBEWART | KEY | 1 | CN |
12 | VTBPFHAPO | SFORMREF | AT30 | RFORMBEZ | REF | C | CN |
13 | VTBPFHAPO | SKOART | TZK01 | SKOART | KEY | 1 | CN |
14 | VTBPFHAPO | SKURSART | TW56 | SKURSART | REF | C | CN |
15 | VTBPFHAPO | SZSREF | T056R | REFERENZ | REF | C | CN |
16 | VTBPFHAPO | UZAWE | T042F | UZAWE | REF | C | CN |
17 | VTBPFHAPO | WBASIS | TCURC | WAERS | REF | C | CN |
18 | VTBPFHAPO | WPRICE | TCURC | WAERS | REF | C | CN |
19 | VTBPFHAPO | WZBETR | TCURC | WAERS | KEY | 1 | CN |
20 | VTBPFHAPO | ZLSCH | T042Z | ZLSCH | REF | C | CN |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in |