I_HCMOBJECT

CDS View

HCM Object

I_HCMOBJECT is a CDS View in S/4HANA. HCM Object. It contains 18 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
C_HCMProcJobListForAdmintr view_entity from CONSUMPTION Jobs managed by a HR Administrator
C_HCMProcOrgUntListForAdmintr view_entity from CONSUMPTION Org Units managed by a HR Administrator
C_HCMProcPosListForAdmintr view_entity from CONSUMPTION Positions managed by a HR Administrator

Fields (18)

KeyField CDS FieldsUsed in Views
KEY EndDate EndDate 1
KEY HCMObjectID HCMObjectID,HCMPosition 2
KEY HCMObjectType HCMObjectType 2
KEY HCMPlanningStatus HCMPlanningStatus 1
KEY HCMPlanVersion HCMPlanVersion 1
KEY HCMSequentialNumber HCMSequentialNumber 1
KEY Language Language 1
KEY StartDate StartDate 1
HCMInfoType HCMInfoType 1
HCMInfoTypeRecordIsHistorical HCMInfoTypeRecordIsHistorical 1
HCMInfoTypeRecordReason HCMInfoTypeRecordReason 1
HCMInfoTypeTextModule HCMInfoTypeTextModule 1
HCMObjectConcatenatedID HCMObjectConcatenatedID 1
HCMObjectDelimitDate HCMObjectDelimitDate 1
HCMObjectShortText HCMObjectShortText 1
HCMObjectText HCMObjectText 2
LastChangedByUser LastChangedByUser 1
LastChangedDate LastChangedDate 1

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.

-- HCM Object
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_HCMOBJECT (
    ENDDATE,
    HCMOBJECTID,
    HCMOBJECTTYPE,
    HCMPLANNINGSTATUS,
    HCMPLANVERSION,
    HCMSEQUENTIALNUMBER,
    LANGUAGE,
    STARTDATE,
    HCMINFOTYPE,
    HCMINFOTYPERECORDISHISTORICAL,
    HCMINFOTYPERECORDREASON,
    HCMINFOTYPETEXTMODULE,
    HCMOBJECTCONCATENATEDID,
    HCMOBJECTDELIMITDATE,
    HCMOBJECTSHORTTEXT,
    HCMOBJECTTEXT,
    LASTCHANGEDBYUSER,
    LASTCHANGEDDATE,
    PRIMARY KEY (ENDDATE, HCMOBJECTID, HCMOBJECTTYPE, HCMPLANNINGSTATUS, HCMPLANVERSION, HCMSEQUENTIALNUMBER, LANGUAGE, STARTDATE)
);