I_CHGRECDREFPLNGSCPBSC

CDS View
25 Fields 9 CDS Views

Change Record Reference Object PLS

I_CHGRECDREFPLNGSCPBSC is a CDS View in S/4HANA. Change Record Reference Object PLS. It contains 25 fields. 9 CDS views read from this table.

CDS Views using this table (9)

ViewTypeJoinVDMDescription
A_ChgRecdRefPlngScope view_entity from COMPOSITE Change Record ref Planning Scope
I_ChgRecdRefPlngScpTP view from TRANSACTIONAL Change Record Reference Object PLS TP
I_PlngScopeDetsAssgdToChgRecd view left_outer COMPOSITE Details of Planning Scopes Assigned to Change Record
N_ChangeRecordObjPgPlngScp view from Change Record Reference Object Page Planning Scope
P_ChgRecdPlngScpProdnPlant view from COMPOSITE
P_EngBOMAndPlngScpAssgd view inner COMPOSITE
P_EngSnpshtChgRecdPlngScp view from COMPOSITE
P_PlngScpAssgdToChgRecd view from COMPOSITE
R_ChgRecdRefPlngScopeTP_2 view_entity from TRANSACTIONAL Change Record ref Planning Scope - TP

Fields (25)

KeyField CDS FieldsUsed in Views
KEY ChangeRecordReferenceUUID ChangeRecordReferenceUUID,ChangeRecordRefPlngScpUUID 8
KEY ChangeRecordUUID ChangeRecordUUID 7
ChangeNumber ChangeNumber 1
ChangeRecord ChangeRecord 5
ChangeRecordItemProcgStatus ChangeRecordItemProcgStatus 2
ChangeRecordItemRelevance ChangeRecordItemRelevance 3
ChangeRecordReference ChangeRecordReference 1
ChangeRecordReferenceSubtype ChangeRecordReferenceSubtype 3
ChangeRecordReferenceType ChangeRecordReferenceType 4
ChangeRecordRefObjectUUID ChangeRecordRefObjectUUID 1
ChangeRecordVirtualRefInd ChangeRecordVirtualRefInd 3
ChgRecdAuthznGrpText ChgRecdAuthznGrpText 1
ChgRecdCurrentItemProcgStatus ChgRecdCurrentItemProcgStatus 1
ChgRecdItmTgtSts ChgRecdItmTgtSts 1
ChgRecdNmbrChgSts ChgRecdNmbrChgSts 1
ChgRecdReasonForChange ChgRecdReasonForChange 1
ChgRecRefInternalKey1 ChgRecRefInternalKey1PlngScp 1
ChgRecRefInternalKey2 ChgRecRefInternalKey2PlngScp 1
CreatedByUser CreatedByUser 4
CreationDateTime CreationDateTime 3
ExpdCompltnDte ExpdCompltnDte 1
IsMainReference IsMainReference 1
LastChangeDateTime LastChangeDateTime 3
LastChangedByUser LastChangedByUser 3
ParentChangeRecordRefUUID ParentChangeRecordRefUUID 4

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

Learn More