P_RAChgTypeItemWithSplitData

DDL: P_RACHGTYPEITEMWITHSPLITDATA Type: view_entity COMPOSITE Package: ODATA_FARR_ALLOC_AMT_EXPLAIN
24 Fields 1 Data Sources 2 Associations

RA Change Type Item With Split Data

P_RAChgTypeItemWithSplitData is a Composite CDS View that provides data about "RA Change Type Item With Split Data" in SAP S/4HANA. It reads from 1 data source (I_RAPerfOblgnChangeTypeItem) and exposes 24 fields with key fields PerformanceObligation, RevenueAccountingContract, RevnAcctgReconciliationKey, RevnAcctgContrChangeEffctvDate. It has 2 associations to related views. Part of development package ODATA_FARR_ALLOC_AMT_EXPLAIN.

Data Sources (1)

SourceAliasJoin Type
I_RAPerfOblgnChangeTypeItem ChangeTypeItemWithRecnclnKey from

Associations (2)

CardinalityTargetAliasCondition
[1..1] P_RAHighLvlSplitRevnPerProKey SplitRevenue $projection.PerformanceObligation = SplitRevenue.RAHigherLevelPerfOblgn and $projection.RevenueAccountingContract = SplitRevenue.RevenueAccountingContract and $projection.RevnAcctgReconciliationKey = SplitRevenue.RevnAcctgReconciliationKey
[1..1] P_RASplitQtyPerProRecnclnKey SplitQuantity $projection.PerformanceObligation = SplitQuantity.PerformanceObligation and $projection.RevenueAccountingContract = SplitQuantity.RevenueAccountingContract and $projection.RevnAcctgReconciliationKey = SplitQuantity.RevnAcctgReconciliationKey

Annotations (3)

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

Fields (24)

KeyFieldSource TableSource FieldDescription
KEY PerformanceObligation I_RAPerfOblgnChangeTypeItem PerformanceObligation Performance Obligation
KEY RevenueAccountingContract I_RAPerfOblgnChangeTypeItem RevenueAccountingContract Revenue Contract
KEY RevnAcctgReconciliationKey I_RAPerfOblgnChangeTypeItem RevnAcctgReconciliationKey Reconcil. Key
KEY RevnAcctgContrChangeEffctvDate RevnAcctgContrChangeEffctvDate Validity Date
RAPerfOblgnChangeType RAPerfOblgnChangeType Change type
PerformanceObligationClass PerformanceObligationClass Performance Obligation Name
FiscalYearPeriod FiscalYearPeriod Period/Year
RAPerformanceObligationType RAPerformanceObligationType Performance Obligation Type
RABusinessChangeReason RABusinessChangeReason
RAPerfOblgnDistinctType RAPerfOblgnDistinctType Composition
ContractualPrcInSlsDocCrcy ContractualPrcInSlsDocCrcy Contractual Price
AllocatedPriceInSalesDocCrcy AllocatedPriceInSalesDocCrcy Allocated Amount
SSPriceInSalesDocCrcy SSPriceInSalesDocCrcy Standalone Selling Price
RATotalInterestAmtInSlsDocCrcy RATotalInterestAmtInSlsDocCrcy
SSPriceTolerancePercent SSPriceTolerancePercent SSP Tolerance Percentage
SSPriceToleranceAmount SSPriceToleranceAmount SSP Tolerance
SalesDocumentCurrency I_RAPerfOblgnChangeTypeItem SalesDocumentCurrency Currency
RAPerfOblgnIsResidual RAPerfOblgnIsResidual Residual Allocation
PerfOblgnIsExclFromPriceAlloc PerfOblgnIsExclFromPriceAlloc Excluded from Allocation
RAContractIsManuallyAllocated RAContractIsManuallyAllocated Price Allocated Manually
RAPerfOblgnFinalizationDate RAPerfOblgnFinalizationDate Finalizat. Date
PerfOblgnEffectiveQuantity PerfOblgnEffectiveQuantity Effective Quantity
PerfOblgnEffectiveQuantityUnit PerfOblgnEffectiveQuantityUnit Unit of Measure
RAChangeTypeChangeDateTime RAChangeTypeChangeDateTime

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_RAChgTypeItemWithSplitData.
-- 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_RAChgTypeItemWithSplitData AS
SELECT
  ChangeTypeItemWithRecnclnKey.PerformanceObligation AS PerformanceObligation,
  ChangeTypeItemWithRecnclnKey.RevenueAccountingContract AS RevenueAccountingContract,
  ChangeTypeItemWithRecnclnKey.RevnAcctgReconciliationKey AS RevnAcctgReconciliationKey,
  RevnAcctgContrChangeEffctvDate,
  RAPerfOblgnChangeType,
  PerformanceObligationClass,
  FiscalYearPeriod,
  RAPerformanceObligationType,
  RABusinessChangeReason,
  RAPerfOblgnDistinctType,
  ContractualPrcInSlsDocCrcy,
  AllocatedPriceInSalesDocCrcy,
  SSPriceInSalesDocCrcy,
  RATotalInterestAmtInSlsDocCrcy,
  SSPriceTolerancePercent,
  SSPriceToleranceAmount,
  ChangeTypeItemWithRecnclnKey.SalesDocumentCurrency AS SalesDocumentCurrency,
  RAPerfOblgnIsResidual,
  PerfOblgnIsExclFromPriceAlloc,
  RAContractIsManuallyAllocated,
  RAPerfOblgnFinalizationDate,
  PerfOblgnEffectiveQuantity,
  PerfOblgnEffectiveQuantityUnit,
  RAChangeTypeChangeDateTime
FROM I_RAPerfOblgnChangeTypeItem AS ChangeTypeItemWithRecnclnKey
LEFT OUTER JOIN P_RAHighLvlSplitRevnPerProKey AS SplitRevenue ON PerformanceObligation = SplitRevenue.RAHigherLevelPerfOblgn AND RevenueAccountingContract = SplitRevenue.RevenueAccountingContract AND RevnAcctgReconciliationKey = SplitRevenue.RevnAcctgReconciliationKey  -- association [1..1]
LEFT OUTER JOIN P_RASplitQtyPerProRecnclnKey AS SplitQuantity ON PerformanceObligation = SplitQuantity.PerformanceObligation AND RevenueAccountingContract = SplitQuantity.RevenueAccountingContract AND RevnAcctgReconciliationKey = SplitQuantity.RevnAcctgReconciliationKey  -- association [1..1]
;

Learn More