I_CHGRECDREFROUTINGBSC

CDS View
22 Fields 5 CDS Views

Change Record Reference Object Routing

I_CHGRECDREFROUTINGBSC is a CDS View in S/4HANA. Change Record Reference Object Routing. It contains 22 fields. 5 CDS views read from this table.

CDS Views using this table (5)

ViewTypeJoinVDMDescription
I_ChgRecdRefOrdSpcfcRoutingTP view from TRANSACTIONAL Change Record Reference Object Ord Spcfc Rtg
I_ChgRecdRefRoutingTP view from TRANSACTIONAL Change Record Reference Object Routing TP
I_ChgRecdRefRoutingVersion view from COMPOSITE Change Record Routing with max version
I_ProdnModRefChangeRecord view_entity from COMPOSITE Reference Change Records
N_ChangeRecordObjPgRouting view from Change Record Object Page Routing

Fields (22)

KeyField CDS FieldsUsed in Views
KEY ChangeRecordReferenceUUID ChangeRecordReferenceUUID 2
KEY ChangeRecordUUID ChangeRecordUUID 5
ChangeNumber ChangeNumber 2
ChangeRecordItemRelevance ChangeRecordItemRelevance 3
ChangeRecordReference ChangeRecordReference 3
ChangeRecordReferenceSubtype ChangeRecordReferenceSubtype 2
ChangeRecordReferenceType ChangeRecordReferenceType 3
ChangeRecordRefObjectUUID ChangeRecordRefObjectUUID 2
ChangeRecordVirtualRefInd ChangeRecordVirtualRefInd 2
ChgRecdAuthznGrpText ChgRecdAuthznGrpText 2
ChgRecdCurrentItemProcgStatus ChgRecdCurrentItemProcgStatus 1
ChgRecdItmDSgntr ChgRecdItmDSgntr 1
ChgRecdItmTgtSts ChgRecdItmTgtSts 1
ChgRecdNmbrChgSts ChgRecdNmbrChgSts 2
ChgRecdReasonForChange ChgRecdReasonForChange 2
CreatedByUser CreatedByUser 3
CreationDateTime CreationDateTime 3
ExpdCompltnDte ExpdCompltnDte 2
IsMainReference IsMainReference 2
LastChangeDateTime LastChangeDateTime 3
LastChangedByUser LastChangedByUser 3
ParentChangeRecordRefUUID ParentChangeRecordRefUUID 3

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 Routing
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_CHGRECDREFROUTINGBSC (
    CHANGERECORDREFERENCEUUID,
    CHANGERECORDUUID,
    CHANGENUMBER,
    CHANGERECORDITEMRELEVANCE,
    CHANGERECORDREFERENCE,
    CHANGERECORDREFERENCESUBTYPE,
    CHANGERECORDREFERENCETYPE,
    CHANGERECORDREFOBJECTUUID,
    CHANGERECORDVIRTUALREFIND,
    CHGRECDAUTHZNGRPTEXT,
    CHGRECDCURRENTITEMPROCGSTATUS,
    CHGRECDITMDSGNTR,
    CHGRECDITMTGTSTS,
    CHGRECDNMBRCHGSTS,
    CHGRECDREASONFORCHANGE,
    CREATEDBYUSER,
    CREATIONDATETIME,
    EXPDCOMPLTNDTE,
    ISMAINREFERENCE,
    LASTCHANGEDATETIME,
    LASTCHANGEDBYUSER,
    PARENTCHANGERECORDREFUUID,
    PRIMARY KEY (CHANGERECORDREFERENCEUUID, CHANGERECORDUUID)
);

Learn More