I_CHANGERECORDREFERENCEBOMTP
Change Record Reference Object BOM
I_CHANGERECORDREFERENCEBOMTP is a CDS View in S/4HANA. Change Record Reference Object BOM. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| C_ChangeRecordObjPgBOM | view | from | CONSUMPTION | Change Record Reference Object BOM |
@AbapCatalog.sqlViewName: 'ICHGRECREFBOMTP'
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.compiler.compareFilter: true
@EndUserText.label: 'Change Record Reference Object BOM'
@VDM.viewType: #TRANSACTIONAL
@ObjectModel: {
semanticKey: [ 'Material','Plant','BillOfMaterialVariantUsage','BillOfMaterialVariant', 'ChangeNumberValidFromDate'],
writeDraftPersistence: 'PLMCRREFBOM_D',
createEnabled,
deleteEnabled,
updateEnabled
}
@ObjectModel.usageType: {serviceQuality: #C,
dataClass: #MIXED,
sizeCategory: #XXL}
@AbapCatalog.preserveKey:true
define view I_ChangeRecordReferenceBOMTP
as select from I_ChgRecdRefBOM as reference_bom
association [1..1] to I_ChangeRecordDraftTP as _ChangeRecordTP on $projection.ChangeRecordUUID = _ChangeRecordTP.ChangeRecordUUID
association [0..1] to E_ChgRecdRefBOMBsc as _BOMExtension on $projection.ChangeRecordReferenceUUID = _BOMExtension.ChangeRecordReferenceUUID
{
key ChangeRecordReferenceUUID,
@ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
reference_bom.Material,
@ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
reference_bom.Plant,
@ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
reference_bom.BillOfMaterialVariantUsage,
@ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
reference_bom.BillOfMaterialVariant,
@ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
reference_bom.ChangeNumberValidFromDate,
ChangeRecordUUID,
ChangeRecordReferenceType,
ChangeRecordReferenceSubtype,
ChangeRecordReference,
ParentChangeRecordRefUUID,
IsMainReference,
BillOfMaterialCategory,
@Semantics.user.createdBy: true
reference_bom.CreatedByUser,
reference_bom.CreationDateTime,
@Semantics.user.lastChangedBy: true
reference_bom.LastChangedByUser,
reference_bom.LastChangeDateTime,
reference_bom.ChgRecdReasonForChange,
reference_bom.ExpdCompltnDte,
reference_bom.ChgRecdAuthznGrpText,
reference_bom.ChgRecdNmbrChgSts,
@ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
ChangeRecordItemRelevance,
ChangeRecordVirtualRefInd,
//For BOM Navigation
BillOfMaterial,
reference_bom.ChangeRecordRefObjectUUID,
@ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
ChangeRecordItemProcgStatus,
@ObjectModel.readOnly: true
reference_bom.ChgRecdCurrentItemProcgStatus,
reference_bom.ChangeNumber,
@ObjectModel.readOnly: true
ChgRecdItmTgtSts,
@ObjectModel.readOnly: true
ChgRecdItmDSgntr,
@ObjectModel.readOnly: true
ChangeRecordLifecycleStatus,
@ObjectModel.readOnly: true
ChangeRecordStatus,
@ObjectModel.association.type: [ #TO_COMPOSITION_PARENT, #TO_COMPOSITION_ROOT ]
_ChangeRecordTP
}
where
ChangeRecordReferenceType = 'BOM'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CHGRECDREFBOM"
],
"ASSOCIATED":
[
"E_CHGRECDREFBOMBSC",
"I_CHANGERECORDDRAFTTP"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/