I_BOOMATERIALASSGMTCHANGESTATE
Change State of Material Assgmt to BOO
I_BOOMATERIALASSGMTCHANGESTATE is a CDS View in S/4HANA. Change State of Material Assgmt to BOO. It contains 23 fields. 10 CDS views read from this table.
CDS Views using this table (10)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_BOOPlngBOMAssignment | view | from | BASIC | PBOM assigned to Planning Routing |
| I_CapEvalByAreaOfRespy | view | inner | COMPOSITE | Work Center By Area Of Responsibility |
| I_EvaltCapWrkCtrGrpAreaOfRespy | view_entity | inner | COMPOSITE | Work Center Group Area of Responsibility |
| I_InspPlnMatlAssgmtVersion | view | from | BASIC | Version of Plan-Material assignment |
| I_InspPlnMatlAssgmtVersion_2 | view_entity | from | BASIC | Version of Material Assgmt in Insp Plan |
| I_MfgBOOMaterialAssgmtChgSt | view | from | BASIC | Change State of Material Assgmt to Manufacturing BOO |
| I_ProdnVersTaskListVH | view | left_outer | COMPOSITE | Task List |
| I_SchedProdnWrkCtrAreaOfRespy | view | inner | COMPOSITE | Work Centers By Area of Responsibilty |
| I_WrkCtrCapByAreaOfRespy | view | inner | COMPOSITE | Work Center By Area Of Responsibility |
| P_WrkCtrMntrAlternateWrkCtr | view | inner | CONSUMPTION |
Fields (23)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | BillOfOperationsGroup | BillOfOperationsGroup,InspectionPlanGroup | 3 |
| KEY | BillOfOperationsType | BillOfOperationsType | 3 |
| KEY | BillOfOperationsVariant | BillOfOperationsVariant,InspectionPlan | 3 |
| KEY | BOOMatlInternalVersionCounter | BOOMatlInternalVersionCounter,InspPlanMatlAssgmtIntVersion | 2 |
| KEY | BOOToMaterialInternalID | BOOToMaterialInternalID,InspPlanMatlAssignment | 3 |
| KEY | Material | Material,Product | 4 |
| KEY | Plant | Plant | 4 |
| BOOSearchText | BOOSearchText | 2 | |
| ChangeNumber | ChangeNumber | 3 | |
| CreatedByUser | CreatedByUser | 2 | |
| CreationDate | CreationDate | 2 | |
| Customer | Customer | 2 | |
| IsDeleted | IsDeleted | 3 | |
| IsImplicitlyDeleted | IsImplicitlyDeleted | 2 | |
| LastChangeDate | LastChangeDate | 2 | |
| LastChangedByUser | LastChangedByUser | 2 | |
| SalesOrder | SalesOrder | 1 | |
| SalesOrderItem | SalesOrderItem | 1 | |
| Supplier | Supplier | 2 | |
| ValidityEndDate | ValidityEndDate | 3 | |
| ValidityStartDate | ValidityStartDate | 3 | |
| WBSElementInternalID | WBSElementInternalID | 1 | |
| WBSElementInternalID_2 | WBSElementInternalID_2 | 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.
-- Change State of Material Assgmt to BOO
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_BOOMATERIALASSGMTCHANGESTATE (
BILLOFOPERATIONSGROUP,
BILLOFOPERATIONSTYPE,
BILLOFOPERATIONSVARIANT,
BOOMATLINTERNALVERSIONCOUNTER,
BOOTOMATERIALINTERNALID,
MATERIAL,
PLANT,
BOOSEARCHTEXT,
CHANGENUMBER,
CREATEDBYUSER,
CREATIONDATE,
CUSTOMER,
ISDELETED,
ISIMPLICITLYDELETED,
LASTCHANGEDATE,
LASTCHANGEDBYUSER,
SALESORDER,
SALESORDERITEM,
SUPPLIER,
VALIDITYENDDATE,
VALIDITYSTARTDATE,
WBSELEMENTINTERNALID,
WBSELEMENTINTERNALID_2,
PRIMARY KEY (BILLOFOPERATIONSGROUP, BILLOFOPERATIONSTYPE, BILLOFOPERATIONSVARIANT, BOOMATLINTERNALVERSIONCOUNTER, BOOTOMATERIALINTERNALID, MATERIAL, PLANT)
);
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