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

61 columns | Print definition?ERP 6.0  | PROGDATE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/SDF/ZQLMLSQL Monitor: LREF4PROGDATEDate of Program (SDATE)nvarchar80
2CMS_BLK_APPL_PARTemporaray table for application parameters of Blocking3PROGDATEDate of Program Runnvarchar80
3DVM_BOF_RUNSBusiness Objects Footprint runs4PROGDATEnvarchar80
4FARR_D_PP_LOCKEDMass Processing: Locked RAIs per Mass Rund ID3PROGDATEDate of Program Runnvarchar80
5FARR_PPRUNRevenue Accounting: Mass Run Logs3PROGDATEDate of Program Runnvarchar80
6FARR_PPRUNSELRevenue Accounting: Selection Parameters of a Mass Run3PROGDATEDate of Program Runnvarchar80
7GRACPPFILTERRNGGlobal Application Parameter for Risk Analysis PPF.3PROGDATEDate of Program Runnvarchar80
8GRACPPJOBSBatch Processing Jobs.3PROGDATEDate of Program Runnvarchar80
9GRACPPOBJATTGlobal Application Parameter for Risk Analysis PPF.3PROGDATEDate of Program Runnvarchar80
10GRACPPOBJRNGGlobal Application Parameter for Risk Analysis PPF.3PROGDATEDate of Program Runnvarchar80
11GRACPPPARAMGlobal Application Parameter for Risk Analysis PPF.3PROGDATEDate of Program Runnvarchar80
12GRACPPRSRNGGlobal Application Parameter for Risk Analysis PPF.3PROGDATEDate of Program Runnvarchar80
13GRACPPSYSRNGGlobal Application Parameter for Risk Analysis PPF.3PROGDATEDate of Program Runnvarchar80
14SQLMHCISQL Monitor: Source Info14PROGDATESQL Monitor: Program Datenvarchar80
15SQLMHCKSQL Monitor: KEY12PROGDATESQL Monitor: Program Datenvarchar80
16SQLMHCLSQL Monitor: LREF4PROGDATEDate of Program (SDATE)nvarchar80
17SQLMLSQL Monitor: LREF4PROGDATEDate of Program (SDATE)nvarchar80
18SQLMSHCISQL Monitor: Source Info / Snapshot15PROGDATESQL Monitor: Program Datenvarchar80
19SQLMZISQL Monitor: Info & Key16PROGDATESQL Monitor: Program Datenvarchar80
20SRTMP_PROGRuntime Monitoring: Program Table5PROGDATEDate of Program (SDATE)nvarchar80
TOPAccounting Interface
21GLE_ECS_DI_ADM0Management of ECS Direct Input17PROGDATEDate of Program Runnvarchar80
22GLE_RUNADM_IDERP Run Administration21PROGDATEDate of Program Runnvarchar80
TOPBatch-Oriented Parallel Processing of Mass Data
23BANK_PPDEMOPARAMMass Run Parameters for Demonstration3PROGDATEDate of Program Runnvarchar80
24BANK_PPDEMO_ORGMass Run Parameters for Demonstration3PROGDATEDate of Program Runnvarchar80
25BANK_PP_PARDESCDescription of the Parameter Structure of the Application3PROGDATEDate of Program Runnvarchar80
26BANK_PP_PARUNData for Current Runs of an Application Process3PROGDATEDate of Program Runnvarchar80
27BANK_PP_PARUNHDGeneral Data on Mass Runs (Header)3PROGDATEDate of Program Runnvarchar80
28BANK_PP_PARUNKEYKey Assignment for Processes in Parallel Processing3PROGDATEDate of Program Runnvarchar80
29BANK_PP_PARVALSParameter Values of an Application3PROGDATEDate of Program Runnvarchar80
30BANK_PP_RUN_LOGLogs Generated During a Mass Run3PROGDATEDate of Program Runnvarchar80
31BANK_PP_STEPDATAData for Processing Steps of a Parallel Mass Run3PROGDATEDate of Program Runnvarchar80
32BANK_PP_TECHSETTechnical Parameters for Parallel Processing3PROGDATEDate of Program Runnvarchar80
33BANK_PP_THREADData on Processes in Parallel Processing4PROGDATEDate of Program Runnvarchar80
34BANK_REPORTSReport on Process7PROGDATEDate of Program Runnvarchar80
35PPF_TST_APPLPARMApplication Parameters of PPF Test Application3PROGDATEDate of Program Runnvarchar80
36PPF_TST_HISTORYHistory Data for Mass Runs5PROGDATEDate of Program Runnvarchar80
37PPF_TST_ORG_RUNOrg. Units of a Mass Run for Processing3PROGDATEDate of Program Runnvarchar80
TOPCalculations
38CMS_BII_PP_OBFLTCMS-Basel II: Data Extr. Appl Params for Parall.Proc Obj Flt4PROGDATEDate of Program Runnvarchar80
TOPCondition
39BKK92Account Balancing (Interest and Charges)36PROGDATERun Date of Programnvarchar80
TOPIncentive and Commission Management ICM
40FPP_RUNSRun Data for Parallel Processing15PROGDATEDate of Program Runnvarchar80
TOPInformation System
41CMS_BII_PP_APOFLCMS-Basel II: Data Extr. Appl Params for Parall.Proc Obj Flt3PROGDATEDate of Program Runnvarchar80
42CMS_BII_PP_APPLPCMS-Basel II: Data Extr. Application Params for Parall. Proc3PROGDATEDate of Program Runnvarchar80
43CMS_BII_PP_AP_PRCMS-Basel II: Data Extr. Appl Params for Parall.Proc Dex Set3PROGDATEDate of Program Runnvarchar80
TOPInterestCharge Calculation
44BKKM1BCA: Bank Statement Data22PROGDATERun Date of Programnvarchar80
45BKKM3BCA: Parameters for Mass Runs in Parallel Processing3PROGDATERun Date of Programnvarchar80
46BKKMACCUNRBlocked Objects of a Mass Run3PROGDATERun Date of Programnvarchar80
47BKKMDISPHDHeader Data for Dispatcher15PROGDATERun Date of Programnvarchar80
48BKKMHEADERHeader data for parallel processing (temporary data)3PROGDATERun Date of Programnvarchar80
49BKKMHEADERCURRFlow data for interval scheduling (parallel processing)3PROGDATERun Date of Programnvarchar80
50BKKMINTERVInterval data for parallel processing (temporary data)3PROGDATERun Date of Programnvarchar80
51BKKMPABANKAREABank Areas in Parallel Processing3PROGDATERun Date of Programnvarchar80
52BKKMPABANKAREAHDBank Areas in Parallel Processing (Header Data)3PROGDATERun Date of Programnvarchar80
53BKKMPARUNData for Current Runs of an Application Process3PROGDATERun Date of Programnvarchar80
54BKKMPARUNHDGeneral Data for Mass Runs (Header)3PROGDATERun Date of Programnvarchar80
55BKKMPARUNKEYSKey Issue for Processes in Parallel Processing3PROGDATERun Date of Programnvarchar80
56BKKMPARUNOBJGRPObject Groups per Mass Run3PROGDATERun Date of Programnvarchar80
57BKKMREPCURRData for End of Day Processing Reports11PROGDATERun Date of Programnvarchar80
58BKKMREPORTSData for End of Day Processing Reports12PROGDATERun Date of Programnvarchar80
59BKKMRESTObjects of a Mass Run for Postprocessing3PROGDATERun Date of Programnvarchar80
60BKKMWORKObjects of a Mass Run being Edited3PROGDATERun Date of Programnvarchar80
TOPSyntax, Compiler, Runtime
61SRTM_PROGRuntime Monitoring: Program Table3PROGDATEDate of Program (SDATE)nvarchar80