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

52 columns | Print definition?ERP 6.0  | PSWBT

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/BIC/B0000172000PSA for 0FI_GL_14 T90CLNT090 Gen. Ledger: Items97PSWBTdecimal150
2BSAD_BAKAccounting: Secondary index for customers (cleared items)121PSWBTAmount for Updating in General Ledgerdecimal132
3BSAK_BAKAccounting: Secondary Index for Vendors (Cleared Items)129PSWBTAmount for Updating in General Ledgerdecimal132
4BSAS_BAKAccounting: Secondary Index for G/L Accounts (Cleared Items)50PSWBTAmount for Updating in General Ledgerdecimal132
5BSEGAccounting Document Segment34PSWBTAmount for Updating in General Ledgerdecimal132
6BSID_BAKAccounting: Secondary Index for Customers121PSWBTAmount for Updating in General Ledgerdecimal132
7BSIK_BAKAccounting: Secondary index for vendors129PSWBTAmount for Updating in General Ledgerdecimal132
8BSIS_BAKAccounting: Secondary Index for G/L Accounts50PSWBTAmount for Updating in General Ledgerdecimal132
9BSSEGAccounting Document Segment23PSWBTAmount for Updating in General Ledgerdecimal132
10DFKKEPRTLog for Inconsistent FI-CA Documents51PSWBTAmount for Updating in General Ledgerdecimal132
11FAGLBSAS_BAKAccounting: Secondary Index for G/L Accounts (Cleared Items)50PSWBTAmount for Updating in General Ledgerdecimal132
12FAGLBSIS_BAKAccounting: Secondary Index for G/L Accounts50PSWBTAmount for Updating in General Ledgerdecimal132
13FUDT_VDOCBSEGVerification Document Item with Additional Info23PSWBTAmount for Updating in General Ledgerdecimal132
14FUDT_VDOCBSEGEVVerification Document Item in the Entry View23PSWBTAmount for Updating in General Ledgerdecimal132
15FUDT_VDOCBSEGHVerification Document Segment with Additional Info(History)23PSWBTAmount for Updating in General Ledgerdecimal132
16REGUPProcessed items from payment program155PSWBTAmount for Updating in General Ledgerdecimal132
TOPAccounting Interface
17GLE_FI_ITEM_MODFECS: Modified FI Line Items (Header/Item/Currency Data)83PSWBTAmount for Updating in General Ledgerdecimal132
18GLE_FI_ITEM_ORIGECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F)83PSWBTAmount for Updating in General Ledgerdecimal132
TOPContract Accounts Receivable and Payable
19DFKKMOPItems in contract account document131PSWBTAmount for Updating in General Ledgerdecimal132
20DFKKOPItems in contract account document131PSWBTAmount for Updating in General Ledgerdecimal132
21DFKKOP_REPOpen Items from FPO4137PSWBTAmount for Updating in General Ledgerdecimal132
22DFKKRAPClearing/Reversal History (Line Item Level) < 4.6216PSWBTAmount for Updating in General Ledgerdecimal132
23DFKKRAPTClearing/Reversal History (Line Item Level)16PSWBTAmount for Updating in General Ledgerdecimal132
24DFKKSUMPosting totals from FI-CA51PSWBTAmount for Updating in General Ledgerdecimal132
TOPCross-Application Components
25BBSIDAccounting: Secondary index for customers121PSWBTAmount for Updating in General Ledgerdecimal132
TOPData Retention Tool
26TXW_S_BSEGRetrieve BSEG from archive69PSWBTAmount for updating in general ledger (position currency PC)nvarchar160
TOPFinancial Accounting
27ACCTITCompressed Data from FI/CO Document27PSWBTAmount for Updating in General Ledgerdecimal132
28BSADAccounting: Secondary Index for Customers (Cleared Items)121PSWBTAmount for Updating in General Ledgerdecimal132
29BSAKAccounting: Secondary Index for Vendors (Cleared Items)129PSWBTAmount for Updating in General Ledgerdecimal132
30BSASAccounting: Secondary Index for G/L Accounts (Cleared Items)50PSWBTAmount for Updating in General Ledgerdecimal132
31BSIDAccounting: Secondary Index for Customers121PSWBTAmount for Updating in General Ledgerdecimal132
32BSIKAccounting: Secondary Index for Vendors129PSWBTAmount for Updating in General Ledgerdecimal132
33BSISAccounting: Secondary Index for G/L Accounts50PSWBTAmount for Updating in General Ledgerdecimal132
TOPGeneral Ledger Accounting
34BSEG_ADDEntry View of Accounting Document for Additional Ledgers81PSWBTAmount for Updating in General Ledgerdecimal232
35EWUFI_SPLITEMU Implementation: Table of FAGL_SPLINFO* to Be Corrected14PSWBTAmount for Updating in General Ledgerdecimal132
36FAGLBSASAccounting: Secondary Index for G/L Accounts (Cleared Items)50PSWBTAmount for Updating in General Ledgerdecimal132
37FAGLBSISAccounting: Secondary Index for G/L Accounts50PSWBTAmount for Updating in General Ledgerdecimal132
38FAGL_SPLINFOSplittling Information of Open Items58PSWBTAmount for Updating in General Ledgerdecimal132
TOPGeneral Ledger Reorganization
39FAGL_R_BLNCEReorganization: Balances to Be Transferred15PSWBTAmount for Updating in General Ledgerdecimal132
40FAGL_R_SPLReorganization: Splitting Information of the Open Items37PSWBTAmount for Updating in General Ledgerdecimal132
TOPLocal Currency Changeover
41EWUFI_SCAEMU conversion: Table of the clearings to be adjusted42PSWBTAmount for Updating in General Ledgerdecimal132
42EWUFI_SOPEMU conversion: Table for open items total13PSWBTItems/subledger total in item currencydecimal152
TOPLocalization
43J_1AINFINVInflation: Invoices for Replacement Value Determination13PSWBTAmount for Updating in General Ledgerdecimal132
44J_3RFTAX_EXTRDTax Extract Detail Lines100PSWBTAmount for Updating in General Ledgerdecimal132
45RFITEMAP_NO_ITEMItem wise detail for the Vendor Transactions99PSWBTAmount for General Ledger Update (Absolute)decimal152
46RFITEMAR_NO_ITEMItem wise detail for the Customer Transactions99PSWBTAmount for General Ledger Update (Absolute)decimal152
47RFITEMGL_NO_ITEMItem wise detail for the GL Account Transactions99PSWBTAmount for General Ledger Update (Absolute)decimal152
TOPPayment Transactions
48FPRL_ITEMItem Data27PSWBTAmount for Updating in General Ledgerdecimal132
49REGUP_COREProcessed Items from Payment Program36PSWBTAmount in local currencydecimal232
TOPRemaining Beverage - Obsolete Objects
50/BEV3/CH1030BSG1Document Segment CH Event Ledger Part125PSWBTAmount for Updating in General Ledgerdecimal132
TOPTechnical Application Support
51CNV_20425_SCAEMU conversion: Table of the clearings to be adjusted37PSWBTAmount for Updating in General Ledgerdecimal132
52CNV_20425_SOPEMU conversion: Table for open items total12PSWBTItems/subledger total in item currencydecimal152