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

156 columns | Print definition?ERP 6.0  | ERZEIT

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/GSINS/INH_RIDHHCM-FSCD: List of HCM Posting runs to be processed10ERZEITTime, at Which Record Was Addednvarchar60
2HRPADNLP_LOG0015NL Pens: infortype 0015 log for Payroll Process21ERZEITTime, at Which Record Was Addednvarchar60
3HRPADNLP_LOGIMMENL Pens: Immediate Payments - log for Payroll Process16ERZEITTime, at Which Record Was Addednvarchar60
4HRPADNLP_LOGSTATNL Pens: Person posting status for FICA10ERZEITTime, at Which Record Was Addednvarchar60
5IDREPFW_STORHRep.Framework: Data Storage - Headers7ERZEITTime, at Which Record Was Addednvarchar60
TOPBulk Distribution Requirements Planning
6OIIGMMHGMM: Meter history14ERZEITTime record creatednvarchar60
7OIIGMMKGMM: General meter header table27ERZEITTime record creatednvarchar60
8OIIGMMMGMM: Meter/Material assignment8ERZEITTime record creatednvarchar60
9OIIOTWSKBDRP-OTWS: Operations time window set header4ERZEITTime record creatednvarchar60
10OIISCPWKSCP: Site control parameters (plant) - IS-Oil BDRP38ERZEITTime record creatednvarchar60
11OIISLVCHSilo calibration history index8ERZEITTime record creatednvarchar60
12OIISLVCKOSilo: Calibration - LVC (strap) set header31ERZEITTime record creatednvarchar60
13OIISOCTSSSOC: time dependent assignment SO <-> SO (IS-Oil BDRP)8ERZEITTime record creatednvarchar60
14OII_DIP_MVMTRelated stock derived from SOC material assignment18ERZEITTime record creatednvarchar60
TOPBusiness Partner
15DFKKBPCL_IMPImport Data of Business Partner Duplicates8ERZEITTime of Data Entrynvarchar60
TOPClinical System
16N2FARZTNWIS-H*MED: Protocol for calling med. specialist exper. rcrd6ERZEITIS-H: Time Record Creatednvarchar60
TOPConsumer Products for Food Beverage
17CFB_BACKFLUSHBackflush of Batches15ERZEITTime, at Which Record Was Addednvarchar60
TOPContract Accounts Receivable and Payable
18DFKKCOLI_LOGCollection Agency Information File: Communication Log24ERZEITTime of Data Entrynvarchar60
19DFKKCOL_LOGCollections Agency File: Settlement Log (Payments)21ERZEITTime, at Which Record Was Addednvarchar60
TOPCross-Application Topics
20/SPE/DELTA_DELVDelta Tool: Results of delivery comparison7ERZEITDelat Tool: Time when results were savednvarchar60
TOPEmpties Management
21/BEV1/EM0LGMTXCustomizing - Empties Calculation25ERZEITTime, at Which Record Was Addednvarchar60
22/BEV1/EMVISFEmpties Customizing Selection for SIS fields6ERZEITTime, at Which Record Was Addednvarchar60
TOPFunctional Locations
23IHPAPlant Maintenance: Partners9ERZEITTime, at Which Record Was Addednvarchar60
TOPInterface to Terminal Automation System
24OIK01IS-OIL/TAS: LID Document Data19ERZEITTime, at Which Record Was Addednvarchar60
25OIK01DIS-OIL/TAS: deactivated LID Document Data20ERZEITTime, at Which Record Was Addednvarchar60
26OIKLIDRTD - TAS Reference Table54ERZEITTime, at Which Record Was Addednvarchar60
TOPLogistics - General
27OIFSPBLPhysical Location - Master Data14ERZEITTime Record Created at (Time)nvarchar60
28OIJTSTransport system (IS-Oil TSW standard/core object )31ERZEITTime of creationnvarchar60
29WBHFTrading Contract: Document Flow11ERZEITTime, at Which Record Was Addednvarchar60
30WBHKTrading Contract: Header Data10ERZEITTime, at Which Record Was Addednvarchar60
TOPMaintenance Notifications
31QMELQuality Notification53ERZEITTime, at Which Record Was Addednvarchar60
32QMFEQuality notification - items21ERZEITTime, at Which Record Was Addednvarchar60
33QMMAQuality notification - activities24ERZEITTime, at Which Record Was Addednvarchar60
34QMSMQuality notification - tasks28ERZEITTime, at Which Record Was Addednvarchar60
35QMURQuality notification - causes16ERZEITTime, at Which Record Was Addednvarchar60
TOPMarketing Retail Network
36OIFBBP1Business partner role assignments (IS-Oil MRN)8ERZEITTime Record Created at (Time)nvarchar60
37OIFBPBLTLocation type - permissible partner roles (IS-Oil MRN)5ERZEITTime Record Created at (Time)nvarchar60
38OIFBRF2Bus. par. roles - permissible tech. categories (IS-Oil MRN)5ERZEITTime Record Created at (Time)nvarchar60
39OIFCOPT1Retail Network Contract option type4ERZEITTime Record Created at (Time)nvarchar60
40OIFDD1Delivery point info for bulk delivery preplannning33ERZEITTime Record Created at (Time)nvarchar60
41OIFDD2Bulk delivery preplanning version4ERZEITTime Record Created at (Time)nvarchar60
42OIFDDM1Del. point/material info for bulk delivery planning19ERZEITTime Record Created at (Time)nvarchar60
43OIFDDM2Del. point/material/tank (bulk delivery planning)8ERZEITTime Record Created at (Time)nvarchar60
44OIFDDM3Del. point/material/meter (bulk delivery planning)9ERZEITTime Record Created at (Time)nvarchar60
45OIFDTT1Tank type table - bulk delivery planning9ERZEITTime Record Created at (Time)nvarchar60
46OIFOANLAObject links - FI-AA asset master (IS-Oil MRN)5ERZEITTime Record Created at (Time)nvarchar60
47OIFOCEPCObject links - CO-PCA profit center (IS-Oil MRN)5ERZEITTime Record Created at (Time)nvarchar60
48OIFOCOASObject links - CO order (IS-Oil MRN)5ERZEITTime Record Created at (Time)nvarchar60
49OIFOCSKSObject links - CO cost center (IS-Oil MRN)5ERZEITTime Record Created at (Time)nvarchar60
50OIFOIFLOObject links - PM functional location (IS-Oil MRN)5ERZEITTime Record Created at (Time)nvarchar60
51OIFOPBLTLocation type - permissible object links (IS-Oil MRN)4ERZEITTime Record Created at (Time)nvarchar60
52OIFOPROJObject links - PS project or project item (IS-Oil MRN)5ERZEITTime Record Created at (Time)nvarchar60
53OIFORACTIVActivation of Oil-Retail Integration Components10ERZEITTime Record Created at (Time)nvarchar60
54OIFORCAMConversion of article master to material master data (ALE)12ERZEITTime Record Created at (Time)nvarchar60
55OIFORCPRTransfer customer expected price into sales condition record6ERZEITTime Record Created at (Time)nvarchar60
56OIFOT001LObject links - CA storage location (IS-Oil MRN)5ERZEITTime Record Created at (Time)nvarchar60
57OIFOT001WObject links - CA Plant (IS-Oil MRN)5ERZEITTime Record Created at (Time)nvarchar60
TOPMaterial Identification and Reconciliation
58HUM_KOMMIHUM Picking with Partial GI Posting13ERZEITTime, at Which Record Was Addednvarchar60
TOPMaterial Sorting
59/BEV1/EMFAS1Material Sorting: Sales Documents7ERZEITTime, at Which Record Was Addednvarchar60
60/BEV1/EMFAS2Material Sorting: Shipping Documents8ERZEITTime, at Which Record Was Addednvarchar60
61/BEV1/EMFAS3Material Sorting: Groups8ERZEITTime, at Which Record Was Addednvarchar60
62/BEV1/EMFAS4Material Sorting: Billing Documents9ERZEITTime, at Which Record Was Addednvarchar60
TOPMeter Reading
63ELWEG_LOGLog Numbers for Street Routes5ERZEITTime, at Which Record Was Addednvarchar60
TOPRemaining Beverage - Obsolete Objects
64/BEV1/RBCUSTRebate Customizing History15ERZEITTimenvarchar60
TOPRevenues and Earnings
65VPKHEADSales Pricing Header Data14ERZEITSystem Timenvarchar60
TOPSAP Ambulatory Care Management
66N2HM_KPFACM: Kopfdaten zum Heilmittelkatalog8ERZEITUhrzeit, zu der der Satz hinzugefügt wurdenvarchar60
TOPSCM Basis
67APODELTAATP: POSGUID Copied to a Second R/3 System8ERZEITTime, at Which Record Was Addednvarchar60
TOPService Station Retailing
68OIRBOANLAObject links - FI-AA asset master (IS-Oil SSR)6ERZEITTime Record Created at (Time)nvarchar60
69OIRBOCEPCObject links - CO-PCA profit center (IS-Oil SSR)6ERZEITTime Record Created at (Time)nvarchar60
70OIRBOCOASObject links - CO order (IS-Oil SSR)6ERZEITTime Record Created at (Time)nvarchar60
71OIRBOCSKSObject links - CO cost center (IS-Oil SSR)6ERZEITTime Record Created at (Time)nvarchar60
72OIRBOIFLOObject links - PM functional location (IS-Oil SSR)6ERZEITTime Record Created at (Time)nvarchar60
73OIRBOMMT001LObject links - CA storage location (IS-Oil MRN)5ERZEITTime Record Created at (Time)nvarchar60
74OIRBOPROJObject links - PS project or project item (IS-Oil SSR)6ERZEITTime Record Created at (Time)nvarchar60
75OIRBOT001LObject links - CA storage location (IS-Oil SSR)6ERZEITTime Record Created at (Time)nvarchar60
76OIRBOT001WObject links - CA Plant (IS-Oil SSR)6ERZEITTime Record Created at (Time)nvarchar60
77OIRBPBLBBusiness location at business type level (IS-OIL SSR)24ERZEITTime Record Created at (Time)nvarchar60
78OIRC_DRREJSSR Stocks - Dip readings rejected records72ERZEITTime record creatednvarchar60
79OIRC_GMMHSSR Meters - History56ERZEITTime record creatednvarchar60
80OIRC_GMMH_DELSSR Meters - Deleted meter readings history57ERZEITTime record creatednvarchar60
81OIRC_MRREJSSR Meters - Meter readings rejected records59ERZEITTime record creatednvarchar60
82OIRC_PRCHKSSR Pricing - Price check23ERZEITTime record creatednvarchar60
83OIRC_PRLOG_PRMSSR Pricing - Price update parameter log18ERZEITTime record creatednvarchar60
84OIRC_SOCDIPSSR Stocks - Dip readings history69ERZEITTime record creatednvarchar60
TOPTraders and Schedulers Workbench
85OIB_TANKDIPSilo management tank strapping history20ERZEITTime record creatednvarchar60
86OIFSBLCDBlocking Indicator for Business Locations7ERZEITTime Record Created at (Time)nvarchar60
87OIFSPBLTPhysical Business Location Type10ERZEITTime Record Created at (Time)nvarchar60
88OIISCPBLSCP: Site control parameters (business loc) - IS-Oil BDRP40ERZEITTime record creatednvarchar60
89OIISCPKNSCP: Site control parameters (customer) - IS-Oil BDRP38ERZEITTime record creatednvarchar60
90OIISLVCKSOC: Linear/volumetric conversion (strap) set header8ERZEITTime record creatednvarchar60
91OIISOCAOISOC: Storage object characteristic: appl. specific oil & g4ERZEITTime record creatednvarchar60
92OIISOCB1SOC: Storage object characteristic segment: bulk17ERZEITTime record creatednvarchar60
93OIISOCB2SOC: Storage object characteristic segment: packaged4ERZEITTime record creatednvarchar60
94OIISOCKSOC: Storage object characteristic segment header32ERZEITTime record creatednvarchar60
95OIISOCKLSOC: Storage object characteristic class16ERZEITTime record creatednvarchar60
96OIISOCO1SOC: Storage object characteristic segment: bulk22ERZEITTime record creatednvarchar60
97OIISOCTSMSOC: time dependent assignment SO <-> material (IS-Oil BDR22ERZEITTime record creatednvarchar60
98OIISOCTSPSOC: Assignment SO <-> Plant/Storage location IS-Oil BDRP6ERZEITTime record creatednvarchar60
99OIISOCTYPSOC: Storage object type6ERZEITTime record creatednvarchar60
100OIJ03_LOVTSW: Table for Left on Vehicle Entries18ERZEITTime of creationnvarchar60
101OIJBERBerth Table14ERZEITTime of creationnvarchar60
102OIJBERLOCIndex table for berths at TSW locations6ERZEITTime of creationnvarchar60
103OIJBERMATAssignment of material to berths7ERZEITTime of creationnvarchar60
104OIJBERSOCAssignment of berths to tanks6ERZEITTime of creationnvarchar60
105OIJBRDOIL-TSW: Rundown table for Batch25ERZEITTime of creationnvarchar60
106OIJBRDHRD header f.batch:Don't use(obsolete) & don't delete(XPRA)29ERZEITTime of creationnvarchar60
107OIJBRDNOMStock Projection item / nomination X-ref table20ERZEITTime of creationnvarchar60
108OIJCLIPBOARDClipboard Table for Railcar32ERZEITTime of creationnvarchar60
109OIJHCT01OIL-TSW: Ticket Holding Table (Draft version 1) - OBSOLETE70ERZEITTime of creationnvarchar60
110OIJLOCLocation table8ERZEITTime of creationnvarchar60
111OIJLOCMATOIL-TSW: Location Rundown/Planning material table86ERZEITTime of creationnvarchar60
112OIJNOMCOIL-TSW: Nomination copy table102ERZEITTime of creationnvarchar60
113OIJNOMHNomination Header51ERZEITTime of creationnvarchar60
114OIJNOMHATLOADNomination Hatch load sequence plan17ERZEITTime of creationnvarchar60
115OIJNOMHATPLANNomination: hatch plan8ERZEITTime of creationnvarchar60
116OIJNOMINomination Item102ERZEITTime of creationnvarchar60
117OIJNOMSUBITEMSNomination Sub-Item52ERZEITTime of creationnvarchar60
118OIJPHYINVPhysical inventory12ERZEITTime of creationnvarchar60
119OIJPLANLOCOIL TSW: Multiple planning Locations6ERZEITTime of creationnvarchar60
120OIJRDOIL-TSW: Rundown table24ERZEITTime of creationnvarchar60
121OIJRDHRundown header: Don't use (obsolete) & don't delete (XPRA)28ERZEITTime of creationnvarchar60
122OIJRDHTPSETOIL-TSW: Rundown Rack issue / throughput settings12ERZEITTime of creationnvarchar60
123OIJRDNOMStock Projection item / nomination X-ref table19ERZEITTime of creationnvarchar60
124OIJRRAOIL-TSW: Partner roles16ERZEITTime of creationnvarchar60
125OIJSDLOCOIL-TSW: Multiple sources/destinations of location14ERZEITTime of creationnvarchar60
126OIJTHPUTFCRack issue / Throughput forecast14ERZEITTime of creationnvarchar60
127OIJTHPUTFCAVGOIL-TSW: Rack issue / Throughput forecast daily average14ERZEITTime of creationnvarchar60
128OIJTHPUTFCESTOIL-TSW: Rack issue / Throughput estimate pop-up15ERZEITTime of creationnvarchar60
129OIJTSLOCOIL-TSW: transport system/location assignment table11ERZEITTime of creationnvarchar60
130OIJTSMATOIL-TSW: TS Rundown/Planning material table78ERZEITTime of creationnvarchar60
131OIJTSMATSEQDisallowed Material sequence within Transport system7ERZEITTime of creationnvarchar60
132OIJWLOIL-TSW: Worklist20ERZEITTime of creationnvarchar60
133OIJXTSW control record5ERZEITTime of creationnvarchar60
134OIJ_EL_CP_LAYTCharter party and laytime and demurrage agreement58ERZEITTime of creationnvarchar60
135OIJ_EL_CP_LOCCharter party contract: load and discharge locations10ERZEITTime of creationnvarchar60
136OIJ_EL_CP_PRODCharter contracts: products and product groups10ERZEITTime of creationnvarchar60
137OIJ_EL_DOC_EVRules for nomination events16ERZEITTime of creationnvarchar60
138OIJ_EL_DOC_H_REFOil TSW: Document header reference to nomination; not used7ERZEITTime of creationnvarchar60
139OIJ_EL_DOC_I_REFDocument item reference to nomination25ERZEITTime of creationnvarchar60
140OIJ_EL_DOC_MOTOil TSW: TSW Relevance of order item36ERZEITTime of creationnvarchar60
141OIJ_EL_DOC_M_MOTOIL TSW: TSW Details / Multiple MoT's8ERZEITTime of creationnvarchar60
142OIJ_EL_LAYT_EVLaytime start and end events20ERZEITTime of creationnvarchar60
143OIJ_EL_LAYT_INFLaytime terms16ERZEITTime of creationnvarchar60
144OIJ_EL_PROD_DATAProduction data for locations10ERZEITTime of creationnvarchar60
145OIJ_EL_TCKET_UOMUniversal ticket additional units of measure14ERZEITTime of creationnvarchar60
146OIJ_EL_TICKET_HUniversal ticket table12ERZEITTime of creationnvarchar60
147OIJ_EL_TICKET_IUniversal ticket item table38ERZEITTime of creationnvarchar60
148OIJ_LMTIMECONOILTSW: Time dependent constraints by location & material9ERZEITTime of creationnvarchar60
149OIJ_NOMLTLaytime and demurrage for groups in nominations16ERZEITTime of creationnvarchar60
150OIJ_RDHEADStock Projection header31ERZEITTime of creationnvarchar60
151OIJ_RELPROFOil-TSW: Release profiles for Schedules8ERZEITTime of creationnvarchar60
152OIJ_REPORT_QUANTSW: Reported Nomination quantities into/out of inventory9ERZEITTime of creationnvarchar60
153OIJ_SCHEDPlanned Schedule Lines149ERZEITTime of creationnvarchar60
154OIJ_SIM_SCHEDobsolete table (will be cleaned up)24ERZEITTime of creationnvarchar60
155OIJ_TGTSFTTIMETime dependent target and safety levels8ERZEITTime of creationnvarchar60
156OIJ_VEH_PERFMarine Scheduling - Table to Store vehicle Performanace24ERZEITTime of creationnvarchar60