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

B1 9.2: Top 10 requests

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

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
9OINM101Whse Journal
10OSRN20Serial Numbers Master Data
Financial Services :: Claims Management
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0ICSITEM761Claim ItemClaims 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, CHANGETIME, CHANGEDBY, DELETED, ITEMCAT, ITEMTYPE, ITEMUSE, COVTYPE, BENTYPE, RCOVTYPE, XWAITPERIOD, COVERAGE, SCPOSID_INT, SERVCAT, SCPOSID_EXT, STATUS, REJREASON, MODIFIED, PROCURED, CALCULATED, DESCRIPTION, DAILY, WEEKLY, MONTHLY, TOTAL, VALIDFROM, VALIDTO, STARTDATE, ENDDATE, DNUMBER, EVALUATION, EVALCAT, EVALBASE, EVQUANTITY, EVQUANUNIT, EVAMTPERUNIT, EVAMOUNT, EVCURR, FACTOR, ACV, ACVPERCENT, CALCEXPRESSION, PERDAY, DISCOUNTPERCENT, XDISCOUNTUSED, XDISCOUNTPERCENT, XDISC_2B_APPLIED, GROSNET, TXCOD, SUBCLREF, PROCUREMENT, ITEM_REF, DAMAGEDOBJ, ASSIGN_GUID, REFNO, PDREF, PDPOS, REF_LOCCAT, PTYPE, XGENEROS, ADDITIONAL_ITEM, ADDIT_ITEM_SUM, REMUN_TYPE, BENVALUE, XCREATEDMAN, CREATIONREASON, XGENLEDGERTP, PERIODICITY, ADDDUEDATE, TOTALVALUEANNUAL, PAYROLLVAR, DISBURSETYPE FROM ICSITEM
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' ')No*ICL_SCLITEM Allow NULL? 
6CHANGETIMEChanged: Date + Timedecimal150DEC((0))NoICL_CHANGEUTC1
7CHANGEDBYChanged Bynvarchar120CHAR(N' ')YesUSR02ICL_CHANGEDBY Allow NULL? 
8DELETEDDatabase Line Status (Original, Changed, Deleted)char10CHAR(N' ')YesICL_RECSTATUS Allow NULL? 
9ITEMCATClaim Item Categorynvarchar20CHAR(N' ')YesTICL139ICL_ITEMCAT Allow NULL? 
10ITEMTYPEClaim Item Object Typenvarchar30CHAR(N' ')YesTICL164ICL_ITEMTYPE Allow NULL? 
11ITEMUSEUsage Type of Claim Itemnvarchar20CHAR(N' ')YesTICL332ICL_ITEMUSE Allow NULL? 
12COVTYPECoverage Typenvarchar100CHAR(N' ')Yes*ICL_COVTYPE Allow NULL? 
13BENTYPEBenefit Typenvarchar100CHAR(N' ')YesTICL055ICL_BENTYPE Allow NULL? 
14RCOVTYPEBenefit Coverage Typenvarchar100CHAR(N' ')Yes*ICL_RCOVTYPE Allow NULL? 
15XWAITPERIODProbationary Periods Ignoredchar10CHAR(N' ')YesICL_XWAITPERIOD Allow NULL? 
16COVERAGECoveragenvarchar40CHAR(N' ')Yes*ICL_POLM Allow NULL? 
17SCPOSID_INTInternal ID of Benefits Catalog Itemnvarchar320CHAR(N' ')YesICL_SERVCAT_POSID_INT Allow NULL? 
18SERVCATID of a Benefits, Services and Fees Catalognvarchar100CHAR(N' ')Yes*ICL_SERVCATID Allow NULL? 
19SCPOSID_EXTID of a Benefits Catalog Itemnvarchar200CHAR(N' ')YesICL_SERVCAT_POSID Allow NULL? 
20STATUSStatus of Claim Itemnvarchar20CHAR(N' ')YesICL_SCLITEMS Allow NULL? 
21REJREASONClaim Item Rejection Reasonnvarchar20CHAR(N' ')YesTICL043ICL_REJREASON Allow NULL? 
22MODIFIEDModifiedchar10CHAR(N' ')YesICL_MODIFIED Allow NULL? 
23PROCUREDOrderedchar10CHAR(N' ')YesICL_PROCURED Allow NULL? 
24CALCULATEDCalculatedchar10CHAR(N' ')YesICL_CALCULATED Allow NULL? 
25DESCRIPTIONClaim Item Descriptionnvarchar400CHAR(N' ')YesICL_DPDESC Allow NULL? 
26DAILYDailychar10NUMC(N'0')YesICL_DAILY Allow NULL? 
27WEEKLYWeeklychar10NUMC(N'0')YesICL_WEEKLY Allow NULL? 
28MONTHLYMonthlynvarchar20NUMC(N'00')YesICL_MONTHLY Allow NULL? 
29TOTALTotal Number of Benefitsnvarchar30NUMC(N'000')YesICL_TOTAL Allow NULL? 
30VALIDFROMClaim Item: Valid Fromnvarchar80DATS(N'00000000')YesICL_VALIDFROM Allow NULL? 
31VALIDTOClaim Item: Valid Tonvarchar80DATS(N'00000000')YesICL_VALIDTO Allow NULL? 
32STARTDATEStart Datenvarchar80DATS(N'00000000')YesICL_STARTDATE Allow NULL? 
33ENDDATEEnd Datenvarchar80DATS(N'00000000')YesICL_ENDDATE Allow NULL? 
34DNUMBERNumberdecimal50DEC((0))YesICL_NUMBER
35EVALUATIONValid claim item evaluationnvarchar20NUMC(N'00')YesICLITEMEVICL_EVALUATION1 Allow NULL? 
36EVALCATEvaluation Categorynvarchar20CHAR(N' ')Yes*ICL_EVALCAT Allow NULL? 
37EVALBASEType of Evaluatornvarchar30CHAR(N' ')YesTICL026ICL_EVALBASE Allow NULL? 
38EVQUANTITYClaim Item: Number (Days, Visits, Area) for Evaluationdecimal103QUAN((0))YesICL_EVQUANTITY
39EVQUANUNITClaim Item: Unit of Measurementnvarchar30UNIT(N' ')Yes*ICL_EVQUANUNIT Allow NULL? 
40EVAMTPERUNITAmount per Unitdecimal152CURR((0))YesICL_EVAMTPERUNIT
41EVAMOUNTEvaluated Amountdecimal152CURR((0))YesICL_EVAMOUNT
42EVCURRCurrency of Evaluated Amountnvarchar50CUKY(N' ')YesTCURCICL_EVCURR Allow NULL? 
43FACTORFactordecimal74DEC((0))YesICLH_FACTOR
44ACVActual Cash Valuedecimal152CURR((0))YesICL_ACV
45ACVPERCENTProportion of Actual Cash Value to Original Cash Value in %decimal52DEC((0))YesICL_ACVPER
46CALCEXPRESSIONBRFplus Expression for Calculating Payout Amountnvarchar200CHAR(N' ')Yes*ICL_CALC_EXPRESSION Allow NULL? 
47PERDAYAmount per Daydecimal152CURR((0))YesICL_PERDAY
48DISCOUNTPERCENTDiscount on Total Invoice Amount in Percentdecimal52DEC((0))YesICL_DISCOUNTPERCENT
49XDISCOUNTUSEDDiscount Amount from Table Applied with Invoicechar10CHAR(N' ')YesICL_XDISCOUNTUSED Allow NULL? 
50XDISCOUNTPERCENTDiscount Amount Without Reference to Percent Discountchar10CHAR(N' ')YesICL_XDISCOUNTPERCENT Allow NULL? 
51XDISC_2B_APPLIEDIndicator: Discount to Be Appliedchar10CHAR(N' ')YesICL_XDISC_2B_APPLIED Allow NULL? 
52GROSNETFlag: Amount Is Net Amountchar10CHAR(N' ')YesICL_GROSNET Allow NULL? 
53TXCODTax Codenvarchar20CHAR(N' ')Yes*ICL_TXCOD Allow NULL? 
54SUBCLREFSubclaim to Which a Claim Item Is Assignednvarchar30CHAR(N' ')Yes*ICL_SUBCLREF Allow NULL? 
55PROCUREMENTID of Claim Item Groupingnvarchar40NUMC(N'0000')Yes*ICL_PROCUREMENT Allow NULL? 
56ITEM_REFClaim Itemnvarchar40CHAR(N' ')Yes*ICL_SCLITEM Allow NULL? 
57DAMAGEDOBJDamaged Objectnvarchar40NUMC(N'0000')YesICLDAMOBJICL_DAMOBJ Allow NULL? 
58ASSIGN_GUIDUUID of Entry to be Linkednvarchar320CHAR(N' ')YesICL_ASSIGN_GUID Allow NULL? 
59REFNOExternal Reference Numbernvarchar150CHAR(N' ')YesICL_SCLITEMREF Allow NULL? 
60PDREFReference to Purchasing Documentnvarchar100CHAR(N' ')YesICL_PDREF Allow NULL? 
61PDPOSReference to Item Number in Purchasing Documentnvarchar100NUMC(N'0000000000')YesICL_PDPOS Allow NULL? 
62REF_LOCCATReference Location for External Servicesnvarchar20CHAR(N' ')Yes*ICL_EXTSVCS_REFCAT Allow NULL? 
63PTYPETransaction Type in Procurement Processnvarchar40CHAR(N' ')Yes*ICL_PTYPE Allow NULL? 
64XGENEROSFlag: Ex Gratia Payment?char10CHAR(N' ')YesICL_XGENEROS Allow NULL? 
65ADDITIONAL_ITEMAdditional Claim Itemchar10CHAR(N' ')YesICL_ITEM_SPLIT_D Allow NULL? 
66ADDIT_ITEM_SUMTotal of Additional Claim Itemschar10CHAR(N' ')YesICL_ITEM_SUM_D Allow NULL? 
67REMUN_TYPERemuneration Categorynvarchar40CHAR(N' ')YesICL_REMUN_TYPE_D_PE Allow NULL? 
68BENVALUEBenefit Valuedecimal152CURR((0))YesICL_BENVALUE_D
69XCREATEDMANManually Created Itemchar10CHAR(N' ')YesICL_XCREATEDMAN_D Allow NULL? 
70CREATIONREASONReason for Manual Creation (ID)nvarchar30CHAR(N' ')Yes*ICL_CREATIONREASON_D Allow NULL? 
71XGENLEDGERTPInternal Clearingchar10CHAR(N' ')YesICL_XGENLEDGERTP_D Allow NULL? 
72PERIODICITYTime Periodsnvarchar20CHAR(N' ')Yes*ICL_PERIODICITY_D Allow NULL? 
73ADDDUEDATEAdditional Payment Due Datenvarchar120CHAR(N' ')YesICL_ADDDUEDATE_D Allow NULL? 
74TOTALVALUEANNUALTotal Annual Valuedecimal152CURR((0))YesICL_TOTALVALUEANNUAL_D
75PAYROLLVARSettlement Variant for Annuity Disbursementnvarchar30NUMC(N'000')YesICL_PAYROLLVAR_D Allow NULL? 
76DISBURSETYPEDisbursement Category for Annuity Disbursementnvarchar30NUMC(N'000')YesICL_DISBURSETYPE_D Allow NULL? 
NamePrimaryUniqueTypeColumns
ICSITEM~0YesYesCLUSTEREDCHANGETIME, 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