SAP ABAP Table V_KNA1WRF1 (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	V_KNA1WRF1	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
3	NAME1	☐	NAME1_GP	NAME	CHAR	35	0	Name 1
4	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
5	KATR1	☐	KATR1	ATTR1	CHAR	2	0	Attribute 1	TVK1
6	KATR2	☐	KATR2	ATTR2	CHAR	2	0	Attribute 2	TVK2
7	KATR3	☐	KATR3	ATTR3	CHAR	2	0	Attribute 3	TVK3
8	KATR4	☐	KATR4	ATTR4	CHAR	2	0	Attribute 4	TVK4
9	KATR5	☐	KATR5	ATTR5	CHAR	2	0	Attribute 5	TVK5
10	KATR6	☐	KATR6	ATTR6	CHAR	3	0	Attribute 6	TVK6
11	KATR7	☐	KATR7	ATTR7	CHAR	3	0	Attribute 7	TVK7
12	KATR8	☐	KATR8	ATTR8	CHAR	3	0	Attribute 8	TVK8
13	KATR9	☐	KATR9	ATTR9	CHAR	3	0	Attribute 9	TVK9
14	KATR10	☐	KATR10	ATTR10	CHAR	3	0	Attribute 10	TVK0
15	LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	LFA1
16	KNAZK	☐	KNAZK	WFCID	CHAR	2	0	Working Time Calendar	TFACD
17	BEGRU	☐	BRGRU	BRGRU	CHAR	4	0	Authorization Group
18	BRSCH	☐	BRSCH	BRSCH	CHAR	4	0	Industry key	T016
19	EXABL	☐	EXABL	XFELD	CHAR	1	0	Indicator: Unloading points exist
20	KUKLA	☐	KUKLA	KUKLA	CHAR	2	0	Customer classification	TKUKL
21	LAND1	☐	LAND1_GP	LAND1	CHAR	3	0	Country Key	T005
22	LIFSD	☐	LIFSD_X	LIFSP	CHAR	2	0	Central delivery block for the customer	TVLS
23	LOEVM	☐	LOEVM_X	XFELD	CHAR	1	0	Central Deletion Flag for Master Record
24	NIELS	☐	NIELS	NIELS	CHAR	2	0	Nielsen ID	TNLS
25	SPRAS	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
26	STKZA	☐	STKZA	STKZA	CHAR	1	0	Indicator: Business Partner Subject to Equalization Tax?
27	STKZU	☐	STKZU	XFELD	CHAR	1	0	Liable for VAT
28	LZONE	☐	LZONE	ZONE	CHAR	10	0	Transportation zone to or from which the goods are delivered	TZONE
29	XCPDK	☐	XCPDK	XFELD	CHAR	1	0	Indicator: Is the account a one-time account?
30	TXJCD	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	TTXJ
31	HZUOR	☐	HZUOR	HZUOR	NUMC	2	0	Assignment to Hierarchy
32	SPERZ	☐	SPERZ	XFELD	CHAR	1	0	Payment Block
33	ETIKG	☐	ETIKG	ETIKG	CHAR	10	0	IS-R Labeling: customer/plant group	TWEK
34	EROED	☐	EROED	DATUM	DATS	8	0	Opening date
35	SCHLD	☐	SCHLD	DATUM	DATS	8	0	Closing date
36	SPDAB	☐	SPDAB	DATUM	DATS	8	0	Block from
37	SPDBI	☐	SPDBI	DATUM	DATS	8	0	Block to
38	KOPRO	☐	POSKOPRO	POSKOPRO	CHAR	4	0	POS outbound profile	TWPFI
39	AUTOB	☐	AUTOB	CHAR001	CHAR	1	0	Automatic purchase order
40	LAYVR	☐	LAYVAR	LAYVAR	CHAR	10	0	Layout	TWGV
41	FLVAR	☐	FLVAR	FLVAR	CHAR	4	0	Area schema	TWGF
42	STFAK	☐	STKAL	WFCID	CHAR	2	0	Calendar	TFACD
43	VERFL	☐	VERFL_WWS	VERFL_WWS	QUAN	6	0	Sales area (floor space)
44	VERFE	☐	VERFE_WWS	MEINS	UNIT	3	0	Sales area (floor space) unit	T006
45	SPGR1	☐	SPGR1	SPGR1	CHAR	2	0	Blocking reason	TWRF11
46	INPRO	☐	POSINTPROF	POSINTPROF	CHAR	4	0	POS inbound profile	TWPIS
47	EKOAR	☐	POSEKOAR	POSEKOAR	CHAR	4	0	POS outbound: condition type group	TWPPK
48	KZLIK	☐	KZLIK	XFELD	CHAR	1	0	Listing conditions should be created per assortment
49	BETRP	☐	BETRP	BETRP	CHAR	4	0	Plant profile	TWRF2
50	NLMATFB	☐	NLMATFB	NLMATFB	CHAR	1	0	ID: Carry out subsequent listing
51	BWWRK	☐	BWWRK	WERKS	CHAR	4	0	Plant for retail price determination	T001W
52	BWVKO	☐	BWVKO	VKORG	CHAR	4	0	Sales organization for retail price determination	TVKO
53	BWVTW	☐	BWVTW	VTWEG	CHAR	2	0	Distribution channel for retail price determination	TVTW
54	BBPRO	☐	BBPRO	BBPRO	CHAR	4	0	Assortment list profile	TWBP
55	VKBUR_WRK	☐	VKBUR_WRK	VKBUR	CHAR	4	0	Sales office
56	VLFKZ	☐	VLFKZ	VLFKZ	CHAR	1	0	Plant category
57	LSTFL	☐	LSTFL	LSTFL	CHAR	2	0	Listing procedure for store or other assortment categories	TWLV

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	V_KNA1WRF1	BBPRO	TWBP	BBPRO
2	V_KNA1WRF1	BETRP	TWRF2	BETRP
3	V_KNA1WRF1	BRSCH	T016	BRSCH	REF	C	CN
4	V_KNA1WRF1	BWVKO	TVKO	VKORG	KEY	1	CN
5	V_KNA1WRF1	BWVTW	TVTW	VTWEG	KEY	1	CN
6	V_KNA1WRF1	BWWRK	T001W	WERKS	KEY	1	CN
7	V_KNA1WRF1	EKOAR	TWPPK	EKOAR	KEY	1	CN
8	V_KNA1WRF1	ETIKG	TWEK	KUNGR	REF	1	CN
9	V_KNA1WRF1	FLVAR	TWGF	FLVAR	REF	C	CN
10	V_KNA1WRF1	INPRO	TWPIS	INPRO	KEY	1	CN
11	V_KNA1WRF1	KATR1	TVK1	KATR1	KEY	1	CN
12	V_KNA1WRF1	KATR10	TVK0	KATR10	KEY	1	CN
13	V_KNA1WRF1	KATR2	TVK2	KATR2	KEY	1	CN
14	V_KNA1WRF1	KATR3	TVK3	KATR3	KEY	1	CN
15	V_KNA1WRF1	KATR4	TVK4	KATR4	KEY	1	CN
16	V_KNA1WRF1	KATR5	TVK5	KATR5	KEY	1	CN
17	V_KNA1WRF1	KATR6	TVK6	KATR6	KEY	1	CN
18	V_KNA1WRF1	KATR7	TVK7	KATR7	KEY	1	CN
19	V_KNA1WRF1	KATR8	TVK8	KATR8	KEY	1	CN
20	V_KNA1WRF1	KATR9	TVK9	KATR9	KEY	1	CN
21	V_KNA1WRF1	KNAZK	TFACD	IDENT	REF	C	CN
22	V_KNA1WRF1	KOPRO	TWPFI	KOPRO	KEY	1	CN
23	V_KNA1WRF1	KUKLA	TKUKL	KUKLA	REF	C	CN
24	V_KNA1WRF1	LAND1	T005	LAND1	REF	C	CN
25	V_KNA1WRF1	LAYVR	TWGV	LAYVR	KEY	1	CN
26	V_KNA1WRF1	LIFNR	LFA1	LIFNR	REF	C	CN
27	V_KNA1WRF1	LIFSD	TVLS	LIFSP	REF	C	CN
28	V_KNA1WRF1	LSTFL	TWLV	LSTFL
29	V_KNA1WRF1	LZONE	TZONE	ZONE1	REF	C	CN
30	V_KNA1WRF1	MANDT	T000	MANDT	KEY	1	CN
31	V_KNA1WRF1	NIELS	TNLS	NIELS	REF	C	CN
32	V_KNA1WRF1	SPGR1	TWRF11	SPGR1	KEY	1	CN
33	V_KNA1WRF1	SPRAS	T002	SPRAS	REF	1	CN
34	V_KNA1WRF1	STFAK	TFACD	IDENT	KEY	1	CN
35	V_KNA1WRF1	TXJCD	TTXJ	TXJCD	REF	C	CN
36	V_KNA1WRF1	VERFE	T006	MSEHI	KEY	1	CN
37	V_KNA1WRF1	WERKS	T001W	WERKS	REF	C	CN

History

Last changed by/on	SAP	20131127
SAP Release Created in