I_PRAMsmtPtAllocProfileDetail

DDL: I_PRAMSMTPTALLOCPROFILEDETAIL Type: view_entity BASIC
10 Fields 1 Data Sources 3 Associations

Measure Point Allocation Profile Detail

I_PRAMsmtPtAllocProfileDetail (Basic)

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

PRAMsmtPtAllocProfileDetail · Cross Applications

I_PRAMsmtPtAllocProfileDetail is a Basic CDS View (Fact) that provides data about "Measure Point Allocation Profile Detail" in SAP S/4HANA. It reads from 1 data source (oiu_pr_mpapd) and exposes 10 fields with key fields PRAMsmtPtAllocProfileNumber, PRAVolumeType, PRAMaterial. It has 3 associations to related views.

SAP Help Documentation

CategoryCDS Views for Production and Revenue Accounting (PRA)
Data CategoryFact
Purpose
This CDS view represents the Measure Point Allocation Profile Details. To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views .

Prerequisites
Authorizations Users who want to use this CDS view must have the following authorization objects assigned: O_OIU_TXN:ACTVT-03,O_OIU_TXN:OIU_TCODE-O3U_MPAP3 ( IS-OIL PRA :Transaction Control - Transaction and Mode) Configuration Mapping role for I_PRAMsmtPtAllocProfileDetail

Structure
Important Fields Important fields in this view include the following: Field Name Description Measure or Attribute Comment PRAVolumeType OIU_VL_TYPE_CD CHAR(2) Volume Type Code PRAMaterial MATNR CHAR(40) Material Number PRAMsmtPtAllocProfileNumber OIU_MPAPH_NO NUMC(12) Measurement point allocation profile number

View on SAP Help Portal →

SAP API Hub

StateC1
Line of BusinessCross Applications
Application ComponentIS-OIL-PRA
CapabilitiesData Source for Data Extraction
PackageCross Applications for SAP S/4HANA Cloud Private Edition
Description <p>This CDS view represents the Measure Point Allocation Profile Details.</p> <p>To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views.</p>

Documentation

Data Sources (1)

SourceAliasJoin Type
oiu_pr_mpapd oiu_pr_mpapd from

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_VolumeType _VolumeType _VolumeType.VolumeType = $projection.PRAVolumeType
[1..1] I_PRAMatlMjrProdMappg _PRAMatlMjrProdMappg _PRAMatlMjrProdMappg.Material = $projection.PRAMaterial
[1..1] I_PRAVolumeIndicatorCodeVH _PRAVolumeIndicatorType _PRAVolumeIndicatorType.PRAVolumeCode = $projection.PRAVolumeCode

Annotations (11)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Measure Point Allocation Profile Detail view
VDM.viewType #BASIC view
Metadata.ignorePropagatedAnnotations true view
Analytics.technicalName IPRAMsmtPtAllocPrflDetail view
Analytics.dataExtraction.enabled true view
Analytics.dataCategory #FACT view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.sapObjectNodeType.name PRAMsmtPtAllocProfileDetail view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY PRAMsmtPtAllocProfileNumber mpaph_no Measurement point allocation profile number
KEY PRAVolumeType Volume Type Code
KEY PRAMaterial Material Number
PRAVolumeCode Volume Indicator Code
PRAProductionFormulaNumber Formula number - Production
CreatedByUser oiu_cruser Name of Person Responsible for Creating the Object
CreationDateTime oiu_timestamp UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
_VolumeType _VolumeType
_PRAMatlMjrProdMappg _PRAMatlMjrProdMappg
_PRAVolumeIndicatorType _PRAVolumeIndicatorType

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_PRAMsmtPtAllocProfileDetail.
-- 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_PRAMsmtPtAllocProfileDetail AS
SELECT
  mpaph_no AS PRAMsmtPtAllocProfileNumber,
  cast(vt_cd as oiu_vl_type_cd preserving type ) AS PRAVolumeType,
  cast(matnr as matnr preserving type ) AS PRAMaterial,
  cast(vli_cd as oiu_vli_cd preserving type ) AS PRAVolumeCode,
  cast(frml_no as oiu_pr_frml_no preserving type ) AS PRAProductionFormulaNumber,
  oiu_cruser AS CreatedByUser,
  oiu_timestamp AS CreationDateTime
FROM oiu_pr_mpapd
LEFT OUTER JOIN I_VolumeType AS _VolumeType ON _VolumeType.VolumeType = PRAVolumeType  -- association [1..1]
LEFT OUTER JOIN I_PRAMatlMjrProdMappg AS _PRAMatlMjrProdMappg ON _PRAMatlMjrProdMappg.Material = PRAMaterial  -- association [1..1]
LEFT OUTER JOIN I_PRAVolumeIndicatorCodeVH AS _PRAVolumeIndicatorType ON _PRAVolumeIndicatorType.PRAVolumeCode = PRAVolumeCode  -- association [1..1]
;

Learn More