SAP ABAP View VFM_KNXX (View of KNA1, KNB1, KNB5 for dunning notices)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ FBM (Package) Dunning

Basic Data

View Type	D	Database View
Database View	VFM_KNXX
Short Description	View of KNA1, KNB1, KNB5 for dunning notices
Root table	KNA1	General Data in Customer Master

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	KNA1	KNA1
2	KNB1
3	KNB5

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	KNA1	MANDT	JL	EQ				0	0
2	KNB1	MANDT	JR	EQ			AND	0	0
3	KNA1	KUNNR	JL	EQ				0	0
4	KNB1	KUNNR	JR	EQ			AND	0	0
5	KNB1	MANDT	JL	EQ				0	0
6	KNB5	MANDT	JR	EQ			AND	0	0
7	KNB1	KUNNR	JL	EQ				0	0
8	KNB5	KUNNR	JR	EQ			AND	0	0
9	KNB1	BUKRS	JL	EQ				0	0
10	KNB5	BUKRS	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	KNA1	MANDT		☐	MANDT	☐	Client
2	KUNNR	KNA1	KUNNR		☐	KUNNR	☐	Customer Number
3	BUKRS	KNB1	BUKRS		☐	BUKRS	☐	Company Code
4	MABER	KNB5	MABER		☐	MABER	☐	Dunning Area
5	XCPDK	KNA1	XCPDK		☐	XCPDK	☐	Indicator: Is the account a one-time account?
6	LIFNR	KNA1	LIFNR		☐	LIFNR	☐	Account Number of Vendor or Creditor
7	BUSAB_KNB1	KNB1	BUSAB		☐	BUSAB	☐	Accounting clerk
8	XVERR	KNB1	XVERR		☐	XVERR_KNB1	☐	Indicator: Clearing between customer and vendor ?
9	ZAHLS	KNB1	ZAHLS		☐	DZAHLS	☐	Block Key for Payment
10	VZSKZ	KNB1	VZSKZ		☐	VZSKZ	☐	Interest calculation indicator
11	XDEZV	KNB1	XDEZV		☐	XDEZV	☐	Indicator: Local processing?
12	ZWELS	KNB1	ZWELS		☐	DZWELS	☐	List of the Payment Methods to be Considered
13	MAHNA	KNB5	MAHNA		☐	MAHNA	☐	Dunning Procedure
14	MANSP	KNB5	MANSP		☐	MANSP	☐	Dunning block
15	MADAT	KNB5	MADAT		☐	MADAT	☐	Date of Last Dunning Notice
16	MAHNS	KNB5	MAHNS		☐	MAHNS_D	☐	Dunning Level
17	KNRMA	KNB5	KNRMA		☐	KNRMA	☐	Account number of the dunning recipient
18	GMVDT	KNB5	GMVDT		☐	GMVDT	☐	Date of the legal dunning proceedings
19	BUSAB	KNB5	BUSAB		☐	BUSAB_MA	☐	Dunning clerk
20	MGRUP	KNB1	MGRUP		☐	MGRUP	☐	Key for dunning notice grouping
21	LAND1	KNA1	LAND1		☐	LAND1_GP	☐	Country Key
22	ORT01	KNA1	ORT01		☐	ORT01_GP	☐	City
23	PFACH	KNA1	PFACH		☐	PFACH	☐	PO Box
24	STRAS	KNA1	STRAS		☐	STRAS_GP	☐	House number and street
25	PSTL2	KNA1	PSTL2		☐	PSTL2	☐	P.O. Box Postal Code
26	PSTLZ	KNA1	PSTLZ		☐	PSTLZ	☐	Postal Code

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

History

Last changed by/on	SAP	20131127
SAP Release Created in