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

51 columns | Print definition?ERP 6.0  | LOESCHZ

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1TDM12Attribute Short/Long Name15LOESCHZDeletion Indicatornvarchar10
2TDM19Specialization category12LOESCHZDeletion Indicatornvarchar10
3TDM20Specialization18LOESCHZDeletion Indicatornvarchar10
4TDM25Assign Entities to Data Element11LOESCHZDeletion Indicatornvarchar10
5TDM26Specialization Category: Short/Long Name11LOESCHZDeletion Indicatornvarchar10
6TFM01Process10LOESCHZDeletion Indicatornvarchar10
7TFM02Process Long Name12LOESCHZDeletion Indicatornvarchar10
8TFM03Basic Function11LOESCHZDeletion Indicatornvarchar10
9TFM05Process-Function Assignment12LOESCHZDeletion Indicatornvarchar10
10TFM06Process-Function-Entity Assignment17LOESCHZDeletion Indicatornvarchar10
11TFM07Event Type10LOESCHZDeletion Indicatornvarchar10
12TFM08Event Type Long Name12LOESCHZDeletion Indicatornvarchar10
13TFM09Process-Function-Event Type Assignment15LOESCHZDeletion Indicatornvarchar10
14TFM10Entity-Event Type Assignment12LOESCHZDeletion Indicatornvarchar10
15TFM11Relationships Between Functions13LOESCHZDeletion Indicatornvarchar10
16TFM12Function Relationships of a Hierarchy Type17LOESCHZDeletion Indicatornvarchar10
17TFM13EFM Function Hierarchies13LOESCHZDeletion Indicatornvarchar10
18TFM16Function-Entity Assignment15LOESCHZDeletion Indicatornvarchar10
TOPBusiness Navigator
19TFM04Function Long Name13LOESCHZDeletion Indicatornvarchar10
20TFM14Hierarchy - Short and Long Name7LOESCHZDeletion Indicatornvarchar10
TOPData Modeler
21DM02LDM Entity Type18LOESCHZDeletion Indicatornvarchar10
22DM02SDM Entity Type Definition Variant13LOESCHZDeletion Indicatornvarchar10
23DM02TDM Entity Type Short Text9LOESCHZDeletion Indicatornvarchar10
24DM03SDM Attribute17LOESCHZDeletion Indicatornvarchar10
25DM25LDM View-Entity Type Assignment11LOESCHZDeletion Indicatornvarchar10
26DM26LDM Table-Entity Type Assignment11LOESCHZDeletion Indicatornvarchar10
27DM40LDM Data Model19LOESCHZDeletion Indicatornvarchar10
28DM41SDM Data Model Hierarchy16LOESCHZDeletion Indicatornvarchar10
29DM42SDM Relationship17LOESCHZDeletion Indicatornvarchar10
30DM42TDM Relationship Short Text11LOESCHZDeletion Indicatornvarchar10
31DM45LDM Specialization Category14LOESCHZDeletion Indicatornvarchar10
32DM45TDM Short text for specialization type9LOESCHZDeletion Indicatornvarchar10
33DM46SDM Specialization11LOESCHZDeletion Indicatornvarchar10
34DM48LDM Area11LOESCHZDeletion Indicatornvarchar10
35DM48TDM Area Short Text8LOESCHZDeletion Indicatornvarchar10
36TDI01Entity Type - View Assignment12LOESCHZDeletion Indicatornvarchar10
37TDM02Assignment of Entities to SAP Tables11LOESCHZDeletion Indicatornvarchar10
38TDM03Entity Short/Long Name13LOESCHZDeletion Indicatornvarchar10
39TDM04Entity Type17LOESCHZDeletion Indicatornvarchar10
40TDM05Data Model Short/Long Name11LOESCHZDeletion Indicatornvarchar10
41TDM06Data Model10LOESCHZDeletion Indicatornvarchar10
42TDM07Assignment of Entities to Data Models14LOESCHZDeletion Indicatornvarchar10
43TDM08Relationships Between Entities20LOESCHZDeletion Indicatornvarchar10
44TDM09Entity Attributes19LOESCHZDeletion Indicatornvarchar10
45TDM13Attributes of entity types, assignment of data elements19LOESCHZDeletion Indicatornvarchar10
46TDM21Entity Specialization Category14LOESCHZDeletion Indicatornvarchar10
47TDM22Entity Specialization Category Text13LOESCHZDeletion Indicatornvarchar10
48TDM23Assign Specialization Category to Target Entity14LOESCHZDeletion Indicatornvarchar10
49TDM27EDM Cluster: Short/Long Name11LOESCHZDeletion Indicatornvarchar10
50TDM28EDM Clusters10LOESCHZDeletion Indicatornvarchar10
51TDM29EDM Cluster Assignment: Data Model-Entity Type13LOESCHZDeletion Indicatornvarchar10