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

55 columns | Print definition?ERP 6.0  | LAEDA

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/SAPF15/F15F15 Belege (Kopfdaten)14LAEDADatum der letzten Änderungnvarchar80
2/SAPF15/F15B01F15 B01 Belege22LAEDADatum der letzten Änderungnvarchar80
3/SAPF15/F15B02F15 B02 Belege42LAEDADatum der letzten Änderungnvarchar80
4/SAPF15/F15E02F15 E02 Belege17LAEDADatum der letzten Änderungnvarchar80
5/SAPF15/F15HF15 Belege (Kopfdaten Historie)15LAEDADatum der letzten Änderungnvarchar80
6/SAPF15/RMF15 Rückmeldung Klärungsbestand17LAEDADatum der letzten Änderungnvarchar80
7/SAPF15/RMLOGF15 Rückmeldung Klärungsbestand Änderungshistorie6LAEDADatum der letzten Änderungnvarchar80
8/SAPF15/SMF15 SEPA Mandat10LAEDADatum der letzten Änderungnvarchar80
9/SMERP/STG_MM005Data staging - Material batch view complex table205LAEDADate of Last Changenvarchar80
10ZCATSDBRecords changed with processing status '10'76LAEDAnvarchar80
11ZCATSDB2Records changed with processing status '10'77LAEDAnvarchar80
12ZEIMMARAUSING FOR STORING EIM MARA DATAS5LAEDADate of Last Changenvarchar80
TOPActual CostingMaterial Ledger
13FCML_MATML Characteristics for Material (Selection Criteria)30LAEDADate of Last Changenvarchar80
TOPAttendancesAbsences
14CATSHRCross-Application Time Sheet (CATS): Transfer to HR62LAEDADate of Last Changenvarchar80
TOPConfirmations
15AFFWGoods Movements with Errors from Confirmations6LAEDADate of Last Changenvarchar80
16AFRUOrder Confirmations6LAEDADate of Last Changenvarchar80
TOPConstruction Equipment Management
17J_3GSTLKOPFHeader Data for Equipment BOMs11LAEDADate of Last Changenvarchar80
TOPCross-Application Components
18MMARAGeneral material data5LAEDADate of Last Changenvarchar80
TOPDemand Management
19PBEDIndependent Requirements Data6LAEDADate of Last Changenvarchar80
20PBHIIndependent Requirements History4LAEDADate of Last Changenvarchar80
21TPSVPPlanning profile lines8LAEDADate of Last Changenvarchar80
TOPESS Based on WD ABAP
22HRESS_D_CATS_FAVCATS Favorites: database table83LAEDADate of Last Changenvarchar80
TOPFunds Management-Specific Postings
23FMD1_F15F15 Interface - Documents14LAEDADate of Last Changenvarchar80
TOPLogistics Basic Data
24MATGRP_HIERArticle Hierarchy Properties12LAEDADate of Last Changenvarchar80
25WRF_MATGRP_HIERArticle Hierarchy Properties13LAEDADate of Last Changenvarchar80
TOPMaintenance Orders
26/MRSS/C_PARAMRCCF: Generelle Einstellungen5LAEDADate of Last Changenvarchar80
TOPMaterial Master
27MARAGeneral Material Data5LAEDADate of Last Changenvarchar80
28MARA_TMPFile for Incorrect Data in Direct Input12LAEDADate of Last Changenvarchar80
29MARVMaterial Control Record12LAEDADate of Last Changenvarchar80
30MARVCDChange Document: Period Initialization when System in Op.5LAEDADate of Last Changenvarchar80
31MBPRStock at Production Storage Bin9LAEDADate of Last Changenvarchar80
32MCH1Batches (if Batch Management Cross-Plant)8LAEDADate of Last Changenvarchar80
33MCHABatches9LAEDADate of Last Changenvarchar80
34MCHBBatch Stocks9LAEDADate of Last Changenvarchar80
35MEIKMake-to-Order Stock for Customer Order12LAEDADate of Last Changenvarchar80
36MGVTYPETable of version categories3LAEDADate of Last Changenvarchar80
37MGVTYPEWORKTable of version categories3LAEDADate of Last Changenvarchar80
38MGVTYPE_WRKTable of version categories3LAEDADate of Last Changenvarchar80
39MKLKConsignment Stocks and Returnable Packaging with Customer10LAEDADate of Last Changenvarchar80
40MKOLSpecial Stocks from Vendor12LAEDADate of Last Changenvarchar80
41MKOPConsignment Price Segment9LAEDADate of Last Changenvarchar80
42MKUBMaterial Provided by Customer10LAEDADate of Last Changenvarchar80
43MLIBMaterial Provided to Vendor9LAEDADate of Last Changenvarchar80
44MSTAMaterial Master Status7LAEDADate of Last Changenvarchar80
45MVRACross-version fields for MARA5LAEDADate of Last Changenvarchar80
TOPMaterials Management
46/ISDFPS/NSN_IDNATO Stock Number: Master Data9LAEDADate of Last Changenvarchar80
47/SAPNEA/JSCDIEHDie management header table6LAEDADate of Last Changenvarchar80
TOPMerchandise and Assortment Planning
48TWISPC_MARARetail Planning: Materials for Provisional Planning22LAEDADate of Last Changenvarchar80
TOPPrice Planning Workbench
49WRF_PPW_WORKLERRPPW Worklist Error Table37LAEDATime Stamp of Last Changenvarchar140
50WRF_PPW_WORKLISTPPW Worklist38LAEDATime Stamp of Last Changenvarchar140
TOPRemote Control and Communication Framework
51RCCC_PARAMRCCF: General Settings5LAEDADate of Last Changenvarchar80
TOPRetail Pricing
52WPFAMFamily Pricing: Definition of Families8LAEDADate of Last Changenvarchar80
TOPTime Sheet
53CATSDBCATS: Database Table for Time Sheet76LAEDADate of Last Changenvarchar80
54CATSDELTable with Deletion Time of Deleted CATS Records5LAEDADate of Last Changenvarchar80
55CATS_BW_TIMETransfer Time Sheet into BW - Time Stamp4LAEDASystem Datenvarchar80