R_RAPerformanceObligationTP

DDL: R_RAPERFORMANCEOBLIGATIONTP Type: view_entity TRANSACTIONAL
39 Fields 1 Data Sources 5 Associations

RA Performance Obligation

R_RAPerformanceObligationTP is a Transactional CDS View that provides data about "RA Performance Obligation" in SAP S/4HANA. It reads from 1 data source (I_RAPerformanceObligation) and exposes 39 fields with key field PerformanceObligation. It has 5 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_RAPerformanceObligation PerformanceObligation from

Associations (5)

CardinalityTargetAliasCondition
[1..1] P_RACompoundMnllyAllcdPrc _CompoundMnllyAllcdPrc $projection.PerformanceObligation = _CompoundMnllyAllcdPrc.PerformanceObligation and $projection.RevenueAccountingContract = _CompoundMnllyAllcdPrc.RevenueAccountingContract
[1..1] I_RAPerfOblgnMnllyChgdAttrib _ManualChange $projection.PerformanceObligation = _ManualChange.PerformanceObligation and _ManualChange.RAManuallyChangedAttribute = 'ALLOC_AMT'
[1..*] I_RAPerfOblgnStatusText _RAPerfOblgnStatusText $projection.RevnAcctgPerfOblgnStatus = _RAPerfOblgnStatusText.RevnAcctgPerfOblgnStatus
[1..*] I_RAUnivRevnRecgnIntegTypeText _RAUnivRevnRecgnIntegTypeText $projection.RAUnivRevnRecgnIntegType = _RAUnivRevnRecgnIntegTypeText.RAUnivRevnRecgnIntegType
[0..*] I_RASuspensionReasonText _RASuspensionReasonText $projection.RevnAcctgSuspensionReason = _RASuspensionReasonText.RevnAcctgSuspensionReason

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label RA Performance Obligation view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MIXED view

Fields (39)

