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

35 columns | Print definition?ERP 6.0  | PRODPER

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/OPT/AT_APPR_HISApproval History for Level Based Approvals96PRODPERProduction Month (Date to find period and year)nvarchar80
2/OPT/AT_LBA_LOGApproval History for Level Based Approvals97PRODPERProduction Month (Date to find period and year)nvarchar80
3/OPT/VIM_1ITEM_SDocument Item102PRODPERProduction Month (Date to find period and year)nvarchar80
4/OPT/VIM_TITEMDocument Item102PRODPERProduction Month (Date to find period and year)nvarchar80
5BSAS_BAKAccounting: Secondary Index for G/L Accounts (Cleared Items)80PRODPERnvarchar60
6BSEGAccounting Document Segment345PRODPERProduction Month (Date to find period and year)nvarchar80
7BSIS_BAKAccounting: Secondary Index for G/L Accounts80PRODPERnvarchar60
8FAGLBSAS_BAKAccounting: Secondary Index for G/L Accounts (Cleared Items)74PRODPERnvarchar60
9FAGLBSIS_BAKAccounting: Secondary Index for G/L Accounts74PRODPERnvarchar60
10FUDT_VDOCBSEGVerification Document Item with Additional Info327PRODPERProduction Month (Date to find period and year)nvarchar80
11FUDT_VDOCBSEGEVVerification Document Item in the Entry View327PRODPERProduction Month (Date to find period and year)nvarchar80
12FUDT_VDOCBSEGHVerification Document Segment with Additional Info(History)327PRODPERProduction Month (Date to find period and year)nvarchar80
13GLPOS_C_CTFI Document: Entry View357PRODPERProduction Month (Date to find period and year)nvarchar80
14GLPOS_C_DEB_CTGLPOS_C_CT Customer Line Items351PRODPERProduction Month (Date to find period and year)nvarchar80
15GLPOS_C_GL_CTGLPOS_C_CT G/L Line Items351PRODPERProduction Month (Date to find period and year)nvarchar80
16GLPOS_C_VEN_CTGLPOS_C_CT Vendor Line Items351PRODPERProduction Month (Date to find period and year)nvarchar80
17GLPOS_N_CTNew General Ledger: Line Item with Currency Type366PRODPERProduction Month (Date to find period and year)nvarchar80
18GLPOS_N_GL_CTNew General Ledger: Line Item with Currency Type360PRODPERProduction Month (Date to find period and year)nvarchar80
19YVIM_1ITEMDocument Item102PRODPERProduction Month (Date to find period and year)nvarchar80
TOPAccounting Interface
20GLE_FI_ITEM_MODFECS: Modified FI Line Items (Header/Item/Currency Data)428PRODPERProduction Month (Date to find period and year)nvarchar80
21GLE_FI_ITEM_ORIGECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F)428PRODPERProduction Month (Date to find period and year)nvarchar80
TOPControlling
22COKEY2CO Key Subnumbers Enhancement Table13PRODPERProduction Month for JVA in COnvarchar60
TOPFinancial Accounting
23/OPT/VIM_1ITEMDocument Item102PRODPERProduction Month (Date to find period and year)nvarchar80
24ACCTITCompressed Data from FI/CO Document193PRODPERProduction Month (Date to find period and year)nvarchar80
25BSASAccounting: Secondary Index for G/L Accounts (Cleared Items)81PRODPERnvarchar60
26BSISAccounting: Secondary Index for G/L Accounts81PRODPERnvarchar60
27EBSEGDoc.Segment of Fin.Accntng External Documents83PRODPERnvarchar60
28VBSEGSDocument Segment for Document Parking - G/L Account Database153PRODPERProduction Month (Date to find period and year)nvarchar80
TOPGeneral Ledger Accounting
29FAGLBSASAccounting: Secondary Index for G/L Accounts (Cleared Items)74PRODPERnvarchar60
30FAGLBSISAccounting: Secondary Index for G/L Accounts74PRODPERnvarchar60
TOPJoint Venture und Production Sharing Accounting
31JVSO1JV LI Table with Objects for JVTO182PRODPERProduction Month (Date to find period and year)nvarchar80
32T8JTPMJoint Venture Production Month Summary Data12PRODPERnvarchar60
TOPOverhead Cost Controlling
33COEPCO Object: Line Items (by Period)79PRODPERProduction Month for JVA in COnvarchar60
34COVP_DELTA_LOGLog of COVP Delta Queue for Error Analysis81PRODPERProduction Month for JVA in COnvarchar60
TOPProfitability Analysis
35CECOEPCO-PA Account Based Line Items81PRODPERProduction Month for JVA in COnvarchar60