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

147 columns | Print definition?ERP 6.0  | DOC_YEAR

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1CNVTDMS_5_WCDVLHfill hedaer for well completion4DOC_YEARMeasurement point document yearnvarchar40
2FIAPPTD_TRANSTable to store the transaction details of the CBR PT4DOC_YEARFiscal Yearnvarchar40
3FIKZD_MAT_MOVECustomizing table for material movements4DOC_YEARMaterial Document Yearnvarchar40
4OIUX8_NM_OOSHSTTax 2.0 - NM - Out-Of-Statute Transaction History66DOC_YEARDocument yearnvarchar40
5OIUX8_NM_OOSTXNTax 2.0 - NM - Out-Of-Statute Transactions66DOC_YEARDocument yearnvarchar40
6OIUX8_NM_PRDTTax 2.0 - NM - PRA Detail Transactions68DOC_YEARDocument yearnvarchar40
7OIUX8_NM_REVSTGTax 2.0 - NM - Tax Reversals (Staging)13DOC_YEARDocument yearnvarchar40
8OIUX8_NM_REVTXNTax 2.0 - NM - Tax Reversals13DOC_YEARDocument yearnvarchar40
9OIUX8_NM_TAXDTLTax 2.0 - New Mexico Tax Details3DOC_YEARDocument yearnvarchar40
10OIUX8_NM_TAXHSTTax 2.0 - NM - Tax Transaction History66DOC_YEARDocument yearnvarchar40
11OIUX8_NM_TAXSTGTax 2.0 - NM - Tax Transactions (Staging)66DOC_YEARDocument yearnvarchar40
12OIUX8_NM_TAXTXNTax 2.0 - NM - Tax Transactions66DOC_YEARDocument yearnvarchar40
13OIUY3_TX_INTSTGRoyalty 2.0 - TX GLO - Royalty Trans Interface Staging66DOC_YEARDocument yearnvarchar40
14OIUY3_TX_INTTXNRoyalty 2.0 - TX GLO/TAMU - Royalty Transaction Interface66DOC_YEARDocument yearnvarchar40
15OIUY3_TX_OOSHSTRoyalty 2.0 - TX - Out of Statute Royalty Transaction Hist63DOC_YEARDocument yearnvarchar40
16OIUY3_TX_OOSTXNRoyalty 2.0 - TX GLO - Out of Statute Royalty Transactions63DOC_YEARDocument yearnvarchar40
17OIUY3_TX_PRDTRoyalty 2.0 - TX GLO - Royalty PRA Details65DOC_YEARDocument yearnvarchar40
18OIUY3_TX_PRDTARoyalty 2.0 - TX GLO - Royalty PRA Details (Allocated)66DOC_YEARDocument yearnvarchar40
19OIUY3_TX_REVSTGRoyalty 2.0 - TX GLO - Royalty Reversals (Staging)13DOC_YEARDocument yearnvarchar40
20OIUY3_TX_REVTXNRoyalty 2.0 - TX GLO - Royalty Reversals13DOC_YEARDocument yearnvarchar40
21OIUY3_TX_ROYHSTRoyalty 2.0 - TX GLO - Royalty Transaction History63DOC_YEARDocument yearnvarchar40
22OIUY3_TX_ROYHSTARoyalty 2.0 - TX GLO - Royalty Trans History (Allocated)64DOC_YEARDocument yearnvarchar40
23OIUY3_TX_ROYSTGRoyalty 2.0 - TX GLO - Royalty Transactions (Staging)63DOC_YEARDocument yearnvarchar40
24OIUY3_TX_ROYTXNRoyalty 2.0 - TX GLO - Royalty Transactions63DOC_YEARDocument yearnvarchar40
25OIUY3_TX_ROYTXNARoyalty 2.0 - TX GLO - Royalty Transactions (Allocated)64DOC_YEARDocument yearnvarchar40
26OIUY6_WY_INTSTGRoyalty 2.0 - WY - Royalty Transaction Interface (Staging)64DOC_YEARDocument yearnvarchar40
27OIUY6_WY_INTTXNRoyalty 2.0 - WY - Royalty Transaction Interface64DOC_YEARDocument yearnvarchar40
28OIUY6_WY_OOSHSTRoyalty 2.0 - WY - Out of Statute Royalty Transaction Hist61DOC_YEARDocument yearnvarchar40
29OIUY6_WY_OOSTXNRoyalty 2.0 - WY - Out of Statute Royalty Transactions61DOC_YEARDocument yearnvarchar40
30OIUY6_WY_PRDTRoyalty 2.0 - WY - Royalty PRA Details63DOC_YEARDocument yearnvarchar40
31OIUY6_WY_PRDTARoyalty 2.0 - WY - Royalty PRA Details (Allocated)64DOC_YEARDocument yearnvarchar40
32OIUY6_WY_REVSTGRoyalty 2.0 - WY - Royalty Reversals (Staging)13DOC_YEARDocument yearnvarchar40
33OIUY6_WY_REVTXNRoyalty 2.0 - WY - Royalty Reversals13DOC_YEARDocument yearnvarchar40
34OIUY6_WY_ROYHSTRoyalty 2.0 - WY - Royalty Transaction History61DOC_YEARDocument yearnvarchar40
35OIUY6_WY_ROYHSTARoyalty 2.0 - WY - Royalty Transaction History (Allocated)62DOC_YEARDocument yearnvarchar40
36OIUY6_WY_ROYSTGRoyalty 2.0 - WY - Royalty Transactions (Staging)61DOC_YEARDocument yearnvarchar40
37OIUY6_WY_ROYTXNRoyalty 2.0 - WY - Royalty Transactions61DOC_YEARDocument yearnvarchar40
38OIUY6_WY_ROYTXNARoyalty 2.0 - WY - Royalty Transactions (Allocated)62DOC_YEARDocument yearnvarchar40
39OIU_RV_LOAD_OILValuation Load Oil Transactions15DOC_YEARDocument yearnvarchar40
40RENT_M340_ESMaintain Rented Business Offices7DOC_YEARFiscal Yearnvarchar40
TOPCheck Input
41OIUCI_DOC_CIREJContains VL/RD rejects to be reported to Check Input3DOC_YEARDocument yearnvarchar40
TOPCross-Application Components
42/OPT/S_PO_HISTVSS Staging Table: PO history9DOC_YEARMaterial Document Yearnvarchar40
TOPDistributor-Reseller-Management
43/SAPHT/DRMR3XNDRM relevant ERP Transactions6DOC_YEARTransaction Document Yearnvarchar40
TOPMedia Product Sales and Distribution
44JKSDORDERBOOKPLFGoods Movements for Return to Publisher12DOC_YEARMaterial Document Yearnvarchar40
TOPOwnership
45OIUOW_DOH_WKOwnership History Workable33DOC_YEARDocument yearnvarchar40
46OIUOW_DORHDO Owner Request History3DOC_YEARDocument yearnvarchar40
47OIUOW_DTCHDOI Transfer Change Header3DOC_YEARDocument yearnvarchar40
48OIUOW_DTCSDOI Transfer Change Select3DOC_YEARDocument yearnvarchar40
49OIUOW_DTDDOI Transfer Change Detail3DOC_YEARDocument yearnvarchar40
50OIUOW_POWOwners on Pending Requests6DOC_YEARDocument yearnvarchar40
51OIUOW_RTCHRD DOI Transfer Change Header11DOC_YEARDocument yearnvarchar40
52OIUOW_RTCH_WKRD DOI Transfer Change Header Worktable11DOC_YEARDocument yearnvarchar40
53OIUOW_RTDRD DOI Transferee Detail18DOC_YEARDocument yearnvarchar40
54OIUOW_RTD_WKRD DOI Transferee Detail Worktable18DOC_YEARDocument yearnvarchar40
TOPProduction
55OIUPR_WCDPSWell Completion Daily Pressures11DOC_YEARDocument yearnvarchar40
TOPProduction and Revenue Accounting
56OIUP_PR_WCDVLHWC Disposition Volumes Header (PDM Shadow)4DOC_YEARFiscal Yearnvarchar40
57OIUP_PR_WCTSTWell Test (PDM Shadow)4DOC_YEARDocument yearnvarchar40
58OIUT2_INT_FDNObsolete: Funds Delete Notification Control20DOC_YEARDocument yearnvarchar40
59OIUXI_INT_FDNFunds Delete Notification Control20DOC_YEARDocument yearnvarchar40
60OIU_DO_DOHOwnership History33DOC_YEARDocument yearnvarchar40
61OIU_PR_CHACDChemical Analysis Component Details3DOC_YEARDocument yearnvarchar40
62OIU_PR_CHAGPDChemical Analysis Gas Properties Details3DOC_YEARDocument yearnvarchar40
63OIU_PR_CHAHChemical Analysis Header3DOC_YEARDocument yearnvarchar40
64OIU_PR_CHALPDChemical Analysis Liquid Properties Detail3DOC_YEARDocument yearnvarchar40
65OIU_PR_TWCDVHTemporary Well Completion Volumes3DOC_YEARFiscal Yearnvarchar40
66OIU_PR_WCDVLHWell Completion Disposition Volumes Header3DOC_YEARFiscal Yearnvarchar40
67OIU_PR_WCTSTWell Test3DOC_YEARDocument yearnvarchar40
TOPRevenue
68OIURV01_RD_REPRD Generic Report3DOC_YEARDocument yearnvarchar40
69OIURV03_DOCMPXRFVL Doc to MP XRef3DOC_YEARDocument yearnvarchar40
70OIURV03_DTL_BKValuation Transactions Level 1 - Vltxns3DOC_YEARDocument yearnvarchar40
71OIURV03_DTL_ZEValuation Transactions Level 1 - Zero Volume3DOC_YEARDocument yearnvarchar40
72OIURV03_FRMHDRValuation Transaction Level 3 - Formula3DOC_YEARDocument yearnvarchar40
73OIURV03_FRMTAXValuation Transactions Level 3 - Formula Tax Detail3DOC_YEARDocument yearnvarchar40
74OIURV03_TAXDTLValuation Tax Master Detail3DOC_YEARDocument yearnvarchar40
75OIURV03_TAXEMPValuation Tax Exempt Detail3DOC_YEARDocument yearnvarchar40
76OIURV03_TAXHDRValuation Tax Header3DOC_YEARDocument yearnvarchar40
77OIURV03_TAXMKTValuation Tax Marketing Detail3DOC_YEARDocument yearnvarchar40
78OIURV03_VOLDTLValuation Transaction Level 2 -Volume3DOC_YEARDocument yearnvarchar40
TOPTax Reporting
79OIUX1_RPT_TAXHTax transaction header for reporting18DOC_YEARDocument yearnvarchar40
80OIUX1_TRN_TAXHCTax transaction header for reporting14DOC_YEARDocument yearnvarchar40
81OIUX1_TRN_TAXHLTax transaction header for reporting14DOC_YEARDocument yearnvarchar40
82OIUX3_MIG_VLDOCTax Reporting - Migration Loaded VL Docs4DOC_YEARDocument yearnvarchar40
83OIUX3_TX_REVSTGTax Reporting - Texas Tax Transaction Reversal Staging14DOC_YEARDocument yearnvarchar40
84OIUX3_TX_TAXSTGTax Reporting - Texas Tax Transaction Staging55DOC_YEARDocument yearnvarchar40
85OIUX5_OK_OOSHSTTax 2.0 - Oklahoma Out Of Statute Transactions History70DOC_YEARDocument yearnvarchar40
86OIUX5_OK_OOSTXNTax 2.0 - Oklahoma Out Of Statute Transactions70DOC_YEARDocument yearnvarchar40
87OIUX5_OK_PRDTTax 2.0 - Oklahoma PRA Detail Tax Transactions72DOC_YEARDocument yearnvarchar40
88OIUX5_OK_PRDTCTax 2.0 - Oklahoma PRA Detail Tax Transactions Multi Count74DOC_YEARDocument yearnvarchar40
89OIUX5_OK_REVSTGTax 2.0 - Oklahoma Tax Reversals Staging13DOC_YEARDocument yearnvarchar40
90OIUX5_OK_REVTXNTax 2.0 - Oklahoma Tax Reversals13DOC_YEARDocument yearnvarchar40
91OIUX5_OK_TAXHSTTax 2.0 - Oklahoma Tax Transactions History70DOC_YEARDocument yearnvarchar40
92OIUX5_OK_TAXHSTCTax 2.0 - Oklahoma Tax Transactions History Multi-Counties72DOC_YEARDocument yearnvarchar40
93OIUX5_OK_TAXSTGTax 2.0 - Oklahoma Tax Transactions Staging70DOC_YEARDocument yearnvarchar40
94OIUX5_OK_TAXTXNTax 2.0 - Oklahoma Tax Transactions70DOC_YEARDocument yearnvarchar40
95OIUX5_OK_TAXTXNCTax 2.0 - Oklahoma Tax Transactions Multiple Counties72DOC_YEARDocument yearnvarchar40
96OIUX6_WY_COOSHSTTax 2.0 - Wyoming Out Of Statute Conservation Trans Hist49DOC_YEARDocument yearnvarchar40
97OIUX6_WY_COOSTXNTax 2.0 - Wyoming Out Of Statute Conservation Transactions49DOC_YEARDocument yearnvarchar40
98OIUX6_WY_CPRDTTax 2.0 - Wyoming Conservation Tax PRA Detail Transactions51DOC_YEARDocument yearnvarchar40
99OIUX6_WY_CREVSTGTax 2.0 - Wyoming Conservation Tax Reversals Staging13DOC_YEARDocument yearnvarchar40
100OIUX6_WY_CREVTXNTax 2.0 - Wyoming Conservation Tax Reversals13DOC_YEARDocument yearnvarchar40
101OIUX6_WY_CTAXHSTTax 2.0 - Wyoming Conservation Tax Transactions History49DOC_YEARDocument yearnvarchar40
102OIUX6_WY_CTAXSTGTax 2.0 - Wyoming Conservation Tax Transactions Staging49DOC_YEARDocument yearnvarchar40
103OIUX6_WY_CTAXTXNTax 2.0 - Wyoming Conservation Tax Transactions49DOC_YEARDocument yearnvarchar40
104OIUX6_WY_GTAXSTGTax 2.0 - Wyoming Gross Prod Tax Transactions Staging64DOC_YEARDocument yearnvarchar40
105OIUX6_WY_GTAXTXNTax 2.0 - Wyoming Gross Prod Tax Transactions64DOC_YEARDocument yearnvarchar40
106OIUX6_WY_SOOSHSTTax 2.0 - Wyoming Out Of Statute Severance Trans History64DOC_YEARDocument yearnvarchar40
107OIUX6_WY_SOOSTXNTax 2.0 - Wyoming Out Of Statute Severance Transactions64DOC_YEARDocument yearnvarchar40
108OIUX6_WY_SPRDTTax 2.0 - Wyoming Severance Tax PRA Detail Transactions66DOC_YEARDocument yearnvarchar40
109OIUX6_WY_SREVSTGTax 2.0 - Wyoming Severance Tax Reversals Staging13DOC_YEARDocument yearnvarchar40
110OIUX6_WY_SREVTXNTax 2.0 - Wyoming Severance Tax Reversals13DOC_YEARDocument yearnvarchar40
111OIUX6_WY_STAXHSTTax 2.0 - Wyoming Severance Tax Transactions History64DOC_YEARDocument yearnvarchar40
112OIUX6_WY_STAXSTGTax 2.0 - Wyoming Severance Tax Transactions Staging64DOC_YEARDocument yearnvarchar40
113OIUX6_WY_STAXTXNTax 2.0 - Wyoming Severance Tax Transactions64DOC_YEARDocument yearnvarchar40
114OIUX7_WY_GTAXTax 2.0 - Wyoming Gross Prod Tax Transactions64DOC_YEARDocument yearnvarchar40
115OIUX7_WY_GTAXHSTTax 2.0 - Wyoming Gross Prod Tax Transactions History63DOC_YEARDocument yearnvarchar40
TOPValuation
116OIURV_CRH_HSTCombined Run Header History14DOC_YEARDocument yearnvarchar40
117OIURV_DOC_BCNRevenue Document Concept - Batch Control Number3DOC_YEARDocument yearnvarchar40
118OIURV_DOC_COTVL Document Chain Of Title3DOC_YEARDocument yearnvarchar40
119OIURV_DOC_CRHOil and Gas appl table3DOC_YEARDocument yearnvarchar40
120OIURV_DOC_DTL_BKValuation Transactions Level 1 - Vltxns3DOC_YEARDocument yearnvarchar40
121OIURV_DOC_DTL_RVValuation Reversal Notificaton3DOC_YEARDocument yearnvarchar40
122OIURV_DOC_DTL_ZEValuation Transactions Level 1 - Zero Volume3DOC_YEARDocument yearnvarchar40
123OIURV_DOC_FRMHDRValuation Transaction Level 3 - Formula3DOC_YEARDocument yearnvarchar40
124OIURV_DOC_FRMLAUValuation Formula Alternate Use3DOC_YEARDocument yearnvarchar40
125OIURV_DOC_FRMMKTValuation Transactions Level 3 - Marketing Detail3DOC_YEARDocument yearnvarchar40
126OIURV_DOC_FRMTAXValuation Transactions Level 3 - Formula Tax Detail3DOC_YEARDocument yearnvarchar40
127OIURV_DOC_HDRValuation Document Header3DOC_YEARDocument yearnvarchar40
128OIURV_DOC_JEINTFRevenue Document Concept - JEINTF temp table3DOC_YEARDocument yearnvarchar40
129OIURV_DOC_MMSPOPDual Accounting MMS/POP3DOC_YEARDocument yearnvarchar40
130OIURV_DOC_OOBJEOut Of Balance JEs3DOC_YEARDocument yearnvarchar40
131OIURV_DOC_RDSUMRD summary(VL interface records to RD)3DOC_YEARDocument yearnvarchar40
132OIURV_DOC_RUNTKTValuation Transaction - Run Ticket3DOC_YEARDocument yearnvarchar40
133OIURV_DOC_TAXDTLValuation Tax Master Detail3DOC_YEARDocument yearnvarchar40
134OIURV_DOC_TAXEMPValuation Tax Exempt Detail3DOC_YEARDocument yearnvarchar40
135OIURV_DOC_TAXHDRValuation Tax Header3DOC_YEARDocument yearnvarchar40
136OIURV_DOC_TAXMKTValuation Tax Marketing Detail3DOC_YEARDocument yearnvarchar40
137OIURV_DOC_VOLDTLValuation Transaction Level 2 -Volume3DOC_YEARDocument yearnvarchar40
138OIURV_DOC_VOLUNTValuation Document Concept - Volume Unit3DOC_YEARDocument yearnvarchar40
139OIURV_DUAL_COMPDual Accounting Compare3DOC_YEARDocument yearnvarchar40
140OIURV_DUAL_JEBRDual Accounting JE Backout / Rebook3DOC_YEARDocument yearnvarchar40
141OIURV_SSTDSettlement statement detail3DOC_YEARDocument yearnvarchar40
142OIURV_SSTD_MKTSettlement statement detail3DOC_YEARDocument yearnvarchar40
143OIURV_SSTD_TAXSettlement statement detail3DOC_YEARDocument yearnvarchar40
144OIUVL_SCAUDITSettlement statement batch3DOC_YEARDocument yearnvarchar40
145OIUVL_SCREJscrej3DOC_YEARDocument yearnvarchar40
146OIUVL_SSTHSettlement statement header3DOC_YEARDocument yearnvarchar40
TOPVehicle Management System
147VLCBATCHACTVELO : Variant for Action Execution in Batch80DOC_YEARMaterial Document Yearnvarchar40