P_UnrealizedDiffAgg

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_UnrealizedDiffAgg.
-- 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.
-- SQL view name: PUNREALZDIFFAGG
-- Parameters: P_KeyDate : sydate, P_Future : sydate

CREATE VIEW P_UnrealizedDiffAgg AS
SELECT
  SourceLedger,
  _flow.CompanyCode AS CompanyCode,
  FiscalYear,
  AccountingDocument,
  LedgerGLLineItem,
  Ledger,
  LogicalSystem AS OriginSystem,
  cast('BSEGV' as fqm_origin_application) AS OriginApplication,
  cast(concat(AccountingDocument, concat(_flow.CompanyCode, FiscalYear)) as fqm_origin_doc_id) AS OriginDocument,
  cast('' as fqm_origin_trans_id) AS OriginTransaction,
  cast('' as fqm_origin_trans_qualifier) AS OriginTransactionQualifier,
  cast(AccountingDocumentItem as fqm_origin_flow_id) AS CashFlow,
  CompanyCodeCurrency AS BaseCurrency,
  AmountInCompanyCodeCurrency AS BaseAmount,
  TransactionCurrency AS Currency,
  AmountInTransactionCurrency AS Amount,
  coalesce(_bam.BankAccountCurrency, TransactionCurrency) AS BankAccountCurrency,
  cast(0 as fqm_amount) AS AmountInAccountCurrency,
  cast('ACTUAL' as fqm_certainty_level) AS CertaintyLevel,
  AccountingDocumentItem,
  AccountingDocumentType AS FIDocumentType,
  AccountingDocCreatedByUser AS CreatedByUser,
  FiscalPeriod,
  GLAccount,
  FinancialAccountType,
  DocumentItemText,
  CashPlanningGroup,
  PlanningLevel,
  cast('' as fqm_payment_method) AS PaymentMethod,
  HouseBank,
  HouseBankAccount,
  coalesce(_flow.BankAccountInternalID, cast('0000000000' as fclm_bam_acc_id)) AS BankAccountId,
  Customer,
  Supplier,
  PartnerCompany AS TradingPartner,
  Material,
  _flow.BusinessArea AS BusinessArea,
  _flow.ProfitCenter AS ProfitCenter,
  CostCenter,
  _flow.Segment AS Segment,
  LiquidityItem,
  _flow.WBSElementInternalID AS WBSElementInternalID,
  _flow.WBSElementExternalID AS WBSElementExternalID,
  Fund,
  GrantID,
  cast('' as bu_partner) AS BusinessPartner,
  cast('' as bukrs) AS SourceCompanyCode,
  coalesce(Bank, cast('' as fclm_bam_bank_key)) AS Bank,
  coalesce(BankCountry, cast('' as fclm_bam_bank_country_key)) AS BankCountry,
  coalesce(BankAccountNumber, cast('' as fclm_bam_acc_num)) AS BankAccount,
  coalesce(BankAccountType, cast('' as fclm_bam_bk_acc_type_id)) AS BankAccountType,
  coalesce(IBAN, cast('' as iban)) AS IBAN,
  case when AmountInCompanyCodeCurrency > 0 then '+' else '-' end AS direction
FROM P_UnrealizedCrcyDiff AS _flow
;