SAP ABAP Table WRF_SIT_KNVV (WRF_SIT_KNVV)

Hierarchy

☛ EA-RETAIL (Software Component) SAP Enterprise Extension Retail
   ⤷ LO-MD-MM (Application Component) Material Master
     ⤷ WRF_DEPARTMENT_STORE (Package) Department Store / Shops

Basic Data

Table Category	INTTAB	Structure
Structure	WRF_SIT_KNVV	Table Relationship Diagram
Short Description	WRF_SIT_KNVV

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	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
4	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVTW
5	SPART	☐	SPART	SPART	CHAR	2	0	Division	TSPA
6	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
7	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
8	BEGRU	☐	BEGRU	BEGRU	CHAR	4	0	Authorization Group
9	LOEVM	☐	LOEVM_V	XFELD	CHAR	1	0	Deletion flag for customer (sales level)
10	VERSG	☐	STGKU	STGKU	CHAR	1	0	Customer Statistics Group	TVSD
11	AUFSD	☐	AUFSD_V	KAUFS	CHAR	2	0	Customer order block (sales area)	TVAST
12	KALKS	☐	KALKS	KALKS	CHAR	1	0	Pricing procedure assigned to this customer	TVKD
13	KDGRP	☐	KDGRP	KDGRP	CHAR	2	0	Customer group	T151
14	BZIRK	☐	BZIRK	BZIRK	CHAR	6	0	Sales district	T171
15	KONDA	☐	KONDA	KONDA	CHAR	2	0	Price Group (Customer)	T188
16	PLTYP	☐	PLTYP	PLTYP	CHAR	2	0	Price list type	T189
17	AWAHR	☐	AWAHR	AWAHR	NUMC	3	0	Order probability of the item
18	INCO1	☐	INCO1	INCO1	CHAR	3	0	Incoterms (part 1)	TINC
19	INCO2	☐	INCO2	INCO2	CHAR	28	0	Incoterms (part 2)
20	LIFSD	☐	LIFSD_V	LIFSP	CHAR	2	0	Customer delivery block (sales area)	TVLS
21	AUTLF	☐	AUTLF	XFELD	CHAR	1	0	Complete delivery defined for each sales order?
22	ANTLF	☐	ANTLF	ANTLF	DEC	1	0	Maximum number of partial deliveries allowed per item
23	KZTLF	☐	KZTLF	KZTLF	CHAR	1	0	Partial delivery at item level
24	KZAZU	☐	KZAZU_D	XFELD	CHAR	1	0	Order combination indicator
25	CHSPL	☐	CHSPL	XFELD	CHAR	1	0	Batch split allowed
26	LPRIO	☐	LPRIO	LPRIO	NUMC	2	0	Delivery priority	TPRIO
27	EIKTO	☐	EIKTO	CHAR12	CHAR	12	0	Shipper's (Our) Account Number at the Customer or Vendor
28	VSBED	☐	VSBED	VSBED	CHAR	2	0	Shipping conditions	TVSB
29	FAKSD	☐	FAKSD_V	FAKSP	CHAR	2	0	Billing block for customer (sales and distribution)	TVFS
30	MRNKZ	☐	MRNKZ	XFELD	CHAR	1	0	Manual invoice maintenance
31	PERFK	☐	PERFK	WFCID	CHAR	2	0	Invoice dates (calendar identification)	TFACD
32	PERRL	☐	PERRL	WFCID	CHAR	2	0	Invoice list schedule (calendar identification)	TFACD
33	KVAKZ	☐	KVAKZ	XFELD	CHAR	1	0	Cost estimate indicator (inactive)
34	KVAWT	☐	KVAWT	WERT7	CURR	13	2	Value limit for cost estimate (inactive)
35	WAERS	☐	WAERS_V02D	WAERS	CUKY	5	0	Currency	TCURC
36	KLABC	☐	KLABC	KLABC	CHAR	2	0	Customer classification (ABC analysis)
37	KTGRD	☐	KTGRD	KTGRD	CHAR	2	0	Account assignment group for this customer	TVKT
38	ZTERM	☐	DZTERM	ZTERM	CHAR	4	0	Terms of payment key
39	VWERK	☐	DWERK	WERKS	CHAR	4	0	Delivering Plant	TVKWZ
40	VKGRP	☐	VKGRP	VKGRP	CHAR	3	0	Sales group	TVBVK
41	VKBUR	☐	VKBUR	VKBUR	CHAR	4	0	Sales office	TVBUR
42	VSORT	☐	VSORT	VBELN	CHAR	10	0	Item proposal	VBUK
43	KVGR1	☐	KVGR1	KVGR1	CHAR	3	0	Customer group 1	TVV1
44	KVGR2	☐	KVGR2	KVGR2	CHAR	3	0	Customer group 2	TVV2
45	KVGR3	☐	KVGR3	KVGR3	CHAR	3	0	Customer group 3	TVV3
46	KVGR4	☐	KVGR4	KVGR4	CHAR	3	0	Customer group 4	TVV4
47	KVGR5	☐	KVGR5	KVGR5	CHAR	3	0	Customer group 5	TVV5
48	BOKRE	☐	BOKRE	XFELD	CHAR	1	0	ID: Customer is to receive rebates
49	BOIDT	☐	BOIDT	DATUM	DATS	8	0	Start of validity per.for the rebate index for the customer
50	KURST	☐	KURST	KURST	CHAR	4	0	Exchange Rate Type	TCURV
51	PRFRE	☐	PRFRE	XFELD	CHAR	1	0	Relevant for Pricing ID
52	PRAT1	☐	KUAT1	PRATK	CHAR	1	0	ID for product attribute 1
53	PRAT2	☐	KUAT2	PRATK	CHAR	1	0	ID for product attribute 2
54	PRAT3	☐	KUAT3	PRATK	CHAR	1	0	ID for product attribute 3
55	PRAT4	☐	KUAT4	PRATK	CHAR	1	0	ID for product attribute 4
56	PRAT5	☐	KUAT5	PRATK	CHAR	1	0	ID for product attribute 5
57	PRAT6	☐	KUAT6	PRATK	CHAR	1	0	ID for product attribute 6
58	PRAT7	☐	KUAT7	PRATK	CHAR	1	0	ID for product attribute 7
59	PRAT8	☐	KUAT8	PRATK	CHAR	1	0	ID for product attribute 8
60	PRAT9	☐	KUAT9	PRATK	CHAR	1	0	ID for product attribute 9
61	PRATA	☐	KUATA	PRATK	CHAR	1	0	ID for product attribute 10
62	KABSS	☐	KABSSCH_CM	KABSSCH_CM	CHAR	4	0	Customer payment guarantee procedure	T691P
63	KKBER	☐	KKBER	KKBER	CHAR	4	0	Credit control area	T014
64	CASSD	☐	CASSD_V	CASSP	CHAR	2	0	Sales block for customer (sales area)
65	RDOFF	☐	RDOFF	XFELD	CHAR	1	0	Switch off rounding?
66	AGREL	☐	AGREL	XFELD	CHAR	1	0	Indicator: Relevant for agency business
67	MEGRU	☐	MEGRU	MEGRU	CHAR	4	0	Unit of Measure Group	TWMEG
68	UEBTO	☐	UEBTO	PRZ21	DEC	3	1	Overdelivery Tolerance Limit
69	UNTTO	☐	UNTTO	PRZ21	DEC	3	1	Underdelivery Tolerance Limit
70	UEBTK	☐	UEBTK_V	XFELD	CHAR	1	0	Unlimited overdelivery allowed
71	PVKSM	☐	PVKSM	PVKSM	CHAR	2	0	Customer procedure for product proposal	TPVD
72	PODKZ	☐	PODKZ	XFELD	CHAR	1	0	Relevant for POD processing
73	PODTG	☐	PODTG	TSTRDURAG	DEC	11	0	Timeframe for Confirmation of POD

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	WRF_SIT_KNVV	AUFSD	TVAST	AUFSP	REF	C	CN
2	WRF_SIT_KNVV	BZIRK	T171	BZIRK		C	CN
3	WRF_SIT_KNVV	FAKSD	TVFS	FAKSP	REF	C	CN
4	WRF_SIT_KNVV	INCO1	TINC	INCO1	REF	C	CN
5	WRF_SIT_KNVV	KABSS	T691P	KABSS	REF	C	CN
6	WRF_SIT_KNVV	KALKS	TVKD	KALKS	REF	C	CN
7	WRF_SIT_KNVV	KDGRP	T151	KDGRP	REF	C	CN
8	WRF_SIT_KNVV	KKBER	T014	KKBER	REF	C	CN
9	WRF_SIT_KNVV	KONDA	T188	KONDA	REF	C	CN
10	WRF_SIT_KNVV	KTGRD	TVKT	KTGRD	REF	C	CN
11	WRF_SIT_KNVV	KUNNR	KNA1	KUNNR	KEY	1	CN
12	WRF_SIT_KNVV	KURST	TCURV	KURST	REF	C	CN
13	WRF_SIT_KNVV	KVGR1	TVV1	KVGR1	REF	C	CN
14	WRF_SIT_KNVV	KVGR2	TVV2	KVGR2	REF	C	CN
15	WRF_SIT_KNVV	KVGR3	TVV3	KVGR3	REF	C	CN
16	WRF_SIT_KNVV	KVGR4	TVV4	KVGR4	REF	C	CN
17	WRF_SIT_KNVV	KVGR5	TVV5	KVGR5	REF	C	CN
18	WRF_SIT_KNVV	LIFSD	TVLS	LIFSP	KEY	C	CN
19	WRF_SIT_KNVV	LPRIO	TPRIO	LPRIO		C	CN
20	WRF_SIT_KNVV	MANDT	T000	MANDT	KEY	1	CN
21	WRF_SIT_KNVV	MEGRU	TWMEG	MEGRU	REF	1	N
22	WRF_SIT_KNVV	PERFK	TFACD	IDENT	REF	C	CN
23	WRF_SIT_KNVV	PERRL	TFACD	IDENT	REF	C	CN
24	WRF_SIT_KNVV	PLTYP	T189	PLTYP	REF	C	CN
25	WRF_SIT_KNVV	PVKSM	TPVD	PVKSM	KEY	1	1
26	WRF_SIT_KNVV	SPART	TSPA	SPART	KEY	1	CN
27	WRF_SIT_KNVV	VERSG	TVSD	STGKU	REF	C	CN
28	WRF_SIT_KNVV	VKBUR	TVBUR	VKBUR	REF	C	CN
29	WRF_SIT_KNVV	VKGRP	TVBVK	VKGRP	REF	C	CN
30	WRF_SIT_KNVV	VKORG	TVKO	VKORG	KEY	1	CN
31	WRF_SIT_KNVV	VSBED	TVSB	VSBED	REF	C	CN
32	WRF_SIT_KNVV	VSORT	VBUK	VBELN	REF	C	CN
33	WRF_SIT_KNVV	VTWEG	TVTW	VTWEG	KEY	1	CN
34	WRF_SIT_KNVV	VWERK	TVKWZ	WERKS	REF	C	CN
35	WRF_SIT_KNVV	WAERS	TCURC	WAERS	REF	C	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in	111