P_RAPriceAllocReltdChgTypeData

DDL: P_RAPRICEALLOCRELTDCHGTYPEDATA Type: view_entity COMPOSITE
24 Fields 1 Data Sources

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

Data Sources (1)

SourceAliasJoin Type
P_RAChgTypeItemWithSplitData ExtendedChangeTypeItem from

Annotations (3)

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

Fields (24)

KeyFieldSource TableSource FieldDescription
KEY PerformanceObligation P_RAChgTypeItemWithSplitData PerformanceObligation Performance Obligation
KEY RevenueAccountingContract P_RAChgTypeItemWithSplitData RevenueAccountingContract Revenue Contract
KEY RevnAcctgContrChangeEffctvDate P_RAChgTypeItemWithSplitData RevnAcctgContrChangeEffctvDate
RevnAcctgReconciliationKey P_RAChgTypeItemWithSplitData RevnAcctgReconciliationKey
RAPerfOblgnChangeType P_RAChgTypeItemWithSplitData RAPerfOblgnChangeType
RAPrevContrChangeEffctvDate PreviousChangeTypeItem RevnAcctgContrChangeEffctvDate
PerformanceObligationClass P_RAChgTypeItemWithSplitData PerformanceObligationClass Performance Obligation Name
FiscalYearPeriod P_RAChgTypeItemWithSplitData FiscalYearPeriod Period/Year
RABusinessChangeReason P_RAChgTypeItemWithSplitData RABusinessChangeReason
RAPerfOblgnDistinctType P_RAChgTypeItemWithSplitData RAPerfOblgnDistinctType Composition
ContractualPrcInSlsDocCrcy P_RAChgTypeItemWithSplitData ContractualPrcInSlsDocCrcy Contractual Price
AllocatedPriceInSalesDocCrcy P_RAChgTypeItemWithSplitData AllocatedPriceInSalesDocCrcy Allocated Amount
SSPriceInSalesDocCrcy P_RAChgTypeItemWithSplitData SSPriceInSalesDocCrcy Standalone Selling Price
SSPriceTolerancePercent P_RAChgTypeItemWithSplitData SSPriceTolerancePercent SSP Tolerance Percentage
SSPriceToleranceAmount P_RAChgTypeItemWithSplitData SSPriceToleranceAmount SSP Tolerance
SalesDocumentCurrency P_RAChgTypeItemWithSplitData SalesDocumentCurrency Currency
RAPerfOblgnIsResidual P_RAChgTypeItemWithSplitData RAPerfOblgnIsResidual Residual Allocation
PerfOblgnIsExclFromPriceAlloc P_RAChgTypeItemWithSplitData PerfOblgnIsExclFromPriceAlloc Excluded from Allocation
RAContractIsManuallyAllocated P_RAChgTypeItemWithSplitData RAContractIsManuallyAllocated Price Allocated Manually
PerfOblgnEffectiveQuantity P_RAChgTypeItemWithSplitData PerfOblgnEffectiveQuantity Effective Quantity
PerfOblgnEffectiveQuantityUnit P_RAChgTypeItemWithSplitData PerfOblgnEffectiveQuantityUnit Unit of Measure
RAPerfOblgnFinalizationDate P_RAChgTypeItemWithSplitData RAPerfOblgnFinalizationDate Finalizat. Date
PrevRecognizedAmtInSlsDocCrcy P_RAChgTypeItemWithSplitData PrevRecognizedAmtInSlsDocCrcy
PerfOblgnPreviousFulfilledQty P_RAChgTypeItemWithSplitData PerfOblgnPreviousFulfilledQty

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_RAPriceAllocReltdChgTypeData.
-- 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_RAPriceAllocReltdChgTypeData AS
SELECT
  ExtendedChangeTypeItem.PerformanceObligation AS PerformanceObligation,
  ExtendedChangeTypeItem.RevenueAccountingContract AS RevenueAccountingContract,
  ExtendedChangeTypeItem.RevnAcctgContrChangeEffctvDate AS RevnAcctgContrChangeEffctvDate,
  ExtendedChangeTypeItem.RevnAcctgReconciliationKey AS RevnAcctgReconciliationKey,
  ExtendedChangeTypeItem.RAPerfOblgnChangeType AS RAPerfOblgnChangeType,
  PreviousChangeTypeItem.RevnAcctgContrChangeEffctvDate AS RAPrevContrChangeEffctvDate,
  ExtendedChangeTypeItem.PerformanceObligationClass AS PerformanceObligationClass,
  ExtendedChangeTypeItem.FiscalYearPeriod AS FiscalYearPeriod,
  ExtendedChangeTypeItem.RABusinessChangeReason AS RABusinessChangeReason,
  ExtendedChangeTypeItem.RAPerfOblgnDistinctType AS RAPerfOblgnDistinctType,
  ExtendedChangeTypeItem.ContractualPrcInSlsDocCrcy AS ContractualPrcInSlsDocCrcy,
  ExtendedChangeTypeItem.AllocatedPriceInSalesDocCrcy AS AllocatedPriceInSalesDocCrcy,
  ExtendedChangeTypeItem.SSPriceInSalesDocCrcy AS SSPriceInSalesDocCrcy,
  ExtendedChangeTypeItem.SSPriceTolerancePercent AS SSPriceTolerancePercent,
  ExtendedChangeTypeItem.SSPriceToleranceAmount AS SSPriceToleranceAmount,
  ExtendedChangeTypeItem.SalesDocumentCurrency AS SalesDocumentCurrency,
  ExtendedChangeTypeItem.RAPerfOblgnIsResidual AS RAPerfOblgnIsResidual,
  ExtendedChangeTypeItem.PerfOblgnIsExclFromPriceAlloc AS PerfOblgnIsExclFromPriceAlloc,
  ExtendedChangeTypeItem.RAContractIsManuallyAllocated AS RAContractIsManuallyAllocated,
  ExtendedChangeTypeItem.PerfOblgnEffectiveQuantity AS PerfOblgnEffectiveQuantity,
  ExtendedChangeTypeItem.PerfOblgnEffectiveQuantityUnit AS PerfOblgnEffectiveQuantityUnit,
  ExtendedChangeTypeItem.RAPerfOblgnFinalizationDate AS RAPerfOblgnFinalizationDate,
  ExtendedChangeTypeItem.PrevRecognizedAmtInSlsDocCrcy AS PrevRecognizedAmtInSlsDocCrcy,
  ExtendedChangeTypeItem.PerfOblgnPreviousFulfilledQty AS PerfOblgnPreviousFulfilledQty
FROM P_RAChgTypeItemWithSplitData AS ExtendedChangeTypeItem
;

Learn More