C_LinkedProdnVersBOO

DDL: C_LINKEDPRODNVERSBOO Type: view_entity CONSUMPTION
31 Fields 4 Data Sources 1 Associations

BOO to Material Assignment for ProdnVers

C_LinkedProdnVersBOO is a Consumption CDS View that provides data about "BOO to Material Assignment for ProdnVers" in SAP S/4HANA. It reads from 4 data sources (I_MasterRecipeHeader, I_MasterRecipeHeader, I_ProductionRouting, I_MasterRecipe) and exposes 31 fields with key fields Material, Plant, BillOfOperationsType, BillOfOperationsGroup, BillOfOperationsVariant. It has 1 association to related views.

Data Sources (4)

SourceAliasJoin Type
I_MasterRecipeHeader plko from
I_MasterRecipeHeader plko union
I_ProductionRouting plkz inner
I_MasterRecipe plkz inner

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_ProdnRoutingMatlAssgmtTP _MatlAssgmt $projection.BillOfOperationsGroup = _MatlAssgmt.ProductionRoutingGroup and $projection.BillOfOperationsVariant = _MatlAssgmt.ProductionRouting and $projection.ValidityEndDate >= _MatlAssgmt.ValidityStartDate and $projection.ValidityStartDate <= _MatlAssgmt.ValidityEndDate

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label BOO to Material Assignment for ProdnVers view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
Metadata.allowExtensions true view

Fields (31)

KeyFieldSource TableSource FieldDescription
KEY Material _MatlAssgmt Product Product Sold
KEY Plant _MatlAssgmt Plant Valuation Area
KEY BillOfOperationsType I_MasterRecipe BillOfOperationsType Task List Type
KEY BillOfOperationsGroup I_MasterRecipe BillOfOperationsGroup Task List Group
KEY BillOfOperationsVariant I_MasterRecipe BillOfOperationsVariant Task List Counter
KEY ProductionRoutingInternalVers I_MasterRecipeHeader BOOInternalVersionCounter
BillOfOperationsDesc I_MasterRecipeHeader BillOfOperationsDesc Description
BillOfOperationsStatus I_MasterRecipeHeader BillOfOperationsStatus Overall Status
BillOfOperationsUsage I_MasterRecipeHeader BillOfOperationsUsage Usage
ValidityStartDate I_MasterRecipeHeader ValidityStartDate Valid From
ValidityEndDate I_MasterRecipeHeader ValidityEndDate Valid To
BillOfOperationsUnit I_MasterRecipeHeader BillOfOperationsUnit
MinimumLotSizeQuantity I_MasterRecipeHeader MinimumLotSizeQuantity Minimum Lot Size
MaximumLotSizeQuantity I_MasterRecipeHeader MaximumLotSizeQuantity Maximum Lot Size
BillOfOperationsUsageDesc _UsageText BillOfOperationsUsageDesc
ProductasMaterial
KEY Plant _MatlAssgmt Plant Valuation Area
KEY BillOfOperationsType I_MasterRecipe BillOfOperationsType Task List Type
KEY BillOfOperationsGroup I_MasterRecipe BillOfOperationsGroup Group
KEY BillOfOperationsVariant I_MasterRecipe BillOfOperationsVariant Group Counter
KEY ProductionRoutingInternalVers I_MasterRecipeHeader BOOInternalVersionCounter
BillOfOperationsDesc I_MasterRecipeHeader BillOfOperationsDesc
BillOfOperationsStatus I_MasterRecipeHeader BillOfOperationsStatus
BillOfOperationsUsage I_MasterRecipeHeader BillOfOperationsUsage
ValidityStartDate I_MasterRecipeHeader ValidityStartDate Validity Start Date
ValidityEndDate I_MasterRecipeHeader ValidityEndDate ValidTo
BillOfOperationsUnit I_MasterRecipeHeader BillOfOperationsUnit
MinimumLotSizeQuantity I_MasterRecipeHeader MinimumLotSizeQuantity Min. Lot Size
MaximumLotSizeQuantity I_MasterRecipeHeader MaximumLotSizeQuantity Max. Lot Size
BillOfOperationsUsageDesc _UsageText BillOfOperationsUsageDesc
BillOfOperationsStatusDesc _StatusText BillOfOperationsStatusDesc

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_LinkedProdnVersBOO.
-- 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_LinkedProdnVersBOO AS
SELECT
  _MatlAssgmt.Product AS Material,
  _MatlAssgmt.Plant AS Plant,
  plkz.BillOfOperationsType AS BillOfOperationsType,
  plkz.BillOfOperationsGroup AS BillOfOperationsGroup,
  plkz.BillOfOperationsVariant AS BillOfOperationsVariant,
  plko.BOOInternalVersionCounter AS ProductionRoutingInternalVers,
  plko.BillOfOperationsDesc AS BillOfOperationsDesc,
  plko.BillOfOperationsStatus AS BillOfOperationsStatus,
  plko.BillOfOperationsUsage AS BillOfOperationsUsage,
  plko.ValidityStartDate AS ValidityStartDate,
  plko.ValidityEndDate AS ValidityEndDate,
  plko.BillOfOperationsUnit AS BillOfOperationsUnit,
  plko.MinimumLotSizeQuantity AS MinimumLotSizeQuantity,
  plko.MaximumLotSizeQuantity AS MaximumLotSizeQuantity,
  _UsageText.BillOfOperationsUsageDesc AS BillOfOperationsUsageDesc,
  _StatusText.BillOfOperationsStatusDesc as BillOfOperationsStatusDesc AS ProductasMaterial,
  _StatusText.BillOfOperationsStatusDesc AS BillOfOperationsStatusDesc
FROM I_MasterRecipeHeader AS plko
INNER JOIN I_ProductionRouting AS plkz ON /* join condition not captured in parsed metadata */
INNER JOIN I_MasterRecipe AS plkz ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ProdnRoutingMatlAssgmtTP AS _MatlAssgmt ON BillOfOperationsGroup = _MatlAssgmt.ProductionRoutingGroup AND BillOfOperationsVariant = _MatlAssgmt.ProductionRouting AND ValidityEndDate >= _MatlAssgmt.ValidityStartDate AND ValidityStartDate <= _MatlAssgmt.ValidityEndDate  -- association [0..*]
-- UNION with additional select branch(es): I_MasterRecipeHeader
;

Learn More