CMS_AST_DOC

Transparent Table Application Table
14 Fields 2 CDS Views

Asset Documents

CMS_AST_DOC is an SAP database table in S/4HANA. Asset Documents. It contains 14 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_CollateralAssetDocument view_entity from BASIC Collateral Asset Document Details
I_ObjectAssetDocument view from BASIC Object Asset Document Details

Fields (14)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY ast_doc_guid CMS_DTE_AST_DOC_GUID ASTDOCGUID
ast_guid CMS_DTE_AST_GUID AST_GUID
doc_referenceid CMS_DTE_REF_DOCID Ref. Doc ID
doc_type CMS_DTE_DOC_TYP Document Type
doc_date CMS_DTE_DOC_DATE Document Date
physical_locn CMS_DTE_DOC_ATT_ID_TY_DOC001 Physical Locn
valid_from CMS_DTE_DOC_VALID_FROM Valid From
valid_to CMS_DTE_DOC_VALID_TO Valid To
created_by CMS_DTE_USER Created by
created_at CMS_DTE_CREATED_AT Created At
changed_by CMS_DTE_LAST_CHNG_USER Last Changed by
changed_at CMS_DTE_CHANGED_AT Changed At
sourceofentry CMS_DTE_SOURCE_OF_ENTRY Source Of Entry

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Asset Documents
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CMS_AST_DOC (
    MANDT,            -- Client [MANDT]
    AST_DOC_GUID,     -- ASTDOCGUID [CMS_DTE_AST_DOC_GUID]
    AST_GUID,         -- AST_GUID [CMS_DTE_AST_GUID]
    DOC_REFERENCEID,  -- Ref. Doc ID [CMS_DTE_REF_DOCID]
    DOC_TYPE,         -- Document Type [CMS_DTE_DOC_TYP]
    DOC_DATE,         -- Document Date [CMS_DTE_DOC_DATE]
    PHYSICAL_LOCN,    -- Physical Locn [CMS_DTE_DOC_ATT_ID_TY_DOC001]
    VALID_FROM,       -- Valid From [CMS_DTE_DOC_VALID_FROM]
    VALID_TO,         -- Valid To [CMS_DTE_DOC_VALID_TO]
    CREATED_BY,       -- Created by [CMS_DTE_USER]
    CREATED_AT,       -- Created At [CMS_DTE_CREATED_AT]
    CHANGED_BY,       -- Last Changed by [CMS_DTE_LAST_CHNG_USER]
    CHANGED_AT,       -- Changed At [CMS_DTE_CHANGED_AT]
    SOURCEOFENTRY,    -- Source Of Entry [CMS_DTE_SOURCE_OF_ENTRY]
    PRIMARY KEY (MANDT, AST_DOC_GUID)
);

Learn More