P_RACatchUpChangeTypeItem

DDL: P_RACATCHUPCHANGETYPEITEM Type: view_entity COMPOSITE Package: ODATA_FARR_REV_CATCHUP

116C: Change Type Item

P_RACatchUpChangeTypeItem is a Composite CDS View that provides data about "116C: Change Type Item" in SAP S/4HANA. It reads from 1 data source (I_RAPerfOblgnChangeTypeItem) and exposes 23 fields with key fields PerformanceObligation, RevenueAccountingContract, RevnAcctgContrChangeEffctvDate, RevnAcctgReconciliationKey. Part of development package ODATA_FARR_REV_CATCHUP.

Data Sources (1)

SourceAliasJoin Type
I_RAPerfOblgnChangeTypeItem _RAPerfOblgnChangeTypeItem from

Annotations (3)

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

Fields (23)

KeyFieldSource TableSource FieldDescription
KEY PerformanceObligation I_RAPerfOblgnChangeTypeItem PerformanceObligation Performance Obligation
KEY RevenueAccountingContract
KEY RevnAcctgContrChangeEffctvDate I_RAPerfOblgnChangeTypeItem RevnAcctgContrChangeEffctvDate Validity Date
KEY RevnAcctgReconciliationKey I_RAPerfOblgnChangeTypeItem RevnAcctgReconciliationKey Reconcil. Key
RAHigherLevelPerfOblgn I_RAPerfOblgnChangeTypeItem RAHigherLevelPerfOblgn Higher-Level POB
CompanyCode
AccountingPrinciple
RevenueAccountingContractT
FiscalYear I_RAPerfOblgnChangeTypeItem FiscalYear G/L Fiscal Year
FiscalPeriod I_RAPerfOblgnChangeTypeItem FiscalPeriod Tax period
FiscalYearPeriod I_RAPerfOblgnChangeTypeItem FiscalYearPeriod Period/Year
RAPerfOblgnChangeType I_RAPerfOblgnChangeTypeItem RAPerfOblgnChangeType Change type
RAPerformanceObligationType I_RAPerfOblgnChangeTypeItem RAPerformanceObligationType Performance Obligation Type
PerfOblgnFulfillmentType I_RAPerfOblgnChangeTypeItem PerfOblgnFulfillmentType Fulfillment Type
RAPerfOblgnDistinctType I_RAPerfOblgnChangeTypeItem RAPerfOblgnDistinctType Composition
PerfOblgnIsFinallyInvoiced I_RAPerfOblgnChangeTypeItem PerfOblgnIsFinallyInvoiced Final Invoice
RAPerfOblgnFinalizationDate I_RAPerfOblgnChangeTypeItem RAPerfOblgnFinalizationDate Finalizat. Date
SalesDocumentCurrency I_RAPerfOblgnChangeTypeItem SalesDocumentCurrency Currency
PerfOblgnEffectiveQuantityUnit I_RAPerfOblgnChangeTypeItem PerfOblgnEffectiveQuantityUnit Unit of Measure
SSPriceInSalesDocCrcy I_RAPerfOblgnChangeTypeItem SSPriceInSalesDocCrcy Standalone Selling Price
AllocatedPriceInSalesDocCrcy I_RAPerfOblgnChangeTypeItem AllocatedPriceInSalesDocCrcy Allocated Amount
ContractualPrcInSlsDocCrcy I_RAPerfOblgnChangeTypeItem ContractualPrcInSlsDocCrcy Contractual Price
PerfOblgnEffectiveQuantity I_RAPerfOblgnChangeTypeItem PerfOblgnEffectiveQuantity Effective Quantity

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_RACatchUpChangeTypeItem.
-- 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_RACatchUpChangeTypeItem AS
SELECT
  _RAPerfOblgnChangeTypeItem.PerformanceObligation AS PerformanceObligation,
  _RAPerfOblgnChangeTypeItem._PerfOblgn.RevenueAccountingContract AS RevenueAccountingContract,
  _RAPerfOblgnChangeTypeItem.RevnAcctgContrChangeEffctvDate AS RevnAcctgContrChangeEffctvDate,
  _RAPerfOblgnChangeTypeItem.RevnAcctgReconciliationKey AS RevnAcctgReconciliationKey,
  _RAPerfOblgnChangeTypeItem.RAHigherLevelPerfOblgn AS RAHigherLevelPerfOblgn,
  _RAPerfOblgnChangeTypeItem._PerfOblgn.CompanyCode AS CompanyCode,
  _RAPerfOblgnChangeTypeItem._PerfOblgn.AccountingPrinciple AS AccountingPrinciple,
  _RAPerfOblgnChangeTypeItem._PerfOblgn.RevenueAccountingContract AS RevenueAccountingContractT,
  _RAPerfOblgnChangeTypeItem.FiscalYear AS FiscalYear,
  _RAPerfOblgnChangeTypeItem.FiscalPeriod AS FiscalPeriod,
  _RAPerfOblgnChangeTypeItem.FiscalYearPeriod AS FiscalYearPeriod,
  _RAPerfOblgnChangeTypeItem.RAPerfOblgnChangeType AS RAPerfOblgnChangeType,
  _RAPerfOblgnChangeTypeItem.RAPerformanceObligationType AS RAPerformanceObligationType,
  _RAPerfOblgnChangeTypeItem.PerfOblgnFulfillmentType AS PerfOblgnFulfillmentType,
  _RAPerfOblgnChangeTypeItem.RAPerfOblgnDistinctType AS RAPerfOblgnDistinctType,
  _RAPerfOblgnChangeTypeItem.PerfOblgnIsFinallyInvoiced AS PerfOblgnIsFinallyInvoiced,
  _RAPerfOblgnChangeTypeItem.RAPerfOblgnFinalizationDate AS RAPerfOblgnFinalizationDate,
  _RAPerfOblgnChangeTypeItem.SalesDocumentCurrency AS SalesDocumentCurrency,
  _RAPerfOblgnChangeTypeItem.PerfOblgnEffectiveQuantityUnit AS PerfOblgnEffectiveQuantityUnit,
  _RAPerfOblgnChangeTypeItem.SSPriceInSalesDocCrcy AS SSPriceInSalesDocCrcy,
  _RAPerfOblgnChangeTypeItem.AllocatedPriceInSalesDocCrcy AS AllocatedPriceInSalesDocCrcy,
  _RAPerfOblgnChangeTypeItem.ContractualPrcInSlsDocCrcy AS ContractualPrcInSlsDocCrcy,
  _RAPerfOblgnChangeTypeItem.PerfOblgnEffectiveQuantity AS PerfOblgnEffectiveQuantity
FROM I_RAPerfOblgnChangeTypeItem AS _RAPerfOblgnChangeTypeItem
;