I_BOOOpDocumentPRTChangeState

DDL: I_BOOOPDOCUMENTPRTCHANGESTATE SQL: IPPBOOOPDOCPRTCS Type: view COMPOSITE Package: VDM_PP_MD_RTG
58 Fields 2 Data Sources 1 Associations

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. Part of development package VDM_PP_MD_RTG.

Data Sources (2)

SourceAliasJoin Type
I_BOOOperationPRTChangeState I_BOOOperationPRTChangeState from
I_DocumentPRTByInternalKey I_DocumentPRTByInternalKey inner

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_DocumentPRTByInternalKey _DocumentPRTByInternalKey $projection.ProductionResourceType = _DocumentPRTByInternalKey.ProductionResourceType and $projection.ProductionResourceInternalID = _DocumentPRTByInternalKey.ProductionResourceInternalID

Annotations (13)

NameValueLevelField
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)

KeyFieldSource TableSource FieldDescription
KEY BillOfOperationsType I_BOOOperationPRTChangeState BillOfOperationsType Task List Type
KEY BillOfOperationsGroup I_BOOOperationPRTChangeState BillOfOperationsGroup Group
KEY BillOfOperationsVariant I_BOOOperationPRTChangeState BillOfOperationsVariant Group Counter
KEY BillOfOperationsSequence I_BOOOperationPRTChangeState BillOfOperationsSequence Sequence
KEY BOOOperationInternalID I_BOOOperationPRTChangeState BOOOperationInternalID Task list node
KEY BOOOpDocumentPRTInternalID I_BOOOperationPRTChangeState BOOOperationPRTInternalID Test equipment
KEY BOOOpDocumentPRTIntVersCounter I_BOOOperationPRTChangeState BOOOperationPRTIntVersCounter
ProductionResourceType I_BOOOperationPRTChangeState ProductionResourceType Object Type
ProductionResourceInternalID I_BOOOperationPRTChangeState ProductionResourceInternalID Object ID
ValidityStartDate I_BOOOperationPRTChangeState ValidityStartDate Validity Start Date
ValidityEndDate ValidityEndDate ValidTo
ChangeNumber I_BOOOperationPRTChangeState ChangeNumber Change Number
ProdnRsceToolItemNumber I_BOOOperationPRTChangeState ProdnRsceToolItemNumber Item Number
ProdnRsceToolControlProfile I_BOOOperationPRTChangeState ProdnRsceToolControlProfile PRT Control Profile
ProdnRsceToolStandardTextCode I_BOOOperationPRTChangeState ProdnRsceToolStandardTextCode Std Text Key
ProdnRsceToolText I_BOOOperationPRTChangeState ProdnRsceToolText Text for PRT
CreationDate I_BOOOperationPRTChangeState CreationDate Time Stamp
CreatedByUser I_BOOOperationPRTChangeState CreatedByUser User Name
LastChangeDate I_BOOOperationPRTChangeState LastChangeDate Time Stamp
LastChangedByUser I_BOOOperationPRTChangeState LastChangedByUser User Name
IsDeleted IsDeleted TRUE
IsImplicitlyDeleted IsImplicitlyDeleted Deletion Ind.
ProdnRsceToolStdWorkQtyUnit I_BOOOperationPRTChangeState ProdnRsceToolStdWorkQtyUnit Unit
ProdnRsceToolStandardWorkQty I_BOOOperationPRTChangeState ProdnRsceToolStandardWorkQty Quantity
ProdnRsceToolTotQtyCalcFormula I_BOOOperationPRTChangeState ProdnRsceToolTotQtyCalcFormula Formula
ProdnRsceToolUsageQuantityUnit I_BOOOperationPRTChangeState ProdnRsceToolUsageQuantityUnit Usage Val. Unit
ProdnRsceToolUsageQuantity I_BOOOperationPRTChangeState ProdnRsceToolUsageQuantity Usage Value
ProdnRsceToolUsageQtyCalcFmla I_BOOOperationPRTChangeState ProdnRsceToolUsageQtyCalcFmla Formula
StartDateOffsetReferenceCode I_BOOOperationPRTChangeState StartDateOffsetReferenceCode Reference Date
StartDateOffsetDurationUnit I_BOOOperationPRTChangeState StartDateOffsetDurationUnit Unit
StartDateOffsetDuration I_BOOOperationPRTChangeState StartDateOffsetDuration Offset
EndDateOffsetReferenceCode I_BOOOperationPRTChangeState EndDateOffsetReferenceCode Reference
EndDateOffsetDurationUnit I_BOOOperationPRTChangeState EndDateOffsetDurationUnit Unit
EndDateOffsetDuration I_BOOOperationPRTChangeState EndDateOffsetDuration Offset to finsh
BillOfOperationsVersion I_BOOOperationPRTChangeState BillOfOperationsVersion Routing Version
_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

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_BOOOpDocumentPRTChangeState.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: IPPBOOOPDOCPRTCS

