Deprecated
This CDS view is deprecated in S/4HANA. View all deprecated CDS views →

C_RAPerfOblgnWithToCurPerdAmt

DDL: C_RAPERFOBLGNWITHTOCURPERDAMT SQL: CRAPERFOBLGNWAMT Type: view CONSUMPTION

Consumption RA Perf Oblgn With Amt

C_RAPerfOblgnWithToCurPerdAmt is a Consumption CDS View that provides data about "Consumption RA Perf Oblgn With Amt" in SAP S/4HANA. It reads from 1 data source (I_RAPerfOblgnWithToCurPerdAmt) and exposes 58 fields with key field PerformanceObligation. It has 9 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_RAPerfOblgnWithToCurPerdAmt PerfOblgn from

Associations (9)

CardinalityTargetAliasCondition
[1..1] C_RAContrWithPostedBalance _Contract $projection.RevenueAccountingContract = _Contract.RevenueAccountingContract
[0..*] C_RAPerfOblgnWthCndnTypeAmt _ConditionType $projection.RevenueAccountingContract = _ConditionType.RevenueAccountingContract and $projection.PerformanceObligation = _ConditionType.PerformanceObligation
[0..*] C_RAPerfOblgnWithFreezeDate _Freeze $projection.PerformanceObligation = _Freeze.PerformanceObligation
[0..1] P_RAPerfOblgnIsFrozen _IsFrozen $projection.PerformanceObligation = _IsFrozen.PerformanceObligation
[1..*] I_RAPerfOblgnFlfmtTypeText _FulfillmentTypeName $projection.PerfOblgnFulfillmentType = _FulfillmentTypeName.PerfOblgnFulfillmentType
[1..*] I_RAPerfOblgnEventTypeText _EventTypeText $projection.PerfOblgnEventType = _EventTypeText.PerfOblgnEventType
[1..*] I_RAPerfOblgnStartDateTypeText _StartDateTypeText $projection.PerfOblgnStartDateType = _StartDateTypeText.PerfOblgnStartDateType
[1..*] I_RAPerfOblgnDeferralMethodTxt _DeferralMethodTxt $projection.PerfObligationDeferralMethod = _DeferralMethodTxt.PerfObligationDeferralMethod
[1..*] I_RAPerfOblgnStatusText _PerfOblgnStatusText $projection.RevnAcctgPerfOblgnStatus = _PerfOblgnStatusText.RevnAcctgPerfOblgnStatus

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName CRAPERFOBLGNWAMT view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Consumption RA Perf Oblgn With Amt view
Metadata.allowExtensions true view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
Search.searchable true view
VDM.lifecycle.status #DEPRECATED view
VDM.viewType #CONSUMPTION view

Fields (58)

