I_BOOOpMaterialPRTChangeState

Q: Which tables does I_BOOOpMaterialPRTChangeState use?

I_BOOOpMaterialPRTChangeState reads from 2 data source(s): I_BOOOperationPRTChangeState, I_MaterialPRTByInternalKey.

Q: How many fields does I_BOOOpMaterialPRTChangeState have?

I_BOOOpMaterialPRTChangeState has 58 fields. Key fields: BillOfOperationsType, BillOfOperationsGroup, BillOfOperationsVariant, BillOfOperationsSequence, BOOOperationInternalID.

DDL: I_BOOOPMATERIALPRTCHANGESTATE SQL: IPPBOOOPMATPRTCS Type: view COMPOSITE

BOO Operation Material Production Resource/Tool Change State

I_BOOOpMaterialPRTChangeState is a Composite CDS View (Dimension) that provides data about "BOO Operation Material Production Resource/Tool Change State" in SAP S/4HANA. It reads from 2 data sources (I_BOOOperationPRTChangeState, I_MaterialPRTByInternalKey) and exposes 58 fields with key fields BillOfOperationsType, BillOfOperationsGroup, BillOfOperationsVariant, BillOfOperationsSequence, BOOOperationInternalID. It has 1 association to related views.

Data Sources (2)

Source	Alias	Join Type
I_BOOOperationPRTChangeState	I_BOOOperationPRTChangeState	from
I_MaterialPRTByInternalKey	I_MaterialPRTByInternalKey	inner

Associations (1)

Cardinality	Target	Alias	Condition
[1..1]	I_MaterialPRTByInternalKey	_MaterialPRTByInternalKey	`$projection.ProductionResourceType = _MaterialPRTByInternalKey.ProductionResourceType and $projection.ProductionResourceInternalID = _MaterialPRTByInternalKey.ProductionResourceInternalID`

Annotations (13)

Name	Value	Level
AbapCatalog.sqlViewName	IPPBOOOPMATPRTCS	view
AccessControl.authorizationCheck	#CHECK	view
VDM.viewType	#COMPOSITE	view
Analytics.dataCategory	#DIMENSION	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
ObjectModel.representativeKey	BOOOpMaterialPRTIntVersCounter	view
AbapCatalog.compiler.compareFilter	true	view
ObjectModel.usageType.serviceQuality	#B	view
ObjectModel.usageType.sizeCategory	#M	view
ObjectModel.usageType.dataClass	#MASTER	view
EndUserText.label	BOO Operation Material Production Resource/Tool Change State	view
Metadata.allowExtensions	true	view
AbapCatalog.preserveKey	true	view

Fields (58)

