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

47 columns | Print definition?ERP 6.0  | MODEL_ID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/IWFND/I_MGDPIMODC Control Table: "Data Provider Implementation Definition"1MODEL_IDMeta Model Identifiernvarchar400
2FMPEP_ADM_SVSession Variants administration8MODEL_IDMask ID for Easy Multiple Budget Entrynvarchar100
3FMPEP_UI_MODELDefine UI model for Multiple Budget Entry transaction2MODEL_IDMask ID for Easy Multiple Budget Entrynvarchar100
TOPBusiness Navigator
4DF33SCustomizing assignment to modeling5MODEL_IDUnique ID - 32 charactersnvarchar320
5DF35SAssignment of Customizing to modeling objects2MODEL_IDObject definitionnvarchar200
6DF36SDeselected assignments of Customizing to modeling objects2MODEL_IDObject definitionnvarchar200
TOPData Mining
7RSDMTC_ATTR_DTLAttribute Detail1MODEL_IDAnalytical Modelnvarchar300
8RSDMTC_ATTR_HEADAttribute Header1MODEL_IDAnalytical Modelnvarchar300
9RSDMTC_CLID_TEXTMean Header1MODEL_IDAnalytical Modelnvarchar300
10RSDMTC_DISTRIBUTDistribution of Attribute Values among a Cluster1MODEL_IDAnalytical Modelnvarchar300
11RSDMTC_MEAN_DTLMean Detail1MODEL_IDAnalytical Modelnvarchar300
12RSDMTC_MEAN_HEADMean Header1MODEL_IDAnalytical Modelnvarchar300
13RSDMTC_PMMLTable for Storing Model PMMLs in String Format1MODEL_IDAnalytical Modelnvarchar300
14RSDMTD_ATTRVALAttribute Value List1MODEL_IDAnalytical Modelnvarchar300
15RSDMTD_PMMLTable for Storing Model PMMLs in String Format1MODEL_IDAnalytical Modelnvarchar300
16RSDMTP_DSRC_BWDMining Source to Datasource Relation4MODEL_IDAnalytical Modelnvarchar300
TOPLine Maintenance
17/ISDFPS/CASMODCLCustomizing Confign Code Classes f. Model ID (Weapon System)2MODEL_IDModel ID/Weapon Systemnvarchar140
18/ISDFPS/LMEQEXTEnhancements to the Equipment Tables for Line Maintenance12MODEL_IDModel ID/Weapon Systemnvarchar140
19/ISDFPS/LMSITEEQSite Equipment in Line Maintenance Process6MODEL_IDModel ID/Weapon Systemnvarchar140
20/ISDFPS/LM_EINROperation Roles (Configuration Code)2MODEL_IDModel ID/Weapon Systemnvarchar140
21/ISDFPS/LM_EINRTOperation Roles (Configuration Code)3MODEL_IDModel ID/Weapon Systemnvarchar140
22/ISDFPS/LM_FLIFlight4MODEL_IDModel ID/Weapon Systemnvarchar140
TOPNetWeaver Enterprise Search
23ESH_OM_PC_EXEMPTPlausibility Check: Exemptions6MODEL_IDObject Typenvarchar200
TOPOrganizational Flexibility
24/ISDFPS/PM_TPCMPPartner Roles for Weapon System ID2MODEL_IDModel ID/Weapon Systemnvarchar140
TOPPersonnel Administration
25PA0515HR Master Record: Infotype 051545MODEL_IDModel ID for PLZLAnvarchar20
TOPRecords and Case Management
26RMPSE_SOA_RECDefine Record Types for Services6MODEL_IDUnique ID of Record Modelnvarchar640
TOPTag Library
27WCF_GMT_NMODELSNexus Data Models for use in the Flex Sandbox test app1MODEL_IDNexus Data Model IDnvarchar320
TOPUpgrade - General
28COMP_LAYERComponent Layering1MODEL_IDID of Layer Modelnvarchar100
TOPVisual Business
29VBCD_CNTXTModel context2MODEL_IDVisual Business Applicationnvarchar400
30VBCD_DATA_OBJData Objects2MODEL_IDVisual Business Applicationnvarchar400
31VBCD_MESSAGE_OBJMessage Objects2MODEL_IDVisual Business Applicationnvarchar400
32VBCD_MODELMain Visual Business Model2MODEL_IDVisual Business Applicationnvarchar400
33VBCD_MODEL_OBJMain Visual Business Model XML Streams2MODEL_IDVisual Business Applicationnvarchar400
34VBCD_PERSPersonalization2MODEL_IDVisual Business Applicationnvarchar400
35VBCD_TXT_OBJText Objects2MODEL_IDVisual Business Applicationnvarchar400
36VBCD_TXT_OBJ_TText Objects (language dependent texts)3MODEL_IDVisual Business Applicationnvarchar400
37VBCD_VISUAL_OBJVisual Objects2MODEL_IDVisual Business Applicationnvarchar400
TOPWithout Description
38RSDMESCGENERATEDGenerated Objects for Scoring Models1MODEL_IDAnalytical Modelnvarchar300
39RSDMTA_ASSRULESAssociation discovery rules table1MODEL_IDAnalytical Modelnvarchar300
40RSDMTA_CONDS_VARFilter conditions for association rules2MODEL_IDAnalytical Modelnvarchar300
41RSDMTA_DEPN_DETDepending items detail table1MODEL_IDAnalytical Modelnvarchar300
42RSDMTA_ENUM_INFOLIS table Information1MODEL_IDAnalytical Modelnvarchar300
43RSDMTA_LEAD_DETLeading items detail table1MODEL_IDAnalytical Modelnvarchar300
44RSDMTA_LISLarge Itemsets table1MODEL_IDAnalytical Modelnvarchar300
45RSDMTA_LIST_INFOLarge Itemests information1MODEL_IDAnalytical Modelnvarchar300
46RSDMTA_LIS_DETLIS detail table1MODEL_IDAnalytical Modelnvarchar300
47RSDMTA_TG_MAPItem mapping table1MODEL_IDAnalytical Modelnvarchar300