CREATE VIEW I_BOOOpDocumentPRTChangeState AS
SELECT
  I_BOOOperationPRTChangeState.BillOfOperationsType AS BillOfOperationsType,
  I_BOOOperationPRTChangeState.BillOfOperationsGroup AS BillOfOperationsGroup,
  I_BOOOperationPRTChangeState.BillOfOperationsVariant AS BillOfOperationsVariant,
  I_BOOOperationPRTChangeState.BillOfOperationsSequence AS BillOfOperationsSequence,
  I_BOOOperationPRTChangeState.BOOOperationInternalID AS BOOOperationInternalID,
  I_BOOOperationPRTChangeState.BOOOperationPRTInternalID AS BOOOpDocumentPRTInternalID,
  I_BOOOperationPRTChangeState.BOOOperationPRTIntVersCounter AS BOOOpDocumentPRTIntVersCounter,
  I_BOOOperationPRTChangeState.ProductionResourceType AS ProductionResourceType,
  I_BOOOperationPRTChangeState.ProductionResourceInternalID AS ProductionResourceInternalID,
  I_BOOOperationPRTChangeState.ValidityStartDate AS ValidityStartDate,
  ValidityEndDate,
  I_BOOOperationPRTChangeState.ChangeNumber AS ChangeNumber,
  I_BOOOperationPRTChangeState.ProdnRsceToolItemNumber AS ProdnRsceToolItemNumber,
  I_BOOOperationPRTChangeState.ProdnRsceToolControlProfile AS ProdnRsceToolControlProfile,
  I_BOOOperationPRTChangeState.ProdnRsceToolStandardTextCode AS ProdnRsceToolStandardTextCode,
  I_BOOOperationPRTChangeState.ProdnRsceToolText AS ProdnRsceToolText,
  I_BOOOperationPRTChangeState.CreationDate AS CreationDate,
  I_BOOOperationPRTChangeState.CreatedByUser AS CreatedByUser,
  I_BOOOperationPRTChangeState.LastChangeDate AS LastChangeDate,
  I_BOOOperationPRTChangeState.LastChangedByUser AS LastChangedByUser,
  IsDeleted,
  IsImplicitlyDeleted,
  I_BOOOperationPRTChangeState.ProdnRsceToolStdWorkQtyUnit AS ProdnRsceToolStdWorkQtyUnit,
  I_BOOOperationPRTChangeState.ProdnRsceToolStandardWorkQty AS ProdnRsceToolStandardWorkQty,
  I_BOOOperationPRTChangeState.ProdnRsceToolTotQtyCalcFormula AS ProdnRsceToolTotQtyCalcFormula,
  I_BOOOperationPRTChangeState.ProdnRsceToolUsageQuantityUnit AS ProdnRsceToolUsageQuantityUnit,
  I_BOOOperationPRTChangeState.ProdnRsceToolUsageQuantity AS ProdnRsceToolUsageQuantity,
  I_BOOOperationPRTChangeState.ProdnRsceToolUsageQtyCalcFmla AS ProdnRsceToolUsageQtyCalcFmla,
  I_BOOOperationPRTChangeState.StartDateOffsetReferenceCode AS StartDateOffsetReferenceCode,
  I_BOOOperationPRTChangeState.StartDateOffsetDurationUnit AS StartDateOffsetDurationUnit,
  I_BOOOperationPRTChangeState.StartDateOffsetDuration AS StartDateOffsetDuration,
  I_BOOOperationPRTChangeState.EndDateOffsetReferenceCode AS EndDateOffsetReferenceCode,
  I_BOOOperationPRTChangeState.EndDateOffsetDurationUnit AS EndDateOffsetDurationUnit,
  I_BOOOperationPRTChangeState.EndDateOffsetDuration AS EndDateOffsetDuration,
  I_BOOOperationPRTChangeState.BillOfOperationsVersion AS BillOfOperationsVersion,
  I_BOOOperationPRTChangeState._BillOfOperationsType AS _BillOfOperationsType,
  I_BOOOperationPRTChangeState._BillOfOperationsGroup AS _BillOfOperationsGroup,
  I_BOOOperationPRTChangeState._BillOfOperations AS _BillOfOperations,
  I_BOOOperationPRTChangeState._BillOfOperationsOperation AS _BillOfOperationsOperation,
  I_BOOOperationPRTChangeState._BOOOperationInternalID AS _BOOOperationInternalID,
  I_BOOOperationPRTChangeState._BillOfOperationsSequence AS _BillOfOperationsSequence,
  I_BOOOperationPRTChangeState._BOOOperationPRTInternalID AS _BOOOperationPRTInternalID,
  I_BOOOperationPRTChangeState._ProductionResourceType AS _ProductionResourceType,
  I_BOOOperationPRTChangeState._ProdnRsceToolMasterData AS _ProdnRsceToolMasterData,
  I_BOOOperationPRTChangeState._ProdnRsceToolControlProfile AS _ProdnRsceToolControlProfile,
  I_BOOOperationPRTChangeState._ProdnRsceToolTotQtyCalcFmla AS _ProdnRsceToolTotQtyCalcFmla,
  I_BOOOperationPRTChangeState._ProdnRsceToolUsageQtyCalcFmla AS _ProdnRsceToolUsageQtyCalcFmla,
  I_BOOOperationPRTChangeState._ProdnRsceToolStandardText AS _ProdnRsceToolStandardText,
  I_BOOOperationPRTChangeState._ProductionResourceToolUnit AS _ProductionResourceToolUnit,
  I_BOOOperationPRTChangeState._ProdnResourceToolUsageUnit AS _ProdnResourceToolUsageUnit,
  I_BOOOperationPRTChangeState._StartDateOffsetReferenceCode AS _StartDateOffsetReferenceCode,
  I_BOOOperationPRTChangeState._StartDateOffsetDurationUnit AS _StartDateOffsetDurationUnit,
  I_BOOOperationPRTChangeState._EndDateOffsetReferenceCode AS _EndDateOffsetReferenceCode,
  I_BOOOperationPRTChangeState._EndDateOffsetDurationUnit AS _EndDateOffsetDurationUnit,
  I_BOOOperationPRTChangeState._CreatedByUser AS _CreatedByUser,
  I_BOOOperationPRTChangeState._LastChangedByUser AS _LastChangedByUser,
  I_BOOOperationPRTChangeState._ChangeMaster AS _ChangeMaster
FROM I_BOOOperationPRTChangeState
INNER JOIN I_DocumentPRTByInternalKey ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_DocumentPRTByInternalKey AS _DocumentPRTByInternalKey ON ProductionResourceType = _DocumentPRTByInternalKey.ProductionResourceType AND ProductionResourceInternalID = _DocumentPRTByInternalKey.ProductionResourceInternalID  -- association [1..1]
;

Learn More