I_BOOOPERATIONPRTCHANGESTATE

CDS View
58 Fields 9 CDS Views

BOO Operation Production Resource/Tool Change State

I_BOOOPERATIONPRTCHANGESTATE is a CDS View in S/4HANA. BOO Operation Production Resource/Tool Change State. It contains 58 fields. 9 CDS views read from this table.

CDS Views using this table (9)

ViewTypeJoinVDMDescription
I_BOOOpDocumentPRTChangeState view from COMPOSITE BOO Operation Document Production Resource/Tool Change State
I_BOOOpEquipmentPRTChangeState view from COMPOSITE BOO Operation Equipment Prod. Resource/Tool Change State
I_BOOOpMaterialPRTChangeState view from COMPOSITE BOO Operation Material Production Resource/Tool Change State
I_BOOOpMiscPRTChangeState view from COMPOSITE BOO Operation Misc Production Resource/Tool Change State
I_InspPlanOpPRT view from COMPOSITE Inspection Plan Production Res Tool View
I_MaintTaskListOpPRT view from COMPOSITE Maint. Task List Operation PRT
I_MfgBOOOpProdnRsceToolChgSt view from BASIC Mfg BOO Op Prodn Rsce Tool Change State
I_MfgWorkInstructionPRTDocLink view inner BASIC Documents linked to a PRT assigned to OA
P_BOOVersionPRT view_entity inner COMPOSITE

Fields (58)

