I_BillOfOperationsGroup

DDL: I_BILLOFOPERATIONSGROUP SQL: IPPBOOGROUP Type: view BASIC
3 Fields 1 Associations

Bill of Operations Group

I_BillOfOperationsGroup (Basic)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

Manufacturing

I_BillOfOperationsGroup is a Basic CDS View (Dimension) that provides data about "Bill of Operations Group" in SAP S/4HANA. It has 1 association to related views.

SAP Help Documentation

CategoryCDS Views for Basic Routing Data
Data CategoryDimension
StatusReleased
Purpose
With this CDS view you can build foreign key associations to the second key field of bill of operations tables (for example PLKO-PLNNR , PLPO-PLNNR ) in analytical CDS views. This CDS view provides the prerequisites for answering the following business questions: Which IDs of bill of operations exist for a bill of operations type?

Prerequisites
Users have authorizations to: Display task lists by type ( C_ROUT )

Structure
Measures and attributes Some important measures and attributes are: Bill of operations type Bill of operations group

View on SAP Help Portal →

SAP API Hub

StateC1
Line of BusinessManufacturing
Application ComponentPP-VDM-MD
CapabilitiesAssociation Target for Defining CDS Entities, Analytical Dimension
PackageManufacturing for SAP S/4HANA Cloud Private Edition

Documentation

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_BillOfOperationsType _BillOfOperationsType $projection.BillOfOperationsType = _BillOfOperationsType.BillOfOperationsType

Annotations (17)

NameValueLevelField
AbapCatalog.sqlViewName IPPBOOGROUP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
Analytics.dataCategory #DIMENSION view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.representativeKey BillOfOperationsGroup view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
EndUserText.label Bill of Operations Group view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY BillOfOperationsType Bill of Operations Type
KEY BillOfOperationsGroup Bill of Operations Group
_BillOfOperationsType _BillOfOperationsType

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 I_BillOfOperationsGroup.
-- 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.
-- SQL view name: IPPBOOGROUP

CREATE VIEW I_BillOfOperationsGroup AS
SELECT
  cast(plnty as billofoperationstype preserving type) AS BillOfOperationsType,
  cast(plnnr as billofoperationsgroup preserving type) AS BillOfOperationsGroup
LEFT OUTER JOIN I_BillOfOperationsType AS _BillOfOperationsType ON BillOfOperationsType = _BillOfOperationsType.BillOfOperationsType  -- association [1..1]
;

Learn More