P_CHGRECDREFBOMITMVIRT

CDS View
35 Fields 2 CDS Views

Private view for BOM Item Reference (Virtual)

P_CHGRECDREFBOMITMVIRT is a CDS View in S/4HANA. Private view for BOM Item Reference (Virtual). It contains 35 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_ChgRecdRefBOMItmDataMigrtn view union_all COMPOSITE Change Record Reference BIT Data Mgrtn
P_ChgRecdRefBOMItm view from TRANSACTIONAL Private view for BOM Item Reference

Fields (35)

KeyField CDS FieldsUsed in Views
_ChangeRecordBsc _ChangeRecordBsc 1
BillOfMaterial BillOfMaterial 1
BillOfMaterialComponent BillOfMaterialComponent 1
BillOfMaterialItemNumber BillOfMaterialItemNumber 1
BillOfMaterialItemUUID BillOfMaterialItemUUID 1
BillOfMaterialVariant BillOfMaterialVariant 1
BillOfMaterialVariantUsage BillOfMaterialVariantUsage 1
ChangeNumber ChangeNumber 1
ChangeRecord ChangeRecord 1
ChangeRecordItemProcgStatus ChangeRecordItemProcgStatus 1
ChangeRecordItemRelevance ChangeRecordItemRelevance 1
ChangeRecordReference ChangeRecordReference 1
ChangeRecordReferenceSubtype ChangeRecordReferenceSubtype 1
ChangeRecordReferenceType ChangeRecordReferenceType 1
ChangeRecordUUID ChangeRecordUUID 1
ChangeRecordVirtualRefInd ChangeRecordVirtualRefInd 1
ChgRecdAuthznGrpText ChgRecdAuthznGrpText 1
ChgRecdDataMigrationStatus ChgRecdDataMigrationStatus 1
ChgRecdItmDSgntr ChgRecdItmDSgntr 1
ChgRecdItmTgtSts ChgRecdItmTgtSts 1
ChgRecdNmbrChgSts ChgRecdNmbrChgSts 1
ChgRecdReasonForChange ChgRecdReasonForChange 1
ChgRecRefInternalKey1 ChgRecRefInternalKey1 1
ChgRecRefInternalKey2 ChgRecRefInternalKey2 1
ChgRecRefInternalKey3 ChgRecRefInternalKey3 1
ChgRecRefInternalKey4 ChgRecRefInternalKey4 1
CreatedByUser CreatedByUser 1
CreationDateTime CreationDateTime 1
ExpdCompltnDte ExpdCompltnDte 1
IsMainReference IsMainReference 1
LastChangeDateTime LastChangeDateTime 1
LastChangedByUser LastChangedByUser 1
Material Material 1
ParentChangeRecordRefUUID ParentChangeRecordRefUUID 1
Plant Plant 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.

-- Private view for BOM Item Reference (Virtual)
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_CHGRECDREFBOMITMVIRT (
    _CHANGERECORDBSC,
    BILLOFMATERIAL,
    BILLOFMATERIALCOMPONENT,
    BILLOFMATERIALITEMNUMBER,
    BILLOFMATERIALITEMUUID,
    BILLOFMATERIALVARIANT,
    BILLOFMATERIALVARIANTUSAGE,
    CHANGENUMBER,
    CHANGERECORD,
    CHANGERECORDITEMPROCGSTATUS,
    CHANGERECORDITEMRELEVANCE,
    CHANGERECORDREFERENCE,
    CHANGERECORDREFERENCESUBTYPE,
    CHANGERECORDREFERENCETYPE,
    CHANGERECORDUUID,
    CHANGERECORDVIRTUALREFIND,
    CHGRECDAUTHZNGRPTEXT,
    CHGRECDDATAMIGRATIONSTATUS,
    CHGRECDITMDSGNTR,
    CHGRECDITMTGTSTS,
    CHGRECDNMBRCHGSTS,
    CHGRECDREASONFORCHANGE,
    CHGRECREFINTERNALKEY1,
    CHGRECREFINTERNALKEY2,
    CHGRECREFINTERNALKEY3,
    CHGRECREFINTERNALKEY4,
    CREATEDBYUSER,
    CREATIONDATETIME,
    EXPDCOMPLTNDTE,
    ISMAINREFERENCE,
    LASTCHANGEDATETIME,
    LASTCHANGEDBYUSER,
    MATERIAL,
    PARENTCHANGERECORDREFUUID,
    PLANT
);

Learn More