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  | CMS_INS
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 :: Collateral Management System :: Master Data :: Rights
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0CMS_INS822Insurance Application TableRights
SQL:  selectupdate insert create

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

SELECT MANDT, INS_GUID, INS_CATEGORY, INS_TYP, INS_ID, INS_DESC, INSUR_TAX_DB, SETLMNT_TYPE, INSUR_SUM, INSUR_CURR, PRM_RT, INSUR_PREMIUM, INSUR_PRM_CURR, INSUR_TAX_RT, INSUR_TAX_AMT, INSUR_TAX_CURR, SCOPE_INS_COVER, EXT_ITM_NO, EXT_REFERENCE, FOP, FREQ_UNIT, INS_CODE, ORIG_COUNTRY, ORIG_REGION, AUTO_CANCEL_DT, PRM_TYPE, PRM_VALID_FROM, PAYMNT_METHOD, PAYMNT_INFO, LAST_PAYMENT_DT, NXT_PAYMENT_DT, STATEMENT_DT, REBATE_METHOD, PORTFOLIO, MAX_AGE_LIMIT, MAX_COVER_AMT, MIN_COVER_AMT, IND_INSURED_EVNT, INSURED_EVENT_DT, IND_FORCE_PLACED, IND_TAX_DEDUCT, INACTIVE_REASON, POLICY_STATUS, INS_STRT_DAT, INSUR_EXPY_DAT, REQD_INSUR_CVR, REQD_INSUR_CURR, INSURER_NAM, INSURER_INF, COVER_MKT, SHARE_CVR_MKT, SH_CVR_MKT_CUR, CONTACT_FIRM, CONTACT_PARTNER, TARRIF, CONTRACT_STRT_DT, CONTRACT_END_DT, CONTRACT_CON_DT, INSUR_STATUS, INSUR_STATUS_DT, SUM_ONE_TM_CON, ONE_TM_CON_CKY, DYNAMICS, PER_DYNAMICS, TERMIN_PRD, TERM_PRD_UNIT, RECALL_PRD, RECALL_PRD_UNIT, INS_SUM_SRVL, INS_SUM_SRVL_CKY, INS_SUM_DTH, INS_SUM_DTH_CKY, INS_BENF_EXP, INS_BENF_EXP_CKY, DT_PROB_BEN_EXP, ADMIN_ORG_UNIT, BANKAREA, CREATED_BY, CREATED_AT, CHANGED_BY, CHANGED_AT, SOURCEOFENTRY FROM CMS_INS
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')No*MANDT Allow NULL? 
2INS_GUIDInsurance GUIDvarbinary160RAWNoCMS_DTE_INS_GUID
3INS_CATEGORYObject Categorynvarchar60CHAR(N' ')Yes*CMS_DTE_OMS_OBJ_CAT Allow NULL? 
4INS_TYPInsurance Typenvarchar60CHAR(N' ')Yes*CMS_DTE_INS_TYPE Allow NULL? 
5INS_IDInsurance IDnvarchar400CHAR(N' ')YesCMS_DTE_INS_ID Allow NULL? 
6INS_DESCInsurance Descriptionnvarchar300CHAR(N' ')YesCMS_DTE_INS_DESC Allow NULL? 
7INSUR_TAX_DBInsurance tax to the debit of the bankchar10CHAR(N' ')YesCMS_DTE_INS_TAX_DB Allow NULL? 
8SETLMNT_TYPEType of settlementnvarchar60CHAR(N' ')YesTCMS_ATT_ID_TYCMS_DTE_INS_SETLMNT_TYPE Allow NULL? 
9INSUR_SUMInsurance Sumdecimal172CURR((0))YesCMS_DTE_INS_SUM
10INSUR_CURRInsurance Currencynvarchar50CUKY(N' ')YesTCURCCMS_DTE_INS_CURR Allow NULL? 
11PRM_RTPremium Ratedecimal107DEC((0))YesCMS_DTE_INS_PRM_RT
12INSUR_PREMIUMInsurance Premiumdecimal172CURR((0))YesCMS_DTE_INS_PRM
13INSUR_PRM_CURRInsurance Currencynvarchar50CUKY(N' ')YesTCURCCMS_DTE_INS_CURR Allow NULL? 
14INSUR_TAX_RTInsurance tax rate (in %)decimal107DEC((0))YesCMS_DTE_INS_TAX_RT
15INSUR_TAX_AMTInsurance tax amountdecimal172CURR((0))YesCMS_DTE_INS_TAX_AMT
16INSUR_TAX_CURRTax Currencynvarchar50CUKY(N' ')YesTCURCCMS_DTE_INS_TAX_CURR Allow NULL? 
17SCOPE_INS_COVERnot used -> package has to be changed CMS_OMS_INSnvarchar60CHAR(N' ')YesCMS_DTE_INS_COVER Allow NULL? 
18EXT_ITM_NOExt. Item no / Number for identification of the objectsnvarchar400CHAR(N' ')YesCMS_DTE_OMS_EXT_ITM_NO Allow NULL? 
19EXT_REFERENCEReference number for the legacy systemnvarchar320CHAR(N' ')YesCMS_DTE_OMS_REF_ID Allow NULL? 
20FOPFrequency of Paymentnvarchar40NUMC(N'0000')YesCMS_DTE_INS_FOP Allow NULL? 
21FREQ_UNITIndicator: Units of time for revaluationnvarchar20CHAR(N' ')YesCMS_DTE_INS_FREQ_UNIT Allow NULL? 
22INS_CODEInsurance Product Codenvarchar60CHAR(N' ')YesCMS_DTE_INS_CODE Allow NULL? 
23ORIG_COUNTRYCountry where Insurance was purchasednvarchar30CHAR(N' ')YesT005CMS_DTE_INS_ORIG_COUNTRY Allow NULL? 
24ORIG_REGIONRegion where Insurance was purchasednvarchar30CHAR(N' ')YesT005SCMS_DTE_INS_ORIG_REGION Allow NULL? 
25AUTO_CANCEL_DTAuto Cancellation Date for an Insurance Policynvarchar80DATS(N'00000000')YesCMS_DTE_INS_AUTO_CANCEL_DT Allow NULL? 
26PRM_TYPEType of Premiumnvarchar20CHAR(N' ')YesCMS_DTE_INS_PRM_TYPE Allow NULL? 
27PRM_VALID_FROMDate from when specified Premium is validnvarchar80DATS(N'00000000')YesCMS_DTE_INS_PRM_VALID_FROM_DT Allow NULL? 
28PAYMNT_METHODPayment method for premiumsnvarchar20CHAR(N' ')YesCMS_DTE_INS_PAYMENT_METHOD Allow NULL? 
29PAYMNT_INFOPayment Info for an insurance policynvarchar300CHAR(N' ')YesCMS_DTE_INS_PAY_INFO Allow NULL? 
30LAST_PAYMENT_DTDate when last premium payment was madenvarchar80DATS(N'00000000')YesCMS_DTE_INS_LAST_PAYMENT_DT Allow NULL? 
31NXT_PAYMENT_DTNext Payment Date when insurance premium is duenvarchar80DATS(N'00000000')YesCMS_DTE_INS_NXT_PAYMENT_DT Allow NULL? 
32STATEMENT_DTDate when statements for Policy was madenvarchar80DATS(N'00000000')YesCMS_DTE_INS_STATEMENT_DT Allow NULL? 
33REBATE_METHODIdentifier for the rebate method used to calculate refundsnvarchar60CHAR(N' ')YesTCMS_INS_REBCMS_DTE_INS_REBATE_METHOD_ID Allow NULL? 
34PORTFOLIOInsurance Portfolionvarchar60CHAR(N' ')YesTCMS_INS_PORTCMS_DTE_INS_PORTFOLIO Allow NULL? 
35MAX_AGE_LIMITMaximum age limit for Policy Validitytinyint30INT1((0))YesCMS_DTE_INS_MAX_AGE_LIMIT
36MAX_COVER_AMTMaximum Coverage Amountdecimal172CURR((0))YesCMS_DTE_INS_MAX_COVER_AMT
37MIN_COVER_AMTMinimum Coverage Amountdecimal172CURR((0))YesCMS_DTE_INS_MIN_COVER_AMT
38IND_INSURED_EVNTBoolean indicator that insured event occured (X = Occured)char10CHAR(N' ')YesCMS_DTE_IND_INSURED_EVENT Allow NULL? 
39INSURED_EVENT_DTDate when Insured Event Occurednvarchar80DATS(N'00000000')YesCMS_DTE_INSURED_EVENT_DT Allow NULL? 
40IND_FORCE_PLACEDIs Insurance Force Placed? (Default = No)nvarchar20CHAR(N' ')YesCMS_DTE_INS_IND_FORCE_PLACE Allow NULL? 
41IND_TAX_DEDUCTIndicator that Insurance Policy is Tax Deductiblenvarchar20CHAR(N' ')YesCMS_DTE_INS_IND_TAX_DEDUCT Allow NULL? 
42INACTIVE_REASONReason for inactivating insurance policynvarchar20CHAR(N' ')YesTCMS_INS_SRSNCMS_DTE_INS_INACTIVE_REASON Allow NULL? 
43POLICY_STATUSInsurance Policy Statusnvarchar20CHAR(N' ')YesCMS_DTE_INS_POLICY_STATUS Allow NULL? 
44INS_STRT_DATStart date of insurancenvarchar80DATS(N'00000000')YesCMS_DTE_INS_STRT_DAT Allow NULL? 
45INSUR_EXPY_DATDate of expiry of insurancenvarchar80DATS(N'00000000')YesCMS_DTE_INS_EXPY_DAT Allow NULL? 
46REQD_INSUR_CVRRequired insurance coverdecimal172CURR((0))YesCMS_DTE_INS_REQD_CVR
47REQD_INSUR_CURRInsurance Currencynvarchar50CUKY(N' ')YesTCURCCMS_DTE_INS_CURR Allow NULL? 
48INSURER_NAMName of the insurernvarchar300CHAR(N' ')YesCMS_DTE_INS_INSUR_NAM Allow NULL? 
49INSURER_INFRemarks on insurernvarchar300CHAR(N' ')YesCMS_DTE_INS_INSUR_INF Allow NULL? 
50COVER_MKTCover Marketnvarchar30CHAR(N' ')Yes*CMS_DTE_INS_COVER_MKT Allow NULL? 
51SHARE_CVR_MKTShare of cover marketdecimal172CURR((0))YesCMS_DTE_INS_SH_CVR_MKT
52SH_CVR_MKT_CURCurrency for Share of Cover Marketnvarchar50CUKY(N' ')Yes*CMS_DTE_INS_SH_CVR_MKT_CUR Allow NULL? 
53CONTACT_FIRMContact firmnvarchar300CHAR(N' ')YesCMS_DTE_INS_CON_FRM Allow NULL? 
54CONTACT_PARTNERContact partnernvarchar300CHAR(N' ')YesCMS_DTE_INS_CON_PRT Allow NULL? 
55TARRIFInsurance tariffnvarchar300CHAR(N' ')YesCMS_DTE_INS_TARRIF Allow NULL? 
56CONTRACT_STRT_DTContract begin datenvarchar80DATS(N'00000000')YesCMS_DTE_INS_CNTRT_STRT_DT Allow NULL? 
57CONTRACT_END_DTContract end datenvarchar80DATS(N'00000000')YesCMS_DTE_INS_CNTRT_END_DT Allow NULL? 
58CONTRACT_CON_DTDate of conclusion of contractnvarchar80DATS(N'00000000')YesCMS_DTE_INS_CNTRT_CON_DT Allow NULL? 
59INSUR_STATUSStatus of insurancenvarchar60CHAR(N' ')YesTCMS_ATT_ID_TYCMS_DTE_INS_STATUS Allow NULL? 
60INSUR_STATUS_DTStatus date of insurancenvarchar80DATS(N'00000000')YesCMS_DTE_INS_STATUS_DT Allow NULL? 
61SUM_ONE_TM_CONSum of one time contributiondecimal172CURR((0))YesCMS_DTE_INS_SUM_ONE_TM_CON
62ONE_TM_CON_CKYCurrencynvarchar50CUKY(N' ')YesTCURCCMS_DTE_INS_ONE_TM_CON_CKY Allow NULL? 
63DYNAMICSDynamicschar10CHAR(N' ')YesCMS_DTE_INS_DYNAMICS Allow NULL? 
64PER_DYNAMICSPercentage of the dynamicsdecimal106DEC((0))YesCMS_DTE_INS_PER_DYNAMICS
65TERMIN_PRDTermination periodnvarchar40NUMC(N'0000')YesCMS_DTE_INS_TERMIN_PRD Allow NULL? 
66TERM_PRD_UNITIndicator: Units of termination periodnvarchar20CHAR(N' ')YesCMS_DTE_INS_TERM_PRD_UNIT Allow NULL? 
67RECALL_PRDRecall periodnvarchar40NUMC(N'0000')YesCMS_DTE_INS_RECALL_PRD Allow NULL? 
68RECALL_PRD_UNITIndicator: Units of Recall Periodnvarchar20CHAR(N' ')YesCMS_DTE_INS_RECALL_PRD_UNIT Allow NULL? 
69INS_SUM_SRVLInsurance sum incase of survivaldecimal172CURR((0))YesCMS_DTE_INS_SUM_IN_SURVIVAL
70INS_SUM_SRVL_CKYInsurance survival Currencynvarchar50CUKY(N' ')YesTCURCCMS_DTE_INS_SUM_IN_SURVIVL_CKY Allow NULL? 
71INS_SUM_DTHInsurance sum in case of deathdecimal172CURR((0))YesCMS_DTE_INS_SUM_IN_DEATH
72INS_SUM_DTH_CKYDeath benefit currencynvarchar50CUKY(N' ')YesTCURCCMS_DTE_INS_SUM_IN_DEATH_CKY Allow NULL? 
73INS_BENF_EXPProbable benefit on expirydecimal172CURR((0))YesCMS_DTE_INS_PROB_BENF
74INS_BENF_EXP_CKYCurrency for probable benefit on expirynvarchar50CUKY(N' ')YesTCURCCMS_DTE_INS_PROB_BENF_CKY Allow NULL? 
75DT_PROB_BEN_EXPDate of probable benefit on expirynvarchar80DATS(N'00000000')YesCMS_DTE_INS_DT_PRO_BEN_EXP Allow NULL? 
76ADMIN_ORG_UNITAdministration Organizational Unitnvarchar120CHAR(N' ')YesCMS_DTE_ADMINORG Allow NULL? 
77BANKAREABank Area in Collateral Managementnvarchar40CHAR(N' ')Yes*CMS_DTE_BANKAREA Allow NULL? 
78CREATED_BYLogin ID of the User who created the Recordnvarchar120CHAR(N' ')YesCMS_DTE_USER Allow NULL? 
79CREATED_ATCreation Timestampdecimal150DEC((0))YesCMS_DTE_CREATED_AT
80CHANGED_BYLast Changed Bynvarchar120CHAR(N' ')YesCMS_DTE_LAST_CHNG_USER Allow NULL? 
81CHANGED_ATChange Timestampdecimal150DEC((0))YesCMS_DTE_CHANGED_AT
82SOURCEOFENTRYSource of Entrynvarchar320CHAR(N' ')YesCMS_DTE_SOURCE_OF_ENTRY Allow NULL? 
NamePrimaryUniqueTypeColumns
CMS_INS~0YesYesCLUSTEREDINS_GUID, MANDT
CMS_INS~SKYNoNoNONCLUSTEREDINS_ID, INS_TYP, INS_CATEGORY, 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