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
Financials :: Financial Supply Chain Management :: Treasury and Risk Management :: Transaction Manager :: Transfer to Financial Accounting
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0TRLC_DFT_ASSGN_G1161Assignment: Update Types to Position Change Category GTransfer to Financial Accounting
SQL:  selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns

SELECT MANDT, POS_MAN_PROC, G001, G002, G003, G004, G005, G006, G007, G008, G009, G010, G011, G012, G013, G014, G015, G016, G017, G018, G019, G020, G021, G022, G023, G024, G025, G026, G027, G028, G029, G030, G031, G032, G033, G034, G035, G036, G037, G038, G039, G040, G041, G042, G043, G044, G045, G046, G047, G048, G049, G050, G051, G052, G053, G054, G055, G056, G057, G058, G059, G060, G061, G062, G063, G064, G065, G066, G067, G068, G069, G070, G071, G072, G073, G074, G075, G076, G077, G078, G079, G080, G081, G082, G083, G084, G085, G086, G087, G088, G089, G090, G091, G092, G093, G094, G095, G096, G097, G098, G099, G100, G101, G102, G103, G104, G105, G106, G107, G108, G109, G110, G111, G112, G113, G114 FROM TRLC_DFT_ASSGN_G
ColumnFieldDescriptionSQL TypeLengthDecimalsRelationDefault ValueConstraintsSQL Create Statement
1MANDTClientnvarchar30 Allow NULL? 
2POS_MAN_PROCPosition Management Procedurenvarchar40 Allow NULL? 
3G001Update Typenvarchar80 Allow NULL? 
4G002Update Typenvarchar80 Allow NULL? 
5G003Update Typenvarchar80 Allow NULL? 
6G004Update Typenvarchar80 Allow NULL? 
7G005Update Typenvarchar80 Allow NULL? 
8G006Update Typenvarchar80 Allow NULL? 
9G007Update Typenvarchar80 Allow NULL? 
10G008Update Typenvarchar80 Allow NULL? 
11G009Update Typenvarchar80 Allow NULL? 
12G010Update Typenvarchar80 Allow NULL? 
13G011Update Typenvarchar80 Allow NULL? 
14G012Update Typenvarchar80 Allow NULL? 
15G013Update Typenvarchar80 Allow NULL? 
16G014Update Typenvarchar80 Allow NULL? 
17G015Update Typenvarchar80 Allow NULL? 
18G016Update Typenvarchar80 Allow NULL? 
19G017Update Typenvarchar80 Allow NULL? 
20G018Update Typenvarchar80 Allow NULL? 
21G019Update Typenvarchar80 Allow NULL? 
22G020Update Typenvarchar80 Allow NULL? 
23G021Update Typenvarchar80 Allow NULL? 
24G022Update Typenvarchar80 Allow NULL? 
25G023Update Typenvarchar80 Allow NULL? 
26G024Update Typenvarchar80 Allow NULL? 
27G025Update Typenvarchar80 Allow NULL? 
28G026Update Typenvarchar80 Allow NULL? 
29G027Update Typenvarchar80 Allow NULL? 
30G028Update Typenvarchar80 Allow NULL? 
31G029Update Typenvarchar80 Allow NULL? 
32G030Update Typenvarchar80 Allow NULL? 
33G031Update Typenvarchar80 Allow NULL? 
34G032Update Typenvarchar80 Allow NULL? 
35G033Update Typenvarchar80 Allow NULL? 
36G034Update Typenvarchar80 Allow NULL? 
37G035Update Typenvarchar80 Allow NULL? 
38G036Update Typenvarchar80 Allow NULL? 
39G037Update Typenvarchar80 Allow NULL? 
40G038Update Typenvarchar80 Allow NULL? 
41G039Update Typenvarchar80 Allow NULL? 
42G040Update Typenvarchar80 Allow NULL? 
43G041Update Typenvarchar80 Allow NULL? 
44G042Update Typenvarchar80 Allow NULL? 
45G043Update Typenvarchar80 Allow NULL? 
46G044Update Typenvarchar80 Allow NULL? 
47G045Update Typenvarchar80 Allow NULL? 
48G046Update Typenvarchar80 Allow NULL? 
49G047Update Typenvarchar80 Allow NULL? 
50G048Update Typenvarchar80 Allow NULL? 
51G049Update Typenvarchar80 Allow NULL? 
52G050Update Typenvarchar80 Allow NULL? 
53G051Update Typenvarchar80 Allow NULL? 
54G052Update Typenvarchar80 Allow NULL? 
55G053Update Typenvarchar80 Allow NULL? 
56G054Update Typenvarchar80 Allow NULL? 
57G055Update Typenvarchar80 Allow NULL? 
58G056Update Typenvarchar80 Allow NULL? 
59G057Update Typenvarchar80 Allow NULL? 
60G058Update Typenvarchar80 Allow NULL? 
61G059Update Typenvarchar80 Allow NULL? 
62G060Update Typenvarchar80 Allow NULL? 
63G061Update Typenvarchar80 Allow NULL? 
64G062Update Typenvarchar80 Allow NULL? 
65G063Update Typenvarchar80 Allow NULL? 
66G064Update Typenvarchar80 Allow NULL? 
67G065Update Typenvarchar80 Allow NULL? 
68G066Update Typenvarchar80 Allow NULL? 
69G067Update Typenvarchar80 Allow NULL? 
70G068Update Typenvarchar80 Allow NULL? 
71G069Update Typenvarchar80 Allow NULL? 
72G070Update Typenvarchar80 Allow NULL? 
73G071Update Typenvarchar80 Allow NULL? 
74G072Update Typenvarchar80 Allow NULL? 
75G073Update Typenvarchar80 Allow NULL? 
76G074Update Typenvarchar80 Allow NULL? 
77G075Update Typenvarchar80 Allow NULL? 
78G076Update Typenvarchar80 Allow NULL? 
79G077Update Typenvarchar80 Allow NULL? 
80G078Update Typenvarchar80 Allow NULL? 
81G079Update Typenvarchar80 Allow NULL? 
82G080Update Typenvarchar80 Allow NULL? 
83G081Update Typenvarchar80 Allow NULL? 
84G082Update Typenvarchar80 Allow NULL? 
85G083Update Typenvarchar80 Allow NULL? 
86G084Update Typenvarchar80 Allow NULL? 
87G085Update Typenvarchar80 Allow NULL? 
88G086Update Typenvarchar80 Allow NULL? 
89G087Update Typenvarchar80 Allow NULL? 
90G088Update Typenvarchar80 Allow NULL? 
91G089Update Typenvarchar80 Allow NULL? 
92G090Update Typenvarchar80 Allow NULL? 
93G091Update Typenvarchar80 Allow NULL? 
94G092Update Typenvarchar80 Allow NULL? 
95G093Update Typenvarchar80 Allow NULL? 
96G094Update Typenvarchar80 Allow NULL? 
97G095Update Typenvarchar80 Allow NULL? 
98G096Update Typenvarchar80 Allow NULL? 
99G097Update Typenvarchar80 Allow NULL? 
100G098Update Typenvarchar80 Allow NULL? 
101G099Update Typenvarchar80 Allow NULL? 
102G100Update Typenvarchar80 Allow NULL? 
103G101Update Typenvarchar80 Allow NULL? 
104G102Update Typenvarchar80 Allow NULL? 
105G103Update Typenvarchar80 Allow NULL? 
106G104Update Typenvarchar80 Allow NULL? 
107G105Update Typenvarchar80 Allow NULL? 
108G106Update Typenvarchar80 Allow NULL? 
109G107Update Typenvarchar80 Allow NULL? 
110G108Update Typenvarchar80 Allow NULL? 
111G109Update Typenvarchar80 Allow NULL? 
112G110Update Typenvarchar80 Allow NULL? 
113G111Update Typenvarchar80 Allow NULL? 
114G112Update Typenvarchar80 Allow NULL? 
115G113Update Typenvarchar80 Allow NULL? 
116G114Update Typenvarchar80 Allow NULL? 
NamePrimaryUniqueTypeColumns
TRLC_DFT_ASSGN_G~0YesYesCLUSTEREDMANDT, POS_MAN_PROC