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 :: Valuation
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0OIUVL_STS621Severance tax statisticsValuation
SQL:  selectupdate insert create

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

SELECT MANDT, SEV_NO, TAX_TYPE, SEVT_PAY_FL, SEVT_RPT_FL, VL_TAX_RAT, VAL_TAX_RAT, ACTL_TXVAL, ACTL_TXVL, ACTL_OVRD_TAX_VA, ACTL_OVRD_TAX_VL, FX_MCD, FX_MCD_RAT, TOTAL_TAX_PC, EXMP_CD_1, EXMP_CD_2, EXMP_CD_3, EXMP_CD_4, EXMP_CD_5, EXMP_INT_DEC_1, EXMP_INT_DEC_2, EXMP_INT_DEC_3, EXMP_INT_DEC_4, EXMP_INT_DEC_5, EXMP_VL_1, EXMP_VL_2, EXMP_VL_3, EXMP_VL_4, EXMP_VL_5, EXMP_VAL_1, EXMP_VAL_2, EXMP_VAL_3, EXMP_VAL_4, EXMP_VAL_5, ACTL_MKCT_1, ACTL_MKCT_2, ACTL_MKCT_3, ACTL_MKCT_4, ACTL_MKCT_5, ACTL_MKCT_6, ACTL_MKCT_7, ACTL_MKCT_8, ACTL_MKCT_9, ACTL_MKCT_10, ACTL_MCR_1, ACTL_MCR_2, ACTL_MCR_3, ACTL_MCR_4, ACTL_MCR_5, ACTL_MCR_6, ACTL_MCR_7, ACTL_MCR_8, ACTL_MCR_9, ACTL_MCR_10, ACTL_ST_TAX_AM, ACTL_ST_TAX_REIM, OIU_CRUSER, OIU_TIMESTAMP, TAX_FREE_05_VAL, TAX_FREE_05_VL, TAX_FREE_05_WLR, ST_TAX_PROC_ALLW FROM OIUVL_STS
ColumnFieldDescriptionSQL TypeLengthDecimalsRelationDefault ValueConstraintsSQL Create Statement
1MANDTClientnvarchar30 Allow NULL? 
2SEV_NOSeverance tax numbernvarchar200 Allow NULL? 
3TAX_TYPESeverance Tax Typenvarchar20 Allow NULL? 
4SEVT_PAY_FLTax Severance Tax Calculation Payment Obligations Typeschar10 Allow NULL? 
5SEVT_RPT_FLState Severance Tax Reporting Indicatorschar10 Allow NULL? 
6VL_TAX_RATVolume tax ratedecimal76
7VAL_TAX_RATValue tax ratedecimal76
8ACTL_TXVALActual taxable valuedecimal152
9ACTL_TXVLActual taxable volumedecimal133
10ACTL_OVRD_TAX_VAActual override taxable valuedecimal152
11ACTL_OVRD_TAX_VLActual override taxable volumedecimal133
12FX_MCDFixed marketing cost deductiondecimal152
13FX_MCD_RATFixed marketing cost deduction ratedecimal52
14TOTAL_TAX_PCTotal tax percentagedecimal98
15EXMP_CD_1Exempt Entity Codenvarchar20 Allow NULL? 
16EXMP_CD_2Exempt Entity Codenvarchar20 Allow NULL? 
17EXMP_CD_3Exempt Entity Codenvarchar20 Allow NULL? 
18EXMP_CD_4Exempt Entity Codenvarchar20 Allow NULL? 
19EXMP_CD_5Exempt Entity Codenvarchar20 Allow NULL? 
20EXMP_INT_DEC_1Exempt interest decimaldecimal98
21EXMP_INT_DEC_2Exempt interest decimaldecimal98
22EXMP_INT_DEC_3Exempt interest decimaldecimal98
23EXMP_INT_DEC_4Exempt interest decimaldecimal98
24EXMP_INT_DEC_5Exempt interest decimaldecimal98
25EXMP_VL_1Exempt volumedecimal133
26EXMP_VL_2Exempt volumedecimal133
27EXMP_VL_3Exempt volumedecimal133
28EXMP_VL_4Exempt volumedecimal133
29EXMP_VL_5Exempt volumedecimal133
30EXMP_VAL_1Exempt valuedecimal152
31EXMP_VAL_2Exempt valuedecimal152
32EXMP_VAL_3Exempt valuedecimal152
33EXMP_VAL_4Exempt valuedecimal152
34EXMP_VAL_5Exempt valuedecimal152
35ACTL_MKCT_1Actual marketing costdecimal152
36ACTL_MKCT_2Actual marketing costdecimal152
37ACTL_MKCT_3Actual marketing costdecimal152
38ACTL_MKCT_4Actual marketing costdecimal152
39ACTL_MKCT_5Actual marketing costdecimal152
40ACTL_MKCT_6Actual marketing costdecimal152
41ACTL_MKCT_7Actual marketing costdecimal152
42ACTL_MKCT_8Actual marketing costdecimal152
43ACTL_MKCT_9Actual marketing costdecimal152
44ACTL_MKCT_10Actual marketing costdecimal152
45ACTL_MCR_1Actual marketing cost reimbursementdecimal152
46ACTL_MCR_2Actual marketing cost reimbursementdecimal152
47ACTL_MCR_3Actual marketing cost reimbursementdecimal152
48ACTL_MCR_4Actual marketing cost reimbursementdecimal152
49ACTL_MCR_5Actual marketing cost reimbursementdecimal152
50ACTL_MCR_6Actual marketing cost reimbursementdecimal152
51ACTL_MCR_7Actual marketing cost reimbursementdecimal152
52ACTL_MCR_8Actual marketing cost reimbursementdecimal152
53ACTL_MCR_9Actual marketing cost reimbursementdecimal152
54ACTL_MCR_10Actual marketing cost reimbursementdecimal152
55ACTL_ST_TAX_AMActual state tax amountdecimal152
56ACTL_ST_TAX_REIMActual state tax reimbursementdecimal152
57OIU_CRUSERName of Person who Created the Objectnvarchar120 Allow NULL? 
58OIU_TIMESTAMPUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
59TAX_FREE_05_VALTax free 05 valuedecimal152
60TAX_FREE_05_VLTax free 05 volumedecimal133
61TAX_FREE_05_WLRTax free 05 wet-less-residuedecimal133
62ST_TAX_PROC_ALLWState tax processing allowancedecimal152
NamePrimaryUniqueTypeColumns
OIUVL_STS~0YesYesCLUSTEREDTAX_TYPE, SEV_NO, MANDT