SAP ABAP View VFM_LFXX (View of LFA1, LFB1, LFB5 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_LFXX
Short Description	View of LFA1, LFB1, LFB5 for dunning notices
Root table	LFA1	Vendor Master (General Section)

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	LFA1	LFA1
2	LFB1
3	LFB5

Join Conditions

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

View Fields

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

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