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

72 columns | Print definition?ERP 6.0  | FDLEV

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1BSEGAccounting Document Segment62FDLEVPlanning levelnvarchar20
2BSSEGAccounting Document Segment51FDLEVPlanning levelnvarchar20
3CNV_20100_SKB1CNV backup copy for SKB111FDLEVnvarchar20
4FLQITEMMMPARK_FCLiquidity Calculation - Forecast Line Items for MM Documents18FDLEVPlanning levelnvarchar20
5FLQITEMPARK_FCLiquidity Calculation - Forecast Line Items for FI Documents19FDLEVPlanning levelnvarchar20
6FUDT_VDOCBSEGVerification Document Item with Additional Info51FDLEVPlanning levelnvarchar20
7FUDT_VDOCBSEGEVVerification Document Item in the Entry View51FDLEVPlanning levelnvarchar20
8FUDT_VDOCBSEGHVerification Document Segment with Additional Info(History)51FDLEVPlanning levelnvarchar20
9GLPOS_C_CTFI Document: Entry View110FDLEVPlanning levelnvarchar20
10GLPOS_C_DEB_CTGLPOS_C_CT Customer Line Items110FDLEVPlanning levelnvarchar20
11GLPOS_C_GL_CTGLPOS_C_CT G/L Line Items110FDLEVPlanning levelnvarchar20
12GLPOS_C_VEN_CTGLPOS_C_CT Vendor Line Items110FDLEVPlanning levelnvarchar20
13GLPOS_N_CTNew General Ledger: Line Item with Currency Type112FDLEVPlanning levelnvarchar20
14GLPOS_N_GL_CTNew General Ledger: Line Item with Currency Type112FDLEVPlanning levelnvarchar20
15TFK036SPlanning Levels with Payment Locks2FDLEVPlanning levelnvarchar20
16TFK036VDifferent Planning Levels By Transactions3FDLEVPlanning levelnvarchar20
17VIYCADVPAYAdvance Payments77FDLEVPlanning levelnvarchar20
TOPAccounting Interface
18GLE_FI_ITEM_MODFECS: Modified FI Line Items (Header/Item/Currency Data)271FDLEVPlanning levelnvarchar20
19GLE_FI_ITEM_ORIGECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F)271FDLEVPlanning levelnvarchar20
TOPBasic Functions
20FDFIEPCM: FI Line Items (OP of Deb/Cred for Drilldown)9FDLEVPlanning levelnvarchar20
21FDI1Cash Management Line Item for RE Classic Planning Records9FDLEVPlanning levelnvarchar20
22FDLFCash Management Line Items for Agency Business11FDLEVPlanning levelnvarchar20
23FDLF2Cash Management Line Items for Agency Business (As of 604)12FDLEVPlanning levelnvarchar20
24FDM1Cash Management & Forecast: Line Items of MM Documents14FDLEVPlanning levelnvarchar20
25FDM2Cash management line items from MM purchase requisition10FDLEVPlanning levelnvarchar20
26FDMVCash Planning Line Items of Earmarked Funds18FDLEVPlanning levelnvarchar20
27FDRECash Management Line Items from RE-FX (Real Estate)6FDLEVPlanning levelnvarchar20
28FDS2CM&F Line Items in SD Documents (fromr Release 4.0)15FDLEVPlanning levelnvarchar20
29FDSPCash Mgmt Adjustment Items from Document Splitting25FDLEVPlanning levelnvarchar20
30FLQITEMC1_FCLiquidity Calculation: Forecast from Securities12FDLEVPlanning levelnvarchar20
31SKB1G/L account master (company code)10FDLEVPlanning levelnvarchar20
32SKM1Sample G/L accounts10FDLEVPlanning levelnvarchar20
TOPCollectionsDisbursements
33VVSCITEMBill Scheduling: Scheduling Document59FDLEVPlanning levelnvarchar20
34VVSCITEM_MANScheduling Items: Temp. Storage for Manual -> Auto Change59FDLEVPlanning levelnvarchar20
TOPContract Accounts Receivable and Payable
35DFKKCASHFCInterim Table for Cash Management and Forecast Data7FDLEVPlanning levelnvarchar20
36DFKKIP_GRPPayment Specification: Header Data37FDLEVPlanning levelnvarchar20
37DFKKIP_GRPHPayment Specification: Payment Data (History)39FDLEVPlanning levelnvarchar20
38DFKKMOPItems in contract account document79FDLEVPlanning levelnvarchar20
39DFKKMOPKItems in contract account document17FDLEVPlanning levelnvarchar20
40DFKKOPItems in contract account document79FDLEVPlanning levelnvarchar20
41DFKKOPKItems in contract account document17FDLEVPlanning levelnvarchar20
42DFKKOP_REPOpen Items from FPO483FDLEVPlanning levelnvarchar20
43DFKKORDERPOSRequests: Items68FDLEVPlanning levelnvarchar20
44DFKKORDERPOS_SRequest Templates: Items53FDLEVPlanning levelnvarchar20
45DFKKPOHPayment Order: Header Data28FDLEVPlanning levelnvarchar20
46DFKKPPPromises to Pay Header Table18FDLEVPlanning levelnvarchar20
47DFKKSUMPosting totals from FI-CA26FDLEVPlanning levelnvarchar20
TOPDefault Risk and Limit System
48KLCMMAPPINGMapping Table for CM and Business Partner4FDLEVCredit Limit: Level for Cash Management and Forecastingnvarchar20
49KLXCMRTCM Data for Risk Objects Derived from Cash Management6FDLEVCredit Limit: Level for Cash Management and Forecastingnvarchar20
TOPFinancial Accounting
50VBSEGDDocument Segment for Customer Document Parking33FDLEVPlanning levelnvarchar20
51VBSEGKDocument Segment for Vendor Document Parking38FDLEVPlanning levelnvarchar20
52VBSEGSDocument Segment for Document Parking - G/L Account Database30FDLEVPlanning levelnvarchar20
TOPFunds Management-Specific Postings
53FMFUNDTRANSYEARAdditional Documents for Funds Transfer to Diff. Years31FDLEVPlanning levelnvarchar20
54PSOSEGDDocument Segment: Recurring Request, Customer34FDLEVPlanning levelnvarchar20
55PSOSEGKRecurring Request Document Segment, Vendors39FDLEVPlanning levelnvarchar20
56PSOSEGSRecurring Request Document Segment, G/L Accounts30FDLEVPlanning levelnvarchar20
TOPInvoice Verification
57RBKPDocument Header: Invoice Receipt120FDLEVPlanning levelnvarchar20
TOPInvoicing
58DEABPSCustomer change table: Logical view of BB amounts72FDLEVPlanning levelnvarchar20
TOPPayment Transactions
59PYORDHPayment order header data14FDLEVPlanning levelnvarchar20
TOPPayments
60DFKKBOHBoleto: Header data31FDLEVPlanning levelnvarchar20
TOPReal Estate Contract
61VICDCFOBJObject-Related Cash Flow74FDLEVPlanning levelnvarchar20
62VICDCFPAYPayment-Related Cash Flow73FDLEVPlanning levelnvarchar20
TOPReal Estate Management
63VIAKBSEGDocument Line Item from SCS for Interface56FDLEVPlanning levelnvarchar20
64VIBEPPFlow data - Planned items for real estate management35FDLEVPlanning levelnvarchar20
TOPRemaining Beverage - Obsolete Objects
65/BEV3/CH1030BSG1Document Segment CH Event Ledger Part153FDLEVPlanning levelnvarchar20
TOPTreasury
66FLQITEMD1_FCLiquidity Calculation: Forecast Line Items from Loans15FDLEVPlanning levelnvarchar20
67FLQITEMFI_FCLiquidity Calculation - Forecast Line Items for FI Documents18FDLEVPlanning levelnvarchar20
68FLQITEMPO_FCLiquidity Calculation - Forecast Line Items for MM POs18FDLEVPlanning levelnvarchar20
69FLQITEMPR_FCLiquidity Calc. Forecast - Line Items, Purchase Requisitions16FDLEVPlanning levelnvarchar20
70FLQITEMSO_FCLiquidity Calculation-Forecast Line Items from Sales Orders15FDLEVPlanning levelnvarchar20
71FLQITEMT1_FCLiquidity Calculation: Forecast Line Items from TR Trans.16FDLEVPlanning levelnvarchar20
72FLQSUM_FCLiquidity Calculation - Forecast Totals Records8FDLEVPlanning levelnvarchar20