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

28 columns | Print definition?ERP 6.0  | MRPPP

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/SMD/MD_____00SXSID-Tabelle fuer Planning calendar4MRPPPPPC planning calendarnvarchar30
2/SMD/MD_____00VFSID-Tabelle fuer Planning cycle4MRPPPPPC planning calendarnvarchar30
3/SMERP/STG_MM001Data staging - Material master plant view complex table294MRPPPPPC planning calendarnvarchar30
4PPH_MRP_PERIODSPeriod table for lot-sizing in MRP5MRPPPPPC planning calendarnvarchar30
5T439IPP planning periods: schedule lines (periods)3MRPPPPPC planning calendarnvarchar30
6T439JPP planning periods: calculation rule3MRPPPPPC planning calendarnvarchar30
7T449USettings for Collective Display of MRP List28MRPPPPPC planning calendarnvarchar30
TOPCross-Application Components
8FRE_DB_PROCYCProcurement cycle4MRPPPPPC planning calendarnvarchar30
9MMARCPlant Data for Material98MRPPPPPC planning calendarnvarchar30
TOPKANBAN
10CTIMEDEFTime definition8MRPPPPPC planning calendarnvarchar30
11TPKBPKanban calculation profile24MRPPPPPC planning calendarnvarchar30
TOPMaster Data
12MDCOVTable with Range of Coverage Information36MRPPPPPC planning calendarnvarchar30
13MDKPHeader Data for MRP Document63MRPPPPPC planning calendarnvarchar30
14MDKPDBHeader Data for MRP Document64MRPPPPPC planning calendarnvarchar30
15MDMAMRP Area for Material23MRPPPPPC planning calendarnvarchar30
16T439GPPplanning periods: header table3MRPPPPPC planning calendarnvarchar30
17T439HPP planning periods: long texts4MRPPPPPC planning calendarnvarchar30
18T465Evaluation Profile Ranges of Coverage18MRPPPPPC planning calendarnvarchar30
19T466Customizing: Extraction Mode for Planning Situation6MRPPPPPC planning calendarnvarchar30
TOPMaterial Master
20MARCPlant Data for Material98MRPPPPPC planning calendarnvarchar30
21MARC_TMPFile for Incorrect Data in Direct Input101MRPPPPPC planning calendarnvarchar30
22MDIPMaterial: MRP Profiles (Field Contents)30MRPPPPPC planning calendarnvarchar30
23MVRCCross-version fields for MARC98MRPPPPPC planning calendarnvarchar30
TOPMaterial Requirements Planning
24CIFMDMAVRVersions of Table MDMA24MRPPPPPC planning calendarnvarchar30
TOPSAP Retail Store
25WSAO_T439SRS STO: Order Times in Planning Calendar3MRPPPPPC planning calendarnvarchar30
TOPVendor Master
26LFM1Vendor master record purchasing organization data26MRPPPPlanning calendarnvarchar30
27LFM2Vendor Master Record: Purchasing Data28MRPPPPlanning calendarnvarchar30
28WYT5Changes to Vendor Master Record14MRPPPPlanning calendarnvarchar30