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
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

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

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
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

41 columns | Print definition?ERP 6.0  | CONSUMER

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/SDF/IVISEVTALTAlternative messages for DC event2CONSUMERType for IVIS IDsnvarchar360
2/SDF/IVISEVTFLOWFlow list for DC event2CONSUMERType for IVIS IDsnvarchar360
3/SDF/IVISEVTMAINEvents persistency2CONSUMERType for IVIS IDsnvarchar360
4/SDF/IVISEVTMWPRMiddleware properties for DC event2CONSUMERType for IVIS IDsnvarchar360
5/SDF/IVISEVTPATRUDS attributes for DC event2CONSUMERType for IVIS IDsnvarchar360
6/SDF/IVISEVTPREDPredecessor messages for DC event2CONSUMERType for IVIS IDsnvarchar360
7/SDF/IVISEVTRELRelated messages for DC event2CONSUMERType for IVIS IDsnvarchar360
8/SDF/IVISEVTSUCCSuccessor messages for DC event2CONSUMERType for IVIS IDsnvarchar360
9CMM_D_IDXCommodity Management: Index Table2CONSUMERIndex: Consumernvarchar40
TOPABAP Unit
10TAUNIT_PROG_INFOINTERNAL: Cache on test class meta data per program14CONSUMERActive / Inactivenvarchar10
TOPCross-Application Components
11AFQNAMESQueue Names8CONSUMERUser of R/3 Adaptor Functionalitynvarchar100
12BDOC_TRACKInformation on BDOCs During Load from CRM System/Back End6CONSUMERUser of R/3 Adaptor Functionalitynvarchar100
13CRMCONSUMPossible Users of R/3 Adapter Functionality2CONSUMERUser of R/3 Adaptor Functionalitynvarchar100
14CRMFILCONDTable for Temporary Saving of Filter Conditions2CONSUMERUser of R/3 Adaptor Functionalitynvarchar100
15CRMFILTABFilter Conditions for Download2CONSUMERUser of R/3 Adaptor Functionalitynvarchar100
16CRMMASSUPDMass Data Handling for Adapter Objects: Technical Settings2CONSUMERUser of R/3 Adaptor Functionalitynvarchar100
17CRMMASSUPD_ACTHistory Table, Activation/Deactivation of Mass Data Handling2CONSUMERUser of R/3 Adaptor Functionalitynvarchar100
18CRMMASSUPD_CUSSettings for Mass Data Handling2CONSUMERUser of R/3 Adaptor Functionalitynvarchar100
19CRMOBJECTDefinition of Download Objects (Corresponds to SMOFOBJECT)2CONSUMERUser of R/3 Adaptor Functionalitynvarchar100
20CRMOBJTABTables Belonging to One Object2CONSUMERUser of R/3 Adaptor Functionalitynvarchar100
21CRMPAROLTPCRM OLTP Parameters5CONSUMERUser of R/3 Adaptor Functionalitynvarchar100
22CRMQNAMESQueue Name Management for CRM-QRFC Supply2CONSUMERUser of R/3 Adaptor Functionalitynvarchar100
23CRMRELTABInformation for Reselection of Table Contents2CONSUMERUser of R/3 Adaptor Functionalitynvarchar100
24CRMRFCPARDefinitions for RFC Connections2CONSUMERUser of R/3 Adaptor Functionalitynvarchar100
25CRMSUBTABSubscription Table for Upload and Download Objects2CONSUMERUser of R/3 Adaptor Functionalitynvarchar100
TOPHR Administrative Services
26POBJC_CONSCASTYPCase type for Consumers2CONSUMERPOBJ Consumer IDnvarchar300
27POBJC_LEVELAllowed levels for a Consumer1CONSUMERPOBJ Consumer IDnvarchar300
28POBJC_LEVEL_TAllowable levels with text for a given consumer2CONSUMERPOBJ Consumer IDnvarchar300
29POBJC_LOGIC_ANCHList of Logical Anchors1CONSUMERPOBJ Consumer IDnvarchar300
30POBJC_LOG_ANCH_TDescription of Logical Anchor2CONSUMERPOBJ Consumer IDnvarchar300
31POBJC_PH2LOGANCHRelation of logical anchor to physical anchor1CONSUMERPOBJ Consumer IDnvarchar300
TOPIntegration Builder - Configuration
32SALERTRULECONPI Alerting: Alert Rules: Consumer3CONSUMERXI Alert: Alert Consumer Namenvarchar640
33SXICACHEXI Runtime: Cache Status Table2CONSUMERCache Consumer (Business System)nvarchar600
TOPLogistics - General
34CPCRMSTOCK1Define stock values on material level2CONSUMERUser of R/3 Adaptor Functionalitynvarchar100
35CPCRMSTOCK2Define stock values on material group level2CONSUMERUser of R/3 Adaptor Functionalitynvarchar100
36CPSTOCK_P_FILTERTable for Filtering the Allocation to Specific Plants2CONSUMERUser of R/3 Adaptor Functionalitynvarchar100
TOPMobile Materials Management
37/ISDFPS/MEMMTRQLCustomizing: Requisition Type for Document Cat. (Mobile)4CONSUMERManaged at Consumernvarchar10
TOPRuntime WorkbenchMonitoring
38SXMSALERTCONTENTPI Alerting: Alert Information3CONSUMERPI: Consumer of a PI Alertnvarchar640
TOPSales and Distribution
39CMSC_RFC_DES_QUECMS Table for storing RFC destination & que no range2CONSUMERUser of R/3 Adaptor Functionalitynvarchar100
TOPStatus and Action Management
40SAMDT_CONFIGS&AM DT Configuration1CONSUMERS&AM DT consumernvarchar300
TOPTalent Management
41T77TMC_SCA_MAPScale Mapping4CONSUMERScale Mapping: Scale Consumernvarchar10