I_RAPerfOblgnWithoutAcctAssgmt

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_RAPerfOblgnWithoutAcctAssgmt.
-- 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_RAPerfOblgnWithoutAcctAssgmt 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,
  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 preserving type) 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,
  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,
  cast(fully_fulfilled as farr_cds_fully_fulfilled preserving type) AS PerfOblgnIsFullyFulfilled,
  final_invoice AS PerfOblgnIsFinallyInvoiced,
  partner AS BusinessPartner,
  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,
  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,
  cost_recognition AS RAPerfOblgnIsCostRecognizable,
  initial_effective_date AS RAInitialEffectiveDate,
  bom_pob_id AS RootPerformanceObligationInBOM
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_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_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_RAPerfOblgnCategory AS _RAPerfOblgnCategory ON RAPerfOblgnCategory = _RAPerfOblgnCategory.RAPerfOblgnCategory  -- association [1..1]
LEFT OUTER JOIN I_SalesOrganization AS _SalesOrganization ON RevnAcctgSalesOrganization = _SalesOrganization.SalesOrganization  -- association [0..1]
;