MASTERRECIPEREFERENCE

26 Fields

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

Fields (26)

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

-- 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,
    CHGRECDDESCRIPTION,
    CHGRECDITMDSGNTR,
    CHGRECDITMTGTSTS,
    CHGRECDNMBRCHGSTS,
    CHGRECDREASONFORCHANGE,
    CREATEDBYUSER,
    CREATIONDATETIME,
    EXPDCOMPLTNDTE,
    ISMAINREFERENCE,
    LASTCHANGEDATETIME,
    LASTCHANGEDBYUSER,
    PARENTCHANGERECORDREFUUID,
    PRIMARY KEY (CHANGERECORDREFERENCEUUID)
);

Learn More