SAP ABAP Table TERV_TRANS_FLOW (Generated Table for View)
Basic Data
Table Category | VIEW | General view structure |
General view structure | TERV_TRANS_FLOW | Table Relationship Diagram |
Short Description | Generated Table for View |
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 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | ||
2 | ERNR | TER_HEADNUMBER | TER_RIGHTNUMBER | CHAR | 13 | 0 | ID number of exercised right | ||
3 | COMPANY_CODE | BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | ||
4 | SECURITY_ID | TER_EXECRANL | WP_RANL | CHAR | 13 | 0 | ID number of exercised securities right | ||
5 | SECURITY_ACCOUNT | RLDEPO | RLDEPO | CHAR | 10 | 0 | Securities Account | ||
6 | COM_VAL_CLASS | TPM_COM_VAL_CLASS | TPM_COM_VAL_CLASS | NUMC | 4 | 0 | General Valuation Class | ||
7 | PORTFOLIO | RPORTB | RPORTB | CHAR | 10 | 0 | Portfolio | ||
8 | TRADER | RDEALER | RDEALER | CHAR | 12 | 0 | Trader | ||
9 | RIGHTTYPE | TER_RIGHTTYPE | TER_RIGHTTYPE | NUMC | 2 | 0 | Rights category of an executable right | ||
10 | RIGHTNUMBER | TER_RIGHTNUMBER | TER_RIGHTNUMBER | CHAR | 13 | 0 | ID number of executable right | ||
11 | EXECUTION_DATE | TER_SDATUM | DATUM | DATS | 8 | 0 | Key date for exercising rights | ||
12 | BUSTRANSID | TPM_BUSTRANSID | SYSUUID | RAW | 16 | 0 | Identifier of the Distributor Business Transaction | ||
13 | CREATE_DATE | TPM_BT_CREATE_DATE | DATUM | DATS | 8 | 0 | Creation Date of the Operative Business Transaction | ||
14 | CREATE_TIME | TPM_BT_CREATE_TIME | UZEIT | TIMS | 6 | 0 | Creation Time of the Operative Business Transaction | ||
15 | UNITS | TPM_UNITS | TPM_UNITS | DEC | 22 | 6 | Units | ||
16 | NOMINAL_AMT | TPM_NOMINAL_AMT | TPM_AMOUNT | CURR | 21 | 2 | Nominal Amount | ||
17 | NOMINAL_CURR | TPM_NOMINAL_CURR | WAERS | CUKY | 5 | 0 | Nominal Currency | ||
18 | EXERCISETYPE | SOPTTYP | SOPTTYP | NUMC | 1 | 0 | Indicator: Option Category | ||
19 | SETTLEMENT | SVERROPT | SVERROPT | NUMC | 1 | 0 | Option Settlement Indicator | ||
20 | EXPIRE | TER_EXPIRE | TER_EXPIRE | NUMC | 1 | 0 | Expiration of a right | ||
21 | STATUS | TER_STATUS_HEAD | TER_STATUS_HEAD | NUMC | 1 | 0 | Status of executed right | ||
22 | DOCUMENT_DATE | BLDAT | DATUM | DATS | 8 | 0 | Document Date in Document | ||
23 | FI_POSTING_DATE | TPM_FI_POSTING_DATE | DATUM | DATS | 8 | 0 | Different FI Posting Date | ||
24 | REVERSAL_REASON | SSTOGRD | SSTOGRD | CHAR | 2 | 0 | Reason for Reversal | ||
25 | BOOKING_TEXT | XZUSATZ | CHAR18 | CHAR | 18 | 0 | Assignment | ||
26 | SECURITY_ID1 | TER_RANL | WP_RANL | CHAR | 13 | 0 | ID number of reference security of an executable right | ||
27 | SECURITY_ID2 | TER_RANL | WP_RANL | CHAR | 13 | 0 | ID number of reference security of an executable right | ||
28 | INDEXTYPE | IDX | CHAR10 | CHAR | 10 | 0 | Securities Index | ||
29 | INDEXVALUE | IDXSTAND | VVPKTKUR | DEC | 15 | 6 | Index value | ||
30 | RATE_SEC_ID | VVPKTKUR | VVPKTKUR | DEC | 15 | 6 | Price of Unit- or Percentage-Quoted Security | ||
31 | RATE_SEC_ID1 | VVPKTKUR | VVPKTKUR | DEC | 15 | 6 | Price of Unit- or Percentage-Quoted Security | ||
32 | RATE_SEC_ID2 | VVPKTKUR | VVPKTKUR | DEC | 15 | 6 | Price of Unit- or Percentage-Quoted Security | ||
33 | CURR_SEC_ID | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | ||
34 | CURR_SEC_ID1 | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | ||
35 | CURR_SEC_ID2 | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | ||
36 | EXRATE1 | KURSF | KURSF | DEC | 9 | 5 | Exchange rate | ||
37 | EXRATE2 | KURSF | KURSF | DEC | 9 | 5 | Exchange rate | ||
38 | EXRATE3 | KURSF | KURSF | DEC | 9 | 5 | Exchange rate | ||
39 | CURR1_FROM | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | ||
40 | CURR1_TO | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | ||
41 | CURR2_TO | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | ||
42 | CURR2_FROM | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | ||
43 | CURR3_TO | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | ||
44 | CURR3_FROM | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | ||
45 | MIGRATION_FLG | CHAR1 | CHAR1 | CHAR | 1 | 0 | Single-Character Flag | ||
46 | RERF | RERF | SYCHAR12 | CHAR | 12 | 0 | Entered by | ||
47 | DERF | DERF | DATUM | DATS | 8 | 0 | First Entered on | ||
48 | TERF | TERF | TIMES | TIMS | 6 | 0 | Time of Initial Entry | ||
49 | REHER | REHER | CHAR10 | CHAR | 10 | 0 | Source of initial entry | ||
50 | RBEAR | RBEAR | SYCHAR12 | CHAR | 12 | 0 | Employee ID | ||
51 | DBEAR | DBEAR | DATUM | DATS | 8 | 0 | Last Edited on | ||
52 | TBEAR | TBEAR | TIMES | TIMS | 6 | 0 | Last Edited at | ||
53 | RBHER | RBHER | CHAR10 | CHAR | 10 | 0 | Editing Source | ||
54 | FLOW_NUMBER | TER_FLOWNUMBER | TER_FLOWNUMBER | INT4 | 10 | 0 | Flow Number of Rights Exercise | ||
55 | FLOW_CATEGORY | TER_FLOW_CATEGORY | TER_FLOW_CATEGORY | CHAR | 2 | 0 | Flow Category: Rights that can be Exercised | ||
56 | FLOW_TYPE | TPM_DIS_FLOWTYPE | TPM_DIS_FLOWTYPE | CHAR | 8 | 0 | Update Type | ||
57 | AMOUNT_FACTOR | TER_AMOUNT_FACTOR | TER_AMOUNT_FACTOR | FLTP | 16 | 16 | Value Factor: Rights can be Exercised | ||
58 | ALLOC_NMBR | DZUONR | ZUONR | CHAR | 18 | 0 | Assignment number | ||
59 | LOCAL_CURR | TPM_LOCAL_CURR | WAERS | CUKY | 5 | 0 | Local Currency | TCURC | |
60 | LOCAL_AMT | TPM_LOCAL_AMT | TPM_AMOUNT | CURR | 21 | 2 | Amount in Local Currency | ||
61 | PAYMENT_DATE | TPM_PAYMENT_DATE | TPM_POSITION_DATE | DATS | 8 | 0 | Payment Date | ||
62 | PAYMENT_AMT | TPM_PAYMENT_AMT | TPM_AMOUNT | CURR | 21 | 2 | Amount in Payment Currency | ||
63 | PAYMENT_CURR | TPM_PAYMENT_CURR | WAERS | CUKY | 5 | 0 | Payment Currency | ||
64 | HOUSE_BANK | TB_RHABKI | HBKID | CHAR | 5 | 0 | Short key for own house bank | ||
65 | HOUSE_BANK_ACC | TB_RHKTID | HKTID | CHAR | 5 | 0 | Short key for house bank account | ||
66 | POSITION_DATE | TER_POSITION_DATE | DATUM | DATS | 8 | 0 | Position Date: Rights that can be Exercised | ||
67 | POSITION_CURR | TPM_POSITION_CURR | WAERS | CUKY | 5 | 0 | Position Currency | TCURC | |
68 | POSITION_AMT | TPM_POSITION_AMT | TPM_AMOUNT | CURR | 21 | 2 | Amount in Position Currency | ||
69 | CALCULATION_DATE | DVALUT | DATUM | DATS | 8 | 0 | Calculation Date | ||
70 | CALC_DATE_INCL | VVSINCL | VVSINCL | NUMC | 1 | 0 | Inclusive indicator for beginning and end of a period |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | TERV_TRANS_FLOW | LOCAL_CURR | TCURC | WAERS | KEY | 1 | CN |
2 | TERV_TRANS_FLOW | POSITION_CURR | TCURC | WAERS | KEY | 1 | CN |
History
Last changed by/on | SAP | 20110901 |
SAP Release Created in |