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  | ICL_WCMPD
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)
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
10OINM101Whse Journal
Financial Services :: Claims Management
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0ICL_WCMPD352FS-CM: Item Data Workers CompensationClaims Management
SQL:  selectupdate insert create

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

SELECT MANDT, ACTIVE, CLAIM, SUBCLAIM, WCMPH_SEQNUM, WCMPD_SEQNUM, CHANGETIME, CHANGEDBY, DELETED, ITEMCAT, CURRENCY, SAWW, MIN_BEN, MAX_BEN, PERCENT, MAX_PERIOD, MAX_TOTAL, PAYMENT_AMT, PAY_AMT_OFF, NUMFULLPAYM, NUMPARTPAYM, PAYM_PARTIAL, BENEFIT_OFFSET, RETRO_AMT, PMTFR, PMTTO, PAYM_TOTAL, BURIAL_AMOUNT, TRANSPORTN_MAX, LUMP_SUM, TOTAL_AMT, CHLD_MAX_AGE, STDNT_MAX_AGE, SCHEDULED_PERIOD, SCHEDULED_UNIT FROM ICL_WCMPD
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')No*MANDT Allow NULL? 
2ACTIVETable entry is active (A) or in suspense (S)char10CHAR(N' ')NoICL_ACTIVE Allow NULL? 
3CLAIMNumber of Claimnvarchar170CHAR(N' ')No*ICL_CLAIM Allow NULL? 
4SUBCLAIMSubclaimnvarchar30CHAR(N' ')No*ICL_SUBCL Allow NULL? 
5WCMPH_SEQNUMSequence Number of Header Datanvarchar320CHAR(N' ')NoICL_WCMP_SEQNUM Allow NULL? 
6WCMPD_SEQNUMDetail Sequence Numbernvarchar320CHAR(N' ')NoICL_WCMP_DET_SEQNUM Allow NULL? 
7CHANGETIMEChanged: Date + Timedecimal150DEC((0))YesICL_CHANGEUTC1
8CHANGEDBYChanged Bynvarchar120CHAR(N' ')YesUSR02ICL_CHANGEDBY Allow NULL? 
9DELETEDDatabase Line Status (Original, Changed, Deleted)char10CHAR(N' ')YesICL_RECSTATUS Allow NULL? 
10ITEMCATWorkers Compensation Item Categorynvarchar20CHAR(N' ')YesICL_WCMP_ITEMCAT Allow NULL? 
11CURRENCYCurrencynvarchar50CUKY(N' ')Yes*ICL_CURRENCY Allow NULL? 
12SAWWState Average Weekly Wage (AWW)decimal152CURR((0))YesICL_SAWW_AMT
13MIN_BENMinimum Amountdecimal152CURR((0))YesICL_MIN_AMT
14MAX_BENMaximum Amountdecimal152CURR((0))YesICL_MAX_AMT
15PERCENTPercentage of Wage Paid as Benefitdecimal107DEC((0))YesICL_WCMP_PERCENT
16MAX_PERIODMaximum Benefit Period in Weeksnvarchar40NUMC(N'0000')YesICL_MAXPRD Allow NULL? 
17MAX_TOTALMaximum Payment Amountdecimal152CURR((0))YesICL_MAX_PYMNT
18PAYMENT_AMTWeekly Payment Amountdecimal152CURR((0))YesICL_WCMP_TOPAY
19PAY_AMT_OFFPayment Amount After Offsetdecimal152CURR((0))YesICL_WCMP_PAY_AMT_OFF
20NUMFULLPAYMNumber of Full Weeksnvarchar40NUMC(N'0000')YesICL_NUMFULLPAYM Allow NULL? 
21NUMPARTPAYMNumber of Days Remainingnvarchar40NUMC(N'0000')YesICL_NUMPARTPAYM Allow NULL? 
22PAYM_PARTIALAmount of Partial Paymentdecimal152CURR((0))YesICL_PAYM_PARTIAL
23BENEFIT_OFFSETAmount Offsetdecimal152CURR((0))YesICL_WCMP_OFFSET
24RETRO_AMTRetroactive Payment Amountdecimal152CURR((0))YesICL_WCMP_RETRO_AMT
25PMTFRStart of Validity Period of a Recurring Paymentnvarchar80DATS(N'00000000')YesICL_PMTFR_REP Allow NULL? 
26PMTTOEnd of Validity Period of a Recurring Paymentnvarchar80DATS(N'00000000')YesICL_PMTTO_REP Allow NULL? 
27PAYM_TOTALTotal Amount of Paymentdecimal152CURR((0))YesICL_PAYM_TOTAL
28BURIAL_AMOUNTWorkers Compensation: Burial Amountdecimal152CURR((0))YesICL_BURIAL_AMT
29TRANSPORTN_MAXMaximum Amount for Transportdecimal152CURR((0))YesICL_TRNSPT_MAX
30LUMP_SUMLump Sumdecimal152CURR((0))YesICL_LUMP_SUM
31TOTAL_AMTTotal Amount of Paymentdecimal152CURR((0))YesICL_WCMP_SRVR_TOT
32CHLD_MAX_AGEMaximum Age of Childnvarchar40NUMC(N'0000')YesICL_CHILD_MAX_AGE Allow NULL? 
33STDNT_MAX_AGEMaximum Age for Studentnvarchar40NUMC(N'0000')YesICL_STDNT_MAX_AGE Allow NULL? 
34SCHEDULED_PERIODScheduled Period for Payment of Injuriesdecimal103QUAN((0))YesICL_WCMP_SCHEDULED_PERIOD
35SCHEDULED_UNITUnit for Compensationnvarchar30UNIT(N' ')Yes*ICL_WCMP_SCH_COMP_UNIT Allow NULL? 
NamePrimaryUniqueTypeColumns
ICL_WCMPD~0YesYesCLUSTEREDWCMPD_SEQNUM, WCMPH_SEQNUM, SUBCLAIM, CLAIM, ACTIVE, MANDT
ICL_WCMPD~I0NoNoNONCLUSTEREDWCMPH_SEQNUM, MANDT

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