SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

www.saptables.net

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
1BBP_PD_XML8Table for Persistent Class CL_XML_PPF_BBP
2FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
3/ISDFPS/CHVW_E34External Batch Where-Used List
4FMARCPAR4Parallelization of FMARC_BATCH
5CEKRS5Movement type parameters for automatic ERS
6/1RA/0SD010MI170Items for Class SD01 - Raw Data
7/ATL/AANLCP79Periodic Asset-value fields, like anlc, for all areas
8BSEG345Accounting Document Segment
9AUDLORIPR7KPro: Logical Information Object Attribute Values
10/OPT/Z1344Reporting table: Text table for exception definitions

B1 9.2: Top 10 requests

TableColumnsDescription
1OINV386A/R Invoice
2OITM299Items
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7OPCH386A/P Invoice
8OPOR386Purchase Order
9JDT1124Journal Entry - Rows
10OACT114G/L Accounts

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2OINV268A/R Invoice
3OVPM154Outgoing Payments
4ORCT154Incoming Payment
5OPCH268A/P Invoice
6OIVL77Whse Journal
7OOCR9Loading Factors
8OSRN20Serial Numbers Master Data
9JDT1110Journal Entry - Rows
10OBOT10Bill Of Exchang Transaction
PHPRef.com - the webs number one PHP Function reference tool

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