P_RAChangeTypeItemChangeHist

DDL: P_RACHANGETYPEITEMCHANGEHIST Type: view_entity COMPOSITE Package: ODATA_FARR_ALLOC_AMT_EXPLAIN

RA Change Type Item Change History

P_RAChangeTypeItemChangeHist is a Composite CDS View that provides data about "RA Change Type Item Change History" in SAP S/4HANA. It reads from 1 data source (I_RAPerfOblgnChangeTypeItem) and exposes 59 fields with key fields PerformanceObligation, RACurrentContrChangeEffctvDate, RACurrentContrChangeEffctvDate. Part of development package ODATA_FARR_ALLOC_AMT_EXPLAIN.

Data Sources (1)

SourceAliasJoin Type
I_RAPerfOblgnChangeTypeItem I_RAPerfOblgnChangeTypeItem from

Annotations (4)

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

Fields (59)

KeyFieldSource TableSource FieldDescription
KEY PerformanceObligation PerformanceObligation Performance Obligation
KEY RACurrentContrChangeEffctvDate RevnAcctgContrChangeEffctvDate
RevnAcctgContrChangeEffctvDate RevnAcctgContrChangeEffctvDate Validity Date
RevenueAccountingContract RevenueAccountingContract Revenue Contract
OriglRevenueAccountingContract RevenueAccountingContract
PerformanceObligationClass PerformanceObligationClass Performance Obligation Name
RAPerfOblgnDistinctType RAPerfOblgnDistinctType Composition
ValidRAHigherLevelPerfOblgn RAHigherLevelPerfOblgn Higher-Level POB
SSPriceInSalesDocCrcy SSPriceInSalesDocCrcy Standalone Selling Price
SSPriceTolerancePercent SSPriceTolerancePercent SSP Tolerance Percentage
SSPriceToleranceAmount SSPriceToleranceAmount SSP Tolerance
AllocatedPriceInSalesDocCrcy AllocatedPriceInSalesDocCrcy Allocated Amount
ContractualPrcInSlsDocCrcy ContractualPrcInSlsDocCrcy Contractual Price
OplContractualPrcInSlsDocCrcy OplContractualPrcInSlsDocCrcy
SalesDocumentCurrency SalesDocumentCurrency Currency
PerformanceObligationStartDate PerformanceObligationStartDate Start Date
PerformanceObligationEndDate PerformanceObligationEndDate End Date
PerfOblgnFulfillmentType PerfOblgnFulfillmentType Fulfillment Type
PerfObligationDeferralMethod PerfObligationDeferralMethod Deferral Method
PerfOblgnContractualQuantity PerfOblgnContractualQuantity Quantity
PerfOblgnContractualQtyUnit PerfOblgnContractualQtyUnit Unit of Measure
PerfOblgnEffectiveQuantity PerfOblgnEffectiveQuantity Effective Quantity
PerfOblgnEffectiveQuantityUnit PerfOblgnEffectiveQuantityUnit Unit of Measure
RAPerfOblgnIsResidual RAPerfOblgnIsResidual Residual Allocation
PerfOblgnIsExclFromPriceAlloc PerfOblgnIsExclFromPriceAlloc Excluded from Allocation
RAContractIsManuallyAllocated RAContractIsManuallyAllocated Price Allocated Manually
PerfOblgnIsFinallyInvoiced PerfOblgnIsFinallyInvoiced Final Invoice
PerfOblgnIsSoftDeleted PerfOblgnIsSoftDeleted Soft Deleted
RAPerfOblgnFinalizationDate RAPerfOblgnFinalizationDate Finalizat. Date
KEY RACurrentContrChangeEffctvDate CurChgTypeItemEffectvDate
RevnAcctgContrChangeEffctvDate RevnAcctgContrChangeEffctvDate Validity Date
RevenueAccountingContract RevenueAccountingContract Revenue Contract
OriglRevenueAccountingContract OriglRevenueAccountingContract
PerformanceObligationClass PerformanceObligationClass Performance Obligation Name
RAPerfOblgnDistinctType RAPerfOblgnDistinctType Composition
RAHigherLevelPerfOblgn CurHigherLevelPerfOblgn
ValidRAHigherLevelPerfOblgn RAHigherLevelPerfOblgn Higher-Level POB
SSPriceInSalesDocCrcy SSPriceInSalesDocCrcy Standalone Selling Price
SSPriceTolerancePercent SSPriceTolerancePercent SSP Tolerance Percentage
SSPriceToleranceAmount SSPriceToleranceAmount SSP Tolerance
AllocatedPriceInSalesDocCrcy AllocatedPriceInSalesDocCrcy Allocated Amount
ContractualPrcInSlsDocCrcy ContractualPrcInSlsDocCrcy Contractual Price
OplContractualPrcInSlsDocCrcy OplContractualPrcInSlsDocCrcy
SalesDocumentCurrency SalesDocumentCurrency Currency
PerformanceObligationStartDate PerformanceObligationStartDate Start Date
PerformanceObligationEndDate PerformanceObligationEndDate End Date
PerfOblgnFulfillmentType PerfOblgnFulfillmentType Fulfillment Type
PerfObligationDeferralMethod PerfObligationDeferralMethod Deferral Method
PerfOblgnContractualQuantity PerfOblgnContractualQuantity Quantity
PerfOblgnContractualQtyUnit PerfOblgnContractualQtyUnit Unit of Measure
PerfOblgnEffectiveQuantity PerfOblgnEffectiveQuantity Effective Quantity
PerfOblgnEffectiveQuantityUnit PerfOblgnEffectiveQuantityUnit Unit of Measure
RAPerfOblgnIsResidual RAPerfOblgnIsResidual Residual Allocation
PerfOblgnIsExclFromPriceAlloc PerfOblgnIsExclFromPriceAlloc Excluded from Allocation
RAContractIsManuallyAllocated RAContractIsManuallyAllocated Price Allocated Manually
PerfOblgnIsFinallyInvoiced PerfOblgnIsFinallyInvoiced Final Invoice
PerfOblgnIsSoftDeleted PerfOblgnIsSoftDeleted Soft Deleted
RAPerfOblgnFinalizationDate RAPerfOblgnFinalizationDate Finalizat. Date
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_RAChangeTypeItemChangeHist.
-- 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_RAChangeTypeItemChangeHist AS
SELECT
  PerformanceObligation,
  RevnAcctgContrChangeEffctvDate AS RACurrentContrChangeEffctvDate,
  RevnAcctgContrChangeEffctvDate,
  RevenueAccountingContract,
  RevenueAccountingContract AS OriglRevenueAccountingContract,
  PerformanceObligationClass,
  RAPerfOblgnDistinctType,
  RAHigherLevelPerfOblgn AS ValidRAHigherLevelPerfOblgn,
  SSPriceInSalesDocCrcy,
  SSPriceTolerancePercent,
  SSPriceToleranceAmount,
  AllocatedPriceInSalesDocCrcy,
  ContractualPrcInSlsDocCrcy,
  OplContractualPrcInSlsDocCrcy,
  SalesDocumentCurrency,
  PerformanceObligationStartDate,
  PerformanceObligationEndDate,
  PerfOblgnFulfillmentType,
  PerfObligationDeferralMethod,
  PerfOblgnContractualQuantity,
  PerfOblgnContractualQtyUnit,
  PerfOblgnEffectiveQuantity,
  PerfOblgnEffectiveQuantityUnit,
  RAPerfOblgnIsResidual,
  PerfOblgnIsExclFromPriceAlloc,
  RAContractIsManuallyAllocated,
  PerfOblgnIsFinallyInvoiced,
  PerfOblgnIsSoftDeleted,
  RAPerfOblgnFinalizationDate,
  CurHigherLevelPerfOblgn AS RAHigherLevelPerfOblgn,
  RAChangeTypeChangeDateTime
FROM I_RAPerfOblgnChangeTypeItem
;