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

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( 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 ) AS SSPriceTolerancePercent,
  ssp_range_amount AS SSPriceToleranceAmount,
  alloc_amt_curk 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) 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) AS ProfitabilitySegment_2,
  aufnr AS OrderID,
  kdauf AS SalesOrder,
  kdpos 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 ) 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) AS PerformanceObligationRole,
  cast(leading_pob_id as farr_cds_leading_pob_id) 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
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]
;