P_RAChgTypeItemWithLtstContrId

DDL: P_RACHGTYPEITEMWITHLTSTCONTRID Type: view_entity COMPOSITE
37 Fields 1 Data Sources

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

Data Sources (1)

SourceAliasJoin Type
I_RAPerfOblgnChangeTypeItem ChangeTypeItem from

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 RevenueAccountingContract PerformanceObligation RevenueAccountingContract Revenue Contract
KEY RevnAcctgContrChangeEffctvDate I_RAPerfOblgnChangeTypeItem RevnAcctgContrChangeEffctvDate Validity Date
RAPerfOblgnChangeType I_RAPerfOblgnChangeTypeItem RAPerfOblgnChangeType Change type
RevnAcctgReconciliationKey I_RAPerfOblgnChangeTypeItem RevnAcctgReconciliationKey Reconcil. Key
PerformanceObligationClass I_RAPerfOblgnChangeTypeItem PerformanceObligationClass Performance Obligation Name
OriglRevenueAccountingContract I_RAPerfOblgnChangeTypeItem RevenueAccountingContract Revenue Contract
FiscalYear I_RAPerfOblgnChangeTypeItem FiscalYear G/L Fiscal Year
FiscalPeriod I_RAPerfOblgnChangeTypeItem FiscalPeriod Tax period
FiscalYearPeriod I_RAPerfOblgnChangeTypeItem FiscalYearPeriod Period/Year
RAPerfOblgnDistinctType I_RAPerfOblgnChangeTypeItem RAPerfOblgnDistinctType Composition
RAPerformanceObligationType I_RAPerfOblgnChangeTypeItem RAPerformanceObligationType Performance Obligation Type
RAChangeTypeChangeDateTime I_RAPerfOblgnChangeTypeItem RAChangeTypeChangeDateTime
SSPriceInSalesDocCrcy I_RAPerfOblgnChangeTypeItem SSPriceInSalesDocCrcy Standalone Selling Price
SSPriceToleranceAmount I_RAPerfOblgnChangeTypeItem SSPriceToleranceAmount SSP Tolerance
SalesDocumentCurrency I_RAPerfOblgnChangeTypeItem SalesDocumentCurrency Currency
PerfOblgnEffectiveQuantity I_RAPerfOblgnChangeTypeItem PerfOblgnEffectiveQuantity Effective Quantity
PerfOblgnEffectiveQuantityUnit I_RAPerfOblgnChangeTypeItem PerfOblgnEffectiveQuantityUnit Unit of Measure
SSPriceTolerancePercent I_RAPerfOblgnChangeTypeItem SSPriceTolerancePercent SSP Tolerance Percentage
AllocatedPriceInSalesDocCrcy I_RAPerfOblgnChangeTypeItem AllocatedPriceInSalesDocCrcy Allocated Amount
ContractualPrcInSlsDocCrcy I_RAPerfOblgnChangeTypeItem ContractualPrcInSlsDocCrcy Contractual Price
OplContractualPrcInSlsDocCrcy I_RAPerfOblgnChangeTypeItem OplContractualPrcInSlsDocCrcy
PerfOblgnFaceAmtInSlsDocCrcy I_RAPerfOblgnChangeTypeItem PerfOblgnFaceAmtInSlsDocCrcy Face Value
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
RAPerfOblgnIsResidual I_RAPerfOblgnChangeTypeItem RAPerfOblgnIsResidual Residual Allocation
PerfOblgnIsExclFromPriceAlloc I_RAPerfOblgnChangeTypeItem PerfOblgnIsExclFromPriceAlloc Excluded from Allocation
RAContractIsManuallyAllocated I_RAPerfOblgnChangeTypeItem RAContractIsManuallyAllocated Price Allocated Manually
PerfOblgnIsFinallyInvoiced I_RAPerfOblgnChangeTypeItem PerfOblgnIsFinallyInvoiced Final Invoice
PerfOblgnIsSoftDeleted I_RAPerfOblgnChangeTypeItem PerfOblgnIsSoftDeleted Soft Deleted
RAPerfOblgnFinalizationDate I_RAPerfOblgnChangeTypeItem RAPerfOblgnFinalizationDate Finalizat. Date
RABusinessChangeReason I_RAPerfOblgnChangeTypeItem RABusinessChangeReason
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_RAChgTypeItemWithLtstContrId.
-- 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_RAChgTypeItemWithLtstContrId AS
SELECT
  ChangeTypeItem.PerformanceObligation AS PerformanceObligation,
  PerformanceObligation.RevenueAccountingContract AS RevenueAccountingContract,
  ChangeTypeItem.RevnAcctgContrChangeEffctvDate AS RevnAcctgContrChangeEffctvDate,
  ChangeTypeItem.RAPerfOblgnChangeType AS RAPerfOblgnChangeType,
  ChangeTypeItem.RevnAcctgReconciliationKey AS RevnAcctgReconciliationKey,
  ChangeTypeItem.PerformanceObligationClass AS PerformanceObligationClass,
  ChangeTypeItem.RevenueAccountingContract AS OriglRevenueAccountingContract,
  ChangeTypeItem.FiscalYear AS FiscalYear,
  ChangeTypeItem.FiscalPeriod AS FiscalPeriod,
  ChangeTypeItem.FiscalYearPeriod AS FiscalYearPeriod,
  ChangeTypeItem.RAPerfOblgnDistinctType AS RAPerfOblgnDistinctType,
  ChangeTypeItem.RAPerformanceObligationType AS RAPerformanceObligationType,
  ChangeTypeItem.RAChangeTypeChangeDateTime AS RAChangeTypeChangeDateTime,
  ChangeTypeItem.SSPriceInSalesDocCrcy AS SSPriceInSalesDocCrcy,
  ChangeTypeItem.SSPriceToleranceAmount AS SSPriceToleranceAmount,
  ChangeTypeItem.SalesDocumentCurrency AS SalesDocumentCurrency,
  ChangeTypeItem.PerfOblgnEffectiveQuantity AS PerfOblgnEffectiveQuantity,
  ChangeTypeItem.PerfOblgnEffectiveQuantityUnit AS PerfOblgnEffectiveQuantityUnit,
  ChangeTypeItem.SSPriceTolerancePercent AS SSPriceTolerancePercent,
  ChangeTypeItem.AllocatedPriceInSalesDocCrcy AS AllocatedPriceInSalesDocCrcy,
  ChangeTypeItem.ContractualPrcInSlsDocCrcy AS ContractualPrcInSlsDocCrcy,
  ChangeTypeItem.OplContractualPrcInSlsDocCrcy AS OplContractualPrcInSlsDocCrcy,
  ChangeTypeItem.PerfOblgnFaceAmtInSlsDocCrcy AS PerfOblgnFaceAmtInSlsDocCrcy,
  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.RAPerfOblgnIsResidual AS RAPerfOblgnIsResidual,
  ChangeTypeItem.PerfOblgnIsExclFromPriceAlloc AS PerfOblgnIsExclFromPriceAlloc,
  ChangeTypeItem.RAContractIsManuallyAllocated AS RAContractIsManuallyAllocated,
  ChangeTypeItem.PerfOblgnIsFinallyInvoiced AS PerfOblgnIsFinallyInvoiced,
  ChangeTypeItem.PerfOblgnIsSoftDeleted AS PerfOblgnIsSoftDeleted,
  ChangeTypeItem.RAPerfOblgnFinalizationDate AS RAPerfOblgnFinalizationDate,
  ChangeTypeItem.RABusinessChangeReason AS RABusinessChangeReason,
  ChangeTypeItem.RAPerfOblgnAssetImpairmentDate AS RAPerfOblgnAssetImpairmentDate
FROM I_RAPerfOblgnChangeTypeItem AS ChangeTypeItem
;

Learn More