I_RAPerformanceObligation

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_RAPerformanceObligation.
-- 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_RAPerformanceObligation AS
SELECT
  cast(pob_id as farr_cds_pob_id preserving type) AS PerformanceObligation,
  cast(pob_name as farr_cds_pob_name preserving type) AS PerformanceObligationClass,
  cast(contract_id as farr_cds_contract_id preserving type) AS RevenueAccountingContract,
  Segment,
  _CompanyCode.ControllingArea AS ControllingArea,
  prctr AS ProfitCenter,
  alloc_amt AS AllocatedPriceInSalesDocCrcy,
  cast(trx_price as farr_cds_contractual_price preserving type) AS ContractualPrcInSlsDocCrcy,
  cast(total_interest_amount as farr_cds_total_interest_amount preserving type) AS RATotalInterestAmtInSlsDocCrcy,
  cast(unit_ssp as farr_cds_unit_ssp preserving type) AS PerUnitSSPriceInSlsDocCrcy,
  cast(ssp as farr_cds_standalone_price preserving type) AS SSPriceInSalesDocCrcy,
  cast(ssp_range_perc as farr_cds_ssp_range_percentage preserving type) AS SSPriceTolerancePercent,
  ssp_range_amount AS SSPriceToleranceAmount,
  cast(alloc_amt_curk as waerk preserving type) AS SalesDocumentCurrency,
  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,
  cast(fulfill_type as farr_fulfill_type preserving type) AS PerfOblgnFulfillmentType,
  cast(residual_pob as farr_cds_residual_pob preserving type) AS RAPerfOblgnIsResidual,
  event_type AS PerfOblgnEventType,
  start_date AS PerformanceObligationStartDate,
  end_date AS PerformanceObligationEndDate,
  final_date AS RAPerfOblgnFinalizationDate,
  deferral_method AS PerfObligationDeferralMethod,
  start_date_type AS PerfOblgnStartDateType,
  duration AS PerfObligationDuration,
  duration_unit AS PerfObligationDurationUnit,
  cast(fully_fulfilled as farr_cds_fully_fulfilled preserving type) AS PerfOblgnIsFullyFulfilled,
  final_invoice AS PerfOblgnIsFinallyInvoiced,
  partner AS BusinessPartner,
  kostl AS CostCenter,
  _InternalWBSElement.WBSElementExternalID AS WBSElementExternalID,
  cast(ps_psp_pnr as ps_s4_pspnr preserving type) AS WBSElementInternalID,
  sales_org AS RevnAcctgSalesOrganization,
  company_code AS CompanyCode,
  acct_principle AS AccountingPrinciple,
  cast(created_by as fis_cc_erfnm preserving type) AS PerfOblgnCreatedByUser,
  cast(created_on as fis_cc_erfdt preserving type) AS PerfOblgnCreationDate,
  last_changed_on AS PerfOblgnLastChangeDate,
  cast(last_changed_by as fis_aufaenam preserving type) AS PerfOblgnLastChangedByUsr,
  cast(prevent_alloc as farr_cds_exclude_allocation preserving type) AS PerfOblgnIsExclFromPriceAlloc,
  rev_rec_block AS PerfOblgnPostingIsSusp,
  distributed_org_price AS OplContractualPrcInSlsDocCrcy,
  cast(has_pro_change as farr_cds_has_pro_change preserving type) AS PerfOblgnHasContrModification,
  hi_level_pob_id AS RAHigherLevelPerfOblgn,
  soft_deleted AS PerfOblgnIsSoftDeleted,
  invoice_effect_type AS RAPerfOblgnInvoiceEffectType,
  cast(value_based_fulfillments as farr_cds_ful_based_on_value preserving type) AS RAFulfillmentIsValueBased,
  cast(status as farr_cds_pob_status preserving type) AS RevnAcctgPerfOblgnStatus,
  cast(completion_date as farr_cds_pob_completion_date preserving type) AS RAPerfOblgnCompletionDate,
  customer_id AS Customer,
  cast(pob_type as farr_cds_pob_type preserving type) AS RAPerformanceObligationType,
  cast(pob_category as farr_cds_pob_category preserving type) AS RAPerfOblgnCategory,
  fkber AS FunctionalArea,
  gsber AS BusinessArea,
  cast(paobjnr as rkeobjnr_char preserving type) AS ProfitabilitySegment_2,
  aufnr AS OrderID,
  cast(kdauf as farr_cds_acct_assmt_so preserving type) AS SalesOrder,
  cast(kdpos as farr_cds_acct_assmt_so_item preserving type) AS SalesOrderItem,
  accrued_cost_account AS RAPerfOblgnAccruedCostAccount,
  deferred_cost_account AS RAPerfOblgnDeferredCostAccount,
  asset_account AS RAContractAssetAccount,
  liability_account AS RAContractLiabilityAccount,
  manual_changed AS RAPerfOblgnIsManuallyChanged,
  manual_created AS RAPerfOblgnIsManuallyCreated,
  manual_deleted AS RAPerfOblgnIsManuallyDeleted,
  cost AS RAPerfOblgnCostAmtInSlsDocCrcy,
  cost_curk AS CostCurrency,
  distinct_type AS RAPerfOblgnDistinctType,
  cast(cost_recognition as farr_cds_cost_recognition preserving type) AS RAPerfOblgnIsCostRecognizable,
  initial_effective_date AS RAInitialEffectiveDate,
  bom_pob_id AS RootPerformanceObligationInBOM,
  cast(delivered_quantity as farr_cds_delivered_quantity) AS PerfOblgnDeliveredQuantity,
  cast(delivered_qty_diff as farr_cds_diff_to_delivered_qty) AS RAItemDifferenceToDeliveredQty,
  cast(pob_role as farr_cds_pob_role preserving type) AS PerformanceObligationRole,
  cast(leading_pob_id as farr_cds_leading_pob_id preserving type) AS LeadingPerformanceObligation,
  inception_date AS RAPerfOblgnInceptionDate,
  suspension_date AS RevnAcctgSuspensionDate,
  suspension_reason AS RevnAcctgSuspensionReason,
  manual_spreading AS PerfOblgnHasManualSpreading,
  spread_conflict AS PerfOblgnHasSprdgConflict,
  attr_conflict AS RAAttributeHasConflict,
  urr_integration_type AS RAUnivRevnRecgnIntegType,
  receivable_account AS RevnAcctgReceivablesAccount,
  solution_order_id AS BusinessSolutionOrder,
  solution_order_item_id AS BusinessSolutionOrderItem
