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

119 columns | Print definition?ERP 6.0  | TPLNR

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/GEP/FLEET_T_CPOCar Pools2TPLNRCar Poolnvarchar300
2/GEP/T_NEEDGraphischer Leitstand: Bedarfe (einzuplanende Objekte)43TPLNRFuhrparknvarchar300
3/GEP/T_SPLITGraphischer Leitstand: Splits (eingeplante Objekte)44TPLNRFuhrparknvarchar300
4/SMERP/STG_PM001Data staging - Equipment complex table121TPLNRFunctional Locationnvarchar300
5/SMERP/STG_PM002Data staging - Functional Location complex table8TPLNRFunctional Locationnvarchar300
6/SMERP/STG_PM003Data staging - Equipment List Set - Hdr - complex tab121TPLNRFunctional Locationnvarchar300
7/SMERP/STG_PM004Data staging - Equipment list set - Measuring Points61TPLNRFunctional Locationnvarchar300
8/SMERP/STG_PM008Data staging - Functional Loc. List Set - Hdr - complex tab8TPLNRFunctional Locationnvarchar300
9/SMERP/STG_PM009Data staging - Func. Loc. List Set - Meas. Pts - cmplex tab61TPLNRFunctional Locationnvarchar300
10/SMERP/STG_PM011Data staging - Func Loc. LSet - Classifications - Cmplx Tab8TPLNRFunctional Locationnvarchar300
11/SMERP/STG_PM012Data staging - Func Loc LSet - Char Values - complex table8TPLNRFunctional Locationnvarchar300
12CIF_IMRESTMFLIntegration Model Reference Table for Functional Location2TPLNRFunctional Locationnvarchar300
13CNVTDMS_05_TPLNRFill header for Conn. Object3TPLNRChar 30nvarchar300
14EAM_REG_PLANRegular Task Planning Schedule9TPLNRFunctional Locationnvarchar300
15GHO_ALC_SRC_DFEVDeferment Event source data to invalidate Allocation results6TPLNRFunctional Locationnvarchar300
16GHO_ALERTStore Network Alerts10TPLNRFunctional Locationnvarchar300
17GHO_DM_EVENTDeferment Event Data3TPLNRFunctional Locationnvarchar300
18GHO_EVT_SRC_DATATable to store deferment events souce data used in alloc run11TPLNRFunctional Locationnvarchar300
19GHO_WC_NATUREWell completion nature2TPLNRFunctional Locationnvarchar300
20GHO_WELLCLASS_LCWell class Lifecycle2TPLNRFunctional Locationnvarchar300
21IEAM_TASK_LTTask Attributes5TPLNRFunctional Locationnvarchar300
22S555ES555 - Structural Information4TPLNRFunctional Locationnvarchar300
23S901ES901 - Strukturinformationen5TPLNRTechnischer Platznvarchar300
24SFTT_EQUIEquipment Status diary6TPLNRFunctional Locationnvarchar300
25SFTT_EQUICEquipment Current Status4TPLNRFunctional Locationnvarchar300
26SFTT_EQUIMEquipment Master Data4TPLNRFunctional Locationnvarchar300
27SFTT_REG_TASKRegular Tasks List for Item Data9TPLNRFunctional Locationnvarchar300
28SFTT_SNShift Notes: Master Data7TPLNRFunctional Locationnvarchar300
29TTS_SM_DATASafety Measure and Supplemental Safety Measure Data4TPLNRFunctional Locationnvarchar300
TOPAerospace Defence Industry Solution
30EQUIPKPIUsed to store the Delta values and counters for MTBE calc5TPLNRFunctional Locationnvarchar300
TOPAppropriation Requests
31IMAKAppropriation requests - general data17TPLNRFunctional Locationnvarchar300
TOPBasic Functions
32ANLZTime-Dependent Asset Allocations21TPLNRFunctional Locationnvarchar300
TOPBills of Material
33TPSTLink Between Functional Location and BOM2TPLNRFunctional Locationnvarchar300
TOPBulk Distribution Requirements Planning
34OIIGMMKGMM: General meter header table6TPLNRFunctional location IDnvarchar300
TOPData Collection
35S064ES064 - Structural information3TPLNRFunctional Locationnvarchar300
36S116Customer Analysis14TPLNRFunctional Locationnvarchar300
37S116ES116 - Structural information9TPLNRFunctional Locationnvarchar300
38S555Info structure Wolgang Backes9TPLNRFunctional Locationnvarchar300
39S901Garantieauswertung10TPLNR??????????? ?????nvarchar300
TOPDistributed Maintenance
40/ISDFPS/PMDISFLDistributed Maintenance - Dismantled Functional Locations2TPLNRFunctional Locationnvarchar300
TOPEquipment
41IEQT_WL_ITEMSInterim Statuses - Items65TPLNRFunctional Locationnvarchar300
42IEQT_WL_ITM_BACInterim Statuses - Items (Backup)66TPLNRFunctional Locationnvarchar300
TOPFlexible Real Estate Management
43VIBDPMFLOBSOLETE: Link from RE Object to Functional Location4TPLNRFunctional Locationnvarchar300
TOPFunctional Locations
44IFLOCUSTSystem-Specific Settings3TPLNRFunctional Locationnvarchar300
45IFLOSFunctional Location Labels2TPLNRFunctional Locationnvarchar300
46IFLOS_VSFunctional Location Labels (Version Table)3TPLNRFunctional Locationnvarchar300
47IFLOTFunctional Location (Table)2TPLNRFunctional Locationnvarchar300
48IFLOTXFunctional Location: Short Texts2TPLNRFunctional Locationnvarchar300
49IFLOTX_VSFunctional Location Data Fields: Short Texts (Version Table)3TPLNRFunctional Locationnvarchar300
50IFLOT_VSFunctional Location (Version Table)3TPLNRFunctional Locationnvarchar300
51ILOAPM Object Location and Account Assignment3TPLNRFunctional Locationnvarchar300
52ILOA_VSLocation & Account Assignment for PM Object (Version Table)4TPLNRFunctional Locationnvarchar300
TOPGeographical Information System
53GHO_TEMP_TPLNRStores temp tplnr table1TPLNRFunctional Locationnvarchar300
TOPIndustrial Hygiene and Safety
54CCIHT_IALEHS: Incident/Accident Log - Header23TPLNRFunctional Locationnvarchar300
TOPInvestment Programs
55IMPRInvestment Program Positions25TPLNRFunctional Locationnvarchar300
TOPLogbook
56ADFSH_FLGTDETFlight Scheduling: Flight Schedule Details11TPLNRFlight Scheduling: Actual Aircraft Registrationnvarchar300
57ADFSH_FLGTMASFlight Scheduling: Flight Schedule Master22TPLNRFlight Scheduling: Planned Aircraft Registrationnvarchar300
TOPMaintenance
58/ISDFPS/PM_MB_HPM Maintenance Book - Header20TPLNRFunctional Locationnvarchar300
TOPMaintenance History
59HIVGPM order history - operations71TPLNRFunctional Locationnvarchar300
TOPMaintenance Notifications
60QMFEQuality notification - items57TPLNRFunctional Locationnvarchar300
TOPMaintenance Orders
61/CUM/CUDESIGNCU: Design Header Data21TPLNRFunctional Locationnvarchar300
62/CUM/PRF_ORDCU: Profile for Order Generation15TPLNRFunctional Locationnvarchar300
63T352RMaintenance revisions13TPLNRFunctional Locationnvarchar300
64TPMIMIM allocation key11TPLNRFunct.Loc. f. autom. deriv. of charactstcs for IM allocationnvarchar10
65TPMUSPM/SM - User default values24TPLNRFunctional Locationnvarchar300
TOPMaintenance Program Definition
66MPDCDMPD: OBSOLETE - Counter Data for Maintenance Document Items4TPLNRFunctional Locationnvarchar300
67MPDCYCLEMPD: Cycle Data for Maintenance Document Items4TPLNRFunctional Locationnvarchar300
TOPMaintenance Task Lists
68MPLAMaintenance plan13TPLNRFunctional Locationnvarchar300
69TAPLAllocation of task lists to functional locations2TPLNRFunctional Locationnvarchar300
TOPMarketing Retail Network
70OIFOIFLOObject links - PM functional location (IS-Oil MRN)12TPLNRFunctional Locationnvarchar300
TOPMeasurement System
71GHO_IMPTT_EXTData Capture Header6TPLNRFunctional Locationnvarchar300
72GHO_IMRG_EXTExtension Table for IMRG (Measurement Document)5TPLNRFunctional Locationnvarchar300
TOPMigration
73VIGW_IM_LOAbbildung Immoobjekt zu Technischem Platz3TPLNRToimintopaikkanvarchar300
TOPNetwork Objects
74GHO_IFLOT_EXTFunction location extension table2TPLNRFunctional Locationnvarchar300
75GHO_IFLOT_PLANFunction location extension table2TPLNRFunctional Locationnvarchar300
76GHO_ILOA_EXTOBSOLETE: DO NOT USE8TPLNRFunctional Locationnvarchar300
77GHO_NETOBJ_TDWell Time Dependency2TPLNRFunctional Locationnvarchar300
78GHO_PROD_NW_FREQFrequencies for Production Network2TPLNRFunctional Locationnvarchar300
79GHO_PROD_NW_MEDMediums for Production network2TPLNRFunctional Locationnvarchar300
80GHO_WELL_TDWell Time Dependency2TPLNRFunctional Locationnvarchar300
TOPOperative Structures
81PRPSWBS (Work Breakdown Structure) Element Master Data40TPLNRFunctional Locationnvarchar300
TOPOwnership
82GHO_OWN_NET_ASGOwnership (DOI) assignment to Network Objects4TPLNRFunctional Locationnvarchar300
TOPPermits
83IHSGObject-Related Permits in Plant Maintenance15TPLNRFunctional Locationnvarchar300
TOPPlant Maintenance
84MCB_BUDMCB Retraction data for Budget check3TPLNRFunctional Locationnvarchar300
85PLMN_FL_EXTGHO Object characteristics2TPLNRFunctional Locationnvarchar300
TOPPool Asset Management
86PAMS_TPOOLTPPAM Pools for Functional Locations3TPLNRFunctional Locationnvarchar300
TOPProduct Structure Browser
87USROBJECTSTable of Previous Initial Object in Structure Overview12TPLNRFunctional Locationnvarchar300
TOPProduction and Revenue Accounting
88OIU_ME_CNTNRGeneral measurement container10TPLNRFunctional Locationnvarchar300
TOPProduction Orders
89AFVCOperation within an order181TPLNRFunctional Locationnvarchar300
TOPQuality Inspection
90QAPPInspection point13TPLNRFunctional Locationnvarchar300
TOPReal Estate Management
91VIOB29OLD, replaced by VIOB39 for 3.03TPLNRFunctional Locationnvarchar300
92VIOB39Relationship between Real Estate objects and SAP-PM3TPLNRFunctional Locationnvarchar300
TOPRemote Logistics Management
93OIO_MX_OBJECTRLM tracking extract object data44TPLNRFunctional Locationnvarchar300
TOPReporting
94MCIPMISPMIS: Master data characteristics for PMIS before image19TPLNRFunctional Locationnvarchar300
95S061Location and planning13TPLNRFunctional Locationnvarchar300
96S061ES061 - Structural Information8TPLNRFunctional Locationnvarchar300
97S063Damage Analysis 30 .8TPLNRFunctional Locationnvarchar300
98S063ES063 - Structural Information3TPLNRFunctional Locationnvarchar300
99S064Single object - damage analysis8TPLNRFunctional Locationnvarchar300
100S070Breakdown Statistics9TPLNRFunctional Locationnvarchar300
101S070ES070 - Structural Information4TPLNRFunctional Locationnvarchar300
102S115Cost Evaluation10TPLNRFunctional Locationnvarchar300
103S115ES115 - Structural Information5TPLNRFunctional Locationnvarchar300
TOPRouting
104PLPOTask list - operation/activity218TPLNRFunctional Locationnvarchar300
TOPService Station Retailing
105OIRBOIFLOObject links - PM functional location (IS-Oil SSR)13TPLNRFunctional Locationnvarchar300
TOPSimulation
106VSAFVC_CNVersion: Operation in order185TPLNRFunctional Locationnvarchar300
107VSPRPS_CNVersion: WBS Element (Work Breakdwn Struc. Elem.) Mast. Data41TPLNRFunctional Locationnvarchar300
TOPStatus Board
108/ISDFPS/LINKSMEQObject Relationships of Master Equipment (Performance)5TPLNRFunctional Locationnvarchar300
TOPTakeoverHandover of Technical Objects
109PHINTPhase In Table23TPLNRFunctional Locationnvarchar400
TOPTechnical Objects
110TITOB_IBASECreation of IBase: Buffer Table Structures6TPLNRFunctional Locationnvarchar300
TOPTemplates
111PRPSSStandard WBS Element (WBS element) - Master Data40TPLNRFunctional Locationnvarchar300
TOPTraders and Schedulers Workbench
112OIISOCKSOC: Storage object characteristic segment header8TPLNRFunctional location IDnvarchar300
TOPWaste Management
113EEWA_PROP_HHeader data of property9TPLNRFunctional Locationnvarchar300
114EWAPROPSDAllocation Table: Property <-> Sales Document Item11TPLNRFunctional Locationnvarchar300
115EWA_EL_WDPLANTWaste Disposal Facility6TPLNRFunctional Locationnvarchar300
TOPWork Clearance Management
116WCAAPWCM: Application26TPLNRFunctional Locationnvarchar300
117WCAHEWCM: Work Clearance Document (Header)26TPLNRFunctional Locationnvarchar300
118WCAJWCM: Lineup14TPLNRFunctional Locationnvarchar300
119WCAWWCM: Work Approval24TPLNRFunctional Locationnvarchar300