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
4OIVL77Whse Journal
5OVPM154Outgoing Payments
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

121 columns | Print definition?ERP 6.0  | VL_TYPE_CD

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1OIUX8_NM_OOSHSTTax 2.0 - NM - Out-Of-Statute Transaction History12VL_TYPE_CDVolume type codenvarchar20
2OIUX8_NM_OOSTXNTax 2.0 - NM - Out-Of-Statute Transactions12VL_TYPE_CDVolume type codenvarchar20
3OIUX8_NM_PDCXRFTax 2.0 - NM - Product Code Xref3VL_TYPE_CDVolume type codenvarchar20
4OIUX8_NM_PRDTTax 2.0 - NM - PRA Detail Transactions13VL_TYPE_CDVolume type codenvarchar20
5OIUX8_NM_TAXHSTTax 2.0 - NM - Tax Transaction History12VL_TYPE_CDVolume type codenvarchar20
6OIUX8_NM_TAXSTGTax 2.0 - NM - Tax Transactions (Staging)12VL_TYPE_CDVolume type codenvarchar20
7OIUX8_NM_TAXTXNTax 2.0 - NM - Tax Transactions12VL_TYPE_CDVolume type codenvarchar20
8OIUY3_TX_INTSTGRoyalty 2.0 - TX GLO - Royalty Trans Interface Staging16VL_TYPE_CDVolume type codenvarchar20
9OIUY3_TX_INTTXNRoyalty 2.0 - TX GLO/TAMU - Royalty Transaction Interface16VL_TYPE_CDVolume type codenvarchar20
10OIUY3_TX_OOSHSTRoyalty 2.0 - TX - Out of Statute Royalty Transaction Hist12VL_TYPE_CDVolume type codenvarchar20
11OIUY3_TX_OOSTXNRoyalty 2.0 - TX GLO - Out of Statute Royalty Transactions12VL_TYPE_CDVolume type codenvarchar20
12OIUY3_TX_PRDTRoyalty 2.0 - TX GLO - Royalty PRA Details13VL_TYPE_CDVolume type codenvarchar20
13OIUY3_TX_PRDTARoyalty 2.0 - TX GLO - Royalty PRA Details (Allocated)13VL_TYPE_CDVolume type codenvarchar20
14OIUY3_TX_RDCXRFRoyalty 2.0 - TX GLO/TAMU - Royalty Disposition XRef5VL_TYPE_CDVolume type codenvarchar20
15OIUY3_TX_ROYHSTRoyalty 2.0 - TX GLO - Royalty Transaction History12VL_TYPE_CDVolume type codenvarchar20
16OIUY3_TX_ROYHSTARoyalty 2.0 - TX GLO - Royalty Trans History (Allocated)12VL_TYPE_CDVolume type codenvarchar20
17OIUY3_TX_ROYSTGRoyalty 2.0 - TX GLO - Royalty Transactions (Staging)12VL_TYPE_CDVolume type codenvarchar20
18OIUY3_TX_ROYTXNRoyalty 2.0 - TX GLO - Royalty Transactions12VL_TYPE_CDVolume type codenvarchar20
19OIUY3_TX_ROYTXNARoyalty 2.0 - TX GLO - Royalty Transactions (Allocated)12VL_TYPE_CDVolume type codenvarchar20
20OIUY6_WY_INTSTGRoyalty 2.0 - WY - Royalty Transaction Interface (Staging)16VL_TYPE_CDVolume type codenvarchar20
21OIUY6_WY_INTTXNRoyalty 2.0 - WY - Royalty Transaction Interface16VL_TYPE_CDVolume type codenvarchar20
22OIUY6_WY_OOSHSTRoyalty 2.0 - WY - Out of Statute Royalty Transaction Hist12VL_TYPE_CDVolume type codenvarchar20
23OIUY6_WY_OOSTXNRoyalty 2.0 - WY - Out of Statute Royalty Transactions12VL_TYPE_CDVolume type codenvarchar20
24OIUY6_WY_PRDTRoyalty 2.0 - WY - Royalty PRA Details13VL_TYPE_CDVolume type codenvarchar20
25OIUY6_WY_PRDTARoyalty 2.0 - WY - Royalty PRA Details (Allocated)13VL_TYPE_CDVolume type codenvarchar20
26OIUY6_WY_ROYHSTRoyalty 2.0 - WY - Royalty Transaction History12VL_TYPE_CDVolume type codenvarchar20
27OIUY6_WY_ROYHSTARoyalty 2.0 - WY - Royalty Transaction History (Allocated)12VL_TYPE_CDVolume type codenvarchar20
28OIUY6_WY_ROYSTGRoyalty 2.0 - WY - Royalty Transactions (Staging)12VL_TYPE_CDVolume type codenvarchar20
29OIUY6_WY_ROYTXNRoyalty 2.0 - WY - Royalty Transactions12VL_TYPE_CDVolume type codenvarchar20
30OIUY6_WY_ROYTXNARoyalty 2.0 - WY - Royalty Transactions (Allocated)12VL_TYPE_CDVolume type codenvarchar20
31OIU_RV_LOAD_OILValuation Load Oil Transactions13VL_TYPE_CDVolume type codenvarchar20
TOPCheck Input
32OIUCI_JEIncoming Check Journalized. Temporary hold22VL_TYPE_CDVolume Typenvarchar20
TOPCheck Write
33OIUCW_EXTDExtended Details from Payment Run19VL_TYPE_CDVolume Typenvarchar20
34OIUCW_PAYMENTPayment Details from Payment Run12VL_TYPE_CDVolume Typenvarchar20
35OIU_CW_SUM_PAYSummarized Payable Table for Check Write16VL_TYPE_CDVolume Typenvarchar20
TOPOwnership
36OIUOW_DOACCDOI Owner Override Account Codes6VL_TYPE_CDVolume type codenvarchar20
37OIUOW_DOACC_WKDOI Owner Override Account Codes Worktable6VL_TYPE_CDVolume type codenvarchar20
TOPProduction and Revenue Accounting
38OIUREP_TAXBACKUPBackup tax table for old tax reporting SOL14VL_TYPE_CDVolume type codenvarchar20
39OIUREP_TIKBACKUPBackup tik table for old tax reporting SOL14VL_TYPE_CDVolume type codenvarchar20
40OIU_CM_VLTYPGRPVolume Category Type Group3VL_TYPE_CDVolume Type Codenvarchar20
41OIU_PR_VLTCXVolume Type Xref To Volume Category1VL_TYPE_CDVolume Type Codenvarchar20
42OIU_PR_VLTYPVolume Type Table - Tblcm0101VL_TYPE_CDVolume Type Codenvarchar20
43OIU_PR_VLTYP_TXVolume Type Table - Tblcm010 - Text2VL_TYPE_CDVolume Type Codenvarchar20
44OIU_PR_VTRCLSVolume Type Gas Lift Gas Reclassification2VL_TYPE_CDVolume Type Codenvarchar20
45OIU_PR_VTXRGVOLUME TYPE XREF TO REPRODUCED GAS - TBLCM0422VL_TYPE_CDVolume Type Codenvarchar20
46OIU_RV_FRMLValuation Formula Id5VL_TYPE_CDVolume type codenvarchar20
47OIU_RV_MULT_DNMultiple DN for same well8VL_TYPE_CDVolume type codenvarchar20
TOPRevenue
48OIUE1_LSSL_SUMLegal Suspense Summary20VL_TYPE_CDVolume Type Codenvarchar20
49OIUE2_ESCH_DTLProc 2.0 - Escheat - Owner Details21VL_TYPE_CDVolume Type Codenvarchar20
50OIUE2_ESCH_DTLHProc 2.0 - Escheat - Owner Detail History21VL_TYPE_CDVolume Type Codenvarchar20
51OIUE2_ESCROW_DTLProc 2.0 - WY Escrow - Owner Details21VL_TYPE_CDVolume Type Codenvarchar20
52OIUE2_JEINTFProc 2.0 - JE Interface Table23VL_TYPE_CDVolume Typenvarchar20
53OIUH_RV_ARINTFPRA Journal Entries to A/R interface table21VL_TYPE_CDVolume Typenvarchar20
54OIUH_RV_JEINTFPRA Journal Entries22VL_TYPE_CDVolume Typenvarchar20
55OIUH_RV_TCDTax Calc Data3VL_TYPE_CDVolume type codenvarchar20
56OIURV03_DTL_ZEValuation Transactions Level 1 - Zero Volume22VL_TYPE_CDVolume type codenvarchar20
57OIURV03_VOLDTLValuation Transaction Level 2 -Volume39VL_TYPE_CDVolume type codenvarchar20
TOPRoyalty Reporting
58OIUREP_MMS_REJSMMS-2014 - Extraction Rejects95VL_TYPE_CDVolume Type Codenvarchar20
59OIUREP_RTPENDMMS-2014 - Royalty Transaction Pending94VL_TYPE_CDVolume Type Codenvarchar20
60OIUREP_RT_HISTMMS-2014 - Royalty Transaction (Pending) History94VL_TYPE_CDVolume Type Codenvarchar20
TOPTax Reporting
61OIUX1_ADJ_TAXHCTax adjustments header for reporting11VL_TYPE_CDVolume type codenvarchar20
62OIUX1_TRN_TAXHCTax transaction header for reporting12VL_TYPE_CDVolume type codenvarchar20
63OIUX1_TRN_TAXHLTax transaction header for reporting12VL_TYPE_CDVolume type codenvarchar20
64OIUX3_JEINTFTax Reporting - JE Interface Table16VL_TYPE_CDVolume Typenvarchar20
65OIUX3_TX_COMXRFTax Reporting - Texas Commodity XRef3VL_TYPE_CDVolume Type Codenvarchar20
66OIUX3_TX_OOSHSTTax Reporting - Texas Out Of Statute Transaction History12VL_TYPE_CDVolume type codenvarchar20
67OIUX3_TX_OOSTXNTax Reporting - Texas Out Of Statute Transactions12VL_TYPE_CDVolume type codenvarchar20
68OIUX3_TX_PRDTBTax Reporting - Texas PRA Detail Txns-Tier Tax Below13VL_TYPE_CDVolume type codenvarchar20
69OIUX3_TX_PRDTITax Reporting - Texas PRA Detail Txns-Tier Tax Incremental13VL_TYPE_CDVolume type codenvarchar20
70OIUX3_TX_PRDTNTax Reporting - Texas PRA Detail Txns - No Tier Tax13VL_TYPE_CDVolume type codenvarchar20
71OIUX3_TX_REVSTGTax Reporting - Texas Tax Transaction Reversal Staging12VL_TYPE_CDVolume type codenvarchar20
72OIUX3_TX_REVTXNTax Reporting - Texas Tax Transaction Reversals12VL_TYPE_CDVolume type codenvarchar20
73OIUX3_TX_TAXHSTTax Reporting - Texas Tax History Transactions12VL_TYPE_CDVolume type codenvarchar20
74OIUX3_TX_TAXSTGTax Reporting - Texas Tax Transaction Staging12VL_TYPE_CDVolume type codenvarchar20
75OIUX3_TX_TAXTXNTax Reporting - Texas Tax Transactions12VL_TYPE_CDVolume type codenvarchar20
76OIUX5_OK_OOSHSTTax 2.0 - Oklahoma Out Of Statute Transactions History12VL_TYPE_CDVolume type codenvarchar20
77OIUX5_OK_OOSTXNTax 2.0 - Oklahoma Out Of Statute Transactions12VL_TYPE_CDVolume type codenvarchar20
78OIUX5_OK_PRDTTax 2.0 - Oklahoma PRA Detail Tax Transactions13VL_TYPE_CDVolume type codenvarchar20
79OIUX5_OK_PRDTCTax 2.0 - Oklahoma PRA Detail Tax Transactions Multi Count13VL_TYPE_CDVolume type codenvarchar20
80OIUX5_OK_TAXHSTTax 2.0 - Oklahoma Tax Transactions History12VL_TYPE_CDVolume type codenvarchar20
81OIUX5_OK_TAXHSTCTax 2.0 - Oklahoma Tax Transactions History Multi-Counties12VL_TYPE_CDVolume type codenvarchar20
82OIUX5_OK_TAXSTGTax 2.0 - Oklahoma Tax Transactions Staging12VL_TYPE_CDVolume type codenvarchar20
83OIUX5_OK_TAXTXNTax 2.0 - Oklahoma Tax Transactions12VL_TYPE_CDVolume type codenvarchar20
84OIUX5_OK_TAXTXNCTax 2.0 - Oklahoma Tax Transactions Multiple Counties12VL_TYPE_CDVolume type codenvarchar20
85OIUX6_WY_COOSHSTTax 2.0 - Wyoming Out Of Statute Conservation Trans Hist12VL_TYPE_CDVolume type codenvarchar20
86OIUX6_WY_COOSTXNTax 2.0 - Wyoming Out Of Statute Conservation Transactions12VL_TYPE_CDVolume type codenvarchar20
87OIUX6_WY_CPRDTTax 2.0 - Wyoming Conservation Tax PRA Detail Transactions13VL_TYPE_CDVolume type codenvarchar20
88OIUX6_WY_CTAXHSTTax 2.0 - Wyoming Conservation Tax Transactions History12VL_TYPE_CDVolume type codenvarchar20
89OIUX6_WY_CTAXSTGTax 2.0 - Wyoming Conservation Tax Transactions Staging12VL_TYPE_CDVolume type codenvarchar20
90OIUX6_WY_CTAXTXNTax 2.0 - Wyoming Conservation Tax Transactions12VL_TYPE_CDVolume type codenvarchar20
91OIUX6_WY_GTAXSTGTax 2.0 - Wyoming Gross Prod Tax Transactions Staging12VL_TYPE_CDVolume type codenvarchar20
92OIUX6_WY_GTAXTXNTax 2.0 - Wyoming Gross Prod Tax Transactions12VL_TYPE_CDVolume type codenvarchar20
93OIUX6_WY_SOOSHSTTax 2.0 - Wyoming Out Of Statute Severance Trans History12VL_TYPE_CDVolume type codenvarchar20
94OIUX6_WY_SOOSTXNTax 2.0 - Wyoming Out Of Statute Severance Transactions12VL_TYPE_CDVolume type codenvarchar20
95OIUX6_WY_SPRDTTax 2.0 - Wyoming Severance Tax PRA Detail Transactions13VL_TYPE_CDVolume type codenvarchar20
96OIUX6_WY_STAXHSTTax 2.0 - Wyoming Severance Tax Transactions History12VL_TYPE_CDVolume type codenvarchar20
97OIUX6_WY_STAXSTGTax 2.0 - Wyoming Severance Tax Transactions Staging12VL_TYPE_CDVolume type codenvarchar20
98OIUX6_WY_STAXTXNTax 2.0 - Wyoming Severance Tax Transactions12VL_TYPE_CDVolume type codenvarchar20
99OIUX7_WY_GTAXTax 2.0 - Wyoming Gross Prod Tax Transactions13VL_TYPE_CDVolume type codenvarchar20
100OIUX7_WY_GTAXHSTTax 2.0 - Wyoming Gross Prod Tax Transactions History12VL_TYPE_CDVolume type codenvarchar20
101OIUX7_WY_GVOLTax 2.0 - WYGP Volume8VL_TYPE_CDVolume type codenvarchar20
102OIUX7_WY_GVOLHSTTax 2.0 - WYGP Volume History7VL_TYPE_CDVolume type codenvarchar20
103OIUX7_WY_GVOLTXNTax 2.0 - WYGP Volumes7VL_TYPE_CDVolume type codenvarchar20
104OIUX7_WY_PDVLXRFTax 2.0 - WYGP Product Code/Volume Type/Product Type Xref3VL_TYPE_CDVolume Type Codenvarchar20
105OIUX7_WY_VLXRFTax 2.0 - WYGP Volume Type Xref2VL_TYPE_CDVolume Type Codenvarchar20
TOPValuation
106OIURV_DOC_DTL_ZEValuation Transactions Level 1 - Zero Volume22VL_TYPE_CDVolume type codenvarchar20
107OIURV_DOC_JEINTFRevenue Document Concept - JEINTF temp table24VL_TYPE_CDVolume Typenvarchar20
108OIURV_DOC_RDSUMRD summary(VL interface records to RD)52VL_TYPE_CDVolume type codenvarchar20
109OIURV_DOC_VOLDTLValuation Transaction Level 2 -Volume39VL_TYPE_CDVolume type codenvarchar20
110OIURV_DOC_VOLUNTValuation Document Concept - Volume Unit11VL_TYPE_CDVolume type codenvarchar20
111OIURV_SSTDSettlement statement detail18VL_TYPE_CDVolume type codenvarchar20
112OIURV_TAXCONFDState tax configuration detail4VL_TYPE_CDVolume type codenvarchar20
113OIURV_TAXCONFHState tax configuration header4VL_TYPE_CDVolume type codenvarchar20
114OIURV_TCDTax calculation data6VL_TYPE_CDVolume type codenvarchar20
115OIUVL_GASDTL_CURGas statement Detail11VL_TYPE_CDVolume type codenvarchar20
116OIUVL_GASDTL_HSTGas statement Detail11VL_TYPE_CDVolume type codenvarchar20
117OIUVL_GASRPTDGas statement report detail9VL_TYPE_CDVolume type codenvarchar20
118OIUVL_OILRPTDOil statement report detail7VL_TYPE_CDVolume type codenvarchar20
119OIUVL_SCAUDITSettlement statement batch18VL_TYPE_CDVolume type codenvarchar20
120OIUVL_SEVSeverance tax4VL_TYPE_CDVolume type codenvarchar20
121OIUVL_TTVLTYTier tax volume type3VL_TYPE_CDVolume type codenvarchar20