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
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7OPCH386A/P Invoice
8OVTG52Tax Definition
9OPOR386Purchase Order
10JDT1124Journal Entry - Rows

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OVPM154Outgoing Payments
5OIVL77Whse Journal
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

39 columns | Print definition?ERP 6.0  | BENTYPE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/GSINS/INH_B2E_CBenefit Type to Wage Type for External Transfers3BENTYPEBenefit Typenvarchar100
2/GSINS/INH_B2W_CBenefit Type to Wage Type for Payments3BENTYPEBenefit Typenvarchar100
3/GSINS/INH_DUMMYDummy Table for External Deductions9BENTYPEBenefit Typenvarchar100
4/GSINS/INH_EXTDEExternal Transfers (in HCM infotype 0011)8BENTYPEBenefit Typenvarchar100
TOPClaims Management
5ICLCCEVPAYClaim Bundle - Payment Sum4BENTYPEBenefit Typenvarchar100
6ICLDRGITEMDRG Item10BENTYPEBenefit Typenvarchar100
7ICLITEMClaim Item13BENTYPEBenefit Typenvarchar100
8ICLPAYIClaim Payment Item13BENTYPEBenefit Typenvarchar100
9ICLPOLBFBenefit Types in Policy Snapshot6BENTYPEBenefit Typenvarchar100
10ICLPOLLLimit and Deductible in Policy Snapshot6BENTYPEBenefit Typenvarchar100
11ICLPOLSSums Insured and Calculations in Policy Snapshot6BENTYPEBenefit Typenvarchar100
12ICLSERVCATFS-CM: Benefits/Services/Fees Catalogs23BENTYPEBenefit Typenvarchar100
13ICL_CA_BENTPGRPAssignment of Benefit Types to Benefit Type Groups2BENTYPEBenefit Typenvarchar100
14ICL_CBENPRWAIVMaintenance: Premium Exemption for Benefit Type2BENTYPEBenefit Typenvarchar100
15ICL_CBENTYPXMaintenance: Benefit Type Attributes3BENTYPEBenefit Typenvarchar100
16ICL_CPRBENTYPMaintenance: Certain Benefit Types2BENTYPEBenefit Type Premium Arrearsnvarchar100
17ICL_CPRCBENTYPMaintenance: Benefit Type for Premium Credit2BENTYPEBenefit Typenvarchar100
18ICL_CTAXBENTYPMaintenance: Assignment of Tax Type to Benefit Type2BENTYPEBenefit Typenvarchar100
19ICL_TAXBENTYPMaintenance: Benefit Type for Tax2BENTYPEBenefit Typenvarchar100
20ICSCCEVPAYClaim Bundle - Payment Sum4BENTYPEBenefit Typenvarchar100
21ICSDRGITEMDRG Item10BENTYPEBenefit Typenvarchar100
22ICSITEMClaim Item13BENTYPEBenefit Typenvarchar100
23ICSPAYIPayment Item13BENTYPEBenefit Typenvarchar100
24ICSPOLBFBenefit Types in Policy Snapshot (Shadow Table)6BENTYPEBenefit Typenvarchar100
25ICSPOLLLimit and Deductible in Policy Snapshot6BENTYPEBenefit Typenvarchar100
26ICSPOLSSums Insured and Calculations in Policy Snapshot6BENTYPEBenefit Typenvarchar100
27TICL055Benefit Type2BENTYPEBenefit Typenvarchar100
28TICL055TBenefit Type Text3BENTYPEBenefit Typenvarchar100
29TICL056Internal Claim Type: Permitted Benefit Type6BENTYPEBenefit Typenvarchar100
30TICL057Internal Claim Type: Determination of Payment Reason Group6BENTYPEBenefit Typenvarchar100
31TICL076Internal Claim Type: Permitted Object Type6BENTYPEBenefit Typenvarchar100
32TICL083Internal Claim Type: Limit and Deductible6BENTYPEBenefit Typenvarchar100
33TICL100Internal Claim Type - Permitted Coverage Type7BENTYPEBenefit Type for Control of Permitted Benefit Typesnvarchar100
34TICL162Benefit Type Tree: Permitted Benefit Type5BENTYPEBenefit Typenvarchar100
35TICL163Benefit Type Tree: Limit and Deductible5BENTYPEBenefit Typenvarchar100
36TICL164Benefit Type Tree: Permitted Object Type5BENTYPEBenefit Typenvarchar100
37TICL165Benefit Type Tree: Definition of Payment Reason Group5BENTYPEBenefit Typenvarchar100
38TICL166Dependent Benefit Types4BENTYPEBenefit Typenvarchar100
39TICL167Benefit Type Tree: Sum Insured and Calculation Rules5BENTYPEBenefit Typenvarchar100