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

33 columns | Print definition?ERP 6.0  | PROVIDER_ID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/IWPGW/I_TGW_FACTask Gateway: Facade Implementation per Software Version3PROVIDER_IDTask Gateway: Task Provider IDnvarchar40
2DODP_ASSOCDBOSC-DP: Association4PROVIDER_IDDBOSC-CR: Generated ID (30)nvarchar300
3DODP_ASSOCNDBOSC-DP: Navigation Association4PROVIDER_IDDBOSC-CR: Generated ID (30)nvarchar300
4DODP_ASSOCRDBOSC-DP: Referential Association4PROVIDER_IDDBOSC-CR: Generated ID (30)nvarchar300
5DODP_FIELDDBOSC-DP: Data Provider Field4PROVIDER_IDDBOSC-CR: Generated ID (30)nvarchar300
6DODP_FIELD_VALUEDBOS-DP: Data Provider Field Value4PROVIDER_IDDBOSC-CR: Generated ID (30)nvarchar300
7DODP_MAP_SOURCEDBOSC-DP: Map Data Provider to Data Source4PROVIDER_IDDBOSC-CR: Generated ID (30)nvarchar300
8DODP_PROVIDERDBOSC-DP: Data Providers3PROVIDER_IDDBOSC-CR: Generated ID (30)nvarchar300
9DORQ_FIELDDBOSC-RQ: Request Fields4PROVIDER_IDDBOSC-CR: Generated ID (30)nvarchar300
10DORQ_OPTIONDBOSC-RQ: Request Options4PROVIDER_IDDBOSC-CR: Generated ID (30)nvarchar300
11DORQ_REQUESTDBOSC-RQ: Request4PROVIDER_IDDBOSC-CR: Generated ID (30)nvarchar300
TOPGateway Business Workflow enablement
12/IWWRK/I_WF_PACTActivation Status of Workflow Task Providers1PROVIDER_IDWorkflow Task Provider IDnvarchar50
13/IWWRK/I_WF_PADPWorkflow Task Provider Adapter Classes1PROVIDER_IDWorkflow Task Provider IDnvarchar50
14/IWWRK/I_WF_PROVWorkflow task providers1PROVIDER_IDWorkflow Task Provider IDnvarchar50
15/IWWRK/I_WF_PSRVServices for workflow task provider1PROVIDER_IDWorkflow Task Provider IDnvarchar50
TOPHR Administrative Services
16T5ASRDTOBJHIERObject Hierarchy11PROVIDER_IDBrowser Provider IDnvarchar320
17T5ASRDTPROVProvider Classes1PROVIDER_IDBrowser Provider IDnvarchar320
TOPNetWeaver Enterprise Search
18ESH_ADM_MDM_CONNESH: Connections to MDM Servers3PROVIDER_IDMDM: Provider ID for MDM Version Supportnvarchar200
19ESH_EX_FU_CONNReal-Time indexing: Registered Objects5PROVIDER_IDProvider IDnvarchar320
20ESH_OM_ADPRVDData Providers6PROVIDER_IDProvider IDnvarchar320
21ESH_OM_AOTYPObject Types8PROVIDER_IDProvider IDnvarchar320
22ESH_OM_CDPRVDData Providers6PROVIDER_IDProvider IDnvarchar320
23ESH_OM_COTYPObject Types8PROVIDER_IDProvider IDnvarchar320
24ESH_OM_IDPRVDData Providers6PROVIDER_IDProvider IDnvarchar320
25ESH_OM_IOTYPObject Types8PROVIDER_IDProvider IDnvarchar320
26ESH_OM_SDPRVDData Providers6PROVIDER_IDProvider IDnvarchar320
27ESH_OM_SOTYPObject Types8PROVIDER_IDProvider IDnvarchar320
TOPPortfolio Management
28/RPM/BUCKET_SOperational bucket service providers5PROVIDER_IDAttribute Idnvarchar150
29RPM_BUCKET_S_CDBucket service table - Pseudo table for change documents5PROVIDER_IDAttribute Idnvarchar150
TOPPosition Budgeting and Control
30T77HRFPMLGENH01Define Enhancements5PROVIDER_IDFilter Definition (Data Extractor)nvarchar80
TOPUser Interface
31CRMC_UI_GRP_PROVAssociation of Feed Groups to Providers4PROVIDER_IDFeed entries provider idnvarchar300
32CRM_FD_PROVFeed entries providers2PROVIDER_IDFeed entries provider idnvarchar300
33CRM_FD_PROV_TText table for CRM_FD_PROV2PROVIDER_IDFeed entries provider idnvarchar300