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

76 columns | Print definition?ERP 6.0  | REV_BOOK_ADJ_IND

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1OIUX8_NM_OOSHSTTax 2.0 - NM - Out-Of-Statute Transaction History15REV_BOOK_ADJ_INDTax 2.0 - NM Reversal/Booking/Reversal Adjustment/Adjustmentnvarchar10
2OIUX8_NM_OOSTXNTax 2.0 - NM - Out-Of-Statute Transactions15REV_BOOK_ADJ_INDTax 2.0 - NM Reversal/Booking/Reversal Adjustment/Adjustmentnvarchar10
3OIUX8_NM_PRDTTax 2.0 - NM - PRA Detail Transactions16REV_BOOK_ADJ_INDTax 2.0 - NM Reversal/Booking/Reversal Adjustment/Adjustmentnvarchar10
4OIUX8_NM_RPDTTax 2.0 - NM - Report Detail12REV_BOOK_ADJ_INDTax 2.0 - NM Reversal/Booking/Reversal Adjustment/Adjustmentnvarchar10
5OIUX8_NM_RPDT_HTax 2.0 - NM Tax Report Detail - State History12REV_BOOK_ADJ_INDTax 2.0 - NM Reversal/Booking/Reversal Adjustment/Adjustmentnvarchar10
6OIUX8_NM_TAXHSTTax 2.0 - NM - Tax Transaction History15REV_BOOK_ADJ_INDTax 2.0 - NM Reversal/Booking/Reversal Adjustment/Adjustmentnvarchar10
7OIUX8_NM_TAXSTGTax 2.0 - NM - Tax Transactions (Staging)15REV_BOOK_ADJ_INDTax 2.0 - NM Reversal/Booking/Reversal Adjustment/Adjustmentnvarchar10
8OIUX8_NM_TAXTXNTax 2.0 - NM - Tax Transactions15REV_BOOK_ADJ_INDTax 2.0 - NM Reversal/Booking/Reversal Adjustment/Adjustmentnvarchar10
9OIUY3_TX_OOSHSTRoyalty 2.0 - TX - Out of Statute Royalty Transaction Hist14REV_BOOK_ADJ_INDRoyalty 2.0 - TX - Reversal/Booking/Reversal Adjustment/Adjsnvarchar10
10OIUY3_TX_OOSTXNRoyalty 2.0 - TX GLO - Out of Statute Royalty Transactions14REV_BOOK_ADJ_INDRoyalty 2.0 - TX - Reversal/Booking/Reversal Adjustment/Adjsnvarchar10
11OIUY3_TX_PRDTRoyalty 2.0 - TX GLO - Royalty PRA Details15REV_BOOK_ADJ_INDRoyalty 2.0 - TX - Reversal/Booking/Reversal Adjustment/Adjsnvarchar10
12OIUY3_TX_PRDTARoyalty 2.0 - TX GLO - Royalty PRA Details (Allocated)16REV_BOOK_ADJ_INDRoyalty 2.0 - TX - Reversal/Booking/Reversal Adjustment/Adjsnvarchar10
13OIUY3_TX_ROYHSTRoyalty 2.0 - TX GLO - Royalty Transaction History14REV_BOOK_ADJ_INDRoyalty 2.0 - TX - Reversal/Booking/Reversal Adjustment/Adjsnvarchar10
14OIUY3_TX_ROYHSTARoyalty 2.0 - TX GLO - Royalty Trans History (Allocated)15REV_BOOK_ADJ_INDRoyalty 2.0 - TX - Reversal/Booking/Reversal Adjustment/Adjsnvarchar10
15OIUY3_TX_ROYSTGRoyalty 2.0 - TX GLO - Royalty Transactions (Staging)14REV_BOOK_ADJ_INDRoyalty 2.0 - TX - Reversal/Booking/Reversal Adjustment/Adjsnvarchar10
16OIUY3_TX_ROYTXNRoyalty 2.0 - TX GLO - Royalty Transactions14REV_BOOK_ADJ_INDRoyalty 2.0 - TX - Reversal/Booking/Reversal Adjustment/Adjsnvarchar10
17OIUY3_TX_ROYTXNARoyalty 2.0 - TX GLO - Royalty Transactions (Allocated)15REV_BOOK_ADJ_INDRoyalty 2.0 - TX - Reversal/Booking/Reversal Adjustment/Adjsnvarchar10
18OIUY3_TX_RPGDTRoyalty 2.0 - TX GLO/TAMU - Gas Report10REV_BOOK_ADJ_INDRoyalty 2.0 - TX - Reversal/Booking/Reversal Adjustment/Adjsnvarchar10
19OIUY3_TX_RPODTRoyalty 2.0 - TX GLO/TAMU - Oil Report10REV_BOOK_ADJ_INDRoyalty 2.0 - TX - Reversal/Booking/Reversal Adjustment/Adjsnvarchar10
20OIUY6_WY_OOSHSTRoyalty 2.0 - WY - Out of Statute Royalty Transaction Hist14REV_BOOK_ADJ_INDRoyalty 2.0 - WY - Reversal/Booking/Reversal Adjustment/Adjsnvarchar10
21OIUY6_WY_OOSTXNRoyalty 2.0 - WY - Out of Statute Royalty Transactions14REV_BOOK_ADJ_INDRoyalty 2.0 - WY - Reversal/Booking/Reversal Adjustment/Adjsnvarchar10
22OIUY6_WY_PRDTRoyalty 2.0 - WY - Royalty PRA Details15REV_BOOK_ADJ_INDRoyalty 2.0 - WY - Reversal/Booking/Reversal Adjustment/Adjsnvarchar10
23OIUY6_WY_PRDTARoyalty 2.0 - WY - Royalty PRA Details (Allocated)16REV_BOOK_ADJ_INDRoyalty 2.0 - WY - Reversal/Booking/Reversal Adjustment/Adjsnvarchar10
24OIUY6_WY_ROYHSTRoyalty 2.0 - WY - Royalty Transaction History14REV_BOOK_ADJ_INDRoyalty 2.0 - WY - Reversal/Booking/Reversal Adjustment/Adjsnvarchar10
25OIUY6_WY_ROYHSTARoyalty 2.0 - WY - Royalty Transaction History (Allocated)15REV_BOOK_ADJ_INDRoyalty 2.0 - WY - Reversal/Booking/Reversal Adjustment/Adjsnvarchar10
26OIUY6_WY_ROYSTGRoyalty 2.0 - WY - Royalty Transactions (Staging)14REV_BOOK_ADJ_INDRoyalty 2.0 - WY - Reversal/Booking/Reversal Adjustment/Adjsnvarchar10
27OIUY6_WY_ROYTXNRoyalty 2.0 - WY - Royalty Transactions14REV_BOOK_ADJ_INDRoyalty 2.0 - WY - Reversal/Booking/Reversal Adjustment/Adjsnvarchar10
28OIUY6_WY_ROYTXNARoyalty 2.0 - WY - Royalty Transactions (Allocated)15REV_BOOK_ADJ_INDRoyalty 2.0 - WY - Reversal/Booking/Reversal Adjustment/Adjsnvarchar10
TOPTax Reporting
29OIUX3_TX_OOSHSTTax Reporting - Texas Out Of Statute Transaction History16REV_BOOK_ADJ_INDReversal/Booking/Adjustmentnvarchar10
30OIUX3_TX_OOSTXNTax Reporting - Texas Out Of Statute Transactions16REV_BOOK_ADJ_INDReversal/Booking/Adjustmentnvarchar10
31OIUX3_TX_PRDTBTax Reporting - Texas PRA Detail Txns-Tier Tax Below16REV_BOOK_ADJ_INDReversal/Booking/Adjustmentnvarchar10
32OIUX3_TX_PRDTITax Reporting - Texas PRA Detail Txns-Tier Tax Incremental16REV_BOOK_ADJ_INDReversal/Booking/Adjustmentnvarchar10
33OIUX3_TX_PRDTNTax Reporting - Texas PRA Detail Txns - No Tier Tax16REV_BOOK_ADJ_INDReversal/Booking/Adjustmentnvarchar10
34OIUX3_TX_TAXHSTTax Reporting - Texas Tax History Transactions16REV_BOOK_ADJ_INDReversal/Booking/Adjustmentnvarchar10
35OIUX3_TX_TAXSTGTax Reporting - Texas Tax Transaction Staging16REV_BOOK_ADJ_INDReversal/Booking/Adjustmentnvarchar10
36OIUX3_TX_TAXTXNTax Reporting - Texas Tax Transactions16REV_BOOK_ADJ_INDReversal/Booking/Adjustmentnvarchar10
37OIUX5_OK_OOSHSTTax 2.0 - Oklahoma Out Of Statute Transactions History14REV_BOOK_ADJ_INDTax 2.0 - Reversal/Booking/Reversal Adjustment/Adjustmentnvarchar10
38OIUX5_OK_OOSTXNTax 2.0 - Oklahoma Out Of Statute Transactions14REV_BOOK_ADJ_INDTax 2.0 - Reversal/Booking/Reversal Adjustment/Adjustmentnvarchar10
39OIUX5_OK_PRDTTax 2.0 - Oklahoma PRA Detail Tax Transactions15REV_BOOK_ADJ_INDTax 2.0 - Reversal/Booking/Reversal Adjustment/Adjustmentnvarchar10
40OIUX5_OK_PRDTCTax 2.0 - Oklahoma PRA Detail Tax Transactions Multi Count15REV_BOOK_ADJ_INDTax 2.0 - Reversal/Booking/Reversal Adjustment/Adjustmentnvarchar10
41OIUX5_OK_RPDTTax 2.0 - Oklahoma Gross Prod Report Detail14REV_BOOK_ADJ_INDTax 2.0 - Reversal/Booking/Reversal Adjustment/Adjustmentnvarchar10
42OIUX5_OK_TAXHSTTax 2.0 - Oklahoma Tax Transactions History14REV_BOOK_ADJ_INDTax 2.0 - Reversal/Booking/Reversal Adjustment/Adjustmentnvarchar10
43OIUX5_OK_TAXHSTCTax 2.0 - Oklahoma Tax Transactions History Multi-Counties14REV_BOOK_ADJ_INDTax 2.0 - Reversal/Booking/Reversal Adjustment/Adjustmentnvarchar10
44OIUX5_OK_TAXSTGTax 2.0 - Oklahoma Tax Transactions Staging14REV_BOOK_ADJ_INDTax 2.0 - Reversal/Booking/Reversal Adjustment/Adjustmentnvarchar10
45OIUX5_OK_TAXTXNTax 2.0 - Oklahoma Tax Transactions14REV_BOOK_ADJ_INDTax 2.0 - Reversal/Booking/Reversal Adjustment/Adjustmentnvarchar10
46OIUX5_OK_TAXTXNCTax 2.0 - Oklahoma Tax Transactions Multiple Counties14REV_BOOK_ADJ_INDTax 2.0 - Reversal/Booking/Reversal Adjustment/Adjustmentnvarchar10
47OIUX6_WY_COOSHSTTax 2.0 - Wyoming Out Of Statute Conservation Trans Hist14REV_BOOK_ADJ_INDTax 2.0 - Reversal/Booking/Reversal Adjustment/Adjustmentnvarchar10
48OIUX6_WY_COOSTXNTax 2.0 - Wyoming Out Of Statute Conservation Transactions14REV_BOOK_ADJ_INDTax 2.0 - Reversal/Booking/Reversal Adjustment/Adjustmentnvarchar10
49OIUX6_WY_CPRDTTax 2.0 - Wyoming Conservation Tax PRA Detail Transactions15REV_BOOK_ADJ_INDTax 2.0 - Reversal/Booking/Reversal Adjustment/Adjustmentnvarchar10
50OIUX6_WY_CRPDTTax 2.0 - Wyoming Conservation Tax Report Detail9REV_BOOK_ADJ_INDTax 2.0 - Reversal/Booking/Reversal Adjustment/Adjustmentnvarchar10
51OIUX6_WY_CRPDTDTTax 2.0 - Wyoming Conservation Tax Report Detail Detail7REV_BOOK_ADJ_INDTax 2.0 - Reversal/Booking/Reversal Adjustment/Adjustmentnvarchar10
52OIUX6_WY_CTAXHSTTax 2.0 - Wyoming Conservation Tax Transactions History14REV_BOOK_ADJ_INDTax 2.0 - Reversal/Booking/Reversal Adjustment/Adjustmentnvarchar10
53OIUX6_WY_CTAXSTGTax 2.0 - Wyoming Conservation Tax Transactions Staging14REV_BOOK_ADJ_INDTax 2.0 - Reversal/Booking/Reversal Adjustment/Adjustmentnvarchar10
54OIUX6_WY_CTAXTXNTax 2.0 - Wyoming Conservation Tax Transactions14REV_BOOK_ADJ_INDTax 2.0 - Reversal/Booking/Reversal Adjustment/Adjustmentnvarchar10
55OIUX6_WY_GTAXSTGTax 2.0 - Wyoming Gross Prod Tax Transactions Staging14REV_BOOK_ADJ_INDTax 2.0 - Reversal/Booking/Reversal Adjustment/Adjustmentnvarchar10
56OIUX6_WY_GTAXTXNTax 2.0 - Wyoming Gross Prod Tax Transactions14REV_BOOK_ADJ_INDTax 2.0 - Reversal/Booking/Reversal Adjustment/Adjustmentnvarchar10
57OIUX6_WY_SOOSHSTTax 2.0 - Wyoming Out Of Statute Severance Trans History14REV_BOOK_ADJ_INDTax 2.0 - Reversal/Booking/Reversal Adjustment/Adjustmentnvarchar10
58OIUX6_WY_SOOSTXNTax 2.0 - Wyoming Out Of Statute Severance Transactions14REV_BOOK_ADJ_INDTax 2.0 - Reversal/Booking/Reversal Adjustment/Adjustmentnvarchar10
59OIUX6_WY_SPRDTTax 2.0 - Wyoming Severance Tax PRA Detail Transactions15REV_BOOK_ADJ_INDTax 2.0 - Reversal/Booking/Reversal Adjustment/Adjustmentnvarchar10
60OIUX6_WY_STAXHSTTax 2.0 - Wyoming Severance Tax Transactions History14REV_BOOK_ADJ_INDTax 2.0 - Reversal/Booking/Reversal Adjustment/Adjustmentnvarchar10
61OIUX6_WY_STAXSTGTax 2.0 - Wyoming Severance Tax Transactions Staging14REV_BOOK_ADJ_INDTax 2.0 - Reversal/Booking/Reversal Adjustment/Adjustmentnvarchar10
62OIUX6_WY_STAXTXNTax 2.0 - Wyoming Severance Tax Transactions14REV_BOOK_ADJ_INDTax 2.0 - Reversal/Booking/Reversal Adjustment/Adjustmentnvarchar10
63OIUX7_WY_4101Tax 2.0 - WYGP 41017REV_BOOK_ADJ_INDTax 2.0 - Reversal/Booking/Reversal Adjustment/Adjustmentnvarchar10
64OIUX7_WY_4101HSTTax 2.0 - WYGP 4101 Up To Date History6REV_BOOK_ADJ_INDTax 2.0 - Reversal/Booking/Reversal Adjustment/Adjustmentnvarchar10
65OIUX7_WY_4111Tax 2.0 - WYGP 41119REV_BOOK_ADJ_INDTax 2.0 - Reversal/Booking/Reversal Adjustment/Adjustmentnvarchar10
66OIUX7_WY_4111HSTTax 2.0 - WYGP 4111 Up To Date History8REV_BOOK_ADJ_INDTax 2.0 - Reversal/Booking/Reversal Adjustment/Adjustmentnvarchar10
67OIUX7_WY_4121Tax 2.0 - WYGP 41218REV_BOOK_ADJ_INDTax 2.0 - Reversal/Booking/Reversal Adjustment/Adjustmentnvarchar10
68OIUX7_WY_4121HSTTax 2.0 - WYGP 4121 Up To Date History7REV_BOOK_ADJ_INDTax 2.0 - Reversal/Booking/Reversal Adjustment/Adjustmentnvarchar10
69OIUX7_WY_4201Tax 2.0 - WYGP 42017REV_BOOK_ADJ_INDTax 2.0 - Reversal/Booking/Reversal Adjustment/Adjustmentnvarchar10
70OIUX7_WY_4201HSTTax 2.0 - WYGP 4201 Up To Date History6REV_BOOK_ADJ_INDTax 2.0 - Reversal/Booking/Reversal Adjustment/Adjustmentnvarchar10
71OIUX7_WY_4211Tax 2.0 - WYGP 42119REV_BOOK_ADJ_INDTax 2.0 - Reversal/Booking/Reversal Adjustment/Adjustmentnvarchar10
72OIUX7_WY_4211HSTTax 2.0 - WYGP 4211 Up To Date History8REV_BOOK_ADJ_INDTax 2.0 - Reversal/Booking/Reversal Adjustment/Adjustmentnvarchar10
73OIUX7_WY_4221Tax 2.0 - WYGP 42218REV_BOOK_ADJ_INDTax 2.0 - Reversal/Booking/Reversal Adjustment/Adjustmentnvarchar10
74OIUX7_WY_4221HSTTax 2.0 - WYGP 4221 Up To Date History7REV_BOOK_ADJ_INDTax 2.0 - Reversal/Booking/Reversal Adjustment/Adjustmentnvarchar10
75OIUX7_WY_4231Tax 2.0 - WYGP 42317REV_BOOK_ADJ_INDTax 2.0 - Reversal/Booking/Reversal Adjustment/Adjustmentnvarchar10
76OIUX7_WY_4231HSTTax 2.0 - WYGP 4231 Up To Date History6REV_BOOK_ADJ_INDTax 2.0 - Reversal/Booking/Reversal Adjustment/Adjustmentnvarchar10