SAP CMS_AST_DOC Asset Documents Table data and field list

CMS_AST_DOC is a standard SAP Table which is used to store Asset Documents data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The CMS_AST_DOC table consists of various fields, each holding specific information or linking keys about Asset Documents data available in SAP. These include AST_DOC_GUID (GUID for Table CMS_AST_DOC), AST_GUID (GUID for Table CMS_AST), DOC_REFERENCEID (Reference Document ID), DOC_TYPE (Document Type)... 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. .

CMS_AST_DOC table Technical Details:

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified


SAP CMS_AST_DOC table fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the CMS_AST_DOC table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.
Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3T000MANDT
AST_DOC_GUIDGUID for Table CMS_AST_DOC CMS_DTE_AST_DOC_GUIDRAW16SYSUUID
AST_GUIDGUID for Table CMS_AST CMS_DTE_AST_GUIDRAW16SYSUUID
DOC_REFERENCEIDReference Document ID CMS_DTE_REF_DOCIDCHAR64CMS_REFID
DOC_TYPEDocument Type CMS_DTE_DOC_TYPCHAR6TCMS_DOC_TYPCMS_DOC_TYPCMS_DOC_TYP
DOC_DATEDocument Date CMS_DTE_DOC_DATEDATS8CMS_DATE
PHYSICAL_LOCNPhysical Location of Document CMS_DTE_DOC_ATT_ID_TY_DOC001CHAR6TCMS_ATT_ID_TYCMS_ATT_ID_TYP
VALID_FROMDate on which the Document came into effect CMS_DTE_DOC_VALID_FROMNUMC15TSTPSTZNTSTMPSL
VALID_TODate until which the Document stands valid CMS_DTE_DOC_VALID_TONUMC15TSTPSTZNTSTMPSL
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

Key field Non-key field



How do I retrieve data from SAP table CMS_AST_DOC using ABAP code

The following ABAP code Example will allow you to do a basic selection on CMS_AST_DOC to SELECT all data from the table
DATA: WA_CMS_AST_DOC TYPE CMS_AST_DOC.

SELECT SINGLE *
FROM CMS_AST_DOC
INTO CORRESPONDING FIELDS OF WA_CMS_AST_DOC
WHERE...

How to access SAP table CMS_AST_DOC

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

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