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

70 columns | Print definition?ERP 6.0  | ZEKKN

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/OPT/VIM_1ITEM_SDocument Item88ZEKKNSequential Number of Account Assignmentnvarchar20
2/OPT/VIM_TITEMDocument Item88ZEKKNSequential Number of Account Assignmentnvarchar20
3BSAK_BAKAccounting: Secondary Index for Vendors (Cleared Items)131ZEKKNSequential Number of Account Assignmentnvarchar20
4BSEGAccounting Document Segment179ZEKKNSequential Number of Account Assignmentnvarchar20
5BSIK_BAKAccounting: Secondary index for vendors131ZEKKNSequential Number of Account Assignmentnvarchar20
6BSSEGAccounting Document Segment168ZEKKNSequential Number of Account Assignmentnvarchar20
7CNVA_PCREA_GRIROGR/IR Items - Results (Level 2)12ZEKKNSequential Number of Account Assignmentnvarchar20
8FUDT_VDOCBSEGVerification Document Item with Additional Info168ZEKKNSequential Number of Account Assignmentnvarchar20
9FUDT_VDOCBSEGEVVerification Document Item in the Entry View168ZEKKNSequential Number of Account Assignmentnvarchar20
10FUDT_VDOCBSEGHVerification Document Segment with Additional Info(History)168ZEKKNSequential Number of Account Assignmentnvarchar20
11GLPOS_C_CTFI Document: Entry View315ZEKKNSequential Number of Account Assignmentnvarchar20
12GLPOS_C_DEB_CTGLPOS_C_CT Customer Line Items315ZEKKNSequential Number of Account Assignmentnvarchar20
13GLPOS_C_GL_CTGLPOS_C_CT G/L Line Items315ZEKKNSequential Number of Account Assignmentnvarchar20
14GLPOS_C_VEN_CTGLPOS_C_CT Vendor Line Items315ZEKKNSequential Number of Account Assignmentnvarchar20
15GLPOS_N_CTNew General Ledger: Line Item with Currency Type324ZEKKNSequential Number of Account Assignmentnvarchar20
16GLPOS_N_GL_CTNew General Ledger: Line Item with Currency Type324ZEKKNSequential Number of Account Assignmentnvarchar20
17REGUPProcessed items from payment program131ZEKKNSequential Number of Account Assignmentnvarchar20
18VIYCEXPITEMExpense Items43ZEKKNSequential Number of Account Assignmentnvarchar20
19YVIM_1ITEMDocument Item88ZEKKNSequential Number of Account Assignmentnvarchar20
TOPAccounting Interface
20GLE_FI_ITEM_MODFECS: Modified FI Line Items (Header/Item/Currency Data)211ZEKKNSequential Number of Account Assignmentnvarchar20
21GLE_FI_ITEM_ORIGECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F)211ZEKKNSequential Number of Account Assignmentnvarchar20
TOPActual CostingMaterial Ledger
22MLBEMaterial Ledger FS Item Table for GR/IR relevant transaction10ZEKKNSequential Number of Account Assignmentnvarchar20
23MLBEHMaterial Ledger FS Item Table for GR/IR relevant transaction10ZEKKNSequential Number of Account Assignmentnvarchar20
24MLITMBMaterial valuation document row information15ZEKKNSequential Number of Account Assignmentnvarchar20
25MLWEREConversion Table between Purchasing and Material Ledger7ZEKKNSequential Number of Account Assignmentnvarchar20
TOPActual Payments and Forecast
26COFPDocument Lines (project cash management)30ZEKKNSequential Number of Account Assignmentnvarchar20
TOPBasic Functions
27FDM1Cash Management & Forecast: Line Items of MM Documents8ZEKKNSequential Number of Account Assignmentnvarchar20
TOPExternal Services
28ESKLAccount Assignment Specification: Service Line11ZEKKNSequential Number of Account Assignment in ESKNnvarchar20
29ESKNAccount Assignment in Service Package3ZEKKNSequential Number of Account Assignmentnvarchar20
TOPFinancial Accounting
30/OPT/VIM_1ITEMDocument Item88ZEKKNSequential Number of Account Assignmentnvarchar20
31ACCTITCompressed Data from FI/CO Document83ZEKKNSequential Number of Account Assignmentnvarchar20
32BSAKAccounting: Secondary Index for Vendors (Cleared Items)131ZEKKNSequential Number of Account Assignmentnvarchar20
33BSIKAccounting: Secondary Index for Vendors131ZEKKNSequential Number of Account Assignmentnvarchar20
34VBSEGSDocument Segment for Document Parking - G/L Account Database57ZEKKNSequential Number of Account Assignmentnvarchar20
TOPFunds Management
35FCABPFI-CA: Document Item37ZEKKNSequential Number of Account Assignmentnvarchar20
36FMEPFI-FM Line Items30ZEKKNSequential Number of Account Assignmentnvarchar20
TOPFunds Management-Specific Postings
37FMFUNDTRANSYEARAdditional Documents for Funds Transfer to Diff. Years56ZEKKNSequential Number of Account Assignmentnvarchar20
38PSOSEGSRecurring Request Document Segment, G/L Accounts55ZEKKNSequential Number of Account Assignmentnvarchar20
TOPGeneral Ledger Reorganization
39FAGL_R_SPLReorganization: Splitting Information of the Open Items28ZEKKNSequential Number of Account Assignmentnvarchar20
TOPIndustry Solution Catch Weight Management
40/CWM/MIG_PROT_EKSaving EKBE and EBKZ with DMBTR = 05ZEKKNSequential Number of Account Assignmentnvarchar20
TOPInventory Management
41MMINKON_UPCorrections due to Technical Problems with Stock42ZEKKNSequential Number of Account Assignmentnvarchar20
42MSEGDocument Segment: Material140ZEKKNSequential Number of Account Assignmentnvarchar20
43MWXMSEGZMSEG: Interface for Posting of Value140ZEKKNSequential Number of Account Assignmentnvarchar20
44MWZMSEGZMSEG:Interface for Posting of Value140ZEKKNSequential Number of Account Assignmentnvarchar20
TOPInvoice Verification
45RBCODocument Item, Incoming Invoice, Account Assignment46ZEKKNSequential Number of Account Assignmentnvarchar20
46RBDPCInvoice Verification: Down Payment Clearing13ZEKKNSequential Number of Account Assignmentnvarchar20
47RBDRSEGBatch IV: Invoice Document Items65ZEKKNSequential Number of Account Assignmentnvarchar20
48RSEGDocument Item: Incoming Invoice7ZEKKNSequential Number of Account Assignmentnvarchar20
TOPLocal Currency Changeover
49EWUFI_SCAEMU conversion: Table of the clearings to be adjusted33ZEKKNSequential Number of Account Assignmentnvarchar20
TOPLocalization
50IDEU_VATEU VAT Posting4ZEKKNSequential Number of Account Assignmentnvarchar20
TOPMarketing, Accounting and Pricing
51OIC_FORM_ATTRIBAttributes of Business Context for F&A Formula22ZEKKNSequential Number of Account Assignmentnvarchar20
TOPOverhead Cost Controlling
52COEPCO Object: Line Items (by Period)46ZEKKNSequential Number of Account Assignmentnvarchar20
53COVP_DELTA_LOGLog of COVP Delta Queue for Error Analysis48ZEKKNSequential Number of Account Assignmentnvarchar20
TOPProfitability Analysis
54CECOEPCO-PA Account Based Line Items48ZEKKNSequential Number of Account Assignmentnvarchar20
TOPPurchasing
55EKBEHistory per Purchasing Document4ZEKKNSequential Number of Account Assignmentnvarchar20
56EKBEHRemoved PO History Records4ZEKKNSequential Number of Account Assignmentnvarchar20
57EKBEH_MARemoved PO History Records at Account Assignment Level4ZEKKNSequential Number of Account Assignmentnvarchar20
58EKBE_MAHistory of Purchasing Document at Account Assignment Level4ZEKKNSequential Number of Account Assignmentnvarchar20
59EKBE_SRV_SUMTotals History for SRV Documents5ZEKKNSequential Number of Account Assignmentnvarchar20
60EKBZH_MAHistory Table Delivery Costs at Account Assignment Level10ZEKKNSequential Number of Account Assignmentnvarchar20
61EKBZ_MADelivery Costs at Account Assignment Level10ZEKKNSequential Number of Account Assignmentnvarchar20
62EKCPAPurchasing Contract Commitment Plan Account Assignment Data5ZEKKNSequential Number of Account Assignmentnvarchar20
63EKKNAccount Assignment in Purchasing Document4ZEKKNSequential Number of Account Assignmentnvarchar20
TOPRemaining Beverage - Obsolete Objects
64/BEV3/CH1030BSG1Document Segment CH Event Ledger Part1170ZEKKNSequential Number of Account Assignmentnvarchar20
TOPRepetitive Manufacturing
65COMPMOVEGoods Movement of Components56ZEKKNSequential Number of Account Assignmentnvarchar20
TOPSubsequent Settlement
66EKBOIndex of Docs. for Price Determ./Updating, Subsequent Sett.14ZEKKNSequential Number of Account Assignmentnvarchar20
TOPTechnical Application Support
67CNV_20425_SCAEMU conversion: Table of the clearings to be adjusted30ZEKKNSequential number of account assignmentnvarchar20
TOPTransaction Manager
68VTBSIANF**Caution! Do not use. Will be deleted!!25ZEKKNSequential Number of Account Assignmentnvarchar20
69VTBSIZUHedge Allocation33ZEKKNSequential Number of Account Assignmentnvarchar20
TOPTreasury
70FLQITEMPO_FCLiquidity Calculation - Forecast Line Items for MM POs4ZEKKNSequential Number of Account Assignmentnvarchar20