I_RAPerfOblgnWithToCurPerdAmt

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_RAPerfOblgnWithToCurPerdAmt.
-- 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_RAPerfOblgnWithToCurPerdAmt AS
SELECT
  RAPerformanceObligation.PerformanceObligation AS PerformanceObligation,
  RAPerformanceObligation.RevenueAccountingContract AS RevenueAccountingContract,
  RAPerformanceObligation.RAPerfOblgnDistinctType AS RAPerfOblgnDistinctType,
  RAPerformanceObligation.PerformanceObligationClass AS PerformanceObligationClass,
  RAPerformanceObligation.RAPerformanceObligationType AS RAPerformanceObligationType,
  RAPerformanceObligation.RAPerfOblgnCategory AS RAPerfOblgnCategory,
  RAPerformanceObligation.SalesDocumentCurrency AS SalesDocumentCurrency,
  RAPerformanceObligation.SSPriceInSalesDocCrcy AS SSPriceInSalesDocCrcy,
  cast(_RAPerfOblgnWithToCurPerdAmt.UpToCurPeriodInvoicedAmount as farr_invoiced_amount preserving type) AS UpToCurPeriodInvoicedAmount,
  RAPerformanceObligation.PerfOblgnEffectiveQuantityUnit AS PerfOblgnEffectiveQuantityUnit,
  RAPerformanceObligation.PerfOblgnEffectiveQuantity AS PerfOblgnEffectiveQuantity,
  RAPerformanceObligation.PerfOblgnFulfillmentType AS PerfOblgnFulfillmentType,
  RAPerformanceObligation.PerfOblgnEventType AS PerfOblgnEventType,
  cast('' as farr_cds_rai_srcco) AS RevnAcctgSenderComponent,
  cast('' as farr_operational_doc) AS RevnAcctgOperationalDocument,
  cast('' as farr_item_id) AS RAOperationalDocumentItem,
  cast(0 as farr_num_of_oprational_doc) AS RANumberOfOperationalDocument,
  cast(_RAPerfOblgnWithToCurPerdAmt.UpToCurPeriodRecognizedRevenue as farr_recog_amt preserving type) AS UpToCurPeriodRecognizedRevenue,
  cast(_RAPerfOblgnTotalFaceValue.PerfOblgnFaceAmtInSlsDocCrcy as farr_face_value preserving type) AS PerfOblgnFaceAmtInSlsDocCrcy,
  cast(_RAPerfOblgnFulfilledQty.CumltvFulfilledAmtInSlsDocCrcy as farr_cds_cumltv_fulfilled_val preserving type) AS CumltvFulfilledAmtInSlsDocCrcy,
  cast(_RATotalFulfilledQty.CumltvFulfilledAmtInSlsDocCrcy as farr_cds_fulfilled_value preserving type) AS FulfilledAmountInSlsDocCrcy,
  cast('%' as farr_quantity_unit) AS RatioUnit,
  RAPerformanceObligation.PerfOblgnStartDateType AS PerfOblgnStartDateType,
  RAPerformanceObligation.PerformanceObligationStartDate AS PerformanceObligationStartDate,
  RAPerformanceObligation.PerformanceObligationEndDate AS PerformanceObligationEndDate,
  RAPerformanceObligation.RAPerfOblgnFinalizationDate AS RAPerfOblgnFinalizationDate,
  RAPerformanceObligation.PerfObligationDeferralMethod AS PerfObligationDeferralMethod,
  RAPerformanceObligation.PerfOblgnContractualQuantity AS PerfOblgnContractualQuantity,
  RAPerformanceObligation.PerfOblgnContractualQtyUnit AS PerfOblgnContractualQtyUnit,
  RAPerformanceObligation.SSPriceToleranceAmount AS SSPriceToleranceAmount,
  RAPerformanceObligation.SSPriceTolerancePercent AS SSPriceTolerancePercent,
  RAPerformanceObligation.RAPerfOblgnInvoiceEffectType AS RAPerfOblgnInvoiceEffectType,
  cast(_RAPerfOblgnFulfilledQty.UpToCurPeriodFulfilledQty as farr_fulfilled_qty_to_cur_perd preserving type) AS UpToCurPeriodFulfilledQty,
  cast(_RAPerfOblgnInvcdQty.UpToCurPeriodInvoicedQty as farr_invoiced_quantity preserving type) AS UpToCurPeriodInvoicedQty,
  _RATotalFulfilledQty.PerfOblgnTotalFulfilledQty AS PerfOblgnTotalFulfilledQty,
  cast(_RATotInvcdAmt.PerfOblgnTotalInvoicedAmt as farr_cds_total_invoiced_amt preserving type) AS PerfOblgnTotalInvoicedAmt,
  cast(_RATotInvcdQtyByPerfOblg.PerfOblgnTotalInvoicedQty as farr_cds_total_invoiced_qty preserving type) AS PerfOblgnTotalInvoicedQty,
  RAPerformanceObligation.PerUnitSSPriceInSlsDocCrcy AS PerUnitSSPriceInSlsDocCrcy,
  RAPerformanceObligation.PerfOblgnIsExclFromPriceAlloc AS PerfOblgnIsExclFromPriceAlloc,
  RAPerformanceObligation.RAPerfOblgnIsResidual AS RAPerfOblgnIsResidual,
  RAPerformanceObligation.PerfOblgnIsFullyFulfilled AS PerfOblgnIsFullyFulfilled,
  RAPerformanceObligation.PerfOblgnIsFinallyInvoiced AS PerfOblgnIsFinallyInvoiced,
  RAPerformanceObligation.BusinessPartner AS BusinessPartner,
  RAPerformanceObligation._BusinessPartner AS _BusinessPartner,
  RAPerformanceObligation.Customer AS Customer,
  RAPerformanceObligation._Customer AS _Customer,
  RAPerformanceObligation.CostCenter AS CostCenter,
  RAPerformanceObligation.OrderID AS OrderID,
  RAPerformanceObligation.SalesOrder AS SalesOrder,
  RAPerformanceObligation.SalesOrderItem AS SalesOrderItem,
  RAPerformanceObligation.ProfitCenter AS ProfitCenter,
  RAPerformanceObligation.WBSElementExternalID AS WBSElementExternalID,
  RAPerformanceObligation.WBSElementInternalID AS WBSElementInternalID,
  RAPerformanceObligation.Segment AS Segment,
  RAPerformanceObligation.FunctionalArea AS FunctionalArea,
  RAPerformanceObligation.BusinessArea AS BusinessArea,
  RAPerformanceObligation.CompanyCode AS CompanyCode,
  RAPerformanceObligation.RevnAcctgSalesOrganization AS RevnAcctgSalesOrganization,
  RAPerformanceObligation.AccountingPrinciple AS AccountingPrinciple,
  RAPerformanceObligation.RevnAcctgPerfOblgnStatus AS RevnAcctgPerfOblgnStatus,
  RAPerformanceObligation.RAPerfOblgnCompletionDate AS RAPerfOblgnCompletionDate,
  RAPerformanceObligation.PerfOblgnCreatedByUser AS PerfOblgnCreatedByUser,
  RAPerformanceObligation._CreatedByUser.UserDescription AS CreatedByUserDescription,
  RAPerformanceObligation.PerfOblgnLastChangedByUsr AS PerfOblgnLastChangedByUsr,
  RAPerformanceObligation._ChangedByUser.UserDescription AS LastChangedByUserDescription,
  RAPerformanceObligation.PerfOblgnCreationDate AS PerfOblgnCreationDate,
  cast(RAPerformanceObligation.PerfOblgnLastChangeDate as farr_cds_pob_last_chg_date preserving type) AS PerfOblgnLastChangeDate,
  RAPerformanceObligation.RAPerfOblgnIsManuallyChanged AS RAPerfOblgnIsManuallyChanged,
  RAPerformanceObligation.RAPerfOblgnIsManuallyCreated AS RAPerfOblgnIsManuallyCreated,
  RAPerformanceObligation.RAPerfOblgnIsManuallyDeleted AS RAPerfOblgnIsManuallyDeleted,
  RAPerformanceObligation.RAPerfOblgnIsCostRecognizable AS RAPerfOblgnIsCostRecognizable,
  RAPerformanceObligation.RAHigherLevelPerfOblgn AS RAHigherLevelPerfOblgn,
  RAPerformanceObligation.RootPerformanceObligationInBOM AS RootPerformanceObligationInBOM,
  RAPerformanceObligation.PerfOblgnIsSoftDeleted AS PerfOblgnIsSoftDeleted,
  RAPerformanceObligation.PerfOblgnDeliveredQuantity AS PerfOblgnDeliveredQuantity,
  RAPerformanceObligation.RAItemDifferenceToDeliveredQty AS RAItemDifferenceToDeliveredQty,
  RAPerformanceObligation._RevenueAccountingContract AS _RevenueAccountingContract,
  RAPerformanceObligation._Mapping AS _Mapping,
  RAPerformanceObligation._CompanyCode AS _CompanyCode,
  RAPerformanceObligation._AccountingPrinciple AS _AccountingPrinciple,
  RAPerformanceObligation._Segment AS _Segment,
  RAPerformanceObligation._WBSElement AS _WBSElement,
  RAPerformanceObligation._PerfOblgnContractualQtyUnit AS _PerfOblgnContractualQtyUnit,
  RAPerformanceObligation._PerfOblgnEffectiveQtyUnit AS _PerfOblgnEffectiveQtyUnit,
  RAPerformanceObligation._FulfillmentType AS _FulfillmentType,
  RAPerformanceObligation._PerfObligationEventType AS _PerfObligationEventType,
  RAPerformanceObligation._PerfOblgnStartDateType AS _PerfOblgnStartDateType,
  RAPerformanceObligation._RAPerfOblgnStatus AS _RAPerfOblgnStatus,
  RAPerformanceObligation._CreatedByUser AS _CreatedByUser,
  RAPerformanceObligation._ChangedByUser AS _ChangedByUser,
  RAPerformanceObligation._FunctionalArea AS _FunctionalArea,
  RAPerformanceObligation._BusinessArea AS _BusinessArea,
  RAPerformanceObligation._Order AS _Order,
  RAPerformanceObligation._SalesOrder AS _SalesOrder,
  RAPerformanceObligation._SalesOrderItem AS _SalesOrderItem,
  RAPerformanceObligation._IndicatorManuallyChgd AS _IndicatorManuallyChgd,
  RAPerformanceObligation._PerfOblgnDistinctType AS _PerfOblgnDistinctType,
  RAPerformanceObligation._RAPerfOblgnCategory AS _RAPerfOblgnCategory,
  RAPerformanceObligation._SalesOrganization AS _SalesOrganization
