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

62 columns | Print definition?ERP 6.0  | ANNAM

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPBasic Data
1MKAL_AENDChange History of Production Version (Recipes Only)10ANNAMUser who created recordnvarchar120
TOPBills of Material
2CLSTLink class - BOM7ANNAMUser who created recordnvarchar120
3CSORDER_MATAdministration of generated materials per sales order11ANNAMUser who created recordnvarchar120
4CSPRJ_MATManagement of generated materials to project10ANNAMUser who created recordnvarchar120
5DOSTDocument to BOM Link8ANNAMUser who created recordnvarchar120
6EQSTEquipment to BOM Link8ANNAMUser who created recordnvarchar120
7KDSTSales Order to BOM Link10ANNAMUser who created recordnvarchar120
8MASTMaterial to BOM Link10ANNAMUser who created recordnvarchar120
9PRSTProject - BOM link9ANNAMUser who created recordnvarchar120
10PSGRMaster item group3ANNAMUser who created recordnvarchar120
11PSVRMaster alternative items4ANNAMUser who created recordnvarchar120
12STASBOMs - Item Selection12ANNAMUser who created recordnvarchar120
13STKOBOM Header13ANNAMUser who created recordnvarchar120
14STPOBOM item13ANNAMUser who created recordnvarchar120
15STSTStandard BOM Link8ANNAMUser who created recordnvarchar120
16TPSTLink Between Functional Location and BOM8ANNAMUser who created recordnvarchar120
TOPComputer Aided Process Planning
17PLPHCAPP: Sub-operations11ANNAMUser who created recordnvarchar120
18VERFKProcess header data6ANNAMUser who created recordnvarchar120
19VFORKFormula header data6ANNAMUser who created recordnvarchar120
20VMETKMethod header data12ANNAMUser who created recordnvarchar120
TOPCross-Application Components
21MMAPLAllocation of task lists to materials15ANNAMUser who created recordnvarchar120
22PLLPOTask list - operation/activity12ANNAMUser who created recordnvarchar120
TOPEarly Warning System
23MCYAEarly Warning: Exceptions4ANNAMCreated bynvarchar120
TOPEngineering Change Management
24AEDTEngineering Change Management: Alternative Dates6ANNAMUser who created recordnvarchar120
25AEEFECM: effectivity18ANNAMUser who created recordnvarchar120
26AEHIChange hierarchy5ANNAMUser who created recordnvarchar120
27AENRChange Master8ANNAMUser who created recordnvarchar120
28AENVECH: Object Types for Change Master12ANNAMUser who created recordnvarchar120
29AEOIECH: Object Management Records for Change Master12ANNAMUser who created recordnvarchar120
30AEPFECM: effectivity17ANNAMUser who created recordnvarchar120
31AEPRECIdentical object in explosion (header)9ANNAMUser who created recordnvarchar120
32ECM_ADMAdministrative Data4ANNAMCreated Bynvarchar120
33TECSMaster Effectivity Object4ANNAMUser who created recordnvarchar120
TOPFlow Manufacturing
34LDLBHLine balance/planned rate header record15ANNAMUser who created recordnvarchar120
35LDLHLine hierarchy header5ANNAMUser who created recordnvarchar120
TOPLine Maintenance
36/ISDFPS/LM_ACC_HLM - Accident Header10ANNAMUser who created recordnvarchar120
TOPMaintenance
37/ISDFPS/PM_MB_HPM Maintenance Book - Header9ANNAMUser who created recordnvarchar120
TOPMaintenance Task Lists
38EAPLAllocation of task lists to pieces of equipment17ANNAMUser who created recordnvarchar120
39PLWPAllocation of maintenance packages to task list operations18ANNAMUser who created recordnvarchar120
40TAPLAllocation of task lists to functional locations15ANNAMUser who created recordnvarchar120
TOPMaster Data Distribution
41/ISDFPS/TL1Task List - Operation/Activity12ANNAMUser who created recordnvarchar120
TOPMaster Recipe
42PLFTProcess Instructions12ANNAMUser who created recordnvarchar120
43PLFVPI Characteristics/Sub-Operation Parameter Values13ANNAMUser who created recordnvarchar120
TOPNetwork and Activity
44PLABRelationships27ANNAMUser who created recordnvarchar120
TOPProduct Data Management
45KLFBAssignment: Class to template8ANNAMUser who created recordnvarchar120
TOPProduction ResourcesTools
46CRFHCIM production resource/tool master data12ANNAMUser who created recordnvarchar120
TOPReporting
47MCRSVSelection versions: Header data4ANNAMName of Person who Created the Objectnvarchar120
48MCSHIERKHeader of general hierarchy12ANNAMName of Person who Created the Objectnvarchar120
TOPResourcen Management
49MRTRST_HDRRMS-MRTRS : MR Transformation Header30ANNAMUser who created recordnvarchar120
50MRTRST_POP_RELRMS-MRTRS : General Recipe Operation to Master Recipe Phase14ANNAMUser who created recordnvarchar120
51MRTRST_PRI_RELRMS-MRTRS : Equipment Requirement to Primary Resource12ANNAMUser who created recordnvarchar120
52MRTRST_PST_RELRMS-MRTRS: General Recipe Stage to Master Recipe Operation14ANNAMUser who created recordnvarchar120
53MRTRST_QM_RELRMS-MRTRS : QM of GR Element to QM of MR Element23ANNAMUser who created recordnvarchar120
54MRTRST_SEC_RELRMS-MRTRS: Equipment Requirement to Secondary Resource15ANNAMUser who created recordnvarchar120
55MRTRST_STR_MATRMS-MRTRS: Assignment of Stream to Material14ANNAMUser who created recordnvarchar120
56MRTRST_STR_RELRMS-MRTRS: Stream with QM to Master Recipe Phase11ANNAMUser who created recordnvarchar120
TOPRouting
57MAPLAssignment of Task Lists to Materials15ANNAMUser who created recordnvarchar120
58PLASTask list - selection of operations/activities14ANNAMUser who created recordnvarchar120
59PLFLTask list - sequences13ANNAMUser who created recordnvarchar120
60PLKOTask list - header12ANNAMUser who created recordnvarchar120
61PLMZAllocation of bill of material items to operations27ANNAMUser who created recordnvarchar120
62PLPOTask list - operation/activity12ANNAMUser who created recordnvarchar120