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  | ICLITEMAU
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.0ICLITEMAU782Damaged VehicleClaims Management
SQL:  selectupdate insert create

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

SELECT CLIENT, ACTIVE, CLAIM, DAMAGEDOBJ, CHANGETIME, CHANGEDBY, DELETED, PROPMAKE, PROPMODEL, MODELTY, VIN, PLATECOUNTRY, PLATEREGION, PLATENO, CONSTYEAR, FIRSTREG, CAPACITY, CAPUNIT, COLOR, GEAR, XTHIRDPARTY, LOCATION, INSPDATE, WHENSEEN, PURPTRIP, LEASING, XPERM, XDAM, XVEHICIT, XDRIVCIT, XPVENDOR, XPARKED, XPRE, DRIVABLE, MILEAGE, MILEAGEUNIT, TREADF, TREADR, TREADUNIT, PCV, PCVCURR, OWPHREL, XTOTDAMAGE, XSTOLEN, XRECOVERED, RECOVERDATE, MONTH_FROM, MONTH_TO, OWNERCHANGE, GENERALINSP, CURR, SALVVALUE, ESTACV, EVALDATE, DETERMDATE, DATEATRPR, RPTDTOCB, SOLDDATE, XOWNERRET, HISTRATE, DAILYRATE, ASSIGNDATE, RETRVDATE, SETTLEDATE, STOCKNUM, YARDLOC, TITLETOSALV, TITLEFMSALV, TITLETOSTATE, TITLEFMSTATE, TITLERECV, CERTFICATEDT, REFNO, PDREF, PDPOS, REF_LOCCAT, PTYPE, SEL_LOCATION FROM ICLITEMAU
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' ')NoICLCLAIMICL_CLAIM Allow NULL? 
4DAMAGEDOBJDamaged vehiclenvarchar40NUMC(N'0000')NoICLDAMOBJICL_DAMOBJAU Allow NULL? 
5CHANGETIMEChanged: Date + Timedecimal150DEC((0))YesICL_CHANGEUTC1
6CHANGEDBYChanged Bynvarchar120CHAR(N' ')YesUSR02ICL_CHANGEDBY Allow NULL? 
7DELETEDDatabase Line Status (Original, Changed, Deleted)char10CHAR(N' ')YesICL_RECSTATUS Allow NULL? 
8PROPMAKEMake of Insured Objectnvarchar40CHAR(N' ')YesICLPROPMAICL_IOBMA Allow NULL? 
9PROPMODELInsured Object Modelnvarchar40CHAR(N' ')YesICLPROPMOICL_IOBMODEL Allow NULL? 
10MODELTYCategory of Insured Objectnvarchar40CHAR(N' ')YesICLPROPTYICL_IOBTY Allow NULL? 
11VINVehicle Identification Numbernvarchar170CHAR(N' ')YesICL_VIN Allow NULL? 
12PLATECOUNTRYCountry Keynvarchar30CHAR(N' ')YesT005LAND1 Allow NULL? 
13PLATEREGIONRegion (State, Province, County)nvarchar30CHAR(N' ')YesT005SREGIO Allow NULL? 
14PLATENOLicense Plate Numbernvarchar120CHAR(N' ')YesICL_LICENSE Allow NULL? 
15CONSTYEARConstruction Year of Insured Vehiclenvarchar40NUMC(N'0000')YesICL_CONSTYEAR Allow NULL? 
16FIRSTREGDate of First Registrationnvarchar80DATS(N'00000000')YesICL_NOLDOAU04 Allow NULL? 
17CAPACITYEngine Capacity of Insured Vehicledecimal40QUAN((0))YesICL_CAPACITY
18CAPUNITUnit for Cubic Capacitynvarchar30UNIT(N' ')YesT006ICL_CAPUNIT Allow NULL? 
19COLORColornvarchar100CHAR(N' ')YesICL_COLOR Allow NULL? 
20GEARGear Typechar10CHAR(N' ')YesICL_GEAR Allow NULL? 
21XTHIRDPARTYFlag: Liability?char10CHAR(N' ')YesICL_XLIAB Allow NULL? 
22LOCATIONLocation where damaged object can be seennvarchar100CHAR(N' ')YesADRCICL_SCIAUADR Allow NULL? 
23INSPDATEInspection Datenvarchar80DATS(N'00000000')YesICL_INSPDATE Allow NULL? 
24WHENSEENNote on Inspectionnvarchar150CHAR(N' ')YesICL_ITEMAU10 Allow NULL? 
25PURPTRIPPurpose of Tripnvarchar20CHAR(N' ')YesTICL303ICL_PURPTRIP Allow NULL? 
26LEASINGFlag: Paid/Leased/Security Certificatechar10CHAR(N' ')YesICL_LEASING Allow NULL? 
27XPERMFlag: Driving with permission?char10CHAR(N' ')YesICL_ITEMAU01 Allow NULL? 
28XDAMFlag: Object Damaged?char10CHAR(N' ')YesICL_ITEMAU02 Allow NULL? 
29XVEHICITFlag: Vehicle Cited?char10CHAR(N' ')YesICL_ITEMAU03 Allow NULL? 
30XDRIVCITFlag: Driver Cited?char10CHAR(N' ')YesICL_ITEMAU04 Allow NULL? 
31XPVENDORFlag: Willing to Use Preferred Vendor?char10CHAR(N' ')YesICL_ITEMAU05 Allow NULL? 
32XPARKEDVehicle Was Parked When Loss Occurredchar10CHAR(N' ')YesICL_ITEMAU06 Allow NULL? 
33XPREFlag: Preexisting Damage?char10CHAR(N' ')YesICL_ITEMAU07 Allow NULL? 
34DRIVABLEDamaged Vehicle Is Not Roadworthychar10CHAR(N' ')YesICL_ITEMAUDR Allow NULL? 
35MILEAGEMileagedecimal60QUAN((0))YesICL_MILEAGE
36MILEAGEUNITUnit for mileagenvarchar30UNIT(N' ')YesT006ICL_MILEAGEUNIT Allow NULL? 
37TREADFTread of Front Tiresdecimal20QUAN((0))YesICL_TREADF
38TREADRTread of Rear Tiresdecimal20QUAN((0))YesICL_TREADR
39TREADUNITTread Unitnvarchar30UNIT(N' ')YesT006ICL_TREADUNIT Allow NULL? 
40PCVValue of Object at Contract Conclusiondecimal152CURR((0))YesICL_PCV
41PCVCURRCurrency of Value at Conclusion of Policynvarchar50CUKY(N' ')YesTCURCICL_PCVCURR Allow NULL? 
42OWPHRELRelationship between Owner and PHchar10CHAR(N' ')YesICL_OWPHREL Allow NULL? 
43XTOTDAMAGEFlag: Total Losschar10CHAR(N' ')YesICL_ITEMAU11 Allow NULL? 
44XSTOLENFlag: Stolen?char10CHAR(N' ')YesICL_ITEMPP01 Allow NULL? 
45XRECOVEREDFlag: Stolen Object Recovered?char10CHAR(N' ')YesICL_ITEMWA02 Allow NULL? 
46RECOVERDATERecovery Date of Objectnvarchar80DATS(N'00000000')YesICL_RECOVERDATE Allow NULL? 
47MONTH_FROMMonth From Which Seasonal License Plate Issuednvarchar20NUMC(N'00')YesICL_MONTHFROM Allow NULL? 
48MONTH_TOMonth up to Which Seasonal License Plate Issuednvarchar20NUMC(N'00')YesICL_MONTHTO Allow NULL? 
49OWNERCHANGELast Change of Vehicle Owner: Datenvarchar80DATS(N'00000000')YesICL_OWNERCHANGE Allow NULL? 
50GENERALINSPNext Mandatory Technical Inspectionnvarchar70CHAR(N' ')YesICL_INSPECTION Allow NULL? 
51CURRCurrency of Actual Cash Valuenvarchar50CUKY(N' ')YesTCURCICL_ACVCURR Allow NULL? 
52SALVVALUESalvage Value as Amount of Moneydecimal152CURR((0))YesICL_SALVVALUE
53ESTACVSalvage: Average Salvage Potentialdecimal152CURR((0))YesICL_SALVESTACV
54EVALDATEEvaluation Date for Salvagenvarchar80DATS(N'00000000')YesICL_SALVEVALDT Allow NULL? 
55DETERMDATEDate: Damaged Objected Determined as Salvagenvarchar80DATS(N'00000000')YesICL_SALVDETRDT Allow NULL? 
56DATEATRPRSalvage: Arrival Date at Repair Shopnvarchar80DATS(N'00000000')YesICL_DTATRPR Allow NULL? 
57RPTDTOCBDate Reported to Policenvarchar80DATS(N'00000000')YesICL_RPTDTOCB Allow NULL? 
58SOLDDATEDate Salvage Item Soldnvarchar80DATS(N'00000000')YesICL_SALVSOLDD Allow NULL? 
59XOWNERRETFlag: Retained by Owner?char10CHAR(N' ')YesICL_SALVOWNRET Allow NULL? 
60HISTRATEHistory Rate in Percentdecimal52DEC((0))YesICL_HISTRATEI
61DAILYRATESalvage: Daily Standing Charges at Salvage Yarddecimal152CURR((0))YesICL_DAILYRATESALV
62ASSIGNDATESalvage: Date Assigned to Salvage Companynvarchar80DATS(N'00000000')YesICL_ASSIGNDT Allow NULL? 
63RETRVDATESalvage: Arrival Date at Salvage Yardnvarchar80DATS(N'00000000')YesICL_RETRVDT Allow NULL? 
64SETTLEDATESalvage: Settlement Datenvarchar80DATS(N'00000000')YesICL_SETTLEMENTDT Allow NULL? 
65STOCKNUMSalvage: Stock Numbernvarchar80CHAR(N' ')YesICL_SALVSTOCK Allow NULL? 
66YARDLOCSalvage: Salvage Yard Locationnvarchar80CHAR(N' ')YesICL_SALVYARDLOC Allow NULL? 
67TITLETOSALVDate on Which Title Was Transferred to Salvornvarchar80DATS(N'00000000')YesICL_SALVTITLEST Allow NULL? 
68TITLEFMSALVDate on Which Title Was Received by Salvornvarchar80DATS(N'00000000')YesICL_SALVTITLERC Allow NULL? 
69TITLETOSTATEDate: Title Sent To Statenvarchar80DATS(N'00000000')YesICL_TITLTOSTAT Allow NULL? 
70TITLEFMSTATEDate on Which Title Received by Statenvarchar80DATS(N'00000000')YesICL_TITLFRMST Allow NULL? 
71TITLERECVDate on Which Insurer Received Titlenvarchar80DATS(N'00000000')YesICL_TITLTOINS Allow NULL? 
72CERTFICATEDTSalvage: Certificate Datenvarchar80DATS(N'00000000')YesICL_PROVCERTDT Allow NULL? 
73REFNOExternal Reference Numbernvarchar150CHAR(N' ')YesICL_SCLITEMREF Allow NULL? 
74PDREFReference to Purchasing Documentnvarchar100CHAR(N' ')YesICL_PDREF Allow NULL? 
75PDPOSReference to Item Number in Purchasing Documentnvarchar100NUMC(N'0000000000')YesICL_PDPOS Allow NULL? 
76REF_LOCCATReference Location for External Servicesnvarchar20CHAR(N' ')Yes*ICL_EXTSVCS_REFCAT Allow NULL? 
77PTYPETransaction Type in Procurement Processnvarchar40CHAR(N' ')Yes*ICL_PTYPE Allow NULL? 
78SEL_LOCATIONLocation of Damaged Objectchar10CHAR(N' ')YesICL_INSPLOC Allow NULL? 
NamePrimaryUniqueTypeColumns
ICLITEMAU~0YesYesCLUSTEREDDAMAGEDOBJ, CLAIM, ACTIVE, CLIENT
ICLITEMAU~001NoNoNONCLUSTEREDPLATENO, 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