FINCS_MD_TF16X

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 FINCS_MD_TF16X.
-- 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: FINCSMDTF16X
-- Parameters: P_FiscalYear : fc_ryear, P_FiscalPeriod : fc_perid, P_Language : spras

CREATE VIEW FINCS_MD_TF16X AS
SELECT
  _CU.ConsolidationDimension AS ConsolidationDimension,
  _CU.ConsolidationUnit AS ConsolidationUnit,
  ConsolidationLedger,
  _Version.rvers AS ConsolidationVersion,
  cast(concat(concat(:P_FiscalYear, '/'), :P_FiscalPeriod) as fincs_fiscalyearperiod) AS FiscalYearPeriod,
  :P_Language AS Language,
  _CU._Text[1: Language=:P_Language].ConsolidationUnitText AS ConsolidationUnitText,
  _CU._Text[1: Language=:P_Language].ConsolidationUnitMdmText AS ConsolidationUnitMdmText,
  _CU.Country AS Country,
  _CU.DocumentEntryIsInGroupCurrency AS DocumentEntryIsInGroupCurrency,
  ConsolidationUnitLocalCurrency,
  _tf165.trans AS CnsldtnDataTransferMethod,
  case _tf165.trans when 'U' then _tf165.upmeth else '' end as CnsldtnUploadMethod AS upmethelseendasCnsldtnUploadMethod,
  _tf168.periv AS FiscalYearVariant,
  CnsldtnCrcyTranslationMethod,
  TaxRate
FROM I_CnsldtnUnit AS _CU
CROSS JOIN tf200 AS _Version
CROSS JOIN I_CnsldtnLedger AS _Ledger
LEFT OUTER JOIN FINCS_MD_TF164_FY ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN FINCS_MD_TF167_FYP ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN FINCS_MD_TF169_FYP ON /* join condition not captured in parsed metadata */
;