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.0OIUE1_LSSL_SUM1344Legal Suspense SummaryRevenue
SQL:  selectupdate insert create

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

SELECT MANDT, OWN_NO, OWN_SEQ_NO, DOI_PR_NO, DOI_SEQ_NO, PD_CD, SA_DT, O_I_TYPE, O_I_SEQ_NO, ACCT_NO, O_DECM_QY, LGND_CD, SYS_NO, OR_LVL_1_NO, ACCT_PERD_DT, BTCH_NO, LE_NO, BTCH_TYP_CD, SYS_SRCE_CD, VL_TYPE_CD, PU_NO, PU_SEQ_NO, CT_NO, CT_TYPE_CD, WL_NO, WC_NO, SA_MP_NO, NWK_NO, SUBNWK_NO, PAY_CD, STATE_CD, UNIT_PR_NO, AES_FL, PRDR_NO, PRDR_SEQ_NO, OWN_INT_DECM_QY, UNIT_OF_MEAS_CD, SUS_RSN_CD, BTU_QY, BA_ST_CD, TRANS_AM, TRANS_QY, GR_AM, GR_QY, TXN_VAL_AM, TAX_RMB_AM, TAX_GR_RMB_AM, DED_RMB_AM, DED_GR_RMB_AM, NET_TRANSP_AM, NET_OTH_MK_AM, GR_TRANSP_AM, GR_OTH_MK_AM, PLT_VL_GRED_AM, PLT_VL_ORED_AM, MMBTU_OVL_AM, TAX_1_AM, TAX_2_AM, TAX_3_AM, TAX_4_AM, TAX_5_AM, TAX_6_AM, TAX_7_AM, TAX_8_AM, TAX_9_AM, TAX_10_AM, GR_TAX_1_AM, GR_TAX_2_AM, GR_TAX_3_AM, GR_TAX_4_AM, GR_TAX_5_AM, GR_TAX_6_AM, GR_TAX_7_AM, GR_TAX_8_AM, GR_TAX_9_AM, GR_TAX_10_AM, OTH_DED_01_AM, OTH_DED_02_AM, OTH_DED_03_AM, OTH_DED_04_AM, OTH_DED_05_AM, OTH_DED_06_AM, OTH_DED_07_AM, OTH_DED_08_AM, OTH_DED_09_AM, OTH_DED_10_AM, OTH_DED_11_AM, OTH_DED_12_AM, OTH_DED_13_AM, OTH_DED_14_AM, OTH_DED_15_AM, OTH_DED_16_AM, OTH_DED_17_AM, OTH_DED_18_AM, O_INT_1_AM, O_INT_2_AM, O_INT_3_AM, O_INT_4_AM, O_INT_5_AM, O_INT_6_AM, O_INT_7_AM, O_INT_8_AM, O_INT_9_AM, O_INT_10_AM, O_EXT_1_AM, O_EXT_2_AM, O_EXT_3_AM, O_EXT_4_AM, O_EXT_5_AM, O_EXT_6_AM, O_EXT_7_AM, O_EXT_8_AM, O_EXT_9_AM, O_EXT_10_AM, G_INT_1_AM, G_INT_2_AM, G_INT_3_AM, G_INT_4_AM, G_INT_5_AM, G_INT_6_AM, G_INT_7_AM, G_INT_8_AM, G_INT_9_AM, G_INT_10_AM, G_EXT_1_AM, G_EXT_2_AM, G_EXT_3_AM, G_EXT_4_AM, G_EXT_5_AM, G_EXT_6_AM, G_EXT_7_AM, G_EXT_8_AM, G_EXT_9_AM, G_EXT_10_AM FROM OIUE1_LSSL_SUM
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2OWN_NOOwner Numbernvarchar60CHAR(N' ')NoOIUH_OWNER Allow NULL? 
3OWN_SEQ_NOOwner Sequence Numbernvarchar20CHAR(N' ')NoOIUH_OWNER_SEQUENCE_NUMBER Allow NULL? 
4DOI_PR_NOProperty / DOInvarchar80CHAR(N' ')NoOIUH_PROPERTY_DOI Allow NULL? 
5DOI_SEQ_NODivision of Interest (DOI) Numbernvarchar50CHAR(N' ')NoOIUH_DOI_NO Allow NULL? 
6PD_CDFull three char. product code (Major and Detail Products)nvarchar30CHAR(N' ')NoOIU_FULL_PD_CD Allow NULL? 
7SA_DTSales datenvarchar80DATS(N'00000000')NoOIU_SA_DT Allow NULL? 
8O_I_TYPEOwner Interest Type Codenvarchar20CHAR(N' ')NoOIUH_OWN_INTEREST_TYPE_CODE Allow NULL? 
9O_I_SEQ_NOOwner Interest Sequence Numbernvarchar20CHAR(N' ')NoOIUH_OWN_INTEREST_SEQ_NUMBER Allow NULL? 
10ACCT_NOAccount IDnvarchar100CHAR(N' ')NoOIUH_ACCTID Allow NULL? 
11O_DECM_QYOwner Disbursement (Balance) Decimaldecimal98DEC((0))NoOIUH_OWNER_DISBUR_DECIMAL
12LGND_CDLegend Codenvarchar20CHAR(N' ')NoOIUH_LEGEND_CODE Allow NULL? 
13SYS_NOSYSTEM NUMBERdecimal180DEC((0))YesOIUH_DO_SYS_NO
14OR_LVL_1_NOCompany Name Codenvarchar30CHAR(N' ')YesOIUH_COMPANY Allow NULL? 
15ACCT_PERD_DTAccounting Period(YYYYMM01)nvarchar80CHAR(N' ')YesOIUH_ACCOUNTING_PERIOD8 Allow NULL? 
16BTCH_NOBatch IDnvarchar40CHAR(N' ')YesOIUH_BATCH_ID Allow NULL? 
17LE_NOJournal Entry Line Numbernvarchar80CHAR(N' ')YesOIUH_JELINENO Allow NULL? 
18BTCH_TYP_CDBatch Typenvarchar20CHAR(N' ')YesOIUH_BATCH_TYPE Allow NULL? 
19SYS_SRCE_CDGL Source Codenvarchar20CHAR(N' ')YesOIUREP_GL_SYS_SRCE_CD Allow NULL? 
20VL_TYPE_CDVolume Type Codenvarchar20CHAR(N' ')Yes*OIU_VL_TYPE_CD Allow NULL? 
21PU_NOPurchaser IDnvarchar60CHAR(N' ')YesOIUH_PURCHASER Allow NULL? 
22PU_SEQ_NOPurchaser Sequence Numbernvarchar20CHAR(N' ')YesOIUH_PURCHASER_SEQUENCE_NUMBER Allow NULL? 
23CT_NOContract IDnvarchar60CHAR(N' ')YesOIUH_CONTRACT_ID Allow NULL? 
24CT_TYPE_CDContract Typenvarchar20CHAR(N' ')Yes*OIU_CT_TYPE_CD Allow NULL? 
25WL_NOWell Numbernvarchar60CHAR(N' ')YesOIUH_WL_NO Allow NULL? 
26WC_NOWell Completion Numbernvarchar20CHAR(N' ')YesOIUH_WC_NO Allow NULL? 
27SA_MP_NOMeasurement Pointnvarchar60CHAR(N' ')YesOIUH_MP_NO Allow NULL? 
28NWK_NODelivery Network numbernvarchar40CHAR(N' ')YesOIUH_DN_NO Allow NULL? 
29SUBNWK_NOSubnetwork Numbernvarchar40CHAR(N' ')YesOIUH_SUBNWK_NO Allow NULL? 
30PAY_CDPay Codenvarchar20CHAR(N' ')YesOIUH_PAY_CODE Allow NULL? 
31STATE_CDState Codenvarchar20CHAR(N' ')YesOIUH_STATE_CODE Allow NULL? 
32UNIT_PR_NOUnit Property Numbernvarchar80CHAR(N' ')YesOIUH_UNIT_PROPERTY_NUMBER Allow NULL? 
33AES_FLActual / Entitled / Settlement Codechar10CHAR(N' ')YesOIU_AES_CD Allow NULL? 
34PRDR_NOProducer IDnvarchar60CHAR(N' ')YesOIUH_PRODUCER Allow NULL? 
35PRDR_SEQ_NOProducer Sequence Numbernvarchar20CHAR(N' ')YesOIUH_PRODUCER_SEQUENCE_NUMBER Allow NULL? 
36OWN_INT_DECM_QYOwner Interest Decimal Quantitydecimal98DEC((0))YesOIUH_OWN_INTEREST_DECIMAL_QTY
37UNIT_OF_MEAS_CDUnit of Measure Codenvarchar30CHAR(N' ')YesOIUH_UNIT_OF_MEASURE Allow NULL? 
38SUS_RSN_CDSuspense Reason Codenvarchar20CHAR(N' ')YesOIUH_SUSPENSE_REASON_CODE Allow NULL? 
39BTU_QYBTU Quantitydecimal73DEC((0))YesOIUH_BTU_QUANTITY
40BA_ST_CDState Codenvarchar20CHAR(N' ')YesOIUH_STATE_CODE Allow NULL? 
41TRANS_AMLSSL Summary - Amountdecimal112CURR((0))YesOIUE1_SIGNED_CURR_11_2
42TRANS_QYLSSL Summary - Quantitydecimal112DEC((0))YesOIUE1_SIGNED_DEC_11_2
43GR_AMLSSL Summary - Amountdecimal112CURR((0))YesOIUE1_SIGNED_CURR_11_2
44GR_QYLSSL Summary - Quantitydecimal112DEC((0))YesOIUE1_SIGNED_DEC_11_2
45TXN_VAL_AMLSSL Summary - Amountdecimal112CURR((0))YesOIUE1_SIGNED_CURR_11_2
46TAX_RMB_AMLSSL Summary - Amountdecimal112CURR((0))YesOIUE1_SIGNED_CURR_11_2
47TAX_GR_RMB_AMLSSL Summary - Amountdecimal112CURR((0))YesOIUE1_SIGNED_CURR_11_2
48DED_RMB_AMLSSL Summary - Amountdecimal112CURR((0))YesOIUE1_SIGNED_CURR_11_2
49DED_GR_RMB_AMLSSL Summary - Amountdecimal112CURR((0))YesOIUE1_SIGNED_CURR_11_2
50NET_TRANSP_AMLSSL Summary - Amountdecimal112CURR((0))YesOIUE1_SIGNED_CURR_11_2
51NET_OTH_MK_AMLSSL Summary - Amountdecimal112CURR((0))YesOIUE1_SIGNED_CURR_11_2
52GR_TRANSP_AMLSSL Summary - Amountdecimal112CURR((0))YesOIUE1_SIGNED_CURR_11_2
53GR_OTH_MK_AMLSSL Summary - Amountdecimal112CURR((0))YesOIUE1_SIGNED_CURR_11_2
54PLT_VL_GRED_AMLSSL Summary - Quantitydecimal112DEC((0))YesOIUE1_SIGNED_DEC_11_2
55PLT_VL_ORED_AMLSSL Summary - Quantitydecimal112DEC((0))YesOIUE1_SIGNED_DEC_11_2
56MMBTU_OVL_AMLSSL Summary - Quantitydecimal112DEC((0))YesOIUE1_SIGNED_DEC_11_2
57TAX_1_AMLSSL Summary - Tax Amountdecimal112CURR((0))YesOIUE1_TAX_AMOUNT
58TAX_2_AMLSSL Summary - Tax Amountdecimal112CURR((0))YesOIUE1_TAX_AMOUNT
59TAX_3_AMLSSL Summary - Tax Amountdecimal112CURR((0))YesOIUE1_TAX_AMOUNT
60TAX_4_AMLSSL Summary - Tax Amountdecimal112CURR((0))YesOIUE1_TAX_AMOUNT
61TAX_5_AMLSSL Summary - Tax Amountdecimal112CURR((0))YesOIUE1_TAX_AMOUNT
62TAX_6_AMLSSL Summary - Tax Amountdecimal112CURR((0))YesOIUE1_TAX_AMOUNT
63TAX_7_AMLSSL Summary - Tax Amountdecimal112CURR((0))YesOIUE1_TAX_AMOUNT
64TAX_8_AMLSSL Summary - Tax Amountdecimal112CURR((0))YesOIUE1_TAX_AMOUNT
65TAX_9_AMLSSL Summary - Tax Amountdecimal112CURR((0))YesOIUE1_TAX_AMOUNT
66TAX_10_AMLSSL Summary - Tax Amountdecimal112CURR((0))YesOIUE1_TAX_AMOUNT
67GR_TAX_1_AMLSSL Summary - Tax Amountdecimal112CURR((0))YesOIUE1_TAX_AMOUNT
68GR_TAX_2_AMLSSL Summary - Tax Amountdecimal112CURR((0))YesOIUE1_TAX_AMOUNT
69GR_TAX_3_AMLSSL Summary - Tax Amountdecimal112CURR((0))YesOIUE1_TAX_AMOUNT
70GR_TAX_4_AMLSSL Summary - Tax Amountdecimal112CURR((0))YesOIUE1_TAX_AMOUNT
71GR_TAX_5_AMLSSL Summary - Tax Amountdecimal112CURR((0))YesOIUE1_TAX_AMOUNT
72GR_TAX_6_AMLSSL Summary - Tax Amountdecimal112CURR((0))YesOIUE1_TAX_AMOUNT
73GR_TAX_7_AMLSSL Summary - Tax Amountdecimal112CURR((0))YesOIUE1_TAX_AMOUNT
74GR_TAX_8_AMLSSL Summary - Tax Amountdecimal112CURR((0))YesOIUE1_TAX_AMOUNT
75GR_TAX_9_AMLSSL Summary - Tax Amountdecimal112CURR((0))YesOIUE1_TAX_AMOUNT
76GR_TAX_10_AMLSSL Summary - Tax Amountdecimal112CURR((0))YesOIUE1_TAX_AMOUNT
77OTH_DED_01_AMLSSL Summary - Other Deduct Amountdecimal112CURR((0))YesOIUE1_OTHER_DEDUCT_AMOUNT
78OTH_DED_02_AMLSSL Summary - Other Deduct Amountdecimal112CURR((0))YesOIUE1_OTHER_DEDUCT_AMOUNT
79OTH_DED_03_AMLSSL Summary - Other Deduct Amountdecimal112CURR((0))YesOIUE1_OTHER_DEDUCT_AMOUNT
80OTH_DED_04_AMLSSL Summary - Other Deduct Amountdecimal112CURR((0))YesOIUE1_OTHER_DEDUCT_AMOUNT
81OTH_DED_05_AMLSSL Summary - Other Deduct Amountdecimal112CURR((0))YesOIUE1_OTHER_DEDUCT_AMOUNT
82OTH_DED_06_AMLSSL Summary - Other Deduct Amountdecimal112CURR((0))YesOIUE1_OTHER_DEDUCT_AMOUNT
83OTH_DED_07_AMLSSL Summary - Other Deduct Amountdecimal112CURR((0))YesOIUE1_OTHER_DEDUCT_AMOUNT
84OTH_DED_08_AMLSSL Summary - Other Deduct Amountdecimal112CURR((0))YesOIUE1_OTHER_DEDUCT_AMOUNT
85OTH_DED_09_AMLSSL Summary - Other Deduct Amountdecimal112CURR((0))YesOIUE1_OTHER_DEDUCT_AMOUNT
86OTH_DED_10_AMLSSL Summary - Other Deduct Amountdecimal112CURR((0))YesOIUE1_OTHER_DEDUCT_AMOUNT
87OTH_DED_11_AMLSSL Summary - Other Deduct Amountdecimal112CURR((0))YesOIUE1_OTHER_DEDUCT_AMOUNT
88OTH_DED_12_AMLSSL Summary - Other Deduct Amountdecimal112CURR((0))YesOIUE1_OTHER_DEDUCT_AMOUNT
89OTH_DED_13_AMLSSL Summary - Other Deduct Amountdecimal112CURR((0))YesOIUE1_OTHER_DEDUCT_AMOUNT
90OTH_DED_14_AMLSSL Summary - Other Deduct Amountdecimal112CURR((0))YesOIUE1_OTHER_DEDUCT_AMOUNT
91OTH_DED_15_AMLSSL Summary - Other Deduct Amountdecimal112CURR((0))YesOIUE1_OTHER_DEDUCT_AMOUNT
92OTH_DED_16_AMLSSL Summary - Other Deduct Amountdecimal112CURR((0))YesOIUE1_OTHER_DEDUCT_AMOUNT
93OTH_DED_17_AMLSSL Summary - Other Deduct Amountdecimal112CURR((0))YesOIUE1_OTHER_DEDUCT_AMOUNT
94OTH_DED_18_AMLSSL Summary - Other Deduct Amountdecimal112CURR((0))YesOIUE1_OTHER_DEDUCT_AMOUNT
95O_INT_1_AMOwner internal mkt amt 1decimal112CURR((0))YesOIU_O_INT_1_AM
96O_INT_2_AMOwner internal mkt amt 2decimal112CURR((0))YesOIU_O_INT_2_AM
97O_INT_3_AMOwner internal mkt amt 3decimal112CURR((0))YesOIU_O_INT_3_AM
98O_INT_4_AMOwner internal mkt amt 4decimal112CURR((0))YesOIU_O_INT_4_AM
99O_INT_5_AMOwner internal mkt amt 5decimal112CURR((0))YesOIU_O_INT_5_AM
100O_INT_6_AMOwner internal mkt amt 6decimal112CURR((0))YesOIU_O_INT_6_AM
101O_INT_7_AMOwner internal mkt amt 7decimal112CURR((0))YesOIU_O_INT_7_AM
102O_INT_8_AMOwner internal mkt amt 8decimal112CURR((0))YesOIU_O_INT_8_AM
103O_INT_9_AMOwner internal mkt amt 9decimal112CURR((0))YesOIU_O_INT_9_AM
104O_INT_10_AMOwner internal mkt amt10decimal112CURR((0))YesOIU_O_INT_10_AM
105O_EXT_1_AMOwner external mkt amt 1decimal112CURR((0))YesOIU_O_EXT_1_AM
106O_EXT_2_AMOwner external mkt amt 2decimal112CURR((0))YesOIU_O_EXT_2_AM
107O_EXT_3_AMOwner external mkt amt 3decimal112CURR((0))YesOIU_O_EXT_3_AM
108O_EXT_4_AMOwner external mkt amt 4decimal112CURR((0))YesOIU_O_EXT_4_AM
109O_EXT_5_AMOwner external mkt amt 5decimal112CURR((0))YesOIU_O_EXT_5_AM
110O_EXT_6_AMOwner external mkt amt 6decimal112CURR((0))YesOIU_O_EXT_6_AM
111O_EXT_7_AMOwner external mkt amt 7decimal112CURR((0))YesOIU_O_EXT_7_AM
112O_EXT_8_AMOwner external mkt amt 8decimal112CURR((0))YesOIU_O_EXT_8_AM
113O_EXT_9_AMOwner external mkt amt 9decimal112CURR((0))YesOIU_O_EXT_9_AM
114O_EXT_10_AMOwner external mkt amt10decimal112CURR((0))YesOIU_O_EXT_10_AM
115G_INT_1_AMGross internal mkt amt 1decimal112CURR((0))YesOIU_G_INT_1_AM
116G_INT_2_AMGross internal mkt amt 2decimal112CURR((0))YesOIU_G_INT_2_AM
117G_INT_3_AMGross internal mkt amt 3decimal112CURR((0))YesOIU_G_INT_3_AM
118G_INT_4_AMGross internal mkt amt 4decimal112CURR((0))YesOIU_G_INT_4_AM
119G_INT_5_AMGross internal mkt amt 5decimal112CURR((0))YesOIU_G_INT_5_AM
120G_INT_6_AMGross internal mkt amt 6decimal112CURR((0))YesOIU_G_INT_6_AM
121G_INT_7_AMGross internal mkt amt 7decimal112CURR((0))YesOIU_G_INT_7_AM
122G_INT_8_AMGross internal mkt amt 8decimal112CURR((0))YesOIU_G_INT_8_AM
123G_INT_9_AMGross internal mkt amt 9decimal112CURR((0))YesOIU_G_INT_9_AM
124G_INT_10_AMGross internal mkt amt10decimal112CURR((0))YesOIU_G_INT_10_AM
125G_EXT_1_AMGross external mkt amt 1decimal112CURR((0))YesOIU_G_EXT_1_AM
126G_EXT_2_AMGross external mkt amt 2decimal112CURR((0))YesOIU_G_EXT_2_AM
127G_EXT_3_AMGross external mkt amt 3decimal112CURR((0))YesOIU_G_EXT_3_AM
128G_EXT_4_AMGross external mkt amt 4decimal112CURR((0))YesOIU_G_EXT_4_AM
129G_EXT_5_AMGross external mkt amt 5decimal112CURR((0))YesOIU_G_EXT_5_AM
130G_EXT_6_AMGross external mkt amt 6decimal112CURR((0))YesOIU_G_EXT_6_AM
131G_EXT_7_AMGross external mkt amt 7decimal112CURR((0))YesOIU_G_EXT_7_AM
132G_EXT_8_AMGross external mkt amt 8decimal112CURR((0))YesOIU_G_EXT_8_AM
133G_EXT_9_AMGross external mkt amt 9decimal112CURR((0))YesOIU_G_EXT_9_AM
134G_EXT_10_AMGross external mkt amt 10decimal112CURR((0))YesOIU_G_EXT_10_AM
NamePrimaryUniqueTypeColumns
OIUE1_LSSL_SUM~0YesYesCLUSTEREDLGND_CD, O_DECM_QY, ACCT_NO, O_I_SEQ_NO, O_I_TYPE, SA_DT, PD_CD, DOI_SEQ_NO, DOI_PR_NO, OWN_SEQ_NO, OWN_NO, MANDT
OIUE1_LSSL_SUM~001NoNoNONCLUSTEREDACCT_PERD_DT, OR_LVL_1_NO, ACCT_NO, MANDT
OIUE1_LSSL_SUM~101NoNoNONCLUSTEREDOWN_SEQ_NO, OWN_NO, SA_DT, STATE_CD, MANDT
OIUE1_LSSL_SUM~201NoNoNONCLUSTEREDOWN_SEQ_NO, OWN_NO, SA_DT, BA_ST_CD, MANDT