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  | TICL003
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
9BSEG345Accounting Document Segment
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.0TICL003641Internal Claim Type VersionClaims Management
SQL:  selectupdate insert create

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

SELECT CLIENT, CLTYPE, GENERAT, VERSION, ACTIVE, CHANGEDBY, CHANGETIME, INACTIVETIME, EFFFROMTIME, EFFTOTIME, TERMTIME, DELETED, OVERSION, OSYSID, OMANDT, BVERSION, CURR, COMPLEX, DEFLTPOST, GFUNCTION, CDSPEC_CLAIM, XDUBLCHECK, LOSDATDEV, XNOPREMCHK, XPREMINCCI, MAXOSPRMA, MAXOSPRMD, POLBTOLH, POLETOLH, COVBTOLH, COVETOLH, DEDUCAMTTOL, DEDUCPERTOL, STATCLAIMVR, STATSUBCLVR, STATPAYVR, STATLITHVR, STATLITIVR, STATNEG, NOCLXSUBCL, NOCLNSUBCL, XREOPENNOCLM, INVOICE_GET_PROC, PROCESS, CCTYPE, INVTYPE_REQ, SCHEDCAT, DATELOSSCHK, POLNEWIMP, POLNUMCHK, REQFLDCHECK, CLAI_ATTRIB, RCOVERCHECK, COVERREJR, CLAIMACLOSE, XF4PRODCOVTYPES, SPLIT_REQUIRED, XCCALC_SUPP_PS, ROLE, INIT_SEND_DAYS, INIT_SEND_EXPR, DFLT_SRCH_MNTH, RE_SRCH_MNTHS, RE_SRCH_EXPR FROM TICL003
ColumnFieldDescriptionSQL TypeLengthDecimalsRelationDefault ValueConstraintsSQL Create Statement
1CLIENTClientnvarchar30 Allow NULL? 
2CLTYPEInternal Claim Typenvarchar40 Allow NULL? 
3GENERATGeneration of Internal Claim Typenvarchar50 Allow NULL? 
4VERSIONInternal Claim Type Versionnvarchar50 Allow NULL? 
5ACTIVEStatuschar10 Allow NULL? 
6CHANGEDBYVersion Created By (= Object Changed By)nvarchar120 Allow NULL? 
7CHANGETIMEVersion Created: Date + Timedecimal150
8INACTIVETIMEVersion Deactivated: Date + Timedecimal150
9EFFFROMTIMEVersion Valid From: Date + Timedecimal150
10EFFTOTIMEVersion Valid To: Date + Timedecimal150
11TERMTIMEValid-To Date Set: Date + Timedecimal150
12DELETEDFlag: Deletion Entry?char10 Allow NULL? 
13OVERSIONVersion in Original Systemnvarchar50 Allow NULL? 
14OSYSIDOriginal System of Versionnvarchar80 Allow NULL? 
15OMANDTClient in Original Systemnvarchar30 Allow NULL? 
16BVERSIONBasis Versionnvarchar50 Allow NULL? 
17CURRCurrency for All Amount Fields of Internal Claim Typenvarchar50 Allow NULL? 
18COMPLEXStandard Complexity for All Claims of This Typechar10 Allow NULL? 
19DEFLTPOSTStandard Data for FS-CD Documentnvarchar20 Allow NULL? 
20GFUNCTIONGroup of Deactivated Functionsnvarchar40 Allow NULL? 
21CDSPEC_CLAIMSample Template for Contract Acct for Insurance Obj. Claimnvarchar40 Allow NULL? 
22XDUBLCHECKCheck for Duplicateschar10 Allow NULL? 
23LOSDATDEVClaim Date in Check for Duplications: Max.Deviation in Daysnvarchar20 Allow NULL? 
24XNOPREMCHKNo Premium Checkchar10 Allow NULL? 
25XPREMINCCIIgnore Premiums Paid Subsequentlychar10 Allow NULL? 
26MAXOSPRMAMaximum Tolerated Outstanding Premiumsdecimal152
27MAXOSPRMDMaximum Number of Days for Which Premium May Be Outstandingnvarchar30 Allow NULL? 
28POLBTOLHTolerance Limit in Hours Before Contract Inceptionnvarchar40 Allow NULL? 
29POLETOLHTolerance Limit in Hours After Contract Endnvarchar40 Allow NULL? 
30COVBTOLHTolerance Limit in Hours for Start of Coveragenvarchar40 Allow NULL? 
31COVETOLHTolerance Limit in Hours After End of Coveragenvarchar40 Allow NULL? 
32DEDUCAMTTOLMaximum Tolerated Outstanding Deductibledecimal152
33DEDUCPERTOLMaximum Tolerated Outstanding Deductible in Percentdecimal20
34STATCLAIMVRValue Request for Setting Claim Statusnvarchar200 Allow NULL? 
35STATSUBCLVRValue Request for Setting Subclaim Statusnvarchar200 Allow NULL? 
36STATPAYVRValue Request for Setting Payment Statusnvarchar200 Allow NULL? 
37STATLITHVRValue Request for Setting Litigation Statusnvarchar200 Allow NULL? 
38STATLITIVRValue Request for Setting Litigation Level Statusnvarchar200 Allow NULL? 
39STATNEGValue Request for Setting Negotiation Statusnvarchar200 Allow NULL? 
40NOCLXSUBCLSubclaim Exists: No Claim Made?char10 Allow NULL? 
41NOCLNSUBCLNo Subclaim Exists: No Claim Made?char10 Allow NULL? 
42XREOPENNOCLMOnly Reoopen Subclaim if No Claim Madechar10 Allow NULL? 
43INVOICE_GET_PROCProcedure for Determination of Invoice Items fr. Appvl Itemschar10 Allow NULL? 
44PROCESSBusiness Process of Internal Claim Typenvarchar20 Allow NULL? 
45CCTYPEClaim Bundle Type of Collective Invoicenvarchar20 Allow NULL? 
46INVTYPE_REQInvoice Type for Receivablenvarchar30 Allow NULL? 
47SCHEDCATCategory of Scheduled Paymentchar10 Allow NULL? 
48DATELOSSCHKPermitted Claim Date Detailschar10 Allow NULL? 
49POLNEWIMPNew Contract Version Imported Without Querychar10 Allow NULL? 
50POLNUMCHKPermitted Contract Numbers When Creating a Claimchar10 Allow NULL? 
51REQFLDCHECKSetting Regarding When Required Field Check Is Performedchar10 Allow NULL? 
52CLAI_ATTRIBNumber of Permitted Claimants in a Claimnvarchar20 Allow NULL? 
53RCOVERCHECKRenewed Check of Coverage Assignmentchar10 Allow NULL? 
54COVERREJRRejection of Claim Item Due to Lack of Coveragenvarchar20 Allow NULL? 
55CLAIMACLOSEClaim Remains Open After Closure of Last Subclaimchar10 Allow NULL? 
56XF4PRODCOVTYPESDisplay All Coverage Types of Product in F4 Input Helpchar10 Allow NULL? 
57SPLIT_REQUIREDSplit After Versions of Claim Type?char10 Allow NULL? 
58XCCALC_SUPP_PSSwitch On/Off Compensation Calculationchar10 Allow NULL? 
59ROLEParticipant Role Required Directly in Claim Creationnvarchar40 Allow NULL? 
60INIT_SEND_DAYSNumber of Days From Claim Opened to Initial Sendnvarchar40 Allow NULL? 
61INIT_SEND_EXPRBRFplus Expression for Claim Investigation Initial Sendnvarchar200 Allow NULL? 
62DFLT_SRCH_MNTHDefault Search Period of Ext. Claim Investigation Providernvarchar40 Allow NULL? 
63RE_SRCH_MNTHSTime Period (in Months) for Automatic Re-Searchnvarchar40 Allow NULL? 
64RE_SRCH_EXPRBRFplus Expression for Automatic Re-Searchnvarchar200 Allow NULL? 
NamePrimaryUniqueTypeColumns
TICL003~0YesYesCLUSTEREDCLIENT, CLTYPE, GENERAT, VERSION

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