P_PlanningScopeMBOM

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 P_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: PPLNSCPMBOM

CREATE VIEW P_PlanningScopeMBOM AS
SELECT
  PlanningScopeMBOM.documentid AS DocumentId,
  PlanningScopeMBOM.plan_scope_alt AS PlanningScopeAlternative,
  PlanningScopeHeader.SourceMaterial AS SourceMaterial,
  PlanningScopeMBOM.plnscp_item_cnt AS PlanningScopeItemCount,
  PlanningScopeMBOM.mbom_material AS Material,
  PlanningScopeMBOM.group_counter AS TaskListGroupCounter,
  PlanningScopeMBOM.group_id AS TaskListGroup,
  PlanningScopeMBOM.group_type AS TaskListType,
  PlanningScopeMBOM.instance_count AS StatusCount,
  PlanningScopeMBOM.mbom_alternative AS AlternativeBillOfMaterial,
  PlanningScopeMBOM.mbom_guid AS BillOfMaterialHeaderUUID,
  PlanningScopeMBOM.mbom_state AS MBOMState,
  PlanningScopeMBOM.mbom_type AS MfgBillOfMaterialCategory,
  PlanningScopeMBOM.mbom_usage AS MBOMUsage,
  PlanningScopeHeader.Plant AS Plant,
  PlanningScopeHeader.ChangeNumber AS ChangeNumber,
  PlanningScopeHeader.BOMIsActive AS BOMIsActive,
  cast('' as boole_d preserving type) AS SyncedWithSyncUnitUUID
FROM vmp_plnscp_mbom AS PlanningScopeMBOM
INNER JOIN I_PlanningScopeHeaderDetail AS PlanningScopeHeader ON /* join condition not captured in parsed metadata */
;