I_PlanningScopeMBOM

DDL: I_PLANNINGSCOPEMBOM SQL: IPLNSCPMBOM Type: view BASIC
23 Fields 1 Data Sources 5 Associations

Document BOM Links

I_PlanningScopeMBOM is a Basic CDS View that provides data about "Document BOM Links" in SAP S/4HANA. It reads from 1 data source (P_PlanningScopeMBOM) and exposes 23 fields with key fields DocumentId, PlanningScopeAlternative, SourceMaterial, PlanningScopeItemCount. It has 5 associations to related views.

Data Sources (1)

SourceAliasJoin Type
P_PlanningScopeMBOM PlanningScopeMBOM from

Associations (5)

CardinalityTargetAliasCondition
[1..1] I_MaterialBOM _BOMHeader $projection.Material = _BOMHeader.Material and $projection.AlternativeBillOfMaterial = _BOMHeader.BillOfMaterialVariant and $projection.MBOMUsage = _BOMHeader.BillOfMaterialVariantUsage and $projection.Plant = _BOMHeader.Plant and $projection.ChangeNumber = _BOMHeader.EngineeringChangeDocument --
[1..1] I_BillOfMaterialUsage _BillOfMaterialVariantUsage $projection.MBOMUsage = _BillOfMaterialVariantUsage.BillOfMaterialVariantUsage and _BillOfMaterialVariantUsage.Language = $session.system_language --
[1..1] I_BillOfOperationsGroup _BillOfOperationsGroup $projection.TaskListGroup = _BillOfOperationsGroup.BillOfOperationsGroup and $projection.TaskListType = _BillOfOperationsGroup.BillOfOperationsType --
[1..1] I_BillOfOperationsType _BillOfOperationsType $projection.TaskListType = _BillOfOperationsType.BillOfOperationsType --Get Change Number
[0..*] I_BillOfMaterialStatusText _BillOfMaterialStatusText $projection.BOMIsActive = _BillOfMaterialStatusText.BillOfMaterialStatus

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IPLNSCPMBOM view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
EndUserText.label Document BOM Links view
VDM.viewType #BASIC view

Fields (23)

KeyFieldSource TableSource FieldDescription
KEY DocumentId P_PlanningScopeMBOM DocumentId Routing slip doc. ID
KEY PlanningScopeAlternative P_PlanningScopeMBOM PlanningScopeAlternative Plan Scope Alternate
KEY SourceMaterial P_PlanningScopeMBOM SourceMaterial
KEY PlanningScopeItemCount P_PlanningScopeMBOM PlanningScopeItemCount Counter
BillOfMaterialHeaderUUID P_PlanningScopeMBOM BillOfMaterialHeaderUUID Guid
Material P_PlanningScopeMBOM Material Vehicle Model
TaskListGroupCounter P_PlanningScopeMBOM TaskListGroupCounter Group Counter
TaskListGroup P_PlanningScopeMBOM TaskListGroup Group
TaskListType P_PlanningScopeMBOM TaskListType Task List Type
AlternativeBillOfMaterial P_PlanningScopeMBOM AlternativeBillOfMaterial Alternative
MBOMState P_PlanningScopeMBOM MBOMState MBOM State
MfgBillOfMaterialCategory P_PlanningScopeMBOM MfgBillOfMaterialCategory MBOM Type
MBOMUsage P_PlanningScopeMBOM MBOMUsage Usage
ChangeNumber P_PlanningScopeMBOM ChangeNumber Change Number
Plant P_PlanningScopeMBOM Plant Valuation Area
BOMIsActive P_PlanningScopeMBOM BOMIsActive
StatusCount P_PlanningScopeMBOM StatusCount INT4
SyncedWithSyncUnitUUID P_PlanningScopeMBOM SyncedWithSyncUnitUUID
_BOMHeader _BOMHeader
_BillOfMaterialVariantUsage _BillOfMaterialVariantUsage
_BillOfOperationsGroup _BillOfOperationsGroup
_BillOfOperationsType _BillOfOperationsType
_BillOfMaterialStatusText _BillOfMaterialStatusText

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_PlanningScopeMBOM.
-- 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: IPLNSCPMBOM

CREATE VIEW I_PlanningScopeMBOM AS
SELECT
  PlanningScopeMBOM.DocumentId AS DocumentId,
  PlanningScopeMBOM.PlanningScopeAlternative AS PlanningScopeAlternative,
  PlanningScopeMBOM.SourceMaterial AS SourceMaterial,
  PlanningScopeMBOM.PlanningScopeItemCount AS PlanningScopeItemCount,
  PlanningScopeMBOM.BillOfMaterialHeaderUUID AS BillOfMaterialHeaderUUID,
  PlanningScopeMBOM.Material AS Material,
  PlanningScopeMBOM.TaskListGroupCounter AS TaskListGroupCounter,
  PlanningScopeMBOM.TaskListGroup AS TaskListGroup,
  PlanningScopeMBOM.TaskListType AS TaskListType,
  PlanningScopeMBOM.AlternativeBillOfMaterial AS AlternativeBillOfMaterial,
  PlanningScopeMBOM.MBOMState AS MBOMState,
  PlanningScopeMBOM.MfgBillOfMaterialCategory AS MfgBillOfMaterialCategory,
  PlanningScopeMBOM.MBOMUsage AS MBOMUsage,
  PlanningScopeMBOM.ChangeNumber AS ChangeNumber,
  PlanningScopeMBOM.Plant AS Plant,
  PlanningScopeMBOM.BOMIsActive AS BOMIsActive,
  PlanningScopeMBOM.StatusCount AS StatusCount,
  PlanningScopeMBOM.SyncedWithSyncUnitUUID AS SyncedWithSyncUnitUUID
FROM P_PlanningScopeMBOM AS PlanningScopeMBOM
LEFT OUTER JOIN I_MaterialBOM AS _BOMHeader ON Material = _BOMHeader.Material AND AlternativeBillOfMaterial = _BOMHeader.BillOfMaterialVariant AND MBOMUsage = _BOMHeader.BillOfMaterialVariantUsage AND Plant = _BOMHeader.Plant AND ChangeNumber = _BOMHeader.EngineeringChangeDocument  -- association [1..1]
LEFT OUTER JOIN I_BillOfMaterialUsage AS _BillOfMaterialVariantUsage ON MBOMUsage = _BillOfMaterialVariantUsage.BillOfMaterialVariantUsage AND _BillOfMaterialVariantUsage.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN I_BillOfOperationsGroup AS _BillOfOperationsGroup ON TaskListGroup = _BillOfOperationsGroup.BillOfOperationsGroup AND TaskListType = _BillOfOperationsGroup.BillOfOperationsType  -- association [1..1]
LEFT OUTER JOIN I_BillOfOperationsType AS _BillOfOperationsType ON TaskListType = _BillOfOperationsType.BillOfOperationsType  -- association [1..1]
LEFT OUTER JOIN I_BillOfMaterialStatusText AS _BillOfMaterialStatusText ON BOMIsActive = _BillOfMaterialStatusText.BillOfMaterialStatus  -- association [0..*]
;

Learn More