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

47 columns | Print definition?ERP 6.0  | MCINF

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1TMCSBLIS Information Structures3MCINFName of information structurenvarchar80
2TMCSTLIS Evaluations: Texts3MCINFName of information structurenvarchar80
3TQ57Assignment of quality score key to info structure2MCINFName of information structurenvarchar80
TOPBasic Data
4P444VPlanning Versions: Info Structures2MCINFName of information structurenvarchar80
5P44VPlanning Versions10MCINFName of information structurenvarchar80
TOPConsumption-Based Planning See Also PP-MRP
6TWVMOControl profiles for transferring material data to vendor7MCINF- obsolete -nvarchar80
7TWVMOQInfo System Access Parameters for Qty Sold and Forecast Data4MCINFName of information structurenvarchar80
TOPContract Billing
8TE539Information Structures of UIS for Mass Simulation3MCINFName of Information Structure for Mass Simulation Datanvarchar80
TOPData Collection
9TMC2LIS: Status Management - Updating2MCINFName of information structurenvarchar80
10TMC2DKey Figures (Updating)2MCINFName of information structurenvarchar80
11TMC2DSKey Figures (Updating)2MCINFName of information structurenvarchar80
12TMC2KObjects (Updating)2MCINFName of information structurenvarchar80
13TMC2KSObjects (Updating)2MCINFName of information structurenvarchar80
14TMC2PTable for Number Assignment of Update Reports2MCINFName of information structurenvarchar80
15TMC2QReference as to Which Update Uses Which Program2MCINFName of information structurenvarchar80
16TMC2SInfo Structures to be Updated per Business Event4MCINFName of information structurenvarchar80
17TMC4Global Control Elements: LIS Info Structure2MCINFName of information structurenvarchar80
18TMC4CConnections of Info Structures2MCINFName of information structurenvarchar80
19TMC4TDescriptions of LIS Information Structures3MCINFName of information structurenvarchar80
20TMC4UTransport Table for Info Structure Data1MCINFName of information structurenvarchar80
21TMC4UCTRansport Table for Info Structure Data Connections1MCINFName of information structurenvarchar80
22TMC4UTTransport Table for Info Structure Texts2MCINFName of information structurenvarchar80
23TMCBIWLIS: BIW Customizing2MCINFName of information structurenvarchar80
24TMCBIWULIS: BIW Customizing1MCINFName of information structurenvarchar80
TOPData Transfer
25T52EPAccount Assignment Type6MCINFPosting with matchcodenvarchar10
TOPDemand Management
26PBIDPlanned independent requirements index: MRP area23MCINFName of information structurenvarchar80
27PBIMIndependent Requirements for Material21MCINFName of information structurenvarchar80
TOPInformation System
28TMCW2Administrative Data for SIS Re-Setup2MCINFName of information structurenvarchar80
TOPLogistics Information System LIS
29TMCBIWCLIS: BW-Customizing - Version copier1MCINFName of information structurenvarchar80
TOPMerchandise and Assortment Planning
30TWISPC_PLSCH_WRetail Planning: Plng Step for Add. Table for Retail Applic.5MCINFName of information structurenvarchar80
31TWISPC_VRSIORetail Planning: Add-Ons to the LIS Plan Version2MCINFName of information structurenvarchar80
32TWISPC_VRSIOTRetail Planning: Texts for Add-Ons to LIS Plan Versions3MCINFName of information structurenvarchar80
33TWISPS01Retail Planning: Assignment Info Structure/Library2MCINFName of information structurenvarchar80
TOPPension fund General Parts
34T72F4HR-PF: FI Characteristics of Symbolic Accounts3MCINFMatchcode Determinationnvarchar10
35T72FAHR-PF: FI Index Table17MCINFMatchcode Determinationnvarchar10
TOPProduction Optimization Interface POI
36TCBP_MLSGeneral model data for SOP2MCINFName of information structurenvarchar80
TOPRecycling Administration Core Functions
37J_7LC09REA Customizing: General Controls21MCINFInformation Structure for Movement Data from Billingnvarchar80
38J_7LC40REA Info System: Recycling Partner-Spec. LIS Update5MCINFName of information structurenvarchar80
39J_7LE09REA Partner Master: Document Types57MCINFInformation Structure for Movement Data from Billingnvarchar80
TOPRemaining Beverage - Obsolete Objects
40/BEV1/RBPAIntermediate Table (Material-Specific Contrib. Margin Acc.)24MCINFName of information structurenvarchar80
41/BEV1/RBSTAFODefine Update Groups for Virtual Documents3MCINFName of information structurenvarchar80
TOPReporting
42TMC7Standard Analyses in Logistics Controlling4MCINFName of information structurenvarchar80
43TMCSALIS Evaluations2MCINFName of evaluation structurenvarchar80
44TMCSCLIS Libraries2MCINFName of information structurenvarchar80
TOPRetail Information System RIS
45MCWPSFile for storing results of function group MCWPS3MCINFTable name, 16 charactersnvarchar160
TOPSales Plan
46T445C2Planning Period Units of Info Structure1MCINFName of information structurenvarchar80
47T445USales and Operations Planning/Initial Settings per User5MCINFName of information structurenvarchar80