SAP Tariffs, Duties and Permits Tables
Are you looking for the right table related to SAP Tariffs, Duties and Permits Tables to query in an ABAP Program, Class, Function Module and OData API?
There are number of standard tables in SAP S/4HANA system. The data of an application is distributed across several database fields. Finding the right table is important, in this post we'll look at list of all the tables in Tariffs, Duties and Permits (IS-OIL-DS-TDP) module.
Top 10 tables in Tariffs, Duties and Permits
| Table | Description |
|---|---|
| OIHLPS | License Master Data - Plants |
| OIH01 | Excise Duty Rates Table |
| OIHSLO | TDP (excise duty) special ledger object table |
| A443 | Red Rate Exc Duty Comp/Plant/Tax Group/Handling Type |
| OIH_J1B_CON | Brazil: Convenio application rules per state |
| OIHEDO | Object table 1, IS-OIL Excise Duty Special Ledger |
| OIH_J_1BATL4T | Tax Law ICMS - Texts |
| OIH31 | Material specific tolerance table |
| OIHSLA | TDP (excise duty) special ledger actual line item table |
| OIH_J1B_COP | Brazil: Controled prices table |
List of tables in Tariffs, Duties and Permits
| Table | Description |
|---|---|
| OIHLPS | License Master Data - Plants |
| OIH01 | Excise Duty Rates Table |
| OIHSLO | TDP (excise duty) special ledger object table |
| A443 | Red Rate Exc Duty Comp/Plant/Tax Group/Handling Type |
| OIH_J1B_CON | Brazil: Convenio application rules per state |
| OIHEDO | Object table 1, IS-OIL Excise Duty Special Ledger |
| OIH_J_1BATL4T | Tax Law ICMS - Texts |
| OIH31 | Material specific tolerance table |
| OIHSLA | TDP (excise duty) special ledger actual line item table |
| OIH_J1B_COP | Brazil: Controled prices table |
| MSPT_OIGS | TD Shipment Header to store deleted records |
| OIH07 | TDP allowed combinations of ED Group and Handling Type |
| OIHEDA | Actual line item table, IS-OIL Excise Duty Special Ledger |
| OIH_J1B_TCH | Deprecated |
| OIH24A | ED GROUPING CODE |
| OIH_J1B_PPR | Brazil Tax: Pondered average price table for final consume |
| SIPT_NUMST_OIG | Signature PT: Number From in IS-OIL Process |
| OIH20 | License types |
| OIH_J_1BTXIX1 | Tax calc.: ISS rules for sales and purchasing exeptions |
| OIH_J1B_PIS | Brazil: PIS/COFINS taxation table (exactly one entry) |
| SIPT_NUMBR_OIG | Siganture PT : Customizing Table for Signature in IS-OIL |
| A423 | Customer Specific Tax (FOB) |
| OIH18 | Price indicator (oih16-INEX) text table |
| OIH30I | Tracking item |
| OIH_J1B_ACSDEF | Brazil: Oil Access Defintion |
| OIH22 | Interstate excise table |
| OIH_J1B_APR | Brazil tax: Acquisition price table |
| OIH10A | License Requirements Tab |
| OIH2V_J1B | Check table for vendor tax group |
| OIH2T | Duty code/tax group description |
| C410 | Chart of accts / Account key - acct assign for ED rev |
| OIH_J_1BTXCI2 | Tax calc.: Complement of ICMS rules INSIDE CALCULATION |
| OIH_ETAX_GRP_MAP | Mapping of Excise Tax Groups into Product Tax Groups |
| OIHEDP | Plan line item table, IS-OIL Excise Duty Special Ledger |
| OIH_J1B_PIC | Brazil: Printing exceptions for ICMS |
| OIHEDT | Summary table, IS-OIL Excise Duty Special Ledger |
| OIH20T | License type text |
| OIH_TAX_REV | Excise Duty Revaluation Documents |
| OIHLO | Used licenses for orders |
| OIH2C_J1B | Check table for customer tax group |
| OIH07A | TDP allowed combinations of ED Group and Handling Type |
| OIH_ETAX_TB070T | Description of Excise Tax Type per Country |
| OIH19 | Assignment between license regime and reference license typ |
| MSPT_OIGSI | Shipment Item to store deleted records |
| OIH21 | Assignment: License type to condition type |
| OIH_J1B_ZFD | Brazil tax: Sub. Trib. Discount for Zona Franca de Manaus |
| OIH4T | Custom duty/tax key descriptions |
| OIH26A | License Requirements Tab |
| OIHLHT | Licence allowed handling types |
| OIH16 | Internal/external price conditions |
| OIH_J1B_PCK | Brazil: Check table for tax codes in Purchasing |
| OIH_J_1BTXST1 | Tax calc.: Sub.Trib. rules |
| A426 | State Tax on delivered goods |
| OIHSLT | TDP (excise duty) special ledger summary table |
| OIH11 | Defaults for ext. sales functions |
| OIH_ETAX_CONDMAP | Mapping of Excise Tax Rate into Condition Technique |
| OIH_ETAX_TB070 | Definition of Excise Tax Type per Country |
| OIH_J1B_RAF | Brazil: Refinery taxation table |
| OIHL | License Master Data |
| A419 | ED pricing/Origin/Tax Group/Handl.Type/Orig.reg. |
| OIH08A | Default values for external procurement functions |
| OIH_J1B_INC | Brazil: Incoming taxation table |
| OIH_J_1BTXIC2 | Tax calc.: ICMS rules (exceptions) |
| OIH09 | Excise duty defaults for Stock Transfers |
| OIH11A | Defaults for ext. sales functions |
| OIH_J1B_ACSVAL | Brazil: Oil Access Values |
| OIH24 | ED GROUPING CODE |
| OIH_MIGO_HTDP | Store the TDP-GOITEM for MIGOs hold/restore feature |
| A425 | State Tax FOB |
| OIH_J_1BTXCI1 | Tax calc.: Complement of ICMS rules |
| OIH_J1B_TOU | Brazil: Check table for tax codes in Transfer Outgoing |
| OIH_J_1BTXIS1 | Tax calc.: ISS rules for sales exeptions |
| A424 | Exception for States (FOB) |
| OIH_J1B_TCI | Deprecated |
| SIPT_GAPS_OIG | Digitial Signature Portugal: Gaps for Delivery Documents |
| OIH2 | Excise duty tax group (IS-Oil TDP standard/core object) |
| A434 | Incoterms / Material group 2 - Federal |
| OIHLTG | Licence allowed Excise duty tax group for material |
| OIH_J1B_TCHH | Deprecated |
| OIH27 | TDP additional checks for sales |
| A433 | Customer Specific Tax (FOB) - Federal |
| OIH_J_1BATL4 | Tax Law PIS/COFINS |
| OIH_J_1BMSEG_NF | Link between Gain and Losses Movements and Nota Fiscal |
| OIH6 | ED postings per ED rate |
| OIH_J1B_SAL_2 | Brazil: ICMS Deferment |
| OIH4 | Excise duty tax status (IS-Oil TDP standard/core object) |
| OIH5T | Handling type description |
| OIH2M_J1B | Check table for material tax group |
| OIH08 | Default values for external procurement functions |
| OIH_J1B_SAL | Brazil: Check table for tax codes in sales process |
| A444 | Two-step transfer with tracking sign |
| OIH_J1B_ALC | Brazil: Percentage of alcohol in gasoline |
| OIH03 | Excise duty posting control |
| OIHLTR | Excise license tracking pointer file |
| OIH_ETAX_GRP | Definition of Oil-Specific Product Tax Groups |
| OIH_J1B_SDTXCD | SD tax code for ICMS ST calculation |
| OIHEDC | Object table 2, IS-OIL Excise Duty Special Ledger |
| OIH_J1B_SSTAD | Brazil tax: Determines Accounts for posting Split of S. T. |
| OIH40 | Excise Duty defaulting table GI/GR for production orders |
| OIH_J1B_CPR | Brazil: Posting exceptions for ICMS complement |
| A442 | Full Rate Excise Duty Company/Plant/Tax Group |
| OIH_J1B_FAC | Brazil: Factor for calculation of PIS / COFINS ST |
| OIH_J1B_TIN | Brazil: Check table for tax codes in Transfer Incoming |
| OIH_J_1BTREGX | Tax region |
| OIH25 | TDP additional checks for purchasing |
| OIH10 | License Requirements Tab |
| OIH79 | ED Notional Plant |
| OIH26 | License Requirements Tab |
| OIH14 | Tax rate revaluation - obsolete |
| OIH01A | Excise Duty Rates Table |
| OIH30 | Two-step transfer control table |
| OIH30H | Tracking header |