FROM I_RAPerformanceObligation AS RAPerformanceObligation
LEFT OUTER JOIN P_RAPerfOblgnRevnInvcToCurPerd AS _RAPerfOblgnWithToCurPerdAmt ON RAPerformanceObligation.RevenueAccountingContract = _RAPerfOblgnWithToCurPerdAmt.RevenueAccountingContract AND RAPerformanceObligation.PerformanceObligation = _RAPerfOblgnWithToCurPerdAmt.PerformanceObligation  -- association [0..1]
LEFT OUTER JOIN P_RAPerfOblgnTotalFaceValue AS _RAPerfOblgnTotalFaceValue ON RAPerformanceObligation.RevenueAccountingContract = _RAPerfOblgnTotalFaceValue.RevenueAccountingContract AND RAPerformanceObligation.PerformanceObligation = _RAPerfOblgnTotalFaceValue.PerformanceObligation  -- association [0..1]
LEFT OUTER JOIN P_RAFulfilledQtyUpToCurPerd AS _RAPerfOblgnFulfilledQty ON RAPerformanceObligation.RevenueAccountingContract = _RAPerfOblgnFulfilledQty.RevenueAccountingContract AND RAPerformanceObligation.PerformanceObligation = _RAPerfOblgnFulfilledQty.PerformanceObligation  -- association [0..1]
LEFT OUTER JOIN P_RAInvoicedQtyUpToCurPerd AS _RAPerfOblgnInvcdQty ON RAPerformanceObligation.RevenueAccountingContract = _RAPerfOblgnInvcdQty.RevenueAccountingContract AND RAPerformanceObligation.PerformanceObligation = _RAPerfOblgnInvcdQty.PerformanceObligation  -- association [0..1]
LEFT OUTER JOIN P_RATotalFulfilledQty AS _RATotalFulfilledQty ON _RATotalFulfilledQty.RevenueAccountingContract = RAPerformanceObligation.RevenueAccountingContract AND _RATotalFulfilledQty.PerformanceObligation = RAPerformanceObligation.PerformanceObligation  -- association [0..1]
LEFT OUTER JOIN P_RATotalInvoicedQuantity AS _RATotInvcdQtyByPerfOblg ON _RATotInvcdQtyByPerfOblg.PerformanceObligation = RAPerformanceObligation.PerformanceObligation AND _RATotInvcdQtyByPerfOblg.RevenueAccountingContract = RAPerformanceObligation.RevenueAccountingContract  -- association [0..1]
LEFT OUTER JOIN P_RATotalInvoicedAmount AS _RATotInvcdAmt ON _RATotInvcdAmt.PerformanceObligation = RAPerformanceObligation.PerformanceObligation AND _RATotInvcdAmt.RevenueAccountingContract = RAPerformanceObligation.RevenueAccountingContract  -- association [0..1]
LEFT OUTER JOIN P_RAHighLvlPerfOblgnAmt AS RAHighLvlPerfOblgnAmt ON RAPerformanceObligation.PerformanceObligation = RAHighLvlPerfOblgnAmt.PerformanceObligation AND RAPerformanceObligation.RevenueAccountingContract = RAHighLvlPerfOblgnAmt.RevenueAccountingContract  -- association [0..1]
LEFT OUTER JOIN P_RAPerfOblgnPostponedRevenue AS _RAPerfOblgnPostponedRevenue ON RAPerformanceObligation.RevenueAccountingContract = _RAPerfOblgnPostponedRevenue.RevenueAccountingContract AND RAPerformanceObligation.PerformanceObligation = _RAPerfOblgnPostponedRevenue.PerformanceObligation  -- association [0..1]
LEFT OUTER JOIN P_CompndPerfOblgnPostponedRevn AS _CompndPerfOblgnPostponedRevn ON RAPerformanceObligation.RevenueAccountingContract = _CompndPerfOblgnPostponedRevn.RevenueAccountingContract AND RAPerformanceObligation.PerformanceObligation = _CompndPerfOblgnPostponedRevn.PerformanceObligation  -- association [0..1]
;