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

47 columns | Print definition?ERP 6.0  | SUBCLTYPE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/GSINS/INH_CPHRRClaim Payee and HCM Person Relation11SUBCLTYPESubclaim Typenvarchar40
2ICL_CPROCDOCInternal Claim Type: Manual Claim Document per CIG Category5SUBCLTYPESubclaim Typenvarchar40
3TICL600Mapping: Condition Fields for Rule Variant3SUBCLTYPESubclaim Typenvarchar40
TOPClaims Management
4ICLCLAIMBException Table Payment Amount Authorizations5SUBCLTYPESubclaim Typenvarchar40
5ICLINDRESIClaim-Independent Reserve20SUBCLTYPESubclaim Typenvarchar40
6ICLSUBCLSubclaim19SUBCLTYPESubclaim Typenvarchar40
7ICL_CBENTPFINDBenefit Type Determination3SUBCLTYPESubclaim Typenvarchar40
8ICL_CNOTE_CTYPEInternal Claim Type: Permitted Communication Type5SUBCLTYPESubclaim Typenvarchar40
9ICL_CNOTE_TEMPL1Internal Claim Type: Permitted Text Templates5SUBCLTYPESubclaim Typenvarchar40
10ICL_CNOTE_TYPEInternal Claim Type: Permitted Topic of Claim Note5SUBCLTYPESubclaim Typenvarchar40
11ICL_CRBPCLTYPERBP: Assignment of Profile to Claim Type and Subclaim Type3SUBCLTYPESubclaim Typenvarchar40
12ICL_IBNR_RESULTIBNR Reserves33SUBCLTYPESubclaim Typenvarchar40
13ICSCLAIMBException Table Payment Amount Authorizations5SUBCLTYPESubclaim Typenvarchar40
14ICSSUBCLSubclaim19SUBCLTYPESubclaim Typenvarchar40
15TICL004Subclaim Type2SUBCLTYPESubclaim Typenvarchar40
16TICL004TSubclaim Type Text3SUBCLTYPESubclaim Typenvarchar40
17TICL005Internal Claim Type: Permitted Subclaim Type5SUBCLTYPESubclaim Typenvarchar40
18TICL027Internal Claim Type: Permitted Subclaim Complexity5SUBCLTYPESubclaim Typenvarchar40
19TICL043Internal Claim Type: Permitted Claim Item Rejection Reason5SUBCLTYPESubclaim Typenvarchar40
20TICL045Internal Claim Type: Permitted Manual Task/Log Entry5SUBCLTYPESubclaim Typenvarchar40
21TICL046Internal Claim Type: Permitted Manual Claim Document5SUBCLTYPESubclaim Typenvarchar40
22TICL047Internal Claim Type: Permitted Claim Closure Reason5SUBCLTYPESubclaim Typenvarchar40
23TICL048Internal Claim Type: Method of Settlement5SUBCLTYPESubclaim Typenvarchar40
24TICL049Internal Claim Type: Permitted Damage Category5SUBCLTYPESubclaim Typenvarchar40
25TICL050Internal Claim Type: Permitted Damage Descriptor5SUBCLTYPESubclaim Typenvarchar40
26TICL052Internal Claim Type: Permitted Document and Other Categories5SUBCLTYPESubclaim Typenvarchar40
27TICL053Internal Claim Type: Permitted Reserve Type5SUBCLTYPESubclaim Typenvarchar40
28TICL054Claim Bundle Type - Claim Type - Assignment4SUBCLTYPESubclaim Type of Subclaims to be Includednvarchar40
29TICL056Internal Claim Type: Permitted Benefit Type5SUBCLTYPESubclaim Typenvarchar40
30TICL057Internal Claim Type: Determination of Payment Reason Group5SUBCLTYPESubclaim Typenvarchar40
31TICL058Internal Claim Type: Permitted Manual Coverage Referral5SUBCLTYPESubclaim Typenvarchar40
32TICL064Subclaim-Screen Sequence Determination5SUBCLTYPESubclaim Typenvarchar40
33TICL076Internal Claim Type: Permitted Object Type5SUBCLTYPESubclaim Typenvarchar40
34TICL083Internal Claim Type: Limit and Deductible5SUBCLTYPESubclaim Typenvarchar40
35TICL084Internal Claim Type: Permitted Reason for Creating ClmItmGp5SUBCLTYPESubclaim Typenvarchar40
36TICL100Internal Claim Type - Permitted Coverage Type5SUBCLTYPESubclaim Typenvarchar40
37TICL110Amount Authorizations for Payments/Reserves5SUBCLTYPESubclaim Typenvarchar40
38TICL110_RESTYPAmount Authorizations Reserves (per Reserve Type)5SUBCLTYPESubclaim Typenvarchar40
39TICL142Permitted Claim Item Grouping Category5SUBCLTYPESubclaim Typenvarchar40
40TICL143Permitted Types of Claim Item Grouping Category5SUBCLTYPESubclaim Typenvarchar40
41TICL184Internal Claim Type: Permitted Specification of Reason5SUBCLTYPESubclaim Typenvarchar40
42TICL187Internal Claim Type: Permitted Recovery/Subro Indicator5SUBCLTYPESubclaim Typenvarchar40
43TICL188Internal Claim Type: Permitted Accident Indicator5SUBCLTYPESubclaim Typenvarchar40
44TICL189FS-CM Subclaim Type: Permitted Benef./Services/Fees Catalogs5SUBCLTYPESubclaim Typenvarchar40
45TICL191FS-CM Permitted Document Types for Claim Type/Subclaim Type5SUBCLTYPESubclaim Typenvarchar40
46TICL371Internal Claim Type: Permitted Diagnosis Catalogs5SUBCLTYPESubclaim Typenvarchar40
TOPFinancial Services Localization
47/GSINS/DMG_TYPESDamage types2SUBCLTYPESubclaim Typenvarchar40