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

137 columns | Print definition?ERP 6.0  | AEZEIT

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1HRPADNLP_LOGIMMENL Pens: Immediate Payments - log for Payroll Process19AEZEITTime of Changenvarchar60
TOPBulk Distribution Requirements Planning
2OIIGMMHGMM: Meter history17AEZEITTime record changednvarchar60
3OIIGMMKGMM: General meter header table30AEZEITTime record changednvarchar60
4OIIGMMMGMM: Meter/Material assignment11AEZEITTime record changednvarchar60
5OIIOTWSKBDRP-OTWS: Operations time window set header7AEZEITTime record changednvarchar60
6OIISCPWKSCP: Site control parameters (plant) - IS-Oil BDRP41AEZEITTime record changednvarchar60
7OIISLVCHSilo calibration history index11AEZEITTime record changednvarchar60
8OIISLVCKOSilo: Calibration - LVC (strap) set header34AEZEITTime record changednvarchar60
9OIISOCTSSSOC: time dependent assignment SO <-> SO (IS-Oil BDRP)11AEZEITTime record changednvarchar60
TOPCross-Application Components
10AAUUFKOrder master data91AEZEITChanged atnvarchar60
TOPEmpties Management
11/BEV1/EMLGOFSEmpties - Billing Document Without Update12AEZEITTime of Changenvarchar60
TOPFunctional Locations
12IHPAPlant Maintenance: Partners12AEZEITTime of Changenvarchar60
TOPInterface to Terminal Automation System
13OIK01IS-OIL/TAS: LID Document Data22AEZEITTime of Changenvarchar60
14OIK01DIS-OIL/TAS: deactivated LID Document Data23AEZEITTime of Changenvarchar60
15OIKLIDRTD - TAS Reference Table57AEZEITTime of Changenvarchar60
TOPLogistics - General
16OIFSPBLPhysical Location - Master Data17AEZEITTime when Record Was Changednvarchar60
17OIJTSTransport system (IS-Oil TSW standard/core object )34AEZEITTime of day the record was changednvarchar60
18WBHKTrading Contract: Header Data13AEZEITTime of Changenvarchar60
TOPMaintenance Notifications
19QMELQuality Notification52AEZEITTime of Changenvarchar60
20QMFEQuality notification - items22AEZEITTime of Changenvarchar60
21QMMAQuality notification - activities25AEZEITTime of Changenvarchar60
22QMSMQuality notification - tasks29AEZEITTime of Changenvarchar60
23QMURQuality notification - causes17AEZEITTime of Changenvarchar60
TOPMarketing Retail Network
24OIFBBP1Business partner role assignments (IS-Oil MRN)11AEZEITTime when Record Was Changednvarchar60
25OIFCHRS2Retail Network Contract service hours type7AEZEITTime when Record Was Changednvarchar60
26OIFCOPT1Retail Network Contract option type7AEZEITTime when Record Was Changednvarchar60
27OIFDD1Delivery point info for bulk delivery preplannning36AEZEITTime when Record Was Changednvarchar60
28OIFDD2Bulk delivery preplanning version7AEZEITTime when Record Was Changednvarchar60
29OIFDDM1Del. point/material info for bulk delivery planning22AEZEITTime when Record Was Changednvarchar60
30OIFDDM2Del. point/material/tank (bulk delivery planning)11AEZEITTime when Record Was Changednvarchar60
31OIFDDM3Del. point/material/meter (bulk delivery planning)12AEZEITTime when Record Was Changednvarchar60
32OIFDTT1Tank type table - bulk delivery planning12AEZEITTime when Record Was Changednvarchar60
33OIFOANLAObject links - FI-AA asset master (IS-Oil MRN)8AEZEITTime when Record Was Changednvarchar60
34OIFOCEPCObject links - CO-PCA profit center (IS-Oil MRN)8AEZEITTime when Record Was Changednvarchar60
35OIFOCOASObject links - CO order (IS-Oil MRN)8AEZEITTime when Record Was Changednvarchar60
36OIFOCSKSObject links - CO cost center (IS-Oil MRN)8AEZEITTime when Record Was Changednvarchar60
37OIFOIFLOObject links - PM functional location (IS-Oil MRN)8AEZEITTime when Record Was Changednvarchar60
38OIFOPBLTLocation type - permissible object links (IS-Oil MRN)7AEZEITTime when Record Was Changednvarchar60
39OIFOPROJObject links - PS project or project item (IS-Oil MRN)8AEZEITTime when Record Was Changednvarchar60
40OIFORACTIVActivation of Oil-Retail Integration Components13AEZEITTime when Record Was Changednvarchar60
41OIFORCAMConversion of article master to material master data (ALE)15AEZEITTime when Record Was Changednvarchar60
42OIFORCPRTransfer customer expected price into sales condition record9AEZEITTime when Record Was Changednvarchar60
43OIFOT001LObject links - CA storage location (IS-Oil MRN)8AEZEITTime when Record Was Changednvarchar60
44OIFOT001WObject links - CA Plant (IS-Oil MRN)8AEZEITTime when Record Was Changednvarchar60
TOPOverhead Cost Orders
45AUFKOrder master data91AEZEITChanged atnvarchar60
TOPRemaining Beverage - Obsolete Objects
46/BEV1/RSQUSEQuick Settlement22AEZEITTime of Changenvarchar60
TOPRevenues and Earnings
47VPKHEADSales Pricing Header Data17AEZEITSystem Timenvarchar60
TOPSAP Ambulatory Care Management
48N2HM_KPFACM: Kopfdaten zum Heilmittelkatalog11AEZEITÄnderungsuhrzeitnvarchar60
TOPService Station Retailing
49OIRBOANLAObject links - FI-AA asset master (IS-Oil SSR)9AEZEITTime when Record Was Changednvarchar60
50OIRBOCEPCObject links - CO-PCA profit center (IS-Oil SSR)9AEZEITTime when Record Was Changednvarchar60
51OIRBOCOASObject links - CO order (IS-Oil SSR)9AEZEITTime when Record Was Changednvarchar60
52OIRBOCSKSObject links - CO cost center (IS-Oil SSR)9AEZEITTime when Record Was Changednvarchar60
53OIRBOIFLOObject links - PM functional location (IS-Oil SSR)9AEZEITTime when Record Was Changednvarchar60
54OIRBOMMT001LObject links - CA storage location (IS-Oil MRN)8AEZEITTime when Record Was Changednvarchar60
55OIRBOPROJObject links - PS project or project item (IS-Oil SSR)9AEZEITTime when Record Was Changednvarchar60
56OIRBOT001LObject links - CA storage location (IS-Oil SSR)9AEZEITTime when Record Was Changednvarchar60
57OIRBOT001WObject links - CA Plant (IS-Oil SSR)9AEZEITTime when Record Was Changednvarchar60
58OIRBPBLBBusiness location at business type level (IS-OIL SSR)27AEZEITTime when Record Was Changednvarchar60
59OIRC_DRREJSSR Stocks - Dip readings rejected records75AEZEITTime record changednvarchar60
60OIRC_GMMHSSR Meters - History59AEZEITTime record changednvarchar60
61OIRC_GMMH_DELSSR Meters - Deleted meter readings history60AEZEITTime record changednvarchar60
62OIRC_MRREJSSR Meters - Meter readings rejected records62AEZEITTime record changednvarchar60
63OIRC_PRCHKSSR Pricing - Price check26AEZEITTime record changednvarchar60
64OIRC_SOCDIPSSR Stocks - Dip readings history72AEZEITTime record changednvarchar60
TOPSimulation
65VSAUFK_CNVersion: Order master data92AEZEITChanged atnvarchar60
TOPTraders and Schedulers Workbench
66OIB_TANKDIPSilo management tank strapping history23AEZEITTime record changednvarchar60
67OIFSBLCDBlocking Indicator for Business Locations10AEZEITTime when Record Was Changednvarchar60
68OIFSPBLTPhysical Business Location Type13AEZEITTime when Record Was Changednvarchar60
69OIISCPBLSCP: Site control parameters (business loc) - IS-Oil BDRP43AEZEITTime record changednvarchar60
70OIISCPKNSCP: Site control parameters (customer) - IS-Oil BDRP41AEZEITTime record changednvarchar60
71OIISLVCKSOC: Linear/volumetric conversion (strap) set header11AEZEITTime record changednvarchar60
72OIISOCAOISOC: Storage object characteristic: appl. specific oil & g7AEZEITTime record changednvarchar60
73OIISOCB1SOC: Storage object characteristic segment: bulk20AEZEITTime record changednvarchar60
74OIISOCB2SOC: Storage object characteristic segment: packaged7AEZEITTime record changednvarchar60
75OIISOCKSOC: Storage object characteristic segment header35AEZEITTime record changednvarchar60
76OIISOCKLSOC: Storage object characteristic class19AEZEITTime record changednvarchar60
77OIISOCO1SOC: Storage object characteristic segment: bulk25AEZEITTime record changednvarchar60
78OIISOCTSMSOC: time dependent assignment SO <-> material (IS-Oil BDR25AEZEITTime record changednvarchar60
79OIISOCTSPSOC: Assignment SO <-> Plant/Storage location IS-Oil BDRP9AEZEITTime record changednvarchar60
80OIISOCTYPSOC: Storage object type9AEZEITTime record changednvarchar60
81OIJ03_LOVTSW: Table for Left on Vehicle Entries21AEZEITTime of day the record was changednvarchar60
82OIJBERBerth Table17AEZEITTime of day the record was changednvarchar60
83OIJBERLOCIndex table for berths at TSW locations9AEZEITTime of day the record was changednvarchar60
84OIJBERMATAssignment of material to berths10AEZEITTime of day the record was changednvarchar60
85OIJBERSOCAssignment of berths to tanks9AEZEITTime of day the record was changednvarchar60
86OIJBRDOIL-TSW: Rundown table for Batch28AEZEITTime of day the record was changednvarchar60
87OIJBRDHRD header f.batch:Don't use(obsolete) & don't delete(XPRA)32AEZEITTime of day the record was changednvarchar60
88OIJBRDNOMStock Projection item / nomination X-ref table23AEZEITTime of day the record was changednvarchar60
89OIJCLIPBOARDClipboard Table for Railcar35AEZEITTime of day the record was changednvarchar60
90OIJHCT01OIL-TSW: Ticket Holding Table (Draft version 1) - OBSOLETE73AEZEITTime of day the record was changednvarchar60
91OIJLOCLocation table11AEZEITTime of day the record was changednvarchar60
92OIJLOCMATOIL-TSW: Location Rundown/Planning material table89AEZEITTime of day the record was changednvarchar60
93OIJNOMCOIL-TSW: Nomination copy table105AEZEITTime of day the record was changednvarchar60
94OIJNOMHNomination Header54AEZEITTime of day the record was changednvarchar60
95OIJNOMHATLOADNomination Hatch load sequence plan20AEZEITTime of day the record was changednvarchar60
96OIJNOMHATPLANNomination: hatch plan11AEZEITTime of day the record was changednvarchar60
97OIJNOMINomination Item105AEZEITTime of day the record was changednvarchar60
98OIJNOMSUBITEMSNomination Sub-Item55AEZEITTime of day the record was changednvarchar60
99OIJPHYINVPhysical inventory15AEZEITTime of day the record was changednvarchar60
100OIJPLANLOCOIL TSW: Multiple planning Locations9AEZEITTime of day the record was changednvarchar60
101OIJRDOIL-TSW: Rundown table27AEZEITTime of day the record was changednvarchar60
102OIJRDHRundown header: Don't use (obsolete) & don't delete (XPRA)31AEZEITTime of day the record was changednvarchar60
103OIJRDHTPSETOIL-TSW: Rundown Rack issue / throughput settings15AEZEITTime of day the record was changednvarchar60
104OIJRDNOMStock Projection item / nomination X-ref table22AEZEITTime of day the record was changednvarchar60
105OIJRRAOIL-TSW: Partner roles19AEZEITTime of day the record was changednvarchar60
106OIJSDLOCOIL-TSW: Multiple sources/destinations of location17AEZEITTime of day the record was changednvarchar60
107OIJTHPUTFCRack issue / Throughput forecast17AEZEITTime of day the record was changednvarchar60
108OIJTHPUTFCAVGOIL-TSW: Rack issue / Throughput forecast daily average17AEZEITTime of day the record was changednvarchar60
109OIJTHPUTFCESTOIL-TSW: Rack issue / Throughput estimate pop-up18AEZEITTime of day the record was changednvarchar60
110OIJTSLOCOIL-TSW: transport system/location assignment table14AEZEITTime of day the record was changednvarchar60
111OIJTSMATOIL-TSW: TS Rundown/Planning material table81AEZEITTime of day the record was changednvarchar60
112OIJTSMATSEQDisallowed Material sequence within Transport system10AEZEITTime of day the record was changednvarchar60
113OIJWLOIL-TSW: Worklist23AEZEITTime of day the record was changednvarchar60
114OIJXTSW control record8AEZEITTime of day the record was changednvarchar60
115OIJ_EL_CP_LAYTCharter party and laytime and demurrage agreement61AEZEITTime of day the record was changednvarchar60
116OIJ_EL_CP_LOCCharter party contract: load and discharge locations13AEZEITTime of day the record was changednvarchar60
117OIJ_EL_CP_PRODCharter contracts: products and product groups13AEZEITTime of day the record was changednvarchar60
118OIJ_EL_DOC_EVRules for nomination events19AEZEITTime of day the record was changednvarchar60
119OIJ_EL_DOC_H_REFOil TSW: Document header reference to nomination; not used10AEZEITTime of day the record was changednvarchar60
120OIJ_EL_DOC_I_REFDocument item reference to nomination28AEZEITTime of day the record was changednvarchar60
121OIJ_EL_DOC_MOTOil TSW: TSW Relevance of order item39AEZEITTime of day the record was changednvarchar60
122OIJ_EL_DOC_M_MOTOIL TSW: TSW Details / Multiple MoT's11AEZEITTime of day the record was changednvarchar60
123OIJ_EL_LAYT_EVLaytime start and end events23AEZEITTime of day the record was changednvarchar60
124OIJ_EL_LAYT_INFLaytime terms19AEZEITTime of day the record was changednvarchar60
125OIJ_EL_PROD_DATAProduction data for locations13AEZEITTime of day the record was changednvarchar60
126OIJ_EL_TCKET_UOMUniversal ticket additional units of measure17AEZEITTime of day the record was changednvarchar60
127OIJ_EL_TICKET_HUniversal ticket table15AEZEITTime of day the record was changednvarchar60
128OIJ_EL_TICKET_IUniversal ticket item table41AEZEITTime of day the record was changednvarchar60
129OIJ_LMTIMECONOILTSW: Time dependent constraints by location & material12AEZEITTime of day the record was changednvarchar60
130OIJ_NOMLTLaytime and demurrage for groups in nominations19AEZEITTime of day the record was changednvarchar60
131OIJ_RDHEADStock Projection header34AEZEITTime of day the record was changednvarchar60
132OIJ_RELPROFOil-TSW: Release profiles for Schedules11AEZEITTime of day the record was changednvarchar60
133OIJ_REPORT_QUANTSW: Reported Nomination quantities into/out of inventory12AEZEITTime of day the record was changednvarchar60
134OIJ_SCHEDPlanned Schedule Lines152AEZEITTime of day the record was changednvarchar60
135OIJ_SIM_SCHEDobsolete table (will be cleaned up)27AEZEITTime of day the record was changednvarchar60
136OIJ_TGTSFTTIMETime dependent target and safety levels11AEZEITTime of day the record was changednvarchar60
137OIJ_VEH_PERFMarine Scheduling - Table to Store vehicle Performanace27AEZEITTime of day the record was changednvarchar60