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

75 columns | Print definition?ERP 6.0  | FSTDATE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1TDM12Attribute Short/Long Name10FSTDATEDate on which the record was creatednvarchar80
2TDM19Specialization category7FSTDATEDate on which the record was creatednvarchar80
3TDM20Specialization13FSTDATEDate on which the record was creatednvarchar80
4TDM25Assign Entities to Data Element6FSTDATEDate on which the record was creatednvarchar80
5TDM26Specialization Category: Short/Long Name6FSTDATEDate on which the record was creatednvarchar80
6TDM99User Authorization for EDM Tool8FSTDATEDate on which the record was creatednvarchar80
7TFM01Process5FSTDATEDate on which the record was creatednvarchar80
8TFM02Process Long Name7FSTDATEDate on which the record was creatednvarchar80
9TFM03Basic Function6FSTDATEDate on which the record was creatednvarchar80
10TFM05Process-Function Assignment7FSTDATEDate on which the record was creatednvarchar80
11TFM06Process-Function-Entity Assignment12FSTDATEDate on which the record was creatednvarchar80
12TFM07Event Type5FSTDATEDate on which the record was creatednvarchar80
13TFM08Event Type Long Name7FSTDATEDate on which the record was creatednvarchar80
14TFM09Process-Function-Event Type Assignment10FSTDATEDate on which the record was creatednvarchar80
15TFM10Entity-Event Type Assignment7FSTDATEDate on which the record was creatednvarchar80
16TFM11Relationships Between Functions8FSTDATEDate on which the record was creatednvarchar80
17TFM12Function Relationships of a Hierarchy Type12FSTDATEDate on which the record was creatednvarchar80
18TFM13EFM Function Hierarchies8FSTDATEDate on which the record was creatednvarchar80
19TFM16Function-Entity Assignment10FSTDATEDate on which the record was creatednvarchar80
TOPASAP Tools and Contents
20SMAPBP0Solution Map: Best Practice5FSTDATEDate on which the record was creatednvarchar80
21SMAPCOMP0Solution Map: Component7FSTDATEDate on which the record was creatednvarchar80
22SMAPPA0Solution Map: Partner product10FSTDATEDate on which the record was creatednvarchar80
23SMAPPD0Solution Map: Product information8FSTDATEDate on which the record was creatednvarchar80
24SMAPPI0Solution Map: Performance Indicator (Header)3FSTDATEDate on which the record was creatednvarchar80
25SMAPPR0Solution Map: Process category, main process, process18FSTDATEDate on which the record was creatednvarchar80
TOPBusiness Navigator
26DF03LEvents4FSTDATEDate on which the record was creatednvarchar80
27DF04LSoftware Modules/Functions4FSTDATEDate on which the record was creatednvarchar80
28DF06LInformation flow4FSTDATEDate on which the record was creatednvarchar80
29DF07LObject Types4FSTDATEDate on which the record was creatednvarchar80
30DF08LALE Messages4FSTDATEDate on which the record was creatednvarchar80
31DF10LALE Message Flows4FSTDATEDate on which the record was creatednvarchar80
32DF11LScenario Processes4FSTDATEDate on which the record was creatednvarchar80
33DF12LOrganizational Units4FSTDATEDate on which the record was creatednvarchar80
34DF13LEnterprise areas4FSTDATEDate on which the record was creatednvarchar80
35DF14LApplication Components4FSTDATEDate on which the record was creatednvarchar80
36DF15LCommunication Relationships4FSTDATEDate on which the record was creatednvarchar80
37DF16LGroups4FSTDATEDate on which the record was creatednvarchar80
38DF17LAny BE object with no specific attributes3FSTDATEDate on which the record was creatednvarchar80
39DF18LCollaborative Business Scenario4FSTDATEDate on which the record was creatednvarchar80
40DF32SAssignment of IMG chapters to functions11FSTDATEDate on which the record was creatednvarchar80
41DF33SCustomizing assignment to modeling10FSTDATEDate on which the record was creatednvarchar80
42DF40DDiagam Management Information6FSTDATEDate on which the record was creatednvarchar80
43DF50LVariants6FSTDATEDate on which the record was creatednvarchar80
44DF52LFilter6FSTDATEDate on which the record was creatednvarchar80
45DF55LVariants5FSTDATEDate on which the record was creatednvarchar80
46TFM04Function Long Name8FSTDATEDate on which the record was creatednvarchar80
TOPData Modeler
47DM02LDM Entity Type13FSTDATEDate on which the record was creatednvarchar80
48DM02SDM Entity Type Definition Variant8FSTDATEDate on which the record was creatednvarchar80
49DM03SDM Attribute12FSTDATEDate on which the record was creatednvarchar80
50DM25LDM View-Entity Type Assignment6FSTDATEDate on which the record was creatednvarchar80
51DM26LDM Table-Entity Type Assignment6FSTDATEDate on which the record was creatednvarchar80
52DM40LDM Data Model14FSTDATEDate on which the record was creatednvarchar80
53DM41SDM Data Model Hierarchy11FSTDATEDate on which the record was creatednvarchar80
54DM42SDM Relationship12FSTDATEDate on which the record was creatednvarchar80
55DM45LDM Specialization Category9FSTDATEDate on which the record was creatednvarchar80
56DM46SDM Specialization6FSTDATEDate on which the record was creatednvarchar80
57DM48LDM Area6FSTDATEDate on which the record was creatednvarchar80
58DM99LDM User Settings7FSTDATEDate on which the record was creatednvarchar80
59TDI01Entity Type - View Assignment7FSTDATEDate on which the record was creatednvarchar80
60TDM02Assignment of Entities to SAP Tables6FSTDATEDate on which the record was creatednvarchar80
61TDM03Entity Short/Long Name8FSTDATEDate on which the record was creatednvarchar80
62TDM04Entity Type12FSTDATEDate on which the record was creatednvarchar80
63TDM05Data Model Short/Long Name6FSTDATEDate on which the record was creatednvarchar80
64TDM06Data Model5FSTDATEDate on which the record was creatednvarchar80
65TDM07Assignment of Entities to Data Models9FSTDATEDate on which the record was creatednvarchar80
66TDM08Relationships Between Entities15FSTDATEDate on which the record was creatednvarchar80
67TDM09Entity Attributes14FSTDATEDate on which the record was creatednvarchar80
68TDM10Assignment Synonyms-Entity5FSTDATEDate on which the record was creatednvarchar80
69TDM13Attributes of entity types, assignment of data elements14FSTDATEDate on which the record was creatednvarchar80
70TDM21Entity Specialization Category9FSTDATEDate on which the record was creatednvarchar80
71TDM22Entity Specialization Category Text8FSTDATEDate on which the record was creatednvarchar80
72TDM23Assign Specialization Category to Target Entity9FSTDATEDate on which the record was creatednvarchar80
73TDM27EDM Cluster: Short/Long Name6FSTDATEDate on which the record was creatednvarchar80
74TDM28EDM Clusters5FSTDATEDate on which the record was creatednvarchar80
75TDM29EDM Cluster Assignment: Data Model-Entity Type8FSTDATEDate on which the record was creatednvarchar80