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

54 columns | Print definition?ERP 6.0  | PSWSL

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/BIC/B0000172000PSA for 0FI_GL_14 T90CLNT090 Gen. Ledger: Items96PSWSLnvarchar50
2BSAD_BAKAccounting: Secondary index for customers (cleared items)120PSWSLUpdate Currency for General Ledger Transaction Figuresnvarchar50
3BSAK_BAKAccounting: Secondary Index for Vendors (Cleared Items)128PSWSLUpdate Currency for General Ledger Transaction Figuresnvarchar50
4BSAS_BAKAccounting: Secondary Index for G/L Accounts (Cleared Items)37PSWSLUpdate Currency for General Ledger Transaction Figuresnvarchar50
5BSEGAccounting Document Segment35PSWSLUpdate Currency for General Ledger Transaction Figuresnvarchar50
6BSID_BAKAccounting: Secondary Index for Customers120PSWSLUpdate Currency for General Ledger Transaction Figuresnvarchar50
7BSIK_BAKAccounting: Secondary index for vendors128PSWSLUpdate Currency for General Ledger Transaction Figuresnvarchar50
8BSIS_BAKAccounting: Secondary Index for G/L Accounts37PSWSLUpdate Currency for General Ledger Transaction Figuresnvarchar50
9BSSEGAccounting Document Segment24PSWSLUpdate Currency for General Ledger Transaction Figuresnvarchar50
10DFKKEPRTLog for Inconsistent FI-CA Documents52PSWSLUpdate Currency for General Ledger Transaction Figuresnvarchar50
11FAGLBSAS_BAKAccounting: Secondary Index for G/L Accounts (Cleared Items)37PSWSLUpdate Currency for General Ledger Transaction Figuresnvarchar50
12FAGLBSIS_BAKAccounting: Secondary Index for G/L Accounts37PSWSLUpdate Currency for General Ledger Transaction Figuresnvarchar50
13FUDT_VDOCBSEGVerification Document Item with Additional Info24PSWSLUpdate Currency for General Ledger Transaction Figuresnvarchar50
14FUDT_VDOCBSEGEVVerification Document Item in the Entry View24PSWSLUpdate Currency for General Ledger Transaction Figuresnvarchar50
15FUDT_VDOCBSEGHVerification Document Segment with Additional Info(History)24PSWSLUpdate Currency for General Ledger Transaction Figuresnvarchar50
16REGUPProcessed items from payment program154PSWSLUpdate Currency for General Ledger Transaction Figuresnvarchar50
TOPAccounting Interface
17GLE_FI_ITEM_MODFECS: Modified FI Line Items (Header/Item/Currency Data)82PSWSLUpdate Currency for General Ledger Transaction Figuresnvarchar50
18GLE_FI_ITEM_ORIGECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F)82PSWSLUpdate Currency for General Ledger Transaction Figuresnvarchar50
TOPContract Accounts Receivable and Payable
19DFKKMOPItems in contract account document130PSWSLUpdate Currency for General Ledger Transaction Figuresnvarchar50
20DFKKMOPKItems in contract account document57PSWSLUpdate Currency for General Ledger Transaction Figuresnvarchar50
21DFKKOPItems in contract account document130PSWSLUpdate Currency for General Ledger Transaction Figuresnvarchar50
22DFKKOPKItems in contract account document57PSWSLUpdate Currency for General Ledger Transaction Figuresnvarchar50
23DFKKOP_REPOpen Items from FPO4136PSWSLUpdate Currency for General Ledger Transaction Figuresnvarchar50
24DFKKRAPClearing/Reversal History (Line Item Level) < 4.6217PSWSLUpdate Currency for General Ledger Transaction Figuresnvarchar50
25DFKKRAPTClearing/Reversal History (Line Item Level)17PSWSLUpdate Currency for General Ledger Transaction Figuresnvarchar50
26DFKKSUMPosting totals from FI-CA10PSWSLUpdate Currency for General Ledger Transaction Figuresnvarchar50
TOPCross-Application Components
27BBSIDAccounting: Secondary index for customers120PSWSLUpdate Currency for General Ledger Transaction Figuresnvarchar50
TOPData Retention Tool
28TXW_S_BSEGRetrieve BSEG from archive68PSWSLUpdate Currency for General Ledger Transaction Figuresnvarchar50
TOPFinancial Accounting
29ACCTITCompressed Data from FI/CO Document26PSWSLUpdate Currency for General Ledger Transaction Figuresnvarchar50
30BSADAccounting: Secondary Index for Customers (Cleared Items)120PSWSLUpdate Currency for General Ledger Transaction Figuresnvarchar50
31BSAKAccounting: Secondary Index for Vendors (Cleared Items)128PSWSLUpdate Currency for General Ledger Transaction Figuresnvarchar50
32BSASAccounting: Secondary Index for G/L Accounts (Cleared Items)37PSWSLUpdate Currency for General Ledger Transaction Figuresnvarchar50
33BSIDAccounting: Secondary Index for Customers120PSWSLUpdate Currency for General Ledger Transaction Figuresnvarchar50
34BSIKAccounting: Secondary Index for Vendors128PSWSLUpdate Currency for General Ledger Transaction Figuresnvarchar50
35BSISAccounting: Secondary Index for G/L Accounts37PSWSLUpdate Currency for General Ledger Transaction Figuresnvarchar50
TOPGeneral Ledger Accounting
36BSEG_ADDEntry View of Accounting Document for Additional Ledgers80PSWSLUpdate Currency for General Ledger Transaction Figuresnvarchar50
37FAGLBSASAccounting: Secondary Index for G/L Accounts (Cleared Items)37PSWSLUpdate Currency for General Ledger Transaction Figuresnvarchar50
38FAGLBSISAccounting: Secondary Index for G/L Accounts37PSWSLUpdate Currency for General Ledger Transaction Figuresnvarchar50
39FAGL_SPLINFOSplittling Information of Open Items57PSWSLUpdate Currency for General Ledger Transaction Figuresnvarchar50
TOPGeneral Ledger Reorganization
40FAGL_R_BLNCEReorganization: Balances to Be Transferred7PSWSLUpdate Currency for General Ledger Transaction Figuresnvarchar50
41FAGL_R_BLNCE_VALReorganization: Balances to Be Transferred - Values7PSWSLUpdate Currency for General Ledger Transaction Figuresnvarchar50
42FAGL_R_SPLReorganization: Splitting Information of the Open Items36PSWSLUpdate Currency for General Ledger Transaction Figuresnvarchar50
TOPLocal Currency Changeover
43EWUFI_SCAEMU conversion: Table of the clearings to be adjusted41PSWSLUpdate Currency for General Ledger Transaction Figuresnvarchar50
44EWUFI_SOPEMU conversion: Table for open items total11PSWSLUpdate Currency for General Ledger Transaction Figuresnvarchar50
TOPLocalization
45J_1AINFINVInflation: Invoices for Replacement Value Determination14PSWSLUpdate Currency for General Ledger Transaction Figuresnvarchar50
46J_3RFTAX_EXTRDTax Extract Detail Lines99PSWSLUpdate Currency for General Ledger Transaction Figuresnvarchar50
47RFITEMAP_NO_ITEMItem wise detail for the Vendor Transactions98PSWSLUpdate Currency for General Ledger Transaction Figuresnvarchar50
48RFITEMAR_NO_ITEMItem wise detail for the Customer Transactions98PSWSLUpdate Currency for General Ledger Transaction Figuresnvarchar50
49RFITEMGL_NO_ITEMItem wise detail for the GL Account Transactions98PSWSLUpdate Currency for General Ledger Transaction Figuresnvarchar50
TOPPayment Transactions
50FPRL_ITEMItem Data26PSWSLUpdate Currency for General Ledger Transaction Figuresnvarchar50
51REGUP_COREProcessed Items from Payment Program35PSWSLCurrency Keynvarchar50
TOPRemaining Beverage - Obsolete Objects
52/BEV3/CH1030BSG1Document Segment CH Event Ledger Part126PSWSLUpdate Currency for General Ledger Transaction Figuresnvarchar50
TOPTechnical Application Support
53CNV_20425_SCAEMU conversion: Table of the clearings to be adjusted36PSWSLUpdate Currency for General Ledger Transaction Figuresnvarchar50
54CNV_20425_SOPEMU conversion: Table for open items total10PSWSLUpdate Currency for General Ledger Transaction Figuresnvarchar50