CMS_STR_COR_SEC_REQ SAP (Securities) Structure details

Dictionary Type: Structure
Description: Securities




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




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

CMS_STR_COR_SEC_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 "Securities" 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_SEC_REQ TYPE CMS_STR_COR_SEC_REQ.

The CMS_STR_COR_SEC_REQ table consists of various fields, each holding specific information or linking keys about Securities 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_SEC_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_SEC_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_SEC_ACT 0
SEC_ACC_GUIDGUID for securities account CMS_DTE_SEC_ACC_GUIDRAW16SYSUUID
DEPO_BANK_IDDepository Bank Identification CMS_DTE_SEC_DEPO_BNK_IDCHAR18CMS_SEC_DEPO_BNK_IDCMS_SEC_DEPO_BANK_ID
ACCOUNT_NUMBERSecurities Account Identification Number CMS_DTE_SEC_ACC_NUMBERCHAR20CMS_SEC_ACC_IDCMS_SEC_ACC_NO
SEC_ACC_DESCDescription of the Securities Account CMS_DTE_SEC_ACC_DESCCHAR30CMS_SEC_DESC
ACC_OLD_REF_NOID of a Securities Account Referenced from External System CMS_DTE_SEC_ACC_REF_NOCHAR32CMS_SEC_EXT_REFID
SEC_ACC_VALValue of the Securities Account CMS_DTE_SEC_ACC_VAL_AMTCURR17(2) CMS_SEC_AMOUNT
SEC_ACC_VAL_CURRCurrency of Securities Account Value CMS_DTE_SEC_ACC_VAL_CURRCUKY5WAERS
VAL_DATEDate of last valuation CMS_DTE_SEC_ACC_VAL_DATEDATS8CMS_DATE
ADMIN_ORG_UNITAdministration Organizational Unit CMS_DTE_ADMINORGCHAR12TEXT12CMS_ADMINORG
BANKAREABank Area in Collateral Management CMS_DTE_BANKAREACHAR4CMS_BANKAREACMS_BANKAREA
RISK_CODERisk Code CMS_DTE_SEC_RISK_CODECHAR6CMS_RISK_CODE
SFTY_INDIndicates that the asset has a default sfty discount or not CMS_DTE_SEC_IND_SFTY_DISCCHAR2CMS_IND_SFTY
SFTY_DSCNTSafety discount CMS_DTE_SEC_SAFETY_DSCNTDEC10(6) CMS_SFTY_PCT
SFTY_AMOUNTSafety discount as an amount CMS_DTE_SEC_SAFETY_AMTCURR17(2) CMS_SEC_AMOUNT
SFTY_AMT_CURRCurrency of the Safety discount amount CMS_DTE_SEC_SAFETY_AMT_CURRCUKY5WAERS
UNIT_VALN_FREQIndicator : Valuation Frequency of Securities Account CMS_DTE_SEC_IND_FREQUENCYCHAR2CMS_IND_AST_VALN_FREQ_UNIT
PERIOD_VALN_FREQPeriod of revaluation for securities CMS_DTE_SEC_VALN_FREQ_PERIODNUMC4CMS_AST_VALN_FREQ_PERIOD
START_DATEValuation Start date CMS_DTE_SEC_START_DATEDATS8CMS_DATE
END_DATEValuation End date CMS_DTE_SEC_END_DATEDATS8CMS_DATE
LENDING_RATE_INDIndicates that the asset has a default lending rate or not CMS_DTE_SEC_IND_LND_RTECHAR2CMS_IND_LRTE
LENDING_RATE1Lending rate 1 CMS_DTE_SEC_LRTE_PCT1DEC10(6) CMS_PCT
LIQD_TYPLiquidation type CMS_DTE_SEC_LIQD_TYPCHAR6CMS_TYPCMS_AST_LIQTYP
LIQD_REASONLiquidation Reason CMS_DTE_ATT_ID_TY_AST004CHAR6CMS_ATT_ID_TYP
LIQD_DATEDate of Liquidation of Collateral CMS_DTE_SEC_LIQD_DATEDATS8CMS_DATE
LIQD_AMTProceeds obtained from liquidation of the collateral CMS_DTE_SEC_LIQD_VALUECURR17(2) CMS_SEC_AMOUNT
LIQD_CURRCurrency of Liquidation value CMS_DTE_SEC_LIQD_CURRCUKY5WAERS
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
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
ORG_UNIT1Organizational Unit 1: Assets CMS_DTE_SEC_ORG_UNIT1CHAR10CMS_ORG_UNIT
ORG_UNIT2Organizational Unit 2: Assets CMS_DTE_SEC_ORG_UNIT2CHAR10CMS_ORG_UNIT
ORG_UNIT3Organizational Unit 3: Assets CMS_DTE_SEC_ORG_UNIT3CHAR10CMS_ORG_UNIT
ORG_UNIT4Organizational Unit 4: Assets CMS_DTE_SEC_ORG_UNIT4CHAR10CMS_ORG_UNIT
ORG_UNIT5Organizational Unit 5: Assets CMS_DTE_SEC_ORG_UNIT5CHAR10CMS_ORG_UNIT
CREATED_BYSecurities Add-On User CMS_DTE_SEC_CR_BYCHAR12CMS_USER
CREATED_DATECreated On CMS_DTE_SEC_CR_ONDATS8CMS_DATE
CREATED_TIMECreated At CMS_DTE_SEC_CR_ATTIMS6CMS_TIME
LAST_CHG_BYLast Changed By CMS_DTE_SEC_CH_BYCHAR12CMS_USER
LAST_CHG_DATELast Changed on CMS_DTE_SEC_CH_ONDATS8CMS_DATE
LAST_CHG_TIMELast Changed At CMS_DTE_SEC_CH_ATTIMS6CMS_TIME
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
T_SEC_SYS_ST 0
T_SEC_USR_ST 0
T_SEC_NOTES 0
T_SEC_DOC 0
T_SEC_BP 0
T_SEC_POS 0

Key field Non-key field



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

As CMS_STR_COR_SEC_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_SEC_REQ as there is no data to select.

How to access SAP table CMS_STR_COR_SEC_REQ

Within an ECC or HANA version of SAP you can also view further information about CMS_STR_COR_SEC_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!