I_PurReqnAlgnmtMntrProdFailRsn

DDL: I_PURREQNALGNMTMNTRPRODFAILRSN SQL: IPRAMPFR Type: view BASIC Package: RFM_ALIGNMENT_MONITOR
6 Fields 1 Data Sources

Failure Reason for Pur Reqn

I_PurReqnAlgnmtMntrProdFailRsn is a Basic CDS View that provides data about "Failure Reason for Pur Reqn" in SAP S/4HANA. It reads from 1 data source (rfm_align_rscode) and exposes 6 fields with key fields PurReqnAlignmentID, PurchasingDocument, PurchasingDocumentItem. Part of development package RFM_ALIGNMENT_MONITOR.

Data Sources (1)

SourceAliasJoin Type
rfm_align_rscode rfm_align_rscode from

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName IPRAMPFR view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Failure Reason for Pur Reqn view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #REQUIRED view
VDM.viewType #BASIC view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY PurReqnAlignmentID Reason alignid Alignment ID
KEY PurchasingDocument Reason ebeln Source PurchDoc
KEY PurchasingDocumentItem Reason ebelp Item pur. doc.
ebelnendasPurchasingDocumentItemUniqueID
ReasonCode Reason reason_code Return/Change Reason
RFMAlgnmtRunRsnCode Reason reason_code Return/Change Reason

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_PurReqnAlgnmtMntrProdFailRsn.
-- 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: IPRAMPFR

CREATE VIEW I_PurReqnAlgnmtMntrProdFailRsn AS
SELECT
  Reason.alignid AS PurReqnAlignmentID,
  Reason.ebeln AS PurchasingDocument,
  Reason.ebelp AS PurchasingDocumentItem,
  case when Reason.ebelp <> '00000' then cast (concat(Reason.ebeln , Reason.ebelp) as purchasingdocumentitemuniqueid) else Reason.ebeln end as PurchasingDocumentItemUniqueID AS ebelnendasPurchasingDocumentItemUniqueID,
  Reason.reason_code AS ReasonCode,
  Reason.reason_code AS RFMAlgnmtRunRsnCode
FROM rfm_align_rscode
;

Learn More