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

57 columns | Print definition?ERP 6.0  | PARNAME

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/XFT/EPAB_RMDEFRM Related Definitions3PARNAMERM Parameterstinyint30
2COM_IPC_PROP_ERPIPC Settings (User Interface, Scenario-Spec., User-Spec.)4PARNAMEParametersnvarchar500
3ECONDIPARAMParameter Definition of Conditional Application Structure4PARNAMEComponent namenvarchar300
4GRFNPARNAMEParameter Name2PARNAMEParameter Namenvarchar100
5GRFNPARNAMETParameter Name Description3PARNAMEParameter Namenvarchar100
6GRFNSUBSCEPARLKQuery Parameter Lookup4PARNAMEParameter Namenvarchar100
7GRFNUIBRTECHINFOTechnical Setting Lookup8PARNAMEParameter Namenvarchar100
8GRFNUIEOPARCFGObsolete4PARNAMEParameter Namenvarchar100
9HRP5341DB Table for Infotype 534118PARNAMEParameter Namenvarchar100
10HRP5344DB Table for Infotype 534418PARNAMEParameter Namenvarchar100
11RSCRMPARAMSRSCRM: Parameters for Report Interface2PARNAMEParameter Namenvarchar300
12SWNC_SETTINGSCollector Settings1PARNAMEParameter Namenvarchar300
TOPActivation Program, Conversion Program, DB Utility, MC, SPDD
13DDSPARStorage clause for tables and indexes7PARNAMESAP object namenvarchar300
14DDSPAR1Storage clause for tables and indexes7PARNAMESAP object namenvarchar300
15DDSPAR2Storage clause for tables and indexes7PARNAMESAP object namenvarchar300
16DDSTORAGEStorage clause for tables and indexes7PARNAMESAP object namenvarchar300
17DDSTORAGE1Storage clause for tables and indexes7PARNAMESAP object namenvarchar300
18DDSTORAGE2Storage clause for tables and indexes7PARNAMESAP object namenvarchar300
TOPBasis Application Log
19BALHDRPApplication log: log parameter4PARNAMEApplication log: Parametersnvarchar100
20BALMPApplication log: message parameter5PARNAMEApplication log: Parametersnvarchar100
TOPBW generation tool and quantity object
21ODQADMINParameter for Operational Delta Queue2PARNAMEParameter Namenvarchar300
TOPCross-Application Components
22CRMPAROLTPCRM OLTP Parameters2PARNAMEParameter Namenvarchar640
TOPData Staging
23RSBMLOGPARHierarchical Log: Field/Value Pair3PARNAMEApplication log: Parametersnvarchar100
24RSBMLOGPAR_DTPDTP Log: Field/Value Pairs6PARNAMEApplication log: Parametersnvarchar100
25RSDBSESPARLOCAL Database Parameters for BW that3PARNAMEName of an Initialization Parameter for a Databasenvarchar640
TOPDB2 Universal Database for UNIX NT
26DB6PMHCDMDB6: Database and Database Manager Parameter Changes5PARNAMEnvarchar300
TOPEnergy Data Management
27EEDMSETTLDOCPARVSettlement Document (Persistent Value Parameters)6PARNAMEName of Parameter for Settlement Stepsnvarchar150
28EEDMSETTLDOCUPDPSettlement Document (Updated Profiles)7PARNAMEName of Parameter for Settlement Stepsnvarchar150
29EEDMSETTLPARAMSettlement Parameter: Profiles and Values2PARNAMEName of Parameter for Settlement Stepsnvarchar150
30EEDMSETTLPARAMPSettlement Paramter: Definition of Reference Profiles2PARNAMEName of Parameter for Settlement Stepsnvarchar150
31EEDMSETTLPARAMTSettlement Parameter: Profiles and Values (Paramter Texts)2PARNAMEName of Parameter for Settlement Stepsnvarchar150
32EEDMSETTLPARAMVSettlement Paramter: Definition of Values2PARNAMEName of Parameter for Settlement Stepsnvarchar150
33EEDMSETTLPROCPASettlement Procedure (Procedure Parameters)5PARNAMEName of Parameter for Settlement Stepsnvarchar150
34EEDMSETTLSTEPPASettlement Steps (Parameters)5PARNAMEName of Settlement-Specific Parameternvarchar150
TOPGRC Process Control Plug-in
35/GRCPI/GRIABRPARAM - Technical Setting Parameter (Temp Storage for A Sync)3PARNAMEAM - Query Parameter Namenvarchar100
TOPIntercompany Data Exchange
36TINV_INV_LOGPARMLog Table - PARAMETER - for Bill Receipt Processing4PARNAMEApplication log: Parametersnvarchar100
TOPLegacy System Migration Workbench
37/SAPDMC/LSGBDCBI Name: "Code"9PARNAMEField Name (BI Recording)nvarchar300
TOPManagement Cockpit
38UMM_CUSTGeneral Customizing Settings2PARNAMEParameter Namenvarchar200
TOPMaster Data Distribution
39/ISDFPS/ALEOBJCDDFPS: Distributable Customer Appends for ALE Objects4PARNAMEParameter namenvarchar640
TOPMaxDB
40SDBPAHISAP DB: Parameter History1PARNAMESAP DB: Parameter Name in Parameter Historynvarchar640
TOPMicrosoft SQL Server
41MSSSTORAGEMSSQL-Specific Storage Parameters for Tables and Indexes7PARNAMESAP object namenvarchar300
TOPMonitoring
42SCSM_CHECK_ITFMapping Table: Adobe Forms ITF <-> RZ50 Checks1PARNAMEVariable Namenvarchar300
TOPPayroll
43T7ROG1EE register - ER history30PARNAME30 Charactersnvarchar300
44T7ROG5EE register - ER history19PARNAME30 Charactersnvarchar300
TOPPerformance Monitors TCC
45PAHIHistory of system, DB and SAP parameter5PARNAMEParameter namenvarchar640
TOPPrint and Output Management
46TSPUSROPTSpool: User-specific settings3PARNAMEParameter name for spool settingsnvarchar160
TOPProduct Cost Planning
47CMFPARError Management: Additional Parameters for Message6PARNAMEApplication log: Parametersnvarchar100
TOPProfile Maintenance
48TPFESPrototype: Table for profile parameters3PARNAMEProfile parameter namenvarchar600
49TPFETTable of profile parameters3PARNAMEProfile parameter namenvarchar600
TOPPublic Sector Contract Accounts Receivable and Payable
50DPSOB_UPDWNLOAD2Contract Object: Mapping Download2PARNAMEParameter Namenvarchar320
TOPSCM Basis
51CIFOBJINFOControl Table for APO-CIF Filter Objects, Client-Independent21PARNAMEParameter name of RANGE definednvarchar80
TOPUse Subcomponents
52TSOPASAPoffice: SET/GET Parameter1PARNAMESAPoffice: Parameter namenvarchar30
53TSOPTSAPoffice: Parameter Texts2PARNAMESAPoffice: Parameter namenvarchar30
TOPWorkbench Utilities
54SPAR_ASSParameter Storage: Assignment of Object to Parameter2PARNAMEParameter Storage: General namenvarchar600
55SPAR_DATAParameter Storage: Persistent Data Container3PARNAMEParameter Storage: General namenvarchar600
56SPAR_METHParameter Storage: Assignment Parameter->Method2PARNAMEParameter Storage: General namenvarchar600
57SPAR_SDATParameter Storage: Short data3PARNAMEParameter Storage: General namenvarchar600