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

39 columns | Print definition?ERP 6.0  | POLICY_CATEGORY

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1LRM_T_OC_OGObject Groups3POLICY_CATEGORYPolicy Categorynvarchar30
2LRM_T_OC_OG_TObject Groups - Description4POLICY_CATEGORYPolicy Categorynvarchar30
3LRM_T_OC_RGRule Groups3POLICY_CATEGORYPolicy Categorynvarchar30
4LRM_T_OC_RG_FRule Groups - Fields3POLICY_CATEGORYPolicy Categorynvarchar30
5LRM_T_OC_RG_TRule Groups - Description4POLICY_CATEGORYPolicy Categorynvarchar30
TOPArchive Development Kit
6ADMI_FILE_RULESIRM Rules Applied for Archive Files4POLICY_CATEGORYPolicy Categorynvarchar30
TOPInformation Retention Manager
7IRM_T_EXIT_POLIRM: Dummy Table for Branching to Policy Maintenance3POLICY_CATEGORYIRM: Policy Categorynvarchar30
8IRM_T_OT_POL_CATIRM: Obj. Types - References (Policy-Spec. Specifications)3POLICY_CATEGORYIRM: Policy Categorynvarchar30
9IRM_T_POL_CATIRM: Policy Categories1POLICY_CATEGORYIRM: Policy Categorynvarchar30
10IRM_T_POL_CAT_TIRM: Descriptions for Policy Categories2POLICY_CATEGORYIRM: Policy Categorynvarchar30
11IRM_T_POL_TYPEIRM: Policy Types1POLICY_CATEGORYIRM: Policy Categorynvarchar30
12IRM_T_POL_TYPE_TIRM: Description for Rule Types2POLICY_CATEGORYIRM: Policy Categorynvarchar30
13LRM_BS_RST_CONDSIRM: Conditions for Business Suite and Residence Times4POLICY_CATEGORYPolicy Categorynvarchar30
14LRM_BS_RST_RULESIRM: Rules for Business Suite and Residence Times4POLICY_CATEGORYPolicy Categorynvarchar30
15LRM_BS_RTP_CONDSIRM: Conditions for Business Suite and Retention Periods4POLICY_CATEGORYPolicy Categorynvarchar30
16LRM_BS_RTP_RULESIRM: Rules for Business Suite and Retention Periods4POLICY_CATEGORYPolicy Categorynvarchar30
17LRM_PD_RTP_CONDSIRM: Conditions for Retention Rules for Paper Documents4POLICY_CATEGORYPolicy Categorynvarchar30
18LRM_PD_RTP_RULESIRM: Rules for Retention of Paper Documents4POLICY_CATEGORYPolicy Categorynvarchar30
TOPIRM Run Time
19LRM_RE_NRIRM: Number Assignment for Rules4POLICY_CATEGORYPolicy Categorynvarchar30
20LRM_RE_RES_STRUCRegistration of Rule Structure for OC and PC2POLICY_CATEGORYPolicy Categorynvarchar30
21LRM_T_EXIT_POLDummy Table for Jump to Policy Maintenance4POLICY_CATEGORYPolicy Categorynvarchar30
22LRM_T_OC_PCPolicy Category for Result Fields of Object Category2POLICY_CATEGORYPolicy Categorynvarchar30
23LRM_T_OC_RFResult Fields of Policies2POLICY_CATEGORYPolicy Categorynvarchar30
24LRM_T_OC_RF_TResult Fields of Policies - Description3POLICY_CATEGORYPolicy Categorynvarchar30
25LRM_T_OT_PCPolicy Categories Available for Object Types3POLICY_CATEGORYPolicy Categorynvarchar30
26LRM_T_OT_PC_STATAvailable Policy Categories for Object Type - Status3POLICY_CATEGORYPolicy Categorynvarchar30
27LRM_T_OT_POL_FLDSelected Fields in Policy4POLICY_CATEGORYPolicy Categorynvarchar30
28LRM_T_OT_POL_ORIPolicy (Origin)4POLICY_CATEGORYPolicy Categorynvarchar30
29LRM_T_OT_PTAvailable Policy Types (Available Audit Areas)4POLICY_CATEGORYPolicy Categorynvarchar30
30LRM_T_PCPolicy Categories1POLICY_CATEGORYPolicy Categorynvarchar30
31LRM_T_PC_TPolicy Categories - Descriptions2POLICY_CATEGORYPolicy Categorynvarchar30
32LRM_T_PTPolicy Types (Audit Areas)2POLICY_CATEGORYPolicy Categorynvarchar30
33LRM_T_PT_TPolicy Types - Descriptions3POLICY_CATEGORYPolicy Categorynvarchar30
34LRM_T_RE_CONSwitch for Rule Engine3POLICY_CATEGORYPolicy Categorynvarchar30
35LRM_T_SIMIRM Simulator3POLICY_CATEGORYPolicy Categorynvarchar30
TOPRetention Warehouse
36IWP_REPOS_BWAvailable Tables for BW4POLICY_CATEGORYPolicy Categorynvarchar30
37IWP_REPOS_BW_CAvailable Tables for BW - Customer adoptions4POLICY_CATEGORYPolicy Categorynvarchar30
38IWP_REPOS_BW_VAvailable Views for BW2POLICY_CATEGORYPolicy Categorynvarchar30
39IWP_REPOS_BW_V_CAvailable Views for BW - Customer adoption2POLICY_CATEGORYPolicy Categorynvarchar30