SAP ABAP View VF_DEBI (View of KNA1 and KNB1)

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_DEBI
Short Description	View of KNA1 and KNB1
Root table	KNA1	General Data in Customer Master

Table

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

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

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	KNB1	MANDT		☐	MANDT	☐	Client
2	KUNNR	KNB1	KUNNR		☐	KUNNR	☐	Customer Number
3	BUKRS	KNB1	BUKRS		☐	BUKRS	☐	Company Code
4	ADRNR	KNA1	ADRNR		☐	ADRNR	☐	Address
5	ANRED	KNA1	ANRED		☐	ANRED	☐	Title
6	AUFSD	KNA1	AUFSD		☐	AUFSD_X	☐	Central order block for customer
7	BBBNR	KNA1	BBBNR		☐	BBBNR	☐	International location number (part 1)
8	BBSNR	KNA1	BBSNR		☐	BBSNR	☐	International location number (Part 2)
9	BEGRU	KNA1	BEGRU		☐	BRGRU	☐	Authorization Group
10	BRSCH	KNA1	BRSCH		☐	BRSCH	☐	Industry key
11	BUBKZ	KNA1	BUBKZ		☐	BUBKZ	☐	Check digit for the international location number
12	DATLT	KNA1	DATLT		☐	DATLT	☐	Data communication line no.
13	EXABL	KNA1	EXABL		☐	EXABL	☐	Indicator: Unloading points exist
14	FAKSD	KNA1	FAKSD		☐	FAKSD_X	☐	Central billing block for customer
15	FISKN	KNA1	FISKN		☐	FISKN_D	☐	Account number of the master record with the fiscal address
16	KNAZK	KNA1	KNAZK		☐	KNAZK	☐	Working Time Calendar
17	KNRZA	KNA1	KNRZA		☐	KNRZA	☐	Account number of an alternative payer
18	KONZS	KNA1	KONZS		☐	KONZS	☐	Group key
19	LAND1	KNA1	LAND1		☐	LAND1_GP	☐	Country Key
20	LIFNR	KNA1	LIFNR		☐	LIFNR	☐	Account Number of Vendor or Creditor
21	LIFSD	KNA1	LIFSD		☐	LIFSD_X	☐	Central delivery block for the customer
22	LOCCO	KNA1	LOCCO		☐	LOCCO	☐	City Coordinates
23	LOEVM	KNA1	LOEVM		☐	LOEVM_X	☐	Central Deletion Flag for Master Record
24	NAME1	KNA1	NAME1		☐	NAME1_GP	☐	Name 1
25	NAME2	KNA1	NAME2		☐	NAME2_GP	☐	Name 2
26	NAME3	KNA1	NAME3		☐	NAME3_GP	☐	Name 3
27	NAME4	KNA1	NAME4		☐	NAME4_GP	☐	Name 4
28	ORT01	KNA1	ORT01		☐	ORT01_GP	☐	City
29	ORT02	KNA1	ORT02		☐	ORT02_GP	☐	District
30	PFACH	KNA1	PFACH		☐	PFACH	☐	PO Box
31	PSTL2	KNA1	PSTL2		☐	PSTL2	☐	P.O. Box Postal Code
32	PSTLZ	KNA1	PSTLZ		☐	PSTLZ	☐	Postal Code
33	REGIO	KNA1	REGIO		☐	REGIO	☐	Region (State, Province, County)
34	COUNC	KNA1	COUNC		☐	COUNC	☐	County Code
35	CITYC	KNA1	CITYC		☐	CITYC	☐	City Code
36	RPMKR	KNA1	RPMKR		☐	RPMKR	☐	Regional market
37	SPERR	KNA1	SPERR		☐	SPERB_X	☐	Central posting block
38	SPRAS	KNA1	SPRAS		☐	SPRAS	☐	Language Key
39	STCD1	KNA1	STCD1		☐	STCD1	☐	Tax Number 1
40	STCD2	KNA1	STCD2		☐	STCD2	☐	Tax Number 2
41	STKZA	KNA1	STKZA		☐	STKZA	☐	Indicator: Business Partner Subject to Equalization Tax?
42	STKZU	KNA1	STKZU		☐	STKZU	☐	Liable for VAT
43	STRAS	KNA1	STRAS		☐	STRAS_GP	☐	House number and street
44	XCPDK	KNA1	XCPDK		☐	XCPDK	☐	Indicator: Is the account a one-time account?
45	XZEMP	KNA1	XZEMP		☐	XREGU	☐	Indicator: Is an alternative payer allowed in document?
46	VBUND	KNA1	VBUND		☐	RASSC	☐	Company ID of trading partner
47	SPERR_B	KNB1	SPERR		☐	SPERB_B	☐	Posting block for company code
48	LOEVM_B	KNB1	LOEVM		☐	LOEVM_B	☐	Deletion Flag for Master Record (Company Code Level)
49	ZUAWA	KNB1	ZUAWA		☐	DZUAWA	☐	Key for sorting according to assignment numbers
50	BUSAB	KNB1	BUSAB		☐	BUSAB	☐	Accounting clerk
51	AKONT	KNB1	AKONT		☐	AKONT	☐	Reconciliation Account in General Ledger
52	BEGRU_B	KNB1	BEGRU		☐	BRGRU	☐	Authorization Group
53	KNRZE	KNB1	KNRZE		☐	KNRZE	☐	Head office account number (in branch accounts)
54	KNRZB	KNB1	KNRZB		☐	KNRZB	☐	Account number of an alternative payer
55	ZAMIM	KNB1	ZAMIM		☐	DZAMIM	☐	Indicator: Payment notice to customer (with cleared items)?
56	ZAMIV	KNB1	ZAMIV		☐	DZAMIV	☐	Indicator: payment notice to sales department?
57	ZAMIR	KNB1	ZAMIR		☐	DZAMIR	☐	Indicator: payment notice to legal department?
58	ZAMIB	KNB1	ZAMIB		☐	DZAMIB	☐	Indicator: Payment notice to the accounting department ?
59	ZAMIO	KNB1	ZAMIO		☐	DZAMIO	☐	Indicator: payment notice to customer (w/o cleared items)?
60	ZWELS	KNB1	ZWELS		☐	DZWELS	☐	List of the Payment Methods to be Considered
61	XVERR	KNB1	XVERR		☐	XVERR_KNB1	☐	Indicator: Clearing between customer and vendor ?
62	ZAHLS	KNB1	ZAHLS		☐	DZAHLS	☐	Block Key for Payment
63	ZTERM	KNB1	ZTERM		☐	DZTERM	☐	Terms of payment key
64	WAKON	KNB1	WAKON		☐	WAKON	☐	Terms of payment key for bill of exchange charges
65	VZSKZ	KNB1	VZSKZ		☐	VZSKZ	☐	Interest calculation indicator
66	ZINDT	KNB1	ZINDT		☐	DZINDT	☐	Key date of the last interest calculation
67	ZINRT	KNB1	ZINRT		☐	DZINRT	☐	Interest calculation frequency in months
68	EIKTO	KNB1	EIKTO		☐	EIKTO_D	☐	Our account number at customer
69	ZSABE	KNB1	ZSABE		☐	DZSABE_D	☐	User at customer
70	KVERM	KNB1	KVERM		☐	KVERM	☐	Memo
71	FDGRV	KNB1	FDGRV		☐	FDGRV	☐	Planning group
72	VRBKZ	KNB1	VRBKZ		☐	VRBKZ	☐	Export credit insurance institution number
73	PERKZ	KNB1	PERKZ		☐	PERKZ_KNB1	☐	Collective invoice variant
74	XDEZV	KNB1	XDEZV		☐	XDEZV	☐	Indicator: Local processing?
75	XAUSZ	KNB1	XAUSZ		☐	XAUSZ	☐	Indicator for periodic account statements
76	WEBTR	KNB1	WEBTR		☐	WEBTR	☐	Bill of exchange limit (in local currency)
77	REMIT	KNB1	REMIT		☐	REMIT	☐	Next payee
78	DATLZ	KNB1	DATLZ		☐	DATLZ	☐	Date of the last interest calculation run
79	XZVER	KNB1	XZVER		☐	XZVER	☐	Indicator: Record Payment History ?
80	TOGRU	KNB1	TOGRU		☐	TOGRU	☐	Tolerance group for the business partner/G/L account
81	KULTG	KNB1	KULTG		☐	KULTG	☐	Probable time until check is paid
82	HBKID	KNB1	HBKID		☐	HBKID	☐	Short key for a house bank
83	XPORE	KNB1	XPORE		☐	XPORE	☐	Indicator: Pay all items separately ?
84	BLNKZ	KNB1	BLNKZ		☐	BLNKZ	☐	Subsidy Indicator for Determining the Reduction Rates
85	ERDAT	KNA1	ERDAT		☐	ERDAT_RF	☐	Date on which the Record Was Created
86	ERNAM	KNA1	ERNAM		☐	ERNAM_RF	☐	Name of Person who Created the Object
87	KTOKD	KNA1	KTOKD		☐	KTOKD	☐	Customer Account Group
88	SORTL	KNA1	SORTL		☐	SORTL	☐	Sort field
89	TELBX	KNA1	TELBX		☐	TELBX	☐	Telebox number
90	TELF1	KNA1	TELF1		☐	TELF1	☐	First telephone number
91	TELF2	KNA1	TELF2		☐	TELF2	☐	Second telephone number
92	TELFX	KNA1	TELFX		☐	TELFX	☐	Fax Number
93	TELTX	KNA1	TELTX		☐	TELTX	☐	Teletex number
94	TELX1	KNA1	TELX1		☐	TELX1	☐	Telex number
95	ERDAT_B	KNB1	ERDAT		☐	ERDAT_RF	☐	Date on which the Record Was Created
96	ERNAM_B	KNB1	ERNAM		☐	ERNAM_RF	☐	Name of Person who Created the Object
97	VLIBB	KNB1	VLIBB		☐	VLIBB	☐	Amount Insured
98	VRSZL	KNB1	VRSZL		☐	VRSZL	☐	Insurance lead months
99	VRSPR	KNB1	VRSPR		☐	VRSPR	☐	Deductible percentage rate
100	VRSNR	KNB1	VRSNR		☐	VRSNR	☐	Insurance number
101	VERDT	KNB1	VERDT		☐	VERDT	☐	Insurance validity date
102	STCEG	KNA1	STCEG		☐	STCEG	☐	VAT Registration Number
103	STKZN	KNA1	STKZN		☐	STKZN	☐	Natural Person
104	ALTKN	KNB1	ALTKN		☐	ALTKN	☐	Previous Master Record Number
105	ZGRUP	KNB1	ZGRUP		☐	DZGRUP	☐	Key for Payment Grouping
106	TXJCD	KNA1	TXJCD		☐	TXJCD	☐	Tax Jurisdiction
107	URLID	KNB1	URLID		☐	URLID	☐	Short Key for Known/Negotiated Leave
108	MGRUP	KNB1	MGRUP		☐	MGRUP	☐	Key for dunning notice grouping
109	LOCKB	KNB1	LOCKB		☐	LOCKB	☐	Key of the Lockbox to Which the Customer Is To Pay
110	UZAWE	KNB1	UZAWE		☐	UZAWE	☐	Payment method supplement
111	KTOCD	KNA1	KTOCD		☐	KTOCD	☐	Reference Account Group for One-Time Account (Customer)
112	PFORT	KNA1	PFORT		☐	PFORT_GP	☐	PO Box city
113	DTAMS	KNA1	DTAMS		☐	DTAMS	☐	Report key for data medium exchange
114	DTAWS	KNA1	DTAWS		☐	DTAWS	☐	Instruction key for data medium exchange
115	XEDIP	KNB1	XEDIP		☐	XEDIP	☐	Indicator: Send Payment Advices by EDI
116	SREGL	KNB1	SREGL		☐	SREGL	☐	Selection Rule for Payment Advices
117	VRSDG	KNB1	VRSDG		☐	VRSDG	☐	Reason Code Conversion Version
118	SPERZ	KNA1	SPERZ		☐	SPERZ	☐	Payment Block
119	PERNR	KNB1	PERNR		☐	PERNR_D	☐	Personnel Number
120	FRGRP	KNB1	FRGRP		☐	FRGRP	☐	Release Approval Group
121	TLFXS	KNB1	TLFXS		☐	TLFXS	☐	Accounting clerk's fax number at the customer/vendor
122	INTAD	KNB1	INTAD		☐	INTAD	☐	Internet address of partner company clerk
123	XKNZA	KNA1	XKNZA		☐	XKNZA	☐	Indicator: Alternative payer using account number
124	XKNZB	KNB1	XKNZB		☐	XKNZB	☐	Indicator: Alternative payer using account number
125	GUZTE	KNB1	GUZTE		☐	GUZTE	☐	Payment Terms Key for Credit Memos
126	EKVBD	KNB1	EKVBD		☐	EKVBD	☐	Account Number of Buying Group
127	GRICD	KNB1	GRICD		☐	J_1AGICD_D	☐	Activity Code for Gross Income Tax
128	GRIDT	KNB1	GRIDT		☐	J_1ADTYP_D	☐	Distribution Type for Employment Tax
129	NODEL	KNA1	NODEL		☐	NODEL_X	☐	Central deletion block for master record
130	CONFS	KNA1	CONFS		☐	CONFS_X	☐	Status of Change Authorization (Central)
131	UPDAT	KNA1	UPDAT		☐	UPDAT_RF	☐	Date on Which the Changes Were Confirmed
132	UPTIM	KNA1	UPTIM		☐	UPTIM_RF	☐	Time of Last Change Confirmation
133	NODEL_B	KNB1	NODEL		☐	NODEL_B	☐	Deletion bock for master record (company code level)
134	CONFS_B	KNB1	CONFS		☐	CONFS_B	☐	Status of Change Authorization (Company Code Level)
135	UPDAT_B	KNB1	UPDAT		☐	UPDAT_RF	☐	Date on Which the Changes Were Confirmed
136	UPTIM_B	KNB1	UPTIM		☐	UPTIM_RF	☐	Time of Last Change Confirmation
137	NIELS	KNA1	NIELS		☐	NIELS	☐	Nielsen ID
138	CESSION_KZ	KNB1	CESSION_KZ		☐	CESSION_KZ	☐	Accounts Receivable Pledging Indicator
139	TLFNS	KNB1	TLFNS		☐	TLFNS	☐	Accounting clerk's telephone number at business partner
140	J_1KFREPRE	KNA1	J_1KFREPRE		☐	REPRES	☐	Name of Representative
141	J_1KFTBUS	KNA1	J_1KFTBUS		☐	GESTYP	☐	Type of Business
142	J_1KFTIND	KNA1	J_1KFTIND		☐	INDTYP	☐	Type of Industry
143	.APPEND	AFMVF_DEBI			☐		☐
144	PSOFG	KNA1	PSOFG		☐	PSOFG	☐	Processor group
145	PSOIS	KNA1	PSOIS		☐	PSOIS	☐	Subledger acct preprocessing procedure

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	20140122
SAP Release Created in