I_SCMPlannerVH

DDL: I_SCMPLANNERVH SQL: ISCMPLANNERVH Type: view COMPOSITE Package: VDM_SCMB_MD_PLANNER

SCM Planner Value Help

I_SCMPlannerVH is a Composite CDS View that provides data about "SCM Planner Value Help" in SAP S/4HANA. It reads from 1 data source (I_SCMPlanner) and exposes 8 fields with key field Planner. Part of development package VDM_SCMB_MD_PLANNER.

Data Sources (1)

SourceAliasJoin Type
I_SCMPlanner I_SCMPlanner from

Annotations (14)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.representativeKey Planner view
ObjectModel.usageType.dataClass #META view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
EndUserText.label SCM Planner Value Help view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AbapCatalog.sqlViewName ISCMPLANNERVH view
Search.searchable true view
Metadata.ignorePropagatedAnnotations true view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY Planner Planner Transp. Planner
PlannerName PlannerName Zone name
SAPOfficeRecipientName SAPOfficeRecipientName Subscription address
DistributionListName DistributionListName DL name
SrvcPartsPlnrIsDRPPlnr SrvcPartsPlnrIsDRPPlnr DRP Plnr
SrvcPartsPlnrIsSupChainAnalyst SrvcPartsPlnrIsSupChainAnalyst SC Analyst
SrvcPartsPlnrIsInventoryPlnr SrvcPartsPlnrIsInventoryPlnr Inventory Plnr
SrvcPartsPlnrIsPlanningBuyer SrvcPartsPlnrIsPlanningBuyer Buyer

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_SCMPlannerVH.
-- 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: ISCMPLANNERVH

CREATE VIEW I_SCMPlannerVH AS
SELECT
  Planner,
  PlannerName,
  SAPOfficeRecipientName,
  DistributionListName,
  SrvcPartsPlnrIsDRPPlnr,
  SrvcPartsPlnrIsSupChainAnalyst,
  SrvcPartsPlnrIsInventoryPlnr,
  SrvcPartsPlnrIsPlanningBuyer
FROM I_SCMPlanner
;