KeyFieldSource TableSource FieldDescription
KEY PerformanceObligation I_RAPerfOblgnWithToCurPerdAmt PerformanceObligation Performance Obligation
RevenueAccountingContract I_RAPerfOblgnWithToCurPerdAmt RevenueAccountingContract Revenue Contract
PerformanceObligationClass I_RAPerfOblgnWithToCurPerdAmt PerformanceObligationClass Performance Obligation Name
SalesDocumentCurrency I_RAPerfOblgnWithToCurPerdAmt SalesDocumentCurrency Currency
ContractualPrcInSlsDocCrcy I_RAPerfOblgnWithToCurPerdAmt ContractualPrcInSlsDocCrcy Contractual Price
SSPriceInSalesDocCrcy I_RAPerfOblgnWithToCurPerdAmt SSPriceInSalesDocCrcy Standalone Selling Price
AllocatedPriceInSalesDocCrcy I_RAPerfOblgnWithToCurPerdAmt AllocatedPriceInSalesDocCrcy Allocated Amount
AllocEffctAmountInSalesDocCrcy I_RAPerfOblgnWithToCurPerdAmt AllocEffctAmountInSalesDocCrcy Allocation Effect
UpToCurPeriodInvoicedAmount I_RAPerfOblgnWithToCurPerdAmt UpToCurPeriodInvoicedAmount
PerfOblgnEffectiveQuantityUnit I_RAPerfOblgnWithToCurPerdAmt PerfOblgnEffectiveQuantityUnit Unit of Measure
PerfOblgnEffectiveQuantity I_RAPerfOblgnWithToCurPerdAmt PerfOblgnEffectiveQuantity Effective Quantity
PerfOblgnFulfillmentType I_RAPerfOblgnWithToCurPerdAmt PerfOblgnFulfillmentType Fulfillment Type
PerfOblgnEventType I_RAPerfOblgnWithToCurPerdAmt PerfOblgnEventType Event Type
RevnAcctgOperationalDocument I_RAPerfOblgnWithToCurPerdAmt RevnAcctgOperationalDocument
RevnAcctgSenderComponent I_RAPerfOblgnWithToCurPerdAmt RevnAcctgSenderComponent Sender Component
UpToCurPeriodRecognizedRevenue I_RAPerfOblgnWithToCurPerdAmt UpToCurPeriodRecognizedRevenue Recognizable Revenue
RecognizedRevnUpToCurPerdPct
RatioUnit I_RAPerfOblgnWithToCurPerdAmt RatioUnit Unit of Measure
PerfOblgnStartDateType I_RAPerfOblgnWithToCurPerdAmt PerfOblgnStartDateType Start Date Type
PerformanceObligationStartDate I_RAPerfOblgnWithToCurPerdAmt PerformanceObligationStartDate Start Date
PerformanceObligationEndDate I_RAPerfOblgnWithToCurPerdAmt PerformanceObligationEndDate End Date
PerfObligationDeferralMethod I_RAPerfOblgnWithToCurPerdAmt PerfObligationDeferralMethod Deferral Method
PerfOblgnContractualQuantity I_RAPerfOblgnWithToCurPerdAmt PerfOblgnContractualQuantity Quantity
PerfOblgnContractualQtyUnit I_RAPerfOblgnWithToCurPerdAmt PerfOblgnContractualQtyUnit Unit of Measure
UpToCurPeriodFulfilledQty I_RAPerfOblgnWithToCurPerdAmt UpToCurPeriodFulfilledQty
FulfilledQtyUpToCurPerdRatio I_RAPerfOblgnWithToCurPerdAmt FulfilledQtyUpToCurPerdRatio
UpToCurPeriodInvoicedQty I_RAPerfOblgnWithToCurPerdAmt UpToCurPeriodInvoicedQty
PerUnitSSPriceInSlsDocCrcy I_RAPerfOblgnWithToCurPerdAmt PerUnitSSPriceInSlsDocCrcy SSP per Unit
PerfOblgnIsExclFromPriceAlloc I_RAPerfOblgnWithToCurPerdAmt PerfOblgnIsExclFromPriceAlloc Excluded from Allocation
PerfOblgnIsFullyFulfilled I_RAPerfOblgnWithToCurPerdAmt PerfOblgnIsFullyFulfilled Is Fully Fulfilled
PerfOblgnIsFinallyInvoiced I_RAPerfOblgnWithToCurPerdAmt PerfOblgnIsFinallyInvoiced Final Invoice
BusinessPartner I_RAPerfOblgnWithToCurPerdAmt BusinessPartner Issuing Authority
BusinessPartnerName
CostCenter I_RAPerfOblgnWithToCurPerdAmt CostCenter Cost Center
ProfitCenter I_RAPerfOblgnWithToCurPerdAmt ProfitCenter Profit Center
WBSElementExternalID I_RAPerfOblgnWithToCurPerdAmt WBSElementExternalID WBS Element External ID
Segment I_RAPerfOblgnWithToCurPerdAmt Segment Segment number
Customer I_RAPerfOblgnWithToCurPerdAmt Customer Sold-to Party
CustomerName
RevnAcctgPerfOblgnStatus I_RAPerfOblgnWithToCurPerdAmt RevnAcctgPerfOblgnStatus Perf. Oblig. Status
RAPerfOblgnCompletionDate I_RAPerfOblgnWithToCurPerdAmt RAPerfOblgnCompletionDate Completion Date
CompanyCode I_RAPerfOblgnWithToCurPerdAmt CompanyCode Receiver Company Code
RevnAcctgSalesOrganization I_RAPerfOblgnWithToCurPerdAmt RevnAcctgSalesOrganization Sales Org.
AccountingPrinciple I_RAPerfOblgnWithToCurPerdAmt AccountingPrinciple AP Ledger/CoCode
PerfOblgnCreatedByUser I_RAPerfOblgnWithToCurPerdAmt PerfOblgnCreatedByUser Created By
PerfOblgnCreationDate I_RAPerfOblgnWithToCurPerdAmt PerfOblgnCreationDate Created On
PerfOblgnLastChangeDate I_RAPerfOblgnWithToCurPerdAmt PerfOblgnLastChangeDate Changed on
PerfOblgnLastChangedByUsr I_RAPerfOblgnWithToCurPerdAmt PerfOblgnLastChangedByUsr Last Changed By
RAFulfillmentTypeIsTimeBased I_RAPerfOblgnWithToCurPerdAmt RAFulfillmentTypeIsTimeBased TRUE
RAFulfillmentTypeIsEventBased I_RAPerfOblgnWithToCurPerdAmt RAFulfillmentTypeIsEventBased TRUE
_Contract _Contract
_ConditionType _ConditionType
_Freeze _Freeze
_FulfillmentTypeName _FulfillmentTypeName
_EventTypeText _EventTypeText
_StartDateTypeText _StartDateTypeText
_DeferralMethodTxt _DeferralMethodTxt
_PerfOblgnStatusText _PerfOblgnStatusText

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_RAPerfOblgnWithToCurPerdAmt.
-- 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: CRAPERFOBLGNWAMT

