I_CHGRECDREFTMPLROUTINGBSC

CDS View
24 Fields 4 CDS Views

Change Record Ref Object Tmpl Routing

I_CHGRECDREFTMPLROUTINGBSC is a CDS View in S/4HANA. Change Record Ref Object Tmpl Routing. It contains 24 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
I_ChangeRecdRefTmplRoutingTP_2 view from TRANSACTIONAL Change Record Reference Object Template Routing
I_ChgRecdRefTmplRoutingTP view from TRANSACTIONAL Chg Record Ref Obj Template Routing
N_ChangeRecordObjPgTmplRouting view from Auxillary view for ESH-Change Record Ref. Obj. Tmpl Routing
P_RTGTMPLCHREC view_entity from COMPOSITE

Fields (24)

KeyField CDS FieldsUsed in Views
KEY ChangeRecordReferenceUUID ChangeRecordReferenceUUID 2
KEY ChgRecRefInternalKey1 BillofOperationsType 1
KEY ChgRecRefInternalKey2 BillofOperationsGroup 1
KEY ChgRecRefInternalKey3 BillofOperationsVariant 1
KEY ChgRecRefInternalKey4 BillofOperationsVersion 1
ChangeNumber ChangeNumber 1
ChangeRecord ChangeRecord 1
ChangeRecordItemRelevance ChangeRecordItemRelevance 2
ChangeRecordReference ChangeRecordReference 2
ChangeRecordReferenceSubtype ChangeRecordReferenceSubtype 2
ChangeRecordReferenceType ChangeRecordReferenceType 2
ChangeRecordRefObjectUUID ChangeRecordRefObjectUUID 2
ChangeRecordUUID ChangeRecordUUID 2
ChangeRecordVirtualRefInd ChangeRecordVirtualRefInd 2
ChgRecdAuthznGrpText ChgRecdAuthznGrpText 1
ChgRecdNmbrChgSts ChgRecdNmbrChgSts 1
ChgRecdReasonForChange ChgRecdReasonForChange 1
CreatedByUser CreatedByUser 3
CreationDateTime CreationDateTime 3
ExpdCompltnDte ExpdCompltnDte 1
IsMainReference IsMainReference 2
LastChangeDateTime LastChangeDateTime 3
LastChangedByUser LastChangedByUser 3
ParentChangeRecordRefUUID ParentChangeRecordRefUUID 2

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 Ref Object Tmpl Routing
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_CHGRECDREFTMPLROUTINGBSC (
    CHANGERECORDREFERENCEUUID,
    CHGRECREFINTERNALKEY1,
    CHGRECREFINTERNALKEY2,
    CHGRECREFINTERNALKEY3,
    CHGRECREFINTERNALKEY4,
    CHANGENUMBER,
    CHANGERECORD,
    CHANGERECORDITEMRELEVANCE,
    CHANGERECORDREFERENCE,
    CHANGERECORDREFERENCESUBTYPE,
    CHANGERECORDREFERENCETYPE,
    CHANGERECORDREFOBJECTUUID,
    CHANGERECORDUUID,
    CHANGERECORDVIRTUALREFIND,
    CHGRECDAUTHZNGRPTEXT,
    CHGRECDNMBRCHGSTS,
    CHGRECDREASONFORCHANGE,
    CREATEDBYUSER,
    CREATIONDATETIME,
    EXPDCOMPLTNDTE,
    ISMAINREFERENCE,
    LASTCHANGEDATETIME,
    LASTCHANGEDBYUSER,
    PARENTCHANGERECORDREFUUID,
    PRIMARY KEY (CHANGERECORDREFERENCEUUID, CHGRECREFINTERNALKEY1, CHGRECREFINTERNALKEY2, CHGRECREFINTERNALKEY3, CHGRECREFINTERNALKEY4)
);

Learn More