FAC_DART_Z3_SPECIALGL

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 FAC_DART_Z3_SPECIALGL.
-- 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: FAC_DZSPECIALGL
-- Parameters: P_Language : sylangu

CREATE VIEW FAC_DART_Z3_SPECIALGL AS
SELECT
  umskz AS SpecialGLCode,
  koart AS FinancialAccountType,
  umsks AS SpecialGLTransactionType,
  klimp AS CreditLimitIsChecked,
  merkp AS IsNotedItmWithoutBalUpdt,
  _Text[1: Language = $parameters.P_Language].SpecialGLCodeName AS SpecialGLCodeName,
  _Text[1: Language = $parameters.P_Language].SpecialGLCodeLongName AS SpecialGLCodeLongName,
  mandt AS SystemClient,
  zumkz AS IndTargetSpecialGLFromReq,
  diams AS IndSendWarningMsgIfBalaExist
FROM t074u
LEFT OUTER JOIN I_SpecialGLCodeText AS _Text ON FinancialAccountType = _Text.FinancialAccountType AND SpecialGLCode = _Text.SpecialGLCode  -- association [0..*]
LEFT OUTER JOIN I_FinancialAccountType AS _FinancialAccountType ON FinancialAccountType = _FinancialAccountType.FinancialAccountType  -- association [1..1]
;