KeyFieldSource TableSource FieldDescription
KEY PerformanceObligation I_RAPerformanceObligation PerformanceObligation Performance Obligation
RevenueAccountingContract I_RAPerformanceObligation RevenueAccountingContract Revenue Contract
PerformanceObligationClass I_RAPerformanceObligation PerformanceObligationClass Performance Obligation Name
RAPerformanceObligationType I_RAPerformanceObligation RAPerformanceObligationType Performance Obligation Type
RAPerfOblgnDistinctType I_RAPerformanceObligation RAPerfOblgnDistinctType Composition
RAPerfOblgnDistinctTypeName
SSPriceInSalesDocCrcy I_RAPerformanceObligation SSPriceInSalesDocCrcy Standalone Selling Price
AllocEffctAmountInSalesDocCrcy
PerfOblgnIsExclFromPriceAlloc I_RAPerformanceObligation PerfOblgnIsExclFromPriceAlloc Excluded from Allocation
RAPerfOblgnCategory I_RAPerformanceObligation RAPerfOblgnCategory Performance Obligation Category
RAPerfOblgnCategoryName
AccountingPrinciple I_RAPerformanceObligation AccountingPrinciple AP Ledger/CoCode
CompanyCode I_RAPerformanceObligation CompanyCode Receiver Company Code
RevnAcctgPerfOblgnStatus I_RAPerformanceObligation RevnAcctgPerfOblgnStatus Perf. Oblig. Status
RAPerfOblgnIsResidual I_RAPerformanceObligation RAPerfOblgnIsResidual Residual Allocation
SalesDocumentCurrency I_RAPerformanceObligation SalesDocumentCurrency Currency
PerformanceObligationStartDate I_RAPerformanceObligation PerformanceObligationStartDate Start Date
PerformanceObligationEndDate I_RAPerformanceObligation PerformanceObligationEndDate End Date
PerfOblgnIsSoftDeleted I_RAPerformanceObligation PerfOblgnIsSoftDeleted Soft Deleted
PerfOblgnToBeFulfilledQuantity
PerfOblgnEffectiveQuantityUnit I_RAPerformanceObligation PerfOblgnEffectiveQuantityUnit Unit of Measure
PerfOblgnFulfillmentType I_RAPerformanceObligation PerfOblgnFulfillmentType Fulfillment Type
PerfOblgnEventType I_RAPerformanceObligation PerfOblgnEventType Event Type
RevnAcctgSuspensionDate I_RAPerformanceObligation RevnAcctgSuspensionDate Suspension Date
RevnAcctgSuspensionReason I_RAPerformanceObligation RevnAcctgSuspensionReason Suspension Reason
RAUnivRevnRecgnIntegType I_RAPerformanceObligation RAUnivRevnRecgnIntegType URR Integration Type
RAPerfOblgnAssetImpairmentDate I_RAPerformanceObligation RAPerfOblgnAssetImpairmentDate
RAPerfOblgnHasAssetImpairment I_RAPerformanceObligation RAPerfOblgnHasAssetImpairment
_Contract _Contract
_AccountingPrinciple I_RAPerformanceObligation _AccountingPrinciple
_CompanyCode I_RAPerformanceObligation _CompanyCode
_RAPerfOblgnCategory I_RAPerformanceObligation _RAPerfOblgnCategory
_PerfOblgnDistinctType I_RAPerformanceObligation _PerfOblgnDistinctType
_PerfOblgnEffectiveQtyUnit I_RAPerformanceObligation _PerfOblgnEffectiveQtyUnit
_FulfillmentType I_RAPerformanceObligation _FulfillmentType
_PerfObligationEventType I_RAPerformanceObligation _PerfObligationEventType
_RAPerfOblgnStatusText _RAPerfOblgnStatusText
_RAUnivRevnRecgnIntegTypeText _RAUnivRevnRecgnIntegTypeText
_RASuspensionReasonText _RASuspensionReasonText

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_RAPerformanceObligationTP.
-- 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_RAPerformanceObligationTP AS
SELECT
  PerformanceObligation.PerformanceObligation AS PerformanceObligation,
  PerformanceObligation.RevenueAccountingContract AS RevenueAccountingContract,
  PerformanceObligation.PerformanceObligationClass AS PerformanceObligationClass,
  PerformanceObligation.RAPerformanceObligationType AS RAPerformanceObligationType,
  PerformanceObligation.RAPerfOblgnDistinctType AS RAPerfOblgnDistinctType,
  PerformanceObligation._PerfOblgnDistinctType._Text[Language=$session.system_language].RAPerfOblgnDistinctTypeName AS RAPerfOblgnDistinctTypeName,
  PerformanceObligation.SSPriceInSalesDocCrcy AS SSPriceInSalesDocCrcy,
  cast((PerformanceObligation.AllocatedPriceInSalesDocCrcy - PerformanceObligation.ContractualPrcInSlsDocCrcy) as farr_corr_amt ) AS AllocEffctAmountInSalesDocCrcy,
  PerformanceObligation.PerfOblgnIsExclFromPriceAlloc AS PerfOblgnIsExclFromPriceAlloc,
  PerformanceObligation.RAPerfOblgnCategory AS RAPerfOblgnCategory,
  PerformanceObligation._RAPerfOblgnCategory._Text[Language=$session.system_language].RAPerfOblgnCategoryName AS RAPerfOblgnCategoryName,
  PerformanceObligation.AccountingPrinciple AS AccountingPrinciple,
  PerformanceObligation.CompanyCode AS CompanyCode,
  PerformanceObligation.RevnAcctgPerfOblgnStatus AS RevnAcctgPerfOblgnStatus,
  PerformanceObligation.RAPerfOblgnIsResidual AS RAPerfOblgnIsResidual,
  PerformanceObligation.SalesDocumentCurrency AS SalesDocumentCurrency,
  PerformanceObligation.PerformanceObligationStartDate AS PerformanceObligationStartDate,
  PerformanceObligation.PerformanceObligationEndDate AS PerformanceObligationEndDate,
  PerformanceObligation.PerfOblgnIsSoftDeleted AS PerfOblgnIsSoftDeleted,
  cast( 0 as farr_to_be_ff_quantity ) AS PerfOblgnToBeFulfilledQuantity,
  PerformanceObligation.PerfOblgnEffectiveQuantityUnit AS PerfOblgnEffectiveQuantityUnit,
  PerformanceObligation.PerfOblgnFulfillmentType AS PerfOblgnFulfillmentType,
  PerformanceObligation.PerfOblgnEventType AS PerfOblgnEventType,
  PerformanceObligation.RevnAcctgSuspensionDate AS RevnAcctgSuspensionDate,
  PerformanceObligation.RevnAcctgSuspensionReason AS RevnAcctgSuspensionReason,
  PerformanceObligation.RAUnivRevnRecgnIntegType AS RAUnivRevnRecgnIntegType,
  PerformanceObligation.RAPerfOblgnAssetImpairmentDate AS RAPerfOblgnAssetImpairmentDate,
  PerformanceObligation.RAPerfOblgnHasAssetImpairment AS RAPerfOblgnHasAssetImpairment,
  PerformanceObligation._AccountingPrinciple AS _AccountingPrinciple,
  PerformanceObligation._CompanyCode AS _CompanyCode,
  PerformanceObligation._RAPerfOblgnCategory AS _RAPerfOblgnCategory,
  PerformanceObligation._PerfOblgnDistinctType AS _PerfOblgnDistinctType,
  PerformanceObligation._PerfOblgnEffectiveQtyUnit AS _PerfOblgnEffectiveQtyUnit,
  PerformanceObligation._FulfillmentType AS _FulfillmentType,
  PerformanceObligation._PerfObligationEventType AS _PerfObligationEventType
FROM I_RAPerformanceObligation AS PerformanceObligation
LEFT OUTER JOIN P_RACompoundMnllyAllcdPrc AS _CompoundMnllyAllcdPrc ON PerformanceObligation = _CompoundMnllyAllcdPrc.PerformanceObligation AND RevenueAccountingContract = _CompoundMnllyAllcdPrc.RevenueAccountingContract  -- association [1..1]
LEFT OUTER JOIN I_RAPerfOblgnMnllyChgdAttrib AS _ManualChange ON PerformanceObligation = _ManualChange.PerformanceObligation AND _ManualChange.RAManuallyChangedAttribute = 'ALLOC_AMT'  -- association [1..1]
LEFT OUTER JOIN I_RAPerfOblgnStatusText AS _RAPerfOblgnStatusText ON RevnAcctgPerfOblgnStatus = _RAPerfOblgnStatusText.RevnAcctgPerfOblgnStatus  -- association [1..*]
LEFT OUTER JOIN I_RAUnivRevnRecgnIntegTypeText AS _RAUnivRevnRecgnIntegTypeText ON RAUnivRevnRecgnIntegType = _RAUnivRevnRecgnIntegTypeText.RAUnivRevnRecgnIntegType  -- association [1..*]
LEFT OUTER JOIN I_RASuspensionReasonText AS _RASuspensionReasonText ON RevnAcctgSuspensionReason = _RASuspensionReasonText.RevnAcctgSuspensionReason  -- association [0..*]
;

Learn More