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_RABusRecnclnForContract.
-- 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_RABusRecnclnForContract AS
SELECT
_RABusRecnclnContract.CompanyCode AS CompanyCode,
_RABusRecnclnContract.AccountingPrinciple AS AccountingPrinciple,
_RABusRecnclnContract.RevenueAccountingContract AS RevenueAccountingContract,
_RABusRecnclnContract._Contract.RevnAcctgContractDescription AS RevnAcctgContractDescription,
_RABusRecnclnContract._Contract.BusinessPartner AS BusinessPartner,
_RABusRecnclnContract._Contract._BusinessPartner.BusinessPartnerName AS BusinessPartnerName,
_RABusRecnclnContract._Contract.Customer AS Customer,
_RABusRecnclnContract._Contract._Customer.CustomerName AS CustomerName,
_RABusRecnclnContract._Contract.RevnAcctgContractStatus AS RevnAcctgContractStatus,
_RABusRecnclnContract._Contract._RAContractStatus._Text[1: Language = $session.system_language].RevnAcctgContractStatusName AS RevnAcctgContractStatusName,
cast(' ' as farr_rai_srcco preserving type) AS RevnAcctgSenderComponent,
cast(' ' as farr_rai_srcls preserving type) AS LogicalSystem,
cast(' ' as boole_d preserving type) AS ReportIsOnlineMode,
_RABusRecnclnContract.SalesDocumentCurrency AS SalesDocumentCurrency,
_RABusRecnclnContract.CompanyCodeCurrency AS CompanyCodeCurrency,
_RABusRecnclnContract.AdditionalCurrency1 AS AdditionalCurrency1,
_RABusRecnclnContract.AdditionalCurrency2 AS AdditionalCurrency2,
cast(_RABusRecnclnContract.OplContractualPrcInSlsDocCrcy as farr_cds_op_cond_price preserving type) AS OplContractualPrcInSlsDocCrcy,
cast(_RABusRecnclnContract.DeltaEffectiveAmtInSlsDocCrcy as farr_contractual_price_org preserving type) AS DeltaEffectiveAmtInSlsDocCrcy,
cast(_RABusRecnclnContract.RAOplCostAmtInSlsDocCrcy as farr_cds_op_cond_cost preserving type) AS RAOplCostAmtInSlsDocCrcy,
cast(_RABusRecnclnContract.TotalInvoicedAmtInSlsDocCrcy as farr_opl_invoiced_amt preserving type) AS TotalInvoicedAmtInSlsDocCrcy,
cast(_RABusRecnclnContract.RAOplCostPriceAmtInSlsDocCrcy as farr_cds_cost_price preserving type) AS RAOplCostPriceAmtInSlsDocCrcy,
cast(_RABusRecnclnContract._Contract.TotContractualPrcInSlsDocCrcy as farr_transaction_price preserving type) AS ContractualPrcInSlsDocCrcy,
cast(_RABusRecnclnContract.RAPerfOblgnCostAmtInSlsDocCrcy as farr_cost_total preserving type) AS RAPerfOblgnCostAmtInSlsDocCrcy,
cast(_RABusRecnclnContract.RADeltaRecgdCostInSlsDocCrcy as farr_actual_cost preserving type) AS RADeltaRecgdCostInSlsDocCrcy,
cast(_RABusRecnclnContract.RARecognizedRevnInSlsDocCrcy as farr_recog_amt preserving type) AS RARecognizedRevnInSlsDocCrcy,
cast(_RABusRecnclnContract.RARecgdCostAmountInSlsDocCrcy as farr_recog_cost preserving type) AS RARecgdCostAmountInSlsDocCrcy,
cast(_RABusRecnclnContract.PerPerdInvoicedAmtInSlsDocCrcy as farr_invoiced_amt preserving type) AS PerPerdInvoicedAmtInSlsDocCrcy,
cast(PostedAmountForContract.PostedRevnInSlsDocCrcy as farr_cds_posted_rv preserving type) AS PostedRevnInSlsDocCrcy,
cast(PostedAmountForContract.PostedInvoiceAmtInSlsDocCrcy as farr_cds_posted_ic preserving type) AS PostedInvoiceAmtInSlsDocCrcy,
cast(PostedAmountForContract.RAPostedCostInSlsDocCrcy as farr_cds_posted_co preserving type) AS RAPostedCostInSlsDocCrcy,
cast(PostedAmountForContract.RAPostedUnbilldRblsAmount as farr_cds_posted_ur preserving type) AS RAPostedUnbilldRblsAmount,
cast(PostedAmountForContract.RADeferredRevenueInSlsDocCrcy as farr_cds_posted_dr preserving type) AS RADeferredRevenueInSlsDocCrcy,
cast(PostedAmountForContract.RAContractAssetsAmount as farr_cds_posted_ca preserving type) AS RAContractAssetsAmount,
cast(PostedAmountForContract.RAContrLiabilitiesAmount as farr_cds_posted_cl preserving type) AS RAContrLiabilitiesAmount,
cast(PostedAmountForContract.PostdDfrrdCostAmtInSlsDocCrcy as farr_cds_posted_cj preserving type) AS PostdDfrrdCostAmtInSlsDocCrcy,
cast(PostedAmountForContract.RAPostedRevenueAmtInCoCodeCrcy as farr_cds_posted_rv_lc1 preserving type) AS RAPostedRevenueAmtInCoCodeCrcy,
cast(PostedAmountForContract.RAPostedInvoiceAmtInCoCodeCrcy as farr_cds_posted_ic_lc1 preserving type) AS RAPostedInvoiceAmtInCoCodeCrcy,
cast(PostedAmountForContract.RAPostedCostAmountInCoCodeCrcy as farr_cds_posted_co_lc1 preserving type) AS RAPostedCostAmountInCoCodeCrcy,
cast(PostedAmountForContract.PostdUnbilldRblAmtInCoCodeCrcy as farr_cds_posted_ur_lc1 preserving type) AS PostdUnbilldRblAmtInCoCodeCrcy,
cast(PostedAmountForContract.PostedDfrrdRevnAmtInCoCodeCrcy as farr_cds_posted_dr_lc1 preserving type) AS PostedDfrrdRevnAmtInCoCodeCrcy,
cast(PostedAmountForContract.RAPostdContrAstAmtInCoCodeCrcy as farr_cds_posted_ca_lc1 preserving type) AS RAPostdContrAstAmtInCoCodeCrcy,
cast(PostedAmountForContract.PostdContrLbltyAmtInCoCodeCrcy as farr_cds_posted_cl_lc1 preserving type) AS PostdContrLbltyAmtInCoCodeCrcy,
cast(PostedAmountForContract.PostdDfrrdCostAmtInCoCodeCrcy as farr_cds_posted_cj_lc1 preserving type) AS PostdDfrrdCostAmtInCoCodeCrcy,
cast(PostedAmountForContract.RAPostedRevenueAmtInAddlCrcy1 as farr_cds_posted_rv_lc2 preserving type) AS RAPostedRevenueAmtInAddlCrcy1,
cast(PostedAmountForContract.RAPostedInvoiceAmtInAddlCrcy1 as farr_cds_posted_ic_lc2 preserving type) AS RAPostedInvoiceAmtInAddlCrcy1,
cast(PostedAmountForContract.RAPostedCostAmountInAddlCrcy1 as farr_cds_posted_co_lc2 preserving type) AS RAPostedCostAmountInAddlCrcy1,
cast(PostedAmountForContract.PostedUnbilldRblAmtInAddlCrcy1 as farr_cds_posted_ur_lc2 preserving type) AS PostedUnbilldRblAmtInAddlCrcy1,
cast(PostedAmountForContract.RAPostdDfrrdRevnAmtInAddlCrcy1 as farr_cds_posted_dr_lc2 preserving type) AS RAPostdDfrrdRevnAmtInAddlCrcy1,
cast(PostedAmountForContract.RAPostedContrAstAmtInAddlCrcy1 as farr_cds_posted_ca_lc2 preserving type) AS RAPostedContrAstAmtInAddlCrcy1,
cast(PostedAmountForContract.PostedContrLbltyAmtInAddlCrcy1 as farr_cds_posted_cl_lc2 preserving type) AS PostedContrLbltyAmtInAddlCrcy1,
cast(PostedAmountForContract.RAPostdDfrrdCostAmtInAddlCrcy1 as farr_cds_posted_cj_lc2 preserving type) AS RAPostdDfrrdCostAmtInAddlCrcy1,
cast(PostedAmountForContract.RAPostedRevenueAmtInAddlCrcy2 as farr_cds_posted_rv_lc3 preserving type) AS RAPostedRevenueAmtInAddlCrcy2,
cast(PostedAmountForContract.RAPostedInvoiceAmtInAddlCrcy2 as farr_cds_posted_ic_lc3 preserving type) AS RAPostedInvoiceAmtInAddlCrcy2,
cast(PostedAmountForContract.RAPostedCostAmountInAddlCrcy2 as farr_cds_posted_co_lc3 preserving type) AS RAPostedCostAmountInAddlCrcy2,
cast(PostedAmountForContract.PostedUnbilldRblAmtInAddlCrcy2 as farr_cds_posted_ur_lc3 preserving type) AS PostedUnbilldRblAmtInAddlCrcy2,
cast(PostedAmountForContract.RAPostdDfrrdRevnAmtInAddlCrcy2 as farr_cds_posted_dr_lc3 preserving type) AS RAPostdDfrrdRevnAmtInAddlCrcy2,
cast(PostedAmountForContract.RAPostedContrAstAmtInAddlCrcy2 as farr_cds_posted_ca_lc3 preserving type) AS RAPostedContrAstAmtInAddlCrcy2,
cast(PostedAmountForContract.PostedContrLbltyAmtInAddlCrcy2 as farr_cds_posted_cl_lc3 preserving type) AS PostedContrLbltyAmtInAddlCrcy2,
cast(PostedAmountForContract.RAPostdDfrrdCostAmtInAddlCrcy2 as farr_cds_posted_cj_lc3 preserving type) AS RAPostdDfrrdCostAmtInAddlCrcy2,
cast(_RABusRecnclnContract.SrceRecgdRevnAmtInSlsDocCrcy as farr_sched_rv_cumltv preserving type) AS SrceRecgdRevnAmtInSlsDocCrcy,
cast(_RABusRecnclnContract.SrceRecgdCostAmtInSlsDocCrcy as farr_sched_co_cumltv preserving type) AS SrceRecgdCostAmtInSlsDocCrcy,
cast(_RABusRecnclnContract.SrceRecgdInvcAmtInSlsDocCrcy as farr_sched_ic_cumltv preserving type) AS SrceRecgdInvcAmtInSlsDocCrcy,
_RABusRecnclnContract.ContractualPriceCriticality AS ContractualPriceCriticality,
_RABusRecnclnContract.TotalCostCriticality AS TotalCostCriticality,
_RABusRecnclnContract.InvoicedAmountCriticality AS InvoicedAmountCriticality,
_RABusRecnclnContract.OrderQuantityCriticality AS OrderQuantityCriticality,
_RABusRecnclnContract.ActualCostCriticality AS ActualCostCriticality,
cast(_RABusRecnclnContract.RAContractIsInconsistent as farr_inconsistency_error preserving type) AS RAContractIsInconsistent,
_DataValidationContract.DataValidationHasError AS DataValidationHasError,
_DataValidationContract.ValidationDateTime AS ValidationDateTime,
cast(' ' as farr_operational_doc preserving type) AS RevnAcctgOperationalDocument,
_RABusRecnclnContract._Contract.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted,
_RABusRecnclnContract._Contract AS _Contract,
_RABusRecnclnContract._CompanyCode AS _CompanyCode,
_RABusRecnclnContract._AccountingPrinciple AS _AccountingPrinciple
FROM P_RABusRecnclnForContract AS _RABusRecnclnContract
LEFT OUTER JOIN I_LogicalSystem AS _LogicalSystem ON LogicalSystem = _LogicalSystem.LogicalSystem -- association [1..1]
LEFT OUTER JOIN I_RevnAcctgSenderComponent AS _RevnAcctgSenderComponent ON RevnAcctgSenderComponent = _RevnAcctgSenderComponent.RevnAcctgSenderComponent -- association [1..1]
;