I_CashPositionProfileBasic

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_CashPositionProfileBasic.
-- 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_CashPositionProfileBasic AS
SELECT
  Main.profile_name AS CashPositionProfile,
  Main.prof_description AS CashPositionProfileDescription,
  Main.hierarchy_source AS CashPositionHierSource,
  Main.hierarchy_level1 AS CashPositionHierLevel1,
  Main.hierarchy_level2 AS CashPositionHierLevel2,
  Main.hierarchy_level3 AS CashPositionHierLevel3,
  Main.bank_acc_hierarchy_id AS BankAccountHierarchyName,
  Main.balance_type AS CashBalanceType,
  Main.balance_category AS CashPositionBalanceCategory,
  Main.view_category AS CashPositionViewCategory,
  Main.step_rhythm AS CashPositionPrdfndIncrement,
  Main.step_unit AS CashPositionPrdfndInterimStep,
  Main.period_end AS CashPositionPeriodEndIsNatural,
  Main.show_overdue AS CashPositionOverdueIsVisible,
  Main.include_overdue_in_closing AS CashPositionOvrdIsIncldInClsg,
  Main.shift_option AS CashPositionShiftOption,
  Main.factory_calendar AS FactoryCalendar,
  Main.display_currency AS DisplayCurrency,
  Main.exchange_rate_type AS ExchangeRateType,
  Main.need_root_node AS CashPositionRootNodeIsNeeded,
  Main.root_node AS CashPositionRootNode,
  Main.show_future AS CashPositionFutureIsVisible,
  Main.enable_smart_currency AS CashPositionSmartCrcyIsEnabled,
  Main.display_embed_csh_pos_det_view AS EmbeddedCshPosDetViewIsVisible,
  Main.consider_intraday_recncln_rslt AS IntradayRecnclnRsltIsConsdrd,
  Main.consider_endofday_recncln_rslt AS EndOfDayRecnclnRsltIsConsdrd,
  Main.created_by AS CreatedByUser,
  Main.created_at AS CreationDateTime,
  Main.last_changed_by AS LastChangedByUser,
  Main.last_changed_at AS LastChangeDateTime,
  Main.allow_key_date_in_the_past AS CshPosKeyDteInThePastIsAllowed
FROM fclm_cp_prof AS Main
;