V_FDES_DDL

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 V_FDES_DDL.
-- 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: VFDESDDL

CREATE VIEW V_FDES_DDL AS
SELECT
  memo.mandt AS mandt,
  company_code AS BUKRS,
  fi_account AS BNKKO,
  planning_group AS GRUPP,
  planning_level AS EBENE,
  currency AS DISPW,
  transaction_date AS DATUM,
  cast ( lpad(substring(origin_document_id,1,10),10,'0') as idenr) AS IDENR,
  business_area AS GSBER,
  cast( base_amount as dmshw) AS DMSHB,
  amount AS WRSHB,
  cmm_exchange_rate_type AS KURST,
  cmm_inverted_rate_type AS XINVR,
  create_user AS USRID,
  cast( tstmp_to_dats(create_timestamp,'UTC',memo.mandt,'NULL') as hzdat) AS HZDAT,
  last_update_user AS AENUS,
  cast( tstmp_to_dats(last_update_timestamp,'UTC',memo.mandt,'NULL') as aendt) AS AENDT,
  cast(characteristics as merkm) AS MERKM,
  cmm_assignment_number AS ZUONR,
  cast(internal_reference as refer) AS REFER,
  fi_item_text AS SGTXT,
  cmm_offset_account AS GGRUP,
  cast(assigned_company_code as gbukr) AS GBUKR,
  cast(fi_value_date as gvalt) AS GVALT,
  cast(substring(origin_transaction_id_rl,1,18) as ausnr_lg) AS AUSNR,
  cast(lp_planed_payment_date2 as austg) AS AUSTG,
  cmm_transaction_type AS VOART,
  cmm_interest_rate AS ZINSS,
  cmm_calendar_type AS KLART,
  cmm_statistics_indicator AS STKNZ,
  cast(payment_date as sdatm) AS SDATM,
  cmm_payment_group AS KLIDR,
  cmm_reason AS KLGND,
  cmm_auth_rel AS AUTH_REL,
  SEGMENT,
  profit_center AS PRCTR,
  fund AS GEBER,
  GRANT_NBR,
  house_bank AS HBKID,
  house_bank_account AS HKTID,
  cast('' as dzlsch) AS ZLSCH,
  liquidity_item AS LQPOS,
  bank_account_id AS ACC_ID,
  cmm_offset_accid AS GACCID,
  cmm_bs_num_eb AS BS_ESNUM
FROM V_CMMRD AS memo
LEFT OUTER JOIN V_FDES_PLT AS plmstr ON /* join condition not captured in parsed metadata */
;