I_ProductionSchedulingProfile

DDL: I_PRODUCTIONSCHEDULINGPROFILE SQL: IPRODNSCHEDGPROF Type: view BASIC Package: VDM_PP_SFC

Production Scheduling Profile

I_ProductionSchedulingProfile (Basic)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Public Edition with built-in and side-by-side extension capabilities.

Production Scheduling Profile · Manufacturing

I_ProductionSchedulingProfile is a Basic CDS View (Dimension) that provides data about "Production Scheduling Profile" in SAP S/4HANA. It reads from 1 data source (tco43) and exposes 8 fields with key fields ProductionSchedulingProfile, Plant. It has 3 associations to related views. Part of development package VDM_PP_SFC.

SAP Help Documentation

CategoryCDS Views for Discrete and Process Manufacturing
Data CategoryDimension
Purpose
This CDS view provides the prerequisites for answering the following business questions: Which production scheduling profiles are maintained in a plant?

Prerequisites
Authorizations Users who want to use this CDS view don't need any special authorization.

Structure
Main input parameters This view does not have any input parameters. Measures and attributes The following attributes are provided: Production scheduling profile Plant Order category

View on SAP Help Portal →

SAP API Hub

CategoryBasic
StateC1
Line of BusinessManufacturing
Application ComponentPP-VDM-2CL
CapabilitiesAnalytical Dimension,Association Target for Defining CDS Entities,Data Source in SQL Select,Data Source for Defining CDS Entities,Data Source for Search
Extensible (Key User)No
Extensible (Developer)No
Release State (Key User)Released
Release State (Developer)Released
PackageManufacturing for SAP S/4HANA Cloud Public Edition
Description <p>This CDS view provides the prerequisites for answering the following business questions:</p> <ul> <li><p>Which production scheduling profiles are maintained in a plant?</p></li> </ul>

Documentation

Data Sources (1)

SourceAliasJoin Type
tco43 tco43 from

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_Plant _Plant $projection.Plant = _Plant.Plant
[0..1] I_OrderCategory _OrderCategory $projection.OrderCategory = _OrderCategory.OrderCategory
[0..*] I_ProductionSchedgProfileText _Text $projection.Plant = _Text.Plant and $projection.ProductionSchedulingProfile = _Text.ProductionSchedulingProfile

Annotations (23)

NameValueLevelField
AbapCatalog.sqlViewName IPRODNSCHEDGPROF view
AbapCatalog.buffering.status #ACTIVE view
AbapCatalog.buffering.type #FULL view
AbapCatalog.buffering.numberOfKeyFields 000 view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
Analytics.dataCategory #DIMENSION view
Analytics.internalName #LOCAL view
ClientHandling.algorithm #SESSION_VARIABLE view
Consumption.ranked true view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.compositionRoot true view
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view
ObjectModel.representativeKey ProductionSchedulingProfile view
ObjectModel.sapObjectNodeType.name ProductionSchedulingProfile view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
VDM.viewType #BASIC view
Search.searchable true view
EndUserText.label Production Scheduling Profile view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY ProductionSchedulingProfile Production Scheduling Profile
KEY Plant tco43 werks Receiving Plant
OrderCategory Order Category
GRIsPostedAutomatically tco43 autwe Indicator: Post Goods Receipt Automatically
MfgOrderEWMSynchronousPosting tco43 sync_gm_for_ewm Synchronous posting of goods movement for EWM
_Text _Text
_Plant _Plant
_OrderCategory _OrderCategory

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_ProductionSchedulingProfile.
-- 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: IPRODNSCHEDGPROF

CREATE VIEW I_ProductionSchedulingProfile AS
SELECT
  cast(tco43.co_prodprf as pph_prodprf preserving type) AS ProductionSchedulingProfile,
  tco43.werks AS Plant,
  cast(tco43.autyp as pph_autyp preserving type) AS OrderCategory,
  tco43.autwe AS GRIsPostedAutomatically,
  tco43.sync_gm_for_ewm AS MfgOrderEWMSynchronousPosting
FROM tco43
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [1..1]
LEFT OUTER JOIN I_OrderCategory AS _OrderCategory ON OrderCategory = _OrderCategory.OrderCategory  -- association [0..1]
LEFT OUTER JOIN I_ProductionSchedgProfileText AS _Text ON Plant = _Text.Plant AND ProductionSchedulingProfile = _Text.ProductionSchedulingProfile  -- association [0..*]
;