P_CHGRECDREFBITBFRDATAMIGRTN
Change Record Reference BOM Item Before Data Migration
P_CHGRECDREFBITBFRDATAMIGRTN is a CDS View in S/4HANA. Change Record Reference BOM Item Before Data Migration. It contains 35 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_ChgRecdRefBOMItmDataMigrtn | view | from | COMPOSITE | Change Record Reference BIT Data Mgrtn |
Fields (35)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | ChangeRecordReferenceUUID | ChangeRecordReferenceUUID | 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 |
@AbapCatalog.sqlViewName: 'PCHGRECREFBITBDM'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.private: true
@VDM.viewType: #COMPOSITE
define view P_ChgRecdRefBITBfrDataMigrtn
as select from I_ChgRecdRefBOMItmBsc as reference_bit
inner join I_ChgRecdRefBOMComponent as BOMItem on reference_bit.ChgRecRefInternalKey1 = BOMItem.BillOfMaterialCategory
and reference_bit.ChgRecRefInternalKey2 = BOMItem.BillOfMaterial
and reference_bit.ChgRecRefInternalKey3 = BOMItem.BillOfMaterialVariant
and reference_bit.ChgRecRefInternalKey4 = BOMItem.BillOfMaterialItemNumber
{
key reference_bit.ChangeRecordReferenceUUID,
BOMItem._MaterialBOMLink.Material,
BOMItem._MaterialBOMLink.Plant,
BOMItem._MaterialBOMLink.BillOfMaterialVariantUsage,
BOMItem._MaterialBOMLink.BillOfMaterialVariant,
BOMItem.BillOfMaterialItemUUID,
cast( BOMItem.BillOfMaterialItemNumber as cs_sposn preserving type ) as BillOfMaterialItemNumber,
BOMItem.BillOfMaterialComponent,
cast( BOMItem.BillOfMaterial as cs_stlnr preserving type ) as BillOfMaterial,
reference_bit.ChangeRecord,
reference_bit.ChangeRecordUUID,
reference_bit.ChangeRecordReferenceType,
reference_bit.ChangeRecordReferenceSubtype,
reference_bit.ChangeRecordReference,
reference_bit.ParentChangeRecordRefUUID,
reference_bit.IsMainReference,
reference_bit.ChgRecRefInternalKey1,
reference_bit.ChgRecRefInternalKey2,
reference_bit.ChgRecRefInternalKey3,
reference_bit.ChgRecRefInternalKey4,
reference_bit.ChgRecdReasonForChange,
reference_bit.ExpdCompltnDte,
reference_bit.ChgRecdAuthznGrpText,
reference_bit.ChgRecdNmbrChgSts,
// reference.internal_guid as ChgRecRefInternalGUID,
// reference_ext.customer_no as ChangeRecordReferenceCustNo,
reference_bit.CreatedByUser,
reference_bit.CreationDateTime,
reference_bit.LastChangedByUser,
reference_bit.LastChangeDateTime,
reference_bit.ChangeRecordVirtualRefInd,
reference_bit.ChangeRecordItemRelevance,
reference_bit.ChgRecdDataMigrationStatus,
reference_bit.ChangeRecordItemProcgStatus,
reference_bit.ChgRecdItmTgtSts,
reference_bit.ChgRecdItmDSgntr,
reference_bit.ChangeNumber,
@ObjectModel.association.type: [ #TO_COMPOSITION_PARENT, #TO_COMPOSITION_ROOT ]
reference_bit._ChangeRecordBsc
}