SAP ABAP Table FTI_BIW_SEC_ID_ATTR (CFM: Class Master Data - Reduced to Max. 16-Character Names)
Hierarchy
☛
EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
⤷ FIN-FSCM-TRM-TM-IS (Application Component) Information System
⤷ CFM_TR_BIW (Package) CFM: Connection to BW
⤷ FIN-FSCM-TRM-TM-IS (Application Component) Information System
⤷ CFM_TR_BIW (Package) CFM: Connection to BW
Basic Data
Table Category | INTTAB | Structure |
Structure | FTI_BIW_SEC_ID_ATTR | Table Relationship Diagram |
Short Description | CFM: Class Master Data - Reduced to Max. 16-Character Names |
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 | SECURITY_NUMBER | WP_RANL | WP_RANL | CHAR | 13 | 0 | Security ID number | VWPANLA | |
2 | COMMODITY_ID | FTI_COMM_ID | CHAR18 | CHAR | 18 | 0 | Commodity ID | ||
3 | CONTRACT_SIZE | TPM_CTY_CONTRACT_SIZE | QUAN | 13 | 3 | Contract Size | |||
4 | CONTRACT_SZ_UNIT | TPM_CTY_CONTRACT_SIZE_UNIT | MEINS | UNIT | 3 | 0 | Contract size Unit of measure | * | |
5 | BETICK_CTY | FTI_BETICK_COMMODITY | DEC | 13 | 7 | Tick as amount (Commodity) | |||
6 | BWTICK_CTY | FTI_BWTICK_COMMODITY | DEC | 13 | 7 | Tick value (Commodity) | |||
7 | PRODUCT_CATEGORY | SANLF | VVSANLF | NUMC | 3 | 0 | Product Category | TZAF | |
8 | PRODUCT_TYPE | VVSART | VVSART | CHAR | 3 | 0 | Product Type | TZPA | |
9 | LISTED | SEC_LISTED | ATXF1 | CHAR | 1 | 0 | Indicator: Listed on an Exchange | ||
10 | QUOTATION | SNOTI | SNOTI | NUMC | 1 | 0 | Quotation Indicator | ||
11 | ISSUER | REPKE_NEW | BU_PARTNER | CHAR | 10 | 0 | Issuer Identity Key | * | |
12 | ISSUE_CCY | REWHR | WAERS | CUKY | 5 | 0 | Issue currency | * | |
13 | ISSUE_PRICE | VVKBEMPR | VVKWKURS | DEC | 15 | 6 | Issue price independent of currency | ||
14 | ISSUE_RATE | PEMKURS | DEC3_7 | DEC | 10 | 7 | Issue rate in percent | ||
15 | SSTBE | SSTBE | JANEI | CHAR | 1 | 0 | Tax treatment indicator | ||
16 | SEC_CATEGORY | ALWPKL | ALWPKL | CHAR | 3 | 0 | General Security Classification | * | |
17 | RATING | BP_RATING | BP_RATING | CHAR | 3 | 0 | Rating | * | |
18 | INSTITUTE | BP_SOL_INS | BP_SOL_INS | CHAR | 4 | 0 | Institute Providing Credit Standing Information | * | |
19 | TERM_FROM | FTI_LDB_FP_TERMFROM | DATUM | DATS | 8 | 0 | Start of Term | ||
20 | TERM_UPTO | FTI_LDB_FP_TERMUPTO | DATUM | DATS | 8 | 0 | End of Term | ||
21 | SECURITY_TYPE | SWERTTYP | SAKTTYP | NUMC | 1 | 0 | Security Type ID | * | |
22 | ELIGIBLE | SEC_ELIGIBLE | ATXF1 | CHAR | 1 | 0 | Eligibility indicator | ||
23 | ELIG_AS_COLL | SEC_AS_COLL | ATXF1 | CHAR | 1 | 0 | Indicator eligible as collateral | ||
24 | ELIG_TO_SERVE | SEC_TO_SERVE | ATXF1 | CHAR | 1 | 0 | Eligible for premium reserve fund | ||
25 | NOM_VALUE_CI | VVBNEWE | VVKWKURS | DEC | 15 | 6 | Nominal Value per Stock (Independent of Currency) | ||
26 | FELLOW_PARTNER | JABMI | JANEI | CHAR | 1 | 0 | Joint partner vote indicator | ||
27 | SHAREH_TYPE | SARTBET | SARTBET | NUMC | 2 | 0 | Type of shareholding | * | |
28 | SHAREH_STRUCT | SKONBET | SKONBET | NUMC | 2 | 0 | Details about structure of shareholding | * | |
29 | SHARES_OUTSTAND | AAAAKTIE | DEC12 | DEC | 12 | 0 | Number of stocks issued | ||
30 | STOCK_CATEGORY | SAKAR | SAKAR | NUMC | 1 | 0 | Stock category | ||
31 | STOCK_FORM | SVBRE | SVBRE | NUMC | 1 | 0 | Stock form indicator | ||
32 | FUND_TYPE | SFOTY | SFOTY | NUMC | 1 | 0 | Fund type indicator | * | |
33 | FUND_CATEGORY | VVSFOART | VVSFOART | CHAR | 2 | 0 | Fund category indicator | ||
34 | FUND_VOLUME | BAPI_BFONVOL | BAPICURR | DEC | 23 | 4 | Fund volume | ||
35 | PUBLIC_FUND | SOEFF | JANEI | CHAR | 1 | 0 | Public fund indicator | ||
36 | ISSUE_PREMIUM | PAUSG | DEC3_7 | DEC | 10 | 7 | Issue premium in percentage | ||
37 | FOREIGN_INV_LAW | SAING | JANEI | CHAR | 1 | 0 | Foreign Investment Law indicator | ||
38 | ACCUMULATION | STHES | JANEI | CHAR | 1 | 0 | Reinvestment indicator | ||
39 | REINV_DISCOUNT | PWARB | DEC3_7 | DEC | 10 | 7 | Reinvestment discount percent | ||
40 | CLASSIFICATION | SWPKLASS | SWPKLASS | NUMC | 3 | 0 | Classification of bond | * | |
41 | NOMINAL_VALUE | BAPI_BNOMS | BAPICURR | DEC | 23 | 4 | Nominal value | ||
42 | TRADING_UNIT | BAPI_BNHAE | BAPICURR | DEC | 23 | 4 | Nominal per trading unit | ||
43 | SECONDARY_LOANS | VVJNACHR | JANE | CHAR | 1 | 0 | Secondary loans ID | ||
44 | ISSUE_YIELD | ISSUE_YIELD | DEC3_7 | DEC | 10 | 7 | Issue Yield | ||
45 | PERCENTAGE_RATE | PKOND | DECV3_7 | DEC | 10 | 7 | Percentage rate for condition items | ||
46 | YIELD_METHOD | SEFFMETH | SEFFMETH | NUMC | 1 | 0 | Effective Interest Method (Financial Mathematics) | ||
47 | INT_CALC_METHOD | SZBMETH | SZBMETH | CHAR | 1 | 0 | Interest Calculation Method | ||
48 | REF_INT_RATE | SZSREF | ZIREFKU | CHAR | 10 | 0 | Reference Interest Rate | * | |
49 | REF_SIGN | SZSREFVZ | SZSREFVZ | CHAR | 1 | 0 | +/- sign / reference interest rate operator | ||
50 | OPT_FUT_CATEGORY | TI_SOFTYP | T_SOFTYP | NUMC | 2 | 0 | Options/futures category | ||
51 | ORG_OPTTYPE | TV_OPTTYP | T_OPTTYP | NUMC | 3 | 0 | Original option category (on closing) | * | |
52 | SETTLEMENT_METH | TI_SABRMET | T_SABRMET | CHAR | 1 | 0 | Settlement Method Option | ||
53 | OPT_FUT_QUOT | TI_NOTTYPE | T_NOTTYPE | CHAR | 1 | 0 | Quotation type option/future | ||
54 | PUT_CALL_IND | TI_SPUTCAL | T_SPUTCAL | NUMC | 1 | 0 | Put/call indicator | ||
55 | SETTLEMENT_OPT | TI_SETTLFL | T_SETTLFL | CHAR | 1 | 0 | Settlement indicator | ||
56 | EXERCISE_TYPE_OP | SOPTAUS | SOPTAUS | NUMC | 1 | 0 | Exercise Type (American or European) | ||
57 | EXPIRY_DATE | TI_DVERF | DATUM | DATS | 8 | 0 | Expiration date | ||
58 | LAST_TRADING_DAY | TI_DLHAND | DATUM | DATS | 8 | 0 | Last trade date | ||
59 | SETTLEMENT_DAY | TI_DERFUE | DATUM | DATS | 8 | 0 | Settlement date | ||
60 | FACTORY_CALENDAR | SKALID | WFCID | CHAR | 2 | 0 | Factory calendar | * | |
61 | FINAL_DUE_DATE_F | DENDF | DATUM | DATS | 8 | 0 | Final due date | ||
62 | SECURITY_REF | WP_RANL | WP_RANL | CHAR | 13 | 0 | Security ID number | * | |
63 | SECURITY_INDEX | IDX | CHAR10 | CHAR | 10 | 0 | Securities Index | ||
64 | TICK_AMOUNT | BAPI_TI_BETICK | BAPICURR | DEC | 23 | 4 | Tick as amount | ||
65 | TICK_IN_POINTS | TI_PITICK | T_PKTKUR | DEC | 11 | 6 | Tick in index points | ||
66 | TICK_VALUE | BAPI_TI_BWTICK | BAPICURR | DEC | 23 | 4 | Tick value | ||
67 | NUMBER_OF_UNITS | ASTUECK | ASTUECK | DEC | 15 | 5 | Number of units for unit-quoted securities | ||
68 | INDEX_POINT_VAL | BAPI_TI_BPINDEX | BAPICURR | DEC | 23 | 4 | Value of an index point | ||
69 | STRIKE_AMOUNT | BAPI_TI_BSTRIKE | BAPICURR | DEC | 23 | 4 | Strike as amount | ||
70 | STRIKE_IN_POINTS | TI_PKSTRIK | DEC5_4 | DEC | 9 | 4 | Strike in points | ||
71 | VOTES_PER_SHARE | VOTES_PER_SHARE | VOTES_PER_SHARE | DEC | 15 | 6 | Voting Rights per Share | ||
72 | EXTRA_CAPITAL | BAPI_EXTRACAP | BAPICURR | DEC | 23 | 4 | Additional Stock Capital | ||
73 | PRICE_INDEX | TIDX_INDEX_NAME | TIDX_INDEX_NAME | CHAR | 15 | 0 | Name of Price Index | * | |
74 | SET_NAME | RDPT_SET_NAME | RDPT_SET_NAME | CHAR | 15 | 0 | Redemption Schedule Set | * | |
75 | VAR_OFFSET | FTI_VAR_OFFSET | DECV3_7 | DEC | 10 | 7 | Spread for Reference Interest Rate (Variable Interest) | ||
76 | FUNDED | SEC_FUNDED | ATXF1 | CHAR | 1 | 0 | Indicator: Funded | ||
77 | VALID_FROM | VALID_FRM | DATUM | DATS | 8 | 0 | Valid From | ||
78 | VALID_TO | VALID_TODAT | DATUM | DATS | 8 | 0 | Valid To | ||
79 | TRANCHE_CLASSIF | VVTRANCHECL | VVTRANCHECL | NUMC | 3 | 0 | Tranche Classification |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | FTI_BIW_SEC_ID_ATTR | PRODUCT_CATEGORY | TZAF | SANLF | |||
2 | FTI_BIW_SEC_ID_ATTR | PRODUCT_TYPE | TZPA | GSART | 1 | CN | |
3 | FTI_BIW_SEC_ID_ATTR | SECURITY_NUMBER | VWPANLA | RANL |
History
Last changed by/on | SAP | 20131127 |
SAP Release Created in | 110 |