I_CHANGEMASTER

CDS View

Change Number

I_CHANGEMASTER is a CDS View in S/4HANA. Change Number. It contains 13 fields. 17 CDS views read from this table.

CDS Views using this table (17)

ViewTypeJoinVDMDescription
A_ChangeMaster view from BASIC Change Number Header Data
C_ChangeMasterDEX view_entity from CONSUMPTION Data extraction for ECN Header
C_ChangeMasterDEX_2 view_entity from CONSUMPTION Engineering Change Master
C_ChangeMasterObjPg view from CONSUMPTION Manage Change Masters
C_Changenumbertemp view from CONSUMPTION Change Number Value Help
C_ChgMasterForChgRecordOvPg view from CONSUMPTION Change Master For Change Record Overview Page
C_ProdStrucChangeMasterVH view from CONSUMPTION Product Structure Change Number Value Help
D_ChangeMasterActShiftValidity view_entity from CONSUMPTION Change Master Action Change Validity Date
ESH_N_CHG_NMBR view from
I_BomHeaderChanges view inner BASIC BOM Header Changes
I_ChangeMasterStdVH view from COMPOSITE Change Number
I_ChangeMasterTP view_entity from TRANSACTIONAL Change Number (Transactional Processsing)
I_ChangeMasterVH view from COMPOSITE Change Number
I_MaintTechObjBOMChgNumberVH view_entity from COMPOSITE Change Numbers for TechObjBOM
I_ProductChangeNumberVH view from COMPOSITE Change Numbers applicable for Product
P_BOMItemChanges view inner BASIC
P_ChgNmbrParameterEffectivity view_entity inner BASIC

Fields (13)

KeyField CDS FieldsUsed in Views
KEY ChangeNumber ChangeNumber 4
_ChangeMasterLogAccMActive _ChangeMasterLogAccMActive 1
_ChangeMstrLogAccMUserAuthzn _ChangeMstrLogAccMUserAuthzn 1
_ChgMstrLogAccMSecureIDAssgmt _ChgMstrLogAccMSecureIDAssgmt 1
AuthorizationGroup AuthorizationGroup 2
ChangeNumberCreatedByUser ChangeNumberCreatedByUser 3
ChangeNumberCreationDate ChangeNumberCreationDate 3
ChangeNumberDescription ChangeNumberDescription 4
ChangeNumberFunction ChangeNumberFunction 2
ChangeNumberLastChgdDateTime ChangeNumberLastChgdDateTime 1
ChangeNumberReleaseKey ChangeNumberReleaseKey 2
ChangeNumberStatus ChangeNumberStatus 4
ChangeNumberValidFromDate ChangeNumberValidFromDate 5

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.

-- Change Number
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_CHANGEMASTER (
    CHANGENUMBER,
    _CHANGEMASTERLOGACCMACTIVE,
    _CHANGEMSTRLOGACCMUSERAUTHZN,
    _CHGMSTRLOGACCMSECUREIDASSGMT,
    AUTHORIZATIONGROUP,
    CHANGENUMBERCREATEDBYUSER,
    CHANGENUMBERCREATIONDATE,
    CHANGENUMBERDESCRIPTION,
    CHANGENUMBERFUNCTION,
    CHANGENUMBERLASTCHGDDATETIME,
    CHANGENUMBERRELEASEKEY,
    CHANGENUMBERSTATUS,
    CHANGENUMBERVALIDFROMDATE,
    PRIMARY KEY (CHANGENUMBER)
);