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

22 columns | Print definition?ERP 6.0  | RASTER

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPAdvertising Management
1JHAERLIS-M: OPM Ad Error Log for Schedule Line Generation12RASTERIS-M: Grid for IS-M/AM Ordernvarchar30
2JHAMOTIS-M/AM: Ad Spec54RASTERIS-M: Grid Spacingnvarchar20
3TJH37IS-M/AM: Grid Spacing for Ad Spec2RASTERIS-M: Grid Spacingnvarchar20
4TJH38IS-M: Texts for Grid Spacing (Ad Spec)3RASTERIS-M: Grid Spacingnvarchar20
5TJJ57IS-M/AM: Frequency Rule4RASTERIS-M: Grid for IS-M/AM Ordernvarchar30
TOPContract Accounts Receivable and Payable
6DFKK_DUEGRIDOI - Reclassifications13RASTERGrid Upper Limit in Daysdecimal40
7TFKBWFICA to BW - Maintain Fields for Extraction7RASTERGrid ID for Extractionnvarchar20
8TFKBWCFICA BW - Maintain Fields for Extraction (Customer View)7RASTERGrid ID for Extractionnvarchar20
9TFKBWT01FICA to BW - Interval Definition2RASTERGrid ID for Extractionnvarchar20
10TFKBWT01DFICA to BW - Intervals2RASTERGrid ID for Extractionnvarchar20
11TFKBWT01DTFICA to BW - Intervals3RASTERGrid ID for Extractionnvarchar20
TOPMedia Product Sales and Distribution
12TJD03_MPIS-M: Frequency Rules for Media Products4RASTERGrid (e.g. day, week, month)nvarchar30
TOPPeriodical Sales and Distribution
13RJD01_RTEIS-M: Structure Truck Route for Generation Rule3RASTERGrid (e.g. day, week, month)nvarchar30
14TJD03IS-M/SD: Frequency Rules4RASTERGrid (e.g. day, week, month)nvarchar30
TOPPurchasing
15WGRC_ASSVendors Door/Area Appointment8RASTERGUID in 'RAW' formatvarbinary160
16WGRC_ASS_RASTERResource Table Grid2RASTERGUID in 'RAW' formatvarbinary160
17WGRC_RES_AREAResources in a Staging Area5RASTERGUID in 'RAW' formatvarbinary160
18WGRC_RES_DOORDoor Resources for a Specific Period8RASTERPointer for Relevant Entry in Grid Tablevarbinary160
19WGRC_RES_RASTERResource Table Grid2RASTERGeneric Data Element for GUID Fields (X16)varbinary160
TOPResourcen Management
20RMSAT_QMINSPRMS: ATL QM List of Inspection Data for General Recipes39RASTERInspection Frequency (Only for Inspection with Insp. Points)nvarchar30
TOPResults Recording
21QAMVCharacteristic specifications for inspection processing132RASTERInspection Frequency (Only for Inspection with Insp. Points)nvarchar30
TOPSamples and SPC
22QDSVSampling procedure29RASTERInspection Frequency (Only for Inspection with Insp. Points)nvarchar30