SAP ABAP View FDW1_TZPA (View Using FDW1 with Product Type)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ FVVW (Package) Treasury Management: Securities

Basic Data

View Type	D	Database View
Database View	FDW1_TZPA
Short Description	View Using FDW1 with Product Type
Root table	FDW1	Cash Mgt and Forecast - Securities Line Items- Planned Flows

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	FDW1	FDW1
2	VWBEPP
3	VWPANLA

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	FDW1	MANDT	JL	EQ				0	0
2	VWBEPP	MANDT	JR	EQ			AND	0	0
3	FDW1	BUKRS	JL	EQ				0	0
4	VWBEPP	BUKRS	JR	EQ			AND	0	0
5	FDW1	RANL	JL	EQ				0	0
6	VWBEPP	RANL	JR	EQ			AND	0	0
7	FDW1	RLDEPO	JL	EQ				0	0
8	VWBEPP	RLDEPO	JR	EQ			AND	0	0
9	FDW1	DTRANS	JL	EQ				0	0
10	VWBEPP	DTRANS	JR	EQ			AND	0	0
11	FDW1	TTRANS	JL	EQ				0	0
12	VWBEPP	TTRANS	JR	EQ			AND	0	0
13	FDW1	NTRANS	JL	EQ				0	0
14	VWBEPP	NTRANS	JR	EQ			AND	0	0
15	VWPANLA	MANDT	JL	EQ				0	0
16	VWBEPP	MANDT	JR	EQ			AND	0	0
17	VWPANLA	RANL	JL	EQ				0	0
18	VWBEPP	RANL	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	FDW1	MANDT		☐	MANDT	☐	Client
2	BUKRS	FDW1	BUKRS		☐	BUKRS	☐	Company Code
3	RANL	FDW1	RANL		☐	VVRANLW	☐	Security ID Number
4	RLDEPO	FDW1	RLDEPO		☐	RLDEPO	☐	Securities Account
5	DTRANS	FDW1	DTRANS		☐	VVDTRANS	☐	Flow data key: System date
6	TTRANS	FDW1	TTRANS		☐	VVTTRANS	☐	Transaction data key: system time
7	NTRANS	FDW1	NTRANS		☐	VVNTRANS	☐	Transaction data key: Consecutive number
8	SSOLHAB	FDW1	SSOLHAB		☐	OVERW1	☐	Not used
9	SFDLEV	FDW1	SFDLEV		☐	FDLEV	☐	Planning Level
10	KOART	FDW1	KOART		☐	KOART	☐	Account type
11	FDGRP	FDW1	FDGRP		☐	FDGRP	☐	Planning Group
12	RBANKK	FDW1	RBANKK		☐	RBANKK	☐	Bank account
13	DDISPO	FDW1	DDISPO		☐	VVDWERTST	☐	Value date / planning day
14	GSBER	FDW1	GSBER		☐	GSBER	☐	Business Area
15	SCWHR	FDW1	SCWHR		☐	SCWHR	☐	Settlement Currency
16	BCWHR	FDW1	BCWHR		☐	BCWHR	☐	Settlement Amount
17	BHWHR	FDW1	BHWHR		☐	BHWHR	☐	Amount in local currency
18	SVORGKZ	FDW1	SVORGKZ		☐	VVSVORGKZ	☐	Activity indicator for debit/credit control
19	SANLF	VWPANLA	SANLF		☐	SANLF	☐	Product Category
20	GSART	VWPANLA	GSART		☐	VVSART	☐	Product Type
21	SBEWART	VWBEPP	SBEWART		☐	SBEWART	☐	Flow Type
22	SBEWZITI	VWBEPP	SBEWZITI		☐	SBEWZITI	☐	Flow category

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	20131127
SAP Release Created in	200