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

57 columns | Print definition?ERP 6.0  | SUBCLAIM

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/GSINS/INH_CPHRRClaim Payee and HCM Person Relation3SUBCLAIMSubclaimnvarchar30
2/GSINS/INH_DUMMYDummy Table for External Deductions3SUBCLAIMSubclaimnvarchar30
3/GSINS/INH_EXTDEExternal Transfers (in HCM infotype 0011)3SUBCLAIMSubclaimnvarchar30
TOPClaims Management
4ICLACTIVITYTasks in Claim4SUBCLAIMSubclaimnvarchar30
5ICLALDDAssign Archive Link Document to Claim Subobject4SUBCLAIMSubclaimnvarchar30
6ICLDOCDocument to be Sent in Claim4SUBCLAIMSubclaimnvarchar30
7ICLDOCALAttachments to Outbound Documents4SUBCLAIMSubclaimnvarchar30
8ICLDRGITEMDRG Item4SUBCLAIMSubclaimnvarchar30
9ICLEXPLANATIONProfile of Boolean Expressions of a BRF Run4SUBCLAIMSubclaimnvarchar30
10ICLEXPLANATIONCValues of Expressions per Claim -Explanation (Cluster Table5SUBCLAIMSubclaimnvarchar30
11ICLITEMClaim Item4SUBCLAIMSubclaimnvarchar30
12ICLITEMEVClaim Item Evaluation4SUBCLAIMSubclaimnvarchar30
13ICLITEMEVAClaim Item: Actual Cash Value Valuation4SUBCLAIMSubclaimnvarchar30
14ICLITEMEVBClaim Item: Daily Rate Valuation4SUBCLAIMSubclaimnvarchar30
15ICLNOTEClaim Note9SUBCLAIMSubclaimnvarchar30
16ICLPAYClaim Payment4SUBCLAIMSubclaim of Paymentnvarchar30
17ICLPAYEEAdditional Payee4SUBCLAIMSubclaim of Paymentnvarchar30
18ICLPAYIClaim Payment Item4SUBCLAIMSubclaim of Paymentnvarchar30
19ICLPROCUREClaim Item Groupings4SUBCLAIMSubclaim of Paymentnvarchar30
20ICLPROFILEProfile of True Predicates of a BRF Run4SUBCLAIMSubclaimnvarchar30
21ICLREFCoverage Referral in Claim4SUBCLAIMSubclaimnvarchar30
22ICLSALVSalvage8SUBCLAIMSubclaimnvarchar30
23ICLSALVISalvage Item9SUBCLAIMSubclaimnvarchar30
24ICLSUBCLSubclaim4SUBCLAIMSubclaimnvarchar30
25ICLSUBCLCLObsolete - Internal Claim Types, Contracts of Int.Claim Type4SUBCLAIMSubclaimnvarchar30
26ICLSUBCLFRAUDResult from Check System4SUBCLAIMSubclaimnvarchar30
27ICL_SUBROGITEMSubrogation/Recovery Item9SUBCLAIMSubclaimnvarchar30
28ICL_WCMPDFS-CM: Item Data Workers Compensation4SUBCLAIMSubclaimnvarchar30
29ICL_WCMPD_SCHFS-CM: Item Data Workers Compensation4SUBCLAIMSubclaimnvarchar30
30ICL_WCMPHWorkers Comp - Header Data4SUBCLAIMSubclaimnvarchar30
31ICSACTIVITYActivity in the Claim4SUBCLAIMSubclaimnvarchar30
32ICSALDDAssign Archive Link Document to Claim Subobject4SUBCLAIMSubclaimnvarchar30
33ICSDOCDocument in Claim4SUBCLAIMSubclaimnvarchar30
34ICSDOCALAttachments to Outbound Correspondence4SUBCLAIMSubclaimnvarchar30
35ICSDRGITEMDRG Item4SUBCLAIMSubclaimnvarchar30
36ICSITEMClaim Item4SUBCLAIMSubclaimnvarchar30
37ICSITEMEVClaim Item Evaluation4SUBCLAIMSubclaimnvarchar30
38ICSITEMEVAClaim Item: Actual Cash Value Valuation4SUBCLAIMSubclaimnvarchar30
39ICSITEMEVBClaim Item: Daily Rate Valuation4SUBCLAIMSubclaimnvarchar30
40ICSNOTENote9SUBCLAIMSubclaimnvarchar30
41ICSPAYPayment4SUBCLAIMSubclaim of Paymentnvarchar30
42ICSPAYEEAdditional Payee4SUBCLAIMSubclaim of Paymentnvarchar30
43ICSPAYIPayment Item4SUBCLAIMSubclaim of Paymentnvarchar30
44ICSPROCUREClaim Item Groupings4SUBCLAIMSubclaim of Paymentnvarchar30
45ICSREFCoverage Referral in Claim4SUBCLAIMSubclaimnvarchar30
46ICSSALVSalvage8SUBCLAIMSubclaimnvarchar30
47ICSSALVISalvage Item9SUBCLAIMSubclaimnvarchar30
48ICSSUBCLSubclaim4SUBCLAIMSubclaimnvarchar30
49ICSSUBCLCLInternal Claim Types, Contracts of Internal Claim Type4SUBCLAIMSubclaimnvarchar30
50ICSSUBCLFRAUDResult from Claims Check System4SUBCLAIMSubclaimnvarchar30
51ICS_SUBROGITEMSubrogation/Recovery Item: Shadow Table9SUBCLAIMSubclaimnvarchar30
52ICS_WCMPDFS-CM: Item Data Workers Compensation4SUBCLAIMSubclaimnvarchar30
53ICS_WCMPD_SCHFS-CM: Scheduled Workers Compensation4SUBCLAIMSubclaimnvarchar30
54ICS_WCMPHWorkers Comp - Header Data4SUBCLAIMSubclaimnvarchar30
TOPFinancial Services Localization
55/GSINS/DRIVEPARTDriver participant3SUBCLAIMSubclaimnvarchar30
56/GSINS/DRVPRTCPNDriver participant3SUBCLAIMSubclaimnvarchar30
57/GSINS/VEHCLDOCUVehicle documentation3SUBCLAIMSubclaimnvarchar30