C_RAContrWithPostedBalanceTP

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_RAContrWithPostedBalanceTP.
-- 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_RAContrWithPostedBalanceTP AS
SELECT
  RAContract.RevenueAccountingContract AS RevenueAccountingContract,
  RAContract.RevnAcctgContractDescription AS RevnAcctgContractDescription,
  RAContract.CompanyCode AS CompanyCode,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  RAContract.AccountingPrinciple AS AccountingPrinciple,
  _AccountingPrinciple._Text[1:Language =$session.system_language].AccountingPrincipleName AS AccountingPrincipleName,
  RAContract.BusinessPartner AS BusinessPartner,
  RAContract.BusinessPartnerName AS BusinessPartnerName,
  RAContract.Customer AS Customer,
  RAContract.CustomerName AS CustomerName,
  RAContract.TotContractualPrcInSlsDocCrcy AS TotContractualPrcInSlsDocCrcy,
  RAContract.RAContrBalanceIsDfrrdRevn AS RAContrBalanceIsDfrrdRevn,
  RAContract.RAContrBalanceIsLiability AS RAContrBalanceIsLiability,
  cast(_RAContractRev2CurPerd.UpToCurPeriodRecognizedRevenue as farr_recog_amt) AS UpToCurPeriodRecognizedRevenue,
  cast(_RAContrPostedAmt.PostedRevnInSlsDocCrcy as farr_post_price) AS PostedRevnInSlsDocCrcy,
  cast(RAContract.SuspendedRevnAmtInSlsDocCrcy as farr_cds_suspended_revenue) AS SuspendedRevnAmtInSlsDocCrcy,
  cast(RAContract.SuspendedCostAmtInSlsDocCrcy as farr_cds_suspended_cost) AS SuspendedCostAmtInSlsDocCrcy,
  cast(_RAContrPostedAmt.RAContrLiabilitiesAmount as farr_posted_clt) AS RAContrLiabilitiesAmount,
  cast(_RAContrPostedAmt.RAContractAssetsAmount as farr_posted_cat) AS RAContractAssetsAmount,
  cast(_RAContrPostedAmt.RAPostedUnbilldRblsAmount as farr_posted_urt) AS RAPostedUnbilldRblsAmount,
  cast(_RAContrPostedAmt.RADeferredRevenueInSlsDocCrcy as farr_posted_drt) AS RADeferredRevenueInSlsDocCrcy,
  cast(_RAContrPostedAmt.RAReceivablesAmtInSlsDocCrcy as farr_receivable) AS RAReceivablesAmtInSlsDocCrcy,
  cast(_RAContrPostedAmt.RABilledRblsAmtInSlsDocCrcy as farr_billed_rbl) AS RABilledRblsAmtInSlsDocCrcy,
  cast(_RAContrPostedAmt.RAUnbilledRblsAmount as farr_unbill_rbl) AS RAUnbilledRblsAmount,
  cast(_RAContrPostedAmt.RARblAdjustmentAmtInSlsDocCrcy as farr_cds_rbl_adjmt_amt) AS RARblAdjustmentAmtInSlsDocCrcy,
  RAContract.NumberOfPerformanceObligations AS NumberOfPerformanceObligations,
  RAContract.AllocEffctAmountInSalesDocCrcy AS AllocEffctAmountInSalesDocCrcy,
  RAContract.RevnContrAssetsImpairmentDate AS RevnContrAssetsImpairmentDate,
  RAContract.RAContractHasAssetsImpairment AS RAContractHasAssetsImpairment,
  RAContract.RevnAcctgContractStatus AS RevnAcctgContractStatus,
  RAContract.RevnAcctgContractStatusName AS RevnAcctgContractStatusName,
  RAContract.RAContractPostingMode AS RAContractPostingMode,
  RAContract.RAContractPostingModeName AS RAContractPostingModeName,
  RAContract.RAContractStatusCriticality AS RAContractStatusCriticality,
  RAContract.RAContractCompletionDate AS RAContractCompletionDate,
  RAContract.SalesDocumentCurrency AS SalesDocumentCurrency,
  RAContract.RevnAcctgSalesOrganization AS RevnAcctgSalesOrganization,
  RAContract.RAContractHasAllocationEffect AS RAContractHasAllocationEffect,
  RAContract.RevnAcctgContractCreatedByUser AS RevnAcctgContractCreatedByUser,
  RAContract.CreatedByUserDescription AS CreatedByUserDescription,
  RAContract.RevnAcctgContractCreationDate AS RevnAcctgContractCreationDate,
  RAContract.RAContractLastChangedByUsr AS RAContractLastChangedByUsr,
  RAContract.LastChangedByUserDescription AS LastChangedByUserDescription,
  RAContract.RAContractLastChangeDate AS RAContractLastChangeDate,
  RAContract.RAContractVersionCode AS RAContractVersionCode,
  RAContract.RAContractIsSoftDeleted AS RAContractIsSoftDeleted,
  RAContract.RAContrManualChgBusinessReason AS RAContrManualChgBusinessReason,
  RAContract.HasAttachment AS HasAttachment,
  RAContract.RAContractHasCompoundPerfOblgn AS RAContractHasCompoundPerfOblgn,
  RAContractIsManuallyAllocated,
  RAContrHasMnlPrcAllocConflict,
  RAAttributeHasConflict,
  PerfOblgnHasSprdgConflict,
  PerfOblgnHasManualSpreading,
  _RAContrPostedAmt.RAContrLiabilityAssetIsPosted AS RAContrLiabilityAssetIsPosted,
  IsBusinessPurposeCompleted,
  RARevnLbltyAssetCalcIsEnabled,
  RARevenuePostIsEnabled,
  FiscalYear,
  FiscalPeriod,
  RAContractHasPostponedItem,
  RAContract.RAContractIsUniversal AS RAContractIsUniversal,
  RAContract.RAContrIsNotActvUnivRevnRecgn AS RAContrIsNotActvUnivRevnRecgn
FROM I_RAContrWithPostedBalanceTP AS RAContract
LEFT OUTER JOIN C_RAPerfOblgnWthToCurPerdAmtTP AS _RAPerfOblgnWithToCurPerdAmt ON RevenueAccountingContract = _RAPerfOblgnWithToCurPerdAmt.RevenueAccountingContract  -- association [0..*]
;