KeyField CDS FieldsUsed in Views
KEY BillOfOperationsGroup BillOfOperationsGroup 5
KEY BillOfOperationsSequence BillOfOperationsSequence 5
KEY BillOfOperationsType BillOfOperationsType 5
KEY BillOfOperationsVariant BillOfOperationsVariant 5
KEY BOOOperationInternalID BOOOperationInternalID 5
KEY BOOOperationPRTInternalID BOOOpDocumentPRTInternalID,BOOOpEquipmentPRTInternalID,BOOOperationPRTInternalID,BOOOpMaterialPRTInternalID,BOOOpMiscPRTInternalID 5
KEY BOOOperationPRTIntVersCounter BOOOpDocumentPRTIntVersCounter,BOOOpEquipPRTIntVersCounter,BOOOperationPRTIntVersCounter,BOOOpMaterialPRTIntVersCounter,BOOOpMiscPRTIntVersCounter 6
_BillOfOperations _BillOfOperations 4
_BillOfOperationsGroup _BillOfOperationsGroup 4
_BillOfOperationsOperation _BillOfOperationsOperation 4
_BillOfOperationsSequence _BillOfOperationsSequence 4
_BillOfOperationsType _BillOfOperationsType 4
_BOOOperationInternalID _BOOOperationInternalID 4
_BOOOperationPRTInternalID _BOOOperationPRTInternalID 4
_ChangeMaster _ChangeMaster 4
_CreatedByUser _CreatedByUser 4
_EndDateOffsetDurationUnit _EndDateOffsetDurationUnit 4
_EndDateOffsetReferenceCode _EndDateOffsetReferenceCode 4
_LastChangedByUser _LastChangedByUser 4
_ProdnResourceToolUsageUnit _ProdnResourceToolUsageUnit 4
_ProdnRsceToolControlProfile _ProdnRsceToolControlProfile 4
_ProdnRsceToolMasterData _ProdnRsceToolMasterData 4
_ProdnRsceToolStandardText _ProdnRsceToolStandardText 4
_ProdnRsceToolTotQtyCalcFmla _ProdnRsceToolTotQtyCalcFmla 4
_ProdnRsceToolUsageQtyCalcFmla _ProdnRsceToolUsageQtyCalcFmla 4
_ProductionResourceToolUnit _ProductionResourceToolUnit 4
_ProductionResourceType _ProductionResourceType 4
_StartDateOffsetDurationUnit _StartDateOffsetDurationUnit 4
_StartDateOffsetReferenceCode _StartDateOffsetReferenceCode 4
BillOfOperationsVersion BillOfOperationsVersion 4
ChangeNumber ChangeNumber 5
CreatedByUser CreatedByUser 5
CreationDate CreationDate 5
EndDateOffsetDuration EndDateOffsetDuration 5
EndDateOffsetDurationUnit EndDateOffsetDurationUnit 5
EndDateOffsetReferenceCode EndDateOffsetReferenceCode 5
IsDeleted IsDeleted 1
IsImplicitlyDeleted IsImplicitlyDeleted 1
LastChangeDate LastChangeDate 5
LastChangedByUser LastChangedByUser 5
ProdnRsceToolControlProfile ProdnRsceToolControlProfile 6
ProdnRsceToolItemNumber ProdnRsceToolItemNumber 6
ProdnRsceToolStandardTextCode ProdnRsceToolStandardTextCode 6
ProdnRsceToolStandardWorkQty ProdnRsceToolStandardWorkQty 6
ProdnRsceToolStdWorkQtyUnit ProdnRsceToolStdWorkQtyUnit 6
ProdnRsceToolText ProdnRsceToolText 6
ProdnRsceToolTotQtyCalcFormula ProdnRsceToolTotQtyCalcFormula 6
ProdnRsceToolUsageQtyCalcFmla ProdnRsceToolUsageQtyCalcFmla 6
ProdnRsceToolUsageQuantity ProdnRsceToolUsageQuantity 6
ProdnRsceToolUsageQuantityUnit ProdnRsceToolUsageQuantityUnit 6
ProductionResourceInternalID ProductionResourceInternalID 6
ProductionResourceType ProductionResourceType 6
ShopFloorRtgPRTIsRegistrable ShopFloorRtgPRTIsRegistrable 1
StartDateOffsetDuration StartDateOffsetDuration 5
StartDateOffsetDurationUnit StartDateOffsetDurationUnit 5
StartDateOffsetReferenceCode StartDateOffsetReferenceCode 5
ValidityEndDate ValidityEndDate 1
ValidityStartDate ValidityStartDate 5

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- BOO Operation Production Resource/Tool Change State
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_BOOOPERATIONPRTCHANGESTATE (
    BILLOFOPERATIONSGROUP,
    BILLOFOPERATIONSSEQUENCE,
    BILLOFOPERATIONSTYPE,
    BILLOFOPERATIONSVARIANT,
    BOOOPERATIONINTERNALID,
    BOOOPERATIONPRTINTERNALID,
    BOOOPERATIONPRTINTVERSCOUNTER,
    _BILLOFOPERATIONS,
    _BILLOFOPERATIONSGROUP,
    _BILLOFOPERATIONSOPERATION,
    _BILLOFOPERATIONSSEQUENCE,
    _BILLOFOPERATIONSTYPE,
    _BOOOPERATIONINTERNALID,
    _BOOOPERATIONPRTINTERNALID,
    _CHANGEMASTER,
    _CREATEDBYUSER,
    _ENDDATEOFFSETDURATIONUNIT,
    _ENDDATEOFFSETREFERENCECODE,
    _LASTCHANGEDBYUSER,
    _PRODNRESOURCETOOLUSAGEUNIT,
    _PRODNRSCETOOLCONTROLPROFILE,
    _PRODNRSCETOOLMASTERDATA,
    _PRODNRSCETOOLSTANDARDTEXT,
    _PRODNRSCETOOLTOTQTYCALCFMLA,
    _PRODNRSCETOOLUSAGEQTYCALCFMLA,
    _PRODUCTIONRESOURCETOOLUNIT,
    _PRODUCTIONRESOURCETYPE,
    _STARTDATEOFFSETDURATIONUNIT,
    _STARTDATEOFFSETREFERENCECODE,
    BILLOFOPERATIONSVERSION,
    CHANGENUMBER,
    CREATEDBYUSER,
    CREATIONDATE,
    ENDDATEOFFSETDURATION,
    ENDDATEOFFSETDURATIONUNIT,
    ENDDATEOFFSETREFERENCECODE,
    ISDELETED,
    ISIMPLICITLYDELETED,
    LASTCHANGEDATE,
    LASTCHANGEDBYUSER,
    PRODNRSCETOOLCONTROLPROFILE,
    PRODNRSCETOOLITEMNUMBER,
    PRODNRSCETOOLSTANDARDTEXTCODE,
    PRODNRSCETOOLSTANDARDWORKQTY,
    PRODNRSCETOOLSTDWORKQTYUNIT,
    PRODNRSCETOOLTEXT,
    PRODNRSCETOOLTOTQTYCALCFORMULA,
    PRODNRSCETOOLUSAGEQTYCALCFMLA,
    PRODNRSCETOOLUSAGEQUANTITY,
    PRODNRSCETOOLUSAGEQUANTITYUNIT,
    PRODUCTIONRESOURCEINTERNALID,
    PRODUCTIONRESOURCETYPE,
    SHOPFLOORRTGPRTISREGISTRABLE,
    STARTDATEOFFSETDURATION,
    STARTDATEOFFSETDURATIONUNIT,
    STARTDATEOFFSETREFERENCECODE,
    VALIDITYENDDATE,
    VALIDITYSTARTDATE,
    PRIMARY KEY (BILLOFOPERATIONSGROUP, BILLOFOPERATIONSSEQUENCE, BILLOFOPERATIONSTYPE, BILLOFOPERATIONSVARIANT, BOOOPERATIONINTERNALID, BOOOPERATIONPRTINTERNALID, BOOOPERATIONPRTINTVERSCOUNTER)
);

Learn More