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  | ICLPROCURE
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.0ICLPROCURE744Claim Item GroupingsClaims Management
SQL:  selectupdate insert create

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

SELECT CLIENT, ACTIVE, CLAIM, SUBCLAIM, PROCUREMENT, CHANGETIME, CHANGEDBY, DELETED, CREATEDBY, CREATETIME, PDOCTYPE, PDOCCAT, ISSUEDATE, RECEIVEDATE, DATEFROM, TIMEFROM, DATETO, TIMETO, ISSUEDATE_PRESCR, ACQUISITIONDATE, AMOUNT1, CURRENCY, EXTERNALREF, EXTDOCUMENT, EXTCASENO, EXTFILENO, PROC_REF, DISCOUNTAMOUNT, DISCOUNTPERCENT, ACCIDENT, SUBROGATION, DUEDATE, DUEDATE_ORIG, STATUS, STATREASON, OWNCONTRIB, REASON, CAUSE, PDOCCATTYPE, SUBCL_ORIG, PROC_ORIG, DATASOURCE, SETORDERDATE, COMPLETIONDATE, FEE, MATLABCOST, MATLABCOSTINT, ADDCOST, VALPERUNIT, SUBSIDYPERCENT, SUBSIDYAMOUNT, SENTUTC, SENT_BY_DME, RECEIPT_BY_DME, CANCEL, REJECTED, INSUSPENSE, INPROCESS, RELEASED, XFINISHED, ORDERED, TRANSFERRED, TOBEAPPROVED, XCLINICCARD, PAYFREQPLAN, ASSIGN_GUID, XREQUEST, COMPPER_DATEFROM, COMPPER_DATETO, PAYOUT_SCENARIO, REASONREJ, METHOD, ADDRNUMBER, BKID FROM ICLPROCURE
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? 
4SUBCLAIMSubclaim of Paymentnvarchar30CHAR(N' ')NoICLSUBCLICL_SUBCLP Allow NULL? 
5PROCUREMENTID of Claim Item Groupingnvarchar40NUMC(N'0000')NoICL_PROCUREMENT Allow NULL? 
6CHANGETIMEChanged: Date + Timedecimal150DEC((0))YesICL_CHANGEUTC1
7CHANGEDBYChanged Bynvarchar120CHAR(N' ')YesUSR02ICL_CHANGEDBY Allow NULL? 
8DELETEDDatabase Line Status (Original, Changed, Deleted)char10CHAR(N' ')YesICL_RECSTATUS Allow NULL? 
9CREATEDBYCreated Bynvarchar120CHAR(N' ')YesUSR02ICL_CREATEDBY Allow NULL? 
10CREATETIMECreated: Date + Timedecimal150DEC((0))YesICL_CREATEUTC
11PDOCTYPEBenefit Type for Grouping of Lower Level Benefit Typesnvarchar100CHAR(N' ')Yes*ICL_PDOCTYPE Allow NULL? 
12PDOCCATClaim Item Grouping Categorynvarchar20CHAR(N' ')YesTICL138ICL_PDOCCAT Allow NULL? 
13ISSUEDATEDate Creatednvarchar80DATS(N'00000000')YesICL_ISSUEDATE1 Allow NULL? 
14RECEIVEDATEDate Receivednvarchar80DATS(N'00000000')YesICL_RECEIVEDATE Allow NULL? 
15DATEFROMStart Date of Periodnvarchar80DATS(N'00000000')YesICL_DATEFROM Allow NULL? 
16TIMEFROMStart Time of Claim Item Groupnvarchar60TIMS(N'000000')YesICL_TIMEFROM Allow NULL? 
17DATETOEnd Date of Periodnvarchar80DATS(N'00000000')YesICL_DATETO Allow NULL? 
18TIMETOEnd Time of Claim Item Groupnvarchar60TIMS(N'000000')YesICL_TIMETO Allow NULL? 
19ISSUEDATE_PRESCRDate Prescription Created Acc. to Invoicenvarchar80DATS(N'00000000')YesICL_ISSUEDATE_PRESCR Allow NULL? 
20ACQUISITIONDATEDate Enterednvarchar80DATS(N'00000000')YesICL_ACQUISITIONDATE Allow NULL? 
21AMOUNT1General Amount Fielddecimal152CURR((0))YesICL_AMOUNT1
22CURRENCYCurrencynvarchar50CUKY(N' ')YesTCURCICL_CURRENCY Allow NULL? 
23EXTERNALREFExternal Reference of Claim Item Groupingnvarchar200CHAR(N' ')YesICL_EXTERNALREF Allow NULL? 
24EXTDOCUMENTExternal Document Numbernvarchar160CHAR(N' ')YesICL_EXTDOCUMENT Allow NULL? 
25EXTCASENOHospital-Internal IDnvarchar230CHAR(N' ')YesICLH_EXTCASENO Allow NULL? 
26EXTFILENOHI: External Data Set Identificationnvarchar200CHAR(N' ')YesICLH_EXTFILENO Allow NULL? 
27PROC_REFReference to Claim Item Groupingnvarchar40NUMC(N'0000')YesICLPROCUREICL_PROC_REF Allow NULL? 
28DISCOUNTAMOUNTDiscount on Invoice Amountdecimal152CURR((0))YesICL_DISCOUNTAMOUNT
29DISCOUNTPERCENTDiscount on Total Invoice Amount in Percentdecimal52DEC((0))YesICL_DISCOUNTPERCENT
30ACCIDENTAccident or Other Reason for Possible Recoverynvarchar20CHAR(N' ')YesTICL158ICL_ACCIDENT Allow NULL? 
31SUBROGATIONIndication Whether Recovery Claim Might Be Involvednvarchar20CHAR(N' ')YesTICL157ICL_SUBROGATION Allow NULL? 
32DUEDATEDue Datenvarchar80DATS(N'00000000')YesICL_DUEDATE Allow NULL? 
33DUEDATE_ORIGOrigin of Due Datenvarchar80DATS(N'00000000')YesICL_DUEDATE_ORIG Allow NULL? 
34STATUSStatus of a Claim Item Groupingnvarchar20CHAR(N' ')YesTICL140ICL_PROCSTATUS Allow NULL? 
35STATREASONReason for Changing the Statusnvarchar20CHAR(N' ')YesTICL018ICL_FORMSET Allow NULL? 
36OWNCONTRIBCopaymentnvarchar30NUMC(N'000')YesICL_OWNCONTRIB Allow NULL? 
37REASONReason for Creating a Claim Item Groupingnvarchar30CHAR(N' ')YesTICL152ICL_REASON Allow NULL? 
38CAUSESpecification of Reason for Creating Claim Item Groupingnvarchar20CHAR(N' ')Yes*ICLH_CAUSE Allow NULL? 
39PDOCCATTYPEType of Claim Item Grouping Categorynvarchar30CHAR(N' ')YesTICL153ICL_PDOCCATTYPE Allow NULL? 
40SUBCL_ORIGOriginal Subclaim Multiple Prescription/Curr.Subclm Appraislnvarchar30CHAR(N' ')Yes*ICL_SUBCL_ORIG Allow NULL? 
41PROC_ORIGOriginal Claim Item Grouping of Multiple Prescriptionnvarchar40NUMC(N'0000')Yes*ICL_PROC_ORIG Allow NULL? 
42DATASOURCEData Originnvarchar20CHAR(N' ')YesTICL136ICL_DATASOURCE Allow NULL? 
43SETORDERDATESet Order Datenvarchar80DATS(N'00000000')YesICL_SETORDERDATE Allow NULL? 
44COMPLETIONDATECompletion Datenvarchar80DATS(N'00000000')YesICL_COMPLETIONDATE Allow NULL? 
45FEEFeedecimal152CURR((0))YesICLH_FEE
46MATLABCOSTMaterial and Laboratory Costsdecimal152CURR((0))YesICLH_MATLABCOST
47MATLABCOSTINTwill be deleted.decimal152CURR((0))YesICLH_MATLABCOSTINT
48ADDCOSTOther Costsdecimal152CURR((0))YesICLH_ADDCOST
49VALPERUNITValue per Unit of Benefits Catalog Itemdecimal2012DEC((0))YesICL_SERVCAT_POS_VALPERUNIT
50SUBSIDYPERCENTSubsidy in Percent (%)decimal52DEC((0))YesICLH_SUBSIDYPERCENT
51SUBSIDYAMOUNTSubsidy Amountdecimal152CURR((0))YesICLH_SUBSIDYAMOUNT
52SENTUTCSent: Date and Timedecimal150DEC((0))YesICL_SENTUTC
53SENT_BY_DMESent via External Interface (Not Yet Used)char10CHAR(N' ')YesICL_SENT_BY_DME Allow NULL? 
54RECEIPT_BY_DMEReceipt via External Interfacechar10CHAR(N' ')YesICL_RECEIPT_BY_DME Allow NULL? 
55CANCELStatus "Cancelled"char10CHAR(N' ')YesICL_STATUS_CANCEL Allow NULL? 
56REJECTEDStatus "Rejected"char10CHAR(N' ')YesICL_STATUS_REJECTED Allow NULL? 
57INSUSPENSEStatus "Pending"char10CHAR(N' ')YesICL_STATUS_INSUSPENSE Allow NULL? 
58INPROCESSStatus "In Process"char10CHAR(N' ')YesICL_STATUS_INPROCESS Allow NULL? 
59RELEASEDStatus "Released"char10CHAR(N' ')YesICL_STATUS_RELEASED Allow NULL? 
60XFINISHEDComplete/Approved/Finishedchar10CHAR(N' ')YesICL_XFINISHED Allow NULL? 
61ORDEREDStatus "Commissioned"char10CHAR(N' ')YesICL_STATUS_ORDERED Allow NULL? 
62TRANSFERREDStatus "Reassigned"char10CHAR(N' ')YesICL_STATUS_TRANSFERRED Allow NULL? 
63TOBEAPPROVEDStatus "To Be Approved"char10CHAR(N' ')YesICL_STATUS_TOBEAPPROVED Allow NULL? 
64XCLINICCARDFlag: Clinic Cardchar10CHAR(N' ')YesICLH_CLINIC_CARD Allow NULL? 
65PAYFREQPLANPayment Frequency of a Repetitive Paymentnvarchar20CHAR(N' ')YesTVS010BICL_PAYFREQPLAN_REP Allow NULL? 
66ASSIGN_GUIDUUID of Entry to be Linkednvarchar320CHAR(N' ')YesICL_ASSIGN_GUID Allow NULL? 
67XREQUESTIndicator: Receivablechar10CHAR(N' ')YesICL_XREQUEST Allow NULL? 
68COMPPER_DATEFROMComparision Period Fromnvarchar80DATS(N'00000000')YesICL_COMPPER_DATEFROM_D_PE Allow NULL? 
69COMPPER_DATETOComparison Period Tonvarchar80DATS(N'00000000')YesICL_COMPPER_DATETO_D_PE Allow NULL? 
70PAYOUT_SCENARIORepetitive Payment Scenariochar10CHAR(N' ')YesICL_PAYOUT_SCENARIO_D Allow NULL? 
71REASONREJRejection Reasons for Payments and Reservesnvarchar20CHAR(N' ')Yes*ICL_REASONREJ Allow NULL? 
72METHODPayment Methodchar10CHAR(N' ')Yes*ICL_PAYMENT01 Allow NULL? 
73ADDRNUMBERAddress Number for Checksnvarchar100CHAR(N' ')Yes*ICL_ADDRNUM Allow NULL? 
74BKIDBank Details IDnvarchar40CHAR(N' ')YesICL_BKID Allow NULL? 
NamePrimaryUniqueTypeColumns
ICLPROCURE~0YesYesCLUSTEREDPROCUREMENT, SUBCLAIM, CLAIM, ACTIVE, CLIENT
ICLPROCURE~001NoNoNONCLUSTEREDEXTERNALREF, CLIENT
ICLPROCURE~002NoNoNONCLUSTEREDSTATUS, PDOCCAT
ICLPROCURE~003NoNoNONCLUSTEREDDATETO, DATEFROM, PDOCCAT

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