The CMS_SEC_ACC_DOC table in SAP ERP or S/4HANA stores Link between securities account and Documents is stored here data. There are total 15 fields in CMS_SEC_ACC_DOC table. The Link between securities account and Documents is stored here table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of CMS_SEC_ACC_DOC table. It is in Securities: General tables and programs & Persistence layer (CMS_SEC) ABAP package and is part of the Securities (FS-CMS-MD-SEC) module.
SAP CMS_SEC_ACC_DOC Table Fields
Following is the list of fields that are available in SAP CMS_SEC_ACC_DOC table. The primary key fields of the table are MANDT (Client), SEC_ACC_DOC_GUID (Document guid of the securities account).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | CLNT (3) | |
| SEC_ACC_DOC_GUID | Document guid of the securities account | CMS_DTE_SEC_ACC_DOC_GUID | RAW (16) | |
| SEC_ACC_GUID | GUID for securities account | CMS_DTE_SEC_ACC_GUID | RAW (16) | |
| DOC_REFERENCEID | Reference Document ID | CMS_DTE_REF_DOCID | CHAR (64) | |
| DOC_TYPE | Document Type | CMS_DTE_DOC_TYP | TCMS_DOC_TYP | CHAR (6) |
| DOC_DATE | Document Date | CMS_DTE_DOC_DATE | DATS (8) | |
| PHYSICAL_LOCN | Physical Location of Document | CMS_DTE_DOC_ATT_ID_TY_DOC001 | TCMS_ATT_ID_TY | CHAR (6) |
| VALID_FROM | Date on which the Document came into effect | CMS_DTE_SEC_DOC_VALID_FROM | NUMC (15) | |
| VALID_TO | Date until which the Document stands valid | CMS_DTE_SEC_DOC_VALID_TO | NUMC (15) | |
| CREATED_BY | Securities Add-On User | CMS_DTE_SEC_CR_BY | CHAR (12) | |
| CREATED_DATE | Created On | CMS_DTE_SEC_CR_ON | DATS (8) | |
| CREATED_TIME | Created At | CMS_DTE_SEC_CR_AT | TIMS (6) | |
| LAST_CHG_BY | Last Changed By | CMS_DTE_SEC_CH_BY | CHAR (12) | |
| LAST_CHG_DATE | Last Changed on | CMS_DTE_SEC_CH_ON | DATS (8) | |
| LAST_CHG_TIME | Last Changed At | CMS_DTE_SEC_CH_AT | TIMS (6) |
