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
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7OPCH386A/P Invoice
8OVTG52Tax Definition
9OPOR386Purchase Order
10JDT1124Journal Entry - Rows

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OVPM154Outgoing Payments
5OIVL77Whse Journal
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

198 columns | Print definition?ERP 6.0  | EQUNR

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/GEP/T_NEEDGraphischer Leitstand: Bedarfe (einzuplanende Objekte)42EQUNRFahrzeugnvarchar180
2/GEP/T_SPLITGraphischer Leitstand: Splits (eingeplante Objekte)43EQUNRFahrzeugnvarchar180
3/ISDFPS/BLTSTADJBacklog Adjustment: Technical Status4EQUNREquipment Numbernvarchar180
4/SMERP/STG_PM001Data staging - Equipment complex table8EQUNREquipment Numbernvarchar180
5/SMERP/STG_PM003Data staging - Equipment List Set - Hdr - complex tab8EQUNREquipment Numbernvarchar180
6/SMERP/STG_PM004Data staging - Equipment list set - Measuring Points62EQUNREquipment Numbernvarchar180
7/SMERP/STG_PM006Data staging - Equip List Set - Classifications - Cmplx Tab8EQUNREquipment Numbernvarchar180
8/SMERP/STG_PM007Data staging - Equip List Set - Char Values - complex table8EQUNREquipment Numbernvarchar180
9/SMERP/STG_PM009Data staging - Func. Loc. List Set - Meas. Pts - cmplex tab62EQUNREquipment Numbernvarchar180
10CIF_IMRESTMEQIntegration Model Reference Table for Equipment2EQUNREquipment Numbernvarchar180
11CNVTDMS_05_EQUITDMS Header table for EQUI table3EQUNREQUNR for table CNVTDMS_05_EQUInvarchar180
12DBERCHECondition Data14EQUNREquipment Numbernvarchar180
13ECRM_MIOMR_TMPTemporary MR Data4EQUNREquipment Numbernvarchar180
14S555ES555 - Structural Information5EQUNREquipment Numbernvarchar180
15S901ES901 - Strukturinformationen6EQUNREquipmentnummernvarchar180
TOPAerospace Defence Industry Solution
16EQUIPKPIUsed to store the Delta values and counters for MTBE calc2EQUNREquipment Numbernvarchar180
TOPAMI Event Management
17EFDT_EXPR002FDT: Expression - Notification Order8EQUNREquipment Numbernvarchar180
18EFDT_EXPR002AFDT: Expression - Create Notification Order8EQUNREquipment Numbernvarchar180
19EFDT_EXPR002SFDT: Expression - Create Notification Order7EQUNREquipment Numbernvarchar180
20EFDT_EXPR002TFDT: Expression - Create Notification Order7EQUNREquipment Numbernvarchar180
21TEAMI_EM_EVTSIS-U AMI Event Management AMI Events10EQUNREquipment Numbernvarchar180
TOPAppropriation Requests
22IMAKAApprop. request for assets or equipment to be replaced7EQUNREquipment Numbernvarchar180
TOPBills of Material
23EQSTEquipment to BOM Link2EQUNREquipment Numbernvarchar180
TOPBulk Distribution Requirements Planning
24OIIGMMKGMM: General meter header table5EQUNREquipment numbernvarchar180
TOPConstruction Equipment Management
25/SAPCEM/EQU_KAPAssignment of Equipment to Indiv. Capacity2EQUNREquipment Numbernvarchar180
26J_3GBELKDocument File - Header Data62EQUNREquipment Numbernvarchar180
27J_3GBELPDocument Data - Item Data64EQUNREquipment Numbernvarchar180
28J_3GEQUMPAssignment of Measuring Point to Equipment4EQUNREquipment Numbernvarchar180
29J_3GSTLAKTActivation File/Buffer for BOMs2EQUNREquipment Numbernvarchar180
30J_3GSTLKOPFHeader Data for Equipment BOMs2EQUNREquipment Numbernvarchar180
31J_3GVBRPCEM Additional Data for VBRP4EQUNREquipment Numbernvarchar180
32J_3GVBRP_ZFrozen Data from VBRP Conversion4EQUNREquipment Numbernvarchar180
33J_3GVERSITax/Insurance Data2EQUNREquipment Numbernvarchar180
34J_3GZVBAPBackup Table for CEM Data in Rel. 3.04EQUNREquipment Numbernvarchar180
TOPContract Billing
35DBERCHZIndividual Line Items27EQUNREquipment Numbernvarchar180
36DBERCHZ2Individual line items (device data)4EQUNREquipment Numbernvarchar180
37DBERCHZ6Document line items (device data, unimportant rows)4EQUNREquipment Numbernvarchar180
38ERCHZ_SHORTBilling Document Individual Lines Extract45EQUNREquipment Numbernvarchar180
39ETTIFInstln Facts27EQUNRAllocation of reference value to equipment numbernvarchar180
40ETTIFBInstallation Facts (Reference Values)20EQUNRAllocation of reference value to equipment numbernvarchar180
TOPData Collection
41S064ES064 - Structural information4EQUNREquipment Numbernvarchar180
42S116Customer Analysis15EQUNREquipment Numbernvarchar180
43S116ES116 - Structural information10EQUNREquipment Numbernvarchar180
44S555Info structure Wolgang Backes10EQUNREquipment Numbernvarchar180
45S901Garantieauswertung11EQUNR????? ??????? ????????????nvarchar180
TOPDevice installation
46ETDZTechnical Data for Installed Register2EQUNREquipment Numbernvarchar180
TOPDevice Management
47EDEVGR_CDChange Document for Dev. Group: Table with Device Data3EQUNREquipment Numbernvarchar180
48EGEREDraw and Sampling Number of a Device2EQUNREquipment Numbernvarchar180
49EGERHHistorical Data of ISU Device Master Record2EQUNREquipment Numbernvarchar180
50EGERRDevice data: Info record for point of delivery - historical2EQUNREquipment Numbernvarchar180
51EGERSIS-U Device Master Data2EQUNREquipment Numbernvarchar180
52EGLODevices per Sample Lot4EQUNREquipment Numbernvarchar180
53EGTURPeriodic Replacement List2EQUNREquipment Numbernvarchar180
54TE571Sample Devs per Sample Lot5EQUNREquipment Numbernvarchar180
55TELOT_LOCKEDBlocked Devices During Lot Compilation (B/NL)3EQUNREquipment Numbernvarchar180
TOPDistributed Maintenance
56/ISDFPS/PMDISEQDistributed Maintenance - Dismantled Equipment2EQUNREquipment Numbernvarchar180
TOPDistributor-Reseller-Management
57S491CEM Construction Site Stock Value12EQUNREquipment Numbernvarchar180
58S491ES491 - Structure Information7EQUNREquipment Numbernvarchar180
59S492CEM Total Costs for Equipment12EQUNREquipment Numbernvarchar180
60S492ES492 - Structure Information7EQUNREquipment Numbernvarchar180
TOPEquipment
61EQKTEquipment Short Texts2EQUNREquipment Numbernvarchar180
62EQUIEquipment master data2EQUNREquipment Numbernvarchar180
63EQUZEquipment time segment2EQUNREquipment Numbernvarchar180
64IEQT_WL_HDR_BACInterim Statuses - Header Data (Backup)3EQUNREquipment Numbernvarchar180
65IEQT_WL_HEADERInterim Statuses - Header Data2EQUNREquipment Numbernvarchar180
66IEQT_WL_ITEMSInterim Statuses - Items2EQUNREquipment Numbernvarchar180
67IEQT_WL_ITM_BACInterim Statuses - Items (Backup)3EQUNREquipment Numbernvarchar180
68IEQT_WL_MPInterim Statuses: Measurement Objects2EQUNREquipment Numbernvarchar180
TOPFlexible Real Estate Management
69VIBDPMEQOBSOLETE: Link from RE Object to Equipment3EQUNREquipment Numbernvarchar180
TOPIndustrial Hygiene and Safety
70CCIHT_IALEHS: Incident/Accident Log - Header24EQUNREquipment Numbernvarchar180
71CCIHT_MPDVEHS: Devices Required for Measurement Project24EQUNREquipment Numbernvarchar180
TOPIndustry Solution Engineering Construction
72A254Customer or Goods Recipient/Equipment/Material5EQUNREquipment Numbernvarchar180
73A270Euqipment/Document Type4EQUNREquipment Numbernvarchar180
74A272Equipment/Standard Dummy Customer/Document Type4EQUNREquipment Numbernvarchar180
75KOT4005Debited Co. Code/Debited Business Area/Recipient/Equipment7EQUNREquipment Numbernvarchar180
76KOTJ005Debited Co. Code/Debited Business Area/Recipient/Equipment7EQUNREquipment Numbernvarchar180
TOPInventory Management
77MSEGDocument Segment: Material49EQUNREquipment Numbernvarchar180
78MWXMSEGZMSEG: Interface for Posting of Value49EQUNREquipment Numbernvarchar180
79MWZMSEGZMSEG:Interface for Posting of Value49EQUNREquipment Numbernvarchar180
TOPInvoicing
80DBERDZDB Table: Individ. Lines - Print Document53EQUNREquipment Numbernvarchar180
TOPLine Maintenance
81/ISDFPS/LMEQEXTEnhancements to the Equipment Tables for Line Maintenance2EQUNREquipment Numbernvarchar180
82/ISDFPS/LMSITEEQSite Equipment in Line Maintenance Process2EQUNREquipment Numbernvarchar180
83/ISDFPS/LMUSAGEUsage Rate for an Aircraft2EQUNREquipment Numbernvarchar180
84/ISDFPS/LM_ACC_HLM - Accident Header3EQUNREquipment Numbernvarchar180
TOPLogbook
85DIACL_CLISTDI CLIST: Component data12EQUNREquipment Numbernvarchar180
TOPMaintenance
86/ISDFPS/PM_MB_HPM Maintenance Book - Header19EQUNREquipment Numbernvarchar180
TOPMaintenance History
87HIKOOrder master data history34EQUNREquipment Numbernvarchar180
88HIVGPM order history - operations72EQUNREquipment Numbernvarchar180
TOPMaintenance Notifications
89QMFEQuality notification - items56EQUNREquipment Numbernvarchar180
90QMIHQuality message - maintenance data excerpt6EQUNREquipment Numbernvarchar180
TOPMaintenance Orders
91/CUM/CUDESIGNCU: Design Header Data22EQUNREquipment Numbernvarchar180
92/CUM/PRF_ORDCU: Profile for Order Generation16EQUNREquipment Numbernvarchar180
93/MRSS/D_EQU_GUIDMapping Equnr(containing characters) with Guids2EQUNREquipment Numbernvarchar180
94AFIHMaintenance order header5EQUNREquipment Numbernvarchar180
95T352RMaintenance revisions12EQUNREquipment Numbernvarchar180
96TPMUSPM/SM - User default values25EQUNREquipment Numbernvarchar180
TOPMaintenance Program Definition
97MPDCDMPD: OBSOLETE - Counter Data for Maintenance Document Items3EQUNREquipment Numbernvarchar180
98MPDCYCLEMPD: Cycle Data for Maintenance Document Items3EQUNREquipment Numbernvarchar180
TOPMaintenance Task Lists
99EAPLAllocation of task lists to pieces of equipment2EQUNREquipment Numbernvarchar180
100MPLAMaintenance plan12EQUNREquipment Numbernvarchar180
101MPOSMaintenance item7EQUNREquipment Numbernvarchar180
TOPMaster Data
102ETINSTechnical information for the premise3EQUNREquipment Numbernvarchar180
TOPMaster Data Distribution
103/ISDFPS/EQUI_CODistribution of Equipment: Save CO Data of Central System2EQUNREquipment Numbernvarchar180
TOPMaterials Management
104/ISDFPS/EQUIAZALoading Object: Dependent on Cooperation2EQUNREquipment Numbernvarchar180
105/ISDFPS/EQUITRPAssignment: Storage Bin --> Equipment (Loading Object)5EQUNREquipment Numbernvarchar180
TOPMeter Reading
106EABLMR Document4EQUNREquipment Numbernvarchar180
107EABLDELDeleted Meter Reading Document4EQUNREquipment Numbernvarchar180
108EIKEIndex for Removed Device -> Removal Not Yet Entered2EQUNREquipment Numbernvarchar180
TOPMigration
109VIGW_IM_EQAbbildung Immoobjekt zu Equipment3EQUNRLaitenumeronvarchar180
TOPMobile Applications
110/ISDFPS/MEDEVDATMiddleware Device Data4EQUNREquipment Numbernvarchar180
TOPMove-InOut
111ECAMIOPRMRIS-U: Parked Document: MR Results and Period Consumption3EQUNREquipment Numbernvarchar180
TOPOperative Structures
112PRPSWBS (Work Breakdown Structure) Element Master Data39EQUNREquipment Numbernvarchar180
TOPPermits
113IHSGObject-Related Permits in Plant Maintenance14EQUNREquipment Numbernvarchar180
TOPPlant Maintenance
114MCB_BUDMCB Retraction data for Budget check2EQUNREquipment Numbernvarchar180
115Z9I_STK_IF_NPVPM/PS-Schnittstelle: Netzplanvorgänge4EQUNREquipmentnummernvarchar180
116Z9I_STK_IF_NPV_WPM/PS-Schnittstelle: Netzplanvorgänge Werkstattsicht4EQUNREquipmentnummernvarchar180
117Z9I_STK_IF_PSPPM/PS-Interface: PSP-Elemente3EQUNREquipmentnummernvarchar180
118Z9I_STK_IF_PSP_WPM/PS-Interface: PSP-Elemente Werkstattsicht3EQUNREquipmentnummernvarchar180
119Z9I_STK_VORGANGTerminkontrolle Stillstandsplanung: Relevante Vorgänge5EQUNREquipmentnummernvarchar180
120Z9MIANFStillstanndsplanung - Daten für Anfragen5EQUNREquipmentnummernvarchar180
121Z9MISTPStillstandsplanung3EQUNREquipmentnummernvarchar180
TOPPool Asset Management
122PAMS_NEEDGraphical Planning Board: Requests (Objects to Schedule)26EQUNREquipment Numbernvarchar180
123PAMS_SPLITGraphical Planning Board: Splits (Scheduled Objects)27EQUNREquipment Numbernvarchar180
TOPProcessing
124EWMINSPDETAILInspection List Detail4EQUNREquipment Numbernvarchar180
TOPProduct Structure Browser
125USROBJECTSTable of Previous Initial Object in Structure Overview10EQUNREquipment Numbernvarchar180
TOPProduction and Revenue Accounting
126OIU_ME_CNTNRGeneral measurement container11EQUNREquipment Numbernvarchar180
TOPProduction Orders
127AFVCOperation within an order182EQUNREquipment Numbernvarchar180
TOPProduction ResourcesTools
128CRVE_AAssignment PRT data - equipment4EQUNREquipment Numbernvarchar180
129CRVE_BAssignment equipment - PRT data2EQUNREquipment Numbernvarchar180
TOPQuality Inspection
130QAPPInspection point11EQUNREquipment Numbernvarchar180
TOPReal Estate Management
131VIOB21Fixtures and fittings objects for room9EQUNRDummy field: no longer used (3.0)nvarchar180
TOPRemaining Beverage - Obsolete Objects
132/BEV3/CHBSALEIPayment in Kind Agreement22EQUNREquipment numbernvarchar180
133/BEV3/CHCDPOBLIGCDP: Contractual Services17EQUNREquipment numbernvarchar180
134/BEV3/CHKAOBLIGACustomer Evaluation Table: Contract Performances18EQUNREquipment numbernvarchar180
TOPRemote Logistics Management
135OIO_MX_OBJECTRLM tracking extract object data45EQUNREquipment Numbernvarchar180
TOPReporting
136MCIPMISPMIS: Master data characteristics for PMIS before image5EQUNREquipment Numbernvarchar180
137S061Location and planning14EQUNREquipment Numbernvarchar180
138S061ES061 - Structural Information9EQUNREquipment Numbernvarchar180
139S063Damage Analysis 30 .9EQUNREquipment Numbernvarchar180
140S063ES063 - Structural Information4EQUNREquipment Numbernvarchar180
141S064Single object - damage analysis9EQUNREquipment Numbernvarchar180
142S070Breakdown Statistics10EQUNREquipment Numbernvarchar180
143S070ES070 - Structural Information5EQUNREquipment Numbernvarchar180
144S114Fahrzeugverbrauchsanalyse16EQUNREquipmentnummernvarchar180
145S114ES114 - Strukturinformationen11EQUNREquipmentnummernvarchar180
146S115Cost Evaluation11EQUNREquipment Numbernvarchar180
147S115ES115 - Structural Information6EQUNREquipment Numbernvarchar180
TOPResults Recording
148QAESSample unit table4EQUNREquipment Numbernvarchar180
TOPRouting
149PLPOTask list - operation/activity219EQUNREquipment Numbernvarchar180
TOPSAP Utilities
150EABLCTemporary Meter Reading Document in AMI Environment4EQUNREquipment Numbernvarchar180
151EAMI_DEVICE_STATAMI: Device Status2EQUNREquipment Numbernvarchar180
152SEAL_INSeal11EQUNREquipment Numbernvarchar180
153TEAMI_MSGMessages4EQUNREquipment Numbernvarchar180
154TEAMI_OPSTATE_RQTable for Operational State Request3EQUNREquipment Numbernvarchar180
TOPSerial Numbers
155EQBSSerial Number Stock Segment2EQUNREquipment Numbernvarchar180
156EQSESerial Number Records9EQUNREquipment Numbernvarchar180
157OBJKPlant Maintenance Object List4EQUNREquipment Numbernvarchar180
158SERBLPlant Maintenance Object List6EQUNREquipment Numbernvarchar180
159SERISerial Numbers8EQUNREquipment Numbernvarchar180
TOPService Station Retailing
160OIRBMATMETBusiness Location material/meter assignment (IS-Oil, SSR)7EQUNREquipment Numbernvarchar180
161OIRC_GMMHSSR Meters - History25EQUNREquipment numbernvarchar180
162OIRC_GMMH_AGG01SSR Meters - Aggregated history (Monthly)9EQUNREquipment numbernvarchar180
163OIRC_GMMH_AGG011SSR Meters - Aggregated history (Monthly)8EQUNREquipment numbernvarchar180
164OIRC_GMMH_DELSSR Meters - Deleted meter readings history26EQUNREquipment numbernvarchar180
165OIRC_MRREJSSR Meters - Meter readings rejected records28EQUNREquipment numbernvarchar180
TOPSimulation
166VSAFIH_CNVersion: Order header for plant maintenance6EQUNREquipment Numbernvarchar180
167VSAFVC_CNVersion: Operation in order186EQUNREquipment Numbernvarchar180
168VSPRPS_CNVersion: WBS Element (Work Breakdwn Struc. Elem.) Mast. Data40EQUNREquipment Numbernvarchar180
TOPSoftware Management
169S426Variant Config.1---IBASE8EQUNREquipment Numbernvarchar180
170S426ES426 - Structural information3EQUNREquipment Numbernvarchar180
171S427Variant Config.2---IBASE12EQUNREquipment Numbernvarchar180
172S427ES427 - Structural information7EQUNREquipment Numbernvarchar180
173TOGM1Software Maintenance Process: Collective Processing8EQUNREquipment Numbernvarchar180
TOPStructures Workbench
174HRP1959DB Table for Infotype 195918EQUNREquipment Numbernvarchar180
TOPTakeoverHandover of Technical Objects
175PHINTPhase In Table18EQUNREquipment Numbernvarchar180
TOPTechnical Objects
176TITOB_IBASECreation of IBase: Buffer Table Structures5EQUNREquipment Numbernvarchar180
TOPTemplates
177PRPSSStandard WBS Element (WBS element) - Master Data39EQUNREquipment Numbernvarchar180
TOPTraders and Schedulers Workbench
178OIGCMTD Vehicle Meter5EQUNREquipment Numbernvarchar180
179OIISOCKSOC: Storage object characteristic segment header7EQUNREquipment numbernvarchar180
TOPTransportation and Distribution
180OIGRMTD Rack Meter Master Table6EQUNREquipment Numbernvarchar180
TOPTransportation Planning
181/DSD/RP_FLTLICDriver's License Category of a Vehicle2EQUNREquipment Numbernvarchar180
182/DSD/RP_FLTLOCKLock Times of a Vehicle2EQUNREquipment Numbernvarchar180
183/DSD/RP_FLTTPLSTTransportation Planning Point of a Vehicle2EQUNREquipment Numbernvarchar180
TOPUnique Identification
184UII_IUIDUnique Item Identifier2EQUNREquipment Numbernvarchar180
TOPVehicle Management System
185VLCVEHICLEVELO : Vehicle7EQUNREquipment Numbernvarchar180
TOPWaste Management
186EWADCFLLinks Table for Waste Disposal Orders8EQUNREquipment Numbernvarchar180
187EWAELOCSDAllocation Table: Container Loc.Data <-> Sales Document Item8EQUNREquipment Numbernvarchar180
188EWAELOCSD_INTEWAELOCSD Dummy Table With Key Fields as CHAR10EQUNREquipment Numbernvarchar180
189EWAELOCSD_NEWAllocation Table: Container Loc.Data <-> Sales Document Item10EQUNREquipment Numbernvarchar180
190EWAEQUIIS-U WA: Additional Data for Equipment Master2EQUNREquipment Numbernvarchar180
191EWAOBJHeader Data for Service Frequency10EQUNREquipment Numbernvarchar180
192EWA_CCOC_ASS_EQCO Assignment and Vehicle5EQUNREquipment Numbernvarchar180
193EWA_CCOC_ASS_REAllocate CO and Container (Rent)6EQUNREquipment Numbernvarchar180
TOPWork Clearance Management
194WCAAPWCM: Application27EQUNREquipment Numbernvarchar180
195WCAHEWCM: Work Clearance Document (Header)27EQUNREquipment Numbernvarchar180
196WCAJWCM: Lineup15EQUNREquipment Numbernvarchar180
197WCAWWCM: Work Approval25EQUNREquipment Numbernvarchar180
TOPWork Management Mobile Business
198EWM_ELWEG_INDEXIndex Table for Street Route2EQUNREquipment Numbernvarchar180