DMS_PH_CD1

Transparent Table Application Table
25 Fields 2 CDS Views

DVS: PHIOS of main originals

DMS_PH_CD1 is an SAP database table in S/4HANA. DVS: PHIOS of main originals. It contains 25 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_DocInfoRecdAttchPhysIDDetail view_entity from BASIC Physical id details of attachments
P_DocInfoRecdOriginal view left_outer BASIC

Fields (25)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY phio_id SDOK_PHID Phys. Document
ph_class SDOK_PHCL PHIO Class
loio_id SDOK_LOID Log. document
lo_class SDOK_LOCL LOIO class
state SDOK_PHSTA Tech. Status
descript SDOK_TITEL Title
langu SPRAS Language
crea_user SDOK_CRUSR Created By
crea_time SDOK_CRTST Time Created
chng_user SDOK_CHUSR Last Changed By
chng_time SDOK_CHTST Last Changed At
stor_cat SDOK_STCAT Category
doc_format SDOK_FORM Document format
doc_prot SDOK_DPROT Protection
prop01 SDOK_PRV_S Attribute feature (short version)
prop02 SDOK_PRV_S Attribute feature (short version)
prop03 SDOK_PRV_S Attribute feature (short version)
prop04 SDOK_PRV_S Attribute feature (short version)
prop05 SDOK_PRV_M Attribute feature (mid-length version)
prop06 SDOK_PRV_M Attribute feature (mid-length version)
prop07 SDOK_PRV_M Attribute feature (mid-length version)
prop08 SDOK_PRV_L Attribute feature (long version)
prop09 SDOK_PRV_L Attribute feature (long version)
prop10 SDOK_PRV_L Attribute feature (long version)

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.

-- DVS: PHIOS of main originals
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE DMS_PH_CD1 (
    MANDT,       -- Client [MANDT]
    PHIO_ID,     -- Phys. Document [SDOK_PHID]
    PH_CLASS,    -- PHIO Class [SDOK_PHCL]
    LOIO_ID,     -- Log. document [SDOK_LOID]
    LO_CLASS,    -- LOIO class [SDOK_LOCL]
    STATE,       -- Tech. Status [SDOK_PHSTA]
    DESCRIPT,    -- Title [SDOK_TITEL]
    LANGU,       -- Language [SPRAS]
    CREA_USER,   -- Created By [SDOK_CRUSR]
    CREA_TIME,   -- Time Created [SDOK_CRTST]
    CHNG_USER,   -- Last Changed By [SDOK_CHUSR]
    CHNG_TIME,   -- Last Changed At [SDOK_CHTST]
    STOR_CAT,    -- Category [SDOK_STCAT]
    DOC_FORMAT,  -- Document format [SDOK_FORM]
    DOC_PROT,    -- Protection [SDOK_DPROT]
    PROP01,      -- Attribute feature (short version) [SDOK_PRV_S]
    PROP02,      -- Attribute feature (short version) [SDOK_PRV_S]
    PROP03,      -- Attribute feature (short version) [SDOK_PRV_S]
    PROP04,      -- Attribute feature (short version) [SDOK_PRV_S]
    PROP05,      -- Attribute feature (mid-length version) [SDOK_PRV_M]
    PROP06,      -- Attribute feature (mid-length version) [SDOK_PRV_M]
    PROP07,      -- Attribute feature (mid-length version) [SDOK_PRV_M]
    PROP08,      -- Attribute feature (long version) [SDOK_PRV_L]
    PROP09,      -- Attribute feature (long version) [SDOK_PRV_L]
    PROP10,      -- Attribute feature (long version) [SDOK_PRV_L]
    PRIMARY KEY (MANDT, PHIO_ID)
);

Learn More