Deprecated
This CDS view is deprecated in S/4HANA. Use P_RAEffectiveChgTypeItemForHis instead. View all deprecated CDS views →

P_RAChgTypeItemWithReconclnKey

DDL: P_RACHGTYPEITEMWITHRECONCLNKEY Type: view_entity COMPOSITE
32 Fields 1 Data Sources

P_RAChgTypeItemWithReconclnKey is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_RAPerfOblgnChangeTypeItem) and exposes 32 fields with key fields PerformanceObligation, RevnAcctgContrChangeEffctvDate.

Data Sources (1)

SourceAliasJoin Type
I_RAPerfOblgnChangeTypeItem ChangeTypeItem inner

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.lifecycle.status #DEPRECATED view
VDM.lifecycle.successor P_RAEffectiveChgTypeItemForHis view
VDM.private true view
VDM.viewType #COMPOSITE view

Fields (32)

KeyFieldSource TableSource FieldDescription
KEY PerformanceObligation ChgTypeItemDstctEffctvDate PerformanceObligation Performance Obligation
KEY RevnAcctgContrChangeEffctvDate
RevenueAccountingContract I_RAPerfOblgnChangeTypeItem RevenueAccountingContract Revenue Contract
PerformanceObligationClass I_RAPerfOblgnChangeTypeItem PerformanceObligationClass Performance Obligation Name
RAPerfOblgnChangeType I_RAPerfOblgnChangeTypeItem RAPerfOblgnChangeType Change type
FiscalYearPeriod I_RAPerfOblgnChangeTypeItem FiscalYearPeriod Period/Year
RAPerformanceObligationType I_RAPerfOblgnChangeTypeItem RAPerformanceObligationType Performance Obligation Type
SSPriceInSalesDocCrcy I_RAPerfOblgnChangeTypeItem SSPriceInSalesDocCrcy Standalone Selling Price
SSPriceTolerancePercent I_RAPerfOblgnChangeTypeItem SSPriceTolerancePercent SSP Tolerance Percentage
SSPriceToleranceAmount I_RAPerfOblgnChangeTypeItem SSPriceToleranceAmount SSP Tolerance
AllocatedPriceInSalesDocCrcy I_RAPerfOblgnChangeTypeItem AllocatedPriceInSalesDocCrcy Allocated Amount
ContractualPrcInSlsDocCrcy I_RAPerfOblgnChangeTypeItem ContractualPrcInSlsDocCrcy Contractual Price
OplContractualPrcInSlsDocCrcy I_RAPerfOblgnChangeTypeItem OplContractualPrcInSlsDocCrcy
SalesDocumentCurrency I_RAPerfOblgnChangeTypeItem SalesDocumentCurrency Currency
PerformanceObligationStartDate I_RAPerfOblgnChangeTypeItem PerformanceObligationStartDate Start Date
PerformanceObligationEndDate I_RAPerfOblgnChangeTypeItem PerformanceObligationEndDate End Date
PerfOblgnFulfillmentType I_RAPerfOblgnChangeTypeItem PerfOblgnFulfillmentType Fulfillment Type
PerfObligationDeferralMethod I_RAPerfOblgnChangeTypeItem PerfObligationDeferralMethod Deferral Method
PerfOblgnContractualQuantity I_RAPerfOblgnChangeTypeItem PerfOblgnContractualQuantity Quantity
PerfOblgnContractualQtyUnit I_RAPerfOblgnChangeTypeItem PerfOblgnContractualQtyUnit Unit of Measure
PerfOblgnEffectiveQuantity I_RAPerfOblgnChangeTypeItem PerfOblgnEffectiveQuantity Effective Quantity
PerfOblgnEffectiveQuantityUnit I_RAPerfOblgnChangeTypeItem PerfOblgnEffectiveQuantityUnit Unit of Measure
RAPerfOblgnIsResidual I_RAPerfOblgnChangeTypeItem RAPerfOblgnIsResidual Residual Allocation
PerfOblgnIsExclFromPriceAlloc I_RAPerfOblgnChangeTypeItem PerfOblgnIsExclFromPriceAlloc Excluded from Allocation
PerfOblgnIsFinallyInvoiced I_RAPerfOblgnChangeTypeItem PerfOblgnIsFinallyInvoiced Final Invoice
PerfOblgnIsSoftDeleted I_RAPerfOblgnChangeTypeItem PerfOblgnIsSoftDeleted Soft Deleted
RAPerfOblgnFinalizationDate I_RAPerfOblgnChangeTypeItem RAPerfOblgnFinalizationDate Finalizat. Date
RABusinessChangeReason I_RAPerfOblgnChangeTypeItem RABusinessChangeReason
RAChangeTypeChangeDateTime I_RAPerfOblgnChangeTypeItem RAChangeTypeChangeDateTime
_Currency I_RAPerfOblgnChangeTypeItem _Currency
_PerfOblgnEffectiveQtyUnit I_RAPerfOblgnChangeTypeItem _PerfOblgnEffectiveQtyUnit
_PerfOblgnContractualQtyUnit I_RAPerfOblgnChangeTypeItem _PerfOblgnContractualQtyUnit

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_RAChgTypeItemWithReconclnKey.
-- 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_RAChgTypeItemWithReconclnKey AS
SELECT
  ChgTypeItemDstctEffctvDate.PerformanceObligation AS PerformanceObligation,
  cast(ChgTypeItemDstctEffctvDate.RevnAcctgContrChangeEffctvDate as farr_effective_date preserving type) AS RevnAcctgContrChangeEffctvDate,
  ChangeTypeItem.RevenueAccountingContract AS RevenueAccountingContract,
  ChangeTypeItem.PerformanceObligationClass AS PerformanceObligationClass,
  ChangeTypeItem.RAPerfOblgnChangeType AS RAPerfOblgnChangeType,
  ChangeTypeItem.FiscalYearPeriod AS FiscalYearPeriod,
  ChangeTypeItem.RAPerformanceObligationType AS RAPerformanceObligationType,
  ChangeTypeItem.SSPriceInSalesDocCrcy AS SSPriceInSalesDocCrcy,
  ChangeTypeItem.SSPriceTolerancePercent AS SSPriceTolerancePercent,
  ChangeTypeItem.SSPriceToleranceAmount AS SSPriceToleranceAmount,
  ChangeTypeItem.AllocatedPriceInSalesDocCrcy AS AllocatedPriceInSalesDocCrcy,
  ChangeTypeItem.ContractualPrcInSlsDocCrcy AS ContractualPrcInSlsDocCrcy,
  ChangeTypeItem.OplContractualPrcInSlsDocCrcy AS OplContractualPrcInSlsDocCrcy,
  ChangeTypeItem.SalesDocumentCurrency AS SalesDocumentCurrency,
  ChangeTypeItem.PerformanceObligationStartDate AS PerformanceObligationStartDate,
  ChangeTypeItem.PerformanceObligationEndDate AS PerformanceObligationEndDate,
  ChangeTypeItem.PerfOblgnFulfillmentType AS PerfOblgnFulfillmentType,
  ChangeTypeItem.PerfObligationDeferralMethod AS PerfObligationDeferralMethod,
  ChangeTypeItem.PerfOblgnContractualQuantity AS PerfOblgnContractualQuantity,
  ChangeTypeItem.PerfOblgnContractualQtyUnit AS PerfOblgnContractualQtyUnit,
  ChangeTypeItem.PerfOblgnEffectiveQuantity AS PerfOblgnEffectiveQuantity,
  ChangeTypeItem.PerfOblgnEffectiveQuantityUnit AS PerfOblgnEffectiveQuantityUnit,
  ChangeTypeItem.RAPerfOblgnIsResidual AS RAPerfOblgnIsResidual,
  ChangeTypeItem.PerfOblgnIsExclFromPriceAlloc AS PerfOblgnIsExclFromPriceAlloc,
  ChangeTypeItem.PerfOblgnIsFinallyInvoiced AS PerfOblgnIsFinallyInvoiced,
  ChangeTypeItem.PerfOblgnIsSoftDeleted AS PerfOblgnIsSoftDeleted,
  ChangeTypeItem.RAPerfOblgnFinalizationDate AS RAPerfOblgnFinalizationDate,
  ChangeTypeItem.RABusinessChangeReason AS RABusinessChangeReason,
  ChangeTypeItem.RAChangeTypeChangeDateTime AS RAChangeTypeChangeDateTime,
  ChangeTypeItem._Currency AS _Currency,
  ChangeTypeItem._PerfOblgnEffectiveQtyUnit AS _PerfOblgnEffectiveQtyUnit,
  ChangeTypeItem._PerfOblgnContractualQtyUnit AS _PerfOblgnContractualQtyUnit
INNER JOIN I_RAPerfOblgnChangeTypeItem AS ChangeTypeItem ON /* join condition not captured in parsed metadata */
;

Learn More