SAP ABAP View TPMV_DEDOC_FLOW2 (Derivatives Document: View of Lot Flows with Posting Data)

Hierarchy

☛ EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
   ⤷ FIN-FSCM-TRM-TM-BO (Application Component) Back Office
     ⤷ FTPM (Package) Treasury: Position Management

Basic Data

View Type	D	Database View
Database View	TPMV_DEDOC_FLOW2
Short Description	Derivatives Document: View of Lot Flows with Posting Data
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	RPOSNR	TPMT_DEDOC_POS	RPOSNR		☐	TPM_DEDOC_RPOSNR	☐	Item in a derivatives document
5	RLOT	TPMT_DEDOC_LOTPO	RLOT		☐	TPM_RLOT	☐	Single position number for TR position management
6	RDOCNREXT	TPMT_DEDOC_HDR	RDOCNREXT		☐	TPM_DEDOC_RDOCNREXT	☐	External document number of derivatives document
7	OBJNR_EXT	TPMT_DEDOC_HDR	OBJNR_EXT		☐	J_OBJNR	☐	Object number
8	TRPOSTINGSTATE	TPMT_DEDOC_HDR	TRPOSTINGSTATE		☐	TPM_DEDOC_POSTINGSTATE	☐	TR posting status of derivatives document
9	TRPOSTINGDATE	TPMT_DEDOC_HDR	TRPOSTINGDATE		☐	TPM_DEDOC_DPOSTINGDATE	☐	Treasury posting date of derivatives document
10	REVERSAL_REASON	TPMT_DEDOC_HDR	REVERSAL_REASON		☐	SSTOGRD	☐	Reason for Reversal
11	FIPOSTINGSTATE	TPMT_DEDOC_HDR	FIPOSTINGSTATE		☐	TPM_DEDOC_FIPOSTINGSTATE	☐	FI posting status of derivatives document
12	SBEWART	TPMT_DEDOC_POS	SBEWART		☐	SBEWART	☐	Flow Type
13	RANTYP_SBEWART	TPMT_DEDOC_POS	RANTYP_SBEWART		☐	RANTYP	☐	Contract Type
14	LOT_CAT	TPMT_DEDOC_POS	LOT_CAT		☐	TPM_DEAL_LOT_CATEGORY	☐	Category of a transaction for lot management
15	RANL	TPMT_DEDOC_POS	RANL		☐	VVRANLW	☐	Security ID Number
16	RLDEPO	TPMT_DEDOC_POS	RLDEPO		☐	VRLDEPO	☐	Securities Account
17	DBESTAND	TPMT_DEDOC_POS	DBESTAND		☐	DBESTAND	☐	Position value date
18	PM_CAT	TPMT_DEDOC_POS	PM_CAT		☐	TPM_DE_PM_CATEGORY	☐	Position management category derivatives
19	ASTUECK	TPMT_DEDOC_LOTPO	ASTUECK		☐	ASTUECK	☐	Number of units for unit-quoted securities
20	SNWHR	TPMT_DEDOC_LOTPO	SNWHR		☐	SNWHR	☐	Currency of nominal amount
21	BNWHR	TPMT_DEDOC_LOTPO	BNWHR		☐	BNWHR	☐	Nominal amount
22	SCWHR	TPMT_DEDOC_LOTPO	SCWHR		☐	SCWHR	☐	Settlement Currency
23	BCWHR	TPMT_DEDOC_LOTPO	BCWHR		☐	BCWHR	☐	Settlement Amount
24	SBWHR	TPMT_DEDOC_LOTPO	SBWHR		☐	SBWHR	☐	Position Currency (Currency of Position Amount)
25	BBWHR	TPMT_DEDOC_LOTPO	BBWHR		☐	BBWHR	☐	Amount in position currency
26	SHWHR	TPMT_DEDOC_LOTPO	SHWHR		☐	SHWHR	☐	Local currency
27	BHWHR	TPMT_DEDOC_LOTPO	BHWHR		☐	BHWHR	☐	Amount in local currency
28	RREFKONT	TPMT_DEDOC_POS	RREFKONT		☐	RREFKONT	☐	Account Assignment Reference in Financial Assets Management
29	RANTYP_RREFKONT	TPMT_DEDOC_POS	RANTYP_RREFKONT		☐	RANTYP	☐	Contract Type
30	GSBER	TPMT_DEDOC_POS	GSBER		☐	GSBER	☐	Business Area
31	DDISPO	TPMT_DEDOC_POS	DDISPO		☐	DDISPO	☐	Payment Date
32	TRSEDOCNR1	TPMT_DEDOC_POS	TRSEDOCNR1		☐	TRSEDOCNR	☐	Document number of security posting document
33	TRSEGJAHR1	TPMT_DEDOC_POS	TRSEGJAHR1		☐	GJAHR	☐	Fiscal Year
34	TRSEDOCNR2	TPMT_DEDOC_POS	TRSEDOCNR2		☐	TRSEDOCNR	☐	Document number of security posting document
35	TRSEGJAHR2	TPMT_DEDOC_POS	TRSEGJAHR2		☐	GJAHR	☐	Fiscal Year
36	RERF	TPMT_DEDOC_HDR	RERF		☐	RERF	☐	Entered by
37	DERF	TPMT_DEDOC_HDR	DERF		☐	DERF	☐	First Entered on
38	RBEAR	TPMT_DEDOC_HDR	RBEAR		☐	RBEAR	☐	Employee ID
39	DBEAR	TPMT_DEDOC_HDR	DBEAR		☐	DBEAR	☐	Last Edited on

Maintenance Status

Access

☑   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