OIH_TAX_REV SAP (Excise Duty Revaluation Documents) Table details

Dictionary Type: Table
Description: Excise Duty Revaluation Documents




ABAP Code to SELECT data from OIH_TAX_REV
Related tables to OIH_TAX_REV
Access table OIH_TAX_REV




Table field list including key, data, relationships and ABAP select examples

OIH_TAX_REV is a standard SAP Table which is used to store Excise Duty Revaluation Documents data and is available within R/3 SAP systems depending on the version and release level.

The OIH_TAX_REV table consists of various fields, each holding specific information or linking keys about Excise Duty Revaluation Documents data available in SAP. These include BUKRS (Company Code), TR_NUMBER (Excise Duty Revaluation Document Number), TR_YEAR (Excise Duty Revaluation Document Year), TR_LINE (Item in tax revaluation document).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP OIH_TAX_REV table fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3Assigned to domainMANDT
BUKRSCompany Code BUKRSCHAR4Assigned to domainBUKRSBUKC_T001
TR_NUMBERExcise Duty Revaluation Document Number OIH_TAX_REV_NUMBERCHAR10ALPHAOIH_TAX_REVALUATION_NUMBEROIH_TR_DOC
TR_YEARExcise Duty Revaluation Document Year OIH_TAX_REV_YEARNUMC4GJAHRGJAHR
TR_LINEItem in tax revaluation document OIH_TAX_REV_LINENUMC4MBLPO
XBLNRReference Document Number XBLNR1CHAR16XBLNR1
WAERSCurrency Key WAERSCUKY5Assigned to domainWAERSFWS
MATNRMaterial Number MATNRCHAR18Assigned to domainMATN1MATNRMATS_MAT1
BWKEYValuation Area BWKEYCHAR4Assigned to domainBWKEYBWK
BWTARValuation Type BWTAR_DCHAR10Assigned to domainBWTARBWT
OICURVALExcise Duty Current Value OIH_CURTAXVCURR13(2) OIH_TAXDIF
OICURDATECurrent date OIH_CURDATDATS8DATUM
OICURQTYCurrent quantity with sign OIH_CURQTYVQUAN13(3) MENG13V
OICURUTCurrent unit of measure OIH_CURUTUNIT3Assigned to domainCUNITMEINS
OIFUTVALExcise Duty Future Value OIH_FUTTAXVCURR13(2) OIH_TAXDIF
OIFUTDATEFuture date OIH_FUTDATDATS8DATUM
OIFUTQTYFuture quantity with sign OIH_FUTQTYVQUAN13(3) MENG13V
OIFUTUTFuture unit of measure OIH_FUTUTUNIT3Assigned to domainCUNITMEINS
OINVALQTYNot to be used!!! (non valuated quantity) OIH_NVALQTQUAN13(3) MENGE
OIREQUATQuantity to be revaluated OIH_REQUATQUAN13(3) MENGE
OITAXKEYExcise Duty Status OIH_TAXKEYCHAR2Assigned to domainOIH_TAXKEY
OITAXDIFFExcise Duty Difference Value OIH_TAXDIFFCURR13(2) OIH_TAXDIF
OITAXDIFF1Excise Duty Difference Value (Element 1) OIH_TAXDIF1CURR13(2) OIH_TAXDIF
OITAXDIFF2Excise Duty Difference Value (Element 2) OIH_TAXDIF2CURR13(2) OIH_TAXDIF
OITAXDIFF3Excise Duty Difference Value (Element 3) OIH_TAXDIF3CURR13(2) OIH_TAXDIF
OITAXDIFF4Excise Duty Difference Value (Element 4) OIH_TAXDIF4CURR13(2) OIH_TAXDIF
OITAXDIFF5Excise Duty Difference Value (Element 5) OIH_TAXDIF5CURR13(2) OIH_TAXDIF
OITAXDIFF6Excise Duty Difference Value (Element 6) OIH_TAXDIF6CURR13(2) OIH_TAXDIF
OIHANTYPExcise Duty Handling Type OIH_HANTYPCHAR2Assigned to domainOIH_HANTYP
OITAXGRPExcise Duty Group OIH_TAXGRPCHAR2OIH2OIH_TAXGRP
SELKZSelection flag SELKZCHAR1SELKZ

Key field Non-key field



How do I retrieve data from SAP table OIH_TAX_REV using ABAP code

The following ABAP code Example will allow you to do a basic selection on OIH_TAX_REV to SELECT all data from the table
DATA: WA_OIH_TAX_REV TYPE OIH_TAX_REV.

SELECT SINGLE *
FROM OIH_TAX_REV
INTO CORRESPONDING FIELDS OF WA_OIH_TAX_REV
WHERE...

How to access SAP table OIH_TAX_REV

Within an ECC or HANA version of SAP you can also view further information about OIH_TAX_REV and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!