HRFIO_D_COXX_D

Transparent Table Application Table
34 Fields 1 CDS Views

Draft table for entity I_HCM_ESSCOMMUNICATIONTP

HRFIO_D_COXX_D is an SAP database table in S/4HANA. Draft table for entity I_HCM_ESSCOMMUNICATIONTP. It contains 34 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_HCM_ESSCommunicationDraft view_entity from BASIC My Communication - Draft

Fields (34)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY hcmpersonnelnumber PERSNO Personnel No.
KEY hcmsubtype SUBTY Subtype
KEY hcmobjectidentification OBJPS Object ID
KEY hcmrecordislocked SPRPS Lock indicator
KEY enddate ENDDA End Date
KEY startdate BEGDA Start Date
KEY hcmsequentialnumber SEQNR IT record no.
KEY hcmdraftsequentialnumber HRFIO_PER_DRAFT_SEQ_NUMBER Sequential Number
hcminfotype INFTY Infotype
lastchangeddate AEDAT Changed On
lastchangedbyuser AENAM Changed By
hcminfotyperecordhastext ITXEX Text exists
hcminfotyperecordscreenctrl ITBLD Screen control
hcmetag SYSUUID_C32 UUID
hcmdefaultdate SYDATUM Current Date
hcmvaliditystartdate HRFIO_PER_VALID_FROM Valid from
hcmvalidityenddate ENDDA End Date
hcmrecordisstoredindatabase ABAP_BOOLEAN Truth Value
hcmvaliditystartdatefieldctrl abap.int1
hcmsubtypetext SBTTX Name
hcmcommunicationtype USRTY Type
hcmcommunicationid SYSID System ID
hcmcommunicationlongid COMM_ID_LONG Long ID/Number
hcmcommunicationphonenumber AD_TLNMBR1 Telephone
hcmtelephonenumberextension AD_TLXTNS1 Extension
hcmcommunicationdata SYSID System ID
draftentitycreationdatetime SYCH_BDL_DRAFT_CREATED_AT Draft Created
draftentitylastchangedatetime SYCH_BDL_DRAFT_LAST_CHANGED_AT Draft Changed
draftadministrativedatauuid SYCH_BDL_DRAFT_ADMIN_UUID Admin. UUID
draftentityoperationcode SYCH_BDL_DRAFT_OPERATION_CODE Operation Code
hasactiveentity SYCH_BDL_DRAFT_HASACTIVE Has active
draftfieldchanges SYCH_BDL_DRAFT_FIELD_CHANGES Draft Changes
component_to_be_changed abap.strg

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.

-- Draft table for entity I_HCM_ESSCOMMUNICATIONTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE HRFIO_D_COXX_D (
    MANDT,                          -- Client [MANDT]
    HCMPERSONNELNUMBER,             -- Personnel No. [PERSNO]
    HCMSUBTYPE,                     -- Subtype [SUBTY]
    HCMOBJECTIDENTIFICATION,        -- Object ID [OBJPS]
    HCMRECORDISLOCKED,              -- Lock indicator [SPRPS]
    ENDDATE,                        -- End Date [ENDDA]
    STARTDATE,                      -- Start Date [BEGDA]
    HCMSEQUENTIALNUMBER,            -- IT record no. [SEQNR]
    HCMDRAFTSEQUENTIALNUMBER,       -- Sequential Number [HRFIO_PER_DRAFT_SEQ_NUMBER]
    HCMINFOTYPE,                    -- Infotype [INFTY]
    LASTCHANGEDDATE,                -- Changed On [AEDAT]
    LASTCHANGEDBYUSER,              -- Changed By [AENAM]
    HCMINFOTYPERECORDHASTEXT,       -- Text exists [ITXEX]
    HCMINFOTYPERECORDSCREENCTRL,    -- Screen control [ITBLD]
    HCMETAG,                        -- UUID [SYSUUID_C32]
    HCMDEFAULTDATE,                 -- Current Date [SYDATUM]
    HCMVALIDITYSTARTDATE,           -- Valid from [HRFIO_PER_VALID_FROM]
    HCMVALIDITYENDDATE,             -- End Date [ENDDA]
    HCMRECORDISSTOREDINDATABASE,    -- Truth Value [ABAP_BOOLEAN]
    HCMVALIDITYSTARTDATEFIELDCTRL,  -- abap.int1
    HCMSUBTYPETEXT,                 -- Name [SBTTX]
    HCMCOMMUNICATIONTYPE,           -- Type [USRTY]
    HCMCOMMUNICATIONID,             -- System ID [SYSID]
    HCMCOMMUNICATIONLONGID,         -- Long ID/Number [COMM_ID_LONG]
    HCMCOMMUNICATIONPHONENUMBER,    -- Telephone [AD_TLNMBR1]
    HCMTELEPHONENUMBEREXTENSION,    -- Extension [AD_TLXTNS1]
    HCMCOMMUNICATIONDATA,           -- System ID [SYSID]
    DRAFTENTITYCREATIONDATETIME,    -- Draft Created [SYCH_BDL_DRAFT_CREATED_AT]
    DRAFTENTITYLASTCHANGEDATETIME,  -- Draft Changed [SYCH_BDL_DRAFT_LAST_CHANGED_AT]
    DRAFTADMINISTRATIVEDATAUUID,    -- Admin. UUID [SYCH_BDL_DRAFT_ADMIN_UUID]
    DRAFTENTITYOPERATIONCODE,       -- Operation Code [SYCH_BDL_DRAFT_OPERATION_CODE]
    HASACTIVEENTITY,                -- Has active [SYCH_BDL_DRAFT_HASACTIVE]
    DRAFTFIELDCHANGES,              -- Draft Changes [SYCH_BDL_DRAFT_FIELD_CHANGES]
    COMPONENT_TO_BE_CHANGED,        -- abap.strg
    PRIMARY KEY (MANDT, HCMPERSONNELNUMBER, HCMSUBTYPE, HCMOBJECTIDENTIFICATION, HCMRECORDISLOCKED, ENDDATE, STARTDATE, HCMSEQUENTIALNUMBER, HCMDRAFTSEQUENTIALNUMBER)
);

Learn More