MASTERRECIPEREFERENCE

25 Fields

MASTERRECIPEREFERENCE is an SAP database table in S/4HANA. It contains 25 fields.

Fields (25)

KeyField CDS FieldsUsed in Views
KEY ChangeRecordReferenceUUID ChangeRecordReferenceUUID 2
ChangeNumber ChangeNumber 2
ChangeRecordItemProcgStatus ChangeRecordItemProcgStatus 2
ChangeRecordItemRelevance ChangeRecordItemRelevance 2
ChangeRecordLifecycleStatus ChangeRecordLifecycleStatus 1
ChangeRecordReference ChangeRecordReference 2
ChangeRecordReferenceSubtype ChangeRecordReferenceSubtype 2
ChangeRecordReferenceType ChangeRecordReferenceType 2
ChangeRecordRefObjectUUID ChangeRecordRefObjectUUID 2
ChangeRecordStatus ChangeRecordStatus 1
ChangeRecordUUID ChangeRecordUUID 2
ChangeRecordVirtualRefInd ChangeRecordVirtualRefInd 2
ChgRecdAuthznGrpText ChgRecdAuthznGrpText 1
ChgRecdCurrentItemProcgStatus ChgRecdCurrentItemProcgStatus 2
ChgRecdItmDSgntr ChgRecdItmDSgntr 2
ChgRecdItmTgtSts ChgRecdItmTgtSts 2
ChgRecdNmbrChgSts ChgRecdNmbrChgSts 1
ChgRecdReasonForChange ChgRecdReasonForChange 1
CreatedByUser CreatedByUser 2
CreationDateTime CreationDateTime 2
ExpdCompltnDte ExpdCompltnDte 1
IsMainReference IsMainReference 2
LastChangeDateTime LastChangeDateTime 2
LastChangedByUser LastChangedByUser 2
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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MASTERRECIPEREFERENCE (
    CHANGERECORDREFERENCEUUID,
    CHANGENUMBER,
    CHANGERECORDITEMPROCGSTATUS,
    CHANGERECORDITEMRELEVANCE,
    CHANGERECORDLIFECYCLESTATUS,
    CHANGERECORDREFERENCE,
    CHANGERECORDREFERENCESUBTYPE,
    CHANGERECORDREFERENCETYPE,
    CHANGERECORDREFOBJECTUUID,
    CHANGERECORDSTATUS,
    CHANGERECORDUUID,
    CHANGERECORDVIRTUALREFIND,
    CHGRECDAUTHZNGRPTEXT,
    CHGRECDCURRENTITEMPROCGSTATUS,
    CHGRECDITMDSGNTR,
    CHGRECDITMTGTSTS,
    CHGRECDNMBRCHGSTS,
    CHGRECDREASONFORCHANGE,
    CREATEDBYUSER,
    CREATIONDATETIME,
    EXPDCOMPLTNDTE,
    ISMAINREFERENCE,
    LASTCHANGEDATETIME,
    LASTCHANGEDBYUSER,
    PARENTCHANGERECORDREFUUID,
    PRIMARY KEY (CHANGERECORDREFERENCEUUID)
);

Learn More