C_RAChangeTypeItemChangeHist

DDL: C_RACHANGETYPEITEMCHANGEHIST Type: view_entity CONSUMPTION Package: ODATA_FARR_ALLOC_AMT_EXPLAIN
38 Fields 1 Data Sources 1 Associations 1 OData Services

RA Change Type Item Change History

C_RAChangeTypeItemChangeHist is a Consumption CDS View that provides data about "RA Change Type Item Change History" in SAP S/4HANA. It reads from 1 data source (I_RAChangeTypeItemChangeHist) and exposes 38 fields with key fields PerformanceObligation, RACurrentContrChangeEffctvDate, RevnAcctgContrChangeEffctvDate, ChangeDocDatabaseTableField. It has 1 association to related views. It is exposed through 1 OData service (ASQL_F4424). Part of development package ODATA_FARR_ALLOC_AMT_EXPLAIN.

Data Sources (1)

SourceAliasJoin Type
I_RAChangeTypeItemChangeHist I_RAChangeTypeItemChangeHist from

Associations (1)

CardinalityTargetAliasCondition
[1..1] E_RAPerfOblgnChangeTypeItem _E_RAPerfOblgnChangeTypeItem $projection.RevenueAccountingContract = _E_RAPerfOblgnChangeTypeItem.RevenueAccountingContract and $projection.PerformanceObligation = _E_RAPerfOblgnChangeTypeItem.PerformanceObligation and $projection.RevnAcctgContrChangeEffctvDate = _E_RAPerfOblgnChangeTypeItem.RevnAcctgContrChangeEffctvDate

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label RA Change Type Item Change History view
Metadata.allowExtensions true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #CONSUMPTION view

OData Services (1)

ServiceBindingVersionContractRelease
ASQL_F4424 ASQL_F4424 C2 NOT_RELEASED

Fields (38)

KeyFieldSource TableSource FieldDescription
KEY PerformanceObligation PerformanceObligation Performance Obligation
KEY RACurrentContrChangeEffctvDate RACurrentContrChangeEffctvDate
KEY RevnAcctgContrChangeEffctvDate RevnAcctgContrChangeEffctvDate
KEY ChangeDocDatabaseTableField ChangeDocDatabaseTableField
DatabaseTableFieldText DatabaseTableFieldText
RevenueAccountingContract RevenueAccountingContract Revenue Contract
OriglRevenueAccountingContract OriglRevenueAccountingContract
CompanyCode CompanyCode Receiver Company Code
PerformanceObligationClass PerformanceObligationClass Performance Obligation Name
RAPerfOblgnDistinctType RAPerfOblgnDistinctType Composition
RAPerfOblgnDistinctTypeName RAPerfOblgnDistinctTypeName
ValidRAHigherLevelPerfOblgn ValidRAHigherLevelPerfOblgn
RAHigherLevelPerfOblgn RAHigherLevelPerfOblgn Higher-Level POB
ChangeDocNewFieldValue ChangeDocNewFieldValue
ChangeDocPreviousFieldValue ChangeDocPreviousFieldValue
RAChangeTypeChangeDateTime RAChangeTypeChangeDateTime
SSPriceInSalesDocCrcy SSPriceInSalesDocCrcy Standalone Selling Price
SSPriceTolerancePercent SSPriceTolerancePercent SSP Tolerance Percentage
SSPriceToleranceAmount SSPriceToleranceAmount SSP Tolerance
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
PerfOblgnDeferralMethodText PerfOblgnDeferralMethodText
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
_DistinctTypeText _DistinctTypeText

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_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 C_RAChangeTypeItemChangeHist AS
SELECT
  PerformanceObligation,
  RACurrentContrChangeEffctvDate,
  RevnAcctgContrChangeEffctvDate,
  ChangeDocDatabaseTableField,
  DatabaseTableFieldText,
  RevenueAccountingContract,
  OriglRevenueAccountingContract,
  CompanyCode,
  PerformanceObligationClass,
  RAPerfOblgnDistinctType,
  RAPerfOblgnDistinctTypeName,
  ValidRAHigherLevelPerfOblgn,
  RAHigherLevelPerfOblgn,
  ChangeDocNewFieldValue,
  ChangeDocPreviousFieldValue,
  RAChangeTypeChangeDateTime,
  SSPriceInSalesDocCrcy,
  SSPriceTolerancePercent,
  SSPriceToleranceAmount,
  ContractualPrcInSlsDocCrcy,
  OplContractualPrcInSlsDocCrcy,
  SalesDocumentCurrency,
  PerformanceObligationStartDate,
  PerformanceObligationEndDate,
  PerfOblgnFulfillmentType,
  PerfObligationDeferralMethod,
  PerfOblgnDeferralMethodText,
  PerfOblgnContractualQuantity,
  PerfOblgnContractualQtyUnit,
  PerfOblgnEffectiveQuantity,
  PerfOblgnEffectiveQuantityUnit,
  RAPerfOblgnIsResidual,
  PerfOblgnIsExclFromPriceAlloc,
  RAContractIsManuallyAllocated,
  PerfOblgnIsFinallyInvoiced,
  PerfOblgnIsSoftDeleted,
  RAPerfOblgnFinalizationDate
FROM I_RAChangeTypeItemChangeHist
LEFT OUTER JOIN E_RAPerfOblgnChangeTypeItem AS _E_RAPerfOblgnChangeTypeItem ON RevenueAccountingContract = _E_RAPerfOblgnChangeTypeItem.RevenueAccountingContract AND PerformanceObligation = _E_RAPerfOblgnChangeTypeItem.PerformanceObligation AND RevnAcctgContrChangeEffctvDate = _E_RAPerfOblgnChangeTypeItem.RevnAcctgContrChangeEffctvDate  -- association [1..1]
;

Learn More