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
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

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

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OVPM154Outgoing Payments
5OIVL77Whse Journal
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction
Industry Specific :: Industry Solution Oil :: Production and Revenue Accounting :: Revenue
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0OIUH_RV_WHHD391Table for withholding reportRevenue
SQL:  selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns

SELECT MANDT, STA_OR_LVL_1_NO, WHHD_OWNER_NO, OSTA_OI_TYPE_CD, OSTA_TAX_DT, OSTA_ST_CD, A_GR_VAL_ADJ_AM, STA_SEVT_ADJ_AM, OSTA_MKD_ADJ_AM, STA_NVAL_ADJ_AM, A_NRA_WH_ADJ_AM, OSTA_WH_ADJ_AM, A_ST_TAX_ADJ_AM, A_VALTAX_ADJ_AM, OSTA_OTH_ADJ_AM, OSTA_INT_ADJ_AM, OSTA_GR_VAL_AM, OSTA_SEVT_AM, OSTA_MKD_AM, OSTA_NVAL_AM, OSTA_NRA_WH_AM, OSTA_WH_AM, OSTA_ST_TAX_AM, OSTA_VALTAX_AM, STA_INT_PAID_AM, TA_OTH_DED_7_AM, TA_OTH_DED_8_AM, A_OTH_DED_11_AM, A_OTH_DED_12_AM, A_OTH_DED_13_AM, A_OTH_DED_14_AM, A_OTH_DED_15_AM, A_OTH_DED_16_AM, A_OTH_DED_17_AM, A_OTH_DED_18_AM, OSTA_NEMCMP_AM, A_NEMCMP_ADJ_AM, WHHD_USER_ID, WHHD_TIMESTAMP FROM OIUH_RV_WHHD
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')No*MANDT Allow NULL? 
2STA_OR_LVL_1_NOOIUH_CHAR3nvarchar30CHAR(N' ')NoOIUH_CHAR3 Allow NULL? 
3WHHD_OWNER_NOOIUH_CHAR10nvarchar100CHAR(N' ')NoOIUH_CHAR10 Allow NULL? 
4OSTA_OI_TYPE_CDOIUH_CHAR2nvarchar20CHAR(N' ')NoOIUH_CHAR2 Allow NULL? 
5OSTA_TAX_DTOIUH_CHAR14nvarchar140CHAR(N' ')NoOIUH_CHAR14 Allow NULL? 
6OSTA_ST_CDOIUH_CHAR2nvarchar20CHAR(N' ')NoOIUH_CHAR2 Allow NULL? 
7A_GR_VAL_ADJ_AMLocal amountdecimal112CURR((0))NoOIUH_CURR11_2
8STA_SEVT_ADJ_AMLocal amountdecimal112CURR((0))NoOIUH_CURR11_2
9OSTA_MKD_ADJ_AMLocal amountdecimal112CURR((0))NoOIUH_CURR11_2
10STA_NVAL_ADJ_AMLocal amountdecimal112CURR((0))NoOIUH_CURR11_2
11A_NRA_WH_ADJ_AMLocal amountdecimal112CURR((0))NoOIUH_CURR11_2
12OSTA_WH_ADJ_AMLocal amountdecimal112CURR((0))NoOIUH_CURR11_2
13A_ST_TAX_ADJ_AMLocal amountdecimal112CURR((0))NoOIUH_CURR11_2
14A_VALTAX_ADJ_AMLocal amountdecimal112CURR((0))NoOIUH_CURR11_2
15OSTA_OTH_ADJ_AMLocal amountdecimal112CURR((0))NoOIUH_CURR11_2
16OSTA_INT_ADJ_AMLocal amountdecimal112CURR((0))NoOIUH_CURR11_2
17OSTA_GR_VAL_AMLocal amountdecimal112CURR((0))NoOIUH_CURR11_2
18OSTA_SEVT_AMLocal amountdecimal112CURR((0))NoOIUH_CURR11_2
19OSTA_MKD_AMLocal amountdecimal112CURR((0))NoOIUH_CURR11_2
20OSTA_NVAL_AMLocal amountdecimal112CURR((0))NoOIUH_CURR11_2
21OSTA_NRA_WH_AMLocal amountdecimal112CURR((0))NoOIUH_CURR11_2
22OSTA_WH_AMLocal amountdecimal112CURR((0))NoOIUH_CURR11_2
23OSTA_ST_TAX_AMLocal amountdecimal112CURR((0))NoOIUH_CURR11_2
24OSTA_VALTAX_AMLocal amountdecimal112CURR((0))NoOIUH_CURR11_2
25STA_INT_PAID_AMLocal amountdecimal112CURR((0))NoOIUH_CURR11_2
26TA_OTH_DED_7_AMLocal amountdecimal112CURR((0))NoOIUH_CURR11_2
27TA_OTH_DED_8_AMLocal amountdecimal112CURR((0))NoOIUH_CURR11_2
28A_OTH_DED_11_AMLocal amountdecimal112CURR((0))NoOIUH_CURR11_2
29A_OTH_DED_12_AMLocal amountdecimal112CURR((0))NoOIUH_CURR11_2
30A_OTH_DED_13_AMLocal amountdecimal112CURR((0))NoOIUH_CURR11_2
31A_OTH_DED_14_AMLocal amountdecimal112CURR((0))NoOIUH_CURR11_2
32A_OTH_DED_15_AMLocal amountdecimal112CURR((0))NoOIUH_CURR11_2
33A_OTH_DED_16_AMLocal amountdecimal112CURR((0))NoOIUH_CURR11_2
34A_OTH_DED_17_AMLocal amountdecimal112CURR((0))NoOIUH_CURR11_2
35A_OTH_DED_18_AMLocal amountdecimal112CURR((0))NoOIUH_CURR11_2
36OSTA_NEMCMP_AMLocal amountdecimal112CURR((0))NoOIUH_CURR11_2
37A_NEMCMP_ADJ_AMLocal amountdecimal112CURR((0))NoOIUH_CURR11_2
38WHHD_USER_IDOIUH_CHAR8nvarchar80CHAR(N' ')NoOIUH_CHAR8 Allow NULL? 
39WHHD_TIMESTAMPOIUH_CHAR14nvarchar140CHAR(N' ')NoOIUH_CHAR14 Allow NULL? 
NamePrimaryUniqueTypeColumns
OIUH_RV_WHHD~0YesYesCLUSTEREDOSTA_ST_CD, OSTA_TAX_DT, OSTA_OI_TYPE_CD, WHHD_OWNER_NO, STA_OR_LVL_1_NO, MANDT