SAP Table RIHVEDA
Report structure contract items
RIHVEDA (Report structure contract items) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link RIHVEDA to other SAP tables.
Source: RIHVEDA (Report structure contract items)
RIHVEDA table fields
Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||||||
SDAUFNR | Sales Document | VBELN_VA | VBUK | CHAR | 10 | 0 | ||||||||||
POSNR | Sales Document Item | POSNR_VA | VBUP | NUMC | 6 | 0 | ||||||||||
OBKNR | Object list number | OBJKNR | SER00 | INT4 | 10 | 0 | ||||||||||
AUART | Sales Document Type | AUART | TVAK | CHAR | 4 | 0 | ||||||||||
AUGRU | Order reason (reason for the business transaction) | AUGRU | TVAU | CHAR | 3 | 0 | ||||||||||
ERNAM | Name of Person who Created the Object | ERNAM | CHAR | 12 | 0 | |||||||||||
SUBMI | Collective Number | SUBMI | CHAR | 10 | 0 | |||||||||||
WAERK | SD Document Currency | WAERK | TCURC | CUKY | 5 | 0 | ||||||||||
VKORG | Sales Organization | VKORG | TVKO | CHAR | 4 | 0 | ||||||||||
VTWEG | Distribution Channel | VTWEG | TVTW | CHAR | 2 | 0 | ||||||||||
VKGRP | Sales Group | VKGRP | TVKGR | CHAR | 3 | 0 | ||||||||||
VKBUR | Sales Office | VKBUR | TVBUR | CHAR | 4 | 0 | ||||||||||
BSTNK | Customer purchase order number | BSTKD | CHAR | 35 | 0 | |||||||||||
BSARK | Customer purchase order type | BSARK | T176 | CHAR | 4 | 0 | ||||||||||
BSTDK | Customer purchase order date | BSTDK | DATS | 8 | 0 | |||||||||||
BSTZD | Purchase order number supplement | BSTZD | CHAR | 4 | 0 | |||||||||||
IHREZ | Your Reference | IHREZ | CHAR | 12 | 0 | |||||||||||
BNAME | Name of orderer | BNAME_V | CHAR | 35 | 0 | |||||||||||
TELF1 | Telephone Number | TELF1_VP | CHAR | 16 | 0 | |||||||||||
KUNNR | Sold-to party | KUNAG | KNA1 | CHAR | 10 | 0 | ||||||||||
KVGR1 | Customer group 1 | KVGR1 | TVV1 | CHAR | 3 | 0 | ||||||||||
KVGR2 | Customer group 2 | KVGR2 | TVV2 | CHAR | 3 | 0 | ||||||||||
KVGR3 | Customer group 3 | KVGR3 | TVV3 | CHAR | 3 | 0 | ||||||||||
KVGR4 | Customer group 4 | KVGR4 | TVV4 | CHAR | 3 | 0 | ||||||||||
KVGR5 | Customer group 5 | KVGR5 | TVV5 | CHAR | 3 | 0 | ||||||||||
MATNR | Material Number | MATNR | MARA | CHAR | 18 | 0 | ||||||||||
MATWA | Material entered | MATWA | MARA | CHAR | 18 | 0 | ||||||||||
CHARG | Batch Number | CHARG_D | MCH1 | CHAR | 10 | 0 | ||||||||||
MATKL | Material Group | MATKL | T023 | CHAR | 9 | 0 | ||||||||||
ARKTX | Short text for sales order item | ARKTX | CHAR | 40 | 0 | |||||||||||
PSTYV | Sales document item category | PSTYV | TVPT | CHAR | 4 | 0 | ||||||||||
UEPOS | Higher-level item in bill of material structures | UEPOS | VBUP | NUMC | 6 | 0 | ||||||||||
ABGRU | Reason for rejection of quotations and sales orders | ABGRU_VA | TVAG | CHAR | 2 | 0 | ||||||||||
PRODH | Product hierarchy | PRODH_D | T179 | CHAR | 18 | 0 | ||||||||||
ZMENG | Target quantity in sales units | DZMENG | QUAN | 13 | 3 | |||||||||||
ZIEME | Target quantity UoM | DZIEME | T006 | UNIT | 3 | 0 | ||||||||||
UMZIZ | Factor for converting sales units to base units (target qty) | UMZIZ | DEC | 5 | 0 | |||||||||||
UMZIN | Factor for converting sales units to base units (target qty) | UMZIN | DEC | 5 | 0 | |||||||||||
MEINS | Base Unit of Measure | MEINS | T006 | UNIT | 3 | 0 | ||||||||||
KDMAT | Material Number Used by Customer | MATNR_KU | CHAR | 35 | 0 | |||||||||||
POSEX | Item Number of the Underlying Purchase Order | POSEX | CHAR | 6 | 0 | |||||||||||
FAKSP | Billing block for item | FAKSP_AP | TVFS | CHAR | 2 | 0 | ||||||||||
SPART | Division | SPART | TSPA | CHAR | 2 | 0 | ||||||||||
NETWRX | Net value of the order item in document currency | NETWR_AP | CURR | 15 | 2 | |||||||||||
VGBEL | Document number of the reference document | VGBEL | VBUK | CHAR | 10 | 0 | ||||||||||
VGPOS | Item number of the reference item | VGPOS | VBUP | NUMC | 6 | 0 | ||||||||||
WERKS | Plant | WERKS_D | T001W | CHAR | 4 | 0 | ||||||||||
NETPR | Net price | NETPR | CURR | 11 | 2 | |||||||||||
EAN11 | International Article Number (EAN/UPC) | EAN11 | CHAR | 18 | 0 | |||||||||||
MVGR1 | Material group 1 | MVGR1 | TVM1 | CHAR | 3 | 0 | ||||||||||
MVGR2 | Material group 2 | MVGR2 | TVM2 | CHAR | 3 | 0 | ||||||||||
MVGR3 | Material group 3 | MVGR3 | TVM3 | CHAR | 3 | 0 | ||||||||||
MVGR4 | Material group 4 | MVGR4 | TVM4 | CHAR | 3 | 0 | ||||||||||
MVGR5 | Material group 5 | MVGR5 | TVM5 | CHAR | 3 | 0 | ||||||||||
PRCTR | Profit Center | PRCTR | CEPC | CHAR | 10 | 0 | ||||||||||
SERNR | Serial Number | GERNR | CHAR | 18 | 0 | |||||||||||
TPLNR | Functional Location Label | ILOM_STRNO | CHAR | 40 | 0 | |||||||||||
EQUNR | Equipment Number | EQUNR | EQUI | CHAR | 18 | 0 | ||||||||||
BAUTL | Assembly | BAUTL | MARA | CHAR | 18 | 0 | ||||||||||
VLAUFZ | Validity period of contract | VLAUF_VEDA | NUMC | 3 | 0 | |||||||||||
VLAUEZ | Unit of validity period of contract | VLAUE_VEDA | CHAR | 1 | 0 |
Possible values
|
||||||||||
VLAUFK | Validity period category of contract | VLAUK_VEDA | TVLZ | CHAR | 2 | 0 | ||||||||||
VINSDAT | Installation date | VIDAT_VEDA | DATS | 8 | 0 | |||||||||||
VABNDAT | Agreement acceptance date | VADAT_VEDA | DATS | 8 | 0 | |||||||||||
VBEGDAT | Contract start date | VBDAT_VEDA | DATS | 8 | 0 | |||||||||||
VUNTDAT | Date on which contract is signed | VUDAT_VEDA | DATS | 8 | 0 | |||||||||||
VKUESCH | Assignment cancellation procedure/cancellation rule | VKUES_VEDA | TVKS | CHAR | 4 | 0 | ||||||||||
VAKTSCH | Action at end of contract | VASCH_VEDA | TVAS | CHAR | 4 | 0 | ||||||||||
VEINDAT | Date on which cancellation request was received | VEDAT_VEDA | DATS | 8 | 0 | |||||||||||
VWUNDAT | Requested cancellation date | VWDAT_VEDA | DATS | 8 | 0 | |||||||||||
VKUEPAR | Cancellation party | VKPAR_VEDA | CHAR | 1 | 0 |
Possible values
|
||||||||||
VKUEGRU | Reason for Cancellation of Contract | VKGRU_VEDA | TVKG | CHAR | 2 | 0 | ||||||||||
VENDDAT | Contract end date | VNDAT_VEDA | DATS | 8 | 0 | |||||||||||
VBELKUE | Cancellation document number of contract partner | VBELK_VEDA | CHAR | 20 | 0 | |||||||||||
VBEDKUE | Date of cancellation document from contract partner | VBEDK_VEDA | DATS | 8 | 0 | |||||||||||
VVORZEIT | Lead time for cancellation prevention activities | VZEIT_VEDA | NUMC | 3 | 0 | |||||||||||
VVOREIN | Time unit of lead time | VZEIE_VEDA | CHAR | 1 | 0 |
Possible values
|
||||||||||
VDEMDAT | Dismantling date | VDDAT_VEDA | DATS | 8 | 0 | |||||||||||
VASDA | Date for action | VASDA | DATS | 8 | 0 | |||||||||||
CUOBJ | Configuration | CUOBJ_VA | NUMC | 18 | 0 | |||||||||||
PLTXT | Description of functional location | PLTXT | CHAR | 40 | 0 | |||||||||||
EQKTX | Description of technical object | KTX01 | CHAR | 40 | 0 | |||||||||||
MAKTX | Material Description (Short Text) | MAKTX | CHAR | 40 | 0 | |||||||||||
KTEXT | Search term for product proposal | KTEXT_V | CHAR | 40 | 0 | |||||||||||
UII | Unique Item Identifier | UII_CHAR72 | CHAR | 72 | 0 |
RIHVEDA foreign key relationships
Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
---|---|---|---|---|---|---|
RIHVEDA | ABGRU | RIHVEDA | MANDT | TVAG | Sales Documents: Rejection Reasons | MANDT |
RIHVEDA | ABGRU | RIHVEDA | ABGRU | TVAG | Sales Documents: Rejection Reasons | ABGRU |
RIHVEDA | AUART | RIHVEDA | MANDT | TVAK | Sales Document Types | MANDT |
RIHVEDA | AUART | RIHVEDA | AUART | TVAK | Sales Document Types | AUART |
RIHVEDA | AUGRU | RIHVEDA | MANDT | TVAU | Sales Documents: Order Reasons | MANDT |
RIHVEDA | AUGRU | RIHVEDA | AUGRU | TVAU | Sales Documents: Order Reasons | AUGRU |
RIHVEDA | BAUTL | RIHVEDA | MANDT | MARA | General Material Data | MANDT |
RIHVEDA | BAUTL | RIHVEDA | BAUTL | MARA | General Material Data | MATNR |
RIHVEDA | BSARK | RIHVEDA | MANDT | T176 | Sales Documents: Customer Order Types | MANDT |
RIHVEDA | BSARK | RIHVEDA | BSARK | T176 | Sales Documents: Customer Order Types | BSARK |
RIHVEDA | CHARG | RIHVEDA | MANDT | MCH1 | Batches (if Batch Management Cross-Plant) | MANDT |
RIHVEDA | CHARG | RIHVEDA | MATNR | MCH1 | Batches (if Batch Management Cross-Plant) | MATNR |
RIHVEDA | CHARG | RIHVEDA | CHARG | MCH1 | Batches (if Batch Management Cross-Plant) | CHARG |
RIHVEDA | EQUNR | RIHVEDA | EQUNR | EQUI | Equipment master data | EQUNR |
RIHVEDA | EQUNR | RIHVEDA | MANDT | EQUI | Equipment master data | MANDT |
RIHVEDA | FAKSP | RIHVEDA | FAKSP | TVFS | Billing: Reasons for Blocking | FAKSP |
RIHVEDA | FAKSP | RIHVEDA | MANDT | TVFS | Billing: Reasons for Blocking | MANDT |
RIHVEDA | KUNNR | RIHVEDA | KUNNR | KNA1 | General Data in Customer Master | KUNNR |
RIHVEDA | KUNNR | RIHVEDA | MANDT | KNA1 | General Data in Customer Master | MANDT |
RIHVEDA | KVGR1 | RIHVEDA | KVGR1 | TVV1 | Customer Group 1 | KVGR1 |
RIHVEDA | KVGR1 | RIHVEDA | MANDT | TVV1 | Customer Group 1 | MANDT |
RIHVEDA | KVGR2 | RIHVEDA | KVGR2 | TVV2 | Customer Group 2 | KVGR2 |
RIHVEDA | KVGR2 | RIHVEDA | MANDT | TVV2 | Customer Group 2 | MANDT |
RIHVEDA | KVGR3 | RIHVEDA | KVGR3 | TVV3 | Customer Group 3 | KVGR3 |
RIHVEDA | KVGR3 | RIHVEDA | MANDT | TVV3 | Customer Group 3 | MANDT |
RIHVEDA | KVGR4 | RIHVEDA | KVGR4 | TVV4 | Customer Group 4 | KVGR4 |
RIHVEDA | KVGR4 | RIHVEDA | MANDT | TVV4 | Customer Group 4 | MANDT |
RIHVEDA | KVGR5 | RIHVEDA | MANDT | TVV5 | Customer Group 5 | MANDT |
RIHVEDA | KVGR5 | RIHVEDA | KVGR5 | TVV5 | Customer Group 5 | KVGR5 |
RIHVEDA | MANDT | RIHVEDA | MANDT | T000 | Clients | MANDT |
RIHVEDA | MATKL | RIHVEDA | MATKL | T023 | Material Groups | MATKL |
RIHVEDA | MATKL | RIHVEDA | MANDT | T023 | Material Groups | MANDT |
RIHVEDA | MATNR | RIHVEDA | MATNR | MARA | General Material Data | MATNR |
RIHVEDA | MATNR | RIHVEDA | MANDT | MARA | General Material Data | MANDT |
RIHVEDA | MATWA | RIHVEDA | MATWA | MARA | General Material Data | MATNR |
RIHVEDA | MATWA | RIHVEDA | MANDT | MARA | General Material Data | MANDT |
RIHVEDA | MEINS | RIHVEDA | MANDT | T006 | Units of Measurement | MANDT |
RIHVEDA | MEINS | RIHVEDA | MEINS | T006 | Units of Measurement | MSEHI |
RIHVEDA | MVGR1 | RIHVEDA | MVGR1 | TVM1 | Material Pricing Group 1 | MVGR1 |
RIHVEDA | MVGR1 | RIHVEDA | MANDT | TVM1 | Material Pricing Group 1 | MANDT |
RIHVEDA | MVGR2 | RIHVEDA | MVGR2 | TVM2 | Material Pricing Group 2 | MVGR2 |
RIHVEDA | MVGR2 | RIHVEDA | MANDT | TVM2 | Material Pricing Group 2 | MANDT |
RIHVEDA | MVGR3 | RIHVEDA | MVGR3 | TVM3 | Material Pricing Group 3 | MVGR3 |
RIHVEDA | MVGR3 | RIHVEDA | MANDT | TVM3 | Material Pricing Group 3 | MANDT |
RIHVEDA | MVGR4 | RIHVEDA | MANDT | TVM4 | Material Pricing Group 4 | MANDT |
RIHVEDA | MVGR4 | RIHVEDA | MVGR4 | TVM4 | Material Pricing Group 4 | MVGR4 |
RIHVEDA | MVGR5 | RIHVEDA | MANDT | TVM5 | Material Pricing Group 5 | MANDT |
RIHVEDA | MVGR5 | RIHVEDA | MVGR5 | TVM5 | Material Pricing Group 5 | MVGR5 |
RIHVEDA | OBKNR | RIHVEDA | OBKNR | SER00 | General Header Table for Serial Number Management | OBKNR |
RIHVEDA | OBKNR | RIHVEDA | MANDT | SER00 | General Header Table for Serial Number Management | MANDT |
RIHVEDA | POSNR | RIHVEDA | POSNR | VBUP | Sales Document: Item Status | POSNR |
RIHVEDA | POSNR | RIHVEDA | SDAUFNR | VBUP | Sales Document: Item Status | VBELN |
RIHVEDA | POSNR | RIHVEDA | MANDT | VBUP | Sales Document: Item Status | MANDT |
RIHVEDA | PRCTR | RIHVEDA | MANDT | CEPC | Profit Center Master Data Table | MANDT |
RIHVEDA | PRCTR | RIHVEDA | PRCTR | CEPC | Profit Center Master Data Table | PRCTR |
RIHVEDA | PRCTR | RIHVEDA | BSTDK | CEPC | Profit Center Master Data Table | DATBI |
RIHVEDA | PRCTR | * | CEPC | Profit Center Master Data Table | KOKRS | |
RIHVEDA | PRODH | RIHVEDA | PRODH | T179 | Materials: Product Hierarchies | PRODH |
RIHVEDA | PRODH | RIHVEDA | MANDT | T179 | Materials: Product Hierarchies | MANDT |
RIHVEDA | PSTYV | RIHVEDA | PSTYV | TVPT | Sales documents: Item categories | PSTYV |
RIHVEDA | PSTYV | RIHVEDA | MANDT | TVPT | Sales documents: Item categories | MANDT |
RIHVEDA | SDAUFNR | RIHVEDA | MANDT | VBUK | Sales Document: Header Status and Administrative Data | MANDT |
RIHVEDA | SDAUFNR | RIHVEDA | SDAUFNR | VBUK | Sales Document: Header Status and Administrative Data | VBELN |
RIHVEDA | SPART | RIHVEDA | SPART | TSPA | Organizational Unit: Sales Divisions | SPART |
RIHVEDA | SPART | RIHVEDA | MANDT | TSPA | Organizational Unit: Sales Divisions | MANDT |
RIHVEDA | UEPOS | RIHVEDA | UEPOS | VBUP | Sales Document: Item Status | POSNR |
RIHVEDA | UEPOS | RIHVEDA | SDAUFNR | VBUP | Sales Document: Item Status | VBELN |
RIHVEDA | UEPOS | RIHVEDA | MANDT | VBUP | Sales Document: Item Status | MANDT |
RIHVEDA | VAKTSCH | RIHVEDA | MANDT | TVAS | Action Procedure for End of Contract | MANDT |
RIHVEDA | VAKTSCH | RIHVEDA | VAKTSCH | TVAS | Action Procedure for End of Contract | AKTVT |
RIHVEDA | VGBEL | RIHVEDA | VGBEL | VBUK | Sales Document: Header Status and Administrative Data | VBELN |
RIHVEDA | VGBEL | RIHVEDA | MANDT | VBUK | Sales Document: Header Status and Administrative Data | MANDT |
RIHVEDA | VGPOS | RIHVEDA | VGPOS | VBUP | Sales Document: Item Status | POSNR |
RIHVEDA | VGPOS | RIHVEDA | SDAUFNR | VBUP | Sales Document: Item Status | VBELN |
RIHVEDA | VGPOS | RIHVEDA | MANDT | VBUP | Sales Document: Item Status | MANDT |
RIHVEDA | VKBUR | RIHVEDA | VKBUR | TVBUR | Organizational Unit: Sales Offices | VKBUR |
RIHVEDA | VKBUR | RIHVEDA | MANDT | TVBUR | Organizational Unit: Sales Offices | MANDT |
RIHVEDA | VKGRP | RIHVEDA | VKGRP | TVKGR | Organizational Unit: Sales Groups | VKGRP |
RIHVEDA | VKGRP | RIHVEDA | MANDT | TVKGR | Organizational Unit: Sales Groups | MANDT |
RIHVEDA | VKORG | RIHVEDA | VKORG | TVKO | Organizational Unit: Sales Organizations | VKORG |
RIHVEDA | VKORG | RIHVEDA | MANDT | TVKO | Organizational Unit: Sales Organizations | MANDT |
RIHVEDA | VKUEGRU | RIHVEDA | VKUEGRU | TVKG | Sales Documents: Reasons for Cancellation | KUEGRU |
RIHVEDA | VKUEGRU | RIHVEDA | MANDT | TVKG | Sales Documents: Reasons for Cancellation | MANDT |
RIHVEDA | VKUESCH | RIHVEDA | MANDT | TVKS | Cancellation procedures for contracts | MANDT |
RIHVEDA | VKUESCH | RIHVEDA | VKUESCH | TVKS | Cancellation procedures for contracts | VKUESCH |
RIHVEDA | VLAUFK | RIHVEDA | VLAUFK | TVLZ | Validity Period Category | VLAUFK |
RIHVEDA | VLAUFK | RIHVEDA | MANDT | TVLZ | Validity Period Category | MANDT |
RIHVEDA | VTWEG | RIHVEDA | VTWEG | TVTW | Organizational Unit: Distribution Channels | VTWEG |
RIHVEDA | VTWEG | RIHVEDA | MANDT | TVTW | Organizational Unit: Distribution Channels | MANDT |
RIHVEDA | WAERK | RIHVEDA | WAERK | TCURC | Currency Codes | WAERS |
RIHVEDA | WAERK | RIHVEDA | MANDT | TCURC | Currency Codes | MANDT |
RIHVEDA | WERKS | RIHVEDA | MANDT | T001W | Plants/Branches | MANDT |
RIHVEDA | WERKS | RIHVEDA | WERKS | T001W | Plants/Branches | WERKS |
RIHVEDA | ZIEME | RIHVEDA | MANDT | T006 | Units of Measurement | MANDT |
RIHVEDA | ZIEME | RIHVEDA | ZIEME | T006 | Units of Measurement | MSEHI |