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
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

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

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
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

43 columns | Print definition?ERP 6.0  | STBLG

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/BIC/B0000168000PSA for 0FI_GL_40 T90CLNT090 G/L Accounts: Items143STBLGnvarchar100
2/BIC/B0000169000PSA for 0FI_GL_41 T90CLNT090 Documents, Compact143STBLGnvarchar100
3/OPT/VIM_2HEADAdditional Fields for Table /OPT/VIM_1HEAD23STBLGVIM IE Monitor: data element for reversed doc_numnvarchar100
4BBP_RBKPDocument Header: Invoice Receipt35STBLGReverse Document Numbernvarchar100
5FIEUD_FIDOC_HSAFT: FI Transaction Document Header47STBLGReverse Document Numbernvarchar100
6FUDT_VDOCBKPFVerification Document Header19STBLGReverse Document Numbernvarchar100
7FUDT_VDOCBKPFHVerification Document Header(History)19STBLGReverse Document Numbernvarchar100
8FUDT_VERIFDOCFI verification document - index table11STBLGReverse Document Numbernvarchar100
9GLPOS_C_CTFI Document: Entry View234STBLGReverse Document Numbernvarchar100
10GLPOS_C_DEB_CTGLPOS_C_CT Customer Line Items234STBLGReverse Document Numbernvarchar100
11GLPOS_C_GL_CTGLPOS_C_CT G/L Line Items234STBLGReverse Document Numbernvarchar100
12GLPOS_C_VEN_CTGLPOS_C_CT Vendor Line Items234STBLGReverse Document Numbernvarchar100
13GLPOS_N_CTNew General Ledger: Line Item with Currency Type242STBLGReverse Document Numbernvarchar100
14GLPOS_N_GL_CTNew General Ledger: Line Item with Currency Type242STBLGReverse Document Numbernvarchar100
TOPAccounting Interface
15GLE_FI_ITEM_MODFECS: Modified FI Line Items (Header/Item/Currency Data)411STBLGReverse Document Numbernvarchar100
16GLE_FI_ITEM_ORIGECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F)411STBLGReverse Document Numbernvarchar100
TOPAverage Daily Balance
17GLE_FDOCREFECS / ADB Document Reference for Reversal9STBLGReverse Document Numbernvarchar100
TOPBalance Sheet Valuation Procedures
18MYLAUFITObject Table for Delta Run Using MRN915STBLGReverse Document Numbernvarchar100
TOPBasic Functions
19ANEKDocument Header Asset Posting18STBLGReverse Document Numbernvarchar100
TOPBasis Components
20ZDS400_BKPFBelegkopf für Buchhaltung19STBLGBelegnummer des Stornobelegsnvarchar100
TOPContract Accounts Receivable and Payable
21DFKKRAClearing/Reversal History (Document Header Level) < 4.623STBLGNumber of Reverse Document/Reset Documentnvarchar120
22DFKKRAPClearing/Reversal History (Line Item Level) < 4.626STBLGNumber of Reverse Document/Reset Documentnvarchar120
23DFKKRAPTClearing/Reversal History (Line Item Level)6STBLGNumber of Reverse Document/Reset Documentnvarchar120
24DFKKRATPartial Clearing Reset3STBLGNumber of Reverse Document/Reset Documentnvarchar120
25DFKKRHReturns History34STBLGNumber of Reverse Document/Reset Documentnvarchar120
TOPCross-Application Components
26BKKPFAccounting document header19STBLGReverse Document Numbernvarchar100
TOPData Retention Tool
27TXW_S_BKPFRetrieve BKPF from archive27STBLGReverse Document Numbernvarchar100
TOPFinancial Accounting
28/CCEE/SIFIDDVSpecial Tax Table22STBLGReverse Document Numbernvarchar100
29BKPFAccounting Document Header19STBLGReverse Document Numbernvarchar100
TOPFunds Management
30FMFG_REPOST_CNTLDocument batching/control for SL Repost for ECC 600 migratio6STBLGReverse Document Numbernvarchar100
TOPFunds Management-Specific Postings
31FMCJIS-PS: Documents in Cash Desk Subsidiary Ledger28STBLGReverse Document Numbernvarchar100
TOPGeneral Ledger Accounting
32BKPF_ADDAccounting Document Header19STBLGReverse Document Numbernvarchar100
TOPInvoice Verification
33RBKPDocument Header: Invoice Receipt35STBLGReversal document numbernvarchar100
TOPLocalization
34J_1ISER_BSEGTransaction table having the Invoices with Service Category10STBLGReverse Document Numbernvarchar100
TOPPurchasing
35EKDFDocument Flow for Logistics Differential Invoice16STBLGReversal document numbernvarchar100
TOPReal Estate Management
36IVBKIncidental expenses collector-Document header16STBLGReverse Document Numbernvarchar100
37VIEPOSLine items for correction items19STBLGReverse Document Numbernvarchar100
38VITAXALine items for correction items21STBLGReverse Document Numbernvarchar100
39VITAXDTax Shares per Real Estate Account Assignment41STBLGReverse Document Numbernvarchar100
40VIVSTBDocument reference for input tax treatment26STBLGReverse Document Numbernvarchar100
TOPRemaining Beverage - Obsolete Objects
41/BEV3/CH1030BKPFHeader Data for CH Event Ledger 0000103021STBLGReverse Document Numbernvarchar100
TOPTransaction Manager
42IDCFM_BST_HISTHistory table for balance sheet transfer for Brazil17STBLGReverse Document Numbernvarchar100
TOPVendor Evaluation
43EVAL_IV_RES_HDResults of Vendor Evaluation (Header)13STBLGReversal document numbernvarchar100