SAP ABAP View VF_KRED (Database View for LFA1 and LFB1)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ FBAS (Package) Financial accounting 'Basis'

Basic Data

View Type	D	Database View
Database View	VF_KRED
Short Description	Database View for LFA1 and LFB1
Root table	LFA1	Vendor Master (General Section)

Table

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

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				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	LFB1	MANDT		☐	MANDT	☐	Client
2	LIFNR	LFB1	LIFNR		☐	LIFNR	☐	Account Number of Vendor or Creditor
3	BUKRS	LFB1	BUKRS		☐	BUKRS	☐	Company Code
4	ANRED	LFA1	ANRED		☐	ANRED	☐	Title
5	BBBNR	LFA1	BBBNR		☐	BBBNR	☐	International location number (part 1)
6	BBSNR	LFA1	BBSNR		☐	BBSNR	☐	International location number (Part 2)
7	BEGRU	LFA1	BEGRU		☐	BRGRU	☐	Authorization Group
8	BRSCH	LFA1	BRSCH		☐	BRSCH	☐	Industry key
9	BUBKZ	LFA1	BUBKZ		☐	BUBKZ	☐	Check digit for the international location number
10	DATLT	LFA1	DATLT		☐	DATLT	☐	Data communication line no.
11	DTAMS	LFA1	DTAMS		☐	DTAMS	☐	Report key for data medium exchange
12	DTAWS	LFA1	DTAWS		☐	DTAWS	☐	Instruction key for data medium exchange
13	ERDAT	LFA1	ERDAT		☐	ERDAT_RF	☐	Date on which the Record Was Created
14	ERNAM	LFA1	ERNAM		☐	ERNAM_RF	☐	Name of Person who Created the Object
15	ESRNR	LFA1	ESRNR		☐	ESRNR	☐	POR subscriber number
16	KONZS	LFA1	KONZS		☐	KONZS	☐	Group key
17	KUNNR	LFA1	KUNNR		☐	KUNNR	☐	Customer Number
18	LAND1	LFA1	LAND1		☐	LAND1_GP	☐	Country Key
19	LNRZA	LFA1	LNRZA		☐	LNRZA	☐	Account Number of the Alternative Payee
20	LOEVM	LFA1	LOEVM		☐	LOEVM_X	☐	Central Deletion Flag for Master Record
21	NAME1	LFA1	NAME1		☐	NAME1_GP	☐	Name 1
22	NAME2	LFA1	NAME2		☐	NAME2_GP	☐	Name 2
23	NAME3	LFA1	NAME3		☐	NAME3_GP	☐	Name 3
24	NAME4	LFA1	NAME4		☐	NAME4_GP	☐	Name 4
25	ORT01	LFA1	ORT01		☐	ORT01_GP	☐	City
26	ORT02	LFA1	ORT02		☐	ORT02_GP	☐	District
27	PFACH	LFA1	PFACH		☐	PFACH	☐	PO Box
28	PSTL2	LFA1	PSTL2		☐	PSTL2	☐	P.O. Box Postal Code
29	PSTLZ	LFA1	PSTLZ		☐	PSTLZ	☐	Postal Code
30	REGIO	LFA1	REGIO		☐	REGIO	☐	Region (State, Province, County)
31	SORTL	LFA1	SORTL		☐	SORTL	☐	Sort field
32	SPERR	LFA1	SPERR		☐	SPERB_X	☐	Central posting block
33	SPERM	LFA1	SPERM		☐	SPERM_X	☐	Centrally imposed purchasing block
34	SPRAS	LFA1	SPRAS		☐	SPRAS	☐	Language Key
35	STCD1	LFA1	STCD1		☐	STCD1	☐	Tax Number 1
36	STCD2	LFA1	STCD2		☐	STCD2	☐	Tax Number 2
37	STKZA	LFA1	STKZA		☐	STKZA	☐	Indicator: Business Partner Subject to Equalization Tax?
38	STKZU	LFA1	STKZU		☐	STKZU	☐	Liable for VAT
39	STRAS	LFA1	STRAS		☐	STRAS_GP	☐	House number and street
40	XCPDK	LFA1	XCPDK		☐	XCPDK	☐	Indicator: Is the account a one-time account?
41	XZEMP	LFA1	XZEMP		☐	XZEMP	☐	Indicator: Alternative payee in document allowed ?
42	VBUND	LFA1	VBUND		☐	RASSC	☐	Company ID of trading partner
43	FISKN	LFA1	FISKN		☐	FISKN_K	☐	Account number of the master record with fiscal address
44	FISKU	LFA1	FISKU		☐	FISKU	☐	Account Number of Master Record of Tax Office Responsible
45	STENR	LFA1	STENR		☐	STENR	☐	Tax Number at Responsible Tax Authority
46	SPERR_B	LFB1	SPERR		☐	SPERB_B	☐	Posting block for company code
47	LOEVM_B	LFB1	LOEVM		☐	LOEVM_B	☐	Deletion Flag for Master Record (Company Code Level)
48	ZUAWA	LFB1	ZUAWA		☐	DZUAWA	☐	Key for sorting according to assignment numbers
49	AKONT	LFB1	AKONT		☐	AKONT	☐	Reconciliation Account in General Ledger
50	BEGRU_B	LFB1	BEGRU		☐	BRGRU	☐	Authorization Group
51	VZSKZ	LFB1	VZSKZ		☐	VZSKZ	☐	Interest calculation indicator
52	ZWELS	LFB1	ZWELS		☐	DZWELS	☐	List of the Payment Methods to be Considered
53	XVERR	LFB1	XVERR		☐	XVERR_LFB1	☐	Indicator: Clearing between customer and vendor?
54	ZAHLS	LFB1	ZAHLS		☐	DZAHLS	☐	Block Key for Payment
55	ZTERM	LFB1	ZTERM		☐	DZTERM	☐	Terms of payment key
56	EIKTO	LFB1	EIKTO		☐	EIKTO_K	☐	Our account number with the vendor
57	ZSABE	LFB1	ZSABE		☐	DZSABE_K	☐	Clerk at vendor
58	KVERM	LFB1	KVERM		☐	KVERM	☐	Memo
59	FDGRV	LFB1	FDGRV		☐	FDGRV	☐	Planning group
60	BUSAB	LFB1	BUSAB		☐	BUSAB	☐	Accounting clerk
61	LNRZE	LFB1	LNRZE		☐	LNRZE	☐	Head office account number
62	LNRZB	LFB1	LNRZB		☐	LNRZB	☐	Account number of the alternative payee
63	ZINDT	LFB1	ZINDT		☐	DZINDT	☐	Key date of the last interest calculation
64	ZINRT	LFB1	ZINRT		☐	DZINRT	☐	Interest calculation frequency in months
65	DATLZ	LFB1	DATLZ		☐	DATLZ	☐	Date of the last interest calculation run
66	XDEZV	LFB1	XDEZV		☐	XDEZV	☐	Indicator: Local processing?
67	WEBTR	LFB1	WEBTR		☐	WEBTR	☐	Bill of exchange limit (in local currency)
68	KULTG	LFB1	KULTG		☐	KULTG	☐	Probable time until check is paid
69	REPRF	LFB1	REPRF		☐	REPRF	☐	Check Flag for Double Invoices or Credit Memos
70	TOGRU	LFB1	TOGRU		☐	TOGRU	☐	Tolerance group for the business partner/G/L account
71	HBKID	LFB1	HBKID		☐	HBKID	☐	Short key for a house bank
72	XPORE	LFB1	XPORE		☐	XPORE	☐	Indicator: Pay all items separately ?
73	QSZNR	LFB1	QSZNR		☐	QSZNR	☐	Certificate Number of the Withholding Tax Exemption
74	QSZDT	LFB1	QSZDT		☐	QSZDT	☐	Validity Date for Withholding Tax Exemption Certificate
75	QSSKZ	LFB1	QSSKZ		☐	QSSKZ	☐	Withholding Tax Code
76	BLNKZ	LFB1	BLNKZ		☐	BLNKZ	☐	Subsidy Indicator for Determining the Reduction Rates
77	KTOKK	LFA1	KTOKK		☐	KTOKK	☐	Vendor account group
78	TELBX	LFA1	TELBX		☐	TELBX	☐	Telebox number
79	TELF1	LFA1	TELF1		☐	TELF1	☐	First telephone number
80	TELF2	LFA1	TELF2		☐	TELF2	☐	Second telephone number
81	TELFX	LFA1	TELFX		☐	TELFX	☐	Fax Number
82	TELTX	LFA1	TELTX		☐	TELTX	☐	Teletex number
83	TELX1	LFA1	TELX1		☐	TELX1	☐	Telex number
84	ERDAT_B	LFB1	ERDAT		☐	ERDAT_RF	☐	Date on which the Record Was Created
85	ERNAM_B	LFB1	ERNAM		☐	ERNAM_RF	☐	Name of Person who Created the Object
86	STCEG	LFA1	STCEG		☐	STCEG	☐	VAT Registration Number
87	STKZN	LFA1	STKZN		☐	STKZN	☐	Natural Person
88	MINDK	LFB1	MINDK		☐	MINDK	☐	Minority Indicators
89	ALTKN	LFB1	ALTKN		☐	ALTKN	☐	Previous Master Record Number
90	ZGRUP	LFB1	ZGRUP		☐	DZGRUP	☐	Key for Payment Grouping
91	MGRUP	LFB1	MGRUP		☐	MGRUP	☐	Key for dunning notice grouping
92	ADRNR	LFA1	ADRNR		☐	ADRNR	☐	Address
93	UZAWE	LFB1	UZAWE		☐	UZAWE	☐	Payment method supplement
94	QLAND	LFB1	QLAND		☐	QLAND	☐	Withholding Tax Country Key
95	KRAUS	LFA1	KRAUS		☐	KRAUS_CM	☐	Credit information number
96	REVDB	LFA1	REVDB		☐	REVDB_CM	☐	Last review (external)
97	QSSYS	LFA1	QSSYS		☐	QSSYS_IST	☐	Vendor's QM system
98	GBORT	LFA1	GBORT		☐	GBORT_Q	☐	Place of birth of the person subject to withholding tax
99	GBDAT	LFA1	GBDAT		☐	GBDAT_Q	☐	Date of birth of the person subject to withholding tax
100	SEXKZ	LFA1	SEXKZ		☐	SEXKZ	☐	Key for the Sex of the Person Subject to Withholding Tax
101	KTOCK	LFA1	KTOCK		☐	KTOCK	☐	Reference Account Group for One-Time Account (Vendor)
102	PFORT	LFA1	PFORT		☐	PFORT_GP	☐	PO Box city
103	XEDIP	LFB1	XEDIP		☐	XEDIP	☐	Indicator: Send Payment Advices by EDI
104	SPERZ	LFA1	SPERZ		☐	SPERZ	☐	Payment Block
105	PERNR	LFB1	PERNR		☐	PERNR_D	☐	Personnel Number
106	QSREC	LFB1	QSREC		☐	QSREC	☐	Vendor Recipient Type
107	QSBGR	LFB1	QSBGR		☐	QSBGR	☐	Authority for Exemption from Withholding Tax
108	FRGRP	LFB1	FRGRP		☐	FRGRP	☐	Release Approval Group
109	TLFXS	LFB1	TLFXS		☐	TLFXS	☐	Accounting clerk's fax number at the customer/vendor
110	INTAD	LFB1	INTAD		☐	INTAD	☐	Internet address of partner company clerk
111	XLFZA	LFA1	XLFZA		☐	XLFZA	☐	Indicator: Alternative payee using account number
112	XLFZB	LFB1	XLFZB		☐	XLFZB	☐	Indicator: Alternative payee using account number
113	GUZTE	LFB1	GUZTE		☐	GUZTE	☐	Payment Terms Key for Credit Memos
114	TOGRR	LFB1	TOGRR		☐	TOGRR	☐	Tolerance group; Invoice Verification
115	XAUSZ	LFB1	XAUSZ		☐	XAUSZ	☐	Indicator for periodic account statements
116	GRICD	LFB1	GRICD		☐	J_1AGICD_D	☐	Activity Code for Gross Income Tax
117	GRIDT	LFB1	GRIDT		☐	J_1ADTYP_D	☐	Distribution Type for Employment Tax
118	NODEL	LFA1	NODEL		☐	NODEL_X	☐	Central deletion block for master record
119	CONFS	LFA1	CONFS		☐	CONFS_X	☐	Status of Change Authorization (Central)
120	UPDAT	LFA1	UPDAT		☐	UPDAT_RF	☐	Date on Which the Changes Were Confirmed
121	UPTIM	LFA1	UPTIM		☐	UPTIM_RF	☐	Time of Last Change Confirmation
122	NODEL_B	LFB1	NODEL		☐	NODEL_B	☐	Deletion bock for master record (company code level)
123	CONFS_B	LFB1	CONFS		☐	CONFS_B	☐	Status of Change Authorization (Company Code Level)
124	UPDAT_B	LFB1	UPDAT		☐	UPDAT_RF	☐	Date on Which the Changes Were Confirmed
125	UPTIM_B	LFB1	UPTIM		☐	UPTIM_RF	☐	Time of Last Change Confirmation
126	SCACD	LFA1	SCACD		☐	SCACD	☐	Standard carrier access code
127	J_1KFREPRE	LFA1	J_1KFREPRE		☐	REPRES	☐	Name of Representative
128	J_1KFTBUS	LFA1	J_1KFTBUS		☐	GESTYP	☐	Type of Business
129	J_1KFTIND	LFA1	J_1KFTIND		☐	INDTYP	☐	Type of Industry
130	TLFNS	LFB1	TLFNS		☐	TLFNS	☐	Accounting clerk's telephone number at business partner
131	SFRGR	LFA1	SFRGR		☐	SFRGR	☐	Forwarding Agent Freight Group

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