SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

www.saptables.net

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
1BBP_PD_XML8Table for Persistent Class CL_XML_PPF_BBP
2FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
3/ISDFPS/CHVW_E34External Batch Where-Used List
4FMARCPAR4Parallelization of FMARC_BATCH
5CEKRS5Movement type parameters for automatic ERS
6/1RA/0SD010MI170Items for Class SD01 - Raw Data
7/ATL/AANLCP79Periodic Asset-value fields, like anlc, for all areas
8BSEG345Accounting Document Segment
9AUDLORIPR7KPro: Logical Information Object Attribute Values
10/OPT/Z1344Reporting table: Text table for exception definitions

B1 9.2: Top 10 requests

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

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2OINV268A/R Invoice
3OVPM154Outgoing Payments
4ORCT154Incoming Payment
5OPCH268A/P Invoice
6OIVL77Whse Journal
7OOCR9Loading Factors
8OSRN20Serial Numbers Master Data
9JDT1110Journal Entry - Rows
10OBOT10Bill Of Exchang Transaction
PHPRef.com - the webs number one PHP Function reference tool

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