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_STS652Severence Tax SubsidiaryRevenue
SQL:  selectupdate insert create

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

SELECT MANDT, DUMMY_SEQ_FIELD, STS_SEV_SYS_NO, STS_TAX_TYPE, STS_TAX_PAY_FL, STS_TAX_RPT_FL, TAX_CALC_BS_CD, VL_TAX_RATE_PC, VAL_TAX_RAT_PC, STS_TAX_VAL_AM, STS_TAX_VL_AM, S_OVRD_TAXVA_AM, S_OVRD_TAXVL_AM, S_FX_MKD_RAT_PC, STS_FX_MKD_AM, STS_TOT_TAX_PC, EXEN_TYPE_1_CD, EXEN_TYPE_2_CD, EXEN_TYPE_3_CD, EXEN_TYPE_4_CD, EXEN_TYPE_5_CD, S_EXIN_DEC_1_AM, S_EXIN_DEC_2_AM, S_EXIN_DEC_3_AM, S_EXIN_DEC_4_AM, S_EXIN_DEC_5_AM, ACTL_EXVL_1_AM, ACTL_EXVL_2_AM, ACTL_EXVL_3_AM, ACTL_EXVL_4_AM, ACTL_EXVL_5_AM, ACTL_EXVA_1_AM, ACTL_EXVA_2_AM, ACTL_EXVA_3_AM, ACTL_EXVA_4_AM, ACTL_EXVA_5_AM, S_TAX_MKCT_1_AM, S_TAX_MKCT_2_AM, S_TAX_MKCT_3_AM, S_TAX_MKCT_4_AM, S_TAX_MKCT_5_AM, S_TAX_MKCT_6_AM, S_TAX_MKCT_7_AM, S_TAX_MKCT_8_AM, S_TAX_MKCT_9_AM, TAX_MKCT_10_AM, TS_TAX_MCR_1_AM, TS_TAX_MCR_2_AM, TS_TAX_MCR_3_AM, TS_TAX_MCR_4_AM, TS_TAX_MCR_5_AM, TS_TAX_MCR_6_AM, TS_TAX_MCR_7_AM, TS_TAX_MCR_8_AM, TS_TAX_MCR_9_AM, S_TAX_MCR_10_AM, STS_ACTL_STX_AM, TS_ACTL_STXR_AM, STS_VER_NO, STS_USER_ID, STS_TIMESTAMP, TAX_FREE_05_VAL, TAX_FREE_05_VL, TAX_FREE_05_WLR, ST_TAX_PROC_ALLW FROM OIUH_RV_STS
ColumnFieldDescriptionSQL TypeLengthDecimalsRelationDefault ValueConstraintsSQL Create Statement
1MANDTClientnvarchar30 Allow NULL? 
2DUMMY_SEQ_FIELDOIUH_CHAR10nvarchar100 Allow NULL? 
3STS_SEV_SYS_NOSeverance tax numbernvarchar200 Allow NULL? 
4STS_TAX_TYPEOIUH_CHAR2nvarchar20 Allow NULL? 
5STS_TAX_PAY_FLOIUH_CHAR1char10 Allow NULL? 
6STS_TAX_RPT_FLOIUH_CHAR1char10 Allow NULL? 
7TAX_CALC_BS_CDOIUH_CHAR1char10 Allow NULL? 
8VL_TAX_RATE_PCOIUH_DEC7_6decimal76
9VAL_TAX_RAT_PCOIUH_DEC7_6decimal76
10STS_TAX_VAL_AMLocal amountdecimal112
11STS_TAX_VL_AMOIUH_DEC11_2decimal112
12S_OVRD_TAXVA_AMLocal amountdecimal112
13S_OVRD_TAXVL_AMOIUH_DEC11_2decimal112
14S_FX_MKD_RAT_PCOIUH_DEC5_2decimal52
15STS_FX_MKD_AMLocal amountdecimal72
16STS_TOT_TAX_PCOIUH_DEC9_8decimal98
17EXEN_TYPE_1_CDOIUH_CHAR2nvarchar20 Allow NULL? 
18EXEN_TYPE_2_CDOIUH_CHAR2nvarchar20 Allow NULL? 
19EXEN_TYPE_3_CDOIUH_CHAR2nvarchar20 Allow NULL? 
20EXEN_TYPE_4_CDOIUH_CHAR2nvarchar20 Allow NULL? 
21EXEN_TYPE_5_CDOIUH_CHAR2nvarchar20 Allow NULL? 
22S_EXIN_DEC_1_AMOIUH_DEC9_8decimal98
23S_EXIN_DEC_2_AMOIUH_DEC9_8decimal98
24S_EXIN_DEC_3_AMOIUH_DEC9_8decimal98
25S_EXIN_DEC_4_AMOIUH_DEC9_8decimal98
26S_EXIN_DEC_5_AMOIUH_DEC9_8decimal98
27ACTL_EXVL_1_AMOIUH_DEC11_2decimal112
28ACTL_EXVL_2_AMOIUH_DEC11_2decimal112
29ACTL_EXVL_3_AMOIUH_DEC11_2decimal112
30ACTL_EXVL_4_AMOIUH_DEC11_2decimal112
31ACTL_EXVL_5_AMOIUH_DEC11_2decimal112
32ACTL_EXVA_1_AMLocal amountdecimal112
33ACTL_EXVA_2_AMLocal amountdecimal112
34ACTL_EXVA_3_AMLocal amountdecimal112
35ACTL_EXVA_4_AMLocal amountdecimal112
36ACTL_EXVA_5_AMLocal amountdecimal112
37S_TAX_MKCT_1_AMLocal amountdecimal112
38S_TAX_MKCT_2_AMLocal amountdecimal112
39S_TAX_MKCT_3_AMLocal amountdecimal112
40S_TAX_MKCT_4_AMLocal amountdecimal112
41S_TAX_MKCT_5_AMLocal amountdecimal112
42S_TAX_MKCT_6_AMLocal amountdecimal112
43S_TAX_MKCT_7_AMLocal amountdecimal112
44S_TAX_MKCT_8_AMLocal amountdecimal112
45S_TAX_MKCT_9_AMLocal amountdecimal112
46TAX_MKCT_10_AMLocal amountdecimal112
47TS_TAX_MCR_1_AMLocal amountdecimal112
48TS_TAX_MCR_2_AMLocal amountdecimal112
49TS_TAX_MCR_3_AMLocal amountdecimal112
50TS_TAX_MCR_4_AMLocal amountdecimal112
51TS_TAX_MCR_5_AMLocal amountdecimal112
52TS_TAX_MCR_6_AMLocal amountdecimal112
53TS_TAX_MCR_7_AMLocal amountdecimal112
54TS_TAX_MCR_8_AMLocal amountdecimal112
55TS_TAX_MCR_9_AMLocal amountdecimal112
56S_TAX_MCR_10_AMLocal amountdecimal112
57STS_ACTL_STX_AMLocal amountdecimal112
58TS_ACTL_STXR_AMLocal amountdecimal112
59STS_VER_NOOIUH_DEC5decimal50
60STS_USER_IDOIUH_CHAR8nvarchar80 Allow NULL? 
61STS_TIMESTAMPOIUH_CHAR14nvarchar140 Allow NULL? 
62TAX_FREE_05_VALTax free 05 valuedecimal152
63TAX_FREE_05_VLTax free 05 volumedecimal133
64TAX_FREE_05_WLRTax free 05 wet-less-residuedecimal133
65ST_TAX_PROC_ALLWState tax processing allowancedecimal152
NamePrimaryUniqueTypeColumns
OIUH_RV_STS~0YesYesCLUSTEREDDUMMY_SEQ_FIELD, MANDT
OIUH_RV_STS~I01NoYesNONCLUSTEREDSTS_TAX_TYPE, STS_SEV_SYS_NO, MANDT