SAP ABAP Table VF_DEBI (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	VF_DEBI	Table Relationship Diagram
Short Description	Generated Table for View

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

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

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VF_DEBI	AKONT	SKB1	SAKNR	REF	1	CN
2	VF_DEBI	AUFSD	TVAST	AUFSP	REF	C	CN
3	VF_DEBI	BRSCH	T016	BRSCH	REF	C	CN
4	VF_DEBI	BUKRS	T001	BUKRS	KEY	1	CN
5	VF_DEBI	BUSAB	T001S	BUSAB	REF	C	CN
6	VF_DEBI	CESSION_KZ	TCESSION	CESSION_KZ		1	CN
7	VF_DEBI	CITYC	T005G	CITYC	REF	C	CN
8	VF_DEBI	COUNC	T005E	COUNC	REF	C	CN
9	VF_DEBI	EKVBD	KNA1	KUNNR	REF	C	CN
10	VF_DEBI	FAKSD	TVFS	FAKSP	REF	C	CN
11	VF_DEBI	FDGRV	T035	GRUPP	REF	C	CN
12	VF_DEBI	FISKN	KNA1	KUNNR	REF	C	CN
13	VF_DEBI	FRGRP	VBWF08	FRGRP	REF	C	CN
14	VF_DEBI	GRICD	J_1AGICD	J_1AGICD		1	CN
15	VF_DEBI	GRIDT	J_1ADTYP	J_1ADTYP		1	CN
16	VF_DEBI	HBKID	T012	HBKID	REF	C	CN
17	VF_DEBI	J_1KFTBUS	BUSTYPE	GESTYP	REF	C	CN
18	VF_DEBI	J_1KFTIND	INDUSTYPE	INDTYPE	REF	C	CN
19	VF_DEBI	KNAZK	TFACD	IDENT	REF	C	CN
20	VF_DEBI	KNRZA	KNA1	KUNNR	REF	C	CN
21	VF_DEBI	KNRZB	KNA1	KUNNR	REF	C	CN
22	VF_DEBI	KNRZE	KNA1	KUNNR	REF	C	CN
23	VF_DEBI	KTOCD	T077D	KTOKD	REF	C	CN
24	VF_DEBI	KTOKD	T077D	KTOKD	REF	1	CN
25	VF_DEBI	KUNNR	KNA1	KUNNR	KEY	1	CN
26	VF_DEBI	LAND1	T005	LAND1	REF	C	CN
27	VF_DEBI	LIFNR	LFA1	LIFNR	REF	C	CN
28	VF_DEBI	LIFSD	TVLS	LIFSP	REF	C	CN
29	VF_DEBI	LOCKB	T049L	LOCKB	REF	C	CN
30	VF_DEBI	MANDT	T000	MANDT	KEY	1	CN
31	VF_DEBI	MGRUP	T047R	MGRUP	REF	C	CN
32	VF_DEBI	NIELS	TNLS	NIELS	REF	C	CN
33	VF_DEBI	PSOFG	PSO19	PSOFG		1	CN
34	VF_DEBI	REGIO	T005S	BLAND	REF	C	CN
35	VF_DEBI	REMIT	KNA1	KUNNR	REF	C	CN
36	VF_DEBI	SPRAS	T002	SPRAS	REF	1	CN
37	VF_DEBI	SREGL	T053A	SREGL	REF	C	CN
38	VF_DEBI	TOGRU	T043G	TOGRU	REF	C	CN
39	VF_DEBI	TXJCD	TTXJ	TXJCD	REF	C	CN
40	VF_DEBI	URLID	T052A	URLID	REF	C	CN
41	VF_DEBI	UZAWE	T042F	UZAWE	REF	C	CN
42	VF_DEBI	VBUND	T880	RCOMP	REF	C	CN
43	VF_DEBI	VRSDG	T053V	VRSDG	REF	C	CN
44	VF_DEBI	VZSKZ	T056	VZSKZ	REF	C	CN
45	VF_DEBI	XAUSZ	T048K	XAUSZ	REF	C	CN
46	VF_DEBI	ZAHLS	T008	ZAHLS	REF	C	CN
47	VF_DEBI	ZGRUP	TZGR	ZGRUP	REF	C	CN
48	VF_DEBI	ZUAWA	TZUN	ZUAWA	REF	C	CN

History

Last changed by/on	SAP	20140122
SAP Release Created in