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 R_RABusRecnclnForPerfOblgnTP.
-- 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 R_RABusRecnclnForPerfOblgnTP AS
SELECT
_pob_biz.CompanyCode AS CompanyCode,
_pob_biz.AccountingPrinciple AS AccountingPrinciple,
_pob_biz.RevenueAccountingContract AS RevenueAccountingContract,
_pob_biz.PerformanceObligation AS PerformanceObligation,
_pob_biz._RAPerformanceObligation.PerformanceObligationClass AS PerformanceObligationClass,
_NumOfOperationalDocument.RANumberOfOperationalDocument AS RANumberOfOperationalDocument,
_pob_biz.RevnAcctgOperationalDocument AS RevnAcctgOperationalDocument,
_pob_biz.RevnAcctgSenderComponent AS RevnAcctgSenderComponent,
_pob_biz.SalesDocumentCurrency AS SalesDocumentCurrency,
_pob_biz.CompanyCodeCurrency AS CompanyCodeCurrency,
_pob_biz.AdditionalCurrency1 AS AdditionalCurrency1,
_pob_biz.AdditionalCurrency2 AS AdditionalCurrency2,
cast(_pob_biz.OplContractualPrcInSlsDocCrcy as farr_cds_op_cond_price) AS OplContractualPrcInSlsDocCrcy,
cast(_pob_biz.DeltaEffectiveAmtInSlsDocCrcy as farr_contractual_price_org) AS DeltaEffectiveAmtInSlsDocCrcy,
cast(_pob_biz.RAOplCostAmtInSlsDocCrcy as farr_cds_op_cond_cost) AS RAOplCostAmtInSlsDocCrcy,
cast(_pob_biz.TotalInvoicedAmtInSlsDocCrcy as farr_opl_invoiced_amt) AS TotalInvoicedAmtInSlsDocCrcy,
cast(_pob_biz.RAOplCostPriceAmtInSlsDocCrcy as farr_cds_cost_price) AS RAOplCostPriceAmtInSlsDocCrcy,
cast(_pob_biz.ContractualPrcInSlsDocCrcy as farr_transaction_price) AS ContractualPrcInSlsDocCrcy,
cast( _pob_biz.RAPerfOblgnCostAmtInSlsDocCrcy as farr_cost_total) AS RAPerfOblgnCostAmtInSlsDocCrcy,
cast (_pob_biz.SSPriceInSalesDocCrcy as farr_cds_standalone_price) AS SSPriceInSalesDocCrcy,
cast(_pob_biz.RADeltaRecgdCostInSlsDocCrcy as farr_actual_cost ) AS RADeltaRecgdCostInSlsDocCrcy,
cast ( _pob_biz.RARecognizedRevnInSlsDocCrcy as farr_recog_amt ) AS RARecognizedRevnInSlsDocCrcy,
cast ( _pob_biz.RARecgdCostAmountInSlsDocCrcy as farr_recog_cost ) AS RARecgdCostAmountInSlsDocCrcy,
cast ( _pob_biz.PerPerdInvoicedAmtInSlsDocCrcy as farr_invoiced_amt ) AS PerPerdInvoicedAmtInSlsDocCrcy,
cast (_RARecnclnPostdAmtPerfOblgn.PostedRevnInSlsDocCrcy as farr_cds_posted_rv) AS PostedRevnInSlsDocCrcy,
cast (_RARecnclnPostdAmtPerfOblgn.PostedInvoiceAmtInSlsDocCrcy as farr_cds_posted_ic) AS PostedInvoiceAmtInSlsDocCrcy,
cast(_pob_biz.SuspendedRevnAmtInSlsDocCrcy as farr_cds_suspended_revenue) AS SuspendedRevnAmtInSlsDocCrcy,
cast(_pob_biz.SuspendedCostAmtInSlsDocCrcy as farr_cds_suspended_cost) AS SuspendedCostAmtInSlsDocCrcy,
cast (_RARecnclnPostdAmtPerfOblgn.RAPostedCostInSlsDocCrcy as farr_cds_posted_co) AS RAPostedCostInSlsDocCrcy,
cast (_RARecnclnPostdAmtPerfOblgn.RAPostedUnbilldRblsAmount as farr_cds_posted_ur) AS RAPostedUnbilldRblsAmount,
cast (_RARecnclnPostdAmtPerfOblgn.RADeferredRevenueInSlsDocCrcy as farr_cds_posted_dr) AS RADeferredRevenueInSlsDocCrcy,
cast (_RARecnclnPostdAmtPerfOblgn.RAContractAssetsAmount as farr_cds_posted_ca) AS RAContractAssetsAmount,
cast (_RARecnclnPostdAmtPerfOblgn.RAContrLiabilitiesAmount as farr_cds_posted_cl) AS RAContrLiabilitiesAmount,
cast (_RARecnclnPostdAmtPerfOblgn.PostdDfrrdCostAmtInSlsDocCrcy as farr_cds_posted_cj) AS PostdDfrrdCostAmtInSlsDocCrcy,
cast (_RARecnclnPostdAmtPerfOblgn.RAPostedRevenueAmtInCoCodeCrcy as farr_cds_posted_rv_lc1) AS RAPostedRevenueAmtInCoCodeCrcy,
cast (_RARecnclnPostdAmtPerfOblgn.RAPostedInvoiceAmtInCoCodeCrcy as farr_cds_posted_ic_lc1) AS RAPostedInvoiceAmtInCoCodeCrcy,
cast (_RARecnclnPostdAmtPerfOblgn.RAPostedCostAmountInCoCodeCrcy as farr_cds_posted_co_lc1) AS RAPostedCostAmountInCoCodeCrcy,
cast (_RARecnclnPostdAmtPerfOblgn.PostdUnbilldRblAmtInCoCodeCrcy as farr_cds_posted_ur_lc1) AS PostdUnbilldRblAmtInCoCodeCrcy,
cast (_RARecnclnPostdAmtPerfOblgn.PostedDfrrdRevnAmtInCoCodeCrcy as farr_cds_posted_dr_lc1) AS PostedDfrrdRevnAmtInCoCodeCrcy,
cast (_RARecnclnPostdAmtPerfOblgn.RAPostdContrAstAmtInCoCodeCrcy as farr_cds_posted_ca_lc1) AS RAPostdContrAstAmtInCoCodeCrcy,
cast (_RARecnclnPostdAmtPerfOblgn.PostdContrLbltyAmtInCoCodeCrcy as farr_cds_posted_cl_lc1) AS PostdContrLbltyAmtInCoCodeCrcy,
cast (_RARecnclnPostdAmtPerfOblgn.PostdDfrrdCostAmtInCoCodeCrcy as farr_cds_posted_cj_lc1) AS PostdDfrrdCostAmtInCoCodeCrcy,
cast (_RARecnclnPostdAmtPerfOblgn.RAPostedRevenueAmtInAddlCrcy1 as farr_cds_posted_rv_lc2) AS RAPostedRevenueAmtInAddlCrcy1,
cast (_RARecnclnPostdAmtPerfOblgn.RAPostedInvoiceAmtInAddlCrcy1 as farr_cds_posted_ic_lc2) AS RAPostedInvoiceAmtInAddlCrcy1,
cast (_RARecnclnPostdAmtPerfOblgn.RAPostedCostAmountInAddlCrcy1 as farr_cds_posted_co_lc2) AS RAPostedCostAmountInAddlCrcy1,
cast (_RARecnclnPostdAmtPerfOblgn.PostedUnbilldRblAmtInAddlCrcy1 as farr_cds_posted_ur_lc2) AS PostedUnbilldRblAmtInAddlCrcy1,
cast (_RARecnclnPostdAmtPerfOblgn.RAPostdDfrrdRevnAmtInAddlCrcy1 as farr_cds_posted_dr_lc2) AS RAPostdDfrrdRevnAmtInAddlCrcy1,
cast (_RARecnclnPostdAmtPerfOblgn.RAPostedContrAstAmtInAddlCrcy1 as farr_cds_posted_ca_lc2) AS RAPostedContrAstAmtInAddlCrcy1,
cast (_RARecnclnPostdAmtPerfOblgn.PostedContrLbltyAmtInAddlCrcy1 as farr_cds_posted_cl_lc2) AS PostedContrLbltyAmtInAddlCrcy1,
cast (_RARecnclnPostdAmtPerfOblgn.RAPostdDfrrdCostAmtInAddlCrcy1 as farr_cds_posted_cj_lc2) AS RAPostdDfrrdCostAmtInAddlCrcy1,
cast (_RARecnclnPostdAmtPerfOblgn.RAPostedRevenueAmtInAddlCrcy2 as farr_cds_posted_rv_lc3) AS RAPostedRevenueAmtInAddlCrcy2,
cast (_RARecnclnPostdAmtPerfOblgn.RAPostedInvoiceAmtInAddlCrcy2 as farr_cds_posted_ic_lc3) AS RAPostedInvoiceAmtInAddlCrcy2,
cast (_RARecnclnPostdAmtPerfOblgn.RAPostedCostAmountInAddlCrcy2 as farr_cds_posted_co_lc3) AS RAPostedCostAmountInAddlCrcy2,
cast (_RARecnclnPostdAmtPerfOblgn.PostedUnbilldRblAmtInAddlCrcy2 as farr_cds_posted_ur_lc3) AS PostedUnbilldRblAmtInAddlCrcy2,
cast (_RARecnclnPostdAmtPerfOblgn.RAPostdDfrrdRevnAmtInAddlCrcy2 as farr_cds_posted_dr_lc3) AS RAPostdDfrrdRevnAmtInAddlCrcy2,
cast (_RARecnclnPostdAmtPerfOblgn.RAPostedContrAstAmtInAddlCrcy2 as farr_cds_posted_ca_lc3) AS RAPostedContrAstAmtInAddlCrcy2,
cast (_RARecnclnPostdAmtPerfOblgn.PostedContrLbltyAmtInAddlCrcy2 as farr_cds_posted_cl_lc3) AS PostedContrLbltyAmtInAddlCrcy2,
cast (_RARecnclnPostdAmtPerfOblgn.RAPostdDfrrdCostAmtInAddlCrcy2 as farr_cds_posted_cj_lc3) AS RAPostdDfrrdCostAmtInAddlCrcy2,
cast(_pob_biz.SrceRecgdRevnAmtInSlsDocCrcy as farr_sched_rv_cumltv preserving type ) AS SrceRecgdRevnAmtInSlsDocCrcy,
cast(_pob_biz.SrceRecgdCostAmtInSlsDocCrcy as farr_sched_co_cumltv preserving type ) AS SrceRecgdCostAmtInSlsDocCrcy,
cast(_pob_biz.SrceRecgdInvcAmtInSlsDocCrcy as farr_sched_ic_cumltv preserving type ) AS SrceRecgdInvcAmtInSlsDocCrcy,
_DataValidationPOB.DataValidationHasError AS DataValidationHasError,
_DataValidationPOB.ValidationDateTime AS ValidationDateTime,
_pob_biz._RAPerformanceObligation.RAPerformanceObligationType AS RAPerformanceObligationType,
_pob_biz._RAPerformanceObligation.BusinessPartner AS BusinessPartner,
_pob_biz._RAPerformanceObligation._BusinessPartner.BusinessPartnerName AS BusinessPartnerName,
_pob_biz._RAPerformanceObligation.Customer AS Customer,
_pob_biz._RAPerformanceObligation._Customer.CustomerName AS CustomerName,
_pob_biz._RAPerformanceObligation.FunctionalArea AS FunctionalArea,
_pob_biz._RAPerformanceObligation.BusinessArea AS BusinessArea,
_pob_biz._RAPerformanceObligation.Segment AS Segment,
_pob_biz._RAPerformanceObligation.ProfitCenter AS ProfitCenter,
_pob_biz._RAPerformanceObligation.CostCenter AS CostCenter,
_pob_biz._RAPerformanceObligation.OrderID AS OrderID,
_pob_biz._RAPerformanceObligation.SalesOrder AS SalesOrder,
_pob_biz._RAPerformanceObligation.SalesOrderItem AS SalesOrderItem,
_pob_biz._RAPerformanceObligation.WBSElementExternalID AS WBSElementExternalID,
cast (_pob_biz.OperationalDocItemQty as farr_operational_quantity) AS OperationalDocItemQty,
cast (_pob_biz.PerfOblgnContractualQuantity as farr_order_quantity) AS PerfOblgnContractualQuantity,
_pob_biz.CARevnRecgnQtyUnit AS CARevnRecgnQtyUnit,
_pob_biz.Material AS Material,
_pob_biz.MaterialName AS MaterialName,
_pob_biz._RAPerformanceObligation.RevnAcctgPerfOblgnStatus AS RevnAcctgPerfOblgnStatus,
_pob_biz._RAPerformanceObligation._RAPerfOblgnStatus._Text[1:Language =$session.system_language].RevnAcctgPerfOblgnStatusName AS RevnAcctgPerfOblgnStatusName,
_pob_biz.ContractualPriceCriticality AS ContractualPriceCriticality,
_pob_biz.TotalCostCriticality AS TotalCostCriticality,
_pob_biz.InvoicedAmountCriticality AS InvoicedAmountCriticality,
_pob_biz.OrderQuantityCriticality AS OrderQuantityCriticality,
_pob_biz.ActualCostCriticality AS ActualCostCriticality,
cast(_pob_biz.RAContractIsInconsistent as farr_inconsistency_error) AS RAContractIsInconsistent,
cast (_pob_biz._RAPerformanceObligation.AllocatedPriceInSalesDocCrcy as farr_alloc_amt ) AS AllocatedPriceInSalesDocCrcy,
_BusRecnclnContract.RevnAcctgContractStatus AS RevnAcctgContractStatus,
_BusRecnclnContract._Contract._RAContractStatus._Text[1:Language =$session.system_language].RevnAcctgContractStatusName AS RevnAcctgContractStatusName,
_BusRecnclnContract._Contract.RAContractVersionCode AS RAContractVersionCode,
_BusRecnclnContract._Contract._RAContrMgmtVersion._Text[1:Language =$session.system_language].RAContractVersionName AS RAContractVersionName,
_pob_biz._RAPerformanceObligation.PerfOblgnEventType AS PerfOblgnEventType,
_pob_biz._Mapping AS _Mapping
FROM P_RABusRecnclnForPerfOblgn AS _pob_biz
LEFT OUTER JOIN P_RAPerfOblgnIsFrozen AS _IsFrozen ON PerformanceObligation = _IsFrozen.PerformanceObligation -- association [0..1]
LEFT OUTER JOIN R_RABusRecnclnDetWthCndnTypeTP AS _PerfOblgnConditionType ON /* condition not available in parsed metadata */ -- association [0..*]
;