I_BOOPlngBOMAssignment

DDL: I_BOOPLNGBOMASSIGNMENT SQL: ICHGIMPLNGROUMBM Type: view BASIC
19 Fields 4 Data Sources

PBOM assigned to Planning Routing

I_BOOPlngBOMAssignment is a Basic CDS View that provides data about "PBOM assigned to Planning Routing" in SAP S/4HANA. It reads from 4 data sources (stko, I_BOOMaterialAssgmtChangeState, mast, I_ProdnBOMChgImpactObjMappg) and exposes 19 fields with key fields BillOfOperationsType, BillOfOperationsGroup, BillOfOperationsVariant, BOOToMaterialInternalID, BOOMatlInternalVersionCounter.

Data Sources (4)

SourceAliasJoin Type
stko BOMHeader inner
I_BOOMaterialAssgmtChangeState BOP_TO_MatAssgmnt from
mast MaterialToBOM inner
I_ProdnBOMChgImpactObjMappg ProdBOMUsage inner

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName ICHGIMPLNGROUMBM view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
EndUserText.label PBOM assigned to Planning Routing view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY BillOfOperationsType I_BOOMaterialAssgmtChangeState BillOfOperationsType Task List Type
KEY BillOfOperationsGroup I_BOOMaterialAssgmtChangeState BillOfOperationsGroup Group
KEY BillOfOperationsVariant I_BOOMaterialAssgmtChangeState BillOfOperationsVariant Group Counter
KEY BOOToMaterialInternalID I_BOOMaterialAssgmtChangeState BOOToMaterialInternalID Add. Crit. Cntr
KEY BOOMatlInternalVersionCounter I_BOOMaterialAssgmtChangeState BOOMatlInternalVersionCounter Sort pos.
KEY BillOfMaterial
KEY BillOfMaterialVariant mast stlal AlternativeBOM
KEY Plant I_BOOMaterialAssgmtChangeState Plant Valuation Area
Material I_BOOMaterialAssgmtChangeState Material Vehicle Model
ChangeNumber I_BOOMaterialAssgmtChangeState ChangeNumber Change Number
IsDeleted I_BOOMaterialAssgmtChangeState IsDeleted TRUE
ValidityStartDate I_BOOMaterialAssgmtChangeState ValidityStartDate Validity Start Date
ValidityEndDate I_BOOMaterialAssgmtChangeState ValidityEndDate ValidTo
BillOfMaterialVariantUsage mast stlan Usage
ProdnRlvnce I_ProdnBOMChgImpactObjMappg ProdnRlvnce Prod Relevance Usage
BillOfMaterialVersion stko bom_versn BOM Version
BOMVersionStatus stko versnst BOM Version Status
BillOfMaterialStatus stko stlst Order level
BillOfMaterialCategory stko stlty Single-Character Flag

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_BOOPlngBOMAssignment.
-- 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: ICHGIMPLNGROUMBM

CREATE VIEW I_BOOPlngBOMAssignment AS
SELECT
  BOP_TO_MatAssgmnt.BillOfOperationsType AS BillOfOperationsType,
  BOP_TO_MatAssgmnt.BillOfOperationsGroup AS BillOfOperationsGroup,
  BOP_TO_MatAssgmnt.BillOfOperationsVariant AS BillOfOperationsVariant,
  BOP_TO_MatAssgmnt.BOOToMaterialInternalID AS BOOToMaterialInternalID,
  BOP_TO_MatAssgmnt.BOOMatlInternalVersionCounter AS BOOMatlInternalVersionCounter,
  cast( MaterialToBOM.stlnr as char8 preserving type) AS BillOfMaterial,
  MaterialToBOM.stlal AS BillOfMaterialVariant,
  BOP_TO_MatAssgmnt.Plant AS Plant,
  BOP_TO_MatAssgmnt.Material AS Material,
  BOP_TO_MatAssgmnt.ChangeNumber AS ChangeNumber,
  BOP_TO_MatAssgmnt.IsDeleted AS IsDeleted,
  BOP_TO_MatAssgmnt.ValidityStartDate AS ValidityStartDate,
  BOP_TO_MatAssgmnt.ValidityEndDate AS ValidityEndDate,
  MaterialToBOM.stlan AS BillOfMaterialVariantUsage,
  ProdBOMUsage.ProdnRlvnce AS ProdnRlvnce,
  BOMHeader.bom_versn AS BillOfMaterialVersion,
  BOMHeader.versnst AS BOMVersionStatus,
  BOMHeader.stlst AS BillOfMaterialStatus,
  BOMHeader.stlty AS BillOfMaterialCategory
FROM I_BOOMaterialAssgmtChangeState AS BOP_TO_MatAssgmnt
INNER JOIN mast AS MaterialToBOM ON /* join condition not captured in parsed metadata */
INNER JOIN stko AS BOMHeader ON /* join condition not captured in parsed metadata */
INNER JOIN I_ProdnBOMChgImpactObjMappg AS ProdBOMUsage ON /* join condition not captured in parsed metadata */
;

Learn More