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  | ICSITEMEV
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.0ICSITEMEV501Claim Item EvaluationClaims Management
SQL:  selectupdate insert create

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

SELECT CLIENT, ACTIVE, CLAIM, SUBCLAIM, ITEM, EVALUATION, CHANGETIME, CHANGEDBY, DELETED, EVALCAT, EVAMOUNT, EVCURR, GROSNET, TXCOD, EVDATE, LIABRATE, EVALBASE, CLMDAMOUNT, EVAMTPERUNIT, EVQUANTITY, EVQUANUNIT, XARCHDOC, FACTOR, DNUMBER, STARTDATE, ENDDATE, PERDAY, OC, RC, ACV, INUMBER, AGE, ACVPERCENT, RCORACV, CATALOGID, CATALOGITEM, MATNR, MATGROUP, PRICE_UNIT, VENDOR_CATALOG, VENDORMAT, MANUFACTCODE, MANUFACTMAT, SERVICE, CUST_FIELD1, CUST_FIELD2, CUST_FIELD3, CUST_FIELD4, CUST_FIELD5, PROCUREMENT FROM ICSITEMEV
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? 
4SUBCLAIMSubclaimnvarchar30CHAR(N' ')NoICLSUBCLICL_SUBCL Allow NULL? 
5ITEMClaim Itemnvarchar40CHAR(N' ')NoICLITEMICL_SCLITEM Allow NULL? 
6EVALUATIONClaim Item Evaluationnvarchar20NUMC(N'00')No*ICL_EVALUATION Allow NULL? 
7CHANGETIMEChanged: Date + Timedecimal150DEC((0))NoICL_CHANGEUTC1
8CHANGEDBYChanged Bynvarchar120CHAR(N' ')YesUSR02ICL_CHANGEDBY Allow NULL? 
9DELETEDDatabase Line Status (Original, Changed, Deleted)char10CHAR(N' ')YesICL_RECSTATUS Allow NULL? 
10EVALCATEvaluation Categorynvarchar20CHAR(N' ')YesTICL021ICL_EVALCAT Allow NULL? 
11EVAMOUNTEvaluated Amountdecimal152CURR((0))YesICL_EVAMOUNT
12EVCURRCurrency of Evaluated Amountnvarchar50CUKY(N' ')YesTCURCICL_EVCURR Allow NULL? 
13GROSNETFlag: Amount Is Net Amountchar10CHAR(N' ')YesICL_GROSNET Allow NULL? 
14TXCODTax Codenvarchar20CHAR(N' ')Yes*ICL_TXCOD Allow NULL? 
15EVDATEValuation Datenvarchar80DATS(N'00000000')YesICL_EVDATE Allow NULL? 
16LIABRATELiability Rate in Percentdecimal52DEC((0))YesICL_LIABRATEI
17EVALBASEType of Evaluatornvarchar30CHAR(N' ')YesTICL026ICL_EVALBASE Allow NULL? 
18CLMDAMOUNTAmount Requesteddecimal152CURR((0))YesICL_CLMDAMOUNT
19EVAMTPERUNITAmount per Unitdecimal152CURR((0))YesICL_EVAMTPERUNIT
20EVQUANTITYClaim Item: Number (Days, Visits, Area) for Evaluationdecimal103QUAN((0))YesICL_EVQUANTITY
21EVQUANUNITClaim Item: Unit of Measurementnvarchar30UNIT(N' ')YesT006ICL_EVQUANUNIT Allow NULL? 
22XARCHDOCArchived Document Assigned?char10CHAR(N' ')YesICL_XARCHDOC Allow NULL? 
23FACTORFactordecimal74DEC((0))YesICLH_FACTOR
24DNUMBERNumber of Daysdecimal50DEC((0))YesICL_DNUMBER
25STARTDATEStart Datenvarchar80DATS(N'00000000')YesICL_STARTDATE Allow NULL? 
26ENDDATEEnd Datenvarchar80DATS(N'00000000')YesICL_ENDDATE Allow NULL? 
27PERDAYAmount per Daydecimal152CURR((0))YesICL_PERDAY
28OCOriginal Valuedecimal152CURR((0))YesICL_OC
29RCOriginal Cash Valuedecimal152CURR((0))YesICL_RC
30ACVActual Cash Valuedecimal152CURR((0))YesICL_ACV
31INUMBERNumberdecimal50DEC((0))YesICL_NUMBER
32AGEAge of Item in Yearsnvarchar20NUMC(N'00')YesICL_ITEMAGE Allow NULL? 
33ACVPERCENTProportion of Actual Cash Value to Original Cash Value in %decimal52DEC((0))YesICL_ACVPER
34RCORACVFlag: Use Actual Cash Value or Original Cash Valuechar10CHAR(N' ')YesICL_RCORACV Allow NULL? 
35CATALOGIDCatalog IDnvarchar40CHAR(N' ')Yes*ICL_CATALOGID Allow NULL? 
36CATALOGITEMCatalog Item Numbernvarchar400CHAR(N' ')YesICL_CATALOGITEM Allow NULL? 
37MATNRMaterial Numbernvarchar180CHAR(N' ')Yes*MATNR Allow NULL? 
38MATGROUPEBP: Material Groupnvarchar100CHAR(N' ')YesICL_MATGROUP Allow NULL? 
39PRICE_UNITPrice Unitdecimal50DEC((0))YesEPEIN
40VENDOR_CATALOGSuppliernvarchar100CHAR(N' ')Yes*ICL_SUPPL Allow NULL? 
41VENDORMATProduct Number of Vendornvarchar220CHAR(N' ')YesICL_VENDORMAT Allow NULL? 
42MANUFACTCODEEBP: Manufacturer Codenvarchar100CHAR(N' ')YesICL_MANUFACTCODE Allow NULL? 
43MANUFACTMATEBP: Part Number of Manufacturernvarchar400CHAR(N' ')YesICL_MANUFACTMAT Allow NULL? 
44SERVICEEBP: Service Flagchar10CHAR(N' ')YesICL_SERVICE Allow NULL? 
45CUST_FIELD1BBP: Catalog - Customer Field 1nvarchar100CHAR(N' ')YesICL_CUST_FIELD1 Allow NULL? 
46CUST_FIELD2BBP: Catalog - Customer Field 2nvarchar100CHAR(N' ')YesICL_CUST_FIELD2 Allow NULL? 
47CUST_FIELD3BBP: Catalog - Customer Field 3nvarchar100CHAR(N' ')YesICL_CUST_FIELD3 Allow NULL? 
48CUST_FIELD4BBP: Catalog - Customer Field 4nvarchar200CHAR(N' ')YesICL_CUST_FIELD4 Allow NULL? 
49CUST_FIELD5BBP: Catalog - Customer Field 5nvarchar500CHAR(N' ')YesICL_CUST_FIELD5 Allow NULL? 
50PROCUREMENTID of Claim Item Groupingnvarchar40NUMC(N'0000')Yes*ICL_PROCUREMENT Allow NULL? 
NamePrimaryUniqueTypeColumns
ICSITEMEV~0YesYesCLUSTEREDCHANGETIME, EVALUATION, ITEM, SUBCLAIM, 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