SAP ABAP Table VF_KRED (Generated Table for View)

Basic Data

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

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VF_KRED	AKONT	SKB1	SAKNR	REF	1	CN
2	VF_KRED	BRSCH	T016	BRSCH	REF	C	CN
3	VF_KRED	BUKRS	T001	BUKRS	KEY	1	CN
4	VF_KRED	BUSAB	T001S	BUSAB	REF	C	CN
5	VF_KRED	FDGRV	T035	GRUPP	REF	C	CN
6	VF_KRED	FISKN	LFA1	LIFNR	REF	C	CN
7	VF_KRED	FISKU	LFA1	LIFNR	KEY	C	CN
8	VF_KRED	FRGRP	VBWF08	FRGRP	REF	C	CN
9	VF_KRED	GRICD	J_1AGICD	J_1AGICD		1	CN
10	VF_KRED	GRIDT	J_1ADTYP	J_1ADTYP		1	CN
11	VF_KRED	HBKID	T012	HBKID	REF	C	CN
12	VF_KRED	J_1KFTBUS	BUSTYPE	GESTYP	REF	C	CN
13	VF_KRED	J_1KFTIND	INDUSTYPE	INDTYPE	REF	C	CN
14	VF_KRED	KTOCK	T077K	KTOKK	REF	C	CN
15	VF_KRED	KTOKK	T077K	KTOKK	REF	1	CN
16	VF_KRED	KUNNR	KNA1	KUNNR	REF	C	CN
17	VF_KRED	LAND1	T005	LAND1	REF	C	CN
18	VF_KRED	LIFNR	LFA1	LIFNR	KEY	1	CN
19	VF_KRED	LNRZA	LFA1	LIFNR	REF	C	CN
20	VF_KRED	LNRZB	LFA1	LIFNR	REF	C	CN
21	VF_KRED	LNRZE	LFA1	LIFNR	REF	C	CN
22	VF_KRED	MANDT	T000	MANDT	KEY	1	CN
23	VF_KRED	MGRUP	T047R	MGRUP	REF	C	CN
24	VF_KRED	MINDK	T059M	MINDK	REF	C	CN
25	VF_KRED	QLAND	T005Q	QLAND	REF	1	CN
26	VF_KRED	QSREC	T059A	QSREC	REF	1	CN
27	VF_KRED	QSSYS	TQ02B	QSSYSFAM	REF	C	CN
28	VF_KRED	REGIO	T005S	BLAND	REF	C	CN
29	VF_KRED	SFRGR	TSFG	SFRGR	REF	C	CN
30	VF_KRED	SPRAS	T002	SPRAS	REF	1	CN
31	VF_KRED	TOGRR	T169L	TOGRR	REF	1	CN
32	VF_KRED	TOGRU	T043G	TOGRU	REF	C	CN
33	VF_KRED	UZAWE	T042F	UZAWE	REF	C	CN
34	VF_KRED	VBUND	T880	RCOMP	REF	C	CN
35	VF_KRED	VZSKZ	T056	VZSKZ	REF	C	CN
36	VF_KRED	XAUSZ	T048K	XAUSZ	REF	C	CN
37	VF_KRED	ZAHLS	T008	ZAHLS	REF	C	CN
38	VF_KRED	ZGRUP	TZGR	ZGRUP	REF	C	CN
39	VF_KRED	ZUAWA	TZUN	ZUAWA	REF	C	CN

History

Last changed by/on	SAP	20131127
SAP Release Created in