I_CHANGERECORDBSC

CDS View
26 Fields 24 CDS Views

Change Record

I_CHANGERECORDBSC is a CDS View in S/4HANA. Change Record. It contains 26 fields. 24 CDS views read from this table.

CDS Views using this table (24)

ViewTypeJoinVDMDescription
C_ChangeRecord_MyInbox view from CONSUMPTION Change Record My Inbox
C_ChangeRecordClfnChgLog view_entity from CONSUMPTION Change document for Classification in CR
C_ChgMasterForChgRecordOvPg view left_outer CONSUMPTION Change Master For Change Record Overview Page
C_ChgRecdDetsAssgdToEngSnpsht view from CONSUMPTION Change Records assgd to Eng Snapshot
C_ImpctMgmtChangeRecordVH view_entity from CONSUMPTION Impact Analysis for CR
C_MfgPlngExecChgRecdPopover view from CONSUMPTION Change Record Popover
C_MngUnassgdMBOMChangeRecords view from CONSUMPTION All Change Records with an Open Lifecycle Status
C_ProdnModOpenChangeRecordVH view_entity from CONSUMPTION Prodn Model Open Change Record
I_ChangeRecordDraftTP view from TRANSACTIONAL Change Record (Draft 2.0)
I_ChangeRecordHistoryBasic view_entity from BASIC Change Record history
I_ChangeRecordItemValidity view_entity from BASIC Change Record Extended Data
I_ChangeRecordObjPgClfn view from TRANSACTIONAL Classification
I_ChangeRecordRelatedChangeTP view_entity left_outer TRANSACTIONAL Related Change Record TP View
I_ChangeRecordTP view from TRANSACTIONAL Change Record API View
I_ChangeRecordTP_2 view from TRANSACTIONAL Change Record API View
I_DocInfoRecdObjLinkChgRecd view from COMPOSITE DIR Object Link Change Record
I_MfgEngChangeRecordVH view from COMPOSITE Change Record Value Help
I_OrdSpcfcChgRecdOpn view from COMPOSITE Order Specific Open Change Records
I_PlngScopeDetsAssgdToChgRecd view from COMPOSITE Details of Planning Scopes Assigned to Change Record
I_ProdnModRefChangeRecord view_entity inner COMPOSITE Reference Change Records
P_ChangeRecordMyInboxBasic view from TRANSACTIONAL
P_EngBOMAndPlngScpAssgd view from COMPOSITE
P_EngCockpit view from BASIC
P_VersMfgBOMwithCRAssgd view from COMPOSITE

Fields (26)

KeyField CDS FieldsUsed in Views
KEY ChangeRecord ChangeRecord 12
KEY ChangeRecordUUID ChangeRecordUUID,RelatedChangeRecordUUID 8
_LogAccMObjectTypeActive _LogAccMObjectTypeActive 1
_LogAccMObjectUserAuthzn _LogAccMObjectUserAuthzn 2
_LogAccMObjSecureIDAssgmt _LogAccMObjSecureIDAssgmt 2
ChangeNumber ChangeNumber 3
ChangeRecordCategory ChangeRecordCategory 3
ChangeRecordDetailDescription ChangeRecordDetailDescription 1
ChangeRecordLifecycleStatus ChangeRecordLifecycleStatus 5
ChangeRecordPriority ChangeRecordPriority 1
ChangeRecordStatus ChangeRecordStatus 7
ChangeRecordType ChangeRecordType 10
ChgRecdAuthGroup ChgRecdAuthGroup 1
ChgRecdEngEffectiveDate ChgRecdEngEffectiveDate 3
ChgRecdExpectedCompletionDate ChgRecdExpectedCompletionDate 1
ChgRecdMfgEffectiveDate ChgRecdMfgEffectiveDate 2
ChgRecordApplication ChgRecordApplication 3
ChgRecordDescriptionText ChgRecordDescriptionText,RelatedChgRecordDescriptionTxt 9
CreatedByUser CreatedByUser 3
CreationDateTime CreationDateTime 1
LastChangeDateTime LastChangeDateTime 1
LastChangedByUser LastChangedByUser 1
LogAccMSecureIDOwnerID LogAccMSecureIDOwnerID 1
ParentChangeRecordUUID ParentChangeRecordUUID 1
Partner Partner 7
RootChangeRecordUUID RootChangeRecordUUID 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.

-- Change Record
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_CHANGERECORDBSC (
    CHANGERECORD,
    CHANGERECORDUUID,
    _LOGACCMOBJECTTYPEACTIVE,
    _LOGACCMOBJECTUSERAUTHZN,
    _LOGACCMOBJSECUREIDASSGMT,
    CHANGENUMBER,
    CHANGERECORDCATEGORY,
    CHANGERECORDDETAILDESCRIPTION,
    CHANGERECORDLIFECYCLESTATUS,
    CHANGERECORDPRIORITY,
    CHANGERECORDSTATUS,
    CHANGERECORDTYPE,
    CHGRECDAUTHGROUP,
    CHGRECDENGEFFECTIVEDATE,
    CHGRECDEXPECTEDCOMPLETIONDATE,
    CHGRECDMFGEFFECTIVEDATE,
    CHGRECORDAPPLICATION,
    CHGRECORDDESCRIPTIONTEXT,
    CREATEDBYUSER,
    CREATIONDATETIME,
    LASTCHANGEDATETIME,
    LASTCHANGEDBYUSER,
    LOGACCMSECUREIDOWNERID,
    PARENTCHANGERECORDUUID,
    PARTNER,
    ROOTCHANGERECORDUUID,
    PRIMARY KEY (CHANGERECORD, CHANGERECORDUUID)
);

Learn More