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
9OVTG52Tax Definition
10OPOR386Purchase Order

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

47 columns | Print definition?ERP 6.0  | ARCHIVE_FLUD

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/IBS/TRB_ECF_HDRBD ECF - Value Adjustment Header Data43ARCHIVE_FLUDResubmission Datenvarchar80
2/IBS/TRB_ECH_HDRBD ECF - Value Adjustment History - Header Data44ARCHIVE_FLUDResubmission Datenvarchar80
3CMS_ARC_CAGCAG Archiving table7ARCHIVE_FLUDResubmission Datenvarchar80
4CMS_ARC_INSInsurance Archiving table8ARCHIVE_FLUDResubmission Datenvarchar80
5CMS_ARC_MOVABLESMovables Archiving Table8ARCHIVE_FLUDResubmission Datenvarchar80
6CMS_ARC_RBLReceivables Archiving Table7ARCHIVE_FLUDResubmission Datenvarchar80
7CMS_ARC_RE_OBJReal Estate Archiving Table7ARCHIVE_FLUDResubmission Datenvarchar80
8CMS_ARC_RIGRightsArchiving table: Includes claims and patents also8ARCHIVE_FLUDResubmission Datenvarchar80
9CMS_ARC_SEC_ACCSecurities Account Archiving Table7ARCHIVE_FLUDResubmission Datenvarchar80
10CMS_ARC_SHPShip Archiving Table7ARCHIVE_FLUDResubmission Datenvarchar80
TOPAccounting Interface
11GLE_ECS_DI_ADM0Management of ECS Direct Input13ARCHIVE_FLUDResubmission Datenvarchar80
12GLE_ECS_ITEMECS: Error Correction Items36ARCHIVE_FLUDResubmission Datenvarchar80
13GLE_RUNADM_IDERP Run Administration19ARCHIVE_FLUDResubmission Datenvarchar80
TOPArchiving Engine
14TARCHFLIGHTArchiving Example: Flights16ARCHIVE_FLUDResubmission Datenvarchar80
15TARCHFLIGHTCONNArchiving Example: Flight Connections10ARCHIVE_FLUDResubmission Datenvarchar80
TOPBank Customer Accounts
16BKK_PRENOTEPrenotes47ARCHIVE_FLUDResubmission Datenvarchar80
TOPClaims Management
17ICLCCEVENTClaim Bundle46ARCHIVE_FLUDResubmission Datenvarchar80
18ICLCLAIMClaim96ARCHIVE_FLUDResubmission Datenvarchar80
19ICLINDRESReserve Lot14ARCHIVE_FLUDResubmission Datenvarchar80
20ICLSERVCATFS-CM: Benefits/Services/Fees Catalogs43ARCHIVE_FLUDResubmission Datenvarchar80
21ICLSUBCLSubclaim51ARCHIVE_FLUDResubmission Datenvarchar80
22ICSCCEVENTShadow Table Claim Bundle46ARCHIVE_FLUDResubmission Datenvarchar80
23ICSCLAIMClaim96ARCHIVE_FLUDResubmission Datenvarchar80
24ICSSUBCLSubclaim51ARCHIVE_FLUDResubmission Datenvarchar80
25IMP_WORKSETSIMP: Workset17ARCHIVE_FLUDResubmission Datenvarchar80
TOPCorrespondence Tool
26DFKKCOHICorrespondence - Correspondence History40ARCHIVE_FLUDResubmission Datenvarchar80
27DFKKCOH_ARCFI-CA Correspondence - Correspondence Header5ARCHIVE_FLUDResubmission Datenvarchar80
TOPDefault Risk and Limit System
28KLFAZ01Facilities (Header)23ARCHIVE_FLUDResubmission Datenvarchar80
29KLSI01Collateral Provision (Header)21ARCHIVE_FLUDResubmission Datenvarchar80
TOPFinancial Conditions
30FICOT_AMTAmount Table (Obsolete; Not used for persistency)79ARCHIVE_FLUDResubmission Datenvarchar80
31FICOT_CONDIConditions (Unbuffered)121ARCHIVE_FLUDResubmission Datenvarchar80
32FICOT_CONDI_BUFFConditions (Buffered)121ARCHIVE_FLUDResubmission Datenvarchar80
33FICOT_DATEDate (Obsolete; Not used for persistency)59ARCHIVE_FLUDResubmission Datenvarchar80
TOPFramework for the Principle of Dual Control
34BCA_REL_LOG_HHeader Data of Log Table for Release7ARCHIVE_FLUDResubmission Datenvarchar80
TOPPostprocessing Office
35/SAPPO/ORDER_HDRPostprocessing Order - Header Data79ARCHIVE_FLUDnvarchar80
TOPRisk Analysis
36JBRDBKORM: DB Table Header Information Extended Risk Object27ARCHIVE_FLUDResubmission Datenvarchar80
37JBRHKORM: Version Table: Header Information: Extended Risk Object28ARCHIVE_FLUDResubmission Datenvarchar80
38JBROZRM Gap Opportunity Interest Rates from Single Trans. Costing7ARCHIVE_FLUDResubmission Datenvarchar80
39JBRSVGAPHD2RM: Header Data (Saved Gap Evaluation Results)49ARCHIVE_FLUDResubmission Datenvarchar80
TOPTransaction Data Pool
40JBDOBJ1Object Table for Financial Transactions, General Part34ARCHIVE_FLUDResubmission Datenvarchar80
41JBDVTBAVariable Transaction - Balances7ARCHIVE_FLUDResubmission Datenvarchar80
42JBDVTMDVariable transaction - master data20ARCHIVE_FLUDResubmission Datenvarchar80
43JBDVTTOVariable Transaction - Turnovers10ARCHIVE_FLUDResubmission Datenvarchar80
44JBDZSKOCash Flow Header33ARCHIVE_FLUDResubmission Datenvarchar80
45TJBD_VDARL_ARCHArchiving Status for Loans7ARCHIVE_FLUDResubmission Datenvarchar80
TOPValue Adjustment
46/IBS/TRB_SHEETHRBD IAS - Header Data of Valuation Sheet66ARCHIVE_FLUDResubmission Datenvarchar80
47/IBS/TRB_SHISTHRBD IAS - History Header Data Valuation Sheet67ARCHIVE_FLUDResubmission Datenvarchar80