P_RAChgTypeItemWithLtstContrId

DDL: P_RACHGTYPEITEMWITHLTSTCONTRID SQL: PARCHGTYPWLTCT Type: view COMPOSITE
36 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 36 fields with key fields PerformanceObligation, RevenueAccountingContract, RevnAcctgContrChangeEffctvDate.

Data Sources (1)

SourceAliasJoin Type
I_RAPerfOblgnChangeTypeItem ChangeTypeItem from

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName PARCHGTYPWLTCT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (36)

KeyFieldSource TableSource FieldDescription
KEY PerformanceObligation I_RAPerfOblgnChangeTypeItem PerformanceObligation Performance Obligation
KEY RevenueAccountingContract PerformanceObligation RevenueAccountingContract Revenue Contract
KEY RevnAcctgContrChangeEffctvDate RevnAcctgContrChangeEffctvDate Validity Date
RAPerfOblgnChangeType RAPerfOblgnChangeType Change type
RevnAcctgReconciliationKey RevnAcctgReconciliationKey Reconcil. Key
PerformanceObligationClass I_RAPerfOblgnChangeTypeItem PerformanceObligationClass Performance Obligation Name
OriglRevenueAccountingContract I_RAPerfOblgnChangeTypeItem RevenueAccountingContract Revenue Contract
FiscalYear FiscalYear G/L Fiscal Year
FiscalPeriod FiscalPeriod Tax period
FiscalYearPeriod FiscalYearPeriod Period/Year
RAPerfOblgnDistinctType I_RAPerfOblgnChangeTypeItem RAPerfOblgnDistinctType Composition
RAPerformanceObligationType I_RAPerfOblgnChangeTypeItem RAPerformanceObligationType Performance Obligation Type
RAChangeTypeChangeDateTime 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 RABusinessChangeReason

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.
-- SQL view name: PARCHGTYPWLTCT

CREATE VIEW P_RAChgTypeItemWithLtstContrId AS
SELECT
  ChangeTypeItem.PerformanceObligation AS PerformanceObligation,
  PerformanceObligation.RevenueAccountingContract AS RevenueAccountingContract,
  RevnAcctgContrChangeEffctvDate,
  RAPerfOblgnChangeType,
  RevnAcctgReconciliationKey,
  ChangeTypeItem.PerformanceObligationClass AS PerformanceObligationClass,
  ChangeTypeItem.RevenueAccountingContract AS OriglRevenueAccountingContract,
  FiscalYear,
  FiscalPeriod,
  FiscalYearPeriod,
  ChangeTypeItem.RAPerfOblgnDistinctType AS RAPerfOblgnDistinctType,
  ChangeTypeItem.RAPerformanceObligationType AS RAPerformanceObligationType,
  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,
  RABusinessChangeReason
FROM I_RAPerfOblgnChangeTypeItem AS ChangeTypeItem
;

Learn More