SAP ABAP View V_DB_TFK047B (Database View for Search Help for Item Dunning Procedure)

Hierarchy

☛ FI-CA (Software Component) FI-CA
   ⤷ FI-CA (Application Component) Contract Accounts Receivable and Payable
     ⤷ FKKB (Package) Contract A/R & A/P: Central Objects

Basic Data

View Type	D	Database View
Database View	V_DB_TFK047B
Short Description	Database View for Search Help for Item Dunning Procedure
Root table	TFK047A	Dunning procedure

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	TFK047A	TFK047A
2	TFK047B
3	TFK047BT

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	TFK047A	MANDT	JL	EQ				0	0
2	TFK047B	MANDT	JR	EQ			AND	0	0
3	TFK047A	MAHNV	JL	EQ				0	0
4	TFK047B	MAHNV	JR	EQ			AND	0	0
5	TFK047B	MANDT	JL	EQ				0	0
6	TFK047BT	MANDT	JR	EQ			AND	0	0
7	TFK047B	MAHNV	JL	EQ				0	0
8	TFK047BT	MAHNV	JR	EQ			AND	0	0
9	TFK047B	MAHNS	JL	EQ				0	0
10	TFK047BT	MAHNS	JR	EQ			AND	0	0
11	TFK047A	MVTYP		NE	'05'			0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	TFK047A	MANDT		☐	MANDT	☐	Client
2	MAHNV	TFK047A	MAHNV		☐	MAHNV_KK	☐	Dunning Procedure
3	MVTYP	TFK047A	MVTYP		☐	MVTYP_KK	☐	Dunning Procedure Category
4	MAHNS	TFK047B	MAHNS		☐	MAHNS_KK	☐	Dunning Level
5	SPRAS	TFK047BT	SPRAS		☐	SPRAS	☐	Language Key
6	MTEXT	TFK047BT	MTEXT		☐	TX010_KK	☐	Name of Dunning Level

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	20130529
SAP Release Created in	600