I_CHGRECDREFPURORDBSC

CDS View
22 Fields 2 CDS Views

Change Record Reference Object Pur Ord

I_CHGRECDREFPURORDBSC is a CDS View in S/4HANA. Change Record Reference Object Pur Ord. It contains 22 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_ChgRecdRefPurOrdTP view from TRANSACTIONAL Change Record Reference Object Pur Ord
N_ChangeRecordObjPgPurOrd view from Change Record Reference Object Page Pur Ord

Fields (22)

KeyField CDS FieldsUsed in Views
KEY ChangeRecordReferenceUUID ChangeRecordReferenceUUID 1
ChangeNumber ChangeNumber 1
ChangeRecordItemProcgStatus ChangeRecordItemProcgStatus 1
ChangeRecordItemRelevance ChangeRecordItemRelevance 2
ChangeRecordReference ChangeRecordReference 2
ChangeRecordReferenceSubtype ChangeRecordReferenceSubtype 1
ChangeRecordReferenceType ChangeRecordReferenceType 2
ChangeRecordRefObjectUUID ChangeRecordRefObjectUUID 1
ChangeRecordUUID ChangeRecordUUID 2
ChangeRecordVirtualRefInd ChangeRecordVirtualRefInd 1
ChgRecdAuthznGrpText ChgRecdAuthznGrpText 1
ChgRecdItmDSgntr ChgRecdItmDSgntr 1
ChgRecdItmTgtSts ChgRecdItmTgtSts 1
ChgRecdNmbrChgSts ChgRecdNmbrChgSts 1
ChgRecdReasonForChange ChgRecdReasonForChange 1
CreatedByUser CreatedByUser 2
CreationDateTime CreationDateTime 2
ExpdCompltnDte ExpdCompltnDte 1
IsMainReference IsMainReference 1
LastChangeDateTime LastChangeDateTime 2
LastChangedByUser LastChangedByUser 1
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 Reference Object Pur Ord
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_CHGRECDREFPURORDBSC (
    CHANGERECORDREFERENCEUUID,
    CHANGENUMBER,
    CHANGERECORDITEMPROCGSTATUS,
    CHANGERECORDITEMRELEVANCE,
    CHANGERECORDREFERENCE,
    CHANGERECORDREFERENCESUBTYPE,
    CHANGERECORDREFERENCETYPE,
    CHANGERECORDREFOBJECTUUID,
    CHANGERECORDUUID,
    CHANGERECORDVIRTUALREFIND,
    CHGRECDAUTHZNGRPTEXT,
    CHGRECDITMDSGNTR,
    CHGRECDITMTGTSTS,
    CHGRECDNMBRCHGSTS,
    CHGRECDREASONFORCHANGE,
    CREATEDBYUSER,
    CREATIONDATETIME,
    EXPDCOMPLTNDTE,
    ISMAINREFERENCE,
    LASTCHANGEDATETIME,
    LASTCHANGEDBYUSER,
    PARENTCHANGERECORDREFUUID,
    PRIMARY KEY (CHANGERECORDREFERENCEUUID)
);

Learn More