Key	Field	Source Table	Source Field
KEY	BillOfOperationsType	I_BOOOperationPRTChangeState	BillOfOperationsType
KEY	BillOfOperationsGroup	I_BOOOperationPRTChangeState	BillOfOperationsGroup
KEY	BillOfOperationsVariant	I_BOOOperationPRTChangeState	BillOfOperationsVariant
KEY	BillOfOperationsSequence	I_BOOOperationPRTChangeState	BillOfOperationsSequence
KEY	BOOOperationInternalID	I_BOOOperationPRTChangeState	BOOOperationInternalID
KEY	BOOOpMaterialPRTInternalID	I_BOOOperationPRTChangeState	BOOOperationPRTInternalID
KEY	BOOOpMaterialPRTIntVersCounter	I_BOOOperationPRTChangeState	BOOOperationPRTIntVersCounter
	ProductionResourceType	I_BOOOperationPRTChangeState	ProductionResourceType
	ProductionResourceInternalID	I_BOOOperationPRTChangeState	ProductionResourceInternalID
	ValidityStartDate	I_BOOOperationPRTChangeState	ValidityStartDate
	ValidityEndDate		ValidityEndDate
	ChangeNumber	I_BOOOperationPRTChangeState	ChangeNumber
	ProdnRsceToolItemNumber	I_BOOOperationPRTChangeState	ProdnRsceToolItemNumber
	ProdnRsceToolControlProfile	I_BOOOperationPRTChangeState	ProdnRsceToolControlProfile
	ProdnRsceToolStandardTextCode	I_BOOOperationPRTChangeState	ProdnRsceToolStandardTextCode
	ProdnRsceToolText	I_BOOOperationPRTChangeState	ProdnRsceToolText
	CreationDate	I_BOOOperationPRTChangeState	CreationDate
	CreatedByUser	I_BOOOperationPRTChangeState	CreatedByUser
	LastChangeDate	I_BOOOperationPRTChangeState	LastChangeDate
	LastChangedByUser	I_BOOOperationPRTChangeState	LastChangedByUser
	IsDeleted		IsDeleted
	IsImplicitlyDeleted		IsImplicitlyDeleted
	ProdnRsceToolStdWorkQtyUnit	I_BOOOperationPRTChangeState	ProdnRsceToolStdWorkQtyUnit
	ProdnRsceToolStandardWorkQty	I_BOOOperationPRTChangeState	ProdnRsceToolStandardWorkQty
	ProdnRsceToolTotQtyCalcFormula	I_BOOOperationPRTChangeState	ProdnRsceToolTotQtyCalcFormula
	ProdnRsceToolUsageQuantityUnit	I_BOOOperationPRTChangeState	ProdnRsceToolUsageQuantityUnit
	ProdnRsceToolUsageQuantity	I_BOOOperationPRTChangeState	ProdnRsceToolUsageQuantity
	ProdnRsceToolUsageQtyCalcFmla	I_BOOOperationPRTChangeState	ProdnRsceToolUsageQtyCalcFmla
	StartDateOffsetReferenceCode	I_BOOOperationPRTChangeState	StartDateOffsetReferenceCode
	StartDateOffsetDurationUnit	I_BOOOperationPRTChangeState	StartDateOffsetDurationUnit
	StartDateOffsetDuration	I_BOOOperationPRTChangeState	StartDateOffsetDuration
	EndDateOffsetReferenceCode	I_BOOOperationPRTChangeState	EndDateOffsetReferenceCode
	EndDateOffsetDurationUnit	I_BOOOperationPRTChangeState	EndDateOffsetDurationUnit
	EndDateOffsetDuration	I_BOOOperationPRTChangeState	EndDateOffsetDuration
	BillOfOperationsVersion	I_BOOOperationPRTChangeState	BillOfOperationsVersion
	_MaterialPRTByInternalKey		_MaterialPRTByInternalKey
	_BillOfOperationsType	I_BOOOperationPRTChangeState	_BillOfOperationsType
	_BillOfOperationsGroup	I_BOOOperationPRTChangeState	_BillOfOperationsGroup
	_BillOfOperations	I_BOOOperationPRTChangeState	_BillOfOperations
	_BillOfOperationsOperation	I_BOOOperationPRTChangeState	_BillOfOperationsOperation
	_BOOOperationInternalID	I_BOOOperationPRTChangeState	_BOOOperationInternalID
	_BillOfOperationsSequence	I_BOOOperationPRTChangeState	_BillOfOperationsSequence
	_BOOOperationPRTInternalID	I_BOOOperationPRTChangeState	_BOOOperationPRTInternalID
	_ProductionResourceType	I_BOOOperationPRTChangeState	_ProductionResourceType
	_ProdnRsceToolMasterData	I_BOOOperationPRTChangeState	_ProdnRsceToolMasterData
	_ProdnRsceToolControlProfile	I_BOOOperationPRTChangeState	_ProdnRsceToolControlProfile
	_ProdnRsceToolTotQtyCalcFmla	I_BOOOperationPRTChangeState	_ProdnRsceToolTotQtyCalcFmla
	_ProdnRsceToolUsageQtyCalcFmla	I_BOOOperationPRTChangeState	_ProdnRsceToolUsageQtyCalcFmla
	_ProdnRsceToolStandardText	I_BOOOperationPRTChangeState	_ProdnRsceToolStandardText
	_ProductionResourceToolUnit	I_BOOOperationPRTChangeState	_ProductionResourceToolUnit
	_ProdnResourceToolUsageUnit	I_BOOOperationPRTChangeState	_ProdnResourceToolUsageUnit
	_StartDateOffsetReferenceCode	I_BOOOperationPRTChangeState	_StartDateOffsetReferenceCode
	_StartDateOffsetDurationUnit	I_BOOOperationPRTChangeState	_StartDateOffsetDurationUnit
	_EndDateOffsetReferenceCode	I_BOOOperationPRTChangeState	_EndDateOffsetReferenceCode
	_EndDateOffsetDurationUnit	I_BOOOperationPRTChangeState	_EndDateOffsetDurationUnit
	_CreatedByUser	I_BOOOperationPRTChangeState	_CreatedByUser
	_LastChangedByUser	I_BOOOperationPRTChangeState	_LastChangedByUser
	_ChangeMaster	I_BOOOperationPRTChangeState	_ChangeMaster

