I_PlngScpBasic

DDL: I_PLNGSCPBASIC SQL: IPLSBSC Type: view BASIC Package: MPE_PLAN_MEC
17 Fields 1 Data Sources

Planning Scope Basic View

I_PlngScpBasic is a Basic CDS View that provides data about "Planning Scope Basic View" in SAP S/4HANA. It reads from 1 data source (vmp_plnscp_hdr) and exposes 17 fields with key fields DocumentId, PlanningScopeAlternative. Part of development package MPE_PLAN_MEC.

Data Sources (1)

SourceAliasJoin Type
vmp_plnscp_hdr PlngScpHdr from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName IPLSBSC view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MASTER view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Planning Scope Basic View view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY DocumentId vmp_plnscp_hdr documentid Routing slip doc. ID
KEY PlanningScopeAlternative vmp_plnscp_hdr plan_scope_alt Plan Scope Alternate
PlanningScopeDescription vmp_plnscp_hdr description Well Code Des.
Plant vmp_plnscp_hdr plant Valuation Area
PlanningScopeTimeStamp vmp_plnscp_hdr timestamp UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
ChangeNumber vmp_plnscp_hdr change_number Change Number
SourceMaterial vmp_plnscp_hdr src_matnr Material
MBOMUsage vmp_plnscp_hdr mbom_usage Usage
PlanningScopeScenario vmp_plnscp_hdr plnscp_scenario Scenario ID
TargetMaterial vmp_plnscp_hdr target_matnr Material
CreationDate vmp_plnscp_hdr created_on Variant created on
CreatedByUser vmp_plnscp_hdr created_by Version Created By
SourcePlant vmp_plnscp_hdr source_plant Source plant
SourceBOMAlternative vmp_plnscp_hdr source_bom_alt Source BOM alt
SourceBOMUsage vmp_plnscp_hdr source_bom_usage Usage
SourceBOMType vmp_plnscp_hdr source_bom_type EBom Type
HierarchyRelevantPlngScp

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_PlngScpBasic.
-- 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: IPLSBSC

CREATE VIEW I_PlngScpBasic AS
SELECT
  PlngScpHdr.documentid AS DocumentId,
  PlngScpHdr.plan_scope_alt AS PlanningScopeAlternative,
  PlngScpHdr.description AS PlanningScopeDescription,
  PlngScpHdr.plant AS Plant,
  PlngScpHdr.timestamp AS PlanningScopeTimeStamp,
  PlngScpHdr.change_number AS ChangeNumber,
  PlngScpHdr.src_matnr AS SourceMaterial,
  PlngScpHdr.mbom_usage AS MBOMUsage,
  PlngScpHdr.plnscp_scenario AS PlanningScopeScenario,
  PlngScpHdr.target_matnr AS TargetMaterial,
  PlngScpHdr.created_on AS CreationDate,
  PlngScpHdr.created_by AS CreatedByUser,
  PlngScpHdr.source_plant AS SourcePlant,
  PlngScpHdr.source_bom_alt AS SourceBOMAlternative,
  PlngScpHdr.source_bom_usage AS SourceBOMUsage,
  PlngScpHdr.source_bom_type AS SourceBOMType,
  cast (PlngScpHdr.related_planningscope as mpe_mec_plng_hierarchy_rel_ind) AS HierarchyRelevantPlngScp
FROM vmp_plnscp_hdr AS PlngScpHdr
;

Learn More