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

107 columns | Print definition?ERP 6.0  | BLOIND

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPBulk Distribution Requirements Planning
1OIIGMMHGMM: Meter history19BLOINDBlocking indicatornvarchar10
2OIIGMMKGMM: General meter header table32BLOINDBlocking indicatornvarchar10
3OIIGMMMGMM: Meter/Material assignment13BLOINDBlocking indicatornvarchar10
4OIIOTWSKBDRP-OTWS: Operations time window set header9BLOINDBlocking indicatornvarchar10
5OIISCPWKSCP: Site control parameters (plant) - IS-Oil BDRP43BLOINDBlocking indicatornvarchar10
6OIISLVCHSilo calibration history index13BLOINDBlocking indicatornvarchar10
7OIISLVCKOSilo: Calibration - LVC (strap) set header36BLOINDBlocking indicatornvarchar10
8OIISOCTSSSOC: time dependent assignment SO <-> SO (IS-Oil BDRP)13BLOINDBlocking indicatornvarchar10
TOPLogistics - General
9OIFSPBLPhysical Location - Master Data19BLOINDBlock Indicatornvarchar10
10OIJTSTransport system (IS-Oil TSW standard/core object )36BLOINDBlocking indicatornvarchar10
TOPMarketing Retail Network
11OIFBBP1Business partner role assignments (IS-Oil MRN)13BLOINDBlock Indicatornvarchar10
12OIFDD1Delivery point info for bulk delivery preplannning38BLOINDBlock Indicatornvarchar10
13OIFDDM1Del. point/material info for bulk delivery planning24BLOINDBlock Indicatornvarchar10
14OIFDDM2Del. point/material/tank (bulk delivery planning)13BLOINDBlock Indicatornvarchar10
15OIFDDM3Del. point/material/meter (bulk delivery planning)14BLOINDBlock Indicatornvarchar10
16OIFDTT1Tank type table - bulk delivery planning14BLOINDBlock Indicatornvarchar10
17OIFOANLAObject links - FI-AA asset master (IS-Oil MRN)10BLOINDBlock Indicatornvarchar10
18OIFOCEPCObject links - CO-PCA profit center (IS-Oil MRN)10BLOINDBlock Indicatornvarchar10
19OIFOCOASObject links - CO order (IS-Oil MRN)10BLOINDBlock Indicatornvarchar10
20OIFOCSKSObject links - CO cost center (IS-Oil MRN)10BLOINDBlock Indicatornvarchar10
21OIFOIFLOObject links - PM functional location (IS-Oil MRN)10BLOINDBlock Indicatornvarchar10
22OIFOPROJObject links - PS project or project item (IS-Oil MRN)10BLOINDBlock Indicatornvarchar10
23OIFOT001LObject links - CA storage location (IS-Oil MRN)10BLOINDBlock Indicatornvarchar10
24OIFOT001WObject links - CA Plant (IS-Oil MRN)10BLOINDBlock Indicatornvarchar10
TOPService Station Retailing
25OIRBOANLAObject links - FI-AA asset master (IS-Oil SSR)11BLOINDBlock Indicatornvarchar10
26OIRBOCEPCObject links - CO-PCA profit center (IS-Oil SSR)11BLOINDBlock Indicatornvarchar10
27OIRBOCOASObject links - CO order (IS-Oil SSR)11BLOINDBlock Indicatornvarchar10
28OIRBOCSKSObject links - CO cost center (IS-Oil SSR)11BLOINDBlock Indicatornvarchar10
29OIRBOIFLOObject links - PM functional location (IS-Oil SSR)11BLOINDBlock Indicatornvarchar10
30OIRBOMMT001LObject links - CA storage location (IS-Oil MRN)10BLOINDBlock Indicatornvarchar10
31OIRBOPROJObject links - PS project or project item (IS-Oil SSR)11BLOINDBlock Indicatornvarchar10
32OIRBOT001LObject links - CA storage location (IS-Oil SSR)11BLOINDBlock Indicatornvarchar10
33OIRBOT001WObject links - CA Plant (IS-Oil SSR)11BLOINDBlock Indicatornvarchar10
34OIRBPBLBBusiness location at business type level (IS-OIL SSR)29BLOINDBlock Indicatornvarchar10
35OIRC_DRREJSSR Stocks - Dip readings rejected records77BLOINDBlocking indicatornvarchar10
36OIRC_GMMHSSR Meters - History61BLOINDBlocking indicatornvarchar10
37OIRC_GMMH_DELSSR Meters - Deleted meter readings history62BLOINDBlocking indicatornvarchar10
38OIRC_MRREJSSR Meters - Meter readings rejected records64BLOINDBlocking indicatornvarchar10
39OIRC_PRCHKSSR Pricing - Price check28BLOINDBlocking indicatornvarchar10
40OIRC_SOCDIPSSR Stocks - Dip readings history74BLOINDBlocking indicatornvarchar10
TOPTraders and Schedulers Workbench
41OIB_TANKDIPSilo management tank strapping history25BLOINDBlocking indicatornvarchar10
42OIFBRF1Business partner roles (IS-Oil MRN)4BLOINDBlock Indicatornvarchar10
43OIISCPBLSCP: Site control parameters (business loc) - IS-Oil BDRP45BLOINDBlocking indicatornvarchar10
44OIISCPKNSCP: Site control parameters (customer) - IS-Oil BDRP43BLOINDBlocking indicatornvarchar10
45OIISLVCKSOC: Linear/volumetric conversion (strap) set header13BLOINDBlocking indicatornvarchar10
46OIISOCAOISOC: Storage object characteristic: appl. specific oil & g9BLOINDBlocking indicatornvarchar10
47OIISOCB1SOC: Storage object characteristic segment: bulk22BLOINDBlocking indicatornvarchar10
48OIISOCB2SOC: Storage object characteristic segment: packaged9BLOINDBlocking indicatornvarchar10
49OIISOCKSOC: Storage object characteristic segment header37BLOINDBlocking indicatornvarchar10
50OIISOCKLSOC: Storage object characteristic class21BLOINDBlocking indicatornvarchar10
51OIISOCO1SOC: Storage object characteristic segment: bulk27BLOINDBlocking indicatornvarchar10
52OIISOCTSMSOC: time dependent assignment SO <-> material (IS-Oil BDR27BLOINDBlocking indicatornvarchar10
53OIISOCTSPSOC: Assignment SO <-> Plant/Storage location IS-Oil BDRP11BLOINDBlocking indicatornvarchar10
54OIISOCTYPSOC: Storage object type11BLOINDBlocking indicatornvarchar10
55OIJ03_LOVTSW: Table for Left on Vehicle Entries23BLOINDBlocking indicatornvarchar10
56OIJBERBerth Table19BLOINDBlocking indicatornvarchar10
57OIJBERLOCIndex table for berths at TSW locations11BLOINDBlocking indicatornvarchar10
58OIJBERMATAssignment of material to berths12BLOINDBlocking indicatornvarchar10
59OIJBERSOCAssignment of berths to tanks11BLOINDBlocking indicatornvarchar10
60OIJBRDOIL-TSW: Rundown table for Batch30BLOINDBlocking indicatornvarchar10
61OIJBRDHRD header f.batch:Don't use(obsolete) & don't delete(XPRA)34BLOINDBlocking indicatornvarchar10
62OIJBRDNOMStock Projection item / nomination X-ref table25BLOINDBlocking indicatornvarchar10
63OIJHCT01OIL-TSW: Ticket Holding Table (Draft version 1) - OBSOLETE75BLOINDBlocking indicatornvarchar10
64OIJLOCLocation table13BLOINDBlocking indicatornvarchar10
65OIJLOCMATOIL-TSW: Location Rundown/Planning material table91BLOINDBlocking indicatornvarchar10
66OIJNOMCOIL-TSW: Nomination copy table52BLOINDBlocking indicatornvarchar10
67OIJNOMHNomination Header47BLOINDBlocking indicatornvarchar10
68OIJNOMINomination Item52BLOINDBlocking indicatornvarchar10
69OIJNOMIVERSNomination Item Version Table54BLOINDBlocking indicatornvarchar10
70OIJPHYINVPhysical inventory17BLOINDBlocking indicatornvarchar10
71OIJPLANLOCOIL TSW: Multiple planning Locations11BLOINDBlocking indicatornvarchar10
72OIJRDOIL-TSW: Rundown table29BLOINDBlocking indicatornvarchar10
73OIJRDHRundown header: Don't use (obsolete) & don't delete (XPRA)33BLOINDBlocking indicatornvarchar10
74OIJRDHTPSETOIL-TSW: Rundown Rack issue / throughput settings17BLOINDBlocking indicatornvarchar10
75OIJRDNOMStock Projection item / nomination X-ref table24BLOINDBlocking indicatornvarchar10
76OIJRRAOIL-TSW: Partner roles21BLOINDBlocking indicatornvarchar10
77OIJSDLOCOIL-TSW: Multiple sources/destinations of location19BLOINDBlocking indicatornvarchar10
78OIJTHPUTFCRack issue / Throughput forecast19BLOINDBlocking indicatornvarchar10
79OIJTHPUTFCAVGOIL-TSW: Rack issue / Throughput forecast daily average19BLOINDBlocking indicatornvarchar10
80OIJTHPUTFCESTOIL-TSW: Rack issue / Throughput estimate pop-up20BLOINDBlocking indicatornvarchar10
81OIJTSLOCOIL-TSW: transport system/location assignment table16BLOINDBlocking indicatornvarchar10
82OIJTSMATOIL-TSW: TS Rundown/Planning material table83BLOINDBlocking indicatornvarchar10
83OIJTSMATSEQDisallowed Material sequence within Transport system12BLOINDBlocking indicatornvarchar10
84OIJWLOIL-TSW: Worklist25BLOINDBlocking indicatornvarchar10
85OIJXTSW control record10BLOINDBlocking indicatornvarchar10
86OIJ_EL_CP_LAYTCharter party and laytime and demurrage agreement63BLOINDBlocking indicatornvarchar10
87OIJ_EL_CP_LOCCharter party contract: load and discharge locations15BLOINDBlocking indicatornvarchar10
88OIJ_EL_CP_PRODCharter contracts: products and product groups15BLOINDBlocking indicatornvarchar10
89OIJ_EL_DOC_EVRules for nomination events21BLOINDBlocking indicatornvarchar10
90OIJ_EL_DOC_H_REFOil TSW: Document header reference to nomination; not used12BLOINDBlocking indicatornvarchar10
91OIJ_EL_DOC_I_REFDocument item reference to nomination30BLOINDBlocking indicatornvarchar10
92OIJ_EL_DOC_MOTOil TSW: TSW Relevance of order item41BLOINDBlocking indicatornvarchar10
93OIJ_EL_DOC_M_MOTOIL TSW: TSW Details / Multiple MoT's13BLOINDBlocking indicatornvarchar10
94OIJ_EL_LAYT_EVLaytime start and end events25BLOINDBlocking indicatornvarchar10
95OIJ_EL_LAYT_INFLaytime terms21BLOINDBlocking indicatornvarchar10
96OIJ_EL_PROD_DATAProduction data for locations15BLOINDBlocking indicatornvarchar10
97OIJ_EL_TCKET_UOMUniversal ticket additional units of measure19BLOINDBlocking indicatornvarchar10
98OIJ_EL_TICKET_HUniversal ticket table17BLOINDBlocking indicatornvarchar10
99OIJ_EL_TICKET_IUniversal ticket item table43BLOINDBlocking indicatornvarchar10
100OIJ_LMTIMECONOILTSW: Time dependent constraints by location & material14BLOINDBlocking indicatornvarchar10
101OIJ_NOMLTLaytime and demurrage for groups in nominations21BLOINDBlocking indicatornvarchar10
102OIJ_RDHEADStock Projection header36BLOINDBlocking indicatornvarchar10
103OIJ_RELPROFOil-TSW: Release profiles for Schedules13BLOINDBlocking indicatornvarchar10
104OIJ_REPORT_QUANTSW: Reported Nomination quantities into/out of inventory14BLOINDBlocking indicatornvarchar10
105OIJ_SCHEDPlanned Schedule Lines103BLOINDBlocking indicatornvarchar10
106OIJ_SIM_SCHEDobsolete table (will be cleaned up)29BLOINDBlocking indicatornvarchar10
107OIJ_TGTSFTTIMETime dependent target and safety levels13BLOINDBlocking indicatornvarchar10