SAP ABAP Table RIHVEDA (Report structure contract items)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MSE (Application Component) Mobile Service
     ⤷ IWOC (Package) Application Development R/3 Work Order Cycle

Basic Data

Table Category	INTTAB	Structure
Structure	RIHVEDA	Table Relationship Diagram
Short Description	Report structure contract items

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	SDAUFNR	☐	VBELN_VA	VBELN	CHAR	10	0	Sales Document	VBUK
3	POSNR	☑	POSNR_VA	POSNR	NUMC	6	0	Sales Document Item	VBUP
4	OBKNR	☑	OBJKNR	OBJKN	INT4	10	0	Object list number	SER00
5	AUART	☐	AUART	AUART	CHAR	4	0	Sales Document Type	TVAK
6	AUGRU	☐	AUGRU	AUGRU	CHAR	3	0	Order reason (reason for the business transaction)	TVAU
7	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
8	SUBMI	☐	SUBMI	CHAR10	CHAR	10	0	Collective Number
9	WAERK	☐	WAERK	WAERS	CUKY	5	0	SD document currency	TCURC
10	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
11	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVTW
12	VKGRP	☐	VKGRP	VKGRP	CHAR	3	0	Sales group	TVKGR
13	VKBUR	☐	VKBUR	VKBUR	CHAR	4	0	Sales office	TVBUR
14	BSTNK	☐	BSTKD	BSTKD	CHAR	35	0	Customer purchase order number
15	BSARK	☐	BSARK	BSARK	CHAR	4	0	Customer Order Type	T176
16	BSTDK	☐	BSTDK	DATUM	DATS	8	0	Customer purchase order date
17	BSTZD	☐	BSTZD	BSTZD	CHAR	4	0	Customer purchase order number supplement
18	IHREZ	☐	IHREZ	TEXT12	CHAR	12	0	Your Reference
19	BNAME	☐	BNAME_V	NAME	CHAR	35	0	Name of orderer
20	TELF1	☐	TELF1_VP	TELF1	CHAR	16	0	Telephone Number
21	KUNNR	☐	KUNAG	KUNNR	CHAR	10	0	Sold-to party	KNA1
22	KVGR1	☐	KVGR1	KVGR1	CHAR	3	0	Customer group 1	TVV1
23	KVGR2	☐	KVGR2	KVGR2	CHAR	3	0	Customer group 2	TVV2
24	KVGR3	☐	KVGR3	KVGR3	CHAR	3	0	Customer group 3	TVV3
25	KVGR4	☐	KVGR4	KVGR4	CHAR	3	0	Customer group 4	TVV4
26	KVGR5	☐	KVGR5	KVGR5	CHAR	3	0	Customer group 5	TVV5
27	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
28	MATWA	☐	MATWA	MATNR	CHAR	18	0	Material entered	MARA
29	CHARG	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number	MCH1
30	MATKL	☐	MATKL	MATKL	CHAR	9	0	Material Group	T023
31	ARKTX	☐	ARKTX	TEXT40	CHAR	40	0	Short text for sales order item
32	PSTYV	☐	PSTYV	PSTYV	CHAR	4	0	Sales document item category	TVPT
33	UEPOS	☐	UEPOS	POSNR	NUMC	6	0	Higher-level item in bill of material structures	VBUP
34	ABGRU	☐	ABGRU_VA	ABGRU_VA	CHAR	2	0	Reason for rejection of quotations and sales orders	TVAG
35	PRODH	☐	PRODH_D	PRODH	CHAR	18	0	Product Hierarchy	T179
36	ZMENG	☐	DZMENG	MENG13	QUAN	13	3	Target quantity in sales units
37	ZIEME	☐	DZIEME	MEINS	UNIT	3	0	Target quantity UoM	T006
38	UMZIZ	☐	UMZIZ	UMBSZ	DEC	5	0	Factor for converting sales units to base units (target qty)
39	UMZIN	☐	UMZIN	UMBSN	DEC	5	0	Factor for converting sales units to base units (target qty)
40	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
41	KDMAT	☐	MATNR_KU	IDNEX	CHAR	35	0	Customer Material Number
42	POSEX	☐	POSEX	POSEX	CHAR	6	0	Item Number of the Underlying Purchase Order
43	FAKSP	☐	FAKSP_AP	FAKSP	CHAR	2	0	Billing block for item	TVFS
44	SPART	☐	SPART	SPART	CHAR	2	0	Division	TSPA
45	NETWRX	☐	NETWR_AP	WERTV8	CURR	15	2	Net value of the order item in document currency
46	VGBEL	☐	VGBEL	VBELN	CHAR	10	0	Document number of the reference document	VBUK
47	VGPOS	☐	VGPOS	POSNR	NUMC	6	0	Item number of the reference item	VBUP
48	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
49	NETPR	☐	NETPR	WERTV6	CURR	11	2	Net price
50	EAN11	☐	EAN11	EAN11	CHAR	18	0	International Article Number (EAN/UPC)
51	MVGR1	☐	MVGR1	MVGR1	CHAR	3	0	Material group 1	TVM1
52	MVGR2	☐	MVGR2	MVGR2	CHAR	3	0	Material group 2	TVM2
53	MVGR3	☐	MVGR3	MVGR3	CHAR	3	0	Material group 3	TVM3
54	MVGR4	☐	MVGR4	MVGR4	CHAR	3	0	Material group 4	TVM4
55	MVGR5	☐	MVGR5	MVGR5	CHAR	3	0	Material group 5	TVM5
56	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	CEPC
57	SERNR	☐	GERNR	GERNR	CHAR	18	0	Serial Number
58	TPLNR	☐	ILOM_STRNO	ILOM_STRNO	CHAR	40	0	Functional location label
59	EQUNR	☐	EQUNR	EQUNR	CHAR	18	0	Equipment Number	EQUI
60	BAUTL	☐	BAUTL	MATNR	CHAR	18	0	Assembly	MARA
61	VLAUFZ	☐	VLAUF_VEDA	NUM3	NUMC	3	0	Contract Term
62	VLAUEZ	☐	VLAUE_VEDA	KDZEH	CHAR	1	0	Unit of validity period of contract
63	VLAUFK	☐	VLAUK_VEDA	VLAUK_VEDA	CHAR	2	0	Validity period category of contract	TVLZ
64	VINSDAT	☐	VIDAT_VEDA	DATUM	DATS	8	0	Installation date
65	VABNDAT	☐	VADAT_VEDA	DATUM	DATS	8	0	Agreement acceptance date
66	VBEGDAT	☐	VBDAT_VEDA	DATUM	DATS	8	0	Contract start date
67	VUNTDAT	☐	VUDAT_VEDA	DATUM	DATS	8	0	Date on which contract is signed
68	VKUESCH	☐	VKUES_VEDA	VKUES_VEDA	CHAR	4	0	Assignment cancellation procedure/cancellation rule	TVKS
69	VAKTSCH	☐	VASCH_VEDA	AKTVT	CHAR	4	0	Activity at end of contract	TVAS
70	VEINDAT	☐	VEDAT_VEDA	DATUM	DATS	8	0	Date on which cancellation request was received
71	VWUNDAT	☐	VWDAT_VEDA	DATUM	DATS	8	0	Requested cancellation date
72	VKUEPAR	☐	VKPAR_VEDA	VKPAR_VEDA	CHAR	1	0	Cancelling Party
73	VKUEGRU	☐	VKGRU_VEDA	KUEGRU	CHAR	2	0	Reason for cancellation of contract	TVKG
74	VENDDAT	☐	VNDAT_VEDA	DATUM	DATS	8	0	Contract End Date
75	VBELKUE	☐	VBELK_VEDA	CHAR20	CHAR	20	0	Cancellation document number of contract partner
76	VBEDKUE	☐	VBEDK_VEDA	DATUM	DATS	8	0	Date of cancellation document from contract partner
77	VVORZEIT	☐	VZEIT_VEDA	NUM3	NUMC	3	0	Lead time for cancellation prevention activities
78	VVOREIN	☐	VZEIE_VEDA	KDZEH	CHAR	1	0	Time unit of lead time
79	VDEMDAT	☐	VDDAT_VEDA	DATUM	DATS	8	0	Dismantling date
80	VASDA	☐	VASDA	DATUM	DATS	8	0	Date of Activity
81	CUOBJ	☐	CUOBJ_VA	CUOBJ	NUMC	18	0	Configuration
82	PLTXT	☐	PLTXT	TEXT40	CHAR	40	0	Description of functional location
83	EQKTX	☐	KTX01	TEXT40	CHAR	40	0	Description of technical object
84	MAKTX	☐	MAKTX	TEXT40	CHAR	40	0	Material description
85	KTEXT	☐	KTEXT_V	TEXT40	CHAR	40	0	Search term for product proposal
86	.INCLU--AP	☐				0	0	IUID Append
87	UII	☐	UII_CHAR72	UII_CHAR72	CHAR	72	0	Unique Item Identifier

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	RIHVEDA	ABGRU	TVAG	ABGRU
2	RIHVEDA	AUART	TVAK	AUART
3	RIHVEDA	AUGRU	TVAU	AUGRU
4	RIHVEDA	BAUTL	MARA	MATNR
5	RIHVEDA	BSARK	T176	BSARK
6	RIHVEDA	CHARG	MCH1	CHARG
7	RIHVEDA	EQUNR	EQUI	EQUNR
8	RIHVEDA	FAKSP	TVFS	FAKSP
9	RIHVEDA	KUNNR	KNA1	KUNNR
10	RIHVEDA	KVGR1	TVV1	KVGR1
11	RIHVEDA	KVGR2	TVV2	KVGR2
12	RIHVEDA	KVGR3	TVV3	KVGR3
13	RIHVEDA	KVGR4	TVV4	KVGR4
14	RIHVEDA	KVGR5	TVV5	KVGR5
15	RIHVEDA	MANDT	T000	MANDT
16	RIHVEDA	MATKL	T023	MATKL
17	RIHVEDA	MATNR	MARA	MATNR
18	RIHVEDA	MATWA	MARA	MATNR
19	RIHVEDA	MEINS	T006	MSEHI
20	RIHVEDA	MVGR1	TVM1	MVGR1
21	RIHVEDA	MVGR2	TVM2	MVGR2
22	RIHVEDA	MVGR3	TVM3	MVGR3
23	RIHVEDA	MVGR4	TVM4	MVGR4
24	RIHVEDA	MVGR5	TVM5	MVGR5
25	RIHVEDA	OBKNR	SER00	OBKNR
26	RIHVEDA	POSNR	VBUP	POSNR
27	RIHVEDA	PRCTR	CEPC	PRCTR
28	RIHVEDA	PRODH	T179	PRODH
29	RIHVEDA	PSTYV	TVPT	PSTYV
30	RIHVEDA	SDAUFNR	VBUK	VBELN
31	RIHVEDA	SPART	TSPA	SPART
32	RIHVEDA	UEPOS	VBUP	POSNR
33	RIHVEDA	VAKTSCH	TVAS	AKTVT
34	RIHVEDA	VGBEL	VBUK	VBELN
35	RIHVEDA	VGPOS	VBUP	POSNR
36	RIHVEDA	VKBUR	TVBUR	VKBUR
37	RIHVEDA	VKGRP	TVKGR	VKGRP
38	RIHVEDA	VKORG	TVKO	VKORG
39	RIHVEDA	VKUEGRU	TVKG	KUEGRU
40	RIHVEDA	VKUESCH	TVKS	VKUESCH
41	RIHVEDA	VLAUFK	TVLZ	VLAUFK
42	RIHVEDA	VTWEG	TVTW	VTWEG
43	RIHVEDA	WAERK	TCURC	WAERS
44	RIHVEDA	WERKS	T001W	WERKS
45	RIHVEDA	ZIEME	T006	MSEHI

History

Last changed by/on	SAP	20110901
SAP Release Created in