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
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7OPCH386A/P Invoice
8OVTG52Tax Definition
9OPOR386Purchase Order
10JDT1124Journal Entry - Rows

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OVPM154Outgoing Payments
5OIVL77Whse Journal
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

83 columns | Print definition?ERP 6.0  | C_00000001

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/1SAP1/SE0000001OXMO_STYL_ACCESS1C_00000001nvarchar150
2/1SAP1/SE0000002MIH_FRA_MAT1C_00000001nvarchar150
3/1SAP1/SE0000003MIH_STYL_ACCESS1C_00000001nvarchar150
4/1SAP1/SE0000004MINIMUM_FRA_MAT1C_00000001nvarchar150
5/1SAP1/SE0000005MINIMUM_STYL_ACCES1C_00000001nvarchar150
6/1SAP1/SE0000006NOTHING_FRA_MAT1C_00000001nvarchar150
7/1SAP1/SE0000007NOTHING_STYL_ACCES1C_00000001nvarchar150
8/1SAP1/SE0000008COASTER_FRA_MAT1C_00000001nvarchar150
9/1SAP1/SE0000009COASTER_STYL_ACCES1C_00000001nvarchar150
10/1SAP1/SE0000010BASE_FRA_MAT1C_00000001nvarchar150
11/1SAP1/SE0000011BASE_STYL_ACCESS1C_00000001nvarchar150
12/1SAP1/SE0000012DOLBY_FRA_MAT1C_00000001nvarchar150
13/1SAP1/SE0000013DOLBY_STYL_ACCESS1C_00000001nvarchar150
14/1SAP1/SE0000014HIFI_STYL_ACCESS1C_00000001nvarchar150
15/1SAP1/SE0000015ROLLO_STYL_ACCESS1C_00000001nvarchar150
16/1SAP1/SE0000016OXMO_STYL_ACCESS1C_00000001nvarchar150
17/1SAP1/SE0000017ZEN_FRA_MAT1C_00000001nvarchar150
18/1SAP1/SE0000018ZEN_STYL_ACCESS1C_00000001nvarchar150
19/1SAP1/SE0000019BORGHINI_FRA_MAT1C_00000001nvarchar300
20/1SAP1/SE0000020BORGHINI_STYL_ACCE1C_00000001nvarchar150
21/1SAP1/SE0000021DPCX_DESIGN_PREIS1C_00000001nvarchar30
22/1SAP1/SE0000022DPCX_KEYBOARD1C_00000001nvarchar30
23/1SAP1/SE0000023DPCX_T_PRICING1C_00000001nvarchar300
24/1SAP1/SE0000024DPCX_RAM_TABLE2C_00000001float150
25/1SAP1/SE0000025DPCX_DESIGN_PREIS1C_00000001nvarchar30
26/1SAP1/SE0000026DPCX_KEYBOARD1C_00000001nvarchar30
27/1SAP1/SE0000027DPCX_T_PRICING1C_00000001nvarchar300
28/1SAP1/SE0000028DPCX_RAM_TABLE2C_00000001float150
29/1SAP1/SE0000029TABLE_PUMP_011C_00000001nvarchar20
30/1SAP1/SE0000030TABLE_ISA_PUMP1C_00000001nvarchar20
31/1SAP1/SE0000031TABLE_ISA_PUMP1C_00000001nvarchar20
32/1SAP1/SE0000032TABLE_ISA_PUMP1C_00000001nvarchar20
33/1SAP1/SE0000033TABLE_ISA_PUMP1C_00000001nvarchar20
34/1SAP1/SE0000034TABLE_ISA_PUMP1C_00000001nvarchar20
35/1SAP1/SE0000035TSPC_CNTRY_TAB_001C_00000001nvarchar30
36/1SAP1/SE0000036TABLE_ISA_PUMP1C_00000001nvarchar20
37/1SAP1/SE0000037T_AM_SHELF_SIZE2C_00000001float150
38/1SAP1/SE0000038T_AM_SHELF_LOAD1C_00000001nvarchar30
39/1SAP1/SE0000039T_AM_SHELF_SIZE2C_00000001float150
40/1SAP1/SE0000040T_AM_SHELF_LOAD1C_00000001nvarchar30
41/1SAP1/SE0000041T_AM_SHELF_SIZE2C_00000001float150
42/1SAP1/SE0000042T_AM_SHELF_LOAD1C_00000001nvarchar30
43/1SAP1/SE0000043TSPC_CNTRY_TAB_011C_00000001nvarchar30
44/1SAP1/SE0000044TSPC_CNTRY_TAB_021C_00000001nvarchar30
45/1SAP1/SE0000045TSPC_CNTRY_TAB_031C_00000001nvarchar30
46/1SAP1/SE0000046TSPC_CNTRY_TAB_041C_00000001nvarchar30
47/1SAP1/SE0000047TSPC_CNTRY_TAB_051C_00000001nvarchar30
48/1SAP1/SE0000048TSPC_CNTRY_TAB_061C_00000001nvarchar30
49/1SAP1/SE0000049TSPC_CNTRY_TAB_071C_00000001nvarchar30
50/1SAP1/SE0000050TSPC_CNTRY_TAB_081C_00000001nvarchar30
51/1SAP1/SE0000051TSPC_CNTRY_TAB_091C_00000001nvarchar30
52/1SAP1/SE0000052TSPC_CNTRY_TAB_101C_00000001nvarchar30
53/1SAP1/SE0000053TSPC_CNTRY_TAB_111C_00000001nvarchar30
54/1SAP1/SE0000054TSPC_CNTRY_TAB_121C_00000001nvarchar30
55/1SAP1/SE0000055TSPC_CNTRY_TAB_131C_00000001nvarchar30
56/1SAP1/SE0000056TSPC_CNTRY_TAB_141C_00000001nvarchar30
57/1SAP1/SE0000057TSPC_CNTRY_TAB_151C_00000001nvarchar30
58/1SAP1/SE0000058TSPC_CNTRY_TAB_161C_00000001nvarchar30
59/1SAP1/SE0000059TSPC_CNTRY_TAB_171C_00000001nvarchar30
60/1SAP1/SE0000060TSPC_CNTRY_TAB_181C_00000001nvarchar30
61/1SAP1/SE0000061TSPC_CNTRY_TAB_191C_00000001nvarchar30
62/1SAP1/SE0000062TSPC_CNTRY_TAB_201C_00000001nvarchar30
63/1SAP1/SE0000063TSPC_CNTRY_TAB_211C_00000001nvarchar30
64/1SAP1/SE0000064TSPC_CNTRY_TAB_221C_00000001nvarchar30
65/1SAP1/SE0000065TSPC_CNTRY_TAB_231C_00000001nvarchar30
66/1SAP1/SE0000066TSPC_CNTRY_TAB_241C_00000001nvarchar30
67/1SAP1/SE0000067TABLE_PUMP_011C_00000001nvarchar20
68/1SAP1/SE0000068TABLE_PUMP_011C_00000001nvarchar20
69/1SAP1/SE0000069TABLE_PUMP_011C_00000001nvarchar20
70/1SAP1/SE0000070TABLE_PUMP_011C_00000001nvarchar20
71/1SAP1/SE0000071TABLE_PUMP_011C_00000001nvarchar20
72/1SAP1/SE0000072IP_BB_LINE_QUALITY2C_00000001float150
73/1SAP1/SE0000073IP_BB_SPEED1C_00000001nvarchar90
74/1SAP1/SE0000074IP_GAS_CONNECTION1C_00000001nvarchar30
75/1SAP1/SE0000075IP_PAYMENT1C_00000001nvarchar100
76/1SAP1/SE0000076IP_TEL_HW_LINE_TYP1C_00000001nvarchar100
77/1SAP1/SE0000077IP_TEL_HW_ISDN_TYP1C_00000001nvarchar40
78/1SAP1/SE0000078IP_ISDN_CONN1C_00000001nvarchar100
79/1SAP1/SE0000079IP_TEL_TARIFF1C_00000001nvarchar100
80/1SAP1/SE0000080IP_EL_BASE_FEE2C_00000001float150
81/1SAP1/SE0000081IP_EL_RATES2C_00000001float150
82/1SAP1/SE0000082IP_GAS_PRICE1C_00000001nvarchar30
83/1SAP1/SE0000083IP_TEL_PRICE1C_00000001nvarchar100