SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

Schema:
 Module:  Table: 
Column: 
Searchbeta 

icon of database logic symbol SAP  TABLESv1Made in Britain

JDETables.com - the webs number one JD Edwards Table Definition reference

ERP 6.0: Top 10 requests

TableColumnsDescription
1TJKWE15IS-M/SD: WBZ, Order Data for Inbound Processing
2RSADMINC96Customizing Table General BW
3BBP_PD_XML8Table for Persistent Class CL_XML_PPF_BBP
4/OTX/RM_TELIB24Enterprise Library Server Settings
5UMV_TR1259Obsolete:Val.Driver Tree:Assign.Web Reports to Value Drivers
6/ISDFPS/CHVW_E34External Batch Where-Used List
7FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
8BSEG345Accounting Document Segment
9/1RA/0SD010MI170Items for Class SD01 - Raw Data
10FMARCPAR4Parallelization of FMARC_BATCH

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5OJDT100Journal Entry
6INV1265A/R Invoice - Rows
7OPCH386A/P Invoice
8JDT1124Journal Entry - Rows
9OPOR386Purchase Order
10OVTG52Tax Definition

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OIVL77Whse Journal
5OVPM154Outgoing Payments
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OINM101Whse Journal
10OSRN20Serial Numbers Master Data

107 tablesERP 6.0 

