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

136 columns | Print definition?ERP 6.0  | ZAEHL

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/SMERP/STG_PM006Data staging - Equip List Set - Classifications - Cmplx Tab14ZAEHLSort Itemsmallint50
2/SMERP/STG_PM011Data staging - Func Loc. LSet - Classifications - Cmplx Tab14ZAEHLSort Itemsmallint50
3KSSK_CONVAllocation Table: Object to Class7ZAEHLSort Itemsmallint50
4SGT_PLKOSTask list - header - Segmentation5ZAEHLInternal counternvarchar80
5T731Key Figures in Info Library (Transport Table)12ZAEHLCounter of the calls in the Logistics Information Librarynvarchar80
6T731PInfo Set Assignment in LIL (Transport Table)3ZAEHLCurrent itemnvarchar30
7TCLDCharacteristic Data from Standard4ZAEHLCounter for materialnvarchar20
8TCY16Variable overview - column definition3ZAEHLCounter for terms in a column definition for the var. overv.nvarchar30
9TVGZUView Control: Special Table Access4ZAEHLCounter in control tablesnvarchar20
10ZPS12Project system: Text symbol assign. Standard netw/Routing6ZAEHLInternal counternvarchar80
11ZPS12FProject system: Text symbol assign. Standard netw/Routing7ZAEHLInternal counternvarchar80
12ZPS13Proj.system: Text symbol assign. proced. std.netw./wrk ctr6ZAEHLInternal counternvarchar80
TOPAdvertising Management
13JHTAPIS-M/AM: Settlement Run Log7ZAEHLCounter in control tablesnvarchar20
TOPBasic Data
14MKAL_AENDChange History of Production Version (Recipes Only)5ZAEHLCount parametersnvarchar40
TOPBasic Functions
15TVGMOView Control: Exceptions for Move-Corresponding4ZAEHLCounter in control tablesnvarchar20
TOPBatches
16TCHW2Units of Measurement for Batch-Specific Units of Measure5ZAEHLNumerator for a ratioint100
TOPCAD Integration
17USRCOBJObject Filters for Exploding Product Structures3ZAEHLCounterint100
TOPClasses
18KSSKAllocation Table: Object to Class7ZAEHLSort Itemsmallint50
19TCLAOSeveral Objects in one Class Type10ZAEHLClassification: Sort Itemnvarchar20
TOPComputer Aided Process Planning
20PLPHCAPP: Sub-operations6ZAEHLInternal counternvarchar80
TOPControlling
21CPZPBACKProduction Reporting Points Periodic Totals Values (Temp)5ZAEHLCounter for Reporting Pointsnvarchar80
22CPZPTEMPProduction Reporting Points Periodic Totals Values (Temp)5ZAEHLCounter for Reporting Pointsnvarchar80
23QRP_CPZPReporting Points - Total Values per Date6ZAEHLCounter for Reporting Pointsnvarchar80
TOPCost Object
24PZPELine Items for Measuring Point Update8ZAEHLCounter keynvarchar40
25PZPPProduction Measuring Points: Period Values4ZAEHLCounter keynvarchar40
26PZPSProduction Measuring Point for Totals Record4ZAEHLCounter keynvarchar40
TOPCross-Application Components
27MMAPLAllocation of task lists to materials8ZAEHLInternal counternvarchar80
28PDS_OPERPDS Data for Operations and Dependent Data10ZAEHLInternal counternvarchar80
29PLLPOTask list - operation/activity5ZAEHLInternal counternvarchar80
TOPDistribution Requirements Planning
30PLPLAN_PARAMBOM-dependent planning parameter5ZAEHLInternal counternvarchar80
TOPDocument Management System
31DRAOOriginals for documents7ZAEHLCounter keynvarchar40
32DRAOZAdditional Files for DMS Originals8ZAEHLCounter keynvarchar40
TOPEarly Warning System
33MCY1Objects: Early Warning4ZAEHLNatural Numberint100
34MCYBObjects: Early Warning3ZAEHLNatural Numberint100
35MCYCKey Figures: Early Warning3ZAEHLNatural Numberint100
36MCYDEarly Warning: Groups of Exceptions3ZAEHLNatural Numberint100
37MCYEEarly Warning: Trend Analysis Requirements3ZAEHLNatural Numberint100
38MCYMObjects: Early Warning3ZAEHLNatural Numberint100
TOPEnvironment
39LKSSKAllocation Table: Object to Class7ZAEHLSort Itemsmallint50
TOPFlow Manufacturing
40LDLBCTakts/no. of ind. capacities per line segment line balance4ZAEHLInternal counternvarchar80
41LDLBTLine hierarchy entry and exit takts3ZAEHLInternal counternvarchar80
42LDLHLine hierarchy header3ZAEHLInternal counternvarchar80
43LDLPLine hierarchy items4ZAEHLInternal counternvarchar80
44LDMDRLine Hierarchy Material-Dependent Rates4ZAEHLInternal counternvarchar80
TOPGeneral status management
45TJ49Table for Selection Conditions per SELID3ZAEHLCounter used to differentiate between data base entriesnvarchar40
TOPIndustry-Specific Component Automotive
46MHIS_UNPACKEDCopy of DB table MHIS (Data category INT4 replaced by NUMC)4ZAEHLMaintenance Package Numbernvarchar20
TOPInformation System
47MCAFVGVVersions: Order Procedure7ZAEHLInternal counternvarchar80
48MCSFISR/2 SFIS Data: Old70ZAEHLInternal counternvarchar80
TOPInspection Planning
49PLMKInspection plan characteristics7ZAEHLInternal counternvarchar80
50PLMWMAPL-Dependent Charac. Specifications (Inspection Plan)8ZAEHLInternal counternvarchar80
TOPIntegrated Product and Process Engineering
51CMIG_MAPPINGMapping Table (Classic PP and iPPE Objekt Key)14ZAEHLInternal counternvarchar80
TOPLogistics Execution
52/DSD/PE_PHYSICALHeader structure of SyncBO 'PhysicalUnit' for pricing engi5ZAEHLNumerator for conversion to SI unitint100
TOPLogistics Information Library
53MCLIKey Figures in Information Library12ZAEHLCounter of the calls in the Logistics Information Librarynvarchar80
54MCLIPInfo Set Assignment in LIL3ZAEHLCurrent itemnvarchar30
TOPMaintenance History
55HIKOOrder master data history27ZAEHLInternal counternvarchar80
56HIVGPM order history - operations10ZAEHLInternal counternvarchar80
TOPMaintenance Notifications
57QMIHQuality message - maintenance data excerpt38ZAEHLInternal counternvarchar80
TOPMaintenance Program Definition
58MPDCYCLEMPD: Cycle Data for Maintenance Document Items28ZAEHLMaintenance Package Numbernvarchar20
TOPMaintenance Task Lists
59EAPLAllocation of task lists to pieces of equipment7ZAEHLInternal counternvarchar80
60MHISMaintenance plan history4ZAEHLMaintenance Package Numbernvarchar20
61MMPTCycle definitions and MeasPoints for MaintPlan13ZAEHLMaintenance Package Numbernvarchar20
62PLWPAllocation of maintenance packages to task list operations8ZAEHLInternal counternvarchar80
63T351PMaintenance packages3ZAEHLMaintenance Package Numbernvarchar20
64T351P_OLDOld Version of Maintenance Packages3ZAEHLMaintenance Package Numbernvarchar20
65TAPLAllocation of task lists to functional locations7ZAEHLInternal counternvarchar80
TOPMaster Data Distribution
66/ISDFPS/TL1Task List - Operation/Activity5ZAEHLInternal counternvarchar80
TOPMaster Recipe
67PLFTProcess Instructions7ZAEHLInternal counternvarchar80
68PLFVPI Characteristics/Sub-Operation Parameter Values8ZAEHLInternal counternvarchar80
TOPMaterial Master
69MERRDAT_TMPFile for Incorrect Data in Direct Input3ZAEHL10 digit numbernvarchar100
70MFHM_TMPFile for Incorrect Data in Direct Input9ZAEHLInternal counternvarchar80
71MVHMMRP material version6ZAEHLInternal counternvarchar80
TOPNetwork and Activity
72MLSTMilestone3ZAEHLInternal counternvarchar80
73PLABRelationships11ZAEHLInternal counternvarchar80
74TCNTM03Assignment of date type/milestone to group5ZAEHLInternal counternvarchar80
TOPPeriodical Sales and Distribution
75JFFSIS-M/SD: Error Log for Collective Billing Doc.Processing6ZAEHLCounter in control tablesnvarchar60
76JFXJFFSDLIS-M: Backup Transfer Internal Table XJFFS8ZAEHLCounter in control tablesnvarchar20
77JLFSIS-M/SD: Error Log for Collective Settlement Processing6ZAEHLCounter in control tablesnvarchar60
TOPPlant Maintenance
78Z9I_STK_VORGANGTerminkontrolle Stillstandsplanung: Relevante Vorgänge12ZAEHLInterner Zählernvarchar80
79Z9MIANFStillstanndsplanung - Daten für Anfragen10ZAEHLInterner Zählernvarchar80
80Z9MISTPStillstandsplanung7ZAEHLInterner Zählernvarchar80
TOPProcess Order
81AFFTOrder - Process Instructions11ZAEHLInternal counternvarchar80
82AFFVOrder - Process Instruction Values13ZAEHLInternal counternvarchar80
TOPProduct Cost by Period
83CEZPReporting Points Line Items9ZAEHLCounter for Reporting Pointsnvarchar80
84CHZPReporting Points - Change History7ZAEHLCounter for Reporting Pointsnvarchar80
85CPZPReporting Points - Periodic Totals Values5ZAEHLCounter for Reporting Pointsnvarchar80
TOPProduct Cost Planning
86KEKOProduct Costing - Header Data67ZAEHLInternal counternvarchar80
TOPProduct Lifecycle Management
87DIWPS_CRWork Package Cross-Reference Notification12ZAEHLInternal counternvarchar80
88DIWPS_RV_CRRevision: Cross-Reference Notification9ZAEHLInternal counternvarchar80
TOPProduction Campaign
89PCMO1Pegged production campaign: material3ZAEHLInternal counternvarchar80
90PCMO2Pegged production campaign: requirements3ZAEHLInternal counternvarchar80
91PCMO3Pegged production campaign: recipe3ZAEHLInternal counternvarchar80
92PCMO4Production campaign pegged reqmt resource network3ZAEHLInternal counternvarchar80
93PCMPProduction campaign item3ZAEHLInternal counternvarchar80
TOPProduction Orders
94AFFLWork order sequence8ZAEHLInternal counternvarchar80
95AFKOOrder Header Data PP Orders60ZAEHLInternal counternvarchar80
96AFVCOperation within an order10ZAEHLInternal counternvarchar80
TOPProduction ResourcesTools
97CRFHCIM production resource/tool master data4ZAEHLInternal counternvarchar80
TOPQM Control in Procurement
98QINFQM-info record for material and vendor3ZAEHLInternal Counter for DB Objectsnvarchar60
TOPQuality Inspection
99QALSInspection lot record71ZAEHLInternal counternvarchar80
TOPRemaining Beverage - Obsolete Objects
100/BEV3/CHCIVBFSError Log Collective Run CH Docs. Using Create Invoice8ZAEHLCounter in control tablesnvarchar20
TOPRepetitive Manufacturing
101T437UControl Table for Further Processing of Goods Receipts5ZAEHLHelp counternvarchar30
TOPReporting
102MCKZSFKey figures for key figure view4ZAEHLSequence Numbernvarchar20
103MCRMKLIS selection versions: Characteristics3ZAEHLSequence Numbernvarchar20
104MCRSV_USRSelection version: Assigned distribution lists or users3ZAEHLSequence Numbernvarchar20
TOPResourcen Management
105MRTRST_HDRRMS-MRTRS : MR Transformation Header24ZAEHLInternal counternvarchar80
106MRTRST_POP_RELRMS-MRTRS : General Recipe Operation to Master Recipe Phase5ZAEHLInternal counternvarchar80
107MRTRST_PST_RELRMS-MRTRS: General Recipe Stage to Master Recipe Operation5ZAEHLInternal counternvarchar80
108MRTRST_QM_RELRMS-MRTRS : QM of GR Element to QM of MR Element7ZAEHLInternal counternvarchar80
109MRTRST_SEC_RELRMS-MRTRS: Equipment Requirement to Secondary Resource5ZAEHLInternal counternvarchar80
TOPResults Recording
110QAMVCharacteristic specifications for inspection processing120ZAEHLInternal counternvarchar80
TOPRouting
111MAPLAssignment of Task Lists to Materials8ZAEHLInternal counternvarchar80
112PLASTask list - selection of operations/activities7ZAEHLInternal counternvarchar80
113PLFHTask list - production resources/tools5ZAEHLInternal counternvarchar80
114PLFLTask list - sequences6ZAEHLInternal counternvarchar80
115PLKOTask list - header5ZAEHLInternal counternvarchar80
116PLMZAllocation of bill of material items to operations5ZAEHLInternal counternvarchar80
117PLPOTask list - operation/activity5ZAEHLInternal counternvarchar80
TOPScheduling
118KBEDCapacity Requirements Records40ZAEHLInternal counternvarchar80
TOPShipping
119VBFSError Log for Collective Processing6ZAEHLCounter in control tablesnvarchar20
TOPSimulation
120VSAFFL_CNVersion: Order sequences PP orders9ZAEHLInternal counternvarchar80
121VSAFKO_CNVersion: Order header data for PP orders61ZAEHLInternal counternvarchar80
122VSAFVC_CNVersion: Operation in order11ZAEHLInternal counternvarchar80
123VSHIST_NPTranfer history for network3ZAEHLCounter: Transfer objectsnvarchar80
124VSHIST_NVTranfer history for network activity4ZAEHLCounter: Transfer objectsnvarchar80
125VSHIST_OKTransfer history material components5ZAEHLCounter: Transfer objectsnvarchar80
126VSHIST_ORTransfer history order3ZAEHLCounter: Transfer objectsnvarchar80
127VSHIST_OVTransfer history activity4ZAEHLCounter: Transfer objectsnvarchar80
128VSHIST_PDTransfer history project definition3ZAEHLCounter: Transfer objectsnvarchar80
129VSHIST_PRTransfer history WBS element3ZAEHLCounter: Transfer objectsnvarchar80
130VSKBED_CNVersion: Capacity requirement records41ZAEHLInternal counternvarchar80
131VSMLST_CNVersion: Milestone4ZAEHLInternal counternvarchar80
TOPUnits of Measurement
132T006Units of Measurement11ZAEHLNumerator for conversion to SI unitint100
TOPVariant Configuration
133CUCOAdditional Data for Configurable Objects4ZAEHLInternal counternvarchar40
134IBVALUECCBASE: Redundant Object Doc. on Value Changes for Instance4ZAEHLNumerator for conversion to SI unitint100
135KRIFRichie Riffle3ZAEHLInternal counter for alternative access pathnvarchar40
TOPWork Center
136KAPECapacity unit of measure allocation5ZAEHLNumerator for conversion to SI unitint100