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  | ICSPAY
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.0ICSPAY671PaymentClaims Management
SQL:  selectupdate insert create

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

SELECT CLIENT, ACTIVE, CLAIM, SUBCLAIM, PAYMENT, CHANGETIME, CHANGEDBY, DELETED, CREATEDBY, CREATETIME, APPROVEDBY, APPROVEDTIME, TRANSFERTIME, DOCUMENTREF, POSTDATE, DOCDATE, DUEDATE, XALREADYPAID, PAYCAT, PAYTYPE, SUBSAL, XPAYEE, ADDRNUMBER, CRECADDR, BKID, CURR, EXCHRATE, STATUS, METHOD, CHECKNUMBER, NOTE, INVOICEREF, REFCLAIM, REFSUBCLAIM, REFPAYMENT, AMTDONE, LIABRATE, AMTNEG, SUBROSTATUS, TAXROLE, TAX_RPT, XTAXRPTCT, MTAXRPTCT, OVRD_TAXRPTCT, FUNDSRECDT, XSALVESTEND, OWNERTYPE_GRP, OWNER_GRP, REASONREJ, REFEXTSDOC, MOS, CL_PAYFREQPLAN, PMTTO, PMTFR, SCHEDTYPE, NROFINVREQ, DAMAGEDOBJ, MIGRATION, REQEVALCAT, ASSIGN_GUID, PAYOUT_SCENARIO, SERV_FROM, SERV_TO, XREPPAY, ALTPOSTTARGET, GROSS_NET_PAYMENT, HCM_PAYMENT_STATE FROM ICSPAY
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? 
5PAYMENTNumber of Claim Paymentnvarchar50NUMC(N'00000')No*ICL_PAYMENT 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? 
9CREATEDBYCreated Bynvarchar120CHAR(N' ')YesUSR02ICL_CREATEDBY Allow NULL? 
10CREATETIMECreated: Date + Timedecimal150DEC((0))YesICL_CREATEUTC
11APPROVEDBYChecked Bynvarchar120CHAR(N' ')YesUSR02ICL_PAYMENT13 Allow NULL? 
12APPROVEDTIMEDate Checked (Date+Time)decimal150DEC((0))YesICL_PAYMENT15UTC
13TRANSFERTIMETransfer Date to Collections/Disbursements (Date+Time)decimal150DEC((0))YesICL_PAYMENT17UTC
14DOCUMENTREFReference for Payment Document Created in Subledgernvarchar140CHAR(N' ')YesICL_DOCUMENTREF Allow NULL? 
15POSTDATEPosting Datenvarchar80DATS(N'00000000')YesICL_POSTDATE Allow NULL? 
16DOCDATEDocument Date of Paymentnvarchar80DATS(N'00000000')YesICL_DOCDATE Allow NULL? 
17DUEDATEDue Date for Net Paymentnvarchar80DATS(N'00000000')YesICL_DUEDATENET Allow NULL? 
18XALREADYPAIDPayment Already Madechar10CHAR(N' ')YesICL_ALREADYPAID Allow NULL? 
19PAYCATRecord Type of Paymentchar10CHAR(N' ')YesICL_PAYCAT Allow NULL? 
20PAYTYPEPayment Type (Final Payment, Payment After Closure of Claim)char10CHAR(N' ')YesICL_PAYTYPE Allow NULL? 
21SUBSALSubrogation/Salvagenvarchar30NUMC(N'000')YesICL_SUBSAL Allow NULL? 
22XPAYEEAdditional Payee (ICLPAYEE)char10CHAR(N' ')YesICL_XPAYEE Allow NULL? 
23ADDRNUMBERAddress Number for Checksnvarchar100CHAR(N' ')YesADRCICL_ADDRNUM Allow NULL? 
24CRECADDRAddress Number for Checksnvarchar100CHAR(N' ')Yes*ICL_ADDRNUM Allow NULL? 
25BKIDBank Details IDnvarchar40CHAR(N' ')YesBUT0BKICL_BKID Allow NULL? 
26CURRClaim Payment Currencynvarchar50CUKY(N' ')YesTCURCICL_PAYMENTCUR Allow NULL? 
27EXCHRATEExchange Rate of Payment Currency into Policy Currencydecimal95DEC((0))YesICL_PAYMENT18
28STATUSInternal Payment Status (Database Status)nvarchar20CHAR(N' ')YesICL_PAYMENT12 Allow NULL? 
29METHODPayment Methodchar10CHAR(N' ')YesTFK042ZICL_PAYMENT01 Allow NULL? 
30CHECKNUMBERCheck Number for Manual Check Paymentsnvarchar130CHAR(N' ')YesICL_CHECK Allow NULL? 
31NOTEPayment Notenvarchar500CHAR(N' ')YesICL_PAYMENT04 Allow NULL? 
32INVOICEREFExternal Invoice Numbernvarchar200CHAR(N' ')YesICL_INVOICEREF Allow NULL? 
33REFCLAIMClaim Number (Reassignment Reference)nvarchar170CHAR(N' ')Yes*ICL_CLAIM_REFPAY Allow NULL? 
34REFSUBCLAIMSubclaim (Reassignment Reference)nvarchar30CHAR(N' ')Yes*ICL_SUBCL_REFPAY Allow NULL? 
35REFPAYMENTClaim Payment (Reassignment Reference)nvarchar50NUMC(N'00000')Yes*ICL_PAYMENT_REFPAY Allow NULL? 
36AMTDONEAmount Paid or Receiveddecimal152CURR((0))YesICL_AMOUNT_DONE
37LIABRATENegotiated Liability Rate in Percentdecimal52DEC((0))YesICL_LIABRATE_NEG
38AMTNEGAmount Negotiateddecimal152CURR((0))YesICL_AMOUNTNEG
39SUBROSTATUSLegal Status of Subrogation/Recoverychar10CHAR(N' ')YesICL_SUBROSTATUS Allow NULL? 
40TAXROLETax Role of Claim Payment Recipientnvarchar40CHAR(N' ')Yes*ICL_TAXROLE Allow NULL? 
41TAX_RPTFlag for Reportable Paymentschar10CHAR(N' ')YesICL_TAXRPT Allow NULL? 
42XTAXRPTCTCode for Withholding Tax in Statutory Reporting Categorychar10CHAR(N' ')YesICL_XTAXRPTCT Allow NULL? 
43MTAXRPTCTWithholding Tax Code for Statutory Reportingnvarchar20CHAR(N' ')Yes*ICL_TAXRPTCT Allow NULL? 
44OVRD_TAXRPTCTManual Withholding Tax Codechar10CHAR(N' ')YesICL_OVRDTAXRPTCT Allow NULL? 
45FUNDSRECDTSalvage: Funds Receivednvarchar80DATS(N'00000000')YesICL_SALVFUNDREC Allow NULL? 
46XSALVESTENDEnd Estimation of Salvage Valuechar10CHAR(N' ')YesICL_XSALVESTEND Allow NULL? 
47OWNERTYPE_GRPResponsible Organization Categorynvarchar20CHAR(N' ')Yes*ICL_OWNERTYPE_GRP3 Allow NULL? 
48OWNER_GRPResponsible Organizational Unitnvarchar120CHAR(N' ')Yes*ICL_OWNER_GRP3 Allow NULL? 
49REASONREJRejection Reasons for Payments and Reservesnvarchar20CHAR(N' ')YesTICL112ICL_REASONREJ Allow NULL? 
50REFEXTSDOCReferenced Statistical Payment Entrynvarchar50NUMC(N'00000')Yes*ICL_REFEXTSDOC Allow NULL? 
51MOSMethod of Settlementnvarchar30CHAR(N' ')Yes*ICL_MOS Allow NULL? 
52CL_PAYFREQPLANPayment Frequency of Scheduled Paymentnvarchar20CHAR(N' ')YesTVS010BICL_PAYFREQPLAN Allow NULL? 
53PMTTOEnd Date of a Scheduled Paymentnvarchar80DATS(N'00000000')YesICL_PMTTO Allow NULL? 
54PMTFRStart Date of a Scheduled Paymentnvarchar80DATS(N'00000000')YesICL_PMTFR Allow NULL? 
55SCHEDTYPEType of Scheduled Paymentnvarchar20CHAR(N' ')YesTICL180ICL_SCHEDULE_TYPE Allow NULL? 
56NROFINVREQMininum Number of Inbound Invoicesnvarchar20NUMC(N'00')YesICL_INVOICES_REQUIRED Allow NULL? 
57DAMAGEDOBJDamaged Objectnvarchar40NUMC(N'0000')Yes*ICL_DAMOBJ Allow NULL? 
58MIGRATIONIndicator for Migrated Paymentschar10CHAR(N' ')YesICL_PAYMIGRATION Allow NULL? 
59REQEVALCATDetermination Category of Receivable Amountchar10CHAR(N' ')YesICL_REQEVALCAT_D_PE Allow NULL? 
60ASSIGN_GUIDUUID of Entry to be Linkednvarchar320CHAR(N' ')YesICL_ASSIGN_GUID Allow NULL? 
61PAYOUT_SCENARIORepetitive Payment Scenariochar10CHAR(N' ')YesICL_PAYOUT_SCENARIO_D Allow NULL? 
62SERV_FROMService Start Datenvarchar80DATS(N'00000000')YesICL_SERVFR Allow NULL? 
63SERV_TOService End Datenvarchar80DATS(N'00000000')YesICL_SERVTO Allow NULL? 
64XREPPAYPayment Creation from Repetitive Payment Recordchar10CHAR(N' ')YesICL_XREPPAY_D_AL Allow NULL? 
65ALTPOSTTARGETAlternative Posting Targetnvarchar500CHAR(N' ')YesICL_ALTPOSTTARGET_D Allow NULL? 
66GROSS_NET_PAYMENTGross/Net payment indicatorchar10CHAR(N' ')Yes/GSINS/INSH_GROSS_NET_PAYMENT Allow NULL? 
67HCM_PAYMENT_STATEPayment Processing State Indicator on the HCM systemchar10CHAR(N' ')Yes/GSINS/INSH_HCM_PAYMENT_STATE Allow NULL? 
NamePrimaryUniqueTypeColumns
ICSPAY~0YesYesCLUSTEREDCHANGETIME, PAYMENT, 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