P_RAChgTypeItemWithKeyGroupId

DDL: P_RACHGTYPEITEMWITHKEYGROUPID Type: view_entity COMPOSITE
33 Fields 1 Data Sources

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

Data Sources (1)

SourceAliasJoin Type
I_RAPerfOblgnChangeTypeItem I_RAPerfOblgnChangeTypeItem from

Annotations (3)

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

Fields (33)

KeyFieldSource TableSource FieldDescription
KEY PerformanceObligation PerformanceObligation Performance Obligation
KEY RevenueAccountingContract RevenueAccountingContract Revenue Contract
KEY RevnAcctgContrChangeEffctvDate RevnAcctgContrChangeEffctvDate Validity Date
RevnAcctgReconciliationKey RevnAcctgReconciliationKey Reconcil. Key
RAChangeTypeChangeDateTime RAChangeTypeChangeDateTime
PerformanceObligationClass PerformanceObligationClass Performance Obligation Name
RAPerfOblgnChangeType RAPerfOblgnChangeType Change type
FiscalYearPeriod FiscalYearPeriod Period/Year
RAPerformanceObligationType RAPerformanceObligationType Performance Obligation Type
SSPriceInSalesDocCrcy SSPriceInSalesDocCrcy Standalone Selling Price
SSPriceTolerancePercent SSPriceTolerancePercent SSP Tolerance Percentage
SSPriceToleranceAmount SSPriceToleranceAmount SSP Tolerance
AllocatedPriceInSalesDocCrcy AllocatedPriceInSalesDocCrcy Allocated Amount
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
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
PerfOblgnIsFinallyInvoiced PerfOblgnIsFinallyInvoiced Final Invoice
PerfOblgnIsSoftDeleted PerfOblgnIsSoftDeleted Soft Deleted
RAPerfOblgnFinalizationDate RAPerfOblgnFinalizationDate Finalizat. Date
RABusinessChangeReason RABusinessChangeReason
_Currency _Currency
_PerfOblgnEffectiveQtyUnit _PerfOblgnEffectiveQtyUnit
_PerfOblgnContractualQtyUnit _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_RAChgTypeItemWithKeyGroupId.
-- 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_RAChgTypeItemWithKeyGroupId AS
SELECT
  PerformanceObligation,
  RevenueAccountingContract,
  RevnAcctgContrChangeEffctvDate,
  RevnAcctgReconciliationKey,
  RAChangeTypeChangeDateTime,
  PerformanceObligationClass,
  RAPerfOblgnChangeType,
  FiscalYearPeriod,
  RAPerformanceObligationType,
  SSPriceInSalesDocCrcy,
  SSPriceTolerancePercent,
  SSPriceToleranceAmount,
  AllocatedPriceInSalesDocCrcy,
  ContractualPrcInSlsDocCrcy,
  OplContractualPrcInSlsDocCrcy,
  SalesDocumentCurrency,
  PerformanceObligationStartDate,
  PerformanceObligationEndDate,
  PerfOblgnFulfillmentType,
  PerfObligationDeferralMethod,
  PerfOblgnContractualQuantity,
  PerfOblgnContractualQtyUnit,
  PerfOblgnEffectiveQuantity,
  PerfOblgnEffectiveQuantityUnit,
  RAPerfOblgnIsResidual,
  PerfOblgnIsExclFromPriceAlloc,
  PerfOblgnIsFinallyInvoiced,
  PerfOblgnIsSoftDeleted,
  RAPerfOblgnFinalizationDate,
  RABusinessChangeReason
FROM I_RAPerfOblgnChangeTypeItem
;

Learn More