SAP ABAP View TPMV_LOT_FLOWS (Lot Flows)
Hierarchy
☛
EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
⤷ FIN-FSCM-TRM-TM-BO (Application Component) Back Office
⤷ FTPM (Package) Treasury: Position Management
⤷ FIN-FSCM-TRM-TM-BO (Application Component) Back Office
⤷ FTPM (Package) Treasury: Position Management
Basic Data
View Type | D | Database View |
Database View | TPMV_LOT_FLOWS | |
Short Description | Lot Flows | |
Root table | TPMT_DEDOC_HDR | Derivatives Document: Document Header |
Table
# | Table Name | Foreign Table | Foreign Field | Foreign DIR |
---|---|---|---|---|
1 | TPMT_DEDOC_HDR | TPMT_DEDOC_HDR | ||
2 | TPMT_DEDOC_POS | |||
3 | TPMT_DEDOC_LOTPO |
Join Conditions
# | Table Name | Field Name | Negation | Operator | Constants | Cont. line | AND/OR | Offset | F Length | Mco Field |
---|---|---|---|---|---|---|---|---|---|---|
1 | TPMT_DEDOC_HDR | MANDT | JL | EQ | 0 | 0 | ||||
2 | TPMT_DEDOC_POS | MANDT | JR | EQ | AND | 0 | 0 | |||
3 | TPMT_DEDOC_HDR | BUKRS | JL | EQ | 0 | 0 | ||||
4 | TPMT_DEDOC_POS | BUKRS | JR | EQ | AND | 0 | 0 | |||
5 | TPMT_DEDOC_HDR | RDOCNRINT | JL | EQ | 0 | 0 | ||||
6 | TPMT_DEDOC_POS | RDOCNRINT | JR | EQ | AND | 0 | 0 | |||
7 | TPMT_DEDOC_POS | MANDT | JL | EQ | 0 | 0 | ||||
8 | TPMT_DEDOC_LOTPO | MANDT | JR | EQ | AND | 0 | 0 | |||
9 | TPMT_DEDOC_POS | BUKRS | JL | EQ | 0 | 0 | ||||
10 | TPMT_DEDOC_LOTPO | BUKRS | JR | EQ | AND | 0 | 0 | |||
11 | TPMT_DEDOC_POS | RDOCNRINT | JL | EQ | 0 | 0 | ||||
12 | TPMT_DEDOC_LOTPO | RDOCNRINT | JR | EQ | AND | 0 | 0 | |||
13 | TPMT_DEDOC_POS | RPOSNR | JL | EQ | 0 | 0 | ||||
14 | TPMT_DEDOC_LOTPO | RPOSNR | JR | EQ | 0 | 0 | ||||
View Fields
# | View field | Table | Field | Maintenance Flag | Key | Data element | Mod | Short Description |
---|---|---|---|---|---|---|---|---|
1 | MANDT | TPMT_DEDOC_HDR | MANDT | MANDT | Client | |||
2 | BUKRS | TPMT_DEDOC_HDR | BUKRS | BUKRS | Company Code | |||
3 | RDOCNRINT | TPMT_DEDOC_HDR | RDOCNRINT | TPM_DEDOC_RDOCNRINT | Internal document number of derivatives document | |||
4 | RDOCNREXT | TPMT_DEDOC_HDR | RDOCNREXT | TPM_DEDOC_RDOCNREXT | External document number of derivatives document | |||
5 | OBJNR_EXT | TPMT_DEDOC_HDR | OBJNR_EXT | J_OBJNR | Object number | |||
6 | TRPOSTINGSTATE | TPMT_DEDOC_HDR | TRPOSTINGSTATE | TPM_DEDOC_POSTINGSTATE | TR posting status of derivatives document | |||
7 | TRPOSTINGDATE | TPMT_DEDOC_HDR | TRPOSTINGDATE | TPM_DEDOC_DPOSTINGDATE | Treasury posting date of derivatives document | |||
8 | REVERSAL_REASON | TPMT_DEDOC_HDR | REVERSAL_REASON | SSTOGRD | Reason for Reversal | |||
9 | FIPOSTINGSTATE | TPMT_DEDOC_HDR | FIPOSTINGSTATE | TPM_DEDOC_FIPOSTINGSTATE | FI posting status of derivatives document | |||
10 | BUSTRANSID | TPMT_DEDOC_HDR | BUSTRANSID | TPM_BUSTRANSID | Identifier of the Distributor Business Transaction | |||
11 | BUSTRANSCAT | TPMT_DEDOC_HDR | BUSTRANSCAT | TPM_BUSTRANSCAT | Business Transaction Category | |||
12 | MIGR_CFM10 | TPMT_DEDOC_HDR | MIGR_CFM10 | TPM_MIGR_CFM10 | Status of Flow Related to Migration to CFM 1.0 | |||
13 | RERF | TPMT_DEDOC_HDR | RERF | RERF | Entered by | |||
14 | DERF | TPMT_DEDOC_HDR | DERF | DERF | First Entered on | |||
15 | TERF | TPMT_DEDOC_HDR | TERF | TERF | Time of Initial Entry | |||
16 | REHER | TPMT_DEDOC_HDR | REHER | REHER | Source of initial entry | |||
17 | RBEAR | TPMT_DEDOC_HDR | RBEAR | RBEAR | Employee ID | |||
18 | DBEAR | TPMT_DEDOC_HDR | DBEAR | DBEAR | Last Edited on | |||
19 | TBEAR | TPMT_DEDOC_HDR | TBEAR | TBEAR | Last Edited at | |||
20 | RBHER | TPMT_DEDOC_HDR | RBHER | RBHER | Editing Source | |||
21 | RPOSNR | TPMT_DEDOC_POS | RPOSNR | TPM_DEDOC_RPOSNR | Item in a derivatives document | |||
22 | ASTUECK | TPMT_DEDOC_POS | ASTUECK | ASTUECK | Number of units for unit-quoted securities | |||
23 | SNWHR | TPMT_DEDOC_POS | SNWHR | SNWHR | Currency of nominal amount | |||
24 | BNWHR | TPMT_DEDOC_POS | BNWHR | BNWHR | Nominal amount | |||
25 | LOT_CAT | TPMT_DEDOC_POS | LOT_CAT | TPM_DEAL_LOT_CATEGORY | Category of a transaction for lot management | |||
26 | SCWHR | TPMT_DEDOC_POS | SCWHR | SCWHR | Settlement Currency | |||
27 | BCWHR | TPMT_DEDOC_POS | BCWHR | BCWHR | Settlement Amount | |||
28 | SBWHR | TPMT_DEDOC_POS | SBWHR | SBWHR | Position Currency (Currency of Position Amount) | |||
29 | BBWHR | TPMT_DEDOC_POS | BBWHR | BBWHR | Amount in position currency | |||
30 | SHWHR | TPMT_DEDOC_POS | SHWHR | SHWHR | Local currency | |||
31 | BHWHR | TPMT_DEDOC_POS | BHWHR | BHWHR | Amount in local currency | |||
32 | RANL | TPMT_DEDOC_POS | RANL | VVRANLW | Security ID Number | |||
33 | RLDEPO | TPMT_DEDOC_POS | RLDEPO | VRLDEPO | Securities Account | |||
34 | DBESTAND | TPMT_DEDOC_POS | DBESTAND | DBESTAND | Position value date | |||
35 | PM_CAT | TPMT_DEDOC_POS | PM_CAT | TPM_DE_PM_CATEGORY | Position management category derivatives | |||
36 | RREFKONT | TPMT_DEDOC_POS | RREFKONT | RREFKONT | Account Assignment Reference in Financial Assets Management | |||
37 | RANTYP_RREFKONT | TPMT_DEDOC_POS | RANTYP_RREFKONT | RANTYP | Contract Type | |||
38 | SBEWART | TPMT_DEDOC_POS | SBEWART | SBEWART | Flow Type | |||
39 | RANTYP_SBEWART | TPMT_DEDOC_POS | RANTYP_SBEWART | RANTYP | Contract Type | |||
40 | GSBER | TPMT_DEDOC_POS | GSBER | GSBER | Business Area | |||
41 | DDISPO | TPMT_DEDOC_POS | DDISPO | DDISPO | Payment Date | |||
42 | TRSEDOCNR1 | TPMT_DEDOC_POS | TRSEDOCNR1 | TRSEDOCNR | Document number of security posting document | |||
43 | TRSEGJAHR1 | TPMT_DEDOC_POS | TRSEGJAHR1 | GJAHR | Fiscal Year | |||
44 | TRSEDOCNR2 | TPMT_DEDOC_POS | TRSEDOCNR2 | TRSEDOCNR | Document number of security posting document | |||
45 | TRSEGJAHR2 | TPMT_DEDOC_POS | TRSEGJAHR2 | GJAHR | Fiscal Year | |||
46 | RLOT | TPMT_DEDOC_LOTPO | RLOT | TPM_RLOT | Single position number for TR position management | |||
47 | ASTUECK_L | TPMT_DEDOC_LOTPO | ASTUECK | ASTUECK | Number of units for unit-quoted securities | |||
48 | BNWHR_L | TPMT_DEDOC_LOTPO | BNWHR | BNWHR | Nominal amount | |||
49 | BCWHR_L | TPMT_DEDOC_LOTPO | BCWHR | BCWHR | Settlement Amount | |||
50 | BBWHR_L | TPMT_DEDOC_LOTPO | BBWHR | BBWHR | Amount in position currency | |||
51 | BHWHR_L | TPMT_DEDOC_LOTPO | BHWHR | BHWHR | Amount in local currency | |||
Maintenance Status
read only |
read and change |
Time-dependent views: like U, validity data like ' ' |
read, change, delete and insert |
Delivery Class | ||
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
History
Last changed by/on | SAP | 20110901 |
SAP Release Created in | 463_20 |