I_BILLOFOPERATIONS
Bill of Operations
I_BILLOFOPERATIONS is a CDS View in S/4HANA. Bill of Operations. It contains 23 fields. 25 CDS views read from this table.
CDS Views using this table (25)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| C_ChangeRecordInspectionPlanVH | view_entity | from | CONSUMPTION | Inspection Plan Value Help |
| C_ChangeRecordInspPlanMatVH | view_entity | from | CONSUMPTION | Inspection Plan Value Help by Material |
| C_ChangeRecordMasterRcpVH | view_entity | from | CONSUMPTION | Master Recipe Value Help |
| C_ChangeRecordPlngRtgVH | view | from | CONSUMPTION | Planning Routing Value Help |
| C_ChangeRecordProdnRoutingVH | view_entity | from | CONSUMPTION | Production Routing Value Help |
| C_ChgRecdEquipTskListMatVH | view_entity | from | CONSUMPTION | Material for Equipment Task List |
| C_ChgRecdEquipTskListVH | view_entity | from | CONSUMPTION | Equipment Task List |
| C_ChgRecdFuncLocTskListMatVH | view_entity | from | CONSUMPTION | Material for Functional Loc Task List |
| C_ChgRecdFuncLocTskListVH | view_entity | from | CONSUMPTION | Functional Location Task List |
| C_ChgRecdMaintTskListMatVH | view_entity | from | CONSUMPTION | Material for Maintenance Task List |
| C_ChgRecdMaintTskListVH | view_entity | from | CONSUMPTION | Maintenance Task List |
| C_ChgRecdRateRtgTskListMatVH | view | from | CONSUMPTION | Material for Rate Rtg Task List |
| C_ChgRecdRateRtgTskListVH | view | from | CONSUMPTION | Rate Routing Task List |
| C_ChgRecdRefCutPlngPrflMatVH | view | from | CONSUMPTION | Material for Cut Planning Profile |
| C_ChgRecdRefCutPlngPrflVH | view | from | CONSUMPTION | Cut Planning Profile task List |
| C_ChgRecdRefOpSetTskListMatVH | view | from | CONSUMPTION | Material for Ref Op Set Task List |
| C_ChgRecdRefOpSetTskListVH | view | from | CONSUMPTION | Ref Op Set Task List |
| C_ChgRecdRefRateRtgTskListVH | view_entity | from | CONSUMPTION | Ref rate Routing Task List |
| C_RefRateRtgTskListMatVH | view_entity | from | CONSUMPTION | Material for Ref Rate Routing Task List |
| I_BillOfOperationsStdVH | view | from | COMPOSITE | Bill of Operations |
| I_InspectionPlan | view_entity | from | BASIC | Inspection Plan |
| I_MaintenanceTaskList | view | from | COMPOSITE | Maintenance Task List |
| I_MfgBillOfOperations | view | from | BASIC | Manufacturing Bill of Operations |
| I_ProductionRoutingVersion | view_entity | inner | COMPOSITE | Production Routing Version |
| R_MaintenanceTaskListTP | view_entity | from | TRANSACTIONAL | TaskList Root View |
Fields (23)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | BillOfOperationsGroup | BillOfOperationsGroup,TaskListGroup | 4 |
| KEY | BillOfOperationsType | BillOfOperationsType,TaskListType | 5 |
| KEY | BillOfOperationsVariant | BillOfOperationsVariant,TaskListGroupCounter | 4 |
| _BillOfOperationsVersionType | _BillOfOperationsVersionType | 1 | |
| BillOfOperationIsExecutedInMES | BillOfOperationIsExecutedInMES | 1 | |
| BillOfOperationsIsTrnsfdToERP | BillOfOperationsIsTrnsfdToERP | 1 | |
| BillOfOperationsSubtype | BillOfOperationsSubtype | 1 | |
| BillOfOperationsVariantDesc | BillOfOperationsVariantDesc | 1 | |
| BillOfOperationsVersionType | BillOfOperationsVersionType | 2 | |
| HasChangeNumber | HasChangeNumber | 1 | |
| HasParameterEffectivity | HasParameterEffectivity | 1 | |
| IsMarkedForDeletion | IsMarkedForDeletion | 1 | |
| LastChangeDate | LastChangeDate | 2 | |
| LastChangedByUser | LastChangedByUser | 2 | |
| LastChangeTime | LastChangeTime | 1 | |
| LastUsageDate | LastUsageDate | 1 | |
| NumberOfUsages | NumberOfUsages | 1 | |
| ProdnProcgIsFlexible | ProdnProcgIsFlexible | 1 | |
| RoutingIsReworkRouting | RoutingIsReworkRouting | 1 | |
| ShopFloorRoutingTemplateOwner | ShopFloorRoutingTemplateOwner | 1 | |
| ShopFloorRoutingTemplateType | ShopFloorRoutingTemplateType | 1 | |
| ShopFloorRtgTemplateCategory | ShopFloorRtgTemplateCategory | 1 | |
| ShopFloorRtgTemplateSubType | ShopFloorRtgTemplateSubType | 1 |
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.
-- Bill of Operations
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_BILLOFOPERATIONS (
BILLOFOPERATIONSGROUP,
BILLOFOPERATIONSTYPE,
BILLOFOPERATIONSVARIANT,
_BILLOFOPERATIONSVERSIONTYPE,
BILLOFOPERATIONISEXECUTEDINMES,
BILLOFOPERATIONSISTRNSFDTOERP,
BILLOFOPERATIONSSUBTYPE,
BILLOFOPERATIONSVARIANTDESC,
BILLOFOPERATIONSVERSIONTYPE,
HASCHANGENUMBER,
HASPARAMETEREFFECTIVITY,
ISMARKEDFORDELETION,
LASTCHANGEDATE,
LASTCHANGEDBYUSER,
LASTCHANGETIME,
LASTUSAGEDATE,
NUMBEROFUSAGES,
PRODNPROCGISFLEXIBLE,
ROUTINGISREWORKROUTING,
SHOPFLOORROUTINGTEMPLATEOWNER,
SHOPFLOORROUTINGTEMPLATETYPE,
SHOPFLOORRTGTEMPLATECATEGORY,
SHOPFLOORRTGTEMPLATESUBTYPE,
PRIMARY KEY (BILLOFOPERATIONSGROUP, BILLOFOPERATIONSTYPE, BILLOFOPERATIONSVARIANT)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA