SAP ABAP View VFC_KRED (View For Balance Audit Trail With A/B/C Data)

Hierarchy

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

Basic Data

View Type	D	Database View
Database View	VFC_KRED
Short Description	View For Balance Audit Trail With A/B/C Data
Root table	LFA1	Vendor Master (General Section)

Table

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

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	LFC1	MANDT	JR	EQ			AND	0	0
7	LFB1	LIFNR	JL	EQ				0	0
8	LFC1	LIFNR	JR	EQ			AND	0	0
9	LFB1	BUKRS	JL	EQ				0	0
10	LFC1	BUKRS	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	LFC1	MANDT		☐	MANDT	☐	Client
2	LIFNR	LFC1	LIFNR		☐	LIFNR	☐	Account Number of Vendor or Creditor
3	BUKRS	LFC1	BUKRS		☐	BUKRS	☐	Company Code
4	GJAHR	LFC1	GJAHR		☐	GJAHR	☐	Fiscal Year
5	BBBNR	LFA1	BBBNR		☐	BBBNR	☐	International location number (part 1)
6	BBSNR	LFA1	BBSNR		☐	BBSNR	☐	International location number (Part 2)
7	BRSCH	LFA1	BRSCH		☐	BRSCH	☐	Industry key
8	BUBKZ	LFA1	BUBKZ		☐	BUBKZ	☐	Check digit for the international location number
9	KTOKK	LFA1	KTOKK		☐	KTOKK	☐	Vendor account group
10	LAND1	LFA1	LAND1		☐	LAND1_GP	☐	Country Key
11	NAME1	LFA1	NAME1		☐	NAME1_GP	☐	Name 1
12	NAME2	LFA1	NAME2		☐	NAME2_GP	☐	Name 2
13	ORT01	LFA1	ORT01		☐	ORT01_GP	☐	City
14	ORT02	LFA1	ORT02		☐	ORT02_GP	☐	District
15	PFACH	LFA1	PFACH		☐	PFACH	☐	PO Box
16	PSTL2	LFA1	PSTL2		☐	PSTL2	☐	P.O. Box Postal Code
17	PSTLZ	LFA1	PSTLZ		☐	PSTLZ	☐	Postal Code
18	REGIO	LFA1	REGIO		☐	REGIO	☐	Region (State, Province, County)
19	SORTL	LFA1	SORTL		☐	SORTL	☐	Sort field
20	SPRAS	LFA1	SPRAS		☐	SPRAS	☐	Language Key
21	STCD1	LFA1	STCD1		☐	STCD1	☐	Tax Number 1
22	STCD2	LFA1	STCD2		☐	STCD2	☐	Tax Number 2
23	STRAS	LFA1	STRAS		☐	STRAS_GP	☐	House number and street
24	STKZA	LFA1	STKZA		☐	STKZA	☐	Indicator: Business Partner Subject to Equalization Tax?
25	STKZU	LFA1	STKZU		☐	STKZU	☐	Liable for VAT
26	TELBX	LFA1	TELBX		☐	TELBX	☐	Telebox number
27	TELF1	LFA1	TELF1		☐	TELF1	☐	First telephone number
28	TELF2	LFA1	TELF2		☐	TELF2	☐	Second telephone number
29	TELFX	LFA1	TELFX		☐	TELFX	☐	Fax Number
30	TELTX	LFA1	TELTX		☐	TELTX	☐	Teletex number
31	TELX1	LFA1	TELX1		☐	TELX1	☐	Telex number
32	XCPDK	LFA1	XCPDK		☐	XCPDK	☐	Indicator: Is the account a one-time account?
33	XZEMP	LFA1	XZEMP		☐	XZEMP	☐	Indicator: Alternative payee in document allowed ?
34	VBUND	LFA1	VBUND		☐	RASSC	☐	Company ID of trading partner
35	ERNAM	LFB1	ERNAM		☐	ERNAM_RF	☐	Name of Person who Created the Object
36	BEGRU	LFB1	BEGRU		☐	BRGRU	☐	Authorization Group
37	VZSKZ	LFB1	VZSKZ		☐	VZSKZ	☐	Interest calculation indicator
38	ZWELS	LFB1	ZWELS		☐	DZWELS	☐	List of the Payment Methods to be Considered
39	ZAHLS	LFB1	ZAHLS		☐	DZAHLS	☐	Block Key for Payment
40	ZTERM	LFB1	ZTERM		☐	DZTERM	☐	Terms of payment key
41	EIKTO	LFB1	EIKTO		☐	EIKTO_K	☐	Our account number with the vendor
42	ZSABE	LFB1	ZSABE		☐	DZSABE_K	☐	Clerk at vendor
43	BUSAB	LFB1	BUSAB		☐	BUSAB	☐	Accounting clerk
44	LNRZE	LFB1	LNRZE		☐	LNRZE	☐	Head office account number
45	ZINDT	LFB1	ZINDT		☐	DZINDT	☐	Key date of the last interest calculation
46	ZINRT	LFB1	ZINRT		☐	DZINRT	☐	Interest calculation frequency in months
47	WEBTR	LFB1	WEBTR		☐	WEBTR	☐	Bill of exchange limit (in local currency)
48	BLNKZ	LFB1	BLNKZ		☐	BLNKZ	☐	Subsidy Indicator for Determining the Reduction Rates
49	ZUAWA	LFB1	ZUAWA		☐	DZUAWA	☐	Key for sorting according to assignment numbers
50	AKONT	LFB1	AKONT		☐	AKONT	☐	Reconciliation Account in General Ledger
51	UMSAV	LFC1	UMSAV		☐	UMSAV	☐	Balance Carried Forward in Local Currency
52	UM01S	LFC1	UM01S		☐	UMXXS	☐	Total of the Debit Postings for the Month
53	UM01H	LFC1	UM01H		☐	UMXXH	☐	Total of the Credit Postings for the Month
54	UM02S	LFC1	UM02S		☐	UMXXS	☐	Total of the Debit Postings for the Month
55	UM02H	LFC1	UM02H		☐	UMXXH	☐	Total of the Credit Postings for the Month
56	UM03S	LFC1	UM03S		☐	UMXXS	☐	Total of the Debit Postings for the Month
57	UM03H	LFC1	UM03H		☐	UMXXH	☐	Total of the Credit Postings for the Month
58	UM04S	LFC1	UM04S		☐	UMXXS	☐	Total of the Debit Postings for the Month
59	UM04H	LFC1	UM04H		☐	UMXXH	☐	Total of the Credit Postings for the Month
60	UM05S	LFC1	UM05S		☐	UMXXS	☐	Total of the Debit Postings for the Month
61	UM05H	LFC1	UM05H		☐	UMXXH	☐	Total of the Credit Postings for the Month
62	UM06S	LFC1	UM06S		☐	UMXXS	☐	Total of the Debit Postings for the Month
63	UM06H	LFC1	UM06H		☐	UMXXH	☐	Total of the Credit Postings for the Month
64	UM07S	LFC1	UM07S		☐	UMXXS	☐	Total of the Debit Postings for the Month
65	UM07H	LFC1	UM07H		☐	UMXXH	☐	Total of the Credit Postings for the Month
66	UM08S	LFC1	UM08S		☐	UMXXS	☐	Total of the Debit Postings for the Month
67	UM08H	LFC1	UM08H		☐	UMXXH	☐	Total of the Credit Postings for the Month
68	UM09S	LFC1	UM09S		☐	UMXXS	☐	Total of the Debit Postings for the Month
69	UM09H	LFC1	UM09H		☐	UMXXH	☐	Total of the Credit Postings for the Month
70	UM10S	LFC1	UM10S		☐	UMXXS	☐	Total of the Debit Postings for the Month
71	UM10H	LFC1	UM10H		☐	UMXXH	☐	Total of the Credit Postings for the Month
72	UM11S	LFC1	UM11S		☐	UMXXS	☐	Total of the Debit Postings for the Month
73	UM11H	LFC1	UM11H		☐	UMXXH	☐	Total of the Credit Postings for the Month
74	UM12S	LFC1	UM12S		☐	UMXXS	☐	Total of the Debit Postings for the Month
75	UM12H	LFC1	UM12H		☐	UMXXH	☐	Total of the Credit Postings for the Month
76	UM13S	LFC1	UM13S		☐	UMXXS	☐	Total of the Debit Postings for the Month
77	UM13H	LFC1	UM13H		☐	UMXXH	☐	Total of the Credit Postings for the Month
78	UM14S	LFC1	UM14S		☐	UMXXS	☐	Total of the Debit Postings for the Month
79	UM14H	LFC1	UM14H		☐	UMXXH	☐	Total of the Credit Postings for the Month
80	UM15S	LFC1	UM15S		☐	UMXXS	☐	Total of the Debit Postings for the Month
81	UM15H	LFC1	UM15H		☐	UMXXH	☐	Total of the Credit Postings for the Month
82	UM16S	LFC1	UM16S		☐	UMXXS	☐	Total of the Debit Postings for the Month
83	UM16H	LFC1	UM16H		☐	UMXXH	☐	Total of the Credit Postings for the Month

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	46C