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

50 columns | Print definition?ERP 6.0  | ARCHIVE_STATUS

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/IBS/TRB_ECF_HDRBD ECF - Value Adjustment Header Data42ARCHIVE_STATUSArchiving Statusnvarchar10
2/IBS/TRB_ECH_HDRBD ECF - Value Adjustment History - Header Data43ARCHIVE_STATUSArchiving Statusnvarchar10
3CMS_ARC_CAGCAG Archiving table6ARCHIVE_STATUSArchiving Statusnvarchar10
4CMS_ARC_INSInsurance Archiving table7ARCHIVE_STATUSArchiving Statusnvarchar10
5CMS_ARC_MOVABLESMovables Archiving Table7ARCHIVE_STATUSArchiving Statusnvarchar10
6CMS_ARC_RBLReceivables Archiving Table6ARCHIVE_STATUSArchiving Statusnvarchar10
7CMS_ARC_RE_OBJReal Estate Archiving Table6ARCHIVE_STATUSArchiving Statusnvarchar10
8CMS_ARC_RIGRightsArchiving table: Includes claims and patents also7ARCHIVE_STATUSArchiving Statusnvarchar10
9CMS_ARC_SEC_ACCSecurities Account Archiving Table6ARCHIVE_STATUSArchiving Statusnvarchar10
10CMS_ARC_SHPShip Archiving Table6ARCHIVE_STATUSArchiving Statusnvarchar10
TOPAccounting Interface
11GLE_ECS_DI_ADM0Management of ECS Direct Input12ARCHIVE_STATUSArchivability Statusnvarchar10
12GLE_ECS_ITEMECS: Error Correction Items35ARCHIVE_STATUSArchivability Statusnvarchar10
13GLE_RUNADM_IDERP Run Administration18ARCHIVE_STATUSArchivability Statusnvarchar10
TOPArchiving
14EABLARCInternal index f. analyzing archivable meter reading results4ARCHIVE_STATUSArchive Status of a Meter Reading Documentnvarchar10
15ERCHARCIndex for Archivable Billing Documents3ARCHIVE_STATUSDocument's archiving statusnvarchar10
TOPArchiving Engine
16TARCHFLIGHTArchiving Example: Flights15ARCHIVE_STATUSArchiving Statusnvarchar10
17TARCHFLIGHTCONNArchiving Example: Flight Connections9ARCHIVE_STATUSArchiving Statusnvarchar10
TOPBank Customer Accounts
18BKK_PRENOTEPrenotes46ARCHIVE_STATUSArchiving Statusnvarchar10
TOPClaims Management
19ICLCCEVENTClaim Bundle45ARCHIVE_STATUSArchiving Statusnvarchar10
20ICLCLAIMClaim95ARCHIVE_STATUSArchiving Statusnvarchar10
21ICLINDRESReserve Lot13ARCHIVE_STATUSArchiving Statusnvarchar10
22ICLSERVCATFS-CM: Benefits/Services/Fees Catalogs42ARCHIVE_STATUSArchiving Statusnvarchar10
23ICLSUBCLSubclaim50ARCHIVE_STATUSArchiving Statusnvarchar10
24ICSCCEVENTShadow Table Claim Bundle45ARCHIVE_STATUSArchiving Statusnvarchar10
25ICSCLAIMClaim95ARCHIVE_STATUSArchiving Statusnvarchar10
26ICSSUBCLSubclaim50ARCHIVE_STATUSArchiving Statusnvarchar10
27IMP_WORKSETSIMP: Workset16ARCHIVE_STATUSArchiving Statusnvarchar10
TOPCorrespondence Tool
28DFKKCOHICorrespondence - Correspondence History39ARCHIVE_STATUSArchiving Statusnvarchar10
29DFKKCOH_ARCFI-CA Correspondence - Correspondence Header4ARCHIVE_STATUSArchivability Statusnvarchar10
TOPDefault Risk and Limit System
30KLFAZ01Facilities (Header)22ARCHIVE_STATUSArchivability Statusnvarchar10
31KLSI01Collateral Provision (Header)20ARCHIVE_STATUSArchivability Statusnvarchar10
TOPFinancial Conditions
32FICOT_AMTAmount Table (Obsolete; Not used for persistency)78ARCHIVE_STATUSArchivability Statusnvarchar10
33FICOT_CONDIConditions (Unbuffered)120ARCHIVE_STATUSArchivability Statusnvarchar10
34FICOT_CONDI_BUFFConditions (Buffered)120ARCHIVE_STATUSArchivability Statusnvarchar10
35FICOT_DATEDate (Obsolete; Not used for persistency)58ARCHIVE_STATUSArchivability Statusnvarchar10
TOPFinancial Supply Chain Management
36BNK_BATCH_HEADERBatch Header24ARCHIVE_STATUSArchive Statusnvarchar20
TOPFramework for the Principle of Dual Control
37BCA_REL_LOG_HHeader Data of Log Table for Release6ARCHIVE_STATUSArchiving Statusnvarchar10
TOPPostprocessing Office
38/SAPPO/ORDER_HDRPostprocessing Order - Header Data78ARCHIVE_STATUSnvarchar10
TOPRisk Analysis
39JBRDBKORM: DB Table Header Information Extended Risk Object26ARCHIVE_STATUSArchivability Statusnvarchar10
40JBRHKORM: Version Table: Header Information: Extended Risk Object27ARCHIVE_STATUSArchivability Statusnvarchar10
41JBROZRM Gap Opportunity Interest Rates from Single Trans. Costing6ARCHIVE_STATUSArchivability Statusnvarchar10
42JBRSVGAPHD2RM: Header Data (Saved Gap Evaluation Results)48ARCHIVE_STATUSArchivability Statusnvarchar10
TOPTransaction Data Pool
43JBDOBJ1Object Table for Financial Transactions, General Part33ARCHIVE_STATUSArchivability Statusnvarchar10
44JBDVTBAVariable Transaction - Balances6ARCHIVE_STATUSArchivability Statusnvarchar10
45JBDVTMDVariable transaction - master data19ARCHIVE_STATUSArchivability Statusnvarchar10
46JBDVTTOVariable Transaction - Turnovers9ARCHIVE_STATUSArchivability Statusnvarchar10
47JBDZSKOCash Flow Header32ARCHIVE_STATUSArchivability Statusnvarchar10
48TJBD_VDARL_ARCHArchiving Status for Loans6ARCHIVE_STATUSArchivability Statusnvarchar10
TOPValue Adjustment
49/IBS/TRB_SHEETHRBD IAS - Header Data of Valuation Sheet65ARCHIVE_STATUSArchiving Statusnvarchar10
50/IBS/TRB_SHISTHRBD IAS - History Header Data Valuation Sheet66ARCHIVE_STATUSArchiving Statusnvarchar10