I_RevenueAccountingContract

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_RevenueAccountingContract.
-- 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_RevenueAccountingContract AS
SELECT
  cast(contract_id as farr_cds_contract_id preserving type) AS RevenueAccountingContract,
  company_code AS CompanyCode,
  description AS RevnAcctgContractDescription,
  cast(trx_price as farr_cds_contractual_price preserving type ) AS TotContractualPrcInSlsDocCrcy,
  contract_cat AS RevnAcctgContractCategory,
  sales_org AS RevnAcctgSalesOrganization,
  cast(alloc_differ as farr_corr_amt preserving type) AS AllocEffctAmountInSalesDocCrcy,
  acct_principle AS AccountingPrinciple,
  cast(num_of_pob as farr_cds_num_of_pobs preserving type) AS NumberOfPerformanceObligations,
  trx_price_curk AS SalesDocumentCurrency,
  partner AS BusinessPartner,
  customer_id AS Customer,
  customer_grp AS CustomerGroup,
  cast(price_adjusted as farr_cds_has_alloc_effect preserving type) AS RAContractHasAllocationEffect,
  liab_method AS RAContrBalanceDerivationRule,
  liability_post_mode AS RAPostLevelOfContractBalance,
  status AS RevnAcctgContractStatus,
  cast(completion_date as farr_cds_contr_completion_date preserving type ) AS RAContractCompletionDate,
  cast(asset_impairment_date as farr_cds_asset_impairment_date preserving type) AS RevnContrAssetsImpairmentDate,
  cast(created_by as fis_cc_erfnm preserving type) AS RevnAcctgContractCreatedByUser,
  cast(created_on as farr_cds_created_on preserving type) AS RevnAcctgContractCreationDate,
  cast(last_changed_by as fis_aufaenam preserving type) AS RAContractLastChangedByUsr,
  soft_deleted AS RAContractIsSoftDeleted,
  last_changed_on AS RAContractLastChangeDate,
  last_saved_on AS RAContractLastSavedDateTime,
  recei_adj_account AS RAContractReceivableAdjmtAcct,
  asset_account AS RAContractAssetAccount,
  liability_account AS RAContractLiabilityAccount,
  manual_changed AS RAContractIsManuallyChanged,
  cast(manual_allocated as farr_cds_manual_price_alloc preserving type ) AS RAContractIsManuallyAllocated,
  cast(manual_price_alloc_conflict as farr_cds_has_alloc_conflict preserving type) AS RAContrHasMnlPrcAllocConflict,
  cast( 'RARC' as val_obj_type preserving type ) AS FinancialValuationObjectType,
  cast( contract_id as val_obj_id) AS FinancialValuationObject,
  cast( '' as val_subobj_id ) AS FinancialValuationSubobject,
  rar_version_code AS RAContractVersionCode,
  is_blocked AS IsBusinessPurposeCompleted,
  ccm_ocm_recon_key AS RAContractTransformRecnclnKey,
  posting_mode AS RAContractPostingMode,
  universal_rev_contr AS RAContractIsUniversal
FROM farr_d_contract
LEFT OUTER JOIN I_BusinessPartner AS _BusinessPartner ON BusinessPartner = _BusinessPartner.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _Customer ON Customer = _Customer.Customer  -- association [0..1]
LEFT OUTER JOIN I_CustomerGroup AS _CustomerGroup ON CustomerGroup = _CustomerGroup.CustomerGroup  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_AccountingPrinciple AS _AccountingPrinciple ON AccountingPrinciple = _AccountingPrinciple.AccountingPrinciple  -- association [1..1]
LEFT OUTER JOIN I_RAContractCategory AS _RAContractCategory ON RevnAcctgContractCategory = _RAContractCategory.RevnAcctgContractCategory  -- association [1..1]
LEFT OUTER JOIN I_Currency AS _Currency ON SalesDocumentCurrency = _Currency.Currency  -- association [0..1]
LEFT OUTER JOIN I_SalesOrganization AS _SalesOrganization ON RevnAcctgSalesOrganization = _SalesOrganization.SalesOrganization  -- association [0..1]
LEFT OUTER JOIN I_RAContrBalanceDerivationRule AS _BalanceDerivationRule ON RAContrBalanceDerivationRule = _BalanceDerivationRule.RAContrBalanceDerivationRule  -- association [0..1]
LEFT OUTER JOIN I_RAPostLevelOfContractBalance AS _PostLevel ON RAPostLevelOfContractBalance = _PostLevel.RAPostLevelOfContractBalance  -- association [0..1]
LEFT OUTER JOIN I_RAContractStatus AS _RAContractStatus ON RevnAcctgContractStatus = _RAContractStatus.RevnAcctgContractStatus  -- association [1..1]
LEFT OUTER JOIN I_RAContrManagementVersion AS _RAContrMgmtVersion ON RAContractVersionCode = _RAContrMgmtVersion.RAContractVersionCode  -- association [1..1]
LEFT OUTER JOIN I_User AS _CreatedByUser ON RevnAcctgContractCreatedByUser = _CreatedByUser.UserID  -- association [1..1]
LEFT OUTER JOIN I_User AS _ChangedByUser ON RAContractLastChangedByUsr = _ChangedByUser.UserID  -- association [1..1]
;