P_RAEffectiveChgTypeItems

DDL: P_RAEFFECTIVECHGTYPEITEMS Type: view_entity COMPOSITE
37 Fields 2 Data Sources

P_RAEffectiveChgTypeItems is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (I_RAPerfOblgnChangeTypeItem, P_RAChgTypePrevLtstRetroChange) and exposes 37 fields with key fields PerformanceObligation, RevnAcctgContrChangeEffctvDate, RevenueAccountingContract.

Data Sources (2)

SourceAliasJoin Type
I_RAPerfOblgnChangeTypeItem ChangeTypeItem from
P_RAChgTypePrevLtstRetroChange PreviousLatestRetroChange inner

Annotations (3)

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

Fields (37)

KeyFieldSource TableSource FieldDescription
KEY PerformanceObligation I_RAPerfOblgnChangeTypeItem PerformanceObligation Performance Obligation
KEY RevnAcctgContrChangeEffctvDate I_RAPerfOblgnChangeTypeItem RevnAcctgContrChangeEffctvDate Validity Date
KEY RevenueAccountingContract P_RAChgTypePrevLtstRetroChange RevenueAccountingContract Revenue Contract
OriginalContract I_RAPerfOblgnChangeTypeItem RevenueAccountingContract Revenue Contract
PerformanceObligationClass I_RAPerfOblgnChangeTypeItem PerformanceObligationClass Performance Obligation Name
RAPerfOblgnChangeType I_RAPerfOblgnChangeTypeItem RAPerfOblgnChangeType Change type
RevnAcctgReconciliationKey I_RAPerfOblgnChangeTypeItem RevnAcctgReconciliationKey Reconcil. Key
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
PerfOblgnFaceAmtInSlsDocCrcy I_RAPerfOblgnChangeTypeItem PerfOblgnFaceAmtInSlsDocCrcy Face Value
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
RAPerfOblgnDistinctType I_RAPerfOblgnChangeTypeItem RAPerfOblgnDistinctType Composition
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
RABusinessChangeReason I_RAPerfOblgnChangeTypeItem RABusinessChangeReason
RAChangeTypeChangeDateTime I_RAPerfOblgnChangeTypeItem RAChangeTypeChangeDateTime
RAChangeTypeCreationDateTime I_RAPerfOblgnChangeTypeItem RAChangeTypeCreationDateTime
_Currency I_RAPerfOblgnChangeTypeItem _Currency
_PerfOblgnEffectiveQtyUnit I_RAPerfOblgnChangeTypeItem _PerfOblgnEffectiveQtyUnit
_PerfOblgnContractualQtyUnit I_RAPerfOblgnChangeTypeItem _PerfOblgnContractualQtyUnit
RAPerfOblgnAssetImpairmentDate I_RAPerfOblgnChangeTypeItem RAPerfOblgnAssetImpairmentDate

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_RAEffectiveChgTypeItems.
-- 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_RAEffectiveChgTypeItems AS
SELECT
  ChangeTypeItem.PerformanceObligation AS PerformanceObligation,
  ChangeTypeItem.RevnAcctgContrChangeEffctvDate AS RevnAcctgContrChangeEffctvDate,
  PreviousLatestRetroChange.RevenueAccountingContract AS RevenueAccountingContract,
  ChangeTypeItem.RevenueAccountingContract AS OriginalContract,
  ChangeTypeItem.PerformanceObligationClass AS PerformanceObligationClass,
  ChangeTypeItem.RAPerfOblgnChangeType AS RAPerfOblgnChangeType,
  ChangeTypeItem.RevnAcctgReconciliationKey AS RevnAcctgReconciliationKey,
  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.PerfOblgnFaceAmtInSlsDocCrcy AS PerfOblgnFaceAmtInSlsDocCrcy,
  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.RAPerfOblgnDistinctType AS RAPerfOblgnDistinctType,
  ChangeTypeItem.RAPerfOblgnIsResidual AS RAPerfOblgnIsResidual,
  ChangeTypeItem.PerfOblgnIsExclFromPriceAlloc AS PerfOblgnIsExclFromPriceAlloc,
  ChangeTypeItem.PerfOblgnIsFinallyInvoiced AS PerfOblgnIsFinallyInvoiced,
  ChangeTypeItem.PerfOblgnIsSoftDeleted AS PerfOblgnIsSoftDeleted,
  ChangeTypeItem.RABusinessChangeReason AS RABusinessChangeReason,
  ChangeTypeItem.RAChangeTypeChangeDateTime AS RAChangeTypeChangeDateTime,
  ChangeTypeItem.RAChangeTypeCreationDateTime AS RAChangeTypeCreationDateTime,
  ChangeTypeItem._Currency AS _Currency,
  ChangeTypeItem._PerfOblgnEffectiveQtyUnit AS _PerfOblgnEffectiveQtyUnit,
  ChangeTypeItem._PerfOblgnContractualQtyUnit AS _PerfOblgnContractualQtyUnit,
  ChangeTypeItem.RAPerfOblgnAssetImpairmentDate AS RAPerfOblgnAssetImpairmentDate
FROM I_RAPerfOblgnChangeTypeItem AS ChangeTypeItem
INNER JOIN P_RAChgTypePrevLtstRetroChange AS PreviousLatestRetroChange ON /* join condition not captured in parsed metadata */
;

Learn More