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

89 columns | Print definition?ERP 6.0  | LSTUSER

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1TDM12Attribute Short/Long Name12LSTUSERChanged bynvarchar120
2TDM19Specialization category9LSTUSERChanged bynvarchar120
3TDM20Specialization15LSTUSERChanged bynvarchar120
4TDM25Assign Entities to Data Element8LSTUSERChanged bynvarchar120
5TDM26Specialization Category: Short/Long Name8LSTUSERChanged bynvarchar120
6TFM01Process7LSTUSERChanged bynvarchar120
7TFM02Process Long Name9LSTUSERChanged bynvarchar120
8TFM03Basic Function8LSTUSERChanged bynvarchar120
9TFM05Process-Function Assignment9LSTUSERChanged bynvarchar120
10TFM06Process-Function-Entity Assignment14LSTUSERChanged bynvarchar120
11TFM07Event Type7LSTUSERChanged bynvarchar120
12TFM08Event Type Long Name9LSTUSERChanged bynvarchar120
13TFM09Process-Function-Event Type Assignment12LSTUSERChanged bynvarchar120
14TFM10Entity-Event Type Assignment9LSTUSERChanged bynvarchar120
15TFM11Relationships Between Functions10LSTUSERChanged bynvarchar120
16TFM12Function Relationships of a Hierarchy Type14LSTUSERChanged bynvarchar120
17TFM13EFM Function Hierarchies10LSTUSERChanged bynvarchar120
18TFM16Function-Entity Assignment12LSTUSERChanged bynvarchar120
TOPASAP AcceleratedSAP
19SPERSQADBPersonalization Table for Review Question Filter Values14LSTUSERChanged bynvarchar120
20SQACYCLECycles in Q&Adb7LSTUSERChanged bynvarchar120
21SQADB01Questions7LSTUSERChanged bynvarchar120
22SQADB04Reply10LSTUSERChanged bynvarchar120
23SQADBCATQuestion Categories5LSTUSERChanged bynvarchar120
24SQADBCONQuestion Contexts5LSTUSERChanged bynvarchar120
25SQAKONFQuestion Repository Configuration Groups5LSTUSERChanged bynvarchar120
TOPASAP Tools and Contents
26SMAPBP0Solution Map: Best Practice7LSTUSERChanged bynvarchar120
27SMAPCOMP0Solution Map: Component9LSTUSERChanged bynvarchar120
28SMAPPA0Solution Map: Partner product12LSTUSERChanged bynvarchar120
29SMAPPD0Solution Map: Product information10LSTUSERChanged bynvarchar120
30SMAPPI0Solution Map: Performance Indicator (Header)5LSTUSERChanged bynvarchar120
31SMAPPR0Solution Map: Process category, main process, process20LSTUSERChanged bynvarchar120
TOPBusiness Navigator
32DF03LEvents6LSTUSERChanged bynvarchar120
33DF04LSoftware Modules/Functions6LSTUSERChanged bynvarchar120
34DF06LInformation flow6LSTUSERChanged bynvarchar120
35DF07LObject Types6LSTUSERChanged bynvarchar120
36DF08LALE Messages6LSTUSERChanged bynvarchar120
37DF10LALE Message Flows6LSTUSERChanged bynvarchar120
38DF11LScenario Processes6LSTUSERChanged bynvarchar120
39DF12LOrganizational Units6LSTUSERChanged bynvarchar120
40DF13LEnterprise areas6LSTUSERChanged bynvarchar120
41DF14LApplication Components6LSTUSERChanged bynvarchar120
42DF15LCommunication Relationships6LSTUSERChanged bynvarchar120
43DF16LGroups6LSTUSERChanged bynvarchar120
44DF17LAny BE object with no specific attributes5LSTUSERChanged bynvarchar120
45DF18LCollaborative Business Scenario6LSTUSERChanged bynvarchar120
46DF32SAssignment of IMG chapters to functions13LSTUSERChanged bynvarchar120
47DF33SCustomizing assignment to modeling12LSTUSERChanged bynvarchar120
48DF40DDiagam Management Information8LSTUSERChanged bynvarchar120
49DF50DVariant diagram radio button7LSTUSERChanged bynvarchar120
50DF50LVariants8LSTUSERChanged bynvarchar120
51DF52LFilter8LSTUSERChanged bynvarchar120
52DF55LVariants7LSTUSERChanged bynvarchar120
53TFM04Function Long Name10LSTUSERChanged bynvarchar120
TOPData Modeler
54DM02LDM Entity Type15LSTUSERChanged bynvarchar120
55DM02SDM Entity Type Definition Variant10LSTUSERChanged bynvarchar120
56DM02TDM Entity Type Short Text6LSTUSERChanged bynvarchar120
57DM03SDM Attribute14LSTUSERChanged bynvarchar120
58DM25LDM View-Entity Type Assignment8LSTUSERChanged bynvarchar120
59DM26LDM Table-Entity Type Assignment8LSTUSERChanged bynvarchar120
60DM40LDM Data Model16LSTUSERChanged bynvarchar120
61DM40TDM Data Model Short Text5LSTUSERChanged bynvarchar120
62DM41SDM Data Model Hierarchy13LSTUSERChanged bynvarchar120
63DM42SDM Relationship14LSTUSERChanged bynvarchar120
64DM42TDM Relationship Short Text8LSTUSERChanged bynvarchar120
65DM43TDM Entity Type Aliases6LSTUSERChanged bynvarchar120
66DM45LDM Specialization Category11LSTUSERChanged bynvarchar120
67DM45TDM Short text for specialization type6LSTUSERChanged bynvarchar120
68DM46SDM Specialization8LSTUSERChanged bynvarchar120
69DM48LDM Area8LSTUSERChanged bynvarchar120
70DM48TDM Area Short Text5LSTUSERChanged bynvarchar120
71DM50SDM ADW Position7LSTUSERChanged bynvarchar120
72DM99LDM User Settings9LSTUSERChanged bynvarchar120
73TDI01Entity Type - View Assignment9LSTUSERChanged bynvarchar120
74TDM02Assignment of Entities to SAP Tables8LSTUSERChanged bynvarchar120
75TDM03Entity Short/Long Name10LSTUSERChanged bynvarchar120
76TDM04Entity Type14LSTUSERChanged bynvarchar120
77TDM05Data Model Short/Long Name8LSTUSERChanged bynvarchar120
78TDM06Data Model7LSTUSERChanged bynvarchar120
79TDM07Assignment of Entities to Data Models11LSTUSERChanged bynvarchar120
80TDM08Relationships Between Entities17LSTUSERChanged bynvarchar120
81TDM09Entity Attributes16LSTUSERChanged bynvarchar120
82TDM13Attributes of entity types, assignment of data elements16LSTUSERChanged bynvarchar120
83TDM21Entity Specialization Category11LSTUSERChanged bynvarchar120
84TDM22Entity Specialization Category Text10LSTUSERChanged bynvarchar120
85TDM23Assign Specialization Category to Target Entity11LSTUSERChanged bynvarchar120
86TDM27EDM Cluster: Short/Long Name8LSTUSERChanged bynvarchar120
87TDM28EDM Clusters7LSTUSERChanged bynvarchar120
88TDM29EDM Cluster Assignment: Data Model-Entity Type10LSTUSERChanged bynvarchar120
TOPQuestion Answer Database
89SCQADBQuestionnaire Header Entry13LSTUSERChanged bynvarchar120