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_00000002

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/1SAP1/SE0000001OXMO_STYL_ACCESS2C_00000002nvarchar150
2/1SAP1/SE0000002MIH_FRA_MAT2C_00000002nvarchar150
3/1SAP1/SE0000003MIH_STYL_ACCESS2C_00000002nvarchar150
4/1SAP1/SE0000004MINIMUM_FRA_MAT2C_00000002nvarchar150
5/1SAP1/SE0000005MINIMUM_STYL_ACCES2C_00000002nvarchar150
6/1SAP1/SE0000006NOTHING_FRA_MAT2C_00000002nvarchar150
7/1SAP1/SE0000007NOTHING_STYL_ACCES2C_00000002nvarchar150
8/1SAP1/SE0000008COASTER_FRA_MAT2C_00000002nvarchar150
9/1SAP1/SE0000009COASTER_STYL_ACCES2C_00000002nvarchar150
10/1SAP1/SE0000010BASE_FRA_MAT2C_00000002nvarchar150
11/1SAP1/SE0000011BASE_STYL_ACCESS2C_00000002nvarchar150
12/1SAP1/SE0000012DOLBY_FRA_MAT2C_00000002nvarchar150
13/1SAP1/SE0000013DOLBY_STYL_ACCESS2C_00000002nvarchar150
14/1SAP1/SE0000014HIFI_STYL_ACCESS2C_00000002nvarchar150
15/1SAP1/SE0000015ROLLO_STYL_ACCESS2C_00000002nvarchar150
16/1SAP1/SE0000016OXMO_STYL_ACCESS2C_00000002nvarchar150
17/1SAP1/SE0000017ZEN_FRA_MAT2C_00000002nvarchar150
18/1SAP1/SE0000018ZEN_STYL_ACCESS2C_00000002nvarchar150
19/1SAP1/SE0000019BORGHINI_FRA_MAT2C_00000002nvarchar150
20/1SAP1/SE0000020BORGHINI_STYL_ACCE2C_00000002nvarchar150
21/1SAP1/SE0000021DPCX_DESIGN_PREIS2C_00000002nvarchar30
22/1SAP1/SE0000022DPCX_KEYBOARD2C_00000002nvarchar30
23/1SAP1/SE0000023DPCX_T_PRICING2C_00000002nvarchar30
24/1SAP1/SE0000024DPCX_RAM_TABLE3C_00000002float150
25/1SAP1/SE0000025DPCX_DESIGN_PREIS2C_00000002nvarchar30
26/1SAP1/SE0000026DPCX_KEYBOARD2C_00000002nvarchar30
27/1SAP1/SE0000027DPCX_T_PRICING2C_00000002nvarchar30
28/1SAP1/SE0000028DPCX_RAM_TABLE3C_00000002float150
29/1SAP1/SE0000029TABLE_PUMP_012C_00000002nvarchar20
30/1SAP1/SE0000030TABLE_ISA_PUMP2C_00000002nvarchar20
31/1SAP1/SE0000031TABLE_ISA_PUMP2C_00000002nvarchar20
32/1SAP1/SE0000032TABLE_ISA_PUMP2C_00000002nvarchar20
33/1SAP1/SE0000033TABLE_ISA_PUMP2C_00000002nvarchar20
34/1SAP1/SE0000034TABLE_ISA_PUMP2C_00000002nvarchar20
35/1SAP1/SE0000035TSPC_CNTRY_TAB_002C_00000002nvarchar30
36/1SAP1/SE0000036TABLE_ISA_PUMP2C_00000002nvarchar20
37/1SAP1/SE0000037T_AM_SHELF_SIZE3C_00000002float150
38/1SAP1/SE0000038T_AM_SHELF_LOAD2C_00000002nvarchar60
39/1SAP1/SE0000039T_AM_SHELF_SIZE3C_00000002float150
40/1SAP1/SE0000040T_AM_SHELF_LOAD2C_00000002nvarchar60
41/1SAP1/SE0000041T_AM_SHELF_SIZE3C_00000002float150
42/1SAP1/SE0000042T_AM_SHELF_LOAD2C_00000002nvarchar60
43/1SAP1/SE0000043TSPC_CNTRY_TAB_012C_00000002nvarchar30
44/1SAP1/SE0000044TSPC_CNTRY_TAB_022C_00000002nvarchar30
45/1SAP1/SE0000045TSPC_CNTRY_TAB_032C_00000002nvarchar30
46/1SAP1/SE0000046TSPC_CNTRY_TAB_042C_00000002nvarchar30
47/1SAP1/SE0000047TSPC_CNTRY_TAB_052C_00000002nvarchar30
48/1SAP1/SE0000048TSPC_CNTRY_TAB_062C_00000002nvarchar30
49/1SAP1/SE0000049TSPC_CNTRY_TAB_072C_00000002nvarchar30
50/1SAP1/SE0000050TSPC_CNTRY_TAB_082C_00000002nvarchar30
51/1SAP1/SE0000051TSPC_CNTRY_TAB_092C_00000002nvarchar30
52/1SAP1/SE0000052TSPC_CNTRY_TAB_102C_00000002nvarchar30
53/1SAP1/SE0000053TSPC_CNTRY_TAB_112C_00000002nvarchar30
54/1SAP1/SE0000054TSPC_CNTRY_TAB_122C_00000002nvarchar30
55/1SAP1/SE0000055TSPC_CNTRY_TAB_132C_00000002nvarchar30
56/1SAP1/SE0000056TSPC_CNTRY_TAB_142C_00000002nvarchar30
57/1SAP1/SE0000057TSPC_CNTRY_TAB_152C_00000002nvarchar30
58/1SAP1/SE0000058TSPC_CNTRY_TAB_162C_00000002nvarchar30
59/1SAP1/SE0000059TSPC_CNTRY_TAB_172C_00000002nvarchar30
60/1SAP1/SE0000060TSPC_CNTRY_TAB_182C_00000002nvarchar30
61/1SAP1/SE0000061TSPC_CNTRY_TAB_192C_00000002nvarchar30
62/1SAP1/SE0000062TSPC_CNTRY_TAB_202C_00000002nvarchar30
63/1SAP1/SE0000063TSPC_CNTRY_TAB_212C_00000002nvarchar30
64/1SAP1/SE0000064TSPC_CNTRY_TAB_222C_00000002nvarchar30
65/1SAP1/SE0000065TSPC_CNTRY_TAB_232C_00000002nvarchar30
66/1SAP1/SE0000066TSPC_CNTRY_TAB_242C_00000002nvarchar30
67/1SAP1/SE0000067TABLE_PUMP_012C_00000002nvarchar20
68/1SAP1/SE0000068TABLE_PUMP_012C_00000002nvarchar20
69/1SAP1/SE0000069TABLE_PUMP_012C_00000002nvarchar20
70/1SAP1/SE0000070TABLE_PUMP_012C_00000002nvarchar20
71/1SAP1/SE0000071TABLE_PUMP_012C_00000002nvarchar20
72/1SAP1/SE0000072IP_BB_LINE_QUALITY3C_00000002float150
73/1SAP1/SE0000073IP_BB_SPEED3C_00000002float150
74/1SAP1/SE0000074IP_GAS_CONNECTION3C_00000002float150
75/1SAP1/SE0000075IP_PAYMENT2C_00000002nvarchar20
76/1SAP1/SE0000076IP_TEL_HW_LINE_TYP2C_00000002nvarchar150
77/1SAP1/SE0000077IP_TEL_HW_ISDN_TYP2C_00000002nvarchar150
78/1SAP1/SE0000078IP_ISDN_CONN2C_00000002nvarchar40
79/1SAP1/SE0000079IP_TEL_TARIFF2C_00000002nvarchar100
80/1SAP1/SE0000080IP_EL_BASE_FEE3C_00000002nvarchar260
81/1SAP1/SE0000081IP_EL_RATES3C_00000002nvarchar20
82/1SAP1/SE0000082IP_GAS_PRICE2C_00000002nvarchar260
83/1SAP1/SE0000083IP_TEL_PRICE2C_00000002nvarchar80