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

49 columns | Print definition?ERP 6.0  | BEMOT

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1ZCATSDBRecords changed with processing status '10'60BEMOTnvarchar20
2ZCATSDB2Records changed with processing status '10'61BEMOTnvarchar20
TOPAccounting Interface
3GLE_FI_ITEM_MODFECS: Modified FI Line Items (Header/Item/Currency Data)320BEMOTAccounting Indicatornvarchar20
4GLE_FI_ITEM_ORIGECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F)320BEMOTAccounting Indicatornvarchar20
TOPAgency Business Global Trade
5WBRPAgency business: Item100BEMOTAccounting Indicatornvarchar20
TOPBilling
6VBRPBilling Document: Item Data173BEMOTAccounting Indicatornvarchar20
TOPConditions
7A140Sales Area / Accounting Indicator7BEMOTAccounting Indicatornvarchar20
TOPConfirmations
8AFFWGoods Movements with Errors from Confirmations69BEMOTAccounting Indicatornvarchar20
9AFRDDefault values for collective confirmation96BEMOTAccounting Indicatornvarchar20
10AFRUOrder Confirmations116BEMOTAccounting Indicatornvarchar20
11AFRVConfirmation pool159BEMOTAccounting Indicatornvarchar20
12AFRV_DELBackup Copy for Confirmation Pool159BEMOTAccounting Indicatornvarchar20
TOPControlling
13COKEYCO key sub-numbers13BEMOTAccounting Indicatornvarchar20
14CRMCO_CONF_COSTSCRM/CO: Actual Costs for Confirmations10BEMOTAccounting Indicatornvarchar20
TOPCross-Application Components
15AAUUFKOrder master data88BEMOTAccounting Indicatornvarchar20
16VVBKDSales Document: Business Data67BEMOTAccounting Indicatornvarchar20
TOPCustomer Service
17TBMOTAccounting indicators2BEMOTAccounting Indicatornvarchar20
18TBMOTXAccounting indicator description3BEMOTAccounting Indicatornvarchar20
TOPElectronic Bank Statement
19FEB_ACCNT_SAVESaving of Posting Lines for Postprocessing (Account Assign.)26BEMOTAccounting Indicatornvarchar20
20FEB_ACTAcct Assignment Templates26BEMOTAccounting Indicatornvarchar20
TOPESS Based on WD ABAP
21HRESS_D_CATS_FAVCATS Favorites: database table67BEMOTAccounting Indicatornvarchar20
TOPFinancial Accounting
22ACCTITCompressed Data from FI/CO Document109BEMOTAccounting Indicatornvarchar20
TOPGL Account Posting
23TCJ_POSITIONSCash Journal Document Items33BEMOTAccounting Indicatornvarchar20
TOPInventory Management
24MSEGDocument Segment: Material179BEMOTAccounting Indicatornvarchar20
25MWXMSEGZMSEG: Interface for Posting of Value178BEMOTAccounting Indicatornvarchar20
26MWZMSEGZMSEG:Interface for Posting of Value179BEMOTAccounting Indicatornvarchar20
TOPLease Accounting
27LAE_CRM_ITEMSLAE: Contract Items55BEMOTAccounting Indicatornvarchar20
TOPMaintenance History
28/OLC/PMCO_OPOLC: PMCO for operations11BEMOTAccounting Indicatornvarchar20
29PMCOCost structure of maintenance order11BEMOTAccounting Indicatornvarchar20
30PMCO_OPCost structure of maintenance order11BEMOTAccounting Indicatornvarchar20
TOPMaintenance Orders
31PMCOQTQuantity structure for the maintenance order12BEMOTAccounting Indicatornvarchar20
32PMCOQT_OPQuantity structure for the maintenance order12BEMOTAccounting Indicatornvarchar20
TOPOverhead Cost Controlling
33COINT_TPOST_HDControlling Integration: Reposting: Header Data5BEMOTAccounting Indicatornvarchar20
TOPOverhead Cost Orders
34AUFKOrder master data88BEMOTAccounting Indicatornvarchar20
TOPProfitability Analysis
35TKB9GPA Transfer Structure: Source10BEMOTAccounting Indicatornvarchar20
TOPRepetitive Manufacturing
36COMPMOVEGoods Movement of Components233BEMOTAccounting Indicatornvarchar20
TOPReporting
37PMCOCKFCost/Quantity structure: Customer-specific key figs (PMIS)4BEMOTAccounting Indicatornvarchar20
TOPRevenue recognition
38VBREVERevenue Recognition: Revenue Recognition Lines20BEMOTAccounting Indicatornvarchar20
TOPRevenues and Earnings
39AD01DLIDynamic items (DI)19BEMOTAccounting Indicatornvarchar20
40AD01DLIEFDI flow: Individual flow15BEMOTAccounting Indicatornvarchar20
41VPKDLISales Pricing Dynamic Items5BEMOTAccounting Indicatornvarchar20
TOPSales
42VBKDSales Document: Business Data67BEMOTAccounting Indicatornvarchar20
TOPSimulation
43VSAUFK_CNVersion: Order master data89BEMOTAccounting Indicatornvarchar20
44VSVBKD_CNVersion: Sales document - commercial data68BEMOTAccounting Indicatornvarchar20
TOPTime Sheet
45CATSCOCross-Application Time Sheet (CATS): Transfer to CO36BEMOTAccounting Indicatornvarchar20
46CATSDBCATS: Database Table for Time Sheet60BEMOTAccounting Indicatornvarchar20
47CATSPMCross-Application Time Sheet (CATS): Transfer to PM/CS30BEMOTAccounting Indicatornvarchar20
48CATSPSCross-Application Time Sheet (CATS): Transfer to PS30BEMOTAccounting Indicatornvarchar20
49CATS_TEMPCATS: Database Table for Templates62BEMOTAccounting Indicatornvarchar20