CREATE VIEW C_RAPerfOblgnWithToCurPerdAmt AS
SELECT
  PerfOblgn.PerformanceObligation AS PerformanceObligation,
  PerfOblgn.RevenueAccountingContract AS RevenueAccountingContract,
  PerfOblgn.PerformanceObligationClass AS PerformanceObligationClass,
  PerfOblgn.SalesDocumentCurrency AS SalesDocumentCurrency,
  PerfOblgn.ContractualPrcInSlsDocCrcy AS ContractualPrcInSlsDocCrcy,
  PerfOblgn.SSPriceInSalesDocCrcy AS SSPriceInSalesDocCrcy,
  PerfOblgn.AllocatedPriceInSalesDocCrcy AS AllocatedPriceInSalesDocCrcy,
  PerfOblgn.AllocEffctAmountInSalesDocCrcy AS AllocEffctAmountInSalesDocCrcy,
  PerfOblgn.UpToCurPeriodInvoicedAmount AS UpToCurPeriodInvoicedAmount,
  PerfOblgn.PerfOblgnEffectiveQuantityUnit AS PerfOblgnEffectiveQuantityUnit,
  PerfOblgn.PerfOblgnEffectiveQuantity AS PerfOblgnEffectiveQuantity,
  PerfOblgn.PerfOblgnFulfillmentType AS PerfOblgnFulfillmentType,
  PerfOblgn.PerfOblgnEventType AS PerfOblgnEventType,
  PerfOblgn.RevnAcctgOperationalDocument AS RevnAcctgOperationalDocument,
  PerfOblgn.RevnAcctgSenderComponent AS RevnAcctgSenderComponent,
  PerfOblgn.UpToCurPeriodRecognizedRevenue AS UpToCurPeriodRecognizedRevenue,
  cast(PerfOblgn.RecognizedRevnUpToCurPerdPct as farr_fulfilled_rev_progress) AS RecognizedRevnUpToCurPerdPct,
  PerfOblgn.RatioUnit AS RatioUnit,
  PerfOblgn.PerfOblgnStartDateType AS PerfOblgnStartDateType,
  PerfOblgn.PerformanceObligationStartDate AS PerformanceObligationStartDate,
  PerfOblgn.PerformanceObligationEndDate AS PerformanceObligationEndDate,
  PerfOblgn.PerfObligationDeferralMethod AS PerfObligationDeferralMethod,
  PerfOblgn.PerfOblgnContractualQuantity AS PerfOblgnContractualQuantity,
  PerfOblgn.PerfOblgnContractualQtyUnit AS PerfOblgnContractualQtyUnit,
  PerfOblgn.UpToCurPeriodFulfilledQty AS UpToCurPeriodFulfilledQty,
  PerfOblgn.FulfilledQtyUpToCurPerdRatio AS FulfilledQtyUpToCurPerdRatio,
  PerfOblgn.UpToCurPeriodInvoicedQty AS UpToCurPeriodInvoicedQty,
  PerfOblgn.PerUnitSSPriceInSlsDocCrcy AS PerUnitSSPriceInSlsDocCrcy,
  PerfOblgn.PerfOblgnIsExclFromPriceAlloc AS PerfOblgnIsExclFromPriceAlloc,
  PerfOblgn.PerfOblgnIsFullyFulfilled AS PerfOblgnIsFullyFulfilled,
  PerfOblgn.PerfOblgnIsFinallyInvoiced AS PerfOblgnIsFinallyInvoiced,
  PerfOblgn.BusinessPartner AS BusinessPartner,
  PerfOblgn._BusinessPartner.BusinessPartnerName AS BusinessPartnerName,
  PerfOblgn.CostCenter AS CostCenter,
  PerfOblgn.ProfitCenter AS ProfitCenter,
  PerfOblgn.WBSElementExternalID AS WBSElementExternalID,
  PerfOblgn.Segment AS Segment,
  PerfOblgn.Customer AS Customer,
  PerfOblgn._Customer.CustomerName AS CustomerName,
  PerfOblgn.RevnAcctgPerfOblgnStatus AS RevnAcctgPerfOblgnStatus,
  PerfOblgn.RAPerfOblgnCompletionDate AS RAPerfOblgnCompletionDate,
  PerfOblgn.CompanyCode AS CompanyCode,
  PerfOblgn.RevnAcctgSalesOrganization AS RevnAcctgSalesOrganization,
  PerfOblgn.AccountingPrinciple AS AccountingPrinciple,
  PerfOblgn.PerfOblgnCreatedByUser AS PerfOblgnCreatedByUser,
  PerfOblgn.PerfOblgnCreationDate AS PerfOblgnCreationDate,
  PerfOblgn.PerfOblgnLastChangeDate AS PerfOblgnLastChangeDate,
  PerfOblgn.PerfOblgnLastChangedByUsr AS PerfOblgnLastChangedByUsr,
  PerfOblgn.RAFulfillmentTypeIsTimeBased AS RAFulfillmentTypeIsTimeBased,
  PerfOblgn.RAFulfillmentTypeIsEventBased AS RAFulfillmentTypeIsEventBased
