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 :: Check Write
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0OIUCW_PAYMENT1411Payment Details from Payment RunCheck Write
SQL:  selectupdate insert create

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

SELECT MANDT, RUN_ID, RUN_DATE, OWN_NO, OWN_SEQ_NO, LINE_NO, ORG_LVL_1, TRACE_CO_NO, BTCH_TYPE_CD, ACCT_NO, PD_CD, VL_TYPE_CD, VL_CLASS_CD, VL_SRCE_CD, VL_FRQ_CD, MMBTU_DET_CD, SA_DT, STATE_CD, PAY_CD, LGND_CD, PU_NO, PU_SEQ_NO, PRDR_NO, PRDR_SEQ_NO, OWN_BAL_DECM_QY, OWN_INT_DECM_QY, OWN_INT_TYPE_CD, OWN_INT_SEQ_NO, UNIT_OF_MEAS_CD, SUS_RSN_CD, CT_NO, CT_TYPE_CD, DOI_PR_NO, DOI_SEQ_NO, SECT_PR_NO, SECT_SEQ_NO, UNIT_PR_NO, NWK_NO, SUBNWK_NO, SA_MP_NO, WL_NO, WC_NO, PHASE_NO, TRANS_AM, TRANS_QY, GR_AM, GR_QY, DED_RMB_AM, DED_GR_RMB_AM, TAX_CD, 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, TAX_RMB_AM, TAX_GR_RMB_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, NET_TRANSP_AM, NET_OTH_MK_AM, GR_TRANSP_AM, GR_OTH_MK_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, TXN_VAL_AM, PLT_VL_GRED_AM, PLT_VL_ORED_AM, MMBTU_OVL_AM, MMBTU_GRVL_AM, PLT_PTR_GRED_AM, PLT_PTR_ORED_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 OIUCW_PAYMENT
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')No*MANDT Allow NULL? 
2RUN_IDRun IDnvarchar100CHAR(N' ')NoOIUCW_RUN_PARMSOIUCW_RUN_ID Allow NULL? 
3RUN_DATERun Datenvarchar80DATS(N'00000000')NoOIUCW_RUN_DATE Allow NULL? 
4OWN_NOOwner (Business Associate)nvarchar60CHAR(N' ')NoOIUH_OWN Allow NULL? 
5OWN_SEQ_NOBusiness Associate Sequence Nr.nvarchar20CHAR(N' ')NoOIUH_BASEQNR Allow NULL? 
6LINE_NOLine Numbernvarchar80NUMC(N'00000000')NoOIUCW_LINE_NO Allow NULL? 
7ORG_LVL_1Organization level 1 number (Company Code)nvarchar30CHAR(N' ')Yes*OIUH_OR_LVL_1_NO Allow NULL? 
8TRACE_CO_NOOrganization level 1 number (Company Code)nvarchar30CHAR(N' ')Yes*OIUH_OR_LVL_1_NO Allow NULL? 
9BTCH_TYPE_CDBatch Typenvarchar20CHAR(N' ')YesOIUH_BATCH_TYPE Allow NULL? 
10ACCT_NOAccount IDnvarchar100CHAR(N' ')YesOIUH_ACCTID Allow NULL? 
11PD_CDProduct Codenvarchar30CHAR(N' ')YesOIUH_PRODUCT_CODE Allow NULL? 
12VL_TYPE_CDVolume Typenvarchar20CHAR(N' ')YesOIUH_VOLTYPE Allow NULL? 
13VL_CLASS_CDVolume Class Codechar10CHAR(N' ')YesOIUH_VOL_CLASS_CODE Allow NULL? 
14VL_SRCE_CDVolume source codechar10CHAR(N' ')YesOIUH_VOL_SOURCE_CODE Allow NULL? 
15VL_FRQ_CDVolume Frequency codechar10CHAR(N' ')YesOIUH_VOL_FREQUENCY_CODE Allow NULL? 
16MMBTU_DET_CDMMBTU Determination Codechar10CHAR(N' ')YesOIUH_MMBTU_DET_CODE Allow NULL? 
17SA_DTDate of Char type for compatabiliy with dats stored as Charnvarchar80CHAR(N' ')YesOIUCW_CHARDATE Allow NULL? 
18STATE_CDState Codenvarchar20CHAR(N' ')YesOIUH_STATE_CODE Allow NULL? 
19PAY_CDPay Codenvarchar20CHAR(N' ')YesOIUH_PAY_CODE Allow NULL? 
20LGND_CDLegend Codenvarchar20CHAR(N' ')YesOIUH_LEGEND_CODE Allow NULL? 
21PU_NOPurchaser Numbernvarchar60CHAR(N' ')YesOIUH_PU_NO Allow NULL? 
22PU_SEQ_NOPurchaser Sequence Numbernvarchar20CHAR(N' ')YesOIUH_PURCHASER_SEQUENCE_NUMBER Allow NULL? 
23PRDR_NOProducer IDnvarchar60CHAR(N' ')YesOIUH_PRODUCER Allow NULL? 
24PRDR_SEQ_NOProducer Sequence Numbernvarchar20CHAR(N' ')YesOIUH_PRODUCER_SEQUENCE_NUMBER Allow NULL? 
25OWN_BAL_DECM_QYOwner Disbursement (Balance) Decimaldecimal98DEC((0))YesOIUH_OWNER_DISBUR_DECIMAL
26OWN_INT_DECM_QYOwner Interest Decimal Quantitydecimal98DEC((0))YesOIUH_OWN_INTEREST_DECIMAL_QTY
27OWN_INT_TYPE_CDOwner Interest Type Codenvarchar20CHAR(N' ')YesOIUH_OWN_INTEREST_TYPE_CODE Allow NULL? 
28OWN_INT_SEQ_NOOwner Interest Sequence Numbernvarchar20CHAR(N' ')YesOIUH_OWN_INTEREST_SEQ_NUMBER Allow NULL? 
29UNIT_OF_MEAS_CDUnit of Measure Codenvarchar30CHAR(N' ')YesOIUH_UNIT_OF_MEASURE Allow NULL? 
30SUS_RSN_CDSuspense Reason Codenvarchar20CHAR(N' ')YesOIUH_SUSPENSE_REASON_CODE Allow NULL? 
31CT_NOContract IDnvarchar60CHAR(N' ')YesOIUH_CONTRACT_ID Allow NULL? 
32CT_TYPE_CDContract Type codenvarchar20CHAR(N' ')YesOIUH_CONTRACT_TYPE_CODE Allow NULL? 
33DOI_PR_NOPropertynvarchar80CHAR(N' ')YesOIUH_PR_NO Allow NULL? 
34DOI_SEQ_NODivision of Interest (DOI) Numbernvarchar50CHAR(N' ')YesOIUH_DOI_NO Allow NULL? 
35SECT_PR_NOSection Property Numbernvarchar80CHAR(N' ')YesOIUH_SECTION_PROP_NUMBER Allow NULL? 
36SECT_SEQ_NOSection Sequence Numbernvarchar50CHAR(N' ')YesOIUH_SECTION_SEQ_NUMBER Allow NULL? 
37UNIT_PR_NOUnit Property Numbernvarchar80CHAR(N' ')YesOIUH_UNIT_PROPERTY_NUMBER Allow NULL? 
38NWK_NODelivery Network numbernvarchar40CHAR(N' ')YesOIUH_DN_NO Allow NULL? 
39SUBNWK_NOSubnetwork Numbernvarchar40CHAR(N' ')YesOIUH_SUBNWK_NO Allow NULL? 
40SA_MP_NOSales Measurement Point Numbernvarchar60CHAR(N' ')YesOIUH_SALES_MP_NUMBER Allow NULL? 
41WL_NOWell ID Numbernvarchar60CHAR(N' ')YesOIUH_WELL_NO Allow NULL? 
42WC_NOWell Completion IDnvarchar20CHAR(N' ')YesOIUH_WELL_COMPLETION_ID Allow NULL? 
43PHASE_NOPhase numberchar10CHAR(N' ')YesOIUVL_PHASE_NO Allow NULL? 
44TRANS_AMJE Transaction Amountdecimal112CURR((0))YesOIUH_TRANS_AMT
45TRANS_QYJE Transaction Quantitydecimal112DEC((0))YesOIUH_TRANS_QUANTITY
46GR_AMGross Amount (Value)decimal112CURR((0))YesOIUH_GROSS_AMOUNT
47GR_QYGross Quantitydecimal112DEC((0))YesOIUH_GROSS_QTY
48DED_RMB_AMDeduction/Reimbursement Amountdecimal112CURR((0))YesOIUH_DED_REIMB_AMOUNT
49DED_GR_RMB_AMGross Deduction/Reimbursement amountdecimal112CURR((0))YesOIUH_DED_GR_REIMB_AMOUNT
50TAX_CDTax Codenvarchar20CHAR(N' ')YesOIUH_TAX_CODE Allow NULL? 
51TAX_1_AMTax amountdecimal112CURR((0))YesOIUH_TAX_AMOUNT
52TAX_2_AMTax amountdecimal112CURR((0))YesOIUH_TAX_AMOUNT
53TAX_3_AMTax amountdecimal112CURR((0))YesOIUH_TAX_AMOUNT
54TAX_4_AMTax amountdecimal112CURR((0))YesOIUH_TAX_AMOUNT
55TAX_5_AMTax amountdecimal112CURR((0))YesOIUH_TAX_AMOUNT
56TAX_6_AMTax amountdecimal112CURR((0))YesOIUH_TAX_AMOUNT
57TAX_7_AMTax amountdecimal112CURR((0))YesOIUH_TAX_AMOUNT
58TAX_8_AMTax amountdecimal112CURR((0))YesOIUH_TAX_AMOUNT
59TAX_9_AMTax amountdecimal112CURR((0))YesOIUH_TAX_AMOUNT
60TAX_10_AMTax amountdecimal112CURR((0))YesOIUH_TAX_AMOUNT
61TAX_RMB_AMTax Reimbursement Amountdecimal112CURR((0))YesOIUH_TAX_REIMBURSEMENT_AMT
62TAX_GR_RMB_AMGross Tax Reimbursement Amountdecimal112CURR((0))YesOIUH_GROSS_TAX_REIMB_AMT
63GR_TAX_1_AMGross Tax Amountdecimal132CURR((0))YesOIUH_GROSS_TAX_AMOUNT
64GR_TAX_2_AMGross Tax Amountdecimal132CURR((0))YesOIUH_GROSS_TAX_AMOUNT
65GR_TAX_3_AMGross Tax Amountdecimal132CURR((0))YesOIUH_GROSS_TAX_AMOUNT
66GR_TAX_4_AMGross Tax Amountdecimal132CURR((0))YesOIUH_GROSS_TAX_AMOUNT
67GR_TAX_5_AMGross Tax Amountdecimal132CURR((0))YesOIUH_GROSS_TAX_AMOUNT
68GR_TAX_6_AMGross Tax Amountdecimal132CURR((0))YesOIUH_GROSS_TAX_AMOUNT
69GR_TAX_7_AMGross Tax Amountdecimal132CURR((0))YesOIUH_GROSS_TAX_AMOUNT
70GR_TAX_8_AMGross Tax Amountdecimal132CURR((0))YesOIUH_GROSS_TAX_AMOUNT
71GR_TAX_9_AMGross Tax Amountdecimal132CURR((0))YesOIUH_GROSS_TAX_AMOUNT
72GR_TAX_10_AMGross Tax Amountdecimal132CURR((0))YesOIUH_GROSS_TAX_AMOUNT
73NET_TRANSP_AMNet Transportation Amountdecimal112CURR((0))YesOIUH_TRANSPORTATION_AMT
74NET_OTH_MK_AMNet Other Marketing Amountdecimal112CURR((0))YesOIUH_NET_OTH_MARKETING_AMOUNT
75GR_TRANSP_AMGross Transportation Amountdecimal112CURR((0))YesOIUH_GROSS_TRANP_AMOUNT
76GR_OTH_MK_AMGross Other Marketing Amountdecimal112CURR((0))YesOIUH_GROSS_OTH_MARKETING_AMT
77OTH_DED_01_AMOther Deductions Amountdecimal112CURR((0))YesOIUH_OTHER_DEDUCTION_AMOUNT
78OTH_DED_02_AMOther Deductions Amountdecimal112CURR((0))YesOIUH_OTHER_DEDUCTION_AMOUNT
79OTH_DED_03_AMOther Deductions Amountdecimal112CURR((0))YesOIUH_OTHER_DEDUCTION_AMOUNT
80OTH_DED_04_AMOther Deductions Amountdecimal112CURR((0))YesOIUH_OTHER_DEDUCTION_AMOUNT
81OTH_DED_05_AMOther Deductions Amountdecimal112CURR((0))YesOIUH_OTHER_DEDUCTION_AMOUNT
82OTH_DED_06_AMOther Deductions Amountdecimal112CURR((0))YesOIUH_OTHER_DEDUCTION_AMOUNT
83OTH_DED_07_AMOther Deductions Amountdecimal112CURR((0))YesOIUH_OTHER_DEDUCTION_AMOUNT
84OTH_DED_08_AMOther Deductions Amountdecimal112CURR((0))YesOIUH_OTHER_DEDUCTION_AMOUNT
85OTH_DED_09_AMOther Deductions Amountdecimal112CURR((0))YesOIUH_OTHER_DEDUCTION_AMOUNT
86OTH_DED_10_AMOther Deductions Amountdecimal112CURR((0))YesOIUH_OTHER_DEDUCTION_AMOUNT
87OTH_DED_11_AMOther Deductions Amountdecimal112CURR((0))YesOIUH_OTHER_DEDUCTION_AMOUNT
88OTH_DED_12_AMOther Deductions Amountdecimal112CURR((0))YesOIUH_OTHER_DEDUCTION_AMOUNT
89OTH_DED_13_AMOther Deductions Amountdecimal112CURR((0))YesOIUH_OTHER_DEDUCTION_AMOUNT
90OTH_DED_14_AMOther Deductions Amountdecimal112CURR((0))YesOIUH_OTHER_DEDUCTION_AMOUNT
91OTH_DED_15_AMOther Deductions Amountdecimal112CURR((0))YesOIUH_OTHER_DEDUCTION_AMOUNT
92OTH_DED_16_AMOther Deductions Amountdecimal112CURR((0))YesOIUH_OTHER_DEDUCTION_AMOUNT
93OTH_DED_17_AMOther Deductions Amountdecimal112CURR((0))YesOIUH_OTHER_DEDUCTION_AMOUNT
94OTH_DED_18_AMOther Deductions Amountdecimal112CURR((0))YesOIUH_OTHER_DEDUCTION_AMOUNT
95TXN_VAL_AMTransaction Owner Amountdecimal112CURR((0))YesOIUH_TRAN_OWNER_AMOUNT
96PLT_VL_GRED_AMGross Plant Volume Reduction amountdecimal112DEC((0))YesOIUH_GROSS_PLANT_VOLUME_RED_AM
97PLT_VL_ORED_AMOwner Plant Volume Reduction amountdecimal112DEC((0))YesOIUH_OWNER_PLANT_VOLUME_RED_AM
98MMBTU_OVL_AMOwner MMBTUdecimal112DEC((0))YesOIUH_OWNER_MMBTU
99MMBTU_GRVL_AMMMBTU Gross Volumedecimal112DEC((0))YesOIUH_MMBTU
100PLT_PTR_GRED_AMGross Plant Thermal Reduction amountdecimal112DEC((0))YesOIUH_GR_PLANT_THERMAL_RED
101PLT_PTR_ORED_AMOwner Plant Thermal Reduction amountdecimal112DEC((0))YesOIUH_OWN_PLANT_THERMAL_RED
102O_INT_1_AMOwner internal mkt amt 1decimal112CURR((0))YesOIU_O_INT_1_AM
103O_INT_2_AMOwner internal mkt amt 2decimal112CURR((0))YesOIU_O_INT_2_AM
104O_INT_3_AMOwner internal mkt amt 3decimal112CURR((0))YesOIU_O_INT_3_AM
105O_INT_4_AMOwner internal mkt amt 4decimal112CURR((0))YesOIU_O_INT_4_AM
106O_INT_5_AMOwner internal mkt amt 5decimal112CURR((0))YesOIU_O_INT_5_AM
107O_INT_6_AMOwner internal mkt amt 6decimal112CURR((0))YesOIU_O_INT_6_AM
108O_INT_7_AMOwner internal mkt amt 7decimal112CURR((0))YesOIU_O_INT_7_AM
109O_INT_8_AMOwner internal mkt amt 8decimal112CURR((0))YesOIU_O_INT_8_AM
110O_INT_9_AMOwner internal mkt amt 9decimal112CURR((0))YesOIU_O_INT_9_AM
111O_INT_10_AMOwner internal mkt amt10decimal112CURR((0))YesOIU_O_INT_10_AM
112O_EXT_1_AMOwner external mkt amt 1decimal112CURR((0))YesOIU_O_EXT_1_AM
113O_EXT_2_AMOwner external mkt amt 2decimal112CURR((0))YesOIU_O_EXT_2_AM
114O_EXT_3_AMOwner external mkt amt 3decimal112CURR((0))YesOIU_O_EXT_3_AM
115O_EXT_4_AMOwner external mkt amt 4decimal112CURR((0))YesOIU_O_EXT_4_AM
116O_EXT_5_AMOwner external mkt amt 5decimal112CURR((0))YesOIU_O_EXT_5_AM
117O_EXT_6_AMOwner external mkt amt 6decimal112CURR((0))YesOIU_O_EXT_6_AM
118O_EXT_7_AMOwner external mkt amt 7decimal112CURR((0))YesOIU_O_EXT_7_AM
119O_EXT_8_AMOwner external mkt amt 8decimal112CURR((0))YesOIU_O_EXT_8_AM
120O_EXT_9_AMOwner external mkt amt 9decimal112CURR((0))YesOIU_O_EXT_9_AM
121O_EXT_10_AMOwner external mkt amt10decimal112CURR((0))YesOIU_O_EXT_10_AM
122G_INT_1_AMGross internal mkt amt 1decimal112CURR((0))YesOIU_G_INT_1_AM
123G_INT_2_AMGross internal mkt amt 2decimal112CURR((0))YesOIU_G_INT_2_AM
124G_INT_3_AMGross internal mkt amt 3decimal112CURR((0))YesOIU_G_INT_3_AM
125G_INT_4_AMGross internal mkt amt 4decimal112CURR((0))YesOIU_G_INT_4_AM
126G_INT_5_AMGross internal mkt amt 5decimal112CURR((0))YesOIU_G_INT_5_AM
127G_INT_6_AMGross internal mkt amt 6decimal112CURR((0))YesOIU_G_INT_6_AM
128G_INT_7_AMGross internal mkt amt 7decimal112CURR((0))YesOIU_G_INT_7_AM
129G_INT_8_AMGross internal mkt amt 8decimal112CURR((0))YesOIU_G_INT_8_AM
130G_INT_9_AMGross internal mkt amt 9decimal112CURR((0))YesOIU_G_INT_9_AM
131G_INT_10_AMGross internal mkt amt10decimal112CURR((0))YesOIU_G_INT_10_AM
132G_EXT_1_AMGross external mkt amt 1decimal112CURR((0))YesOIU_G_EXT_1_AM
133G_EXT_2_AMGross external mkt amt 2decimal112CURR((0))YesOIU_G_EXT_2_AM
134G_EXT_3_AMGross external mkt amt 3decimal112CURR((0))YesOIU_G_EXT_3_AM
135G_EXT_4_AMGross external mkt amt 4decimal112CURR((0))YesOIU_G_EXT_4_AM
136G_EXT_5_AMGross external mkt amt 5decimal112CURR((0))YesOIU_G_EXT_5_AM
137G_EXT_6_AMGross external mkt amt 6decimal112CURR((0))YesOIU_G_EXT_6_AM
138G_EXT_7_AMGross external mkt amt 7decimal112CURR((0))YesOIU_G_EXT_7_AM
139G_EXT_8_AMGross external mkt amt 8decimal112CURR((0))YesOIU_G_EXT_8_AM
140G_EXT_9_AMGross external mkt amt 9decimal112CURR((0))YesOIU_G_EXT_9_AM
141G_EXT_10_AMGross external mkt amt 10decimal112CURR((0))YesOIU_G_EXT_10_AM
NamePrimaryUniqueTypeColumns
OIUCW_PAYMENT~0YesYesCLUSTEREDLINE_NO, OWN_SEQ_NO, OWN_NO, RUN_DATE, RUN_ID, MANDT