C_MassMaintCapMatlAssgmt

DDL: C_MASSMAINTCAPMATLASSGMT Type: view_entity CONSUMPTION
7 Fields 1 Data Sources 1 Associations 1 OData Services 1 Fiori Apps

Material Assignment Related to Capacity

C_MassMaintCapMatlAssgmt is a Consumption CDS View that provides data about "Material Assignment Related to Capacity" in SAP S/4HANA. It reads from 1 data source (I_BOOSqncOperationAssgmtChgSt) and exposes 7 fields with key fields WorkCenterInternalID, Product, Plant, BillOfOperationsGroup, BillOfOperationsType. It has 1 association to related views. It is exposed through 1 OData service (UI_WORKCENTERCAPLIST_02). It is used in 1 Fiori application: Mass Maintenance Of Work Center Capacities.

Data Sources (1)

SourceAliasJoin Type
I_BOOSqncOperationAssgmtChgSt _Plas inner

Associations (1)

CardinalityTargetAliasCondition
[0..*] C_MassMaintCapProdnVersionVH _ProdnVers _ProdnVers.Material = _Mat.Product and _ProdnVers.Plant = _Mat.Plant and _ProdnVers.BillOfOperationsGroup = _Mat.BillOfOperationsGroup and _ProdnVers.BillOfOperationsType = _Mat.BillOfOperationsType and _ProdnVers.BillOfOperationsVariant = _Mat.BillOfOperationsVariant and _ProdnVers.ValidityStartDate <= $session.system_date and _ProdnVers.ValidityEndDate >= $session.system_date

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Material Assignment Related to Capacity view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

OData Services (1)

ServiceBindingVersionContractRelease
UI_WORKCENTERCAPLIST_02 UI_WORKCENTERCAPLIST_02 V2 C1 NOT_RELEASED

Fiori Apps (1)

App IDApp NameTypeDescription
F5381 Mass Maintenance Of Work Center Capacities Transactional The application is used to perform a mass create of interval for selected work center capacities. As a Production Planner, you must manage the capacities of multiple work centers to meet future demands. When you foresee a spike in demand, you can create multiple intervals for a few or all capacities that belong to the work centers in a production line/Work Center group. Intervals can be created for both working and non-working days. Within the given interval, you can create shifts for a single day and allow it to repeat on a daily, weekly or monthly basis. On the other hand, you could also create weekly shifts. You can then define a shift order by either assigning existing shift sequences or create your own custom shift definitions. While creating intervals, you can choose to override the existing factory calendar and make edits to Utilization and number of capacities.

Mass Maintenance Of Work Center Capacities

Business Role: Production Planner

With this app, you can perform a mass create of interval for selected work center capacities. As a Production Planner, you must manage the capacities of multiple work centers to meet future demands. When you foresee a spike in demand, you can create multiple intervals for a few or all capacities that belong to the work centers in a production line/Work Center group. Intervals can be created for both working and non-working days. Within the given interval, you can create shifts for a single day and allow it to repeat on a daily, weekly or monthly basis. On the other hand, you could also create weekly shifts. You can then define a shift order by either assigning existing shift sequences or create your own custom shift definitions. While creating intervals, you can choose to override the existing factory calendar and make edits to Utilization and number of capacities.

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY WorkCenterInternalID _WrkCtr WorkCenterInternalID Work Center
KEY Product _Mat Product Product Sold
KEY Plant _Mat Plant Valuation Area
KEY BillOfOperationsGroup _Mat BillOfOperationsGroup Group
KEY BillOfOperationsType _Mat BillOfOperationsType Task List Type
KEY BillOfOperationsVariant _Mat BillOfOperationsVariant Group Counter
_ProdnVers _ProdnVers

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 C_MassMaintCapMatlAssgmt.
-- 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.

CREATE VIEW C_MassMaintCapMatlAssgmt AS
SELECT
  _WrkCtr.WorkCenterInternalID AS WorkCenterInternalID,
  _Mat.Product AS Product,
  _Mat.Plant AS Plant,
  _Mat.BillOfOperationsGroup AS BillOfOperationsGroup,
  _Mat.BillOfOperationsType AS BillOfOperationsType,
  _Mat.BillOfOperationsVariant AS BillOfOperationsVariant
INNER JOIN I_BOOSqncOperationAssgmtChgSt AS _Plas ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN C_MassMaintCapProdnVersionVH AS _ProdnVers ON _ProdnVers.Material = _Mat.Product AND _ProdnVers.Plant = _Mat.Plant AND _ProdnVers.BillOfOperationsGroup = _Mat.BillOfOperationsGroup AND _ProdnVers.BillOfOperationsType = _Mat.BillOfOperationsType AND _ProdnVers.BillOfOperationsVariant = _Mat.BillOfOperationsVariant AND _ProdnVers.ValidityStartDate <= $session.system_date AND _ProdnVers.ValidityEndDate >= $session.system_date  -- association [0..*]
;

Learn More