SAP ABAP View VFC_DEBI ("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_DEBI
Short Description	"View For Balance Audit Trail With A/B/C Data"
Root table	KNA1	General Data in Customer Master

Table

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

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	KNC1	MANDT	JR	EQ			AND	0	0
7	KNB1	KUNNR	JL	EQ				0	0
8	KNC1	KUNNR	JR	EQ			AND	0	0
9	KNB1	BUKRS	JL	EQ				0	0
10	KNC1	BUKRS	JR	EQ				0	0

View Fields

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