C_RAContrWithPostedBalance

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 C_RAContrWithPostedBalance.
-- 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 C_RAContrWithPostedBalance AS
SELECT
  RevenueAccountingContract,
  RevnAcctgContractDescription,
  CompanyCode,
  AccountingPrinciple,
  BusinessPartner,
  I_RAContrWithPostedBalance._BusinessPartner.BusinessPartnerName AS BusinessPartnerName,
  Customer,
  I_RAContrWithPostedBalance._Customer.CustomerName AS CustomerName,
  TotContractualPrcInSlsDocCrcy,
  cast(UpToCurPeriodRecognizedRevenue + RAContrCatchUpAmtInSlsDocCrcy as farr_recog_amt) AS UpToCurPeriodRecognizedRevenue,
  cast(PostedRevnInSlsDocCrcy as farr_post_price) AS PostedRevnInSlsDocCrcy,
  cast(RAContrLiabilitiesAmount as farr_posted_clt) AS RAContrLiabilitiesAmount,
  cast(RAContractAssetsAmount as farr_posted_cat preserving type) AS RAContractAssetsAmount,
  cast(RAPostedUnbilldRblsAmount as farr_posted_urt preserving type) AS RAPostedUnbilldRblsAmount,
  cast(RADeferredRevenueInSlsDocCrcy as farr_posted_drt) AS RADeferredRevenueInSlsDocCrcy,
  cast(RAReceivablesAmtInSlsDocCrcy as farr_receivable) AS RAReceivablesAmtInSlsDocCrcy,
  cast(RABilledRblsAmtInSlsDocCrcy as farr_billed_rbl preserving type) AS RABilledRblsAmtInSlsDocCrcy,
  cast(RAUnbilledRblsAmount as farr_unbill_rbl) AS RAUnbilledRblsAmount,
  NumberOfPerformanceObligations,
  AllocEffctAmountInSalesDocCrcy,
  RAContractHasAssetsImpairment,
  RevnAcctgContractStatus,
  RevnAcctgContractStatusName,
  RAContractCompletionDate,
  SalesDocumentCurrency,
  RevnAcctgSalesOrganization,
  RAContractHasAllocationEffect,
  RevnAcctgContractCreatedByUser,
  RevnAcctgContractCreationDate,
  RAContractLastChangedByUsr,
  RAContractLastChangeDate,
  RAContractVersionCode,
  RAContractHasPostponedItem
FROM I_RAContrWithPostedBalance
LEFT OUTER JOIN C_RAPerfOblgnWithToCurPerdAmt AS _RAPerfOblgnWithToCurPerdAmt ON RevenueAccountingContract = _RAPerfOblgnWithToCurPerdAmt.RevenueAccountingContract  -- association [0..*]
;