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

114 columns | Print definition?ERP 6.0  | DELIND

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1DMS_TBL_LOCKEDMaintain Lock Field Status7DELINDDelete Indicatornvarchar10
TOPBulk Distribution Requirements Planning
2OIIGMMHGMM: Meter history20DELINDDeletion indicatornvarchar10
3OIIGMMKGMM: General meter header table33DELINDDeletion indicatornvarchar10
4OIIGMMMGMM: Meter/Material assignment14DELINDDeletion indicatornvarchar10
5OIIOTWSKBDRP-OTWS: Operations time window set header10DELINDDeletion indicatornvarchar10
6OIISCPWKSCP: Site control parameters (plant) - IS-Oil BDRP44DELINDDeletion indicatornvarchar10
7OIISLVCHSilo calibration history index14DELINDDeletion indicatornvarchar10
8OIISLVCKOSilo: Calibration - LVC (strap) set header37DELINDDeletion indicatornvarchar10
9OIISOCTSSSOC: time dependent assignment SO <-> SO (IS-Oil BDRP)14DELINDDeletion indicatornvarchar10
TOPFlexible Real Estate Management
10VILUROCTODOLUM: To-Do-Liste zum Veränderungsnachweis9DELINDLöschkennzeichen To-do VNnvarchar10
TOPLogistics - General
11OIFSPBLPhysical Location - Master Data20DELINDDeletion indicatornvarchar10
12OIJTSTransport system (IS-Oil TSW standard/core object )37DELINDDeletion indicatornvarchar10
TOPMarketing Retail Network
13OIFBBP1Business partner role assignments (IS-Oil MRN)14DELINDDeletion indicatornvarchar10
14OIFDD1Delivery point info for bulk delivery preplannning39DELINDDeletion indicatornvarchar10
15OIFDDM1Del. point/material info for bulk delivery planning25DELINDDeletion indicatornvarchar10
16OIFDDM2Del. point/material/tank (bulk delivery planning)14DELINDDeletion indicatornvarchar10
17OIFDDM3Del. point/material/meter (bulk delivery planning)15DELINDDeletion indicatornvarchar10
18OIFDTT1Tank type table - bulk delivery planning15DELINDDeletion indicatornvarchar10
19OIFOANLAObject links - FI-AA asset master (IS-Oil MRN)11DELINDDeletion indicatornvarchar10
20OIFOCEPCObject links - CO-PCA profit center (IS-Oil MRN)11DELINDDeletion indicatornvarchar10
21OIFOCOASObject links - CO order (IS-Oil MRN)11DELINDDeletion indicatornvarchar10
22OIFOCSKSObject links - CO cost center (IS-Oil MRN)11DELINDDeletion indicatornvarchar10
23OIFOIFLOObject links - PM functional location (IS-Oil MRN)11DELINDDeletion indicatornvarchar10
24OIFOPROJObject links - PS project or project item (IS-Oil MRN)11DELINDDeletion indicatornvarchar10
25OIFOT001LObject links - CA storage location (IS-Oil MRN)11DELINDDeletion indicatornvarchar10
26OIFOT001WObject links - CA Plant (IS-Oil MRN)11DELINDDeletion indicatornvarchar10
TOPProduct and Process Modeling
27RLMFWOLRelease Order - Items19DELINDDeletion Indicatornvarchar10
TOPService Station Retailing
28OIRBOANLAObject links - FI-AA asset master (IS-Oil SSR)12DELINDDeletion indicatornvarchar10
29OIRBOCEPCObject links - CO-PCA profit center (IS-Oil SSR)12DELINDDeletion indicatornvarchar10
30OIRBOCOASObject links - CO order (IS-Oil SSR)12DELINDDeletion indicatornvarchar10
31OIRBOCSKSObject links - CO cost center (IS-Oil SSR)12DELINDDeletion indicatornvarchar10
32OIRBOIFLOObject links - PM functional location (IS-Oil SSR)12DELINDDeletion indicatornvarchar10
33OIRBOMMT001LObject links - CA storage location (IS-Oil MRN)11DELINDDeletion indicatornvarchar10
34OIRBOPROJObject links - PS project or project item (IS-Oil SSR)12DELINDDeletion indicatornvarchar10
35OIRBOT001LObject links - CA storage location (IS-Oil SSR)12DELINDDeletion indicatornvarchar10
36OIRBOT001WObject links - CA Plant (IS-Oil SSR)12DELINDDeletion indicatornvarchar10
37OIRBPBLBBusiness location at business type level (IS-OIL SSR)30DELINDDeletion indicatornvarchar10
38OIRC_DRREJSSR Stocks - Dip readings rejected records78DELINDDeletion indicatornvarchar10
39OIRC_GMMHSSR Meters - History62DELINDDeletion indicatornvarchar10
40OIRC_GMMH_DELSSR Meters - Deleted meter readings history63DELINDDeletion indicatornvarchar10
41OIRC_MRREJSSR Meters - Meter readings rejected records65DELINDDeletion indicatornvarchar10
42OIRC_PRCHKSSR Pricing - Price check29DELINDDeletion indicatornvarchar10
43OIRC_SOCDIPSSR Stocks - Dip readings history75DELINDDeletion indicatornvarchar10
TOPTraders and Schedulers Workbench
44OIB_TANKDIPSilo management tank strapping history26DELINDDeletion indicatornvarchar10
45OIISCPBLSCP: Site control parameters (business loc) - IS-Oil BDRP46DELINDDeletion indicatornvarchar10
46OIISCPKNSCP: Site control parameters (customer) - IS-Oil BDRP44DELINDDeletion indicatornvarchar10
47OIISLVCKSOC: Linear/volumetric conversion (strap) set header14DELINDDeletion indicatornvarchar10
48OIISOCAOISOC: Storage object characteristic: appl. specific oil & g10DELINDDeletion indicatornvarchar10
49OIISOCB1SOC: Storage object characteristic segment: bulk23DELINDDeletion indicatornvarchar10
50OIISOCB2SOC: Storage object characteristic segment: packaged10DELINDDeletion indicatornvarchar10
51OIISOCKSOC: Storage object characteristic segment header38DELINDDeletion indicatornvarchar10
52OIISOCKLSOC: Storage object characteristic class22DELINDDeletion indicatornvarchar10
53OIISOCO1SOC: Storage object characteristic segment: bulk28DELINDDeletion indicatornvarchar10
54OIISOCTSMSOC: time dependent assignment SO <-> material (IS-Oil BDR28DELINDDeletion indicatornvarchar10
55OIISOCTSPSOC: Assignment SO <-> Plant/Storage location IS-Oil BDRP12DELINDDeletion indicatornvarchar10
56OIISOCTYPSOC: Storage object type12DELINDDeletion indicatornvarchar10
57OIJ03_LOVTSW: Table for Left on Vehicle Entries24DELINDDeletion indicatornvarchar10
58OIJBERBerth Table20DELINDDeletion indicatornvarchar10
59OIJBERLOCIndex table for berths at TSW locations12DELINDDeletion indicatornvarchar10
60OIJBERMATAssignment of material to berths13DELINDDeletion indicatornvarchar10
61OIJBERSOCAssignment of berths to tanks12DELINDDeletion indicatornvarchar10
62OIJBRDOIL-TSW: Rundown table for Batch31DELINDDeletion indicatornvarchar10
63OIJBRDHRD header f.batch:Don't use(obsolete) & don't delete(XPRA)35DELINDDeletion indicatornvarchar10
64OIJBRDNOMStock Projection item / nomination X-ref table26DELINDDeletion indicatornvarchar10
65OIJCLIPBOARDClipboard Table for Railcar30DELINDDeletion indicatornvarchar10
66OIJHCT01OIL-TSW: Ticket Holding Table (Draft version 1) - OBSOLETE76DELINDDeletion indicatornvarchar10
67OIJLOCLocation table14DELINDDeletion indicatornvarchar10
68OIJLOCMATOIL-TSW: Location Rundown/Planning material table92DELINDDeletion indicatornvarchar10
69OIJNENomination Events42DELINDDeletion indicatornvarchar10
70OIJNOMCOIL-TSW: Nomination copy table53DELINDDeletion indicatornvarchar10
71OIJNOMHNomination Header48DELINDDeletion indicatornvarchar10
72OIJNOMINomination Item53DELINDDeletion indicatornvarchar10
73OIJNOMIVERSNomination Item Version Table55DELINDDeletion indicatornvarchar10
74OIJNOMSUBITEMSNomination Sub-Item24DELINDDeletion indicatornvarchar10
75OIJPHYINVPhysical inventory18DELINDDeletion indicatornvarchar10
76OIJPLANLOCOIL TSW: Multiple planning Locations12DELINDDeletion indicatornvarchar10
77OIJRDOIL-TSW: Rundown table30DELINDDeletion indicatornvarchar10
78OIJRDHRundown header: Don't use (obsolete) & don't delete (XPRA)34DELINDDeletion indicatornvarchar10
79OIJRDHTPSETOIL-TSW: Rundown Rack issue / throughput settings18DELINDDeletion indicatornvarchar10
80OIJRDNOMStock Projection item / nomination X-ref table25DELINDDeletion indicatornvarchar10
81OIJRRAOIL-TSW: Partner roles22DELINDDeletion indicatornvarchar10
82OIJSDLOCOIL-TSW: Multiple sources/destinations of location20DELINDDeletion indicatornvarchar10
83OIJSUBITEMEVENTSNomination Sub Item Events33DELINDDeletion indicatornvarchar10
84OIJTETSW Ticket Events23DELINDDeletion indicatornvarchar10
85OIJTHPUTFCRack issue / Throughput forecast20DELINDDeletion indicatornvarchar10
86OIJTHPUTFCAVGOIL-TSW: Rack issue / Throughput forecast daily average20DELINDDeletion indicatornvarchar10
87OIJTHPUTFCESTOIL-TSW: Rack issue / Throughput estimate pop-up21DELINDDeletion indicatornvarchar10
88OIJTSLOCOIL-TSW: transport system/location assignment table17DELINDDeletion indicatornvarchar10
89OIJTSMATOIL-TSW: TS Rundown/Planning material table84DELINDDeletion indicatornvarchar10
90OIJTSMATSEQDisallowed Material sequence within Transport system13DELINDDeletion indicatornvarchar10
91OIJWLOIL-TSW: Worklist26DELINDDeletion indicatornvarchar10
92OIJXTSW control record11DELINDDeletion indicatornvarchar10
93OIJ_EL_CP_LAYTCharter party and laytime and demurrage agreement64DELINDDeletion indicatornvarchar10
94OIJ_EL_CP_LOCCharter party contract: load and discharge locations16DELINDDeletion indicatornvarchar10
95OIJ_EL_CP_PRODCharter contracts: products and product groups16DELINDDeletion indicatornvarchar10
96OIJ_EL_DOC_EVRules for nomination events22DELINDDeletion indicatornvarchar10
97OIJ_EL_DOC_H_REFOil TSW: Document header reference to nomination; not used13DELINDDeletion indicatornvarchar10
98OIJ_EL_DOC_I_REFDocument item reference to nomination31DELINDDeletion indicatornvarchar10
99OIJ_EL_DOC_MOTOil TSW: TSW Relevance of order item42DELINDDeletion indicatornvarchar10
100OIJ_EL_DOC_M_MOTOIL TSW: TSW Details / Multiple MoT's14DELINDDeletion indicatornvarchar10
101OIJ_EL_LAYT_EVLaytime start and end events26DELINDDeletion indicatornvarchar10
102OIJ_EL_LAYT_INFLaytime terms22DELINDDeletion indicatornvarchar10
103OIJ_EL_PROD_DATAProduction data for locations16DELINDDeletion indicatornvarchar10
104OIJ_EL_TCKET_UOMUniversal ticket additional units of measure20DELINDDeletion indicatornvarchar10
105OIJ_EL_TICKET_HUniversal ticket table18DELINDDeletion indicatornvarchar10
106OIJ_EL_TICKET_IUniversal ticket item table44DELINDDeletion indicatornvarchar10
107OIJ_LMTIMECONOILTSW: Time dependent constraints by location & material15DELINDDeletion indicatornvarchar10
108OIJ_NOMLTLaytime and demurrage for groups in nominations22DELINDDeletion indicatornvarchar10
109OIJ_RDHEADStock Projection header37DELINDDeletion indicatornvarchar10
110OIJ_RELPROFOil-TSW: Release profiles for Schedules14DELINDDeletion indicatornvarchar10
111OIJ_REPORT_QUANTSW: Reported Nomination quantities into/out of inventory15DELINDDeletion indicatornvarchar10
112OIJ_SCHEDPlanned Schedule Lines104DELINDDeletion indicatornvarchar10
113OIJ_SIM_SCHEDobsolete table (will be cleaned up)30DELINDDeletion indicatornvarchar10
114OIJ_TGTSFTTIMETime dependent target and safety levels14DELINDDeletion indicatornvarchar10