FROM farr_d_pob
LEFT OUTER JOIN I_RevenueAccountingContract AS _RevenueAccountingContract ON RevenueAccountingContract = _RevenueAccountingContract.RevenueAccountingContract  -- association [1..1]
LEFT OUTER JOIN I_RevenueAccountingMapping AS _Mapping ON PerformanceObligation = _Mapping.PerformanceObligation  -- association [1..*]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_AccountingPrinciple AS _AccountingPrinciple ON AccountingPrinciple = _AccountingPrinciple.AccountingPrinciple  -- association [1..1]
LEFT OUTER JOIN I_BusinessPartner AS _BusinessPartner ON BusinessPartner = _BusinessPartner.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_Segment AS _Segment ON Segment = _Segment.Segment  -- association [0..1]
LEFT OUTER JOIN I_ControllingArea AS _ControllingArea ON ControllingArea = _ControllingArea.ControllingArea  -- association [0..1]
LEFT OUTER JOIN I_ProfitCenter AS _ProfitCenter ON ControllingArea = _ProfitCenter.ControllingArea AND ProfitCenter = _ProfitCenter.ProfitCenter  -- association [0..*]
LEFT OUTER JOIN I_ProfitCenter AS _CurrentProfitCenter ON ControllingArea = _CurrentProfitCenter.ControllingArea AND ProfitCenter = _CurrentProfitCenter.ProfitCenter AND _CurrentProfitCenter.ValidityStartDate <= $session.system_date AND _CurrentProfitCenter.ValidityEndDate >= $session.system_date  -- association [0..1]
LEFT OUTER JOIN I_CostCenter AS _CostCenter ON ControllingArea = _CostCenter.ControllingArea AND CostCenter = _CostCenter.CostCenter  -- association [0..*]
LEFT OUTER JOIN I_CostCenter AS _CurrentCostCenter ON ControllingArea = _CurrentCostCenter.ControllingArea AND CostCenter = _CurrentCostCenter.CostCenter AND _CurrentCostCenter.ValidityStartDate <= $session.system_date AND _CurrentCostCenter.ValidityEndDate >= $session.system_date  -- association [0..1]
LEFT OUTER JOIN I_WBSElementByExternalID AS _WBSElement ON WBSElementExternalID = _WBSElement.WBSElementExternalID  -- association [0..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _InternalWBSElement ON WBSElementInternalID = _InternalWBSElement.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _Currency ON SalesDocumentCurrency = _Currency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _CostCurrency ON CostCurrency = _CostCurrency.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_RAPerfObligationEventType AS _PerfObligationEventType ON PerfOblgnEventType = _PerfObligationEventType.PerfOblgnEventType  -- association [0..1]
LEFT OUTER JOIN I_RAPerfOblgnStartDateType AS _PerfOblgnStartDateType ON PerfOblgnStartDateType = _PerfOblgnStartDateType.PerfOblgnStartDateType  -- association [0..1]
LEFT OUTER JOIN I_RAPerfOblgnStatus AS _RAPerfOblgnStatus ON RevnAcctgPerfOblgnStatus = _RAPerfOblgnStatus.RevnAcctgPerfOblgnStatus  -- association [1..1]
LEFT OUTER JOIN I_User AS _CreatedByUser ON PerfOblgnCreatedByUser = _CreatedByUser.UserID  -- association [1..1]
LEFT OUTER JOIN I_User AS _ChangedByUser ON PerfOblgnLastChangedByUsr = _ChangedByUser.UserID  -- association [1..1]
LEFT OUTER JOIN I_Customer AS _Customer ON Customer = _Customer.Customer  -- association [0..1]
LEFT OUTER JOIN I_FunctionalArea AS _FunctionalArea ON FunctionalArea = _FunctionalArea.FunctionalArea  -- association [0..1]
LEFT OUTER JOIN I_BusinessArea AS _BusinessArea ON BusinessArea = _BusinessArea.BusinessArea  -- association [0..1]
LEFT OUTER JOIN I_Order AS _Order ON OrderID = _Order.OrderID  -- association [0..1]
LEFT OUTER JOIN I_SalesOrder AS _SalesOrder ON SalesOrder = _SalesOrder.SalesOrder  -- association [0..1]
LEFT OUTER JOIN I_SalesOrderItem AS _SalesOrderItem ON SalesOrder = _SalesOrderItem.SalesOrder AND SalesOrderItem = _SalesOrderItem.SalesOrderItem  -- association [0..1]
LEFT OUTER JOIN I_Indicator AS _IndicatorManuallyChgd ON RAPerfOblgnIsManuallyChanged = _IndicatorManuallyChgd.IndicatorValue  -- association [1..1]
LEFT OUTER JOIN I_RAPerfOblgnDistinctType AS _PerfOblgnDistinctType ON RAPerfOblgnDistinctType = _PerfOblgnDistinctType.RAPerfOblgnDistinctType  -- association [1..1]
LEFT OUTER JOIN I_PerformanceObligationRole AS _PerformanceObligationRole ON PerformanceObligationRole = _PerformanceObligationRole.PerformanceObligationRole  -- association [0..1]
LEFT OUTER JOIN I_RAPerfOblgnCategory AS _RAPerfOblgnCategory ON RAPerfOblgnCategory = _RAPerfOblgnCategory.RAPerfOblgnCategory  -- association [1..1]
LEFT OUTER JOIN I_SalesOrganization AS _SalesOrganization ON RevnAcctgSalesOrganization = _SalesOrganization.SalesOrganization  -- association [0..1]
LEFT OUTER JOIN I_RAUnivRevnRecgnIntegType AS _RAUnivRevnRecgnIntegType ON RAUnivRevnRecgnIntegType = _RAUnivRevnRecgnIntegType.RAUnivRevnRecgnIntegType  -- association [1..1]
;