SAP ABAP Table DPWTY_S_CONTRACT (Contract data information)

Hierarchy

☛ EA-APPL (Software Component) SAP Enterprise Extension PLM, SCM, Financials
   ⤷ LO-WTY (Application Component) Warranty Claim Processing
     ⤷ DP_WTY_RFC (Package) Warranty RFC interface

Basic Data

Table Category	INTTAB	Structure
Structure	DPWTY_S_CONTRACT	Table Relationship Diagram
Short Description	Contract data information

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	.INCLUDE	☐				0	0	Generated Table for View
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	*
3	VBELN	☐	VBELN_VA	VBELN	CHAR	10	0	Sales Document	*
4	POSNR	☐	POSNR_VA	POSNR	NUMC	6	0	Sales Document Item	VBUP
5	AUART	☐	AUART	AUART	CHAR	4	0	Sales Document Type	TVAK
6	VBTYP	☐	VBTYP	VBTYP	CHAR	1	0	SD document category
7	AUGRU	☐	AUGRU	AUGRU	CHAR	3	0	Order reason (reason for the business transaction)	TVAU
8	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
9	SUBMI	☐	SUBMI_SD	CHAR10	CHAR	10	0	Collective number (SD)
10	FAKSK	☐	FAKSK	FAKSP	CHAR	2	0	Billing block in SD document	TVFS
11	NETWR	☐	NETWR_AK	WERTV8	CURR	15	2	Net Value of the Sales Order in Document Currency
12	WAERK	☐	WAERK	WAERS	CUKY	5	0	SD document currency	TCURC
13	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
14	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVKOV
15	VKGRP	☐	VKGRP	VKGRP	CHAR	3	0	Sales group	TVBVK
16	VKBUR	☐	VKBUR	VKBUR	CHAR	4	0	Sales office	*
17	BSTZD	☐	BSTZD	BSTZD	CHAR	4	0	Customer purchase order number supplement
18	BNAME	☐	BNAME_V	NAME	CHAR	35	0	Name of orderer
19	TELF1	☐	TELF1_VP	TELF1	CHAR	16	0	Telephone Number
20	KUNNR	☐	KUNAG	KUNNR	CHAR	10	0	Sold-to party	KNA1
21	KVGR1	☐	KVGR1	KVGR1	CHAR	3	0	Customer group 1	TVV1
22	KVGR2	☐	KVGR2	KVGR2	CHAR	3	0	Customer group 2	TVV2
23	KVGR3	☐	KVGR3	KVGR3	CHAR	3	0	Customer group 3	TVV3
24	KVGR4	☐	KVGR4	KVGR4	CHAR	3	0	Customer group 4	TVV4
25	KVGR5	☐	KVGR5	KVGR5	CHAR	3	0	Customer group 5	TVV5
26	MATNRX	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
27	MATWA	☐	MATWA	MATNR	CHAR	18	0	Material entered	MARA
28	CHARG	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number	MCHA
29	MATKL	☐	MATKL	MATKL	CHAR	9	0	Material Group	T023
30	ARKTX	☐	ARKTX	TEXT40	CHAR	40	0	Short text for sales order item
31	PSTYV	☐	PSTYV	PSTYV	CHAR	4	0	Sales document item category	TVPT
32	UEPOS	☐	UEPOS	POSNR	NUMC	6	0	Higher-level item in bill of material structures	*
33	ABGRU	☐	ABGRU_VA	ABGRU_VA	CHAR	2	0	Reason for rejection of quotations and sales orders	TVAG
34	PRODH	☐	PRODH_D	PRODH	CHAR	18	0	Product Hierarchy	T179
35	ZMENG	☐	DZMENG	MENG13	QUAN	13	3	Target quantity in sales units
36	ZIEME	☐	DZIEME	MEINS	UNIT	3	0	Target quantity UoM	T006
37	UMZIZ	☐	UMZIZ	UMBSZ	DEC	5	0	Factor for converting sales units to base units (target qty)
38	UMZIN	☐	UMZIN	UMBSN	DEC	5	0	Factor for converting sales units to base units (target qty)
39	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
40	KDMAT	☐	MATNR_KU	IDNEX	CHAR	35	0	Customer Material Number
41	POSEX	☐	POSEX	POSEX	CHAR	6	0	Item Number of the Underlying Purchase Order
42	FAKSP	☐	FAKSP_AP	FAKSP	CHAR	2	0	Billing block for item	TVFS
43	SPART	☐	SPART	SPART	CHAR	2	0	Division	TSPA
44	NETWRX	☐	NETWR_AP	WERTV8	CURR	15	2	Net value of the order item in document currency
45	VGBEL	☐	VGBEL	VBELN	CHAR	10	0	Document number of the reference document	VBUK
46	VGPOS	☐	VGPOS	POSNR	NUMC	6	0	Item number of the reference item	VBUP
47	WERKS	☐	WERKS_EXT	WERKS	CHAR	4	0	Plant (Own or External)	*
48	NETPR	☐	NETPR	WERTV6	CURR	11	2	Net price
49	EAN11	☐	EAN11	EAN11	CHAR	18	0	International Article Number (EAN/UPC)
50	MVGR1	☐	MVGR1	MVGR1	CHAR	3	0	Material group 1	TVM1
51	MVGR2	☐	MVGR2	MVGR2	CHAR	3	0	Material group 2	TVM2
52	MVGR3	☐	MVGR3	MVGR3	CHAR	3	0	Material group 3	TVM3
53	MVGR4	☐	MVGR4	MVGR4	CHAR	3	0	Material group 4	TVM4
54	MVGR5	☐	MVGR5	MVGR5	CHAR	3	0	Material group 5	TVM5
55	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	*
56	CUOBJ	☐	CUOBJ_VA	CUOBJ	NUMC	18	0	Configuration
57	WAERKX	☐	WAERK	WAERS	CUKY	5	0	SD document currency	TCURC
58	KTEXT	☐	KTEXT_V	TEXT40	CHAR	40	0	Search term for product proposal
59	VLAUFZ	☐	VLAUF_VEDA	NUM3	NUMC	3	0	Contract Term
60	VLAUEZ	☐	VLAUE_VEDA	KDZEH	CHAR	1	0	Unit of validity period of contract
61	VLAUFK	☐	VLAUK_VEDA	VLAUK_VEDA	CHAR	2	0	Validity period category of contract	TVLZ
62	VINSDAT	☐	VIDAT_VEDA	DATUM	DATS	8	0	Installation date
63	VABNDAT	☐	VADAT_VEDA	DATUM	DATS	8	0	Agreement acceptance date
64	VBEGDAT	☐	VBDAT_VEDA	DATUM	DATS	8	0	Contract start date
65	VUNTDAT	☐	VUDAT_VEDA	DATUM	DATS	8	0	Date on which contract is signed
66	VKUESCH	☐	VKUES_VEDA	VKUES_VEDA	CHAR	4	0	Assignment cancellation procedure/cancellation rule	TVKS
67	VAKTSCH	☐	VASCH_VEDA	AKTVT	CHAR	4	0	Activity at end of contract	TVAS
68	VEINDAT	☐	VEDAT_VEDA	DATUM	DATS	8	0	Date on which cancellation request was received
69	VWUNDAT	☐	VWDAT_VEDA	DATUM	DATS	8	0	Requested cancellation date
70	VKUEPAR	☐	VKPAR_VEDA	VKPAR_VEDA	CHAR	1	0	Cancelling Party
71	VKUEGRU	☐	VKGRU_VEDA	KUEGRU	CHAR	2	0	Reason for cancellation of contract	TVKG
72	VENDDAT	☐	VNDAT_VEDA	DATUM	DATS	8	0	Contract End Date
73	VBELKUE	☐	VBELK_VEDA	CHAR20	CHAR	20	0	Cancellation document number of contract partner
74	VBEDKUE	☐	VBEDK_VEDA	DATUM	DATS	8	0	Date of cancellation document from contract partner
75	VBEGREG	☐	VBREG_VEDA	VDREG_VEDA	CHAR	2	0	Rule for calculating contract start date	TVRG
76	VVORZEIT	☐	VZEIT_VEDA	NUM3	NUMC	3	0	Lead time for cancellation prevention activities
77	VVOREIN	☐	VZEIE_VEDA	KDZEH	CHAR	1	0	Time unit of lead time
78	VDEMDAT	☐	VDDAT_VEDA	DATUM	DATS	8	0	Dismantling date
79	VASDA	☐	VASDA	DATUM	DATS	8	0	Date of Activity
80	WIMID	☐	WIMID	SWW_WIID	NUMC	12	0	Work item ID	SWWWIHEAD
81	VASDR	☐	VASDR	VDREG_VEDA	CHAR	2	0	Date Rule for Activity	TVRG
82	VENDREG	☐	RGVTE	VDREG_VEDA	CHAR	2	0	Rule for contract end date	TVRG

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	DPWTY_S_CONTRACT	ABGRU	TVAG	ABGRU	REF	C	CN
2	DPWTY_S_CONTRACT	AUART	TVAK	AUART	REF	1	CN
3	DPWTY_S_CONTRACT	AUGRU	TVAU	AUGRU	REF	C	CN
4	DPWTY_S_CONTRACT	CHARG	MCHA	CHARG	REF	C	CN
5	DPWTY_S_CONTRACT	FAKSK	TVFS	FAKSP	REF	C	CN
6	DPWTY_S_CONTRACT	FAKSP	TVFS	FAKSP	REF	C	CN
7	DPWTY_S_CONTRACT	KUNNR	KNA1	KUNNR	REF	C	CN
8	DPWTY_S_CONTRACT	KVGR1	TVV1	KVGR1	REF	C	CN
9	DPWTY_S_CONTRACT	KVGR2	TVV2	KVGR2	REF	C	CN
10	DPWTY_S_CONTRACT	KVGR3	TVV3	KVGR3	REF	C	CN
11	DPWTY_S_CONTRACT	KVGR4	TVV4	KVGR4	REF	C	CN
12	DPWTY_S_CONTRACT	KVGR5	TVV5	KVGR5	REF	C	CN
13	DPWTY_S_CONTRACT	MATKL	T023	MATKL	REF	C	CN
14	DPWTY_S_CONTRACT	MATNRX	MARA	MATNR	REF	C	CN
15	DPWTY_S_CONTRACT	MATWA	MARA	MATNR	REF	C	CN
16	DPWTY_S_CONTRACT	MEINS	T006	MSEHI	REF	C	CN
17	DPWTY_S_CONTRACT	MVGR1	TVM1	MVGR1	REF	C	CN
18	DPWTY_S_CONTRACT	MVGR2	TVM2	MVGR2	REF	C	CN
19	DPWTY_S_CONTRACT	MVGR3	TVM3	MVGR3	REF	C	CN
20	DPWTY_S_CONTRACT	MVGR4	TVM4	MVGR4	REF	C	CN
21	DPWTY_S_CONTRACT	MVGR5	TVM5	MVGR5	REF	C	CN
22	DPWTY_S_CONTRACT	POSNR	VBUP	POSNR	KEY	1	CN
23	DPWTY_S_CONTRACT	PRODH	T179	PRODH	REF	C	CN
24	DPWTY_S_CONTRACT	PSTYV	TVPT	PSTYV	REF	1	CN
25	DPWTY_S_CONTRACT	SPART	TSPA	SPART	REF	C	CN
26	DPWTY_S_CONTRACT	VAKTSCH	TVAS	AKTVT	REF	C	CN
27	DPWTY_S_CONTRACT	VASDR	TVRG	REGEL	REF	C	CN
28	DPWTY_S_CONTRACT	VBEGREG	TVRG	REGEL	REF	C	CN
29	DPWTY_S_CONTRACT	VENDREG	TVRG	REGEL	REF	C	CN
30	DPWTY_S_CONTRACT	VGBEL	VBUK	VBELN	REF	C	CN
31	DPWTY_S_CONTRACT	VGPOS	VBUP	POSNR	REF	C	CN
32	DPWTY_S_CONTRACT	VKGRP	TVBVK	VKGRP	REF	C	CN
33	DPWTY_S_CONTRACT	VKORG	TVKO	VKORG	REF	1	CN
34	DPWTY_S_CONTRACT	VKUEGRU	TVKG	KUEGRU	REF	C	CN
35	DPWTY_S_CONTRACT	VKUESCH	TVKS	VKUESCH	REF	C	CN
36	DPWTY_S_CONTRACT	VLAUFK	TVLZ	VLAUFK	REF	C	CN
37	DPWTY_S_CONTRACT	VTWEG	TVKOV	VTWEG	REF	1	CN
38	DPWTY_S_CONTRACT	WAERK	TCURC	WAERS	REF	C	CN
39	DPWTY_S_CONTRACT	WAERKX	TCURC	WAERS	REF	C	CN
40	DPWTY_S_CONTRACT	WIMID	SWWWIHEAD	WI_ID	REF	C	CN
41	DPWTY_S_CONTRACT	ZIEME	T006	MSEHI	REF	C	CN

History

Last changed by/on	SAP	20140121
SAP Release Created in	604