I_CHGRECDREFBOM

CDS View
18 Fields 2 CDS Views

Change Record Reference BOM

I_CHGRECDREFBOM is a CDS View in S/4HANA. Change Record Reference BOM. It contains 18 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_ChangeRecordReferenceBOMTP view from TRANSACTIONAL Change Record Reference Object BOM
I_ChangeRecordReferenceBOMTP_2 view from TRANSACTIONAL Change Record Reference Object BOM

Fields (18)

KeyField CDS FieldsUsed in Views
BillOfMaterialVariant BillOfMaterialVariant 2
BillOfMaterialVariantUsage BillOfMaterialVariantUsage 2
ChangeNumber ChangeNumber 1
ChangeNumberValidFromDate ChangeNumberValidFromDate 1
ChangeRecordRefObjectUUID ChangeRecordRefObjectUUID 2
ChgRecdAuthznGrpText ChgRecdAuthznGrpText 1
ChgRecdCurrentItemProcgStatus ChgRecdCurrentItemProcgStatus 1
ChgRecdDescription ChgRecdDescription 1
ChgRecdEffectivityType ChgRecdEffectivityType 1
ChgRecdNmbrChgSts ChgRecdNmbrChgSts 1
ChgRecdReasonForChange ChgRecdReasonForChange 1
CreatedByUser CreatedByUser 2
CreationDateTime CreationDateTime 2
ExpdCompltnDte ExpdCompltnDte 1
LastChangeDateTime LastChangeDateTime 1
LastChangedByUser LastChangedByUser 2
Material Material 2
Plant Plant 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 BOM
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_CHGRECDREFBOM (
    BILLOFMATERIALVARIANT,
    BILLOFMATERIALVARIANTUSAGE,
    CHANGENUMBER,
    CHANGENUMBERVALIDFROMDATE,
    CHANGERECORDREFOBJECTUUID,
    CHGRECDAUTHZNGRPTEXT,
    CHGRECDCURRENTITEMPROCGSTATUS,
    CHGRECDDESCRIPTION,
    CHGRECDEFFECTIVITYTYPE,
    CHGRECDNMBRCHGSTS,
    CHGRECDREASONFORCHANGE,
    CREATEDBYUSER,
    CREATIONDATETIME,
    EXPDCOMPLTNDTE,
    LASTCHANGEDATETIME,
    LASTCHANGEDBYUSER,
    MATERIAL,
    PLANT
);

Learn More