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

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
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0CMS_CAG1093Collateral Agreement DetailsMaster Data
SQL:  selectupdate insert create

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

SELECT MANDT, CAG_GUID, CAGMTID, CAGMT_TYPE, NOM_VALUE, NOM_VALUE_CURR, ASMT_AMT, ASMT_CURR, ASMT_DATE, CAGMT_DATE, VALID_FROM, VALID_TO, ADMIN_ORG_UNIT, BANKAREA, COUNTRY_KEY, FLG_GLOBAL, SPL_MARKDOWN_PCT, SPL_MARKDOWN_AMT, SPL_MRKDOWN_CURR, DESCRIPTION, UNIT_REL_FREQ, PERIOD_REL_FREQ, OLD_CAGMTID, MIN_QL_EXCEP_TYP, MIN_QL_REASON, FLG_MIN_QL_REQMT, MIN_QL_CRITE, PCT_ASSET_VAL, TERM_RIGHT_TYP, FIRST_TERM_DATE, UNIT_TERM_FREQ, PERIOD_TERM_FREQ, NOTICE_PRD_UNIT, REQ_NOTICE_PRD, TERM_NOTICE_DATE, TERM_REASON, TERM_GUAR_AMT, TERMINATION_CURR, GUAR_RATE, FLG_COUNTER_GUAR, FLG_CO_GUAR, FLG_FIXED_LIABTY, FLG_DEF_LIABTY, PCT_DEF_LIABTY, FLG_INCL_CAG_LNK, IND_APPR_AUTH, FLG_ENFORCEABLE, LENDING_RATE, UNIT_REDU_FREQ, PERIOD_REDU_FREQ, REDU_AMT, REDU_CURR, REDU_PCT, REDU_START_DATE, REDU_END_DATE, REDU_LAST_DATE, FLG_LEASING_TXN, IND_LESSOR_LIEN, IND_ACC_LIABLE, FLG_ASGMT_AR, MIN_STOCK_AMT, MIN_STOCK_CURR, FLG_ADDNL_RBL, ADDNL_RBL_DATE, IND_GBC_LIEN, FLG_DISCL, DISCL_DATE, ASGMT_REASON, INT_RATE, INCIDENTAL_PAYMT, UNIT_PMT_FREQ, PERIOD_PMT_FREQ, INT_START_DATE, NUM_YR_LCHG_INT, IND_ENFORCMT_TYP, ENFORCMT_AMT, ENFORCMT_CURR, REF_ENFORCMT_AMT, RANK, ENFORCMT_TITLE, UNIT_INT_FREQ, PERIOD_INT_FREQ, FLG_INTEREST_INC, UNIT_INC_FREQ, PERIOD_INC_FREQ, INC_PCT, INC_AMT, INC_CURR, INC_START_DATE, IND_HBR_WAIVER, INC_LAST_DATE, FLG_COLL_LCHG, FLG_CHARGE_CERT, CHARGE_CERT_NUM, FILE_NUM, SCOPE_INS_COVER, ORG_UNIT1, ORG_UNIT2, ORG_UNIT3, ORG_UNIT4, ORG_UNIT5, LIQD_MODE, COR_ROLE, REL_THRESHOLD, CREATED_BY, CREATED_AT, CHANGED_BY, CHANGED_AT, SOURCEOFENTRY FROM CMS_CAG
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2CAG_GUIDGUID for Table CMS_CAGvarbinary160RAWNoCMS_DTE_CAG_GUID
3CAGMTIDCollateral Agreement IDnvarchar400CHAR(N' ')YesCMS_DTE_CAGID Allow NULL? 
4CAGMT_TYPECollateral Agreement Typenvarchar60CHAR(N' ')YesTCMS_CAG_TYPCMS_DTE_CAG_TYP Allow NULL? 
5NOM_VALUENominal Value of the Collateral Agreementdecimal172CURR((0))YesCMS_DTE_CAG_NOMINAL_VALUE
6NOM_VALUE_CURRCurrency for Nominal Value of the Collateral Agreementnvarchar50CUKY(N' ')YesTCURCCMS_DTE_CAG_NOMINAL_CURR Allow NULL? 
7ASMT_AMTAssessment Amountdecimal172CURR((0))YesCMS_DTE_CAG_ASMT_AMT
8ASMT_CURRCurrency of Assessment Valuenvarchar50CUKY(N' ')YesTCURCCMS_DTE_CAG_ASMT_CURR Allow NULL? 
9ASMT_DATEDate on which the Assessment Value was Calculatednvarchar80DATS(N'00000000')YesCMS_DTE_CAG_ASMT_DATE Allow NULL? 
10CAGMT_DATEDate on which Collateral Agreement was Concludednvarchar80DATS(N'00000000')YesCMS_DTE_CAG_DATE Allow NULL? 
11VALID_FROMCollateral Agreement Document Valid-from Datenvarchar150NUMC(N'000000000000000')YesCMS_DTE_CAG_VALID_FROM Allow NULL? 
12VALID_TOCollateral Agreement Document Valid-to Datenvarchar150NUMC(N'000000000000000')YesCMS_DTE_CAG_VALID_TO Allow NULL? 
13ADMIN_ORG_UNITAdministration Organizational Unitnvarchar120CHAR(N' ')YesCMS_DTE_ADMINORG Allow NULL? 
14BANKAREABank Area in Collateral Managementnvarchar40CHAR(N' ')Yes*CMS_DTE_BANKAREA Allow NULL? 
15COUNTRY_KEYJurisdiction Countrynvarchar30CHAR(N' ')Yes*CMS_DTE_COUNTRY_KEY Allow NULL? 
16FLG_GLOBALFlag to indicate a Global Collateral Agreementchar10CHAR(N' ')YesCMS_DTE_FLG_CAG_GLOBAL Allow NULL? 
17SPL_MARKDOWN_PCTPercentage of Special Markdowndecimal106DEC((0))YesCMS_DTE_CAG_SPL_MARKDOWN_PCT
18SPL_MARKDOWN_AMTAmount of Special Markdowndecimal172CURR((0))YesCMS_DTE_CAG_SPL_MARKDOWN_AMT
19SPL_MRKDOWN_CURRCurrency for Amount of Special Markdownnvarchar50CUKY(N' ')Yes*CMS_DTE_CAG_SPL_MRKDWN_CURR Allow NULL? 
20DESCRIPTIONDescription of Collateral Agreementnvarchar300CHAR(N' ')YesCMS_DTE_CAG_DESC Allow NULL? 
21UNIT_REL_FREQThe unit for period of Release Frequencynvarchar20CHAR(N' ')YesCMS_DTE_IND_CAG_REL_FREQ_UNIT Allow NULL? 
22PERIOD_REL_FREQPeriod for Frequency of Release of Collateral Agreementnvarchar40NUMC(N'0000')YesCMS_DTE_CAG_REL_FREQ_PERIOD Allow NULL? 
23OLD_CAGMTIDExternal/Old Collateral Agreement IDnvarchar400CHAR(N' ')YesCMS_DTE_OLD_CAGID Allow NULL? 
24MIN_QL_EXCEP_TYPExceptions for Minimum Risk Weightnvarchar60CHAR(N' ')YesTCMS_CAG_MQEXPCMS_DTE_CAG_MIN_QUAL_EXCEP_TYP Allow NULL? 
25MIN_QL_REASONReason for the Minimum Qualitative Criterionnvarchar60CHAR(N' ')YesTCMS_ATT_ID_TYCMS_DTE_CAG_ATT_ID_TY_CAG001 Allow NULL? 
26FLG_MIN_QL_REQMTFlag:Minimum requirements fulfilled for CAG(for Basel II)char10CHAR(N' ')YesCMS_DTE_FLG_CAG_MIN_QUAL_REQMT Allow NULL? 
27MIN_QL_CRITEMInimum Qualitative Criterionnvarchar60CHAR(N' ')YesTCMS_CAG_MQCRTCMS_DTE_CAG_MIN_QUAL_CRITERION Allow NULL? 
28PCT_ASSET_VALPercentage of the Asset Value used in Collateral Agreementdecimal106DEC((0))YesCMS_DTE_PCT_AST_VAL
29TERM_RIGHT_TYPTermination Right Typenvarchar60CHAR(N' ')Yes*CMS_DTE_TERM_RIGHT_TYP Allow NULL? 
30FIRST_TERM_DATEFirst possible date of terminationnvarchar80DATS(N'00000000')YesCMS_DTE_CAG_TERM_FSTPOS_DATE Allow NULL? 
31UNIT_TERM_FREQThe Unit for Period of Termination Frequencynvarchar20CHAR(N' ')YesCMS_DTE_IND_CAG_TERM_FREQ_UNIT Allow NULL? 
32PERIOD_TERM_FREQPeriod for Frequency of Termination of Collateral Agreementnvarchar40NUMC(N'0000')YesCMS_DTE_CAG_TERM_FREQ_PERIOD Allow NULL? 
33NOTICE_PRD_UNITThe Unit for the Termination Notice Periodnvarchar20CHAR(N' ')YesCMS_DTE_IND_CAG_NOTICE_UNIT Allow NULL? 
34REQ_NOTICE_PRDNotice Period Required to Terminate Collateral Agreementnvarchar40NUMC(N'0000')Yes*CMS_DTE_CAG_NOTICE_PERIOD Allow NULL? 
35TERM_NOTICE_DATEDate on which Termination Notice was Sentnvarchar80DATS(N'00000000')YesCMS_DTE_CAG_TERM_NOTICE_DATE Allow NULL? 
36TERM_REASONTermination Typenvarchar60CHAR(N' ')YesTCMS_ATT_ID_TYCMS_DTE_CAG_ATT_ID_TY_CAG002 Allow NULL? 
37TERM_GUAR_AMTAmount of Guarantee in the event of Terminationdecimal172CURR((0))YesCMS_DTE_CAG_TERM_VALUE
38TERMINATION_CURRCurrency for Amount of Guarantee in the event of Terminationnvarchar50CUKY(N' ')Yes*CMS_DTE_CAG_TERM_VALUE_CURR Allow NULL? 
39GUAR_RATEGuarantee Ratedecimal106DEC((0))YesCMS_DTE_CAG_GUAR_RATE
40FLG_COUNTER_GUARFlag for Counter Guaranteechar10CHAR(N' ')YesCMS_DTE_FLG_CAG_CNTR_GUAR Allow NULL? 
41FLG_CO_GUARFlag for Co-guaranteechar10CHAR(N' ')YesCMS_DTE_FLG_CAG_CO_GUAR Allow NULL? 
42FLG_FIXED_LIABTYFlag for Fixed Liabilitychar10CHAR(N' ')YesCMS_DTE_FLG_CAG_FIXED_LIABILTY Allow NULL? 
43FLG_DEF_LIABTYFlag for Default Liabilitychar10CHAR(N' ')YesCMS_DTE_FLG_CAG_DEF_LIABILITY Allow NULL? 
44PCT_DEF_LIABTYDefault Liability in %decimal106DEC((0))YesCMS_DTE_FLG_CAG_PCT_DEF_LIABTY
45FLG_INCL_CAG_LNKFlag for back-up guarantee to be used in calculations or notchar10CHAR(N' ')YesCMS_DTE_FLG_CAG_INCL_LINKED Allow NULL? 
46IND_APPR_AUTHApproval from authoritiesnvarchar20CHAR(N' ')YesCMS_DTE_IND_CAG_APPR_AUTH Allow NULL? 
47FLG_ENFORCEABLEAgreement directly enforceablechar10CHAR(N' ')YesCMS_DTE_FLG_CAG_ENFORCEABLE Allow NULL? 
48LENDING_RATELending Rate of a Guaranteedecimal106DEC((0))YesCMS_DTE_CAG_LRTE_PCT
49UNIT_REDU_FREQUnit for Period of Frequency for Reduction in Guarantee Valunvarchar20CHAR(N' ')YesCMS_DTE_IND_CAG_RED_FREQ_UNIT Allow NULL? 
50PERIOD_REDU_FREQPeriod for Frequency of Reduction in Value of Guaranteenvarchar40NUMC(N'0000')YesCMS_DTE_CAG_RED_FREQ_PERIOD Allow NULL? 
51REDU_AMTReduction in Amount of Guaranteedecimal172CURR((0))YesCMS_DTE_CAG_REDU_AMT
52REDU_CURRCurrency of the Reduced Amount of the Guaranteenvarchar50CUKY(N' ')Yes*CMS_DTE_CAG_REDU_AMT_CURR Allow NULL? 
53REDU_PCTPercentage of Reduction in the Value of a Guaranteedecimal106DEC((0))YesCMS_DTE_CAG_REDU_PCT
54REDU_START_DATEDate from which Guarantee Value is Reducednvarchar80DATS(N'00000000')YesCMS_DTE_CAG_REDU_START_DATE Allow NULL? 
55REDU_END_DATEEnd Date for Reduction in Amount of Guaranteenvarchar80DATS(N'00000000')YesCMS_DTE_CAG_REDU_END_DATE Allow NULL? 
56REDU_LAST_DATELast date of reduction of valuenvarchar80DATS(N'00000000')YesCMS_DTE_CAG_REDU_LAST_DATE Allow NULL? 
57FLG_LEASING_TXNFlag: Transfer is part of a leasing transactionchar10CHAR(N' ')YesCMS_DTE_FLG_CAG_LEASING_TXN Allow NULL? 
58IND_LESSOR_LIENIndicator for Lessor Lien on Collateral Agreementnvarchar20CHAR(N' ')YesCMS_DTE_IND_CAG_LESSOR_LIEN Allow NULL? 
59IND_ACC_LIABLESpecifies the applicability of accessories liabilitynvarchar20CHAR(N' ')YesCMS_DTE_IND_CAG_ACC_LIABLE Allow NULL? 
60FLG_ASGMT_ARFlag for Assignment of Accounts Receivables(AR) from Salechar10CHAR(N' ')YesCMS_DTE_FLG_CAG_AR_FRM_SALE Allow NULL? 
61MIN_STOCK_AMTMinimum stock Amount agreed in the Collateral Agreementdecimal172CURR((0))YesCMS_DTE_CAG_MIN_STOCK_AMT
62MIN_STOCK_CURRCurrency of the Minimum Stock Amountnvarchar50CUKY(N' ')YesTCURCCMS_DTE_CAG_MIN_STOCK_AMT_CURR Allow NULL? 
63FLG_ADDNL_RBLFlag for Additional receivablechar10CHAR(N' ')YesCMS_DTE_FLG_CAG_ADDNL_RBL Allow NULL? 
64ADDNL_RBL_DATEDate on which Additional Receivable was Acceptednvarchar80DATS(N'00000000')YesCMS_DTE_CAG_DATE_ADDNL_RBL Allow NULL? 
65IND_GBC_LIENGBC Lien on Agreementnvarchar20CHAR(N' ')YesCMS_DTE_IND_CAG_GBC_LIEN Allow NULL? 
66FLG_DISCLFlag to indicator whether the Agreement is disclosed or notchar10CHAR(N' ')YesCMS_DTE_FLG_CAG_DISCL_PLEDGE Allow NULL? 
67DISCL_DATEDate of Disclosure to Third-party Debtornvarchar80DATS(N'00000000')YesCMS_DTE_CAG_DISCL_DATE Allow NULL? 
68ASGMT_REASONReason for Assignmentnvarchar60CHAR(N' ')YesTCMS_ATT_ID_TYCMS_DTE_CAG_ATT_ID_TY_CAG006 Allow NULL? 
69INT_RATELand Charge Interest Ratedecimal106DEC((0))YesCMS_DTE_CAG_LCHG_INT_RATE
70INCIDENTAL_PAYMTIncidental Payments in Percentagedecimal106DEC((0))YesCMS_DTE_CAG_LCHG_INCD_PAYMT
71UNIT_PMT_FREQThe unit for period of payment frequencynvarchar20CHAR(N' ')YesCMS_DTE_IND_CAG_PYMT_FREQ_UNIT Allow NULL? 
72PERIOD_PMT_FREQPeriod for Frequency of Payment of Land Charge Interestnvarchar40NUMC(N'0000')YesCMS_DTE_CAG_PYMT_FREQ_PERIOD Allow NULL? 
73INT_START_DATEStart Date for Land Charge Interest Calculationnvarchar80DATS(N'00000000')YesCMS_DTE_CAG_LCHG_INT_START_DAT Allow NULL? 
74NUM_YR_LCHG_INTNumber of Years the Land Charge Interest can be Capitalizednvarchar40NUMC(N'0000')YesCMS_DTE_CAG_LCHG_INT_YR Allow NULL? 
75IND_ENFORCMT_TYPEnforcement Typenvarchar20CHAR(N' ')YesCMS_DTE_IND_CAG_LCHG_ENFC_TYP Allow NULL? 
76ENFORCMT_AMTEnforcement Amountdecimal172CURR((0))YesCMS_DTE_CAG_LCHG_ENFC_AMT
77ENFORCMT_CURRCurrency for Enforcement Amount of Land Chargenvarchar50CUKY(N' ')Yes*CMS_DTE_CAG_LCHG_ENFC_AMT_CURR Allow NULL? 
78REF_ENFORCMT_AMTReference amount for part (Equal,Secondar) enforcebilitydecimal172CURR((0))YesCMS_DTE_CAG_LCHG_ENFC_REF_AMT
79RANKRank of the Land Charge Enforceable Amountnvarchar40NUMC(N'0000')YesCMS_DTE_CAG_LCHG_ENFC_RANK Allow NULL? 
80ENFORCMT_TITLEIndicator for Enforcement Titlenvarchar20CHAR(N' ')YesCMS_DTE_IND_CAG_LCHG_ENFC_TITL Allow NULL? 
81UNIT_INT_FREQUnit for period of Payment Frequency of HBR interestnvarchar20CHAR(N' ')YesCMS_DTE_IND_CAG_HBR_INT_UNIT Allow NULL? 
82PERIOD_INT_FREQPayment Frequency Period for HBR interestnvarchar40NUMC(N'0000')YesCMS_DTE_CAG_HBR_INT_PERIOD Allow NULL? 
83FLG_INTEREST_INCFlag for increase in HBR interestchar10CHAR(N' ')YesCMS_DTE_FLG_LCHG_INC_INT Allow NULL? 
84UNIT_INC_FREQUnit for Frequency Period of Increase in HBR Interestnvarchar20CHAR(N' ')YesCMS_DTE_IND_CAG_HBR_INC_UNIT Allow NULL? 
85PERIOD_INC_FREQFrequency Period for Increase in HBR Interestnvarchar40NUMC(N'0000')YesCMS_DTE_CAG_HBR_INC_PERIOD Allow NULL? 
86INC_PCTPercentage Increase in Heritable Building Rights Amountdecimal106DEC((0))YesCMS_DTE_CAG_LCHG_INC_PCT
87INC_AMTIncrease in Heritable Building Rights Amountdecimal172CURR((0))YesCMS_DTE_CAG_LCHG_INC_AMT
88INC_CURRCurrency for Increase in HBR amountnvarchar50CUKY(N' ')Yes*CMS_DTE_CAG_LCHG_INC_AMT_CURR Allow NULL? 
89INC_START_DATEStart date for Increase in Heritable Building Right Interestnvarchar80DATS(N'00000000')YesCMS_DTE_CAG_LCHG_INC_START_DAT Allow NULL? 
90IND_HBR_WAIVERIndicator for Waiver of HBR Enforcementnvarchar20CHAR(N' ')YesCMS_DTE_IND_CAG_LCHG_HBR_WAIVE Allow NULL? 
91INC_LAST_DATELast date of Increase in Heritable Building Right Interestnvarchar80DATS(N'00000000')YesCMS_DTE_CAG_LCHG_INC_LAST_DATE Allow NULL? 
92FLG_COLL_LCHGFlag: Collective Land Chargechar10CHAR(N' ')YesCMS_DTE_FLG_CAG_LCHG_COLL Allow NULL? 
93FLG_CHARGE_CERTFlag: Land Charge certificate existschar10CHAR(N' ')YesCMS_DTE_FLG_CAG_LCHG_CERT Allow NULL? 
94CHARGE_CERT_NUMCharge Certificate Numbernvarchar300CHAR(N' ')YesCMS_DTE_CAG_LCHG_CERT_NUM Allow NULL? 
95FILE_NUMFile Numbernvarchar300CHAR(N' ')YesCMS_DTE_CAG_LCHG_FILE_NUM Allow NULL? 
96SCOPE_INS_COVERScope of Cover of Credit Insurancenvarchar60CHAR(N' ')YesTCMS_ATT_ID_TYCMS_DTE_CAG_ATT_ID_TY_CAG004 Allow NULL? 
97ORG_UNIT1Organizational Unit 1: Collateral Agreementnvarchar100CHAR(N' ')Yes*CMS_DTE_CAG_ORG_UNIT1 Allow NULL? 
98ORG_UNIT2Organizational Unit 2: Collateral Agreementnvarchar100CHAR(N' ')Yes*CMS_DTE_CAG_ORG_UNIT2 Allow NULL? 
99ORG_UNIT3Organizational Unit 3: Collateral Agreementnvarchar100CHAR(N' ')Yes*CMS_DTE_CAG_ORG_UNIT3 Allow NULL? 
100ORG_UNIT4Organizational Unit 4: Collateral Agreementnvarchar100CHAR(N' ')Yes*CMS_DTE_CAG_ORG_UNIT4 Allow NULL? 
101ORG_UNIT5Organizational Unit 5: Collateral Agreementnvarchar100CHAR(N' ')Yes*CMS_DTE_CAG_ORG_UNIT5 Allow NULL? 
102LIQD_MODEMode of Liquidation decision for the pool agreementnvarchar60CHAR(N' ')Yes*CMS_DTE_LIQD_MODE Allow NULL? 
103COR_ROLECorrespondence rolenvarchar40CHAR(N' ')YesTFK070MCMS_DTE_COR_ROLE Allow NULL? 
104REL_THRESHOLDLimit above which the Collaterals can be Released from Pooldecimal106DEC((0))YesCMS_DTE_CAG_RELEASE_THRESHOLD
105CREATED_BYLogin ID of the User who created the Recordnvarchar120CHAR(N' ')YesCMS_DTE_USER Allow NULL? 
106CREATED_ATCreation Timestampdecimal150DEC((0))YesCMS_DTE_CREATED_AT
107CHANGED_BYLast Changed Bynvarchar120CHAR(N' ')YesCMS_DTE_LAST_CHNG_USER Allow NULL? 
108CHANGED_ATChange Timestampdecimal150DEC((0))YesCMS_DTE_CHANGED_AT
109SOURCEOFENTRYSource of Entrynvarchar320CHAR(N' ')YesCMS_DTE_SOURCE_OF_ENTRY Allow NULL? 
NamePrimaryUniqueTypeColumns
CMS_CAG~0YesYesCLUSTEREDCAG_GUID, MANDT
CMS_CAG~COLNoNoNONCLUSTEREDADMIN_ORG_UNIT, CAGMT_TYPE, MANDT
CMS_CAG~SKYNoNoNONCLUSTEREDCAGMT_TYPE, CAGMTID, MANDT