I_ProdnModParamEffctyParam

DDL: I_PRODNMODPARAMEFFCTYPARAM Type: view_entity COMPOSITE
14 Fields 2 Data Sources

Prodn Mod Param Effectivity Parameter

I_ProdnModParamEffctyParam is a Composite CDS View that provides data about "Prodn Mod Param Effectivity Parameter" in SAP S/4HANA. It reads from 2 data sources (I_ChgNmbrModVariantUnitEffcty, P_ProdnModParamEffctyParamChgN) and exposes 14 fields with key fields ProductionModelUUID, BillOfOperationsVersion, ParamEffctyObjectReferenceKey, ParamEffctyParentObjRefKey, ChangeNumberInternalCounter.

Data Sources (2)

SourceAliasJoin Type
I_ChgNmbrModVariantUnitEffcty Data inner
P_ProdnModParamEffctyParamChgN ID from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label Prodn Mod Param Effectivity Parameter view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #COMPOSITE view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY ProductionModelUUID P_ProdnModParamEffctyParamChgN ProductionModelUUID Prodn Model UUID
KEY BillOfOperationsVersion P_ProdnModParamEffctyParamChgN BillOfOperationsVersion Routing Version
KEY ParamEffctyObjectReferenceKey P_ProdnModParamEffctyParamChgN ParamEffctyObjectReferenceKey Logical System
KEY ParamEffctyParentObjRefKey P_ProdnModParamEffctyParamChgN ParamEffctyParentObjRefKey Logical System
KEY ChangeNumberInternalCounter I_ChgNmbrModVariantUnitEffcty ChangeNumberInternalCounter
ParamEffctyObjectType P_ProdnModParamEffctyParamChgN ParamEffctyObjectType Char20
ParameterEffectivityModel I_ChgNmbrModVariantUnitEffcty ParameterEffectivityModel
ParameterEffectivityVariant I_ChgNmbrModVariantUnitEffcty ParameterEffectivityVariant
ParameterEffectivityUnitFrom I_ChgNmbrModVariantUnitEffcty ParameterEffectivityUnitFrom
ParameterEffectivityUnitTo I_ChgNmbrModVariantUnitEffcty ParameterEffectivityUnitTo
BillOfMaterialCategory P_ProdnModParamEffctyParamChgN BillOfMaterialCategory BOM category
BillOfMaterialVariantUsage P_ProdnModParamEffctyParamChgN BillOfMaterialVariantUsage Usage
BillOfOperationsType P_ProdnModParamEffctyParamChgN BillOfOperationsType Task List Type
Plant P_ProdnModParamEffctyParamChgN Plant Valuation Area

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_ProdnModParamEffctyParam.
-- 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_ProdnModParamEffctyParam AS
SELECT
  ID.ProductionModelUUID AS ProductionModelUUID,
  ID.BillOfOperationsVersion AS BillOfOperationsVersion,
  ID.ParamEffctyObjectReferenceKey AS ParamEffctyObjectReferenceKey,
  ID.ParamEffctyParentObjRefKey AS ParamEffctyParentObjRefKey,
  Data.ChangeNumberInternalCounter AS ChangeNumberInternalCounter,
  ID.ParamEffctyObjectType AS ParamEffctyObjectType,
  Data.ParameterEffectivityModel AS ParameterEffectivityModel,
  Data.ParameterEffectivityVariant AS ParameterEffectivityVariant,
  Data.ParameterEffectivityUnitFrom AS ParameterEffectivityUnitFrom,
  Data.ParameterEffectivityUnitTo AS ParameterEffectivityUnitTo,
  ID.BillOfMaterialCategory AS BillOfMaterialCategory,
  ID.BillOfMaterialVariantUsage AS BillOfMaterialVariantUsage,
  ID.BillOfOperationsType AS BillOfOperationsType,
  ID.Plant AS Plant
FROM P_ProdnModParamEffctyParamChgN AS ID
INNER JOIN I_ChgNmbrModVariantUnitEffcty AS Data ON /* join condition not captured in parsed metadata */
;

Learn More