P_RAContractWithPerfOblgnStdVH

DDL: P_RACONTRACTWITHPERFOBLGNSTDVH Type: view_entity COMPOSITE Package: FARR_CONTRACT_CDS
66 Fields 2 Data Sources

RA Contract Standard Value Help

P_RAContractWithPerfOblgnStdVH is a Composite CDS View that provides data about "RA Contract Standard Value Help" in SAP S/4HANA. It reads from 2 data sources (I_RevenueAccountingContract, I_RAPerformanceObligation) and exposes 66 fields with key fields RevenueAccountingContract, AccountingPrinciple, PerformanceObligation, AccountingPrinciple, PerformanceObligation. Part of development package FARR_CONTRACT_CDS.

Data Sources (2)

SourceAliasJoin Type
I_RevenueAccountingContract _RevenueAccountingContract union
I_RAPerformanceObligation I_RAPerformanceObligation from

Annotations (4)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
VDM.private true view
VDM.viewType #COMPOSITE view

Fields (66)

KeyFieldSource TableSource FieldDescription
KEY RevenueAccountingContract RevenueAccountingContract Revenue Contract
KEY AccountingPrinciple AccountingPrinciple AP Ledger/CoCode
KEY PerformanceObligation PerformanceObligation Performance Obligation
PerformanceObligationClass PerformanceObligationClass Performance Obligation Name
RAPerformanceObligationType RAPerformanceObligationType Performance Obligation Type
RevnAcctgOperationalDocument
Customer Customer Sold-to Party
BusinessPartner BusinessPartner Issuing Authority
RevnAcctgSalesOrganization RevnAcctgSalesOrganization Sales Org.
PerfOblgnFulfillmentType PerfOblgnFulfillmentType Fulfillment Type
PerfOblgnFulfillmentTypeName
PerfOblgnEventType PerfOblgnEventType Event Type
PerfOblgnEventTypeText
RAPerfOblgnDistinctType RAPerfOblgnDistinctType Composition
RAPerfOblgnDistinctTypeName
PerformanceObligationRole PerformanceObligationRole Performance Obligation Role
PerformanceObligationRoleName
RAFulfillmentIsValueBased RAFulfillmentIsValueBased Fulfillments Based on Values
PerfOblgnIsFinallyInvoiced PerfOblgnIsFinallyInvoiced Final Invoice
FunctionalArea FunctionalArea Sendr Fctl Area
BusinessArea BusinessArea Business Area
ProfitCenter ProfitCenter Profit Center
Segment Segment Segment number
CostCenter CostCenter Cost Center
OrderID OrderID Order ID
WBSElementExternalID WBSElementExternalID WBS Element External ID
RAPerfOblgnFinalizationDate RAPerfOblgnFinalizationDate Finalizat. Date
RAPerfOblgnIsCostRecognizable RAPerfOblgnIsCostRecognizable Cost Recognition
CompanyCode CompanyCode Receiver Company Code
RAPerfOblgnCategory RAPerfOblgnCategory Performance Obligation Category
RAPerfOblgnCategoryName
IsBusinessPurposeCompleted Purpose Completed
RevenueAccountingContract Revenue Contract
KEY AccountingPrinciple I_RevenueAccountingContract AccountingPrinciple AP Ledger/CoCode
KEY PerformanceObligation Performance Obligation
PerformanceObligationClass Performance Obligation Name
RAPerformanceObligationType Performance Obligation Type
RevnAcctgOperationalDocument
Customer I_RevenueAccountingContract Customer Sold-to Party
BusinessPartner I_RevenueAccountingContract BusinessPartner Issuing Authority
RevnAcctgSalesOrganization I_RevenueAccountingContract RevnAcctgSalesOrganization Sales Org.
PerfOblgnFulfillmentType Fulfillment Type
PerfOblgnFulfillmentTypeName
PerfOblgnEventType Event Type
PerfOblgnEventTypeText
RAPerfOblgnDistinctType Composition
RAPerfOblgnDistinctTypeName
PerformanceObligationRole Performance Obligation Role
PerformanceObligationRoleName
RAFulfillmentIsValueBased Fulfillments Based on Values
PerfOblgnIsFinallyInvoiced Final Invoice
FunctionalArea Sendr Fctl Area
BusinessArea Business Area
ProfitCenter Profit Center
Segment Segment number
CostCenter Cost Center
OrderID Order ID
WBSElementExternalID WBS Element External ID
ProfitabilitySegment
RAPerfOblgnFinalizationDate Finalizat. Date
RAPerfOblgnIsCostRecognizable Cost Recognition
CompanyCode I_RevenueAccountingContract CompanyCode Receiver Company Code
RAPerfOblgnCategory Performance Obligation Category
RAPerfOblgnCategoryName
IsBusinessPurposeCompleted I_RevenueAccountingContract IsBusinessPurposeCompleted Purpose Completed
RAContractIsUniversal I_RevenueAccountingContract RAContractIsUniversal Universal Rev Contr

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 P_RAContractWithPerfOblgnStdVH.
-- 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 P_RAContractWithPerfOblgnStdVH AS
SELECT
  RevenueAccountingContract,
  AccountingPrinciple,
  PerformanceObligation,
  PerformanceObligationClass,
  RAPerformanceObligationType,
  I_RAPerformanceObligation._Mapping.RevnAcctgOperationalDocument AS RevnAcctgOperationalDocument,
  Customer,
  BusinessPartner,
  RevnAcctgSalesOrganization,
  PerfOblgnFulfillmentType,
  _FulfillmentType._Text[1: Language = $session.system_language].PerfOblgnFulfillmentTypeName AS PerfOblgnFulfillmentTypeName,
  PerfOblgnEventType,
  _PerfObligationEventType._Text[1: Language = $session.system_language].PerfOblgnEventTypeText AS PerfOblgnEventTypeText,
  RAPerfOblgnDistinctType,
  _PerfOblgnDistinctType._Text[1: Language = $session.system_language].RAPerfOblgnDistinctTypeName AS RAPerfOblgnDistinctTypeName,
  PerformanceObligationRole,
  _PerformanceObligationRole._Text[1: Language = $session.system_language].PerformanceObligationRoleName AS PerformanceObligationRoleName,
  RAFulfillmentIsValueBased,
  PerfOblgnIsFinallyInvoiced,
  FunctionalArea,
  BusinessArea,
  ProfitCenter,
  Segment,
  CostCenter,
  OrderID,
  WBSElementExternalID,
  RAPerfOblgnFinalizationDate,
  RAPerfOblgnIsCostRecognizable,
  CompanyCode,
  RAPerfOblgnCategory,
  _RAPerfOblgnCategory._Text[1: Language = $session.system_language].RAPerfOblgnCategoryName AS RAPerfOblgnCategoryName,
  I_RAPerformanceObligation._RevenueAccountingContract.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted,
  cast('' as farr_profit_segment_num) AS ProfitabilitySegment,
  _RevenueAccountingContract.RAContractIsUniversal AS RAContractIsUniversal
FROM I_RAPerformanceObligation
-- UNION with additional select branch(es): I_RevenueAccountingContract
;

Learn More