FROM I_RAPerfOblgnWithToCurPerdAmt AS PerfOblgn
LEFT OUTER JOIN C_RAContrWithPostedBalance AS _Contract ON RevenueAccountingContract = _Contract.RevenueAccountingContract  -- association [1..1]
LEFT OUTER JOIN C_RAPerfOblgnWthCndnTypeAmt AS _ConditionType ON RevenueAccountingContract = _ConditionType.RevenueAccountingContract AND PerformanceObligation = _ConditionType.PerformanceObligation  -- association [0..*]
LEFT OUTER JOIN C_RAPerfOblgnWithFreezeDate AS _Freeze ON PerformanceObligation = _Freeze.PerformanceObligation  -- association [0..*]
LEFT OUTER JOIN P_RAPerfOblgnIsFrozen AS _IsFrozen ON PerformanceObligation = _IsFrozen.PerformanceObligation  -- association [0..1]
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 I_RAPerfOblgnStartDateTypeText AS _StartDateTypeText ON PerfOblgnStartDateType = _StartDateTypeText.PerfOblgnStartDateType  -- association [1..*]
LEFT OUTER JOIN I_RAPerfOblgnDeferralMethodTxt AS _DeferralMethodTxt ON PerfObligationDeferralMethod = _DeferralMethodTxt.PerfObligationDeferralMethod  -- association [1..*]
LEFT OUTER JOIN I_RAPerfOblgnStatusText AS _PerfOblgnStatusText ON RevnAcctgPerfOblgnStatus = _PerfOblgnStatusText.RevnAcctgPerfOblgnStatus  -- association [1..*]
;