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

25 columns | Print definition?ERP 6.0  | MED_PROD

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPMedia Product Sales and Distribution
1JKSDFCHEADIS-M: Reference Issue Header Data6MED_PRODMedia Productnvarchar180
2JKSDFCHEADPOIS-M: Header Data for Ref. Issues with Planning Organization7MED_PRODMedia Productnvarchar180
3JKSDFCITEMIS-M: Media Issue Item Data6MED_PRODMedia Productnvarchar180
4JKSDFCITEMPOIS-M: Media Issue Item Data with Planning Organization7MED_PRODMedia Productnvarchar180
5JKSDFCVARIANTIS-M: Reference Issue Header Data6MED_PRODMedia Productnvarchar180
6JKSDFCVARIANTPOIS-M: Header Data for Ref. Issues with Planning Organization7MED_PRODMedia Productnvarchar180
7JKSDISSFORECIS-M: Media Issue Header Data5MED_PRODMedia Productnvarchar180
8JKSDISSFORECITEMIS-M: Media Issue Item Data6MED_PRODMedia Productnvarchar180
9JKSDISSUEDATERecall Dates for Media Issues18MED_PRODHigher-Level Media Productnvarchar180
10JKSDORDERBOOKIS-M: Planned Purchase Quantities5MED_PRODHigher-Level Media Productnvarchar180
11JKSDORDERBOOKPLGoods Movements for Return to Publisher4MED_PRODHigher-Level Media Productnvarchar180
12JKSDORDERBOOKPLFGoods Movements for Return to Publisher4MED_PRODHigher-Level Media Productnvarchar180
13JKSDORDERBOOKRETIS-M: Planned Quantities for Return to Publisher4MED_PRODHigher-Level Media Productnvarchar180
14JKSDPORDERFLOWIS-M: Assignment of Purchase Order Book to Purchase Order4MED_PRODHigher-Level Media Productnvarchar180
15JKSDPORDERFLOWREIS-M: Assignment of PO Book for Rtn to Publisher to PO4MED_PRODHigher-Level Media Productnvarchar180
16JKSDQFAREAIS-M: Planning Area for Media Issues3MED_PRODHigher-Level Media Productnvarchar180
17JKSDQFAREAPRODIS-M: Assignment of Planning Area and Media Product3MED_PRODHigher-Level Media Productnvarchar180
18JKSDUNSOLDPOFLOWDocument Flow Return Delivery PO Unsold Copies6MED_PRODHigher-Level Media Productnvarchar180
19JPTMG0IS-M: Media Product Issue Sequence2MED_PRODHigher-Level Media Productnvarchar180
20JPTMG3IS-M: Control Settings for Copying Issue Seq.from Template2MED_PRODMedia Productnvarchar180
21JPTMG4IS-M: Issue Sequence: Header Data2MED_PRODMedia Productnvarchar180
22JPTMG5IS-M: Issue Sequence: Calendar Maint. for Each User/Product2MED_PRODMedia Productnvarchar180
23JPTMG6IS-M: Planning Horizon for Quantity Planning2MED_PRODMedia Productnvarchar180
24JVSDDELIVCYCLESAIS-M: Assignment of Media Prods to Delivery Cycle/Sales Area7MED_PRODMedia Productnvarchar180
25JVSDDELIVCYCPRODIS-M: Assign Media Products to Delivery Cycle5MED_PRODMedia Productnvarchar180