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

63 columns | Print definition?ERP 6.0  | ENV_ID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1CNVTDMSBW_BPCTDMS control table for BW BPC3ENV_IDnvarchar200
2DOCRP_FLDBMPDBOS Cockpit: CRP: Source Field2ENV_IDDBOSC-CR: Generated ID (4)nvarchar40
3DOCRP_SOURCEDBOSC: CBR: CIM Data Source2ENV_IDDBOSC-CR: Generated ID (4)nvarchar40
4DOCRP_SRCBMPDBOSC: CBR: CIM Data Source2ENV_IDDBOSC-CR: Generated ID (4)nvarchar40
5DOCR_ENVDBOSC-CR: Environment2ENV_IDDBOSC-CR: Generated ID (4)nvarchar40
6DOCR_LOG_ENVDBOSC-CR: Logging and tracing Environment2ENV_IDDBOSC-CR: Generated ID (4)nvarchar40
7DODP_ASSOCDBOSC-DP: Association2ENV_IDDBOSC-CR: Generated ID (4)nvarchar40
8DODP_ASSOCNDBOSC-DP: Navigation Association2ENV_IDDBOSC-CR: Generated ID (4)nvarchar40
9DODP_ASSOCN_FLDDBOSC-DP: Navigation Association Fields2ENV_IDDBOSC-CR: Generated ID (4)nvarchar40
10DODP_ASSOCRDBOSC-DP: Referential Association2ENV_IDDBOSC-CR: Generated ID (4)nvarchar40
11DODP_ASSOCR_FLDDBOSC-DP: Referential Association Fields2ENV_IDDBOSC-CR: Generated ID (4)nvarchar40
12DODP_ASSOC_FIELDDBOSC-DP: Association From Field to Reference Field2ENV_IDDBOSC-CR: Generated ID (4)nvarchar40
13DODP_FIELDDBOSC-DP: Data Provider Field2ENV_IDDBOSC-CR: Generated ID (4)nvarchar40
14DODP_FIELD_VALUEDBOS-DP: Data Provider Field Value2ENV_IDDBOSC-CR: Generated ID (4)nvarchar40
15DODP_MAP_FIELDDBOSC-DP: Map Data Provider Filed to Data Source Field2ENV_IDDBOSC-CR: Generated ID (4)nvarchar40
16DODP_MAP_SOURCEDBOSC-DP: Map Data Provider to Data Source2ENV_IDDBOSC-CR: Generated ID (4)nvarchar40
17DODP_PROCESSORDBOSC-DP: Data Provider Processor3ENV_IDDBOSC-CR: Generated ID (4)nvarchar40
18DODP_PROVIDERDBOSC-DP: Data Providers4ENV_IDDBOSC-CR: Generated ID (4)nvarchar40
19DODP_SERVICEDBOSC-DP: Service3ENV_IDDBOSC-CR: Generated ID (4)nvarchar40
20DODR_DB_STMTDBOSC-DR: Direct SQL Request Statements2ENV_IDDBOSC-CR: Generated ID (4)nvarchar40
21DOOD_ENTITY_TYPEDBOSC-OD: OData Entity Type2ENV_IDDBOSC-CR: Generated ID (4)nvarchar40
22DOOD_SERVICEDBOSC-OD: Service2ENV_IDDBOSC-CR: Generated ID (4)nvarchar40
23DORAN_FIELDDBOSC-RAN: Data Source Field2ENV_IDDBOSC-CR: Generated ID (4)nvarchar40
24DORAN_SOURCEDBOSC-RAN: Request Processor for All - Native2ENV_IDDBOSC-CR: Generated ID (4)nvarchar40
25DORDS_ACCESSDBOSC-DRS: Request Process Database SQL Access2ENV_IDDBOSC-CR: Generated ID (4)nvarchar40
26DORDS_ANSIJOINDBOSC-RDS: Request Process Database SQL Virtual2ENV_IDDBOSC-CR: Generated ID (4)nvarchar40
27DORDS_FIELDDBOSC-RDS: Reques Process DB SQL Data Source Field2ENV_IDDBOSC-CR: Generated ID (4)nvarchar40
28DORDS_FUNCTIONDBOSC-DRS: Request Process Database SQL Function2ENV_IDDBOSC-CR: Generated ID (4)nvarchar40
29DORDS_INVIEWDBOSC-DRS: Request Process Database SQL Inlined View2ENV_IDDBOSC-CR: Generated ID (4)nvarchar40
30DORDS_JOIN_CONDDBOSC-DRS: Request Process Database SQL Join Condition2ENV_IDDBOSC-CR: Generated ID (4)nvarchar40
31DORDS_JOIN_EQDBOSC-RDS: Reques Process DB SQL Data Source Join Field EQ2ENV_IDDBOSC-CR: Generated ID (4)nvarchar40
32DORDS_JOIN_PARTDBOSC-DRS: Request Process Database SQL Join parts2ENV_IDDBOSC-CR: Generated ID (4)nvarchar40
33DORDS_OPTIONDBOSC-DRS: Request Processor Database Option2ENV_IDDBOSC-CR: Generated ID (4)nvarchar40
34DORDS_PARAMETERDBOSC-RDS: Request Process DB SQL Parameter2ENV_IDDBOSC-CR: Generated ID (4)nvarchar40
35DORDS_SETDBOSC-DRS: Request Process Database SQL Virtual2ENV_IDDBOSC-CR: Generated ID (4)nvarchar40
36DORDS_SET_EQDBOSC-RDS: Reques Process DB SQL Data Source Set Field EQ2ENV_IDDBOSC-CR: Generated ID (4)nvarchar40
37DORDS_SET_PARTDBOSC-DRS: Request Process Database SQL Set parts2ENV_IDDBOSC-CR: Generated ID (4)nvarchar40
38DORDS_SET_UNITEDBOSC-DRS: Request Process Database SQL Set combination2ENV_IDDBOSC-CR: Generated ID (4)nvarchar40
39DORDS_SOURCEDBOSC-RDS: Reques Processor DB SQL Data Source2ENV_IDDBOSC-CR: Generated ID (4)nvarchar40
40DORDS_TABLEDBOSC-DRS: Request Process Database SQL Table2ENV_IDDBOSC-CR: Generated ID (4)nvarchar40
41DORDS_VIRTUALDBOSC-DRS: Request Process Database SQL Virtual2ENV_IDDBOSC-CR: Generated ID (4)nvarchar40
42DORQ_FIELDDBOSC-RQ: Request Fields2ENV_IDDBOSC-CR: Generated ID (4)nvarchar40
43DORQ_OPTIONDBOSC-RQ: Request Options2ENV_IDDBOSC-CR: Generated ID (4)nvarchar40
44DORQ_PROPDBOSC-RQ: Request Properties2ENV_IDDBOSC-CR: Generated ID (4)nvarchar40
45DORQ_REQUESTDBOSC-RQ: Request2ENV_IDDBOSC-CR: Generated ID (4)nvarchar40
46DOUI_DOMAINDBOSC-UI: UI Domains3ENV_IDDBOSC-CR: Generated ID (4)nvarchar40
47DOUI_ELEMDBOS Cockpit: Screen Element2ENV_IDDBOSC-CR: Generated ID (4)nvarchar40
48DOUI_ELEM_ALVDBOS Cockpit: Screen Element Extensions for ALV Layout2ENV_IDDBOSC-CR: Generated ID (4)nvarchar40
49DOUI_ELEM_PROPDBOS Cockpit: Screen Element Properties2ENV_IDDBOSC-CR: Generated ID (4)nvarchar40
50DOUI_ELEM_SORTDBOSC-CDL-UI: ALV Sort Field2ENV_IDDBOSC-CR: Generated ID (4)nvarchar40
51DOUI_ELEM_VALUEDBOS Cockpit: Screen Element Values2ENV_IDDBOSC-CR: Generated ID (4)nvarchar40
52DOUI_FLOORPLANDBOS Cockpit: UI Data Model - Floorplan2ENV_IDDBOSC-CR: Generated ID (4)nvarchar40
53DOUI_FP_SLOTDBOS Cockpit: UI Data Model - Floorplan2ENV_IDDBOSC-CR: Generated ID (4)nvarchar40
54DOUI_ICONDBOS Cockpit: UI Data Model - Icons2ENV_IDDBOSC-CR: Generated ID (4)nvarchar40
55DOUI_MAP_FIELDDBOS Cockpit: Mapping Between UI and Request2ENV_IDDBOSC-CR: Generated ID (4)nvarchar40
56DOUI_MAP_KEYVALDBOS Cockpit: Mapping Between UI and Request2ENV_IDDBOSC-CR: Generated ID (4)nvarchar40
57DOUI_MAP_RQSTDBOS Cockpit: Mapping Between UI and Request2ENV_IDDBOSC-CR: Generated ID (4)nvarchar40
58DOUI_MAP_UI_ELEMDBOS Cockpit: Mapping Between UI Element from Diff.Screens2ENV_IDDBOSC-CR: Generated ID (4)nvarchar40
59DOUI_NAV_CONTEXTDBOSC: Navigation Request Context2ENV_IDDBOSC-CR: Generated ID (4)nvarchar40
60DOUI_NAV_LINKDBOSC: Navigation Request Details2ENV_IDDBOSC-CR: Generated ID (4)nvarchar40
61DOUI_NAV_REQUESTDBOS Cockpit: Navigation Request2ENV_IDDBOSC-CR: Generated ID (4)nvarchar40
62DOUI_SCREENDBOS Cockpit: UI Data Model - Basic Screen Properties2ENV_IDDBOSC-CR: Generated ID (4)nvarchar40
63DOUI_VALIDITYDBOS Cockpit: UI Data Model - Basic Screen Properties2ENV_IDDBOSC-CR: Generated ID (4)nvarchar40