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

70 columns | Print definition?ERP 6.0  | DOCM_CHANGED_AT

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1DOCM_BUILD_ORDERDBOSC-CM: Build Order7DOCM_CHANGED_ATDBOS Cockpit: ISO Timestamp (YYYYMMDDHHmmSS)nvarchar140
2DOCM_CONFIGDBOSC-CM: Configuration7DOCM_CHANGED_ATDBOS Cockpit: ISO Timestamp (YYYYMMDDHHmmSS)nvarchar140
3DOCRP_FLDBMPDBOS Cockpit: CRP: Source Field22DOCM_CHANGED_ATDBOS Cockpit: ISO Timestamp (YYYYMMDDHHmmSS)nvarchar140
4DOCRP_SOURCEDBOSC: CBR: CIM Data Source8DOCM_CHANGED_ATDBOS Cockpit: ISO Timestamp (YYYYMMDDHHmmSS)nvarchar140
5DOCRP_SRCBMPDBOSC: CBR: CIM Data Source12DOCM_CHANGED_ATDBOS Cockpit: ISO Timestamp (YYYYMMDDHHmmSS)nvarchar140
6DOCR_ENVDBOSC-CR: Environment12DOCM_CHANGED_ATDBOS Cockpit: ISO Timestamp (YYYYMMDDHHmmSS)nvarchar140
7DOCR_LONG_VALUEDBOSC-CR: Long value in pieces of 255 chars7DOCM_CHANGED_ATDBOS Cockpit: ISO Timestamp (YYYYMMDDHHmmSS)nvarchar140
8DODC_REVIEWDBOS-Docu: Text Review Table8DOCM_CHANGED_ATDBOS Cockpit: ISO Timestamp (YYYYMMDDHHmmSS)nvarchar140
9DODP_ASSOCDBOSC-DP: Association13DOCM_CHANGED_ATDBOS Cockpit: ISO Timestamp (YYYYMMDDHHmmSS)nvarchar140
10DODP_ASSOCNDBOSC-DP: Navigation Association14DOCM_CHANGED_ATDBOS Cockpit: ISO Timestamp (YYYYMMDDHHmmSS)nvarchar140
11DODP_ASSOCN_FLDDBOSC-DP: Navigation Association Fields7DOCM_CHANGED_ATDBOS Cockpit: ISO Timestamp (YYYYMMDDHHmmSS)nvarchar140
12DODP_ASSOCRDBOSC-DP: Referential Association14DOCM_CHANGED_ATDBOS Cockpit: ISO Timestamp (YYYYMMDDHHmmSS)nvarchar140
13DODP_ASSOCR_FLDDBOSC-DP: Referential Association Fields7DOCM_CHANGED_ATDBOS Cockpit: ISO Timestamp (YYYYMMDDHHmmSS)nvarchar140
14DODP_ASSOC_FIELDDBOSC-DP: Association From Field to Reference Field8DOCM_CHANGED_ATDBOS Cockpit: ISO Timestamp (YYYYMMDDHHmmSS)nvarchar140
15DODP_FIELDDBOSC-DP: Data Provider Field32DOCM_CHANGED_ATDBOS Cockpit: ISO Timestamp (YYYYMMDDHHmmSS)nvarchar140
16DODP_FIELD_VALUEDBOS-DP: Data Provider Field Value12DOCM_CHANGED_ATDBOS Cockpit: ISO Timestamp (YYYYMMDDHHmmSS)nvarchar140
17DODP_MAP_FIELDDBOSC-DP: Map Data Provider Filed to Data Source Field8DOCM_CHANGED_ATDBOS Cockpit: ISO Timestamp (YYYYMMDDHHmmSS)nvarchar140
18DODP_MAP_SOURCEDBOSC-DP: Map Data Provider to Data Source13DOCM_CHANGED_ATDBOS Cockpit: ISO Timestamp (YYYYMMDDHHmmSS)nvarchar140
19DODP_PROCESSORDBOSC-DP: Data Provider Processor11DOCM_CHANGED_ATDBOS Cockpit: ISO Timestamp (YYYYMMDDHHmmSS)nvarchar140
20DODP_PROVIDERDBOSC-DP: Data Providers22DOCM_CHANGED_ATDBOS Cockpit: ISO Timestamp (YYYYMMDDHHmmSS)nvarchar140
21DODP_SERVICEDBOSC-DP: Service8DOCM_CHANGED_ATDBOS Cockpit: ISO Timestamp (YYYYMMDDHHmmSS)nvarchar140
22DODR_DB_STMTDBOSC-DR: Direct SQL Request Statements12DOCM_CHANGED_ATDBOS Cockpit: ISO Timestamp (YYYYMMDDHHmmSS)nvarchar140
23DOOD_ENTITY_SETDBOSC-OD: OData Entity Type8DOCM_CHANGED_ATDBOS Cockpit: ISO Timestamp (YYYYMMDDHHmmSS)nvarchar140
24DOOD_ENTITY_TYPEDBOSC-OD: OData Entity Type8DOCM_CHANGED_ATDBOS Cockpit: ISO Timestamp (YYYYMMDDHHmmSS)nvarchar140
25DOOD_PROPERTYDBOSC-DP: Data Provider Field14DOCM_CHANGED_ATDBOS Cockpit: ISO Timestamp (YYYYMMDDHHmmSS)nvarchar140
26DOOD_SERVICEDBOSC-OD: Service7DOCM_CHANGED_ATDBOS Cockpit: ISO Timestamp (YYYYMMDDHHmmSS)nvarchar140
27DORAN_FIELDDBOSC-RAN: Data Source Field17DOCM_CHANGED_ATDBOS Cockpit: ISO Timestamp (YYYYMMDDHHmmSS)nvarchar140
28DORAN_SOURCEDBOSC-RAN: Request Processor for All - Native11DOCM_CHANGED_ATDBOS Cockpit: ISO Timestamp (YYYYMMDDHHmmSS)nvarchar140
29DORDS_ACCESSDBOSC-DRS: Request Process Database SQL Access10DOCM_CHANGED_ATDBOS Cockpit: ISO Timestamp (YYYYMMDDHHmmSS)nvarchar140
30DORDS_ANSIJOINDBOSC-RDS: Request Process Database SQL Virtual7DOCM_CHANGED_ATDBOS Cockpit: ISO Timestamp (YYYYMMDDHHmmSS)nvarchar140
31DORDS_FIELDDBOSC-RDS: Reques Process DB SQL Data Source Field25DOCM_CHANGED_ATDBOS Cockpit: ISO Timestamp (YYYYMMDDHHmmSS)nvarchar140
32DORDS_FUNCTIONDBOSC-DRS: Request Process Database SQL Function11DOCM_CHANGED_ATDBOS Cockpit: ISO Timestamp (YYYYMMDDHHmmSS)nvarchar140
33DORDS_INVIEWDBOSC-DRS: Request Process Database SQL Inlined View10DOCM_CHANGED_ATDBOS Cockpit: ISO Timestamp (YYYYMMDDHHmmSS)nvarchar140
34DORDS_JOIN_CONDDBOSC-DRS: Request Process Database SQL Join Condition15DOCM_CHANGED_ATDBOS Cockpit: ISO Timestamp (YYYYMMDDHHmmSS)nvarchar140
35DORDS_JOIN_EQDBOSC-RDS: Reques Process DB SQL Data Source Join Field EQ10DOCM_CHANGED_ATDBOS Cockpit: ISO Timestamp (YYYYMMDDHHmmSS)nvarchar140
36DORDS_JOIN_PARTDBOSC-DRS: Request Process Database SQL Join parts10DOCM_CHANGED_ATDBOS Cockpit: ISO Timestamp (YYYYMMDDHHmmSS)nvarchar140
37DORDS_OPTIONDBOSC-DRS: Request Processor Database Option13DOCM_CHANGED_ATDBOS Cockpit: ISO Timestamp (YYYYMMDDHHmmSS)nvarchar140
38DORDS_PARAMETERDBOSC-RDS: Request Process DB SQL Parameter24DOCM_CHANGED_ATDBOS Cockpit: ISO Timestamp (YYYYMMDDHHmmSS)nvarchar140
39DORDS_SETDBOSC-DRS: Request Process Database SQL Virtual8DOCM_CHANGED_ATDBOS Cockpit: ISO Timestamp (YYYYMMDDHHmmSS)nvarchar140
40DORDS_SET_EQDBOSC-RDS: Reques Process DB SQL Data Source Set Field EQ10DOCM_CHANGED_ATDBOS Cockpit: ISO Timestamp (YYYYMMDDHHmmSS)nvarchar140
41DORDS_SET_PARTDBOSC-DRS: Request Process Database SQL Set parts10DOCM_CHANGED_ATDBOS Cockpit: ISO Timestamp (YYYYMMDDHHmmSS)nvarchar140
42DORDS_SET_UNITEDBOSC-DRS: Request Process Database SQL Set combination11DOCM_CHANGED_ATDBOS Cockpit: ISO Timestamp (YYYYMMDDHHmmSS)nvarchar140
43DORDS_SOURCEDBOSC-RDS: Reques Processor DB SQL Data Source10DOCM_CHANGED_ATDBOS Cockpit: ISO Timestamp (YYYYMMDDHHmmSS)nvarchar140
44DORDS_TABLEDBOSC-DRS: Request Process Database SQL Table11DOCM_CHANGED_ATDBOS Cockpit: ISO Timestamp (YYYYMMDDHHmmSS)nvarchar140
45DORDS_VIRTUALDBOSC-DRS: Request Process Database SQL Virtual10DOCM_CHANGED_ATDBOS Cockpit: ISO Timestamp (YYYYMMDDHHmmSS)nvarchar140
46DORQ_FIELDDBOSC-RQ: Request Fields14DOCM_CHANGED_ATDBOS Cockpit: ISO Timestamp (YYYYMMDDHHmmSS)nvarchar140
47DORQ_OPTIONDBOSC-RQ: Request Options10DOCM_CHANGED_ATDBOS Cockpit: ISO Timestamp (YYYYMMDDHHmmSS)nvarchar140
48DORQ_PROPDBOSC-RQ: Request Properties8DOCM_CHANGED_ATDBOS Cockpit: ISO Timestamp (YYYYMMDDHHmmSS)nvarchar140
49DORQ_REQUESTDBOSC-RQ: Request13DOCM_CHANGED_ATDBOS Cockpit: ISO Timestamp (YYYYMMDDHHmmSS)nvarchar140
50DOUI5_RESOURCEDBOSC-UI-SAPUI5: Resource6DOCM_CHANGED_ATDBOS Cockpit: ISO Timestamp (YYYYMMDDHHmmSS)nvarchar140
51DOUI_DOMAINDBOSC-UI: UI Domains7DOCM_CHANGED_ATDBOS Cockpit: ISO Timestamp (YYYYMMDDHHmmSS)nvarchar140
52DOUI_DYNPROFIELDTo be Deleted9DOCM_CHANGED_ATDBOS Cockpit: ISO Timestamp (YYYYMMDDHHmmSS)nvarchar140
53DOUI_ELEMDBOS Cockpit: Screen Element42DOCM_CHANGED_ATDBOS Cockpit: ISO Timestamp (YYYYMMDDHHmmSS)nvarchar140
54DOUI_ELEM_ALVDBOS Cockpit: Screen Element Extensions for ALV Layout27DOCM_CHANGED_ATDBOS Cockpit: ISO Timestamp (YYYYMMDDHHmmSS)nvarchar140
55DOUI_ELEM_PROPDBOS Cockpit: Screen Element Properties8DOCM_CHANGED_ATDBOS Cockpit: ISO Timestamp (YYYYMMDDHHmmSS)nvarchar140
56DOUI_ELEM_SORTDBOSC-CDL-UI: ALV Sort Field8DOCM_CHANGED_ATDBOS Cockpit: ISO Timestamp (YYYYMMDDHHmmSS)nvarchar140
57DOUI_ELEM_VALUEDBOS Cockpit: Screen Element Values11DOCM_CHANGED_ATDBOS Cockpit: ISO Timestamp (YYYYMMDDHHmmSS)nvarchar140
58DOUI_FLOORPLANDBOS Cockpit: UI Data Model - Floorplan13DOCM_CHANGED_ATDBOS Cockpit: ISO Timestamp (YYYYMMDDHHmmSS)nvarchar140
59DOUI_FP_SLOTDBOS Cockpit: UI Data Model - Floorplan9DOCM_CHANGED_ATDBOS Cockpit: ISO Timestamp (YYYYMMDDHHmmSS)nvarchar140
60DOUI_ICONDBOS Cockpit: UI Data Model - Icons11DOCM_CHANGED_ATDBOS Cockpit: ISO Timestamp (YYYYMMDDHHmmSS)nvarchar140
61DOUI_MAP_FIELDDBOS Cockpit: Mapping Between UI and Request12DOCM_CHANGED_ATDBOS Cockpit: ISO Timestamp (YYYYMMDDHHmmSS)nvarchar140
62DOUI_MAP_KEYVALDBOS Cockpit: Mapping Between UI and Request11DOCM_CHANGED_ATDBOS Cockpit: ISO Timestamp (YYYYMMDDHHmmSS)nvarchar140
63DOUI_MAP_RQSTDBOS Cockpit: Mapping Between UI and Request9DOCM_CHANGED_ATDBOS Cockpit: ISO Timestamp (YYYYMMDDHHmmSS)nvarchar140
64DOUI_MAP_UI_ELEMDBOS Cockpit: Mapping Between UI Element from Diff.Screens9DOCM_CHANGED_ATDBOS Cockpit: ISO Timestamp (YYYYMMDDHHmmSS)nvarchar140
65DOUI_NAV_CONTEXTDBOSC: Navigation Request Context12DOCM_CHANGED_ATDBOS Cockpit: ISO Timestamp (YYYYMMDDHHmmSS)nvarchar140
66DOUI_NAV_LINKDBOSC: Navigation Request Details14DOCM_CHANGED_ATDBOS Cockpit: ISO Timestamp (YYYYMMDDHHmmSS)nvarchar140
67DOUI_NAV_REQUESTDBOS Cockpit: Navigation Request7DOCM_CHANGED_ATDBOS Cockpit: ISO Timestamp (YYYYMMDDHHmmSS)nvarchar140
68DOUI_SAPUI5_RSRCDBOSC-UI-SAPUI5: Resource6DOCM_CHANGED_ATDBOS Cockpit: ISO Timestamp (YYYYMMDDHHmmSS)nvarchar140
69DOUI_SCREENDBOS Cockpit: UI Data Model - Basic Screen Properties16DOCM_CHANGED_ATDBOS Cockpit: ISO Timestamp (YYYYMMDDHHmmSS)nvarchar140
70DOUI_VALIDITYDBOS Cockpit: UI Data Model - Basic Screen Properties8DOCM_CHANGED_ATDBOS Cockpit: ISO Timestamp (YYYYMMDDHHmmSS)nvarchar140