I_PMRPReferencePlan

DDL: I_PMRPREFERENCEPLAN Type: view_entity BASIC Package: PMRP_ENGINE
16 Fields 1 Data Sources 1 Associations

A Reference Plan in predictive MRP

I_PMRPReferencePlan is a Basic CDS View that provides data about "A Reference Plan in predictive MRP" in SAP S/4HANA. It reads from 1 data source (pmrp_reference) and exposes 16 fields with key field PMRPReferencePlan. It has 1 association to related views. Part of development package PMRP_ENGINE.

Data Sources (1)

SourceAliasJoin Type
pmrp_reference pmrp_reference from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_PMRPReferencePlanText _PMRPReferencePlanText

Annotations (8)

NameValueLevelField
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.compositionRoot true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #BASIC view
ObjectModel.sapObjectNodeType.name PMRPReferenceScenario view
EndUserText.label A Reference Plan in predictive MRP view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY PMRPReferencePlan reference_id Reference No.
PMRPReferencePlanStatus status Workflow Status
CreatedByUser created_by Version Created By
CreationDateTime created_on Variant created on
LastChangedByUser changed_by User Name
LastChangeDateTime changed_on Variant Changed on
BucketCategory bucket_category Bucket Category
PMRPReferencePlanStartDate start_date Valn start date
PMRPReferencePlanEndDate end_date Valn End date
PMRPRsceOverloadTolerancePct resource_overload_tolerance Overload Tolerance
PMRPSalesDemandIsToBeIgnored pmrpsalesdemandistobeignored indc to Update Ref
ActvPlndIndepRqmtIsToBeIgnrd actvplndindeprqmtistobeignrd indc to Update Ref
InactvPlndIndepRqmtIsToBeAdded inactvplndindeprqmtistobeadded indc to Update Ref
PMRPStockDeterminationRule pmrpstockdeterminationrule Opening Stock
PMRPCostCtrPlanIsToBePubd enable_costctr_planning Boolean Variable (X = True, - = False, Space = Unknown)
_PMRPReferencePlanText _PMRPReferencePlanText

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_PMRPReferencePlan.
-- 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.

CREATE VIEW I_PMRPReferencePlan AS
SELECT
  reference_id AS PMRPReferencePlan,
  status AS PMRPReferencePlanStatus,
  created_by AS CreatedByUser,
  created_on AS CreationDateTime,
  changed_by AS LastChangedByUser,
  changed_on AS LastChangeDateTime,
  bucket_category AS BucketCategory,
  start_date AS PMRPReferencePlanStartDate,
  end_date AS PMRPReferencePlanEndDate,
  resource_overload_tolerance AS PMRPRsceOverloadTolerancePct,
  PMRPSalesDemandIsToBeIgnored,
  ActvPlndIndepRqmtIsToBeIgnrd,
  InactvPlndIndepRqmtIsToBeAdded,
  PMRPStockDeterminationRule,
  enable_costctr_planning AS PMRPCostCtrPlanIsToBePubd
FROM pmrp_reference
LEFT OUTER JOIN I_PMRPReferencePlanText AS _PMRPReferencePlanText ON /* condition not available in parsed metadata */  -- association [0..*]
;

Learn More