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

67 columns | Print definition?ERP 6.0  | OBJECT_CATEGORY

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1LRM_T_OC_OGObject Groups2OBJECT_CATEGORYObject Categorynvarchar100
2LRM_T_OC_OG_TObject Groups - Description3OBJECT_CATEGORYObject Categorynvarchar100
3LRM_T_OC_RGRule Groups2OBJECT_CATEGORYObject Categorynvarchar100
4LRM_T_OC_RG_FRule Groups - Fields2OBJECT_CATEGORYObject Categorynvarchar100
5LRM_T_OC_RG_TRule Groups - Description3OBJECT_CATEGORYObject Categorynvarchar100
6LRM_T_OT_CILM Objects - Customer-Specific Settings2OBJECT_CATEGORYObject Categorynvarchar100
7N1TPI_ELINKAssignment of Object to External Key3OBJECT_CATEGORYObject Categorynvarchar20
8N1TPI_HISTORYManagement Message Date for External Key and Object Type4OBJECT_CATEGORYObject Categorynvarchar20
TOPArchive Development Kit
9ADMI_FILE_RULESIRM Rules Applied for Archive Files2OBJECT_CATEGORYObject Categorynvarchar100
TOPGeneric Project Planning
10CGPL_OBJTYPESProject Planning Object Types3OBJECT_CATEGORYObject Categorynvarchar10
TOPHR Administrative Services
11POBJD_OBJECTSObjects run for process object5OBJECT_CATEGORYType of Object (PA, HRBAS, BOR, and so on)nvarchar320
TOPInformation Retention Manager
12IRM_T_EXIT_CUSTIRM: Specific Customizing1OBJECT_CATEGORYIRM: Object Categorynvarchar100
13IRM_T_EXIT_POLIRM: Dummy Table for Branching to Policy Maintenance1OBJECT_CATEGORYIRM: Object Categorynvarchar100
14IRM_T_OBJ_CATIRM: Object Categories1OBJECT_CATEGORYIRM: Object Categorynvarchar100
15IRM_T_OBJ_CAT_MFIRM: Object Categories - Mandatory Fields for Policies1OBJECT_CATEGORYIRM: Object Categorynvarchar100
16IRM_T_OBJ_CAT_TIRM: Descriptions of Object Categories2OBJECT_CATEGORYIRM: Object Categorynvarchar100
17IRM_T_OBJ_TYPEIRM: Object Types1OBJECT_CATEGORYIRM: Object Categorynvarchar100
18IRM_T_OBJ_TYPE_TIRM: Descriptions for Object Types2OBJECT_CATEGORYIRM: Object Categorynvarchar100
19IRM_T_OT_POL_CATIRM: Obj. Types - References (Policy-Spec. Specifications)1OBJECT_CATEGORYIRM: Object Categorynvarchar100
20IRM_T_OT_POL_FLDIRM: Allowed Fields for Policies of an Object Type1OBJECT_CATEGORYIRM: Object Categorynvarchar100
21IRM_T_OT_POL_STTIRM: permitted Start Times for Policies of an Object Type1OBJECT_CATEGORYIRM: Object Categorynvarchar100
22IWP_AREA_FAudit Area Fields3OBJECT_CATEGORYObject Categorynvarchar100
23IWP_AREA_SAudit Area Tables3OBJECT_CATEGORYObject Categorynvarchar100
24IWP_REPOS_FRetention Warehouse: Repository Fields2OBJECT_CATEGORYObject Categorynvarchar100
25IWP_REPOS_FTRetention Warehouse: Repository Field Description3OBJECT_CATEGORYObject Categorynvarchar100
26IWP_REPOS_OT_SRetention Warehouse Repository: Structures ILM Objects2OBJECT_CATEGORYObject Categorynvarchar100
27IWP_REPOS_SRetention Warehouse: Repository Structures2OBJECT_CATEGORYObject Categorynvarchar100
28IWP_REPOS_STRetention Warehouse: Repository Structure Description3OBJECT_CATEGORYObject Categorynvarchar100
29LRM_BS_RST_CONDSIRM: Conditions for Business Suite and Residence Times2OBJECT_CATEGORYObject Categorynvarchar100
30LRM_BS_RST_RULESIRM: Rules for Business Suite and Residence Times2OBJECT_CATEGORYObject Categorynvarchar100
31LRM_BS_RTP_CONDSIRM: Conditions for Business Suite and Retention Periods2OBJECT_CATEGORYObject Categorynvarchar100
32LRM_BS_RTP_RULESIRM: Rules for Business Suite and Retention Periods2OBJECT_CATEGORYObject Categorynvarchar100
33LRM_PD_RTP_CONDSIRM: Conditions for Retention Rules for Paper Documents2OBJECT_CATEGORYObject Categorynvarchar100
34LRM_PD_RTP_RULESIRM: Rules for Retention of Paper Documents2OBJECT_CATEGORYObject Categorynvarchar100
TOPIRM Run Time
35LRM_RE_NRIRM: Number Assignment for Rules2OBJECT_CATEGORYObject Categorynvarchar100
36LRM_RE_RES_STRUCRegistration of Rule Structure for OC and PC1OBJECT_CATEGORYObject Categorynvarchar100
37LRM_T_EXIT_CUSTDummy Table for Jump to Object Category Spec. Customizing1OBJECT_CATEGORYObject Categorynvarchar100
38LRM_T_EXIT_POLDummy Table for Jump to Policy Maintenance2OBJECT_CATEGORYObject Categorynvarchar100
39LRM_T_OCObject Categories1OBJECT_CATEGORYObject Categorynvarchar100
40LRM_T_OC_MFMandatory Condition Fields for Policies1OBJECT_CATEGORYObject Categorynvarchar100
41LRM_T_OC_MF_TMandatory Condition Fields of Policies - Description2OBJECT_CATEGORYObject Categorynvarchar100
42LRM_T_OC_PCPolicy Category for Result Fields of Object Category1OBJECT_CATEGORYObject Categorynvarchar100
43LRM_T_OC_RFResult Fields of Policies1OBJECT_CATEGORYObject Categorynvarchar100
44LRM_T_OC_RF_TResult Fields of Policies - Description2OBJECT_CATEGORYObject Categorynvarchar100
45LRM_T_OC_SFStandard Condition Fields for Policies1OBJECT_CATEGORYObject Categorynvarchar100
46LRM_T_OC_SF_TStandard Condition Fields of Policies - Descriptions2OBJECT_CATEGORYObject Categorynvarchar100
47LRM_T_OC_TDescriptions of Object Categories2OBJECT_CATEGORYObject Categorynvarchar100
48LRM_T_OTILM Objects1OBJECT_CATEGORYObject Categorynvarchar100
49LRM_T_OT_FLDAvailable Condition Fields for Policies1OBJECT_CATEGORYObject Categorynvarchar100
50LRM_T_OT_FLD_TAvailable Condition Fields of Policies - Description2OBJECT_CATEGORYObject Categorynvarchar100
51LRM_T_OT_PCPolicy Categories Available for Object Types1OBJECT_CATEGORYObject Categorynvarchar100
52LRM_T_OT_PC_STATAvailable Policy Categories for Object Type - Status1OBJECT_CATEGORYObject Categorynvarchar100
53LRM_T_OT_POL_FLDSelected Fields in Policy2OBJECT_CATEGORYObject Categorynvarchar100
54LRM_T_OT_POL_ORIPolicy (Origin)2OBJECT_CATEGORYObject Categorynvarchar100
55LRM_T_OT_PTAvailable Policy Types (Available Audit Areas)2OBJECT_CATEGORYObject Categorynvarchar100
56LRM_T_OT_SFAvailable Standard Condition Fields for Object Categories1OBJECT_CATEGORYObject Categorynvarchar100
57LRM_T_OT_STTAvailable Reference Times for Start Time Determination1OBJECT_CATEGORYObject Categorynvarchar100
58LRM_T_OT_STT_TOAvailable Time Offsets for Start Time Determination1OBJECT_CATEGORYObject Categorynvarchar100
59LRM_T_OT_TILM Objects - Descriptions2OBJECT_CATEGORYObject Categorynvarchar100
60LRM_T_RE_CONSwitch for Rule Engine1OBJECT_CATEGORYObject Categorynvarchar100
61LRM_T_SIMIRM Simulator1OBJECT_CATEGORYObject Categorynvarchar100
TOPLegal Case Management for ILM
62SLCM_OBJ_CATILM: Legal Case Management - Supported Object Categories1OBJECT_CATEGORYObject Categorynvarchar50
TOPRetention Warehouse
63IWP_REPOS_BWAvailable Tables for BW2OBJECT_CATEGORYObject Categorynvarchar100
64IWP_REPOS_BW_CAvailable Tables for BW - Customer adoptions2OBJECT_CATEGORYObject Categorynvarchar100
65IWP_WPP_FFields of an Audit Package Template3OBJECT_CATEGORYObject Categorynvarchar100
66IWP_WPP_SStructures of an Audit Package Template3OBJECT_CATEGORYObject Categorynvarchar100
TOPSAP Records Management
67SRMSTATUSPROFSRM: Status Profile4OBJECT_CATEGORYObject Type Categorynvarchar20