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

62 columns | Print definition?ERP 6.0  | PBLNR

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPBulk Distribution Requirements Planning
1OIIOTWSIBLBDRP-OTWS: Operations time window set index - business loc.2PBLNRBusiness location identifier (IS-Oil MRN)nvarchar100
2OIISCPLBLSite control: lead time applicabilities - business locatio2PBLNRBusiness location identifier (IS-Oil MRN)nvarchar100
TOPDownstream
3S414BIW1S414BIW1 * SSR DTF statistics9PBLNRBusiness location identifier (IS-Oil MRN)nvarchar100
4S414BIW2S414BIW2 * SSR DTF statistics9PBLNRBusiness location identifier (IS-Oil MRN)nvarchar100
TOPLogistics - General
5OIFSPBLPhysical Location - Master Data2PBLNRBusiness location identifier (IS-Oil MRN)nvarchar100
TOPMarketing Retail Network
6OIFBBP1Business partner role assignments (IS-Oil MRN)2PBLNRBusiness location identifier (IS-Oil MRN)nvarchar100
7OIFOANLAObject links - FI-AA asset master (IS-Oil MRN)2PBLNRBusiness location identifier (IS-Oil MRN)nvarchar100
8OIFOCEPCObject links - CO-PCA profit center (IS-Oil MRN)2PBLNRBusiness location identifier (IS-Oil MRN)nvarchar100
9OIFOCOASObject links - CO order (IS-Oil MRN)2PBLNRBusiness location identifier (IS-Oil MRN)nvarchar100
10OIFOCSKSObject links - CO cost center (IS-Oil MRN)2PBLNRBusiness location identifier (IS-Oil MRN)nvarchar100
11OIFOIFLOObject links - PM functional location (IS-Oil MRN)2PBLNRBusiness location identifier (IS-Oil MRN)nvarchar100
12OIFOPROJObject links - PS project or project item (IS-Oil MRN)2PBLNRBusiness location identifier (IS-Oil MRN)nvarchar100
13OIFOT001LObject links - CA storage location (IS-Oil MRN)2PBLNRBusiness location identifier (IS-Oil MRN)nvarchar100
14OIFOT001WObject links - CA Plant (IS-Oil MRN)2PBLNRBusiness location identifier (IS-Oil MRN)nvarchar100
15OIFPBLIndex to point at Business Location2PBLNRBusiness location identifier (IS-Oil MRN)nvarchar100
16OIFSMCADDRLink Table Between OIFSPBL and ADRC for Matchcode2PBLNRBusiness location identifier (IS-Oil MRN)nvarchar100
TOPService Station Retailing
17B414LocationID/PrnGp4PBLNRBusiness location identifier (IS-Oil MRN)nvarchar100
18OIRADBTDocument base table5PBLNRBusiness location identifier (IS-Oil MRN)nvarchar100
19OIRA_PRNDOC_HEADPrint document header data7PBLNRBusiness location identifier (IS-Oil MRN)nvarchar100
20OIRBBP1PFLocation partner role SD partner functions (IS-Oil SSR)2PBLNRBusiness location identifier (IS-Oil MRN)nvarchar100
21OIRBCSTOREC-Store/Retail specific data (IS-Oil SSR)2PBLNRBusiness location identifier (IS-Oil MRN)nvarchar100
22OIRBMATMETBusiness Location material/meter assignment (IS-Oil, SSR)2PBLNRBusiness location identifier (IS-Oil MRN)nvarchar100
23OIRBOANLAObject links - FI-AA asset master (IS-Oil SSR)2PBLNRBusiness location identifier (IS-Oil MRN)nvarchar100
24OIRBOCEPCObject links - CO-PCA profit center (IS-Oil SSR)2PBLNRBusiness location identifier (IS-Oil MRN)nvarchar100
25OIRBOCOASObject links - CO order (IS-Oil SSR)2PBLNRBusiness location identifier (IS-Oil MRN)nvarchar100
26OIRBOCSKSObject links - CO cost center (IS-Oil SSR)2PBLNRBusiness location identifier (IS-Oil MRN)nvarchar100
27OIRBOIFLOObject links - PM functional location (IS-Oil SSR)2PBLNRBusiness location identifier (IS-Oil MRN)nvarchar100
28OIRBOMMT001LObject links - CA storage location (IS-Oil MRN)2PBLNRBusiness location identifier (IS-Oil MRN)nvarchar100
29OIRBOPROJObject links - PS project or project item (IS-Oil SSR)2PBLNRBusiness location identifier (IS-Oil MRN)nvarchar100
30OIRBOT001LObject links - CA storage location (IS-Oil SSR)2PBLNRBusiness location identifier (IS-Oil MRN)nvarchar100
31OIRBOT001WObject links - CA Plant (IS-Oil SSR)2PBLNRBusiness location identifier (IS-Oil MRN)nvarchar100
32OIRBPBLBBusiness location at business type level (IS-OIL SSR)2PBLNRBusiness location identifier (IS-Oil MRN)nvarchar100
33OIRBPBLPBLLink Table Location-Loc(Competitor assgnmnt)(IS-OIL,SSR)2PBLNRBusiness location identifier (IS-Oil MRN)nvarchar100
34OIRBPBLSTATLocation Status definition (IS-Oil SSR)2PBLNRBusiness location identifier (IS-Oil MRN)nvarchar100
35OIRCCOMPDSSR Pricing - Competitor price differences2PBLNRBusiness location identifier (IS-Oil MRN)nvarchar100
36OIRCCOMPDMSSR Pricing - Competitor price differences/Material2PBLNRBusiness location identifier (IS-Oil MRN)nvarchar100
37OIRCLPCDSSR Pricing - Location price cluster differences4PBLNRBusiness location identifier (IS-Oil MRN)nvarchar100
38OIRCLPCDMSSR Pricing - Location price cluster differences/Material4PBLNRBusiness location identifier (IS-Oil MRN)nvarchar100
39OIRC_DRREJSSR Stocks - Dip readings rejected records2PBLNRBusiness location identifier (IS-Oil MRN)nvarchar100
40OIRC_DRREJ_ERRSSR Stocks - Dip readings rejected records - Error list2PBLNRBusiness location identifier (IS-Oil MRN)nvarchar100
41OIRC_GMMHSSR Meters - History63PBLNRBusiness location identifier (IS-Oil MRN)nvarchar100
42OIRC_GMMH_AGG01SSR Meters - Aggregated history (Monthly)3PBLNRBusiness location identifier (IS-Oil MRN)nvarchar100
43OIRC_GMMH_AGG011SSR Meters - Aggregated history (Monthly)3PBLNRBusiness location identifier (IS-Oil MRN)nvarchar100
44OIRC_GMMH_DELSSR Meters - Deleted meter readings history64PBLNRBusiness location identifier (IS-Oil MRN)nvarchar100
45OIRC_MRREJSSR Meters - Meter readings rejected records2PBLNRBusiness location identifier (IS-Oil MRN)nvarchar100
46OIRC_MRREJ_ERRSSR Meters - MR rejected records - Error list (OBSOLETE)2PBLNRBusiness location identifier (IS-Oil MRN)nvarchar100
47OIRC_MRREJ_ERRLSSR Meters - Meter readings rejected records - Error list2PBLNRBusiness location identifier (IS-Oil MRN)nvarchar100
48OIRC_PRCHKSSR Pricing - Price check2PBLNRBusiness location identifier (IS-Oil MRN)nvarchar100
49OIRC_PRLOG_OBJSSR Pricing - Price update location list3PBLNRBusiness location identifier (IS-Oil MRN)nvarchar100
50OIRC_PRLOG_PRLSSR Pricing - Old and new prices3PBLNRBusiness location identifier (IS-Oil MRN)nvarchar100
51OIRC_SOCDIPSSR Stocks - Dip readings history132PBLNRBusiness location identifier (IS-Oil MRN)nvarchar100
52OIREPBLSSR PC: Types per business location3PBLNRBusiness location identifier (IS-Oil MRN)nvarchar100
53OIRESPCRSSR PC: Splitting criteria8PBLNRBusiness location identifier (IS-Oil MRN)nvarchar100
54OIREUPLKXXXXSSR PC: Template for generated DTF tables (header)6PBLNRBusiness location identifier (IS-Oil MRN)nvarchar100
55OIRE_RECON_AGGAggregated reconciliation data4PBLNRBusiness location identifier (IS-Oil MRN)nvarchar100
56OIRE_RECON_DETDetailed reconciliation data4PBLNRBusiness location identifier (IS-Oil MRN)nvarchar100
57S414SSR DTF statistics9PBLNRBusiness location identifier (IS-Oil MRN)nvarchar100
58S414ES414 - Structural information4PBLNRBusiness location identifier (IS-Oil MRN)nvarchar100
TOPTraders and Schedulers Workbench
59OIISCPBLSCP: Site control parameters (business loc) - IS-Oil BDRP2PBLNRBusiness location identifier (IS-Oil MRN)nvarchar100
60OIISOCIBLSOC: Index for business location/sequence no. access mode2PBLNRBusiness location identifier (IS-Oil MRN)nvarchar100
61OIJBERLOCIndex table for berths at TSW locations2PBLNRBusiness location identifier (IS-Oil MRN)nvarchar100
62OIJLOCLocation table31PBLNRBusiness location identifier (IS-Oil MRN)nvarchar100