Industry Specific :: Industry Solution Oil :: Downstream :: Tariffs, Duties and Permits
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0A419131ED pricing/Origin/Tax Group/Handl.Type/Orig.reg.Tariffs, Duties and Permits
2ERP EHP76.0A42391Customer Specific Tax (FOB)Tariffs, Duties and Permits
3ERP EHP76.0A424101Exception for States (FOB)Tariffs, Duties and Permits
4ERP EHP76.0A42591State Tax FOBTariffs, Duties and Permits
5ERP EHP76.0A42691State Tax on delivered goodsTariffs, Duties and Permits
6ERP EHP76.0A43381Customer Specific Tax (FOB) - FederalTariffs, Duties and Permits
7ERP EHP76.0A43481Incoterms / Material group 2 - FederalTariffs, Duties and Permits
8ERP EHP76.0A44291Full Rate Excise Duty Company/Plant/Tax GroupTariffs, Duties and Permits
9ERP EHP76.0A443101Red Rate Exc Duty Comp/Plant/Tax Group/Handling TypeTariffs, Duties and Permits
10ERP EHP76.0A44491Two-step transfer with tracking signTariffs, Duties and Permits
11ERP EHP76.0C41071Chart of accts / Account key - acct assign for ED revTariffs, Duties and Permits
12ERP EHP76.0OIH01161Excise Duty Rates TableTariffs, Duties and Permits
13ERP EHP76.0OIH01A191Excise Duty Rates TableTariffs, Duties and Permits
14ERP EHP76.0OIH03111Excise duty posting controlTariffs, Duties and Permits
15ERP EHP76.0OIH0761TDP allowed combinations of ED Group and Handling TypeTariffs, Duties and Permits
16ERP EHP76.0OIH07A91TDP allowed combinations of ED Group and Handling TypeTariffs, Duties and Permits
17ERP EHP76.0OIH0881Default values for external procurement functionsTariffs, Duties and Permits
18ERP EHP76.0OIH08A111Default values for external procurement functionsTariffs, Duties and Permits
19ERP EHP76.0OIH09121Excise duty defaults for Stock TransfersTariffs, Duties and Permits
20ERP EHP76.0OIH1071License Requirements TabTariffs, Duties and Permits
21ERP EHP76.0OIH10A101License Requirements TabTariffs, Duties and Permits
22ERP EHP76.0OIH1161Defaults for ext. sales functionsTariffs, Duties and Permits
23ERP EHP76.0OIH11A91Defaults for ext. sales functionsTariffs, Duties and Permits
24ERP EHP76.0OIH14301Tax rate revaluation - obsoleteTariffs, Duties and Permits
25ERP EHP76.0OIH1631Internal/external price conditionsTariffs, Duties and Permits
26ERP EHP76.0OIH1841Price indicator (oih16-INEX) text tableTariffs, Duties and Permits
27ERP EHP76.0OIH1931Assignment between license regime and reference license typTariffs, Duties and Permits
28ERP EHP76.0OIH231Excise duty tax group (IS-Oil TDP standard/core object)Tariffs, Duties and Permits
29ERP EHP76.0OIH20101License typesTariffs, Duties and Permits
30ERP EHP76.0OIH20T41License type textTariffs, Duties and Permits
31ERP EHP76.0OIH2131Assignment: License type to condition typeTariffs, Duties and Permits
32ERP EHP76.0OIH2281Interstate excise tableTariffs, Duties and Permits
33ERP EHP76.0OIH2471ED GROUPING CODETariffs, Duties and Permits
34ERP EHP76.0OIH24A91ED GROUPING CODETariffs, Duties and Permits
35ERP EHP76.0OIH2541TDP additional checks for purchasingTariffs, Duties and Permits
36ERP EHP76.0OIH2681License Requirements TabTariffs, Duties and Permits
37ERP EHP76.0OIH26A111License Requirements TabTariffs, Duties and Permits
38ERP EHP76.0OIH2741TDP additional checks for salesTariffs, Duties and Permits
39ERP EHP76.0OIH2C_J1B51Check table for customer tax groupTariffs, Duties and Permits
40ERP EHP76.0OIH2M_J1B131Check table for material tax groupTariffs, Duties and Permits
41ERP EHP76.0OIH2T41Duty code/tax group descriptionTariffs, Duties and Permits
42ERP EHP76.0OIH2V_J1B51Check table for vendor tax groupTariffs, Duties and Permits
43ERP EHP76.0OIH30171Two-step transfer control tableTariffs, Duties and Permits
44ERP EHP76.0OIH30H172Tracking headerTariffs, Duties and Permits
45ERP EHP76.0OIH30I91Tracking itemTariffs, Duties and Permits
46ERP EHP76.0OIH3191Material specific tolerance tableTariffs, Duties and Permits
47ERP EHP76.0OIH441Excise duty tax status (IS-Oil TDP standard/core object)Tariffs, Duties and Permits
48ERP EHP76.0OIH4081Excise Duty defaulting table GI/GR for production ordersTariffs, Duties and Permits
49ERP EHP76.0OIH4T41Custom duty/tax key descriptionsTariffs, Duties and Permits
50ERP EHP76.0OIH5T41Handling type descriptionTariffs, Duties and Permits
51ERP EHP76.0OIH681ED postings per ED rateTariffs, Duties and Permits
52ERP EHP76.0OIH7961ED Notional PlantTariffs, Duties and Permits
53ERP EHP76.0OIHEDA765Actual line item table, IS-OIL Excise Duty Special LedgerTariffs, Duties and Permits
54ERP EHP76.0OIHEDC32Object table 2, IS-OIL Excise Duty Special LedgerTariffs, Duties and Permits
55ERP EHP76.0OIHEDO182Object table 1, IS-OIL Excise Duty Special LedgerTariffs, Duties and Permits
56ERP EHP76.0OIHEDP1395Plan line item table, IS-OIL Excise Duty Special LedgerTariffs, Duties and Permits
57ERP EHP76.0OIHEDT1254Summary table, IS-OIL Excise Duty Special LedgerTariffs, Duties and Permits
58ERP EHP76.0OIHL415License Master DataTariffs, Duties and Permits
59ERP EHP76.0OIHLHT41Licence allowed handling typesTariffs, Duties and Permits
60ERP EHP76.0OIHLO72Used licenses for ordersTariffs, Duties and Permits
61ERP EHP76.0OIHLPS41License Master Data - PlantsTariffs, Duties and Permits
62ERP EHP76.0OIHLTG41Licence allowed Excise duty tax group for materialTariffs, Duties and Permits
63ERP EHP76.0OIHLTR91Excise license tracking pointer fileTariffs, Duties and Permits
64ERP EHP76.0OIHSLA655TDP (excise duty) special ledger actual line item tableTariffs, Duties and Permits
65ERP EHP76.0OIHSLO162TDP (excise duty) special ledger object tableTariffs, Duties and Permits
66ERP EHP76.0OIHSLT922TDP (excise duty) special ledger summary tableTariffs, Duties and Permits
67ERP EHP76.0OIH_ETAX_CONDMAP91Mapping of Excise Tax Rate into Condition TechniqueTariffs, Duties and Permits
68ERP EHP76.0OIH_ETAX_GRP51Definition of Oil-Specific Product Tax GroupsTariffs, Duties and Permits
69ERP EHP76.0OIH_ETAX_GRP_MAP61Mapping of Excise Tax Groups into Product Tax GroupsTariffs, Duties and Permits
70ERP EHP76.0OIH_ETAX_TB07071Definition of Excise Tax Type per CountryTariffs, Duties and Permits
71ERP EHP76.0OIH_ETAX_TB070T51Description of Excise Tax Type per CountryTariffs, Duties and Permits
72ERP EHP76.0OIH_J1B_ACSDEF61Brazil: Oil Access DefintionTariffs, Duties and Permits
73ERP EHP76.0OIH_J1B_ACSVAL81Brazil: Oil Access ValuesTariffs, Duties and Permits
74ERP EHP76.0OIH_J1B_ALC61Brazil: Percentage of alcohol in gasolineTariffs, Duties and Permits
75ERP EHP76.0OIH_J1B_APR141Brazil tax: Acquisition price tableTariffs, Duties and Permits
76ERP EHP76.0OIH_J1B_CON61Brazil: Convenio application rules per stateTariffs, Duties and Permits
77ERP EHP76.0OIH_J1B_COP131Brazil: Controled prices tableTariffs, Duties and Permits
78ERP EHP76.0OIH_J1B_CPR101Brazil: Posting exceptions for ICMS complementTariffs, Duties and Permits
79ERP EHP76.0OIH_J1B_FAC141Brazil: Factor for calculation of PIS / COFINS STTariffs, Duties and Permits
80ERP EHP76.0OIH_J1B_INC211Brazil: Incoming taxation tableTariffs, Duties and Permits
81ERP EHP76.0OIH_J1B_PCK161Brazil: Check table for tax codes in PurchasingTariffs, Duties and Permits
82ERP EHP76.0OIH_J1B_PIC111Brazil: Printing exceptions for ICMSTariffs, Duties and Permits
83ERP EHP76.0OIH_J1B_PIS121Brazil: PIS/COFINS taxation table (exactly one entry)Tariffs, Duties and Permits
84ERP EHP76.0OIH_J1B_PPR141Brazil Tax: Pondered average price table for final consumeTariffs, Duties and Permits
85ERP EHP76.0OIH_J1B_RAF131Brazil: Refinery taxation tableTariffs, Duties and Permits
86ERP EHP76.0OIH_J1B_SAL241Brazil: Check table for tax codes in sales processTariffs, Duties and Permits
87ERP EHP76.0OIH_J1B_SAL_2181Brazil: ICMS DefermentTariffs, Duties and Permits
88ERP EHP76.0OIH_J1B_SDTXCD31SD tax code for ICMS ST calculationTariffs, Duties and Permits
89ERP EHP76.0OIH_J1B_SSTAD131Brazil tax: Determines Accounts for posting Split of S. T.Tariffs, Duties and Permits
90ERP EHP76.0OIH_J1B_TCH111Tax Calculation Commands HeaderTariffs, Duties and Permits
91ERP EHP76.0OIH_J1B_TCHH81Tax Calculation Commands Header HistoryTariffs, Duties and Permits
92ERP EHP76.0OIH_J1B_TCI121Brazilian Tax Calculation Commands ItemsTariffs, Duties and Permits
93ERP EHP76.0OIH_J1B_TIN91Brazil: Check table for tax codes in Transfer IncomingTariffs, Duties and Permits
94ERP EHP76.0OIH_J1B_TOU181Brazil: Check table for tax codes in Transfer OutgoingTariffs, Duties and Permits
95ERP EHP76.0OIH_J1B_ZFD131Brazil tax: Sub. Trib. Discount for Zona Franca de ManausTariffs, Duties and Permits
96ERP EHP76.0OIH_J_1BATL421Tax Law PIS/COFINSTariffs, Duties and Permits
97ERP EHP76.0OIH_J_1BATL4T81Tax Law ICMS - TextsTariffs, Duties and Permits
98ERP EHP76.0OIH_J_1BMSEG_NF51Link between Gain and Losses Movements and Nota FiscalTariffs, Duties and Permits
99ERP EHP76.0OIH_J_1BTREGX71Tax regionTariffs, Duties and Permits
100ERP EHP76.0OIH_J_1BTXCI191Tax calc.: Complement of ICMS rulesTariffs, Duties and Permits
101ERP EHP76.0OIH_J_1BTXCI2111Tax calc.: Complement of ICMS rules INSIDE CALCULATIONTariffs, Duties and Permits
102ERP EHP76.0OIH_J_1BTXIC2121Tax calc.: ICMS rules (exceptions)Tariffs, Duties and Permits
103ERP EHP76.0OIH_J_1BTXIS191Tax calc.: ISS rules for sales exeptionsTariffs, Duties and Permits
104ERP EHP76.0OIH_J_1BTXIX1151Tax calc.: ISS rules for sales and purchasing exeptionsTariffs, Duties and Permits
105ERP EHP76.0OIH_J_1BTXST1211Tax calc.: Sub.Trib. rulesTariffs, Duties and Permits
106ERP EHP76.0OIH_MIGO_HTDP401Store the TDP-GOITEM for MIGOs hold/restore featureTariffs, Duties and Permits
107ERP EHP76.0OIH_TAX_REV311Excise Duty Revaluation DocumentsTariffs, Duties and Permits