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

Home | ERP 6.0  | ICSCLAIM
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
4OIVL77Whse Journal
5OVPM154Outgoing Payments
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction
Financial Services :: Claims Management
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0ICSCLAIM971ClaimClaims Management
SQL:  selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns

SELECT CLIENT, ACTIVE, CLAIM, CHANGETIME, CHANGEDBY, DELETED, CREATEDBY, CREATETIME, ACHANGEDBY, ACHANGETIME, EXCLAIMNOCAT, EXCLAIMNO, STATUS, STATUSCHG, STHANDLER, STNOCLAIM, STCLOSED, STATREASON, LOSSTYPE, CLAIMTYPE, CLTYPEG, CLTYPEV, LOSSEVENT, POLPROD, GENERAT, VERSION, LRENEWAL, POLICY, LOSSCAUSE, PERIL, DATELOSS, TIMELOSS, LTIMEZONE, XDATEESTIM, DATECHANGER, LOSSREPCOMPA, LOSSREPAGENT, LOSSADDRESS, XAUTHREP, XSENSITIVE, COMPLEX, JURISCOUNTRY, JURISREGION, ASSIGN_STATE, OWNERTYPE, OWNER, OWNERTYPE_GRP, OWNER_GRP, XCUMUL, VIEWFAULT, VIEWFAULTPH, TPNO, XTPKNOWN, COVERED, AUTHCLM, XCLAIMB, XNONOTIF, XRESERVE, BENTREE, BENTREEG, BENTREEV, WF_EXEC_TIME, WF_STATUS, XDUMMYCLAIM, VERCHNGUTC, OPENDATE, XWITHOUT_PRODUCT, MAX_ITEMNR, ASSIGN_GUID, SIF_STATUS, INVSTG_STATUS, EFFECTIVE_DT, LOSSREP_DT, LUMPSUMOPTION, STATPENSION, WITHDRAWAM, WITHDRAWCURR, WITHDRAWSEQ, ALTERNATEBEN, GENERATENOTIF, NOTIFREASON, AUTFOLLOWUP, FOLLOWUP_DT, PROCESSING_DT, STATUSOBJID, DUNNLEVEL, CLEARDATE, PREMBALANAM, PREMBALANAMCURR, WITHDRAWTYPE, REACT_DT, GENNOTIFTIME, BEN_CALC_FAIL, POLSYSTEM, ARCHIVE_STATUS, ARCHIVE_FLUD, REJECTION FROM ICSCLAIM
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1CLIENTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2ACTIVETable entry is active (A) or in suspense (S)char10CHAR(N' ')NoICL_ACTIVE Allow NULL? 
3CLAIMNumber of Claimnvarchar170CHAR(N' ')No*ICL_CLAIM Allow NULL? 
4CHANGETIMEChanged: Date + Timedecimal150DEC((0))NoICL_CHANGEUTC1
5CHANGEDBYChanged Bynvarchar120CHAR(N' ')YesUSR02ICL_CHANGEDBY Allow NULL? 
6DELETEDDatabase Line Status (Original, Changed, Deleted)char10CHAR(N' ')YesICL_RECSTATUS Allow NULL? 
7CREATEDBYCreated Bynvarchar120CHAR(N' ')YesUSR02ICL_CREATEDBY Allow NULL? 
8CREATETIMECreated: Date + Timedecimal150DEC((0))YesICL_CREATEUTC
9ACHANGEDBYWhole Claim Last Changed Bynvarchar120CHAR(N' ')YesUSR02ICL_ACHANGEDBY Allow NULL? 
10ACHANGETIMEWhole Claim Last Changed Atdecimal150DEC((0))YesICL_ACHANGETIME
11EXCLAIMNOCATExternal Number Categorychar10CHAR(N' ')YesICL_CLAIMNOCAT Allow NULL? 
12EXCLAIMNOExternal Numbernvarchar230CHAR(N' ')YesICL_CLAIMNO Allow NULL? 
13STATUSStatus of Claimnvarchar20CHAR(N' ')YesTICL140ICL_CLSTATUS Allow NULL? 
14STATUSCHGTime of Last Status Changedecimal150DEC((0))YesICL_STATUSCHG
15STHANDLER"Claim Handling" Process Activechar10CHAR(N' ')YesICL_STHANDLER Allow NULL? 
16STNOCLAIMNo Claim Madechar10CHAR(N' ')YesICL_STNOCLAIM Allow NULL? 
17STCLOSED"Close (Sub)Claim" Process Executedchar10CHAR(N' ')YesICL_STCLOSED Allow NULL? 
18STATREASONReason for Changing the Statusnvarchar20CHAR(N' ')Yes*ICL_FORMSET Allow NULL? 
19LOSSTYPEIncident Type of a Claimnvarchar40CHAR(N' ')YesTICL062ICL_LOSSTYPE Allow NULL? 
20CLAIMTYPEInternal Claim Typenvarchar40CHAR(N' ')YesTICL011ICL_CLTYPE Allow NULL? 
21CLTYPEGGeneration of Internal Claim Typenvarchar50NUMC(N'00000')YesTICL011ICL_CLTYPEG Allow NULL? 
22CLTYPEVInternal Claim Type Versionnvarchar50NUMC(N'00000')YesTICL003ICL_CLTYPEV Allow NULL? 
23LOSSEVENTCumulative Eventnvarchar170CHAR(N' ')YesICLCCEVENTICL_LOSSEVENT Allow NULL? 
24POLPRODPolicy Productnvarchar60CHAR(N' ')YesTICL320ICL_POLPROD Allow NULL? 
25GENERATPolicy Product Generationnvarchar50NUMC(N'00000')YesTICL320ICL_GENERAT Allow NULL? 
26VERSIONPolicy Product Versionnvarchar50NUMC(N'00000')YesTICL321ICL_POLPRODV Allow NULL? 
27LRENEWALLast Renewal of Contract Before Claim Date/Timedecimal150DEC((0))YesICL_LRENEWAL
28POLICYContract Numbernvarchar170CHAR(N' ')YesICL_POLICY Allow NULL? 
29LOSSCAUSECause of Loss/Claimnvarchar30CHAR(N' ')YesTICL009ICL_LOSSCAUSE Allow NULL? 
30PERILPerilnvarchar40CHAR(N' ')YesICL_PERIL Allow NULL? 
31DATELOSSDate of Loss/Claimnvarchar80DATS(N'00000000')YesICL_LOSSDATE Allow NULL? 
32TIMELOSSTime of Claim/Lossnvarchar60TIMS(N'000000')YesICL_LOSSTIME Allow NULL? 
33LTIMEZONETime Zone of Claim/Loss Eventnvarchar60CHAR(N' ')YesTTZZICL_LTIMEZONE Allow NULL? 
34XDATEESTIMDate Is Estimatechar10CHAR(N' ')YesICL_XLOSSDATE Allow NULL? 
35DATECHANGERReason for Changing Claim Datenvarchar20CHAR(N' ')YesTICL029ICL_DATECHANGER Allow NULL? 
36LOSSREPCOMPADate Claim Reported to Insurance Companynvarchar80DATS(N'00000000')YesICL_LOSSREPCOMPA Allow NULL? 
37LOSSREPAGENTDate on Which Claim Was Reported to Agentnvarchar80DATS(N'00000000')YesICL_LOSSREPAGENT Allow NULL? 
38LOSSADDRESSLoss Locationnvarchar100CHAR(N' ')YesADRCICL_LOSSADDRESS Allow NULL? 
39XAUTHREPClaim/Loss Reported to Authoritychar10CHAR(N' ')YesICL_XAUTHREP Allow NULL? 
40XSENSITIVESensitive Claim?char10CHAR(N' ')YesICL_CLAIMSENS Allow NULL? 
41COMPLEXComplexity of Claim/Subclaimchar10CHAR(N' ')YesTICL027ICL_COMPLEX Allow NULL? 
42JURISCOUNTRYJurisdiction Countrynvarchar30CHAR(N' ')YesT005ICL_JURICOUNTRY Allow NULL? 
43JURISREGIONJurisdiction Regionnvarchar30CHAR(N' ')YesT005SICL_JURISREGION Allow NULL? 
44ASSIGN_STATEAssignment Status of a Claim Subobjectnvarchar20CHAR(N' ')YesICL_ASSIGN_STATE Allow NULL? 
45OWNERTYPEObject Type of Claim Handlernvarchar20CHAR(N' ')YesT778OICL_OWNERTYPE Allow NULL? 
46OWNERID of Claim Handlernvarchar120CHAR(N' ')YesICL_CLAIMOWNER Allow NULL? 
47OWNERTYPE_GRPObject Type of Claim Handler Groupnvarchar20CHAR(N' ')Yes*ICL_OWNERTYPE2 Allow NULL? 
48OWNER_GRPClaim Handler Groupnvarchar120CHAR(N' ')YesICL_CLAIMOWNER2 Allow NULL? 
49XCUMULClaim Assigned to an Aggregatechar10CHAR(N' ')YesICL_XCUMUL Allow NULL? 
50VIEWFAULTFault of Policyholder from Point of View of Insurerchar10CHAR(N' ')YesTICL081ICL_VIEWFAULTI Allow NULL? 
51VIEWFAULTPHParty at Fault from Point of View of Policyholderchar10CHAR(N' ')YesTICL081ICL_VIEWFAULTPH Allow NULL? 
52TPNOThird Party Count (NOT USED)nvarchar20NUMC(N'00')YesICL_TPNO Allow NULL? 
53XTPKNOWNFlag: Third Party Known?char10CHAR(N' ')YesICL_TPKNOWN Allow NULL? 
54COVEREDIndication of Compensabilitychar10CHAR(N' ')YesICL_COVERED Allow NULL? 
55AUTHCLMAuthorization Group for Claims (VIP)nvarchar40CHAR(N' ')YesTICL113ICL_AUTHCLM Allow NULL? 
56XCLAIMBEntry in ICLCLAIMB Existschar10CHAR(N' ')YesICL_XCLAIMB Allow NULL? 
57XNONOTIFProcessing Not Possible in Notification Modechar10CHAR(N' ')YesICL_XNONOTIF Allow NULL? 
58XRESERVEAt Least One Reserve Exists in Claimchar10CHAR(N' ')YesICL_XRESERVE Allow NULL? 
59BENTREEBenefit Type Treenvarchar80CHAR(N' ')Yes*ICL_BENTREE Allow NULL? 
60BENTREEGGeneration of Benefit Type Treenvarchar50NUMC(N'00000')Yes*ICL_BENTREEG Allow NULL? 
61BENTREEVVersion of Benefit Type Treenvarchar50NUMC(N'00000')Yes*ICL_BENTREEV Allow NULL? 
62WF_EXEC_TIMEExecution Time Workflowdecimal150DEC((0))YesICL_WF_EXECUTION_TIME
63WF_STATUSWorkflow Statuschar10NUMC(N'0')YesICL_WF_STATUS Allow NULL? 
64XDUMMYCLAIMFlag: Dummy Claimchar10CHAR(N' ')YesICL_XDUMMYCLAIM Allow NULL? 
65VERCHNGUTCTime for Reading Versiondecimal150DEC((0))YesICL_VERCHNGUTC
66OPENDATEOpened Onnvarchar80DATS(N'00000000')YesICL_OPENDATE Allow NULL? 
67XWITHOUT_PRODUCTUse of Scenario Without Product Customizingchar10CHAR(N' ')YesICL_XWITHOUTPRODUCT_D Allow NULL? 
68MAX_ITEMNRCurrent Highest Claim Item Numbernvarchar40CHAR(N' ')Yes*ICL_SCLITEM_NR_MAX Allow NULL? 
69ASSIGN_GUIDUUID of Entry to be Linkednvarchar320CHAR(N' ')YesICL_ASSIGN_GUID Allow NULL? 
70SIF_STATUSStatus of Second Injury Fundchar10CHAR(N' ')YesICL_SIF_STATUS_D Allow NULL? 
71INVSTG_STATUSClaim Investigation Match Statuschar10CHAR(N' ')YesICL_INVSTG_MATCH_STATUS_D_PE Allow NULL? 
72EFFECTIVE_DTContract Validity Datenvarchar80DATS(N'00000000')YesICL_EFFECTIVE_DT_D Allow NULL? 
73LOSSREP_DTDate on Request for Insurance Benefitnvarchar80DATS(N'00000000')YesICL_LOSSREP_DT_D Allow NULL? 
74LUMPSUMOPTIONOption Exercisedchar10CHAR(N' ')YesICL_LUMPSUMOPTION_D Allow NULL? 
75STATPENSIONType of Statutory Pensionnvarchar30CHAR(N' ')Yes*ICL_STATPENSION_D Allow NULL? 
76WITHDRAWAMRequested Total Withdrawal Amountdecimal152CURR((0))YesICL_WITHDRAWAM_D
77WITHDRAWCURRCurrency of Withdrawal Amountnvarchar50CUKY(N' ')Yes*ICL_WITHDRAWCURR_D Allow NULL? 
78WITHDRAWSEQWithdrawal Sequencenvarchar30CHAR(N' ')Yes*ICL_WITHDRAWSEQ_D Allow NULL? 
79ALTERNATEBENDisplay Alternative Benefit Valueschar10CHAR(N' ')YesICL_ALTERNATEBEN_D Allow NULL? 
80GENERATENOTIFMake Special Risk Notificationchar10CHAR(N' ')YesICL_GENERATENOTIF_D Allow NULL? 
81NOTIFREASONReason for Special Risk Notificationnvarchar30CHAR(N' ')YesICL_NOTIFREASON_D Allow NULL? 
82AUTFOLLOWUPAutomatic Resubmissionchar10CHAR(N' ')YesICL_AUTFOLLOWUP_D Allow NULL? 
83FOLLOWUP_DTDate of Automatic Resubmissionnvarchar80DATS(N'00000000')YesICL_FOLLOWUP_DT_D Allow NULL? 
84PROCESSING_DTProcessing Onnvarchar80DATS(N'00000000')YesICL_PROCESSING_DT_D Allow NULL? 
85STATUSOBJIDObject numbernvarchar220CHAR(N' ')Yes*J_OBJNR Allow NULL? 
86DUNNLEVELDunning Statusnvarchar20CHAR(N' ')YesICL_DUNNLEVEL_D Allow NULL? 
87CLEARDATEPremium Paid Up Tonvarchar80DATS(N'00000000')YesICL_CLEARDATE_D Allow NULL? 
88PREMBALANAMPremium Balancedecimal152CURR((0))YesICL_PREMBALANAM_D
89PREMBALANAMCURRCurrency of Premium Paymentnvarchar50CUKY(N' ')Yes*ICL_PREMBALANAMCURR_D Allow NULL? 
90WITHDRAWTYPEWithdrawal Typenvarchar30CHAR(N' ')Yes*ICL_WITHDRAWTYPE_D Allow NULL? 
91REACT_DTDate of Occupational Disability/Perm.Incap.to Wk Reactivatnnvarchar80DATS(N'00000000')YesICL_REACT_DT_D Allow NULL? 
92GENNOTIFTIMESpecial Risk Message Submitted Ondecimal150DEC((0))YesICL_GENERATENOTIFTIME_D
93BEN_CALC_FAILTime of Last Incorrect Benefit Calculationdecimal150DEC((0))YesICL_BEN_CALC_FAIL_D
94POLSYSTEMTechnical Key of Policy Systemnvarchar80CHAR(N' ')YesICL_POLSYSTEM_D Allow NULL? 
95ARCHIVE_STATUSArchiving Statuschar10CHAR(N' ')YesTYP_ARCHIVE_STATUS Allow NULL? 
96ARCHIVE_FLUDResubmission Datenvarchar80DATS(N'00000000')YesTYP_ARCHIVE_FLUD Allow NULL? 
97REJECTIONRejection Reasonnvarchar20CHAR(N' ')YesTYP_REJECTION Allow NULL? 
NamePrimaryUniqueTypeColumns
ICSCLAIM~0YesYesCLUSTEREDCHANGETIME, CLAIM, ACTIVE, CLIENT

All references to SAP and SAP logo are trademarks of SAP AG in Germany, EU, USA and other territories.
No warranty is provided to data provided by this site. This website is not affiliated with, maintained, authorized, endorsed or sponsored by the SAP AG Company or any of its affiliates.
About :: Terms :: Privacy