I_RevnAcctgReconciliationKey

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_RevnAcctgReconciliationKey.
-- 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_RevnAcctgReconciliationKey AS
SELECT
  company_code AS CompanyCode,
  acct_principle AS AccountingPrinciple,
  cast(contract_id as farr_cds_contract_id preserving type) AS RevenueAccountingContract,
  recon_key AS RevnAcctgReconciliationKey,
  substring(recon_key, 1, 7) AS FiscalYearPeriod,
  gjahr AS FiscalYear,
  poper AS FiscalPeriod,
  status AS RevnAcctgRecnclnKeyStatus,
  pro_split_date AS RAProspectiveSplitDate,
  runid AS RARecnclnKeyRunID,
  keypp AS RAParallelizationSubareaValue,
  created_by AS RARecnclnKeyCreatedByUser,
  created_on AS RARecnclnKeyCreationDateTime,
  last_changed_by AS RARecnclnKeyChangedByUser,
  last_changed_on AS RARecnclnKeyLastChangeDateTime,
  liab_asset_flag AS RAContrLiabilityAssetIsCalcd,
  value_date AS ContrLiabilityAssetValueDate,
  awtyp AS OriginalReferenceDocumentType,
  awsys AS ReferenceDocumentLogicalSystem,
  aworg AS ReferenceDocumentContext,
  awref AS ReferenceDocument
FROM farr_d_recon_key
LEFT OUTER JOIN I_RevenueAccountingContract AS _RevenueAccountingContract ON RevenueAccountingContract = _RevenueAccountingContract.RevenueAccountingContract  -- association [1..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_RAReconciliationKeyStatus AS _RAReconciliationKeyStatus ON RevnAcctgRecnclnKeyStatus = _RAReconciliationKeyStatus.RevnAcctgRecnclnKeyStatus  -- association [1..1]
LEFT OUTER JOIN I_User AS _ChangedByUser ON RARecnclnKeyChangedByUser = _ChangedByUser.UserID  -- association [1..1]
LEFT OUTER JOIN I_User AS _CreatedByUser ON RARecnclnKeyCreatedByUser = _CreatedByUser.UserID  -- association [1..1]
;