I_RAPerfOblgnChangeTypeItem

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 I_RAPerfOblgnChangeTypeItem.
-- 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 I_RAPerfOblgnChangeTypeItem AS
SELECT
  cast(pob_id as farr_cds_pob_id preserving type) AS PerformanceObligation,
  cast(contract_id as farr_cds_contract_id preserving type) AS RevenueAccountingContract,
  effective_date AS RevnAcctgContrChangeEffctvDate,
  cast(pob_name as farr_cds_pob_name preserving type) AS PerformanceObligationClass,
  change_type AS RAPerfOblgnChangeType,
  recon_key AS RevnAcctgReconciliationKey,
  cast(fiscal_year as fis_gjahr preserving type) AS FiscalYear,
  cast(period as fins_fiscalperiod preserving type) AS FiscalPeriod,
  cast(concat(fiscal_year, period) as fis_jahrper_conv) AS FiscalYearPeriod,
  cast(pob_type as farr_cds_pob_type preserving type) AS RAPerformanceObligationType,
  cast(ssp as farr_cds_standalone_price preserving type) AS SSPriceInSalesDocCrcy,
  alloc_amt AS AllocatedPriceInSalesDocCrcy,
  cast(trx_price as farr_cds_contractual_price preserving type) AS ContractualPrcInSlsDocCrcy,
  cast(trx_price_org as farr_cds_transaction_price_org preserving type) AS OplContractualPrcInSlsDocCrcy,
  face_value AS PerfOblgnFaceAmtInSlsDocCrcy,
  trx_price_curk AS SalesDocumentCurrency,
  start_date AS PerformanceObligationStartDate,
  end_date AS PerformanceObligationEndDate,
  fulfill_type AS PerfOblgnFulfillmentType,
  deferral_method AS PerfObligationDeferralMethod,
  cast(residual_pob as farr_cds_residual_pob preserving type) AS RAPerfOblgnIsResidual,
  cast(prevent_alloc as farr_cds_exclude_allocation preserving type) AS PerfOblgnIsExclFromPriceAlloc,
  cast( asset_impairment_date as farr_cds_pob_asset_imp_date preserving type ) AS RAPerfOblgnAssetImpairmentDate,
  cast(ssp_range_perc as farr_cds_ssp_range_percentage preserving type) AS SSPriceTolerancePercent,
  ssp_range_amount AS SSPriceToleranceAmount,
  cast(quantity as farr_cds_contractual_quantity) AS PerfOblgnContractualQuantity,
  quantity_unit AS PerfOblgnContractualQtyUnit,
  cast(effective_qty as farr_cds_effective_quantity) AS PerfOblgnEffectiveQuantity,
  effective_qty_unit AS PerfOblgnEffectiveQuantityUnit,
  distinct_type AS RAPerfOblgnDistinctType,
  hi_level_pob_id AS RAHigherLevelPerfOblgn,
  final_invoice AS PerfOblgnIsFinallyInvoiced,
  soft_deleted AS PerfOblgnIsSoftDeleted,
  final_date AS RAPerfOblgnFinalizationDate,
  cast(manual_allocated as farr_cds_manual_price_alloc preserving type) AS RAContractIsManuallyAllocated,
  cast(business_change_reason as farr_cds_business_chg_reason preserving type) AS RABusinessChangeReason,
  cast(created_on as creation_date_time preserving type) AS RAChangeTypeCreationDateTime,
  cast(changed_on as last_changed_date_time preserving type) AS RAChangeTypeChangeDateTime
FROM farr_d_pob_ctype
LEFT OUTER JOIN I_RAPerfOblgnWithoutAcctAssgmt AS _PerfOblgn ON PerformanceObligation = _PerfOblgn.PerformanceObligation  -- association [1..1]
LEFT OUTER JOIN I_RevenueAccountingContract AS _RevenueAccountingContract ON RevenueAccountingContract = _RevenueAccountingContract.RevenueAccountingContract  -- association [1..1]
LEFT OUTER JOIN I_RevnAcctgChangeType AS _RevnAcctgChangeType ON RAPerfOblgnChangeType = _RevnAcctgChangeType.RAPerfOblgnChangeType  -- association [1..1]
LEFT OUTER JOIN I_RAPerfOblgnDistinctType AS _PerfOblgnDistinctType ON RAPerfOblgnDistinctType = _PerfOblgnDistinctType.RAPerfOblgnDistinctType  -- association [1..1]
LEFT OUTER JOIN I_Currency AS _Currency ON SalesDocumentCurrency = _Currency.Currency  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _PerfOblgnEffectiveQtyUnit ON PerfOblgnEffectiveQuantityUnit = _PerfOblgnEffectiveQtyUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _PerfOblgnContractualQtyUnit ON PerfOblgnContractualQtyUnit = _PerfOblgnContractualQtyUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_RAPerfOblgnFlfmtType AS _FulfillmentType ON PerfOblgnFulfillmentType = _FulfillmentType.PerfOblgnFulfillmentType  -- association [1..1]
LEFT OUTER JOIN I_RAPerfOblgnDeferralMethod AS _PerfOblgnDeferralMethod ON PerfObligationDeferralMethod = _PerfOblgnDeferralMethod.PerfObligationDeferralMethod  -- association [0..1]
;