P_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 P_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 P_RAContrWithPostedBalance AS
SELECT
  I_RevenueAccountingContract.RevenueAccountingContract AS RevenueAccountingContract,
  RevnAcctgContractDescription,
  I_RevenueAccountingContract.CompanyCode AS CompanyCode,
  AccountingPrinciple,
  BusinessPartner,
  Customer,
  TotContractualPrcInSlsDocCrcy,
  cast(0 as farr_recog_amt) AS UpToCurPeriodRecognizedRevenue,
  cast(0 as farr_defitem_rev_amt_catchup) AS RAContrCatchUpAmtInSlsDocCrcy,
  RAContrBalanceDerivationRule,
  cast(0 as farr_amount_tc) AS PostedRevnInSlsDocCrcy,
  cast(0 as farr_amount_tc) AS RAContrLiabilitiesAmount,
  cast(0 as farr_amount_tc) AS RAContractAssetsAmount,
  cast(0 as farr_amount_tc) AS RAPostedUnbilldRblsAmount,
  cast(0 as farr_amount_tc) AS RADeferredRevenueInSlsDocCrcy,
  cast(0 as farr_amount_tc) AS RAReceivablesAmtInSlsDocCrcy,
  cast(0 as farr_amount_tc) AS RABilledRblsAmtInSlsDocCrcy,
  cast(0 as farr_amount_tc) AS RAUnbilledRblsAmount,
  NumberOfPerformanceObligations,
  AllocEffctAmountInSalesDocCrcy,
  I_RevenueAccountingContract.SalesDocumentCurrency AS SalesDocumentCurrency,
  RevnAcctgSalesOrganization,
  RAContractHasAllocationEffect,
  RevnAcctgContractStatus,
  I_RevenueAccountingContract._RAContractStatus._Text[1: Language = $session.system_language].RevnAcctgContractStatusName AS RevnAcctgContractStatusName,
  RAContractCompletionDate,
  RevnContrAssetsImpairmentDate,
  RAContractHasAssetsImpairment,
  RevnAcctgContractCreatedByUser,
  I_RevenueAccountingContract._CreatedByUser.UserDescription AS CreatedByUserDescription,
  RevnAcctgContractCreationDate,
  RAContractLastChangedByUsr,
  I_RevenueAccountingContract._ChangedByUser.UserDescription AS LastChangedByUserDescription,
  RAContractLastChangeDate,
  I_RevenueAccountingContract.RAContractVersionCode AS RAContractVersionCode,
  RAContractIsSoftDeleted,
  I_RevenueAccountingContract._BusinessPartner AS _BusinessPartner,
  I_RevenueAccountingContract._Customer AS _Customer,
  I_RevenueAccountingContract._CompanyCode AS _CompanyCode,
  I_RevenueAccountingContract._AccountingPrinciple AS _AccountingPrinciple,
  I_RevenueAccountingContract._Currency AS _Currency,
  I_RevenueAccountingContract._SalesOrganization AS _SalesOrganization,
  I_RevenueAccountingContract._CreatedByUser AS _CreatedByUser,
  I_RevenueAccountingContract._ChangedByUser AS _ChangedByUser
FROM I_RevenueAccountingContract
;