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

22 columns | Print definition?ERP 6.0  | PSPID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/BIC/B0000105000PSA for /CPD/PFP_DS_PROJ T90CLNT090 DataSource for Proj.5PSPIDnvarchar240
2/BIC/B0000105001PSA for /CPD/PFP_DS_PROJ T90CLNT090 DataSource for Proj.5PSPIDnvarchar240
3/BIC/B0000106000PSA for /CPD/PFP_DS_PROJ_TEXT T90CLNT090 DataSource for Proj7PSPIDnvarchar240
4/BIC/B0000116000Error Stack DTP_00O2TFWN1YKGA5W5VZK10E640 00014PSPIDnvarchar240
5/BIC/B0000224000Error Stack DTP_00O2TFWN1YKGA5W5VZK10ECFK 00015PSPIDnvarchar240
6ZPRJAPRdocument Status3PSPIDWork Breakdown Structure Element (WBS Element)nvarchar240
7ZPRJSUMProject summary3PSPIDProject Definitionnvarchar240
TOPCustomer Bill of Services
8BOSPS_ASSIGNMENTBOSPS: PS object links to the specified sales document4PSPIDProject Definitionnvarchar240
TOPIntegrated Product and Process Engineering
9PROFILCUST01iPPE: Profile for PS iPPE Interface7PSPIDProject Definitionnvarchar240
TOPInterface to External Project Software
10PDGUIDGUIDs for Project Definition4PSPIDProject Definitionnvarchar240
TOPMarketing Retail Network
11OIFOPROJObject links - PS project or project item (IS-Oil MRN)12PSPIDProject Definitionnvarchar240
TOPOperative Structures
12NHPROJNumber history - Project definition4PSPIDProject definitionnvarchar400
13PROJProject definition3PSPIDProject Definitionnvarchar240
TOPProject Summarization
14PSERBInheritance data, Project System5PSPIDProject Definitionnvarchar240
TOPProject System
15PSHLP_DRAFT_DBTable holds Draft Workbench Information4PSPIDProject Definitionnvarchar240
16PSHLP_DRAFT_DB_NTable holds Draft Workbench Information4PSPIDProject Definitionnvarchar240
TOPService Station Retailing
17OIRBOPROJObject links - PS project or project item (IS-Oil SSR)13PSPIDProject Definitionnvarchar240
TOPSimulation
18PROJVS_ENQBlock key project (project versions)3PSPIDProject Definitionnvarchar240
19VSPROJ_CNVersion: Project definition4PSPIDProject Definitionnvarchar240
TOPStructures
20PSHLP_PROJWL_DBProject Definition ACL Worklist3PSPIDProject Definitionnvarchar240
21PSSKF_DEFAU_TABDefault SKF for the the Project Parameters4PSPIDProject Definitionnvarchar240
TOPTemplates
22PROJSStandard project definition3PSPIDProject definition for standard projectnvarchar240