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

38 columns | Print definition?ERP 6.0  | POS_NO

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1OIUX8_NM_TAXDTLTax 2.0 - New Mexico Tax Details5POS_NOPosition Number fornvarchar100
TOPAccounting Interface
2GLE_ECS_BAL_ITEMGL open items that are not in ECS6POS_NONumber of Line Item Within Accounting Documentnvarchar30
3GLE_ECS_ITEMECS: Error Correction Items9POS_NONumber of Line Item Within Accounting Documentnvarchar30
TOPBack Office
4TRET_PROTOCOLTransactions Generated for Endowments4POS_NOItem Numbernvarchar80
5TRET_TRANSACTIONTransactions to Be Created for Endowments4POS_NOItem Numbernvarchar80
TOPBasic Functions
6ETXDCIExternal tax document: line item info7POS_NOTax document item numbernvarchar60
7TTXYExternal tax interface: tax information13POS_NOSales Document Itemnvarchar60
TOPDepreciation Simulation
8IMCEPPTIM Summarization: Texts for program positions6POS_NOIM Summarization: Position number of program positionnvarchar80
9IMCHIEIM Summarization: Buffer for investment program hierarchy6POS_NOIM Summarization: Position number of program positionnvarchar80
TOPGeneric Contract Accounts Receivable and Payable
10BCA_DIM_CALCDETCalculation details for billing items4POS_NOPosition Numbernvarchar30
TOPInformation System
11CMS_LIQ_CFLCMS Liquidation Cash Flows (Tempoaray Solution for Rel 3.0)5POS_NOCMS Liquidation: Cash Flow Position Numbernvarchar40
TOPOLAP Technology
12RSR_TRACE_POSOLAP Trace2POS_NOint100
TOPProduction and Revenue Accounting
13OIU_PARObsolete3POS_NODocument Line Numbernvarchar50
14OIU_QUANAdditional quantities for PRA transactions in valuation3POS_NODocument Line Numbernvarchar50
15OIU_RV_VLTXNSValuation Transactions17POS_NOLast used (highest) position numbernvarchar30
TOPRevenue
16OIURV03_DTL_BKValuation Transactions Level 1 - Vltxns18POS_NOPosition Number fornvarchar100
17OIURV03_FRMHDRValuation Transaction Level 3 - Formula5POS_NOPosition Number fornvarchar100
18OIURV03_FRMTAXValuation Transactions Level 3 - Formula Tax Detail5POS_NOPosition Number fornvarchar100
19OIURV03_TAXDTLValuation Tax Master Detail5POS_NOPosition Number fornvarchar100
20OIURV03_TAXEMPValuation Tax Exempt Detail5POS_NOPosition Number fornvarchar100
21OIURV03_TAXHDRValuation Tax Header5POS_NOPosition Number fornvarchar100
22OIURV03_TAXMKTValuation Tax Marketing Detail5POS_NOPosition Number fornvarchar100
23OIURV03_VOLDTLValuation Transaction Level 2 -Volume5POS_NOPosition Number fornvarchar100
TOPSecurities
24CMS_SEC_ACC_POSSecurities position details4POS_NOSequence Number of a Position in a Securities Accountnvarchar40
TOPTransaction Tax Engine
25TTEPD3_USITEMPersistency TTE Document UsItem8POS_NOTax document item numbernvarchar60
26TTEPDT_USITEMPersistency TTE Document UsItem8POS_NOTax document item numbernvarchar60
27TTESDT_USITEMOutput Exemptions8POS_NOTax document item numbernvarchar60
TOPValuation
28OIURV_DOC_DTL_BKValuation Transactions Level 1 - Vltxns18POS_NOPosition Number fornvarchar100
29OIURV_DOC_FRMHDRValuation Transaction Level 3 - Formula5POS_NOPosition Number fornvarchar100
30OIURV_DOC_FRMMKTValuation Transactions Level 3 - Marketing Detail5POS_NOPosition Number fornvarchar100
31OIURV_DOC_FRMTAXValuation Transactions Level 3 - Formula Tax Detail5POS_NOPosition Number fornvarchar100
32OIURV_DOC_RUNTKTValuation Transaction - Run Ticket5POS_NOPosition Number fornvarchar100
33OIURV_DOC_TAXDTLValuation Tax Master Detail5POS_NOPosition Number fornvarchar100
34OIURV_DOC_TAXEMPValuation Tax Exempt Detail5POS_NOPosition Number fornvarchar100
35OIURV_DOC_TAXHDRValuation Tax Header5POS_NOPosition Number fornvarchar100
36OIURV_DOC_TAXMKTValuation Tax Marketing Detail5POS_NOPosition Number fornvarchar100
37OIURV_DOC_VOLDTLValuation Transaction Level 2 -Volume5POS_NOPosition Number fornvarchar100
38OIURV_DOC_VOLUNTValuation Document Concept - Volume Unit5POS_NOPosition Number fornvarchar100