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  | OBJCAT

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/BOBF/OBM_BOBOPF Configuration: Business Objects8OBJCATBusiness Object Categorynvarchar10
2/BOBF/OBM_OBJBOPF Configuration: Version17OBJCATBusiness Object Categorynvarchar10
TOPBasic Data
3VIBDBUBuilding71OBJCATBuilding Category Codenvarchar40
TOPBasic Data and Tools
4EHSBC_ST02EHS-BAS: System Status Profiles1OBJCATObject Typenvarchar20
5EHSBC_ST03EHS-BAS: Illegal Transitions to the System Status Profiles1OBJCATObject Typenvarchar20
6EHSBC_ST04EHS-BAS: Insert Transition for User Status in System Status1OBJCATObject Typenvarchar20
TOPClaims Management
7ICLCLAIMAClaim-Claim Object Assignment6OBJCATClaims Management Object Categorynvarchar20
8ICSCLAIMAClaim - Claim Subobject Assignment6OBJCATClaims Management Object Categorynvarchar20
9TICL013Claims Management Subobject Category2OBJCATClaims Management Object Categorynvarchar20
10TICL013TClaims Management Subobject Category Text3OBJCATClaims Management Object Categorynvarchar20
11TICL035Claims Management Object Category2OBJCATClaims Management Object Categorynvarchar20
12TICL035TClaims Management Object Category - Text Table3OBJCATClaims Management Object Categorynvarchar20
13TICL106Assignment Data Set - Claim Subobject Category4OBJCATClaims Management Object Categorynvarchar20
TOPControl Plan
14QPCPC_OBJCATObject Categories2OBJCATObject Categorynvarchar30
15QPCPC_OBJCATTObject Categories - Text Table3OBJCATObject Categorynvarchar30
16QPCPC_OBJTYPECustomizing Table for Object Type4OBJCATObject Categorynvarchar30
TOPHospital Structure
17HRP6080Table for Infotype HC Identification19OBJCATObject Category of Building Units and Organizational Unitsnvarchar20
18NOM_MAP_DATAMapping Table for OUs and Institutions3OBJCATObject Category of Building Units and Organizational Unitsnvarchar20
TOPIndustrial Hygiene and Safety
19CCIHC_IAOBJEHS: Object Types in Industrial Hygiene and Safety2OBJCATObject Typenvarchar30
20CCIHC_IHAWMEHS: Object Type - Object Subtype - Phrase Set Assignment2OBJCATObject Typenvarchar30
21CCIHC_IHOBJEHS: Value Assignment Type - Object Type Assignment3OBJCATObject Typenvarchar30
22CCIHC_IHTABEHS: Tabs in Industrial Hygiene and Safety2OBJCATObject Typenvarchar30
23CCIHC_IHTABNAMEHS: Tabs in IHS - Language-Dependent Description3OBJCATObject Typenvarchar30
24CCIHC_IHTYPEEHS: Object Type - Object Subtype Assignment3OBJCATObject Typenvarchar30
25CCIHC_IHTYPE1EHS: Object Type - Object Subtype Assignment2OBJCATObject Typenvarchar30
26CCIHC_IPTYPEOBJEHS: Exclusion of Person's Role for Object Type3OBJCATObject Typenvarchar30
27CCIHC_OBJEHS: Object Types for Industrial Hygiene and Safety1OBJCATObject Typenvarchar30
28CCIHC_OBJNAMEHS: Description for the Object Types2OBJCATObject Typenvarchar30
29CCIHC_OBJTYPEEHS: Object Type - Object Subtype2OBJCATObject Typenvarchar30
30CCIHC_TCG41EHS: User-Defined Text Type - Object Type Assignment3OBJCATObject Typenvarchar30
TOPLegal Case Management for ILM
31LHM_LEGAL_HOLDSOBSOLETE4OBJCATObject Categorynvarchar50
TOPMaintenance Notifications
32QNAOC_NTYPELinkage of Notification Types to Object Categories3OBJCATObject Category for an Assigned Objectnvarchar30
33QNAOC_OBJCATObject categories2OBJCATObject Category for an Assigned Objectnvarchar30
34QNAOC_OBJCATTObject Categories - Text Table3OBJCATObject Category for an Assigned Objectnvarchar30
35QNAOD_AOBJECTAssigned Objects for Notification Item6OBJCATObject Category for an Assigned Objectnvarchar30
TOPOccupational Health
36T7EHS00_TCG41EHS: User-Defined Text Type - Object Type Assignment3OBJCATDMS Object in Occupational Healthnvarchar20
TOPPayroll General Parts
37DSYS_CUSTHRDSYS: Storage for Customer Documentation7OBJCATFlay - object was entered in TADIRnvarchar10
38DSYS_STDHRDSYS: Storage for SAP standard documentation7OBJCATFlay - object was entered in TADIRnvarchar10
TOPPostprocessing Office
39/SAPPO/BOBJ_BPAssigning Methods to Object Type Based on Component/Process4OBJCATObject Categorynvarchar10
40/SAPPO/BOBJ_BP_TObject Type: Text5OBJCATObject Categorynvarchar10
41/SAPPO/F_ASGAssign Functions to Methods3OBJCATObject Categorynvarchar10
42/SAPPO/LGSYS_ASAssignment of Destinations4OBJCATObject Categorynvarchar10
43/SAPPO/OBJECTObject Types3OBJCATObject Categorynvarchar10
44/SAPPO/OBJECT_TObject Type: Text4OBJCATObject Categorynvarchar10
45/SAPPO/OBJ_ASGAssign Properties to Object Types3OBJCATObject Categorynvarchar10
46/SAPPO/OBJ_BORAssignment of Methods to Object Types for each Component3OBJCATObject Categorynvarchar10
47/SAPPO/OBJ_BOR_TText for Assignment of Methods to Object Type per Component4OBJCATObject Categorynvarchar10
48/SAPPO/OBJ_REDIRObject Types: Rerouting to Other Components3OBJCATObject Categorynvarchar10
49/SAPPO/ORDER_OBJRelated Objects for Postprocessing Order4OBJCATObject Categorynvarchar10
50/SAPPO/SCRN_ASGTab Pages - Object Area3OBJCATObject Categorynvarchar10
51/SAPPO/SOBJ_BORTText: SAP Methods for each Component3OBJCATObject Categorynvarchar10
52/SAPPO/SSCRN_ASSAP Tab Pages in Object Area2OBJCATObject Categorynvarchar10
53/SAPPO/SVALIDOTObject Types Permitted by SAP4OBJCATObject Categorynvarchar10
54/SAPPO/S_BOBJBPTText of SAP Methods Based on Component/Process4OBJCATObject Categorynvarchar10
55/SAPPO/S_BOBJ_BPSAP Methods Based on Component/Process3OBJCATObject Categorynvarchar10
56/SAPPO/S_OBJECTSAP Object Types2OBJCATObject Categorynvarchar10
57/SAPPO/S_OBJECTTText: SAP Object Types3OBJCATObject Categorynvarchar10
58/SAPPO/S_OBJ_BORSAP Methods for each Component2OBJCATObject Categorynvarchar10
59/SAPPO/VALID_OTValid Object Types5OBJCATObject Categorynvarchar10
TOPResourcen Management
60FRMLC15RMS-FRM: Control Table for Formula Status3OBJCATObject Typenvarchar20
TOPRuntime
61SWFGPGENOBJNUMGP Generation Number Assignment1OBJCATGP: Category of Generated Objectsnvarchar10
TOPSchedule Manager
62KPEP_WL_MWorklist in the Schedule Manager4OBJCATObject Type in the Worklist of the Schedule Managernvarchar100
63KPEP_WL_ROLESAssignment of Role to Object Type1OBJCATObject Type in the Worklist of the Schedule Managernvarchar100