I_CHGRECDREFPRODNROUTINGBSC

CDS View

Change Record Ref Obj Production Routing

I_CHGRECDREFPRODNROUTINGBSC is a CDS View in S/4HANA. Change Record Ref Obj Production Routing. It contains 19 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_ChangeRecdRefProdnRtgTP_2 view from TRANSACTIONAL Change Record Reference Object Prodn Routing
I_ChgRecdRefProdnRoutingTP view from TRANSACTIONAL Change Record Reference Object Production Routing TP

Fields (19)

KeyField CDS FieldsUsed in Views
KEY ChangeRecordReferenceUUID ChangeRecordReferenceUUID 2
ChangeRecord ChangeRecord 1
ChangeRecordItemProcgStatus ChangeRecordItemProcgStatus 2
ChangeRecordItemRelevance ChangeRecordItemRelevance 2
ChangeRecordReference ChangeRecordReference 1
ChangeRecordReferenceSubtype ChangeRecordReferenceSubtype 1
ChangeRecordReferenceType ChangeRecordReferenceType 2
ChangeRecordRefObjectUUID ChangeRecordRefObjectUUID 1
ChangeRecordUUID ChangeRecordUUID 2
ChangeRecordVirtualRefInd ChangeRecordVirtualRefInd 1
ChgRecdCurrentItemProcgStatus ChgRecdCurrentItemProcgStatus 1
ChgRecdItmDSgntr ChgRecdItmDSgntr 1
ChgRecdItmTgtSts ChgRecdItmTgtSts 1
CreatedByUser CreatedByUser 2
CreationDateTime CreationDateTime 2
IsMainReference IsMainReference 1
LastChangeDateTime LastChangeDateTime 2
LastChangedByUser LastChangedByUser 2
ParentChangeRecordRefUUID ParentChangeRecordRefUUID 1

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 Obj Production Routing
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_CHGRECDREFPRODNROUTINGBSC (
    CHANGERECORDREFERENCEUUID,
    CHANGERECORD,
    CHANGERECORDITEMPROCGSTATUS,
    CHANGERECORDITEMRELEVANCE,
    CHANGERECORDREFERENCE,
    CHANGERECORDREFERENCESUBTYPE,
    CHANGERECORDREFERENCETYPE,
    CHANGERECORDREFOBJECTUUID,
    CHANGERECORDUUID,
    CHANGERECORDVIRTUALREFIND,
    CHGRECDCURRENTITEMPROCGSTATUS,
    CHGRECDITMDSGNTR,
    CHGRECDITMTGTSTS,
    CREATEDBYUSER,
    CREATIONDATETIME,
    ISMAINREFERENCE,
    LASTCHANGEDATETIME,
    LASTCHANGEDBYUSER,
    PARENTCHANGERECORDREFUUID,
    PRIMARY KEY (CHANGERECORDREFERENCEUUID)
);