R_ProdnModParamEffctyParamTP

DDL: R_PRODNMODPARAMEFFCTYPARAMTP Type: view_entity TRANSACTIONAL
15 Fields 1 Data Sources

Prodn Mod Param Effcty Parameter - TP

R_ProdnModParamEffctyParamTP is a Transactional CDS View that provides data about "Prodn Mod Param Effcty Parameter - TP" in SAP S/4HANA. It reads from 1 data source (I_ProdnModParamEffctyParam) and exposes 15 fields with key fields ProductionModelUUID, BillOfOperationsVersion, ParamEffctyObjectReferenceKey, ParamEffctyParentObjRefKey, ChangeNumberInternalCounter.

Data Sources (1)

SourceAliasJoin Type
I_ProdnModParamEffctyParam I_ProdnModParamEffctyParam from

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label Prodn Mod Param Effcty Parameter - TP view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
Metadata.ignorePropagatedAnnotations true view

Fields (15)

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

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 R_ProdnModParamEffctyParamTP.
-- 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 R_ProdnModParamEffctyParamTP AS
SELECT
  ProductionModelUUID,
  BillOfOperationsVersion,
  ParamEffctyObjectReferenceKey,
  ParamEffctyParentObjRefKey,
  ChangeNumberInternalCounter,
  ParamEffctyObjectType,
  ParameterEffectivityModel,
  ParameterEffectivityVariant,
  ParameterEffectivityUnitFrom,
  ParameterEffectivityUnitTo,
  BillOfMaterialCategory,
  BillOfMaterialVariantUsage,
  BillOfOperationsType,
  Plant
FROM I_ProdnModParamEffctyParam
;

Learn More