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

82 columns | Print definition?ERP 6.0  | LSTDATE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1DFKKODNCHRODN: Chronological numbering last assigned number7LSTDATEDate of last number assignmentnvarchar80
2TDM12Attribute Short/Long Name13LSTDATEChanged onnvarchar80
3TDM19Specialization category10LSTDATEChanged onnvarchar80
4TDM20Specialization16LSTDATEChanged onnvarchar80
5TDM25Assign Entities to Data Element9LSTDATEChanged onnvarchar80
6TDM26Specialization Category: Short/Long Name9LSTDATEChanged onnvarchar80
7TFM01Process8LSTDATEChanged onnvarchar80
8TFM02Process Long Name10LSTDATEChanged onnvarchar80
9TFM03Basic Function9LSTDATEChanged onnvarchar80
10TFM05Process-Function Assignment10LSTDATEChanged onnvarchar80
11TFM06Process-Function-Entity Assignment15LSTDATEChanged onnvarchar80
12TFM07Event Type8LSTDATEChanged onnvarchar80
13TFM08Event Type Long Name10LSTDATEChanged onnvarchar80
14TFM09Process-Function-Event Type Assignment13LSTDATEChanged onnvarchar80
15TFM10Entity-Event Type Assignment10LSTDATEChanged onnvarchar80
16TFM11Relationships Between Functions11LSTDATEChanged onnvarchar80
17TFM12Function Relationships of a Hierarchy Type15LSTDATEChanged onnvarchar80
18TFM13EFM Function Hierarchies11LSTDATEChanged onnvarchar80
19TFM16Function-Entity Assignment13LSTDATEChanged onnvarchar80
TOPASAP Tools and Contents
20SMAPBP0Solution Map: Best Practice8LSTDATEChanged onnvarchar80
21SMAPCOMP0Solution Map: Component10LSTDATEChanged onnvarchar80
22SMAPPA0Solution Map: Partner product13LSTDATEChanged onnvarchar80
23SMAPPD0Solution Map: Product information11LSTDATEChanged onnvarchar80
24SMAPPI0Solution Map: Performance Indicator (Header)6LSTDATEChanged onnvarchar80
25SMAPPR0Solution Map: Process category, main process, process21LSTDATEChanged onnvarchar80
TOPBusiness Navigator
26DF03LEvents7LSTDATEChanged onnvarchar80
27DF04LSoftware Modules/Functions7LSTDATEChanged onnvarchar80
28DF06LInformation flow7LSTDATEChanged onnvarchar80
29DF07LObject Types7LSTDATEChanged onnvarchar80
30DF08LALE Messages7LSTDATEChanged onnvarchar80
31DF10LALE Message Flows7LSTDATEChanged onnvarchar80
32DF11LScenario Processes7LSTDATEChanged onnvarchar80
33DF12LOrganizational Units7LSTDATEChanged onnvarchar80
34DF13LEnterprise areas7LSTDATEChanged onnvarchar80
35DF14LApplication Components7LSTDATEChanged onnvarchar80
36DF15LCommunication Relationships7LSTDATEChanged onnvarchar80
37DF16LGroups7LSTDATEChanged onnvarchar80
38DF17LAny BE object with no specific attributes6LSTDATEChanged onnvarchar80
39DF18LCollaborative Business Scenario7LSTDATEChanged onnvarchar80
40DF32SAssignment of IMG chapters to functions14LSTDATEChanged onnvarchar80
41DF33SCustomizing assignment to modeling13LSTDATEChanged onnvarchar80
42DF40DDiagam Management Information9LSTDATEChanged onnvarchar80
43DF50LVariants9LSTDATEChanged onnvarchar80
44DF52LFilter9LSTDATEChanged onnvarchar80
45DF55LVariants8LSTDATEChanged onnvarchar80
46TFM04Function Long Name11LSTDATEChanged onnvarchar80
TOPContract Accounts Receivable and Payable
47TFK_EXTDOC_IT1Official Document Number Data Italy6LSTDATEDate of Last Number Assignmentnvarchar80
TOPData Modeler
48DM02LDM Entity Type16LSTDATEChanged onnvarchar80
49DM02SDM Entity Type Definition Variant11LSTDATEChanged onnvarchar80
50DM02TDM Entity Type Short Text7LSTDATEChanged onnvarchar80
51DM03SDM Attribute15LSTDATEChanged onnvarchar80
52DM25LDM View-Entity Type Assignment9LSTDATEChanged onnvarchar80
53DM26LDM Table-Entity Type Assignment9LSTDATEChanged onnvarchar80
54DM40LDM Data Model17LSTDATEChanged onnvarchar80
55DM40TDM Data Model Short Text6LSTDATEChanged onnvarchar80
56DM41SDM Data Model Hierarchy14LSTDATEChanged onnvarchar80
57DM42SDM Relationship15LSTDATEChanged onnvarchar80
58DM42TDM Relationship Short Text9LSTDATEChanged onnvarchar80
59DM43TDM Entity Type Aliases7LSTDATEChanged onnvarchar80
60DM45LDM Specialization Category12LSTDATEChanged onnvarchar80
61DM45TDM Short text for specialization type7LSTDATEChanged onnvarchar80
62DM46SDM Specialization9LSTDATEChanged onnvarchar80
63DM48LDM Area9LSTDATEChanged onnvarchar80
64DM48TDM Area Short Text6LSTDATEChanged onnvarchar80
65DM50SDM ADW Position8LSTDATEChanged onnvarchar80
66DM99LDM User Settings10LSTDATEChanged onnvarchar80
67TDI01Entity Type - View Assignment10LSTDATEChanged onnvarchar80
68TDM02Assignment of Entities to SAP Tables9LSTDATEChanged onnvarchar80
69TDM03Entity Short/Long Name11LSTDATEChanged onnvarchar80
70TDM04Entity Type15LSTDATEChanged onnvarchar80
71TDM05Data Model Short/Long Name9LSTDATEChanged onnvarchar80
72TDM06Data Model8LSTDATEChanged onnvarchar80
73TDM07Assignment of Entities to Data Models12LSTDATEChanged onnvarchar80
74TDM08Relationships Between Entities18LSTDATEChanged onnvarchar80
75TDM09Entity Attributes17LSTDATEChanged onnvarchar80
76TDM13Attributes of entity types, assignment of data elements17LSTDATEChanged onnvarchar80
77TDM21Entity Specialization Category12LSTDATEChanged onnvarchar80
78TDM22Entity Specialization Category Text11LSTDATEChanged onnvarchar80
79TDM23Assign Specialization Category to Target Entity12LSTDATEChanged onnvarchar80
80TDM27EDM Cluster: Short/Long Name9LSTDATEChanged onnvarchar80
81TDM28EDM Clusters8LSTDATEChanged onnvarchar80
82TDM29EDM Cluster Assignment: Data Model-Entity Type11LSTDATEChanged onnvarchar80