R_RAFinComplianceSuspension

DDL: R_RAFINCOMPLIANCESUSPENSION Type: view_entity TRANSACTIONAL
23 Fields 1 Data Sources 6 Associations

Compliance of Suspension Date

R_RAFinComplianceSuspension is a Transactional CDS View that provides data about "Compliance of Suspension Date" in SAP S/4HANA. It reads from 1 data source (I_RAPerformanceObligation) and exposes 23 fields with key field PerformanceObligation. It has 6 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_RAPerformanceObligation _RAPerformanceObligation from

Associations (6)

CardinalityTargetAliasCondition
[0..1] P_RAPerfOblgnSuspendedRevenue SuspendedRevenue _RAPerformanceObligation.PerformanceObligation = SuspendedRevenue.PerformanceObligation
[0..1] P_RAPerfOblgnSuspendedCost SuspendedCost _RAPerformanceObligation.PerformanceObligation = SuspendedCost.PerformanceObligation
[0..*] I_RASuspensionReasonText _RASuspensionReasonText $projection.RevnAcctgSuspensionReason = _RASuspensionReasonText.RevnAcctgSuspensionReason and _RASuspensionReasonText.Language = $session.system_language
[0..1] I_BusinessPartner _BusinessPartner $projection.BusinessPartner = _BusinessPartner.BusinessPartner
[0..1] I_Customer _Customer $projection.Customer = _Customer.Customer
[1..1] E_RAPerformanceObligation _E_RAPerformanceObligation $projection.PerformanceObligation = _E_RAPerformanceObligation.PerformanceObligation

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
EndUserText.label Compliance of Suspension Date view

Fields (23)

KeyFieldSource TableSource FieldDescription
KEY PerformanceObligation I_RAPerformanceObligation PerformanceObligation Performance Obligation
RevenueAccountingContract I_RAPerformanceObligation RevenueAccountingContract Revenue Contract
CompanyCode I_RAPerformanceObligation CompanyCode Receiver Company Code
AccountingPrinciple I_RAPerformanceObligation AccountingPrinciple AP Ledger/CoCode
PerformanceObligationClass I_RAPerformanceObligation PerformanceObligationClass Performance Obligation Name
RevnAcctgSuspensionDate I_RAPerformanceObligation RevnAcctgSuspensionDate Suspension Date
RevnAcctgSuspensionReason I_RAPerformanceObligation RevnAcctgSuspensionReason Suspension Reason
RevnAcctgSuspensionReasonName
SalesDocumentCurrency SuspendedRevenue SalesDocumentCurrency Currency
SuspendedRevnAmtInSlsDocCrcy
CostCurrency SuspendedCost CostCurrency Cost Currency
SuspendedCostAmtInSlsDocCrcy
RAPerformanceObligationType I_RAPerformanceObligation RAPerformanceObligationType Performance Obligation Type
BusinessPartner I_RAPerformanceObligation BusinessPartner Issuing Authority
BusinessPartnerName _BusinessPartner BusinessPartnerName Extracted Customer Name
Customer I_RAPerformanceObligation Customer Sold-to Party
CustomerName
ProfitCenter I_RAPerformanceObligation ProfitCenter Profit Center
Segment I_RAPerformanceObligation Segment Segment number
CostCenter I_RAPerformanceObligation CostCenter Cost Center
OrderID I_RAPerformanceObligation OrderID Order ID
WBSElementExternalID I_RAPerformanceObligation WBSElementExternalID WBS Element External ID
IsBusinessPurposeCompleted

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_RAFinComplianceSuspension.
-- 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_RAFinComplianceSuspension AS
SELECT
  _RAPerformanceObligation.PerformanceObligation AS PerformanceObligation,
  _RAPerformanceObligation.RevenueAccountingContract AS RevenueAccountingContract,
  _RAPerformanceObligation.CompanyCode AS CompanyCode,
  _RAPerformanceObligation.AccountingPrinciple AS AccountingPrinciple,
  _RAPerformanceObligation.PerformanceObligationClass AS PerformanceObligationClass,
  _RAPerformanceObligation.RevnAcctgSuspensionDate AS RevnAcctgSuspensionDate,
  _RAPerformanceObligation.RevnAcctgSuspensionReason AS RevnAcctgSuspensionReason,
  cast(_RASuspensionReasonText.RevnAcctgSuspensionReasonName as farr_suspension_reason_name) AS RevnAcctgSuspensionReasonName,
  SuspendedRevenue.SalesDocumentCurrency AS SalesDocumentCurrency,
  cast(SuspendedRevenue.SuspendedRevnAmtInSlsDocCrcy as farr_cds_suspended_revenue) AS SuspendedRevnAmtInSlsDocCrcy,
  SuspendedCost.CostCurrency AS CostCurrency,
  cast(SuspendedCost.SuspendedCostAmtInSlsDocCrcy as farr_cds_suspended_cost) AS SuspendedCostAmtInSlsDocCrcy,
  _RAPerformanceObligation.RAPerformanceObligationType AS RAPerformanceObligationType,
  _RAPerformanceObligation.BusinessPartner AS BusinessPartner,
  _BusinessPartner.BusinessPartnerName AS BusinessPartnerName,
  _RAPerformanceObligation.Customer AS Customer,
  cast(_Customer.CustomerName as farr_cds_customer_name) AS CustomerName,
  _RAPerformanceObligation.ProfitCenter AS ProfitCenter,
  _RAPerformanceObligation.Segment AS Segment,
  _RAPerformanceObligation.CostCenter AS CostCenter,
  _RAPerformanceObligation.OrderID AS OrderID,
  _RAPerformanceObligation.WBSElementExternalID AS WBSElementExternalID,
  _RAPerformanceObligation._RevenueAccountingContract.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted
FROM I_RAPerformanceObligation AS _RAPerformanceObligation
LEFT OUTER JOIN P_RAPerfOblgnSuspendedRevenue AS SuspendedRevenue ON _RAPerformanceObligation.PerformanceObligation = SuspendedRevenue.PerformanceObligation  -- association [0..1]
LEFT OUTER JOIN P_RAPerfOblgnSuspendedCost AS SuspendedCost ON _RAPerformanceObligation.PerformanceObligation = SuspendedCost.PerformanceObligation  -- association [0..1]
LEFT OUTER JOIN I_RASuspensionReasonText AS _RASuspensionReasonText ON RevnAcctgSuspensionReason = _RASuspensionReasonText.RevnAcctgSuspensionReason AND _RASuspensionReasonText.Language = $session.system_language  -- association [0..*]
LEFT OUTER JOIN I_BusinessPartner AS _BusinessPartner ON BusinessPartner = _BusinessPartner.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _Customer ON Customer = _Customer.Customer  -- association [0..1]
LEFT OUTER JOIN E_RAPerformanceObligation AS _E_RAPerformanceObligation ON PerformanceObligation = _E_RAPerformanceObligation.PerformanceObligation  -- association [1..1]
;

Learn More