@AbapCatalog.sqlViewName: 'IPPBOOOPMATPRTCS'
@AccessControl.authorizationCheck: #CHECK
@VDM.viewType: #COMPOSITE
@Analytics.dataCategory: #DIMENSION
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.representativeKey: 'BOOOpMaterialPRTIntVersCounter'
@AbapCatalog.compiler.compareFilter: true
@ObjectModel.usageType: { serviceQuality: #B, sizeCategory: #M, dataClass: #MASTER }
@EndUserText.label: 'BOO Operation Material Production Resource/Tool Change State'
@Metadata.allowExtensions:true
@AbapCatalog.preserveKey:true 

define view I_BOOOpMaterialPRTChangeState
  as select from I_BOOOperationPRTChangeState
    inner join   I_MaterialPRTByInternalKey on  I_BOOOperationPRTChangeState.ProductionResourceType       = I_MaterialPRTByInternalKey.ProductionResourceType
                                            and I_BOOOperationPRTChangeState.ProductionResourceInternalID = I_MaterialPRTByInternalKey.ProductionResourceInternalID

  association [1..1] to I_MaterialPRTByInternalKey as _MaterialPRTByInternalKey on  $projection.ProductionResourceType       = _MaterialPRTByInternalKey.ProductionResourceType
                                                                                and $projection.ProductionResourceInternalID = _MaterialPRTByInternalKey.ProductionResourceInternalID

{
            @ObjectModel.foreignKey.association: '_BillOfOperationsType'
  key       I_BOOOperationPRTChangeState.BillOfOperationsType,

            @ObjectModel.foreignKey.association: '_BillOfOperationsGroup'
  key       I_BOOOperationPRTChangeState.BillOfOperationsGroup,

            @ObjectModel.foreignKey.association: '_BillOfOperations'
  key       I_BOOOperationPRTChangeState.BillOfOperationsVariant,

            @ObjectModel.foreignKey.association: '_BillOfOperationsSequence'
  key       I_BOOOperationPRTChangeState.BillOfOperationsSequence,

            @ObjectModel.foreignKey.association: '_BOOOperationInternalID'
  key       I_BOOOperationPRTChangeState.BOOOperationInternalID,

            @ObjectModel.foreignKey.association:  '_BOOOperationPRTInternalID'
  key       I_BOOOperationPRTChangeState.BOOOperationPRTInternalID     as   BOOOpMaterialPRTInternalID,

  key       I_BOOOperationPRTChangeState.BOOOperationPRTIntVersCounter as   BOOOpMaterialPRTIntVersCounter,

            @ObjectModel.foreignKey.association: '_ProductionResourceType'
            I_BOOOperationPRTChangeState.ProductionResourceType,

            @ObjectModel.foreignKey.association: '_ProdnRsceToolMasterData'
            I_BOOOperationPRTChangeState.ProductionResourceInternalID,

            @Semantics.businessDate.from: true
            I_BOOOperationPRTChangeState.ValidityStartDate,
            @Semantics.businessDate.to: true
            ValidityEndDate,

            @ObjectModel.foreignKey.association: '_ChangeMaster'
            I_BOOOperationPRTChangeState.ChangeNumber,
            I_BOOOperationPRTChangeState.ProdnRsceToolItemNumber,

            @ObjectModel.foreignKey.association: '_ProdnRsceToolControlProfile'
            I_BOOOperationPRTChangeState.ProdnRsceToolControlProfile,

            @ObjectModel.foreignKey.association: '_ProdnRsceToolStandardText'
            I_BOOOperationPRTChangeState.ProdnRsceToolStandardTextCode,

            @Semantics.text: true
            I_BOOOperationPRTChangeState.ProdnRsceToolText,

            // Admin

            @Semantics.businessDate.createdAt: true
            I_BOOOperationPRTChangeState.CreationDate,
            //      @ObjectModel.foreignKey.association: '_CreatedByUser'

            @Semantics.user.createdBy: true
            I_BOOOperationPRTChangeState.CreatedByUser,
            @Semantics.businessDate.lastChangedAt: true
            I_BOOOperationPRTChangeState.LastChangeDate,
            //      @ObjectModel.foreignKey.association: '_LastChangedByUser'

            @Semantics.user.lastChangedBy: true
            I_BOOOperationPRTChangeState.LastChangedByUser,

            IsDeleted,
            IsImplicitlyDeleted,

            @ObjectModel.foreignKey.association: '_ProductionResourceToolUnit'
            @Semantics.unitOfMeasure: true
            I_BOOOperationPRTChangeState.ProdnRsceToolStdWorkQtyUnit,
            @Semantics.quantity.unitOfMeasure: 'ProdnRsceToolStdWorkQtyUnit'
            @DefaultAggregation: #NONE
            I_BOOOperationPRTChangeState.ProdnRsceToolStandardWorkQty,
            @ObjectModel.foreignKey.association: '_ProdnRsceToolTotQtyCalcFmla'
            I_BOOOperationPRTChangeState.ProdnRsceToolTotQtyCalcFormula,

            @ObjectModel.foreignKey.association: '_ProdnResourceToolUsageUnit'
            @Semantics.unitOfMeasure: true
            I_BOOOperationPRTChangeState.ProdnRsceToolUsageQuantityUnit,
            @Semantics.quantity.unitOfMeasure: 'ProdnRsceToolUsageQuantityUnit'
            @DefaultAggregation: #NONE
            I_BOOOperationPRTChangeState.ProdnRsceToolUsageQuantity,
            @ObjectModel.foreignKey.association: '_ProdnRsceToolUsageQtyCalcFmla'
            I_BOOOperationPRTChangeState.ProdnRsceToolUsageQtyCalcFmla,

            @ObjectModel.foreignKey.association: '_StartDateOffsetReferenceCode'
            I_BOOOperationPRTChangeState.StartDateOffsetReferenceCode,
            @ObjectModel.foreignKey.association: '_StartDateOffsetDurationUnit'
            @Semantics.unitOfMeasure: true
            I_BOOOperationPRTChangeState.StartDateOffsetDurationUnit,
            @Semantics.quantity.unitOfMeasure: 'StartDateOffsetDurationUnit'
            @DefaultAggregation: #SUM
            I_BOOOperationPRTChangeState.StartDateOffsetDuration,

            @ObjectModel.foreignKey.association: '_EndDateOffsetReferenceCode'
            I_BOOOperationPRTChangeState.EndDateOffsetReferenceCode,
            @ObjectModel.foreignKey.association: '_EndDateOffsetDurationUnit'
            @Semantics.unitOfMeasure: true
            I_BOOOperationPRTChangeState.EndDateOffsetDurationUnit,
            @Semantics.quantity.unitOfMeasure: 'EndDateOffsetDurationUnit'
            @DefaultAggregation: #SUM
            I_BOOOperationPRTChangeState.EndDateOffsetDuration,

            I_BOOOperationPRTChangeState.BillOfOperationsVersion,

            _MaterialPRTByInternalKey,

            I_BOOOperationPRTChangeState._BillOfOperationsType,
            I_BOOOperationPRTChangeState._BillOfOperationsGroup,
            // !! DO NOT USE @ObjectModel.association.type: [ #TO_COMPOSITION_ROOT ]

            I_BOOOperationPRTChangeState._BillOfOperations,
            // !! DO NOT USE @ObjectModel.association.type: [ #TO_COMPOSITION_PARENT ]

            I_BOOOperationPRTChangeState._BillOfOperationsOperation,
            I_BOOOperationPRTChangeState._BOOOperationInternalID,
            I_BOOOperationPRTChangeState._BillOfOperationsSequence,
            I_BOOOperationPRTChangeState._BOOOperationPRTInternalID,

            I_BOOOperationPRTChangeState._ProductionResourceType,
            I_BOOOperationPRTChangeState._ProdnRsceToolMasterData,
            I_BOOOperationPRTChangeState._ProdnRsceToolControlProfile,
            I_BOOOperationPRTChangeState._ProdnRsceToolTotQtyCalcFmla,
            I_BOOOperationPRTChangeState._ProdnRsceToolUsageQtyCalcFmla,
            I_BOOOperationPRTChangeState._ProdnRsceToolStandardText,
            I_BOOOperationPRTChangeState._ProductionResourceToolUnit,
            I_BOOOperationPRTChangeState._ProdnResourceToolUsageUnit,
            I_BOOOperationPRTChangeState._StartDateOffsetReferenceCode,
            I_BOOOperationPRTChangeState._StartDateOffsetDurationUnit,
            I_BOOOperationPRTChangeState._EndDateOffsetReferenceCode,
            I_BOOOperationPRTChangeState._EndDateOffsetDurationUnit,
            I_BOOOperationPRTChangeState._CreatedByUser,
            I_BOOOperationPRTChangeState._LastChangedByUser,
            I_BOOOperationPRTChangeState._ChangeMaster
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BOOOPERATIONPRTCHANGESTATE",
"I_MATERIALPRTBYINTERNALKEY"
],
"ASSOCIATED":
[
"I_BILLOFOPERATIONS",
"I_BILLOFOPERATIONSGROUP",
"I_BILLOFOPERATIONSOPERATION",
"I_BILLOFOPERATIONSSEQUENCE",
"I_BILLOFOPERATIONSTYPE",
"I_BOOOPERATIONINTERNALID",
"I_BOOOPERATIONPRTINTERNALID",
"I_CHANGEMASTER",
"I_MATERIALPRTBYINTERNALKEY",
"I_OPERATIONDATEOFFSETREFCODE",
"I_PRODNRSCETOOLCONTROLPROFILE",
"I_PRODNRSCETOOLMASTERDATA",
"I_PRODNRSCETOOLQTYCALCFORMULA",
"I_PRODNRSCETOOLSTANDARDTEXT",
"I_PRODUCTIONRESOURCETYPE",
"I_UNITOFMEASURE",
"I_USER"
],
"BASE":
[
"I_BOOOPERATIONPRTCHANGESTATE"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Depth:

I_BOOOpMaterialPRTChangeState view

I_BOOOperationPRTChangeState view
I_MaterialPRTByInternalKey view