I_BOOSQNCOPERATIONASSGMTCHGST
Bill of Operations Sequence Operation Assignment Chg State
I_BOOSQNCOPERATIONASSGMTCHGST is a CDS View in S/4HANA. Bill of Operations Sequence Operation Assignment Chg State. It contains 21 fields. 35 CDS views read from this table.
CDS Views using this table (35)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| C_MaintTaskListOperationDEX | view_entity | inner | CONSUMPTION | Maintenance Task List Operation |
| C_MassMaintCapMatlAssgmt | view_entity | inner | CONSUMPTION | Material Assignment Related to Capacity |
| C_MfgHumRsceQualifnOAAssgmt | view_entity | inner | CONSUMPTION | Qualifications assignments to OA |
| C_MfgStdTextVersWhereUsedList | view | inner | CONSUMPTION | View for ST Where Used List |
| I_BillOfOpsOpWrkCtrGrouping | view_entity | inner | COMPOSITE | Grpg of WrkCntr on BillOfOps Group Type |
| I_BOOMatlAssgmtWrkCtrWhereUsd | view | inner | COMPOSITE | Work Center where used in products |
| I_BOOOpCharacteristicChgSt | view | inner | COMPOSITE | Bill of Operations Operation Characteristic Change State |
| I_BOOOpDepdntCharcSpecChgSt | view_entity | inner | COMPOSITE | BOO Operation Dependent Characteristic Specification ChgSt |
| I_BOOSubOperationChangeState | view | inner | COMPOSITE | Bill of Operations Operation Change State |
| I_BOOVersionOperation | view_entity | inner | COMPOSITE | Versioned Routing Operation |
| I_CapEvalByAreaOfRespy | view | inner | COMPOSITE | Work Center By Area Of Responsibility |
| I_EvaltCapWrkCtrGrpAreaOfRespy | view_entity | inner | COMPOSITE | Work Center Group Area of Responsibility |
| I_InspPlanOpAssgmtVersion | view | from | BASIC | Version of Operation Assgmt in Insp Plan |
| I_MaintTaskListOperation | view | inner | COMPOSITE | Maintenance Task List Operation |
| I_MasterRcpNonHistoricActyTP | view_entity | inner | TRANSACTIONAL | Master Recipe Non Historical Activity |
| I_MasterRecipeActivity | view_entity | inner | COMPOSITE | Master Recipe Activity(Opr,Phs,SecRes) Details |
| I_MasterRecipeInspCharcsAssgmt | view_entity | inner | COMPOSITE | Inspection Characteristics Assignment |
| I_MfgBOOMatlAssgmtWrkCtrGrpg | view_entity | inner | COMPOSITE | Material Assignment Work Center Grouping |
| I_MfgBOOSequenceOpAssgmtChgSt | view_entity | from | BASIC | Bill of Operations Sequence Operation Assignment Chg State |
| I_ProdnModOpActivityTemplate | view_entity | inner | COMPOSITE | Prodn Model Operation Activity Template |
| I_ProdnModOpComponentBasic | view_entity | inner | BASIC | Op Comp Keys and basic data |
| I_ProdnRtgInspCharcsAssgmt | view_entity | inner | COMPOSITE | Inspection Characteristics Assignment |
| I_RoutingActivity | view | inner | COMPOSITE | Routing Activity (Opr, Sub-opr) Details |
| I_SchedProdnVersRtgDetails | view | inner | COMPOSITE | Production Version Routing Details |
| I_SchedProdnWrkCtrAreaOfRespy | view | inner | COMPOSITE | Work Centers By Area of Responsibilty |
| I_WrkCtrCapByAreaOfRespy | view | inner | COMPOSITE | Work Center By Area Of Responsibility |
| P_AreaOfRespyBOOSqncOpAssgmt | view_entity | inner | COMPOSITE | Area of Respy BOO sequence Op Assignment |
| P_BOOOperationChangeState | view | inner | COMPOSITE | |
| P_ProdnModBOOOperation | view_entity | inner | COMPOSITE | Prodn Model Bill of Operations Operation |
| P_ProdnModOpActivityTemplate | view_entity | inner | COMPOSITE | |
| P_RSHTaskListOperations | view | inner | CONSUMPTION | Task List Operations |
| P_SchedProdnAltvProdnVers | view | inner | BASIC | |
| P_WrkCtrMntrAlternateWrkCtr | view | inner | CONSUMPTION | |
| R_MaintTaskListOpBasicTP | view_entity | inner | TRANSACTIONAL | Tasklist Operations |
| R_MaintTaskListOpRelshpTP | view_entity | inner | TRANSACTIONAL | Operation Relationships |
Fields (21)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | BillOfOperationsGroup | BillOfOperationsGroup,TaskListGroup | 9 |
| KEY | BillOfOperationsSequence | BillOfOperationsSequence,TaskListSequence | 14 |
| KEY | BillOfOperationsType | BillOfOperationsType,TaskListType | 9 |
| KEY | BillOfOperationsVariant | BillOfOperationsVariant,MasterRecipe,TaskListGroupCounter | 16 |
| KEY | BillOfOperationsVersion | BillOfOperationsVersion | 1 |
| KEY | BOOOperationInternalID | BOOOperationInternalID | 11 |
| KEY | BOOSqncOpAssgmtIntVersionCntr | BOOSqncInternalVersionCounter,BOOSqncOpAssgmtIntVersionCntr,TaskListOpBOMItmIntVersCounter | 7 |
| _BillOfOperations | _BillOfOperations,_TaskListGroupCounter | 4 | |
| _BillOfOperationsGroup | _BillOfOperationsGroup,_TaskListGroup | 4 | |
| _BillOfOperationsSequence | _BillOfOperationsSequence,_TaskListSequence | 4 | |
| _BillOfOperationsType | _BillOfOperationsType | 4 | |
| _BOOOperationInternalID | _BOOOperationInternalID | 3 | |
| ChangeNumber | ChangeNumber | 1 | |
| CreatedByUser | CreatedByUser | 1 | |
| CreationDate | CreationDate | 3 | |
| IsDeleted | IsDeleted | 1 | |
| IsImplicitlyDeleted | IsImplicitlyDeleted | 3 | |
| LastChangeDate | LastChangeDate | 3 | |
| LastChangedByUser | LastChangedByUser | 1 | |
| ValidityEndDate | ValidityEndDate | 1 | |
| ValidityStartDate | ValidityStartDate | 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 Sequence Operation Assignment Chg State
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_BOOSQNCOPERATIONASSGMTCHGST (
BILLOFOPERATIONSGROUP,
BILLOFOPERATIONSSEQUENCE,
BILLOFOPERATIONSTYPE,
BILLOFOPERATIONSVARIANT,
BILLOFOPERATIONSVERSION,
BOOOPERATIONINTERNALID,
BOOSQNCOPASSGMTINTVERSIONCNTR,
_BILLOFOPERATIONS,
_BILLOFOPERATIONSGROUP,
_BILLOFOPERATIONSSEQUENCE,
_BILLOFOPERATIONSTYPE,
_BOOOPERATIONINTERNALID,
CHANGENUMBER,
CREATEDBYUSER,
CREATIONDATE,
ISDELETED,
ISIMPLICITLYDELETED,
LASTCHANGEDATE,
LASTCHANGEDBYUSER,
VALIDITYENDDATE,
VALIDITYSTARTDATE,
PRIMARY KEY (BILLOFOPERATIONSGROUP, BILLOFOPERATIONSSEQUENCE, BILLOFOPERATIONSTYPE, BILLOFOPERATIONSVARIANT, BILLOFOPERATIONSVERSION, BOOOPERATIONINTERNALID, BOOSQNCOPASSGMTINTVERSIONCNTR)
);
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