I_CHGRECDREFBOMBSC

CDS View
29 Fields 4 CDS Views

Change Record Reference Object BOM

I_CHGRECDREFBOMBSC is a CDS View in S/4HANA. Change Record Reference Object BOM. It contains 29 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
P_ChgRecdRefBOMAfterDataMigrtn view from COMPOSITE
P_ChgRecdRefBOMBfrDataMigrtn view from COMPOSITE
P_ChgRecdRefBOMDataMigrtn view from COMPOSITE
P_ChgRecdRefBOMVirtual view from COMPOSITE

Fields (29)

KeyField CDS FieldsUsed in Views
KEY ChangeRecordReferenceUUID ChangeRecordReferenceUUID 3
ChangeNumber ChangeNumber 4
ChangeRecord ChangeRecord 4
ChangeRecordItemProcgStatus ChangeRecordItemProcgStatus 4
ChangeRecordItemRelevance ChangeRecordItemRelevance 4
ChangeRecordLifecycleStatus ChangeRecordLifecycleStatus 3
ChangeRecordReference ChangeRecordReference 4
ChangeRecordReferenceSubtype ChangeRecordReferenceSubtype 4
ChangeRecordReferenceType ChangeRecordReferenceType 4
ChangeRecordRefObjectUUID ChangeRecordRefObjectUUID 4
ChangeRecordStatus ChangeRecordStatus 3
ChangeRecordUUID ChangeRecordUUID 4
ChangeRecordVirtualRefInd ChangeRecordVirtualRefInd 4
ChgRecdAuthznGrpText ChgRecdAuthznGrpText 3
ChgRecdDataMigrationStatus ChgRecdDataMigrationStatus 3
ChgRecdItmDSgntr ChgRecdItmDSgntr 3
ChgRecdItmTgtSts ChgRecdItmTgtSts 3
ChgRecdNmbrChgSts ChgRecdNmbrChgSts 3
ChgRecdReasonForChange ChgRecdReasonForChange 3
ChgRecRefInternalKey1 ChgRecRefInternalKey1 4
ChgRecRefInternalKey2 ChgRecRefInternalKey2 4
ChgRecRefInternalKey3 ChgRecRefInternalKey3 4
CreatedByUser CreatedByUser 4
CreationDateTime CreationDateTime 4
ExpdCompltnDte ExpdCompltnDte 3
IsMainReference IsMainReference 4
LastChangeDateTime LastChangeDateTime 4
LastChangedByUser LastChangedByUser 4
ParentChangeRecordRefUUID ParentChangeRecordRefUUID 4

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 Reference Object BOM
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_CHGRECDREFBOMBSC (
    CHANGERECORDREFERENCEUUID,
    CHANGENUMBER,
    CHANGERECORD,
    CHANGERECORDITEMPROCGSTATUS,
    CHANGERECORDITEMRELEVANCE,
    CHANGERECORDLIFECYCLESTATUS,
    CHANGERECORDREFERENCE,
    CHANGERECORDREFERENCESUBTYPE,
    CHANGERECORDREFERENCETYPE,
    CHANGERECORDREFOBJECTUUID,
    CHANGERECORDSTATUS,
    CHANGERECORDUUID,
    CHANGERECORDVIRTUALREFIND,
    CHGRECDAUTHZNGRPTEXT,
    CHGRECDDATAMIGRATIONSTATUS,
    CHGRECDITMDSGNTR,
    CHGRECDITMTGTSTS,
    CHGRECDNMBRCHGSTS,
    CHGRECDREASONFORCHANGE,
    CHGRECREFINTERNALKEY1,
    CHGRECREFINTERNALKEY2,
    CHGRECREFINTERNALKEY3,
    CREATEDBYUSER,
    CREATIONDATETIME,
    EXPDCOMPLTNDTE,
    ISMAINREFERENCE,
    LASTCHANGEDATETIME,
    LASTCHANGEDBYUSER,
    PARENTCHANGERECORDREFUUID,
    PRIMARY KEY (CHANGERECORDREFERENCEUUID)
);

Learn More