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

54 columns | Print definition?ERP 6.0  | REC_STATUS

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/SMERP/CABN_EXxChange table for characteristic data7REC_STATUSExchange table record statusnvarchar10
2/SMERP/CAWN_EXxChange table - char values (ATINN+ATZHL+ADZHL)7REC_STATUSExchange table record statusnvarchar10
3/SMERP/DOC_EXExchange Table - DMS Documents7REC_STATUSExchange table record statusnvarchar10
4/SMERP/DOC_FI_EXExchange Table - DMS Document Files7REC_STATUSExchange table record statusnvarchar10
5/SMERP/DOC_LI_EXExchange Table - DMS Document Links7REC_STATUSExchange table record statusnvarchar10
6/SMERP/EAML_EXExchange Table - Linear Asset Management7REC_STATUSExchange table record statusnvarchar10
7/SMERP/KBED_EXExchange Table - Capacity Requirements10REC_STATUSExchange table record statusnvarchar10
8/SMERP/KLAH_EXxChange Table - Classification Header (CLINT)7REC_STATUSExchange table record statusnvarchar10
9/SMERP/KSSK_EXxChange Table - Object To Class Allocation7REC_STATUSExchange table record statusnvarchar10
10/SMERP/SWOR_EXxChange table - Class Keyword (CLINT+SPRAS+KLPOS)7REC_STATUSExchange table record statusnvarchar10
11/SMFND/DEMO_B_EXExchange Table - Demo Bookings11REC_STATUSExchange table record statusnvarchar10
12/SMFND/DEMO_C_EXExchange Table - Demo Customers7REC_STATUSExchange table record statusnvarchar10
13/SMFND/DEMO_F_EXExchange Table - Demo Flights10REC_STATUSExchange table record statusnvarchar10
14/SMFND/OID01_EXxChange table - SAP Object/GIS Object Id Mapping7REC_STATUSExchange table record statusnvarchar10
15/SYCLO/ARBPL_EXSyclo Exchange Table - Work Center7REC_STATUSExchange table record statusnvarchar10
16/SYCLO/AUFNR_EXSyclo Exchange Table - Maintenance Work Order7REC_STATUSExchange table record statusnvarchar10
17/SYCLO/AUFPL_EXSyclo Exchange Table - Maintenance Work Order9REC_STATUSExchange table record statusnvarchar10
18/SYCLO/AUSP_EXSyclo Exchange Table - Maintenance Equipment/FuncLoc CharVal7REC_STATUSExchange table record statusnvarchar10
19/SYCLO/CHARG_EXSyclo Exchange Table - Material Batch7REC_STATUSExchange table record statusnvarchar10
20/SYCLO/EBELN_EXSyclo Exchange Table - Purchase Order7REC_STATUSExchange table record statusnvarchar10
21/SYCLO/EQUNR_EXSyclo Exchange Table - Equipment7REC_STATUSExchange table record statusnvarchar10
22/SYCLO/FLEET_EXSyclo Exchange Table - Crew Management7REC_STATUSExchange table record statusnvarchar10
23/SYCLO/IBASE_EXSyclo Exchange Table - Installed Base7REC_STATUSExchange table record statusnvarchar10
24/SYCLO/IBLNR_EXSyclo Exchange Table - Physical Inventory Document7REC_STATUSExchange table record statusnvarchar10
25/SYCLO/IVNUM_EXSyclo Exchange Table - Inventory Documents7REC_STATUSExchange table record statusnvarchar10
26/SYCLO/KSML_EXSyclo Exchange Table - Class Char (CLINT+POSNR+ADZHL)7REC_STATUSExchange table record statusnvarchar10
27/SYCLO/KUNNR_EXSyclo Exchange Table - Customer Master7REC_STATUSExchange table record statusnvarchar10
28/SYCLO/LIFNR_EXSyclo Exchange Table - Vendor Master7REC_STATUSExchange table record statusnvarchar10
29/SYCLO/LSTAR_EXSyclo Exchange Table - Cost Center/Activity Type7REC_STATUSExchange table record statusnvarchar10
30/SYCLO/MATNR1_EXSyclo Exchange Table - Material Master UoM7REC_STATUSExchange table record statusnvarchar10
31/SYCLO/MATNR2_EXSyclo Exchange Table - Material Master CRM Extension7REC_STATUSExchange table record statusnvarchar10
32/SYCLO/MATNR_EXSyclo Exchange Table - Material Master7REC_STATUSExchange table record statusnvarchar10
33/SYCLO/MBLNR_EXSyclo Exchange Table - Material Document7REC_STATUSExchange table record statusnvarchar10
34/SYCLO/MDOCM_EXSyclo Exchange Table - Measurment Document7REC_STATUSExchange table record statusnvarchar10
35/SYCLO/MELNR_EXSyclo Exchange Table - Entry List7REC_STATUSExchange table record statusnvarchar10
36/SYCLO/OBKNR_EXSyclo Exchange Table - PM Object List7REC_STATUSExchange table record statusnvarchar10
37/SYCLO/POINT_EXSyclo Exchange Table - Measuring Point7REC_STATUSExchange table record statusnvarchar10
38/SYCLO/QMNUM_EXSyclo Exchange Table - PM/CS/QM notification7REC_STATUSExchange table record statusnvarchar10
39/SYCLO/RSNUM_EXSyclo Exchange Table - Material Reservation7REC_STATUSExchange table record statusnvarchar10
40/SYCLO/STOCK1_EXSyclo Exchange Table - Material Stock (WERKS, MATNR)9REC_STATUSExchange table record statusnvarchar10
41/SYCLO/STOCK2_EXSyclo Exchange Table - Customer Special Stock12REC_STATUSExchange table record statusnvarchar10
42/SYCLO/STOCK_EXSyclo Exchange Table - Material Stock Data9REC_STATUSExchange table record statusnvarchar10
43/SYCLO/TANUM_EXSyclo Exchange Table - Transfer Order7REC_STATUSExchange table record statusnvarchar10
44/SYCLO/TBNUM_EXSyclo Exchange Table - Transfer Requirements7REC_STATUSExchange table record statusnvarchar10
45/SYCLO/TPLNR_EXSyclo Exchange Table - Functional Location7REC_STATUSExchange table record statusnvarchar10
46/SYCLO/VBELN_EXExchange Table - SD Sales Document Master7REC_STATUSExchange table record statusnvarchar10
47/SYCLO/WFLOW_EXSyclo Exchange Table - Workflow7REC_STATUSExchange table record statusnvarchar10
48EHPRCC_IMPRESRestrictions for import MDS data2REC_STATUSRecipient Statusnvarchar10
49EHPRCD_ICH4Chapter 4 Data27REC_STATUSRecipient Statusnvarchar10
50T7NOEDG_PRD06EDAG - Receptions12REC_STATUSEDAG - Receipt statusnvarchar90
51T7NOEDG_TEST06EDAG[TEST] - Receptions12REC_STATUSEDAG - Receipt statusnvarchar90
TOPEnvironment, Health and Safety
52/TDAG/CPA_ICH4Chapter 4 Data27REC_STATUSRecipient Statusnvarchar10
53/TDAG/CPC_IMPRESRestrictions for import MDS data2REC_STATUSRecipient Statusnvarchar10
TOPLocalization
54IDIN_ASSETTRNSAsset Transaction Table for India (Block Level)7REC_STATUSRecord status of Asset Blocknvarchar10