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)
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9BSEG345Accounting Document Segment
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
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 TypeLengthDecimalsRelationDefault ValueConstraintsSQL Create Statement
1MANDTClientnvarchar30 Allow NULL? 
2STA_OR_LVL_1_NOOIUH_CHAR3nvarchar30 Allow NULL? 
3WHHD_OWNER_NOOIUH_CHAR10nvarchar100 Allow NULL? 
4OSTA_OI_TYPE_CDOIUH_CHAR2nvarchar20 Allow NULL? 
5OSTA_TAX_DTOIUH_CHAR14nvarchar140 Allow NULL? 
6OSTA_ST_CDOIUH_CHAR2nvarchar20 Allow NULL? 
7A_GR_VAL_ADJ_AMLocal amountdecimal112
8STA_SEVT_ADJ_AMLocal amountdecimal112
9OSTA_MKD_ADJ_AMLocal amountdecimal112
10STA_NVAL_ADJ_AMLocal amountdecimal112
11A_NRA_WH_ADJ_AMLocal amountdecimal112
12OSTA_WH_ADJ_AMLocal amountdecimal112
13A_ST_TAX_ADJ_AMLocal amountdecimal112
14A_VALTAX_ADJ_AMLocal amountdecimal112
15OSTA_OTH_ADJ_AMLocal amountdecimal112
16OSTA_INT_ADJ_AMLocal amountdecimal112
17OSTA_GR_VAL_AMLocal amountdecimal112
18OSTA_SEVT_AMLocal amountdecimal112
19OSTA_MKD_AMLocal amountdecimal112
20OSTA_NVAL_AMLocal amountdecimal112
21OSTA_NRA_WH_AMLocal amountdecimal112
22OSTA_WH_AMLocal amountdecimal112
23OSTA_ST_TAX_AMLocal amountdecimal112
24OSTA_VALTAX_AMLocal amountdecimal112
25STA_INT_PAID_AMLocal amountdecimal112
26TA_OTH_DED_7_AMLocal amountdecimal112
27TA_OTH_DED_8_AMLocal amountdecimal112
28A_OTH_DED_11_AMLocal amountdecimal112
29A_OTH_DED_12_AMLocal amountdecimal112
30A_OTH_DED_13_AMLocal amountdecimal112
31A_OTH_DED_14_AMLocal amountdecimal112
32A_OTH_DED_15_AMLocal amountdecimal112
33A_OTH_DED_16_AMLocal amountdecimal112
34A_OTH_DED_17_AMLocal amountdecimal112
35A_OTH_DED_18_AMLocal amountdecimal112
36OSTA_NEMCMP_AMLocal amountdecimal112
37A_NEMCMP_ADJ_AMLocal amountdecimal112
38WHHD_USER_IDOIUH_CHAR8nvarchar80 Allow NULL? 
39WHHD_TIMESTAMPOIUH_CHAR14nvarchar140 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