I_BOOOpDocumentPRTChangeState

Q: Which tables does I_BOOOpDocumentPRTChangeState use?

I_BOOOpDocumentPRTChangeState reads from 2 data source(s): I_BOOOperationPRTChangeState, I_DocumentPRTByInternalKey.

Q: How many fields does I_BOOOpDocumentPRTChangeState have?

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

DDL: I_BOOOPDOCUMENTPRTCHANGESTATE SQL: IPPBOOOPDOCPRTCS Type: view COMPOSITE

BOO Operation Document Production Resource/Tool Change State

I_BOOOpDocumentPRTChangeState is a Composite CDS View (Dimension) that provides data about "BOO Operation Document Production Resource/Tool Change State" in SAP S/4HANA. It reads from 2 data sources (I_BOOOperationPRTChangeState, I_DocumentPRTByInternalKey) 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_DocumentPRTByInternalKey	I_DocumentPRTByInternalKey	inner

Associations (1)

Cardinality	Target	Alias	Condition
[1..1]	I_DocumentPRTByInternalKey	_DocumentPRTByInternalKey	`$projection.ProductionResourceType = _DocumentPRTByInternalKey.ProductionResourceType and $projection.ProductionResourceInternalID = _DocumentPRTByInternalKey.ProductionResourceInternalID`

Annotations (13)

Name	Value	Level
AbapCatalog.sqlViewName	IPPBOOOPDOCPRTCS	view
AccessControl.authorizationCheck	#CHECK	view
VDM.viewType	#COMPOSITE	view
Analytics.dataCategory	#DIMENSION	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
ObjectModel.representativeKey	BOOOpDocumentPRTIntVersCounter	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 Document 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	BOOOpDocumentPRTInternalID	I_BOOOperationPRTChangeState	BOOOperationPRTInternalID
KEY	BOOOpDocumentPRTIntVersCounter	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
	_DocumentPRTByInternalKey		_DocumentPRTByInternalKey
	_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: 'IPPBOOOPDOCPRTCS'
@AccessControl.authorizationCheck: #CHECK
@VDM.viewType: #COMPOSITE
@Analytics.dataCategory: #DIMENSION
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.representativeKey: 'BOOOpDocumentPRTIntVersCounter'
@AbapCatalog.compiler.compareFilter: true
@ObjectModel.usageType: { serviceQuality: #B, sizeCategory: #M, dataClass: #MASTER }
@EndUserText.label: 'BOO Operation Document Production Resource/Tool Change State'
@Metadata.allowExtensions:true
@AbapCatalog.preserveKey:true 

define view I_BOOOpDocumentPRTChangeState
  as select from I_BOOOperationPRTChangeState
    inner join   I_DocumentPRTByInternalKey on  I_BOOOperationPRTChangeState.ProductionResourceType       = I_DocumentPRTByInternalKey.ProductionResourceType
                                            and I_BOOOperationPRTChangeState.ProductionResourceInternalID = I_DocumentPRTByInternalKey.ProductionResourceInternalID

  association [1..1] to I_DocumentPRTByInternalKey as _DocumentPRTByInternalKey on  $projection.ProductionResourceType       = _DocumentPRTByInternalKey.ProductionResourceType
                                                                                and $projection.ProductionResourceInternalID = _DocumentPRTByInternalKey.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   BOOOpDocumentPRTInternalID,

  key I_BOOOperationPRTChangeState.BOOOperationPRTIntVersCounter as   BOOOpDocumentPRTIntVersCounter,

      @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,

      _DocumentPRTByInternalKey,

      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_DOCUMENTPRTBYINTERNALKEY"
],
"ASSOCIATED":
[
"I_BILLOFOPERATIONS",
"I_BILLOFOPERATIONSGROUP",
"I_BILLOFOPERATIONSOPERATION",
"I_BILLOFOPERATIONSSEQUENCE",
"I_BILLOFOPERATIONSTYPE",
"I_BOOOPERATIONINTERNALID",
"I_BOOOPERATIONPRTINTERNALID",
"I_CHANGEMASTER",
"I_DOCUMENTPRTBYINTERNALKEY",
"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_BOOOpDocumentPRTChangeState view

I_BOOOperationPRTChangeState view
I_DocumentPRTByInternalKey view_entity