I_BalShtExpsrSnpshtItm

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_BalShtExpsrSnpshtItm.
-- 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: IBSESNPSHTITM

CREATE VIEW I_BalShtExpsrSnpshtItm AS
SELECT
  SnapItem.snap_id AS BalShtExpsrSnapshotID,
  SnapItem.snap_item_id AS BalShtExpsrSnpshtItmID,
  SnapItem.company_code AS CompanyCode,
  SnapItem.on_behalf_of_company AS OnBehalfOfCompany,
  SnapItem.keyfigure_id AS BalSheetExpsrKeyFigure,
  SnapItem.group_currency AS GroupCurrency,
  SnapItem.risk_free_currency AS RiskFreeCurrency,
  SnapItem.amount_in_group_currency AS AmountInGroupCurrency,
  cast(SnapItem.amount as bse_snap_sht_ite_amt preserving type ) AS BalShtExpsrSnpshtItmAmt,
  SnapItem.currency AS Currency,
  cast(SnapItem.period_start as bse_snap_itm_perd_start_dte preserving type ) AS BalShtExpsrSnapItmPerdStrtDte,
  cast(SnapItem.period_end as bse_snap_itm_perd_end_dte preserving type ) AS BalShtExpsrSnapItmPerdEndDate,
  SnapItem.manual_or_automatic AS BalShtExpsrSnpshtItmGnrtdMeth,
  cast(SnapItem.last_change_timestamp as snp_sht_item_last_changed_time preserving type ) AS SnpshtItmLastChangedDateTime,
  cast(SnapItem.last_change_user as snp_sht_item_last_changed_by preserving type ) AS SnapshotItemLastChangedByUser,
  SnapItem.fi_account AS GLAccount,
  SnapItem.fi_chart_of_account AS ChartOfAccounts,
  SnapItem.planning_level AS PlanningLevel,
  SnapItem.certainty_level AS CertaintyLevel,
  SnapItem.liquidity_item AS LiquidityItem,
  cast(SnapItem.create_user as snp_sht_item_created_by preserving type ) AS SnapshotItemCreatedByUser,
  cast(SnapItem.create_timestamp as bse_snap_sht_itm_created_time preserving type ) AS BalShtExpsrSnpshtItmCrteDteTme,
  SnapItem.trm_product_type AS FinancialInstrumentProductType,
  SnapItem.trm_transaction_type AS FinancialInstrTransactionType,
  SnapItem.trm_portfolio AS Portfolio,
  SnapItem.description AS BalShtExpsrSnpshtItmDesc
FROM fxm_snap_item AS SnapItem
;