C_RAFlfmtWithRevnNonDistinct

DDL: C_RAFLFMTWITHREVNNONDISTINCT Type: view_entity CONSUMPTION
19 Fields 1 Data Sources 3 Associations

Flfmt by Date of Non-distinct Perf Oblgn

C_RAFlfmtWithRevnNonDistinct is a Consumption CDS View that provides data about "Flfmt by Date of Non-distinct Perf Oblgn" in SAP S/4HANA. It reads from 1 data source (I_RAFlfmtWithRevnNonDistinct) and exposes 19 fields with key fields PerformanceObligation, RevenueAccountingContract, RevnAcctgReconciliationKey, CompndPerfOblgnFulfillmentDate. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_RAFlfmtWithRevnNonDistinct FlfmtNonDistinct from

Associations (3)

CardinalityTargetAliasCondition
[1..*] I_RAPerfOblgnFlfmtTypeText _FulfillmentTypeName $projection.PerfOblgnFulfillmentType = _FulfillmentTypeName.PerfOblgnFulfillmentType
[1..*] I_RAPerfOblgnEventTypeText _EventTypeText $projection.PerfOblgnEventType = _EventTypeText.PerfOblgnEventType
[0..*] C_RAFulfillmentDocNonDistinct _FlfmtDocNonDistinct FlfmtNonDistinct.PerformanceObligation = _FlfmtDocNonDistinct.PerformanceObligation and FlfmtNonDistinct.RevenueAccountingContract = _FlfmtDocNonDistinct.RevenueAccountingContract and FlfmtNonDistinct.RevnAcctgReconciliationKey = _FlfmtDocNonDistinct.RevnAcctgReconciliationKey and FlfmtNonDistinct.CompndPerfOblgnFulfillmentDate = _FlfmtDocNonDistinct.CompndPerfOblgnFulfillmentDate

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label Flfmt by Date of Non-distinct Perf Oblgn view
Metadata.allowExtensions true view
ObjectModel.text.control #ASSOCIATED_TEXT_UI_HIDDEN view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #CONSUMPTION view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY PerformanceObligation PerformanceObligation Performance Obligation
KEY RevenueAccountingContract RevenueAccountingContract Revenue Contract
KEY RevnAcctgReconciliationKey RevnAcctgReconciliationKey
KEY CompndPerfOblgnFulfillmentDate CompndPerfOblgnFulfillmentDate
RAHigherLevelPerfOblgn RAHigherLevelPerfOblgn Higher-Level POB
PerfOblgnEffectiveQuantity PerfOblgnEffectiveQuantity Effective Quantity
PerfOblgnEffectiveQuantityUnit PerfOblgnEffectiveQuantityUnit Unit of Measure
PerformanceObligationClass PerformanceObligationClass Performance Obligation Name
PerfOblgnFulfillmentType PerfOblgnFulfillmentType Fulfillment Type
PerfOblgnEventType PerfOblgnEventType Event Type
CompanyCode CompanyCode Receiver Company Code
ReportedFulfilledQuantity ReportedFulfilledQuantity
PerfOblgnTotalFulfilledQty PerfOblgnTotalFulfilledQty
FulfilledQuantityUnit FulfilledQuantityUnit
RatioUnit RatioUnit Unit of Measure
PerfOblgnFulfilledQtyRatio PerfOblgnFulfilledQtyRatio
_FlfmtDocNonDistinct _FlfmtDocNonDistinct
_FulfillmentTypeName _FulfillmentTypeName
_EventTypeText _EventTypeText

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 C_RAFlfmtWithRevnNonDistinct.
-- 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 C_RAFlfmtWithRevnNonDistinct AS
SELECT
  PerformanceObligation,
  RevenueAccountingContract,
  RevnAcctgReconciliationKey,
  CompndPerfOblgnFulfillmentDate,
  RAHigherLevelPerfOblgn,
  PerfOblgnEffectiveQuantity,
  PerfOblgnEffectiveQuantityUnit,
  PerformanceObligationClass,
  PerfOblgnFulfillmentType,
  PerfOblgnEventType,
  CompanyCode,
  ReportedFulfilledQuantity,
  PerfOblgnTotalFulfilledQty,
  FulfilledQuantityUnit,
  RatioUnit,
  PerfOblgnFulfilledQtyRatio
FROM I_RAFlfmtWithRevnNonDistinct AS FlfmtNonDistinct
LEFT OUTER JOIN I_RAPerfOblgnFlfmtTypeText AS _FulfillmentTypeName ON PerfOblgnFulfillmentType = _FulfillmentTypeName.PerfOblgnFulfillmentType  -- association [1..*]
LEFT OUTER JOIN I_RAPerfOblgnEventTypeText AS _EventTypeText ON PerfOblgnEventType = _EventTypeText.PerfOblgnEventType  -- association [1..*]
LEFT OUTER JOIN C_RAFulfillmentDocNonDistinct AS _FlfmtDocNonDistinct ON FlfmtNonDistinct.PerformanceObligation = _FlfmtDocNonDistinct.PerformanceObligation AND FlfmtNonDistinct.RevenueAccountingContract = _FlfmtDocNonDistinct.RevenueAccountingContract AND FlfmtNonDistinct.RevnAcctgReconciliationKey = _FlfmtDocNonDistinct.RevnAcctgReconciliationKey AND FlfmtNonDistinct.CompndPerfOblgnFulfillmentDate = _FlfmtDocNonDistinct.CompndPerfOblgnFulfillmentDate  -- association [0..*]
;

Learn More