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

TableDescription
OIHLPSLicense Master Data - Plants
OIH01Excise Duty Rates Table
OIHSLOTDP (excise duty) special ledger object table
A443Red Rate Exc Duty Comp/Plant/Tax Group/Handling Type
OIH_J1B_CONBrazil: Convenio application rules per state
OIHEDOObject table 1, IS-OIL Excise Duty Special Ledger
OIH_J_1BATL4TTax Law ICMS - Texts
OIH31Material specific tolerance table
OIHSLATDP (excise duty) special ledger actual line item table
OIH_J1B_COPBrazil: Controled prices table

List of SAP tables for Tariffs, Duties and Permits

TableDescription
OIHLPSLicense Master Data - Plants
OIH01Excise Duty Rates Table
OIHSLOTDP (excise duty) special ledger object table
A443Red Rate Exc Duty Comp/Plant/Tax Group/Handling Type
OIH_J1B_CONBrazil: Convenio application rules per state
OIHEDOObject table 1, IS-OIL Excise Duty Special Ledger
OIH_J_1BATL4TTax Law ICMS - Texts
OIH31Material specific tolerance table
OIHSLATDP (excise duty) special ledger actual line item table
OIH_J1B_COPBrazil: Controled prices table
MSPT_OIGSTD Shipment Header to store deleted records
OIH07TDP allowed combinations of ED Group and Handling Type
OIHEDAActual line item table, IS-OIL Excise Duty Special Ledger
OIH_J1B_TCHDeprecated
OIH24AED GROUPING CODE
OIH_J1B_PPRBrazil Tax: Pondered average price table for final consume
SIPT_NUMST_OIGSignature PT: Number From in IS-OIL Process
OIH20License types
OIH_J_1BTXIX1Tax calc.: ISS rules for sales and purchasing exeptions
OIH_J1B_PISBrazil: PIS/COFINS taxation table (exactly one entry)
SIPT_NUMBR_OIGSiganture PT : Customizing Table for Signature in IS-OIL
A423Customer Specific Tax (FOB)
OIH18Price indicator (oih16-INEX) text table
OIH30ITracking item
OIH_J1B_ACSDEFBrazil: Oil Access Defintion
OIH22Interstate excise table
OIH_J1B_APRBrazil tax: Acquisition price table
OIH10ALicense Requirements Tab
OIH2V_J1BCheck table for vendor tax group
OIH2TDuty code/tax group description
C410Chart of accts / Account key - acct assign for ED rev
OIH_J_1BTXCI2Tax calc.: Complement of ICMS rules INSIDE CALCULATION
OIH_ETAX_GRP_MAPMapping of Excise Tax Groups into Product Tax Groups
OIHEDPPlan line item table, IS-OIL Excise Duty Special Ledger
OIH_J1B_PICBrazil: Printing exceptions for ICMS
OIHEDTSummary table, IS-OIL Excise Duty Special Ledger
OIH20TLicense type text
OIH_TAX_REVExcise Duty Revaluation Documents
OIHLOUsed licenses for orders
OIH2C_J1BCheck table for customer tax group
OIH07ATDP allowed combinations of ED Group and Handling Type
OIH_ETAX_TB070TDescription of Excise Tax Type per Country
OIH19Assignment between license regime and reference license typ
MSPT_OIGSIShipment Item to store deleted records
OIH21Assignment: License type to condition type
OIH_J1B_ZFDBrazil tax: Sub. Trib. Discount for Zona Franca de Manaus
OIH4TCustom duty/tax key descriptions
OIH26ALicense Requirements Tab
OIHLHTLicence allowed handling types
OIH16Internal/external price conditions
OIH_J1B_PCKBrazil: Check table for tax codes in Purchasing
OIH_J_1BTXST1Tax calc.: Sub.Trib. rules
A426State Tax on delivered goods
OIHSLTTDP (excise duty) special ledger summary table
OIH11Defaults for ext. sales functions
OIH_ETAX_CONDMAPMapping of Excise Tax Rate into Condition Technique
OIH_ETAX_TB070Definition of Excise Tax Type per Country
OIH_J1B_RAFBrazil: Refinery taxation table
OIHLLicense Master Data
A419ED pricing/Origin/Tax Group/Handl.Type/Orig.reg.
OIH08ADefault values for external procurement functions
OIH_J1B_INCBrazil: Incoming taxation table
OIH_J_1BTXIC2Tax calc.: ICMS rules (exceptions)
OIH09Excise duty defaults for Stock Transfers
OIH11ADefaults for ext. sales functions
OIH_J1B_ACSVALBrazil: Oil Access Values
OIH24ED GROUPING CODE
OIH_MIGO_HTDPStore the TDP-GOITEM for MIGOs hold/restore feature
A425State Tax FOB
OIH_J_1BTXCI1Tax calc.: Complement of ICMS rules
OIH_J1B_TOUBrazil: Check table for tax codes in Transfer Outgoing
OIH_J_1BTXIS1Tax calc.: ISS rules for sales exeptions
A424Exception for States (FOB)
OIH_J1B_TCIDeprecated
SIPT_GAPS_OIGDigitial Signature Portugal: Gaps for Delivery Documents
OIH2Excise duty tax group (IS-Oil TDP standard/core object)
A434Incoterms / Material group 2 - Federal
OIHLTGLicence allowed Excise duty tax group for material
OIH_J1B_TCHHDeprecated
OIH27TDP additional checks for sales
A433Customer Specific Tax (FOB) - Federal
OIH_J_1BATL4Tax Law PIS/COFINS
OIH_J_1BMSEG_NFLink between Gain and Losses Movements and Nota Fiscal
OIH6ED postings per ED rate
OIH_J1B_SAL_2Brazil: ICMS Deferment
OIH4Excise duty tax status (IS-Oil TDP standard/core object)
OIH5THandling type description
OIH2M_J1BCheck table for material tax group
OIH08Default values for external procurement functions
OIH_J1B_SALBrazil: Check table for tax codes in sales process
A444Two-step transfer with tracking sign
OIH_J1B_ALCBrazil: Percentage of alcohol in gasoline
OIH03Excise duty posting control
OIHLTRExcise license tracking pointer file
OIH_ETAX_GRPDefinition of Oil-Specific Product Tax Groups
OIH_J1B_SDTXCDSD tax code for ICMS ST calculation
OIHEDCObject table 2, IS-OIL Excise Duty Special Ledger
OIH_J1B_SSTADBrazil tax: Determines Accounts for posting Split of S. T.
OIH40Excise Duty defaulting table GI/GR for production orders
OIH_J1B_CPRBrazil: Posting exceptions for ICMS complement
A442Full Rate Excise Duty Company/Plant/Tax Group
OIH_J1B_FACBrazil: Factor for calculation of PIS / COFINS ST
OIH_J1B_TINBrazil: Check table for tax codes in Transfer Incoming
OIH_J_1BTREGXTax region
OIH25TDP additional checks for purchasing
OIH10License Requirements Tab
OIH79ED Notional Plant
OIH26License Requirements Tab
OIH14Tax rate revaluation - obsolete
OIH01AExcise Duty Rates Table
OIH30Two-step transfer control table
OIH30HTracking header