CMS_STR_COR_RIG_REQ SAP (OMS:Rights general) Structure details

Dictionary Type: Structure
Description: OMS:Rights general




ABAP Code to SELECT data from CMS_STR_COR_RIG_REQ
Related tables to CMS_STR_COR_RIG_REQ
Access table CMS_STR_COR_RIG_REQ




Structure field list including key, data, relationships and ABAP select examples

CMS_STR_COR_RIG_REQ is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "OMS:Rights general" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_CMS_STR_COR_RIG_REQ TYPE CMS_STR_COR_RIG_REQ.

The CMS_STR_COR_RIG_REQ table consists of various fields, each holding specific information or linking keys about OMS:Rights general data available in SAP. These include MANDT (Client), COTYP (Correspondence Type), COKEY (Correspondence key), UNAME (User Name).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can Be Enhanced (Deep)


SAP CMS_STR_COR_RIG_REQ structure fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
WA_RIG_GEN 0
MANDTClient MANDTCLNT3MANDT
COTYPCorrespondence Type COTYP_KKCHAR4COTYP_KKCOTYPCOTYP_KK
COKEYCorrespondence key COKEY_KKCHAR36COKEY_KK
UNAMEUser Name SYUNAMECHAR12SYCHAR12
CDATECreated On COCDT_KKDATS8SYDATS
CTIMETime of Creation (to the Second) COCTM_KKTIMS6SYTIME
GPARTCorrespondence Recipient CREC_GP_KKCHAR10ALPHABU_PARTNER
GPART_GUIDCorrespondence Recipient (GUID) CREC_GP_GUID_KKCHAR32SYSUUID_C
GPART_ADR_KINDAddress Type Of Correspondence Recipient CORR_ADR_KIND_KKCHAR10BU_ADRKIND
ORG_GPARTOriginal Correspondence Recipient CREC_ORG_GP_KKCHAR10ALPHABU_PARTNER
ORG_GPART_GUIDOriginal Correspondence Recipient (GUID) CREC_ORG_GP_GUID_KKCHAR32SYSUUID_C
ADD_GPARTAdditional Business Partner for Correspondence Recipient CREC_GP_ADD_KKCHAR10ALPHABU_PARTNER
ADD_GPART_GUIDAddit. Business Partner for Correspondence Recipient GUID CREC_GP_ADD_GUID_KKCHAR32SYSUUID_C
ADD_GPART_CATType of Additional Correspondence Recipient CREC_GP_ADD_CAT_KKCHAR1CORR_CREC_ADD_CAT_KK
VKONTContract Account Number CORR_VKONT_KKCHAR12ALPHACORR_VKONT_KK
VTREFReference Specifications from Contract CORR_VTREF_KKCHAR20ALPHACORR_VTREF_KK
ADR_VALID_ONAddress of Correspondence Recipient Valid On CREC_AD_VALID_ON_KKDEC15TZNTSTMPS
ADRNRAddress Number of Correspondence Recipient CREC_AD_KKCHAR10ALPHAAD_ADDRNUM
ADR_GUIDAddress GUID of Correspondence Recipient CREC_AD_GUID_KKCHAR32SYSUUID_C
ADRNR_INDEP_COMMAddress Number for Address-Independent Communication CREC_AD_INDEP_COMM_KKCHAR10ALPHAAD_ADDRNUM
AGPARTSending Business Partner CSEN_GP_KKCHAR10ALPHABU_PARTNER
AGPART_GUIDSender (GUID) CSEN_GP_GUID_KKCHAR32SYSUUID_C
AGPART_ADR_KINDAddress Type Of Correspondence Recipient CORR_ADR_KIND_KKCHAR10BU_ADRKIND
AADRNRAddress Number of Correspondence Sender CSEN_AD_KKCHAR10ALPHAAD_ADDRNUM
AADR_GUIDAddress GUID of Correspondence Sender CSEN_AD_GUID_KKCHAR32SYSUUID_C
FORMKEYApplication form FORMKEYCHAR30FORMKEYFOM
FORMKEY_RDIApplication form FORMKEYCHAR30FORMKEYFOM
ENTID1Correspondence data ENTID_KKCHAR4ENTID_KK
DATA1Correspondence Data Field CDATA_KKCHAR32CDATA_KK
ENTID2Correspondence data ENTID_KKCHAR4ENTID_KK
DATA2Correspondence Data Field CDATA_KKCHAR32CDATA_KK
ENTID3Correspondence data ENTID_KKCHAR4ENTID_KK
DATA3Correspondence Data Field CDATA_KKCHAR32CDATA_KK
ENTID4Correspondence data ENTID_KKCHAR4ENTID_KK
DATA4Correspondence Data Field CDATA_KKCHAR32CDATA_KK
CSORTCorrespondence Sort Field CSORT_KKCHAR50CORR_TXT50
XCODTData Part Is Used XCODT_KKCHAR1XFELD
XCODT_CLUSTCluster Data Part is Used XCODT_CLUST_KKCHAR1XFELD
LAUFDDate ID for Creation Run CORR_LAUFD_KKDATS8DATUM
LAUFIAdditional ID Characteristic for Creation Run CORR_LAUFI_KKCHAR6CORR_LAUFI_KK
XTESTCorrespondence is Result of Test XTEST_KKCHAR1XFELD
COPRIPrint Date COPRI_KKDATS8SYDATS
COIDTDate of Issue COIDT_KKDATS8SYDATS
COITMIssue Time to the Second COITM_KKTIMS6SYTIME
SPRASLanguage Key SPRASLANG1ISOLASPRASSPRH_T002
SALWATransaction Currency CORR_BLWAE_KKCUKY5WAERSFWS
SALBEAmount in Local Currency with +/- Signs CORR_BETRH_KKCURR13(2) WRTV7
SENDCONTROLDispatch Control SENDCONTROLCHAR4ESENDCONTROL
PERSNUMBERPerson number AD_PERSNUMCHAR10ALPHAAD_PERSNUMCDTADDRESS
APERSNUMBERPerson number AD_PERSNUMCHAR10ALPHAAD_PERSNUMCDTADDRESS
BUKRSCompany Code in Correspondence CORR_BUKRSCHAR4CORR_BUKRS
CORR_ROLECorrespondence Roles CORR_ROLE_KKCHAR4CORR_ROLE_KK
COPRI_LAUFDDate ID for Print Run COPRI_LAUFD_KKDATS8DATUM
COPRI_LAUFIID Characteristic for Run COPRI_LAUFID_KKCHAR6COPRI_LAUFID_KK
PROCESS_ID_Business Process ID CORR_PROCESS_ID_KKCHAR36
NO_DOCPARTSNumber of Document Parts CORR_NO_DOCPARTS_KKNUMC4
DOCPART_ROLEDocument Part Role CORR_DOCPART_ROLE_KKCHAR1CORR_DOCPART_ROLE_KK
XTRIALCorrespondence Request is Test XTRIAL_KKCHAR1XFELD
XREPRINTRecreate Correspondence XREPRINT_KKCHAR1XFELD
SUBAPSubapplication Indicator in Correspondence CORR_SUBAP_KKCHAR1CORR_SUBAP_KK
XDELETECorrespondence Is Logically Deleted X_CORR_DELETE_KKCHAR1XFELD
PRINT_MODEBusiness Partner Print Format PRINT_MODE_KKCHAR1BU_PRINT_MODE
X_NO_ARCSAP ArchiveLink Object ID Part Is Not Used X_NO_ARC_KKCHAR1XFELD
X_DOCPART_LISTDocument Part List Is Used X_DOCPART_LIST_KKCHAR1XFELD
.INCLU--AP 0
BKKRSBank Area BKK_BKKRSCHAR4BKK_BKKRSBNS
ACNUM_INTInternal Account Number for Current Account BKK_ACCNTCHAR10ALPHABKK_ACCNTACI
.INCLU--AP 0
.INCLU-CMS 0
OBJECT_IDCMSObject Identification Number CMS_DTE_OBJECT_IDRAW16SYSUUID
FLG_ORIGINALCMSFlag to indicate if the document is original or duplicate CMS_DTE_FLG_ORIGCHAR1CMS_FLG
SENDCONTROLCMSDispatch Control SENDCONTROLCHAR4ESENDCONTROL
.INCLU--AP 0
.INCLU-FVD 0
PRODUCTTYPEFVDProduct Type VVSARTCHAR3VVSARTSANVVSART_APPL_BAS
BP_ROLEFVDBP Role BU_PARTNERROLECHAR6BU_ROLEBUPA_ROLE
BP_ROLETYPEFVDBusiness Partner Role Type BP_ROLECHAR4BP_ROLE
SOBJECTFVDInternal key for object VVKEYOBJCHAR10VVKEY
CORR_ACTIVITYFVDCorrespondence activity KORRVORFNUMC4KORRVORF
REFERENCEDATEFVDReference Date for Creating Correspondence TB_CORR_REFERENCE_DATEDATS8DATUM
WA_RECEIVER 0
BU_PARTNERIDBusiness Partner Identification Number CMS_DTE_BPIDCHAR32CMS_BPID
BP_DESCRIPTIONAddress description of Business Partner CMS_DTE_BP_ADDR_DESCCHAR60CMS_BP_ADDR_DESC
WA_CLAIM_ADDR 0
RIG_GUIDRights GUID CMS_DTE_RIG_GUIDRAW16SYSUUID
RIG_CATEGORYObject Category CMS_DTE_OMS_OBJ_CATCHAR6CMS_OBJ_CAT
RIG_TYPRight Type CMS_DTE_RIG_TYPCHAR6CMS_RIG_TYP
RIG_IDRights ID CMS_DTE_RIG_IDCHAR40ALPHACMS_MOV_ID
ADDRNUMBERAddress number AD_ADDRNUMCHAR10ALPHAAD_ADDRNUMADR
ADDRHANDLEHandle for Creating Addresses/Persons (Bus. Addr. Services) AD_HANDLECHAR140TEXT140
NATIONVersion ID for International Addresses AD_NATIONCHAR1AD_NATIONADDRESS_NATION
DATEDate referred to AD_DATEDATS8DATUM
DATE_FROMValid-from date - in current Release only 00010101 possible AD_DATE_FRDATS8DATUM
DATE_TOValid-to date in current Release only 99991231 possible AD_DATE_TODATS8DATUM
TITLEForm-of-Address Key AD_TITLECHAR4AD_TITLE
NAME1Name 1 AD_NAME1CHAR40TEXT40
NAME2Name 2 AD_NAME2CHAR40TEXT40
NAME3Name 3 AD_NAME3CHAR40TEXT40
NAME4Name 4 AD_NAME4CHAR40TEXT40
NAME_TXTConverted name field (with form of address) AD_NAMETXTCHAR50TEXT50
NAME_COc/o name AD_NAME_COCHAR40TEXT40
CITY1City AD_CITY1CHAR40TEXT40CLCITYNAME
CITY2District AD_CITY2CHAR40TEXT40CITY_PART
CITY_CODECity code for city/street file AD_CITYNUMCHAR12ALPHACITY_CODE
CITYP_CODEDistrict code for City and Street file AD_CITYPNMCHAR8ALPHACITYP_CODE
HOME_CITYCity (different from postal city) AD_CITY3CHAR40TEXT40
CITYH_CODEDifferent city for city/street file AD_CITYHNMCHAR12ALPHACITY_CODE
CHCKSTATUSCity file test status AD_CHECKSTCHAR1AD_CHECKST
REGIOGROUPRegional structure grouping REGIOGROUPCHAR8REGIOGROUP
POST_CODE1City postal code AD_PSTCD1CHAR10CHAR10
POST_CODE2PO Box Postal Code AD_PSTCD2CHAR10CHAR10
POST_CODE3Company Postal Code (for Large Customers) AD_PSTCD3CHAR10CHAR10
PCODE1_EXT(Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code AD_PST1XTCHAR10CHAR10
PCODE2_EXT(Not Supported) PO Box Postal Code Extension AD_PST2XTCHAR10CHAR10
PCODE3_EXT(Not Supported) Major Customer Postal Code Extension AD_PST3XTCHAR10CHAR10
PO_BOXPO Box AD_POBXCHAR10CHAR10
DONT_USE_PPO Box Address Undeliverable Flag AD_NO_USEPCHAR4AD_NO_USE
PO_BOX_NUMFlag: PO Box Without Number AD_POBXNUMCHAR1XFELD
PO_BOX_LOCPO Box city AD_POBXLOCCHAR40TEXT40CITY_NAME
CITY_CODE2City PO box code (City file) AD_CIT2NUMCHAR12ALPHACITY_CODE
PO_BOX_REGRegion for PO Box (Country, State, Province, ...) AD_POBXREGCHAR3REGIO
PO_BOX_CTYPO box country AD_POBXCTYCHAR3LAND1
POSTALAREA(Not Supported) Post Delivery District AD_PSTLARCHAR15TEXT15
TRANSPZONETransportation zone to or from which the goods are delivered LZONECHAR10ZONE
STREETStreet AD_STREETCHAR60TEXT60CLSTRTNAME
DONT_USE_SStreet Address Undeliverable Flag AD_NO_USESCHAR4AD_NO_USE
STREETCODEStreet Number for City/Street File AD_STRNUMCHAR12ALPHASTRT_CODE
STREETABBR(Not Supported) Abbreviation of Street Name AD_STRABBRCHAR2STRTYPEAB
HOUSE_NUM1House Number AD_HSNM1CHAR10TEXT10
HOUSE_NUM2House number supplement AD_HSNM2CHAR10TEXT10
HOUSE_NUM3(Not supported) House Number Range AD_HSNM3CHAR10TEXT10
STR_SUPPL1Street 2 AD_STRSPP1CHAR40TEXT40
STR_SUPPL2Street 3 AD_STRSPP2CHAR40TEXT40
STR_SUPPL3Street 4 AD_STRSPP3CHAR40TEXT40
LOCATIONStreet 5 AD_LCTNCHAR40TEXT40
BUILDINGBuilding (Number or Code) AD_BLDNGCHAR20TEXT20
FLOORFloor in building AD_FLOORCHAR10TEXT10
ROOMNUMBERRoom or Appartment Number AD_ROOMNUMCHAR10TEXT10
COUNTRYCountry Key LAND1CHAR3LAND1LND
LANGULanguage Key SPRASLANG1ISOLASPRASSPRH_T002
REGIONSTATE (State, Province, County) REGIOCHAR3REGIO
SORT1Search Term 1 AD_SORT1ULCHAR20TEXT20
SORT2Search Term 2 AD_SORT2ULCHAR20TEXT20
SORT_PHN(Not Supported) Phonetic Search Sort Field AD_SRTPHNCHAR20CHAR20
ADDRORIGIN(Not Supported) Address Data Source (Key) AD_ORIGINACHAR4AD_ORIGIN
EXTENSION1Extension (only for data conversion) (e.g. data line) AD_EXTENS1CHAR40TEXT40
EXTENSION2Extension (only for data conversion) (e.g. telebox) AD_EXTENS2CHAR40TEXT40
TIME_ZONEAddress time zone AD_TZONECHAR6TZNZONE
TAXJURCODETax Jurisdiction AD_TXJCDCHAR15AD_TXJCDTXJ
ADDRESS_ID(Not supported) Physical address ID AD_ADDR_IDCHAR10ALPHAAD_ADDR_ID
REMARKAddress notes AD_REMARK1CHAR50TEXT50
LANGU_CREAAddress record creation original language AD_LANGUCRLANG1ISOLASPRAS
PO_BOX_LOBBYPO Box Lobby AD_PO_BOX_LBYCHAR40TEXT40
DELI_SERV_TYPEType of Delivery Service AD_DELIVERY_SERVICE_TYPECHAR4AD_DELIVERY_SERVICE_TYPE
DELI_SERV_NUMBERNumber of Delivery Service AD_DELIVERY_SERVICE_NUMBERCHAR10CHAR10
COUNTY_CODECounty code for county AD_CNTYNUMCHAR8ALPHACNTY_CODE
COUNTYCounty AD_COUNTYCHAR40TEXT40CLTCNTYNAME
TOWNSHIP_CODETownship code for Township AD_TWSHPNUMCHAR8ALPHATWSHP_CODE
TOWNSHIPTownship AD_TOWNSHIPCHAR40TEXT40CLTWSHPNAME
DEFLT_COMMCommunication Method (Key) (Business Address Services) AD_COMMCHAR3AD_COMM
TEL_NUMBERFirst telephone no.: dialling code+number AD_TLNMBR1CHAR30CHAR30
TEL_EXTENSFirst Telephone No.: Extension AD_TLXTNS1CHAR10CHAR10
FAX_NUMBERFirst fax no.: dialling code+number AD_FXNMBR1CHAR30CHAR30
FAX_EXTENSFirst fax no.: extension AD_FXXTNS1CHAR10CHAR10
ADDR_GROUPAddress Group (Key) (Business Address Services) AD_GROUPCHAR4AD_GROUP
WA_SENDER 0
MANDTClient MANDTCLNT3MANDT
PLVARPlan Version PLVARCHAR2PLVARPOP
OTYPEObject Type OTYPECHAR2OTYPEPOT
OBJIDObject ID OBJEKTIDNUMC8NUM08PON
INFTYInfotype INFOTYPCHAR4INFOTYPHRBAS00INFTY
SUBTYSubtype SUBTYPCHAR4SUBTYP
ISTATPlanning Status ISTAT_DCHAR1ISTATPST
PRIOXPriority PRIOXCHAR2CHAR2
BEGDAStart Date BEGDATUMDATS8DATUMBEG
ENDDAEnd Date ENDDATUMDATS8DATUMEND
VARYFVariation Field for File PLOG VARYFCHAR10CHAR10
SEQNRNumber of Infotype Record with Same Key SEQNRNUMC3NUM03
AEDTMChanged on AEDTMDATS8DATUM
UNAMEUser Name USRNAMECHAR12CHAR12
REASNReason REASNCHAR2CHAR2
HISTOHistorical Record Flag HISTOCHAR1CHAR1
ITXNRText Module for Infotype ITXNRNUMC8NUM08
CNAMEAddress Supplement (c/o) CNAMECHAR25TEXT25
STRASHouse Number and Street PD_STRASCHAR30TEXT30
ORT01City KORTCHAR40TEXT40
PSTLZPostal Code PD_PSTLZCHAR10PSTLZ
LAND1Country KLANDCHAR3LAND1
TELNRTelephone Number TELENRCHAR25CHAR25
FAXNRFax Number FAXNRCHAR25CHAR25
ENTKMDistance in Kilometers ENTKMDEC3DEC3
BUILDBuilding BUILDCHAR8BUILD
ROOM1Physical Room Number ROOM1CHAR8CHAR8
ADRNRAddress ADRNRCHAR10ALPHAADRNR
REGIOSTATE (State, Province, County) REGIOCHAR3REGIO
STRS2House number and street STRAS_GPCHAR35TEXT35
HAUSNHouse number HAUSN_BASCHAR6CHAR6
WA_PAT_HDR 0
RIG_GUIDRights GUID CMS_DTE_RIG_GUIDRAW16SYSUUID
RIG_CATEGORYObject Category CMS_DTE_OMS_OBJ_CATCHAR6CMS_OBJ_CAT
RIG_TYPRight Type CMS_DTE_RIG_TYPCHAR6CMS_RIG_TYP
RIG_IDRights ID CMS_DTE_RIG_IDCHAR40ALPHACMS_MOV_ID
RIG_CAT_NAMEObject Category Name CMS_DTE_OMS_CAT_NAMECHAR40CMS_OMS_CAT_NAME
RIG_TYP_NAMERight Type Name CMS_DTE_RIG_TYP_NAMECHAR40CMS_RIG_NAME
ADD_DESCRAdditional description of the right CMS_DTE_CLM_DESCCHAR30CMS_DSC
DURATION_BEGINStart date of the right CMS_DTE_RIG_BEGINDATS8CMS_DATE
DURATION_ENDValidity End Date of the Right or Patent CMS_DTE_RIG_ENDDATS8CMS_DATE
CLASSIFICATIONClassification CMS_DTE_MOV_TYPE_FEATCHAR6CMS_MOV_TYPE_FEAT
EXT_ITM_NOExt. Item no / Number for identification of the objects CMS_DTE_OMS_EXT_ITM_NOCHAR40ALPHACMS_OMS_ID
EXT_REFERENCEReference number for the legacy system CMS_DTE_OMS_REF_IDCHAR32CMS_OMS_REFID
NOTAR_DATENotarization Date CMS_DTE_RIG_NOT_DATDATS8DATUM
REGIS_DATEDate of Patent Registration CMS_DTE_RIG_REG_DATDATS8DATUM
PATENT_NOPatent Number CMS_DTE_RIG_PATENT_NOCHAR40CMS_OMS_ID
REGISTRY_NONo. of the Register in the Patent Office CMS_DTE_RIG_REG_NOCHAR20CMS_RIG_REG_NO
PATENT_OFFICEPatent Office CMS_DTE_RIG_PT_OFFCHAR30CMS_DSC
ADD_PPTY_RIGAdditional Property Rights that are Available CMS_DTE_RIG_AV_PTYCHAR6CMS_ATT_ID_TYP
PAT_PARENT_GUIDLinks to Parent Patent - GUID of the Parent CMS_DTE_PARENT_GUIDRAW16SYSUUID
DESCRIPTIONDescription CMS_DTE_AST_DESCCHAR30CMS_DSC
OBJECT_REF_IDReference ID for the object CMS_DTE_OBJ_REFIDCHAR40CMS_OBJ_REFID
OBJECT_TYPNot used CMS_DTE_OBJ_TYPCHAR32CMS_OBJ_TYP
COUNTRY_KEYIdentification Key for Country CMS_DTE_AST_COUNTRY_KEYCHAR3LAND1
RISK_CODERisk Code CMS_DTE_RISK_CODECHAR6CMS_RISK_CODE
SFTY_INDIndicates if the Asset has a Default Safety Discount CMS_DTE_IND_SFTY_DISCCHAR2CMS_IND_SFTY
SFTY_DSCNTPercentage of Safety Discount CMS_DTE_SAFETY_DSCNTDEC10(6) CMS_SFTY_PCT
SFTY_AMOUNTAmount of Safety Discount CMS_DTE_SAFETY_AMTCURR17(2) CMS_AMOUNT
SFTY_AMT_CURRCurrency of the Safety Discount Amount CMS_DTE_SAFETY_AMT_CURRCUKY5WAERS
OBJSYSIDObject System Reference ID CMS_DTE_OBJ_SYSIDCHAR6CMS_SYSCMS_OBJSYSTEMIDCMS_OBJ_SYS
VALUATION_TYPType of Valuation Check performed on Collateral Object CMS_DTE_IND_VALN_TYPCHAR2CMS_VALN_TYP
UNIT_VALN_FREQIndicator: Units of time for revaluation of an asset CMS_DTE_IND_AST_VALN_FREQ_UNITCHAR2CMS_IND_AST_VALN_FREQ_UNIT
PERIOD_VALN_FREQRevaluation Period for an Asset CMS_DTE_AST_VALN_FREQ_PERIODNUMC4CMS_AST_VALN_FREQ_PERIOD
PAST_VALUED_DATELast Date on which the Asset was Valued CMS_DTE_VALN_DATEDATS8CMS_DATE
START_DATEDate on which the First Valuation is Performed on the Asset CMS_DTE_START_DATEDATS8CMS_DATE
END_DATEDate on which the Last Valuation is Performed on the Asset CMS_DTE_END_DATEDATS8CMS_DATE
LENDING_RATE_INDIndicator to specify if Asset has a Default Lending Rate CMS_DTE_IND_LND_RTECHAR2CMS_IND_LRTE
LENDING_RATE1Lending Rate 1 CMS_DTE_LRTE_PCT1DEC10(6) CMS_PCT
LENDING_RATE2Lending Rate 2 CMS_DTE_LRTE_PCT2DEC10(6) CMS_PCT
LENDING_RATE3Lending Rate 3 CMS_DTE_LRTE_PCT3DEC10(6) CMS_PCT
LENDING_RATE4Lending Rate 4 CMS_DTE_LRTE_PCT4DEC10(6) CMS_PCT
LENDING_RATE5Lending Rate 5 CMS_DTE_LRTE_PCT5DEC10(6) CMS_PCT
LIQD_TYPLiquidation Type CMS_DTE_LIQD_TYPCHAR6CMS_TYPCMS_AST_LIQTYP
LIQD_REASONLiquidation Reason CMS_DTE_ATT_ID_TY_AST004CHAR6CMS_ATT_ID_TYP
LIQD_DATEDate on which the Collateral was Liquidated CMS_DTE_LIQD_DATEDATS8CMS_DATE
LIQD_AMTReturns from the Liquidation of Collateral CMS_DTE_LIQD_VALUECURR17(2) CMS_AMOUNT
LIQD_CURRCurrency of Liquidation Value CMS_DTE_LIQD_CURRCUKY5WAERS
EXP_PRCD_AMNTExpected Proceed Amount CMS_DTE_LIQ_EXP_PRCD_AMOUNTCURR17(2) CMS_AMOUNT
EXP_PRCD_CURRCurrency: Expected Proceed CMS_DTE_LIQ_EXP_PRCD_CURRCUKY5WAERS
EXP_ACC_DATEExpected accrual date CMS_DTE_LIQ_EXP_ACCRUAL_DATEDATS8CMS_DATE
ACC_NUMBER_LIQAccount number for liquidation proceeds CMS_DTE_LIQ_ACC_NUMBERCHAR35BANKN35
BANK_CNTRY_LIQBank country key CMS_DTE_LIQ_BNK_CTRY_KYCHAR3LAND1
BANK_KEY_LIQBank Key CMS_DTE_LIQ_BNK_KEYCHAR15BANKKBNK
BANK_CTRLKEY_LIQBank Control Key BKONTCHAR2BKONT
UNIT_VERF_FREQIndicator: Units of time for verification of an asset CMS_DTE_IND_AST_VERF_FREQ_UNITCHAR2CMS_IND_AST_VERF_FREQ_UNIT
PERIOD_VERF_FREQStatement Period for an Asset CMS_DTE_AST_VERF_FREQ_PERIODNUMC4CMS_AST_VERF_FREQ_PERIOD
LAST_VERF_DATELast Verification Date CMS_DTE_AST_VERF_DATEDATS8CMS_DATE
AST_GUIDGUID for Table CMS_AST CMS_DTE_AST_GUIDRAW16SYSUUID
AST_TYPAsset Type CMS_DTE_AST_TYPCHAR6CMS_AST_TYPCMS_AST_TYPCMS_AST_TYP
PARENT_GUIDAsset Guid as a parent GUID for a sub-asset CMS_DTE_SAS_PAR_GUIDRAW16SYSUUID
NOM_VALUENominal Value of the Asset CMS_DTE_AST_NOMINAL_VALUECURR17(2) CMS_AMOUNT
NOM_VALUE_CURRCurrency of Nominal value CMS_DTE_AST_NOMINAL_VALUE_CURRCUKY5WAERS
AST_VALUEFinal Asset Value CMS_DTE_AST_VALUECURR17(2) CMS_AMOUNT
AST_VALUE_CURRCurrency of the Final Asset Value CMS_DTE_AST_VALUE_CURRCUKY5WAERS
QUANTITYQuantity CMS_DTE_QTYQUAN13(3) CMS_QTY
UNIT_OF_MEASUREUnit of Measure of Quantity CMS_DTE_UNITUNIT3CUNITMEINS
REC_ATAsset Value Recording Timestamp CMS_DTE_REC_ATDEC15TZNTSTMPS
PUR_PRICEPurchase Price of the Asset CMS_DTE_AST_PURCHASE_PRICECURR17(2) CMS_AMOUNT
PUR_PRICE_CURRCurrency of Purchase Price CMS_DTE_AST_PUR_PRICE_CURRCUKY5WAERS
PUR_DATEDate of Purchase CMS_DTE_AST_PUR_PRICE_DATEDATS8CMS_DATE
ADMIN_ORG_UNITAdministration Organizational Unit CMS_DTE_ADMINORGCHAR12TEXT12CMS_ADMINORG
BANKAREABank Area in Collateral Management CMS_DTE_BANKAREACHAR4CMS_BANKAREACMS_BANKAREA
ORG_UNIT1Organizational Unit 1 CMS_DTE_ORG_UNIT1CHAR10CMS_ORG_UNIT
ORG_UNIT2Organizational Unit 2 CMS_DTE_ORG_UNIT2CHAR10CMS_ORG_UNIT
ORG_UNIT3Organizational Unit 3 CMS_DTE_ORG_UNIT3CHAR10CMS_ORG_UNIT
ORG_UNIT4Organizational Unit 4 CMS_DTE_ORG_UNIT4CHAR10CMS_ORG_UNIT
ORG_UNIT5Organizational Unit 5 CMS_DTE_ORG_UNIT5CHAR10CMS_ORG_UNIT
CREATED_BYLogin ID of the User who created the Record CMS_DTE_USERCHAR12CMS_USER
CREATED_ATCreation Timestamp CMS_DTE_CREATED_ATDEC15TZNTSTMPS
CHANGED_BYLast Changed By CMS_DTE_LAST_CHNG_USERCHAR12CMS_USER
CHANGED_ATChange Timestamp CMS_DTE_CHANGED_ATDEC15TZNTSTMPS
SOURCEOFENTRYSource of Entry CMS_DTE_SOURCE_OF_ENTRYCHAR32CMS_SOURCE
WA_INS_HDR 0
RIG_GUIDRights GUID CMS_DTE_RIG_GUIDRAW16SYSUUID
RIG_CATEGORYObject Category CMS_DTE_OMS_OBJ_CATCHAR6CMS_OBJ_CAT
RIG_TYPRight Type CMS_DTE_RIG_TYPCHAR6CMS_RIG_TYP
RIG_IDRights ID CMS_DTE_RIG_IDCHAR40ALPHACMS_MOV_ID
RIG_CAT_NAMEObject Category Name CMS_DTE_OMS_CAT_NAMECHAR40CMS_OMS_CAT_NAME
RIG_TYP_NAMERight Type Name CMS_DTE_RIG_TYP_NAMECHAR40CMS_RIG_NAME
INS_DESCInsurance Description CMS_DTE_INS_DESCCHAR30CMS_INS_DESC
INSUR_TAX_DB Insurance tax to the debit of the bank CMS_DTE_INS_TAX_DBCHAR1CMS_INS_FLG
SETLMNT_TYPEType of settlement CMS_DTE_INS_SETLMNT_TYPECHAR6CMS_ATT_ID_TYP
INSUR_SUMInsurance Sum CMS_DTE_INS_SUMCURR17(2) CMS_AMOUNT
INSUR_CURRInsurance Currency CMS_DTE_INS_CURRCUKY5WAERS
PRM_RTPremium Rate CMS_DTE_INS_PRM_RTDEC10(7) CMS_INS_PRM_RT
INSUR_PREMIUMInsurance Premium CMS_DTE_INS_PRMCURR17(2) CMS_AMOUNT
INSUR_PRM_CURRInsurance Currency CMS_DTE_INS_CURRCUKY5WAERS
INSUR_TAX_RTInsurance tax rate (in %) CMS_DTE_INS_TAX_RTDEC10(7) CMS_INS_PRM_RT
INSUR_TAX_AMTInsurance tax amount CMS_DTE_INS_TAX_AMTCURR17(2) CMS_AMOUNT
INSUR_TAX_CURRTax Currency CMS_DTE_INS_TAX_CURRCUKY5WAERS
SCOPE_INS_COVERnot used -> package has to be changed CMS_OMS_INS CMS_DTE_INS_COVERCHAR6CMS_INS_COVER
EXT_ITM_NOExt. Item no / Number for identification of the objects CMS_DTE_OMS_EXT_ITM_NOCHAR40ALPHACMS_OMS_ID
EXT_REFERENCEReference number for the legacy system CMS_DTE_OMS_REF_IDCHAR32CMS_OMS_REFID
FOPFrequency of Payment CMS_DTE_INS_FOPNUMC4CMS_INS_FREQ_OF_PAYMENT
FREQ_UNITIndicator: Units of time for revaluation CMS_DTE_INS_FREQ_UNITCHAR2CMS_INS_IND_FREQ_UNIT
INS_CODEInsurance Product Code CMS_DTE_INS_CODECHAR6CMS_INS_CODE
ORIG_COUNTRYCountry where Insurance was purchased CMS_DTE_INS_ORIG_COUNTRYCHAR3LAND1
ORIG_REGIONRegion where Insurance was purchased CMS_DTE_INS_ORIG_REGIONCHAR3REGIO
AUTO_CANCEL_DTAuto Cancellation Date for an Insurance Policy CMS_DTE_INS_AUTO_CANCEL_DTDATS8CMS_DATE
PRM_TYPEType of Premium CMS_DTE_INS_PRM_TYPECHAR2CMS_INS_PREMIUM_TYPE
PRM_VALID_FROMDate from when specified Premium is valid CMS_DTE_INS_PRM_VALID_FROM_DTDATS8CMS_DATE
PAYMNT_METHODPayment method for premiums CMS_DTE_INS_PAYMENT_METHODCHAR2CMS_INS_PAYMENT_METHOD
PAYMNT_INFOPayment Info for an insurance policy CMS_DTE_INS_PAY_INFOCHAR30CMS_PAYMENT_HANDLE
LAST_PAYMENT_DTDate when last premium payment was made CMS_DTE_INS_LAST_PAYMENT_DTDATS8CMS_DATE
NXT_PAYMENT_DTNext Payment Date when insurance premium is due CMS_DTE_INS_NXT_PAYMENT_DTDATS8CMS_DATE
STATEMENT_DTDate when statements for Policy was made CMS_DTE_INS_STATEMENT_DTDATS8CMS_DATE
REBATE_METHODIdentifier for the rebate method used to calculate refunds CMS_DTE_INS_REBATE_METHOD_IDCHAR6CMS_INS_REBATE_METHOD_ID
PORTFOLIOInsurance Portfolio CMS_DTE_INS_PORTFOLIOCHAR6CMS_INS_PORTFOLIO
MAX_AGE_LIMITMaximum age limit for Policy Validity CMS_DTE_INS_MAX_AGE_LIMITINT13CMS_AGE
MAX_COVER_AMTMaximum Coverage Amount CMS_DTE_INS_MAX_COVER_AMTCURR17(2) CMS_AMOUNT
MIN_COVER_AMTMinimum Coverage Amount CMS_DTE_INS_MIN_COVER_AMTCURR17(2) CMS_AMOUNT
IND_INSURED_EVNTBoolean indicator that insured event occured (X = Occured) CMS_DTE_IND_INSURED_EVENTCHAR1CMS_IND_OCCURENCE
INSURED_EVENT_DTDate when Insured Event Occured CMS_DTE_INSURED_EVENT_DTDATS8CMS_DATE
IND_FORCE_PLACEDIs Insurance Force Placed? (Default = No) CMS_DTE_INS_IND_FORCE_PLACECHAR2CMS_IND_INS_FORCE_PLACE
IND_TAX_DEDUCTIndicator that Insurance Policy is Tax Deductible CMS_DTE_INS_IND_TAX_DEDUCTCHAR2CMS_IND_INS_TAX_DEDUCTIBLE
INACTIVE_REASONReason for inactivating insurance policy CMS_DTE_INS_INACTIVE_REASONCHAR2CMS_INS_INACTIVE_REASON
POLICY_STATUSInsurance Policy Status CMS_DTE_INS_POLICY_STATUSCHAR2CMS_INS_POLICY_STATUS
TARRIFInsurance tariff CMS_DTE_INS_TARRIFCHAR30CMS_INS_TARRIF
CONTRACT_STRT_DTContract begin date CMS_DTE_INS_CNTRT_STRT_DTDATS8DATUM
CONTRACT_END_DTContract end date CMS_DTE_INS_CNTRT_END_DTDATS8DATUM
CONTRACT_CON_DTDate of conclusion of contract CMS_DTE_INS_CNTRT_CON_DTDATS8DATUM
INSUR_STATUSStatus of insurance CMS_DTE_INS_STATUSCHAR6CMS_ATT_ID_TYP
INSUR_STATUS_DTStatus date of insurance CMS_DTE_INS_STATUS_DTDATS8DATUM
SUM_ONE_TM_CONSum of one time contribution CMS_DTE_INS_SUM_ONE_TM_CONCURR17(2) CMS_AMOUNT
ONE_TM_CON_CKYCurrency CMS_DTE_INS_ONE_TM_CON_CKYCUKY5WAERS
DYNAMICSDynamics CMS_DTE_INS_DYNAMICSCHAR1CMS_INS_FLG
PER_DYNAMICSPercentage of the dynamics CMS_DTE_INS_PER_DYNAMICSDEC10(6) CMS_SEC_PCT
TERMIN_PRDTermination period CMS_DTE_INS_TERMIN_PRDNUMC4CMS_INS_FREQ_OF_PAYMENT
TERM_PRD_UNITIndicator: Units of termination period CMS_DTE_INS_TERM_PRD_UNITCHAR2CMS_INS_IND_FREQ_UNT
RECALL_PRDRecall period CMS_DTE_INS_RECALL_PRDNUMC4CMS_INS_FREQ_OF_PAYMENT
RECALL_PRD_UNITIndicator: Units of Recall Period CMS_DTE_INS_RECALL_PRD_UNITCHAR2CMS_INS_IND_FREQ_UNT
INS_SUM_SRVLInsurance sum incase of survival CMS_DTE_INS_SUM_IN_SURVIVALCURR17(2) CMS_AMOUNT
INS_SUM_SRVL_CKYInsurance survival Currency CMS_DTE_INS_SUM_IN_SURVIVL_CKYCUKY5WAERS
INS_SUM_DTHInsurance sum in case of death CMS_DTE_INS_SUM_IN_DEATHCURR17(2) CMS_AMOUNT
INS_SUM_DTH_CKYDeath benefit currency CMS_DTE_INS_SUM_IN_DEATH_CKYCUKY5WAERS
INS_BENF_EXPProbable benefit on expiry CMS_DTE_INS_PROB_BENFCURR17(2) CMS_AMOUNT
INS_BENF_EXP_CKYCurrency for probable benefit on expiry CMS_DTE_INS_PROB_BENF_CKYCUKY5WAERS
DT_PROB_BEN_EXPDate of probable benefit on expiry CMS_DTE_INS_DT_PRO_BEN_EXPDATS8DATUM
DESCRIPTIONDescription CMS_DTE_AST_DESCCHAR30CMS_DSC
OBJECT_REF_IDReference ID for the object CMS_DTE_OBJ_REFIDCHAR40CMS_OBJ_REFID
OBJECT_TYPNot used CMS_DTE_OBJ_TYPCHAR32CMS_OBJ_TYP
COUNTRY_KEYIdentification Key for Country CMS_DTE_AST_COUNTRY_KEYCHAR3LAND1
RISK_CODERisk Code CMS_DTE_RISK_CODECHAR6CMS_RISK_CODE
SFTY_INDIndicates if the Asset has a Default Safety Discount CMS_DTE_IND_SFTY_DISCCHAR2CMS_IND_SFTY
SFTY_DSCNTPercentage of Safety Discount CMS_DTE_SAFETY_DSCNTDEC10(6) CMS_SFTY_PCT
SFTY_AMOUNTAmount of Safety Discount CMS_DTE_SAFETY_AMTCURR17(2) CMS_AMOUNT
SFTY_AMT_CURRCurrency of the Safety Discount Amount CMS_DTE_SAFETY_AMT_CURRCUKY5WAERS
OBJSYSIDObject System Reference ID CMS_DTE_OBJ_SYSIDCHAR6CMS_SYSCMS_OBJSYSTEMIDCMS_OBJ_SYS
VALUATION_TYPType of Valuation Check performed on Collateral Object CMS_DTE_IND_VALN_TYPCHAR2CMS_VALN_TYP
UNIT_VALN_FREQIndicator: Units of time for revaluation of an asset CMS_DTE_IND_AST_VALN_FREQ_UNITCHAR2CMS_IND_AST_VALN_FREQ_UNIT
PERIOD_VALN_FREQRevaluation Period for an Asset CMS_DTE_AST_VALN_FREQ_PERIODNUMC4CMS_AST_VALN_FREQ_PERIOD
PAST_VALUED_DATELast Date on which the Asset was Valued CMS_DTE_VALN_DATEDATS8CMS_DATE
START_DATEDate on which the First Valuation is Performed on the Asset CMS_DTE_START_DATEDATS8CMS_DATE
END_DATEDate on which the Last Valuation is Performed on the Asset CMS_DTE_END_DATEDATS8CMS_DATE
LENDING_RATE_INDIndicator to specify if Asset has a Default Lending Rate CMS_DTE_IND_LND_RTECHAR2CMS_IND_LRTE
LENDING_RATE1Lending Rate 1 CMS_DTE_LRTE_PCT1DEC10(6) CMS_PCT
LENDING_RATE2Lending Rate 2 CMS_DTE_LRTE_PCT2DEC10(6) CMS_PCT
LENDING_RATE3Lending Rate 3 CMS_DTE_LRTE_PCT3DEC10(6) CMS_PCT
LENDING_RATE4Lending Rate 4 CMS_DTE_LRTE_PCT4DEC10(6) CMS_PCT
LENDING_RATE5Lending Rate 5 CMS_DTE_LRTE_PCT5DEC10(6) CMS_PCT
LIQD_TYPLiquidation Type CMS_DTE_LIQD_TYPCHAR6CMS_TYPCMS_AST_LIQTYP
LIQD_REASONLiquidation Reason CMS_DTE_ATT_ID_TY_AST004CHAR6CMS_ATT_ID_TYP
LIQD_DATEDate on which the Collateral was Liquidated CMS_DTE_LIQD_DATEDATS8CMS_DATE
LIQD_AMTReturns from the Liquidation of Collateral CMS_DTE_LIQD_VALUECURR17(2) CMS_AMOUNT
LIQD_CURRCurrency of Liquidation Value CMS_DTE_LIQD_CURRCUKY5WAERS
EXP_PRCD_AMNTExpected Proceed Amount CMS_DTE_LIQ_EXP_PRCD_AMOUNTCURR17(2) CMS_AMOUNT
EXP_PRCD_CURRCurrency: Expected Proceed CMS_DTE_LIQ_EXP_PRCD_CURRCUKY5WAERS
EXP_ACC_DATEExpected accrual date CMS_DTE_LIQ_EXP_ACCRUAL_DATEDATS8CMS_DATE
ACC_NUMBER_LIQAccount number for liquidation proceeds CMS_DTE_LIQ_ACC_NUMBERCHAR35BANKN35
BANK_CNTRY_LIQBank country key CMS_DTE_LIQ_BNK_CTRY_KYCHAR3LAND1
BANK_KEY_LIQBank Key CMS_DTE_LIQ_BNK_KEYCHAR15BANKKBNK
BANK_CTRLKEY_LIQBank Control Key BKONTCHAR2BKONT
UNIT_VERF_FREQIndicator: Units of time for verification of an asset CMS_DTE_IND_AST_VERF_FREQ_UNITCHAR2CMS_IND_AST_VERF_FREQ_UNIT
PERIOD_VERF_FREQStatement Period for an Asset CMS_DTE_AST_VERF_FREQ_PERIODNUMC4CMS_AST_VERF_FREQ_PERIOD
LAST_VERF_DATELast Verification Date CMS_DTE_AST_VERF_DATEDATS8CMS_DATE
AST_GUIDGUID for Table CMS_AST CMS_DTE_AST_GUIDRAW16SYSUUID
AST_TYPAsset Type CMS_DTE_AST_TYPCHAR6CMS_AST_TYPCMS_AST_TYPCMS_AST_TYP
PARENT_GUIDAsset Guid as a parent GUID for a sub-asset CMS_DTE_SAS_PAR_GUIDRAW16SYSUUID
NOM_VALUENominal Value of the Asset CMS_DTE_AST_NOMINAL_VALUECURR17(2) CMS_AMOUNT
NOM_VALUE_CURRCurrency of Nominal value CMS_DTE_AST_NOMINAL_VALUE_CURRCUKY5WAERS
AST_VALUEFinal Asset Value CMS_DTE_AST_VALUECURR17(2) CMS_AMOUNT
AST_VALUE_CURRCurrency of the Final Asset Value CMS_DTE_AST_VALUE_CURRCUKY5WAERS
QUANTITYQuantity CMS_DTE_QTYQUAN13(3) CMS_QTY
UNIT_OF_MEASUREUnit of Measure of Quantity CMS_DTE_UNITUNIT3CUNITMEINS
REC_ATAsset Value Recording Timestamp CMS_DTE_REC_ATDEC15TZNTSTMPS
PUR_PRICEPurchase Price of the Asset CMS_DTE_AST_PURCHASE_PRICECURR17(2) CMS_AMOUNT
PUR_PRICE_CURRCurrency of Purchase Price CMS_DTE_AST_PUR_PRICE_CURRCUKY5WAERS
PUR_DATEDate of Purchase CMS_DTE_AST_PUR_PRICE_DATEDATS8CMS_DATE
ADMIN_ORG_UNITAdministration Organizational Unit CMS_DTE_ADMINORGCHAR12TEXT12CMS_ADMINORG
BANKAREABank Area in Collateral Management CMS_DTE_BANKAREACHAR4CMS_BANKAREACMS_BANKAREA
ORG_UNIT1Organizational Unit 1 CMS_DTE_ORG_UNIT1CHAR10CMS_ORG_UNIT
ORG_UNIT2Organizational Unit 2 CMS_DTE_ORG_UNIT2CHAR10CMS_ORG_UNIT
ORG_UNIT3Organizational Unit 3 CMS_DTE_ORG_UNIT3CHAR10CMS_ORG_UNIT
ORG_UNIT4Organizational Unit 4 CMS_DTE_ORG_UNIT4CHAR10CMS_ORG_UNIT
ORG_UNIT5Organizational Unit 5 CMS_DTE_ORG_UNIT5CHAR10CMS_ORG_UNIT
CREATED_BYLogin ID of the User who created the Record CMS_DTE_USERCHAR12CMS_USER
CREATED_ATCreation Timestamp CMS_DTE_CREATED_ATDEC15TZNTSTMPS
CHANGED_BYLast Changed By CMS_DTE_LAST_CHNG_USERCHAR12CMS_USER
CHANGED_ATChange Timestamp CMS_DTE_CHANGED_ATDEC15TZNTSTMPS
SOURCEOFENTRYSource of Entry CMS_DTE_SOURCE_OF_ENTRYCHAR32CMS_SOURCE
WA_CLAIM_HDR 0
RIG_GUIDRights GUID CMS_DTE_RIG_GUIDRAW16SYSUUID
RIG_CATEGORYObject Category CMS_DTE_OMS_OBJ_CATCHAR6CMS_OBJ_CAT
RIG_TYPRight Type CMS_DTE_RIG_TYPCHAR6CMS_RIG_TYP
RIG_IDRights ID CMS_DTE_RIG_IDCHAR40ALPHACMS_MOV_ID
RIG_CAT_NAMEObject Category Name CMS_DTE_OMS_CAT_NAMECHAR40CMS_OMS_CAT_NAME
RIG_TYP_NAMERight Type Name CMS_DTE_RIG_TYP_NAMECHAR40CMS_RIG_NAME
ADD_DESCRAdditional description of the right CMS_DTE_CLM_DESCCHAR30CMS_DSC
DURATION_BEGINStart date of the right CMS_DTE_RIG_BEGINDATS8CMS_DATE
DURATION_ENDValidity End Date of the Right or Patent CMS_DTE_RIG_ENDDATS8CMS_DATE
CLASSIFICATIONClassification CMS_DTE_MOV_TYPE_FEATCHAR6CMS_MOV_TYPE_FEAT
EXT_ITM_NOExt. Item no / Number for identification of the objects CMS_DTE_OMS_EXT_ITM_NOCHAR40ALPHACMS_OMS_ID
EXT_REFERENCEReference number for the legacy system CMS_DTE_OMS_REF_IDCHAR32CMS_OMS_REFID
DUE_DATEDue date of a claim CMS_DTE_CLM_DUE_DATEDATS8DATUM
COMPOSITIONComposition of the claim CMS_DTE_CLM_COMPCHAR30CMS_DSC
SAV_SUMSavings sum in Percentage (In building savings contracts) CMS_DTE_CLM_SAV_SUMDEC10(6) CMS_SEC_PCT
PROVBADDEBT_AMTProvision doubtful debt amount CMS_DTE_CLM_DBTDBT_AMTCURR17(2) CMS_AMOUNT
PROVBADDEBT_CURRCurrency of Provision of doubfull debt CMS_DTE_CLM_DBTDBT_CURRCUKY5WAERS
ADDR_ID Address of the object (for build.sav.contr./rental claim) CMS_DTE_CLM_ADDRESSCHAR10ALPHAAD_ADDRNUMADMC
ACC_NUMBERAccount number CMS_DTE_CLM_ACC_NUMBERCHAR35BANKN35
BANK_COUNTRY_KEYBank country key CMS_DTE_CLM_BNK_CTRY_KYCHAR3LAND1
BANK_KEYBank Key CMS_DTE_CLM_BNK_KEYCHAR15BANKKBNK
BANK_CTRL_KEYBank Control Key BKONTCHAR2BKONT
DESCRIPTIONDescription CMS_DTE_AST_DESCCHAR30CMS_DSC
OBJECT_REF_IDReference ID for the object CMS_DTE_OBJ_REFIDCHAR40CMS_OBJ_REFID
OBJECT_TYPNot used CMS_DTE_OBJ_TYPCHAR32CMS_OBJ_TYP
COUNTRY_KEYIdentification Key for Country CMS_DTE_AST_COUNTRY_KEYCHAR3LAND1
RISK_CODERisk Code CMS_DTE_RISK_CODECHAR6CMS_RISK_CODE
SFTY_INDIndicates if the Asset has a Default Safety Discount CMS_DTE_IND_SFTY_DISCCHAR2CMS_IND_SFTY
SFTY_DSCNTPercentage of Safety Discount CMS_DTE_SAFETY_DSCNTDEC10(6) CMS_SFTY_PCT
SFTY_AMOUNTAmount of Safety Discount CMS_DTE_SAFETY_AMTCURR17(2) CMS_AMOUNT
SFTY_AMT_CURRCurrency of the Safety Discount Amount CMS_DTE_SAFETY_AMT_CURRCUKY5WAERS
OBJSYSIDObject System Reference ID CMS_DTE_OBJ_SYSIDCHAR6CMS_SYSCMS_OBJSYSTEMIDCMS_OBJ_SYS
VALUATION_TYPType of Valuation Check performed on Collateral Object CMS_DTE_IND_VALN_TYPCHAR2CMS_VALN_TYP
UNIT_VALN_FREQIndicator: Units of time for revaluation of an asset CMS_DTE_IND_AST_VALN_FREQ_UNITCHAR2CMS_IND_AST_VALN_FREQ_UNIT
PERIOD_VALN_FREQRevaluation Period for an Asset CMS_DTE_AST_VALN_FREQ_PERIODNUMC4CMS_AST_VALN_FREQ_PERIOD
PAST_VALUED_DATELast Date on which the Asset was Valued CMS_DTE_VALN_DATEDATS8CMS_DATE
START_DATEDate on which the First Valuation is Performed on the Asset CMS_DTE_START_DATEDATS8CMS_DATE
END_DATEDate on which the Last Valuation is Performed on the Asset CMS_DTE_END_DATEDATS8CMS_DATE
LENDING_RATE_INDIndicator to specify if Asset has a Default Lending Rate CMS_DTE_IND_LND_RTECHAR2CMS_IND_LRTE
LENDING_RATE1Lending Rate 1 CMS_DTE_LRTE_PCT1DEC10(6) CMS_PCT
LENDING_RATE2Lending Rate 2 CMS_DTE_LRTE_PCT2DEC10(6) CMS_PCT
LENDING_RATE3Lending Rate 3 CMS_DTE_LRTE_PCT3DEC10(6) CMS_PCT
LENDING_RATE4Lending Rate 4 CMS_DTE_LRTE_PCT4DEC10(6) CMS_PCT
LENDING_RATE5Lending Rate 5 CMS_DTE_LRTE_PCT5DEC10(6) CMS_PCT
LIQD_TYPLiquidation Type CMS_DTE_LIQD_TYPCHAR6CMS_TYPCMS_AST_LIQTYP
LIQD_REASONLiquidation Reason CMS_DTE_ATT_ID_TY_AST004CHAR6CMS_ATT_ID_TYP
LIQD_DATEDate on which the Collateral was Liquidated CMS_DTE_LIQD_DATEDATS8CMS_DATE
LIQD_AMTReturns from the Liquidation of Collateral CMS_DTE_LIQD_VALUECURR17(2) CMS_AMOUNT
LIQD_CURRCurrency of Liquidation Value CMS_DTE_LIQD_CURRCUKY5WAERS
EXP_PRCD_AMNTExpected Proceed Amount CMS_DTE_LIQ_EXP_PRCD_AMOUNTCURR17(2) CMS_AMOUNT
EXP_PRCD_CURRCurrency: Expected Proceed CMS_DTE_LIQ_EXP_PRCD_CURRCUKY5WAERS
EXP_ACC_DATEExpected accrual date CMS_DTE_LIQ_EXP_ACCRUAL_DATEDATS8CMS_DATE
ACC_NUMBER_LIQAccount number for liquidation proceeds CMS_DTE_LIQ_ACC_NUMBERCHAR35BANKN35
BANK_CNTRY_LIQBank country key CMS_DTE_LIQ_BNK_CTRY_KYCHAR3LAND1
BANK_KEY_LIQBank Key CMS_DTE_LIQ_BNK_KEYCHAR15BANKKBNK
BANK_CTRLKEY_LIQBank Control Key BKONTCHAR2BKONT
UNIT_VERF_FREQIndicator: Units of time for verification of an asset CMS_DTE_IND_AST_VERF_FREQ_UNITCHAR2CMS_IND_AST_VERF_FREQ_UNIT
PERIOD_VERF_FREQStatement Period for an Asset CMS_DTE_AST_VERF_FREQ_PERIODNUMC4CMS_AST_VERF_FREQ_PERIOD
LAST_VERF_DATELast Verification Date CMS_DTE_AST_VERF_DATEDATS8CMS_DATE
AST_GUIDGUID for Table CMS_AST CMS_DTE_AST_GUIDRAW16SYSUUID
AST_TYPAsset Type CMS_DTE_AST_TYPCHAR6CMS_AST_TYPCMS_AST_TYPCMS_AST_TYP
PARENT_GUIDAsset Guid as a parent GUID for a sub-asset CMS_DTE_SAS_PAR_GUIDRAW16SYSUUID
NOM_VALUENominal Value of the Asset CMS_DTE_AST_NOMINAL_VALUECURR17(2) CMS_AMOUNT
NOM_VALUE_CURRCurrency of Nominal value CMS_DTE_AST_NOMINAL_VALUE_CURRCUKY5WAERS
AST_VALUEFinal Asset Value CMS_DTE_AST_VALUECURR17(2) CMS_AMOUNT
AST_VALUE_CURRCurrency of the Final Asset Value CMS_DTE_AST_VALUE_CURRCUKY5WAERS
QUANTITYQuantity CMS_DTE_QTYQUAN13(3) CMS_QTY
UNIT_OF_MEASUREUnit of Measure of Quantity CMS_DTE_UNITUNIT3CUNITMEINS
REC_ATAsset Value Recording Timestamp CMS_DTE_REC_ATDEC15TZNTSTMPS
PUR_PRICEPurchase Price of the Asset CMS_DTE_AST_PURCHASE_PRICECURR17(2) CMS_AMOUNT
PUR_PRICE_CURRCurrency of Purchase Price CMS_DTE_AST_PUR_PRICE_CURRCUKY5WAERS
PUR_DATEDate of Purchase CMS_DTE_AST_PUR_PRICE_DATEDATS8CMS_DATE
ADMIN_ORG_UNITAdministration Organizational Unit CMS_DTE_ADMINORGCHAR12TEXT12CMS_ADMINORG
BANKAREABank Area in Collateral Management CMS_DTE_BANKAREACHAR4CMS_BANKAREACMS_BANKAREA
ORG_UNIT1Organizational Unit 1 CMS_DTE_ORG_UNIT1CHAR10CMS_ORG_UNIT
ORG_UNIT2Organizational Unit 2 CMS_DTE_ORG_UNIT2CHAR10CMS_ORG_UNIT
ORG_UNIT3Organizational Unit 3 CMS_DTE_ORG_UNIT3CHAR10CMS_ORG_UNIT
ORG_UNIT4Organizational Unit 4 CMS_DTE_ORG_UNIT4CHAR10CMS_ORG_UNIT
ORG_UNIT5Organizational Unit 5 CMS_DTE_ORG_UNIT5CHAR10CMS_ORG_UNIT
CREATED_BYLogin ID of the User who created the Record CMS_DTE_USERCHAR12CMS_USER
CREATED_ATCreation Timestamp CMS_DTE_CREATED_ATDEC15TZNTSTMPS
CHANGED_BYLast Changed By CMS_DTE_LAST_CHNG_USERCHAR12CMS_USER
CHANGED_ATChange Timestamp CMS_DTE_CHANGED_ATDEC15TZNTSTMPS
SOURCEOFENTRYSource of Entry CMS_DTE_SOURCE_OF_ENTRYCHAR32CMS_SOURCE
T_SYS_STAT 0
T_USR_STAT 0
T_INS_DOC 0
T_INS_BP 0
T_INS_DATA 0
T_VAL_DATA 0
T_DOCU 0
T_BUPA 0

Key field Non-key field



How do I retrieve data from SAP structure CMS_STR_COR_RIG_REQ using ABAP code?

As CMS_STR_COR_RIG_REQ is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on CMS_STR_COR_RIG_REQ as there is no data to select.

How to access SAP table CMS_STR_COR_RIG_REQ

Within an ECC or HANA version of SAP you can also view further information about CMS_STR_COR_RIG_REQ and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!