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

101 columns | Print definition?ERP 6.0  | ERSDA

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/SAPF15/DATAF15 Belege (Daten)6ERSDAErstellungsdatumnvarchar80
2/SAPF15/DATADECOF15 Belege (XPRA_DECOMPRESS)6ERSDAErstellungsdatumnvarchar80
3/SAPF15/ELKOGESF15 ELKO Daten GES Dateien14ERSDAErstellungsdatumnvarchar80
4/SAPF15/ELKOHKR1F15 ELKO Daten aus HKR 135ERSDAErstellungsdatumnvarchar80
5/SAPF15/ELKOHKR2F15 ELKO Daten aus HKR 2 Satzart 2 + HKR 644ERSDAErstellungsdatumnvarchar80
6/SAPF15/ELKOHKR4F15 ELKO Daten aus HKR 426ERSDAErstellungsdatumnvarchar80
7/SAPF15/ELKOHKR5F15 ELKO Daten aus HKR 530ERSDAErstellungsdatumnvarchar80
8/SAPF15/ELKOHKRZF15 ELKO Daten aus HKR 2 Satzart 319ERSDAErstellungsdatumnvarchar80
9/SAPF15/ELKOZM_VF15 Daten aus ZÜV 101, alte Versionen26ERSDAErstellungsdatumnvarchar80
10/SAPF15/ELKOZUV1F15 ELKO Daten aus ZÜV 10025ERSDAErstellungsdatumnvarchar80
11/SAPF15/ELKOZUV2F15 ELKO Daten aus ZÜV 20022ERSDAErstellungsdatumnvarchar80
12/SAPF15/ELKOZUV5F15 ELKO Daten aus ZÜV 50021ERSDAErstellungsdatumnvarchar80
13/SAPF15/ELKOZUV6F15 ELKO Daten aus ZÜV 60019ERSDAErstellungsdatumnvarchar80
14/SAPF15/ELKOZUV9F15 ELKO Daten aus ZÜV 90015ERSDAErstellungsdatumnvarchar80
15/SAPF15/ELKOZUVMF15 Daten aus ZÜV 10125ERSDAErstellungsdatumnvarchar80
16/SAPF15/F15F15 Belege (Kopfdaten)11ERSDAErstellungsdatumnvarchar80
17/SAPF15/F15B01F15 B01 Belege19ERSDAErstellungsdatumnvarchar80
18/SAPF15/F15B02F15 B02 Belege39ERSDAErstellungsdatumnvarchar80
19/SAPF15/F15E02F15 E02 Belege14ERSDAErstellungsdatumnvarchar80
20/SAPF15/F15HF15 Belege (Kopfdaten Historie)12ERSDAErstellungsdatumnvarchar80
21/SAPF15/RMF15 Rückmeldung Klärungsbestand14ERSDAErstellungsdatumnvarchar80
22/SAPF15/SMF15 SEPA Mandat7ERSDAErstellungsdatumnvarchar80
23/SMERP/STG_MM002Data staging - Material storage location view complex table240ERSDACreated Onnvarchar80
24/SMERP/STG_MM005Data staging - Material batch view complex table202ERSDACreated Onnvarchar80
25CNV_20100_CSKABackup copy - CSKA5ERSDAnvarchar80
26CNV_20100_CSKBBackup copy - CSKB8ERSDAnvarchar80
27CNV_20305_CEPCSAP LT: Backup table of CEPC7ERSDACreation datenvarchar80
28ZCATSDBRecords changed with processing status '10'73ERSDAnvarchar80
29ZCATSDB2Records changed with processing status '10'74ERSDAnvarchar80
30ZEIMMARAUSING FOR STORING EIM MARA DATAS3ERSDACreated Onnvarchar80
TOPAssortment Maintenance
31WSOFModule Assignment (SAP Retail) to Plants6ERSDACreated Onnvarchar80
32WSOHAssortment Modules SAP Retail7ERSDACreated Onnvarchar80
33WSOPModules SAP Retail / Item Data7ERSDACreated Onnvarchar80
TOPAttendancesAbsences
34CATSHRCross-Application Time Sheet (CATS): Transfer to HR59ERSDACreated onnvarchar80
TOPConfirmations
35AFFWGoods Movements with Errors from Confirmations4ERSDACreated Onnvarchar80
36AFFWPROLog of deleted AFFW entries16ERSDACreated Onnvarchar80
37AFRCIncorrect cost calculations from confirmations5ERSDACreated Onnvarchar80
38AFRUOrder Confirmations4ERSDAConfirmation entry datenvarchar80
TOPConstruction Equipment Management
39J_3GSTLKOPFHeader Data for Equipment BOMs9ERSDACreated Onnvarchar80
TOPControlling
40CSKACost Elements (Data Dependent on Chart of Accounts)4ERSDACreated onnvarchar80
41CSKBCost Elements (Data Dependent on Controlling Area)7ERSDACreated onnvarchar80
42CSKSCost Center Master Data19ERSDACreated onnvarchar80
43CSLAActivity master9ERSDACreated onnvarchar80
TOPCross-Application Components
44MAAVC_CONFMPO: Confirmations Cumulated on WBS Element3ERSDADatenvarchar80
45MMARAGeneral material data3ERSDACreated Onnvarchar80
TOPESS Based on WD ABAP
46HRESS_D_CATS_FAVCATS Favorites: database table80ERSDACreated onnvarchar80
TOPFunds Management-Specific Postings
47FMD1_F15F15 Interface - Documents11ERSDACreated Onnvarchar80
TOPInventory Management
48MSTBStock in Transit10ERSDACreated Onnvarchar80
49MSTEStock in Transit to Sales and Distribution Document12ERSDACreated Onnvarchar80
50MSTQStock in Transit for Project11ERSDACreated Onnvarchar80
TOPLogistics Basic Data
51MATGRP_HIERArticle Hierarchy Properties11ERSDACreated Onnvarchar80
52WRF_MATGRP_HIERArticle Hierarchy Properties12ERSDACreated Onnvarchar80
TOPMaintenance Orders
53/MRSS/C_PARAMRCCF: Generelle Einstellungen3ERSDACreated Onnvarchar80
TOPMaterial Master
54MARAGeneral Material Data3ERSDACreated Onnvarchar80
55MARA_TMPFile for Incorrect Data in Direct Input10ERSDACreated Onnvarchar80
56MARDStorage Location Data for Material44ERSDACreated Onnvarchar80
57MARD_TMPFile for Incorrect Data in Direct Input47ERSDACreated Onnvarchar80
58MBPRStock at Production Storage Bin7ERSDACreated Onnvarchar80
59MCH1Batches (if Batch Management Cross-Plant)5ERSDACreated Onnvarchar80
60MCHABatches6ERSDACreated Onnvarchar80
61MCHBBatch Stocks7ERSDACreated Onnvarchar80
62MEIKMake-to-Order Stock for Customer Order10ERSDACreated Onnvarchar80
63MKLKConsignment Stocks and Returnable Packaging with Customer8ERSDACreated Onnvarchar80
64MKOLSpecial Stocks from Vendor9ERSDACreated Onnvarchar80
65MKOPConsignment Price Segment6ERSDACreated Onnvarchar80
66MKUBMaterial Provided by Customer8ERSDACreated Onnvarchar80
67MLIBMaterial Provided to Vendor7ERSDACreated Onnvarchar80
68MOFFOutstanding Material Master Records3ERSDACreated Onnvarchar80
69MSKASales Order Stock30ERSDACreated Onnvarchar80
70MSKUSpecial Stocks with Customer23ERSDACreated Onnvarchar80
71MSLBSpecial Stocks with Vendor23ERSDACreated Onnvarchar80
72MSPRProject Stock29ERSDACreated Onnvarchar80
73MSSATotal Customer Orders on Hand13ERSDACreated Onnvarchar80
74MSSLTotal Special Stocks with Vendor11ERSDACreated Onnvarchar80
75MSSQProject Stock Total12ERSDACreated Onnvarchar80
76MSTAMaterial Master Status5ERSDACreated Onnvarchar80
77MVRACross-version fields for MARA3ERSDACreated Onnvarchar80
78MVRDStorage Location Data for Material44ERSDACreated Onnvarchar80
TOPMaterials Management
79/ISDFPS/CS_SW_IDSystem Switch: Force Element and IDocs8ERSDACreated Onnvarchar80
80/ISDFPS/NSN_IDNATO Stock Number: Master Data6ERSDACreated Onnvarchar80
81/SAPNEA/JSCDIEHDie management header table4ERSDACreated Onnvarchar80
TOPOverhead Cost Controlling
82CMDTGeneric Master Record: General Header7ERSDACreated onnvarchar80
TOPPrice Planning Workbench
83WRF_PPW_WORKLERRPPW Worklist Error Table21ERSDAPrice Plan Created onnvarchar140
84WRF_PPW_WORKLISTPPW Worklist22ERSDAnvarchar140
TOPProduction Orders
85ORDLYTable of delays for production order8ERSDACreated Onnvarchar80
TOPProfit Center Accounting
86CEPCProfit Center Master Data Table6ERSDACreated onnvarchar80
TOPRemote Control and Communication Framework
87RCCC_PARAMRCCF: General Settings3ERSDACreated Onnvarchar80
TOPRetail Pricing
88WPFAMFamily Pricing: Definition of Families6ERSDACreated Onnvarchar80
TOPSpare Part Sharing and Stock Providede by Customer
89MCSDCustomer Stock8ERSDACreated Onnvarchar80
90MCSSTotal Customer Stock6ERSDACreated Onnvarchar80
91MSCDCustomer stock with vendor24ERSDACreated Onnvarchar80
92MSCSCustomer stock with vendor - Total12ERSDACreated Onnvarchar80
93MSFDSales Order Stock with Vendor25ERSDACreated Onnvarchar80
94MSFSSales Order Stock with Vendor - Total13ERSDACreated Onnvarchar80
95MSIDVendor Stock with Vendor24ERSDACreated Onnvarchar80
96MSISVendor Stock with Vendor - Total12ERSDACreated Onnvarchar80
97MSRDProject Stock with Vendor24ERSDACreated Onnvarchar80
98MSRSProject Stock with Vendor - Total12ERSDACreated Onnvarchar80
TOPTime Sheet
99CATSDBCATS: Database Table for Time Sheet73ERSDACreated onnvarchar80
100CATSPMCross-Application Time Sheet (CATS): Transfer to PM/CS28ERSDACreated Onnvarchar80
101CATSPSCross-Application Time Sheet (CATS): Transfer to PS28ERSDACreated Onnvarchar80