P_CHGRECDREFMBMBFRDATAMIGRTN

CDS View
35 Fields 2 CDS Views

P_CHGRECDREFMBMBFRDATAMIGRTN is a CDS View in S/4HANA. It contains 35 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_ChgRecdRefMBOMDataMigrtn view from COMPOSITE Change Record Reference MBOM Data Mgrtn
I_ChgRecdRefMBOMSrchSupp view from COMPOSITE Change Record Reference MBOM Search Supp

Fields (35)

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

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_CHGRECDREFMBMBFRDATAMIGRTN (
    CHANGERECORDREFERENCEUUID,
    BILLOFMATERIAL,
    BILLOFMATERIALCATEGORY,
    BILLOFMATERIALVARIANT,
    BILLOFMATERIALVARIANTUSAGE,
    BILLOFMATERIALVERSION,
    CHANGENUMBER,
    CHANGERECORD,
    CHANGERECORDITEMPROCGSTATUS,
    CHANGERECORDITEMRELEVANCE,
    CHANGERECORDREFERENCE,
    CHANGERECORDREFERENCESUBTYPE,
    CHANGERECORDREFERENCETYPE,
    CHANGERECORDREFOBJECTUUID,
    CHANGERECORDUUID,
    CHANGERECORDVIRTUALREFIND,
    CHGRECDAUTHZNGRPTEXT,
    CHGRECDDATAMIGRATIONSTATUS,
    CHGRECDITMDSGNTR,
    CHGRECDITMTGTSTS,
    CHGRECDNMBRCHGSTS,
    CHGRECDREASONFORCHANGE,
    CHGRECREFINTERNALKEY1,
    CHGRECREFINTERNALKEY2,
    CHGRECREFINTERNALKEY3,
    CHGRECREFINTERNALKEY4,
    CREATEDBYUSER,
    CREATIONDATETIME,
    EXPDCOMPLTNDTE,
    ISMAINREFERENCE,
    LASTCHANGEDATETIME,
    LASTCHANGEDBYUSER,
    MATERIAL,
    PARENTCHANGERECORDREFUUID,
    PLANT,
    PRIMARY KEY (CHANGERECORDREFERENCEUUID)
);

Learn More