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

45 columns | Print definition?ERP 6.0  | GSTRU

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1T444KLIS Planning: Screen Sequence Control Table1GSTRUGenerated DDIC table for LIS, conditions, messagesnvarchar300
TOPAvailability Check
2LATQ_ENQPersistent Lock Records for Product Allocation3GSTRUGenerated DDIC table for LIS, conditions, messagesnvarchar300
TOPBasic Data
3P44VPlanning Versions2GSTRUGenerated DDIC table for LIS, conditions, messagesnvarchar300
4T444PLIS Planning: Key Matrix Selection Control Table1GSTRUGenerated DDIC table for LIS, conditions, messagesnvarchar300
TOPBasic Functions
5T190HProduct Allocation: Planning Structure for this Step4GSTRUGenerated DDIC table for LIS, conditions, messagesnvarchar300
6T190VProduct allocations: Consumption period in an info structure2GSTRUGenerated DDIC table for LIS, conditions, messagesnvarchar300
TOPData Collection
7MCSCMFIELDSDefinition of field processing category in LIS Copy Mgmt1GSTRUGenerated DDIC table for LIS, conditions, messagesnvarchar300
8TMC1Generated DDIC Structures for LIS, Conditions, Output1GSTRUGenerated DDIC table for LIS, conditions, messagesnvarchar300
9TMC1DData Elements of Generated DDIC Structures1GSTRUGenerated DDIC table for LIS, conditions, messagesnvarchar300
10TMC1DSSave Versions for Table TMC1D1GSTRUGenerated DDIC table for LIS, conditions, messagesnvarchar300
11TMC1KKey Elements in Generated DDIC Structures1GSTRUGenerated DDIC table for LIS, conditions, messagesnvarchar300
12TMC1KSSave Versions for Table TMC1K1GSTRUGenerated DDIC table for LIS, conditions, messagesnvarchar300
13TMC1TShort Texts on Generated DDIC Structures2GSTRUGenerated DDIC table for LIS, conditions, messagesnvarchar300
14TMC4Global Control Elements: LIS Info Structure3GSTRUGenerated DDIC table for LIS, conditions, messagesnvarchar300
15TMC4UTransport Table for Info Structure Data2GSTRUGenerated DDIC table for LIS, conditions, messagesnvarchar300
TOPDistribution Requirements Planning
16MDRP_CONTRControl Table: DRP2GSTRUGenerated DDIC table for LIS, conditions, messagesnvarchar300
17MDRP_DRUNDeployment run3GSTRUGenerated DDIC table for LIS, conditions, messagesnvarchar300
TOPEarly Warning System
18MCY1Objects: Early Warning2GSTRUGenerated DDIC table for LIS, conditions, messagesnvarchar300
19MCYAEarly Warning: Exceptions3GSTRUGenerated DDIC table for LIS, conditions, messagesnvarchar300
TOPProduction Optimization Interface POI
20TCBP_MSVSOP versions2GSTRUGenerated DDIC table for LIS, conditions, messagesnvarchar300
TOPReporting
21MCKZSKey figure views in Logistics Controlling2GSTRUGenerated DDIC table for LIS, conditions, messagesnvarchar300
22MCKZSFKey figures for key figure view2GSTRUGenerated DDIC table for LIS, conditions, messagesnvarchar300
23MCKZSTTexts for key figures of the key figure view3GSTRUGenerated DDIC table for LIS, conditions, messagesnvarchar300
24MCRSVSelection versions: Header data3GSTRUGenerated DDIC table for LIS, conditions, messagesnvarchar300
TOPSales Plan
25ERZUEvent Assignment10GSTRUGenerated DDIC table for LIS, conditions, messagesnvarchar300
26ERZUTEvent Assignment9GSTRUGenerated DDIC table for LIS, conditions, messagesnvarchar300
27LISAKTBackground Planning Activities11GSTRUGenerated DDIC table for LIS, conditions, messagesnvarchar300
28LISCOPAKKey Figures Allocation Flexible Planning - CO-PA7GSTRUGenerated DDIC table for LIS, conditions, messagesnvarchar300
29LISCOPAMCharacteristics Allocation: Flexible Planning - CO-PA6GSTRUGenerated DDIC table for LIS, conditions, messagesnvarchar300
30LISCOPAZAssignment of info structure to operating concern7GSTRUGenerated DDIC table for LIS, conditions, messagesnvarchar300
31LISPLBackground Job for LIS Planning16GSTRUGenerated DDIC table for LIS, conditions, messagesnvarchar300
32LISRPlanning Object Index for Forecast6GSTRUGenerated DDIC table for LIS, conditions, messagesnvarchar300
33LISUPTransfer Profile: LIS Planning to Demand Management7GSTRUGenerated DDIC table for LIS, conditions, messagesnvarchar300
34P445EPlanning Object Index for Rough-Cut Planning Profiles8GSTRUGenerated DDIC table for LIS, conditions, messagesnvarchar300
35P445GParameters for PLOB Version_Key Figure5GSTRUGenerated DDIC table for LIS, conditions, messagesnvarchar300
36P445HVerification: Hier.Ctg./Hier.Form/Plan.Object/GSTRU (SOP)4GSTRUGenerated DDIC table for LIS, conditions, messagesnvarchar300
37PGANProportional Factors per Planning Object Relation (SOP/LIS)5GSTRUGenerated DDIC table for LIS, conditions, messagesnvarchar300
38SAUFSOP Orders3GSTRUGenerated DDIC table for LIS, conditions, messagesnvarchar300
39T445APlanning Configuration for Info Structure1GSTRUGenerated DDIC table for LIS, conditions, messagesnvarchar300
40T445EUnits for LIS Planning1GSTRUGenerated DDIC table for LIS, conditions, messagesnvarchar300
41T445IPlanning Attributes: Information Structure1GSTRUGenerated DDIC table for LIS, conditions, messagesnvarchar300
42T445NKStorage of decimal points2GSTRUGenerated DDIC table for LIS, conditions, messagesnvarchar300
43T445PPlanning Types: LIS/SOP2GSTRUGenerated DDIC table for LIS, conditions, messagesnvarchar300
44T445RCharacteristic Fields per Info Structure for Table T445Q1GSTRUGenerated DDIC table for LIS, conditions, messagesnvarchar300
TOPSCM Basis
45CIF_IMGSTIntegration Model Reference Table for Quota Info. Structures2GSTRUGenerated DDIC table for LIS, conditions, messagesnvarchar300