C_IntrastatSCByLanguage

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 C_IntrastatSCByLanguage.
-- 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: CISSRVCCDBYLANG

CREATE VIEW C_IntrastatSCByLanguage AS
SELECT
  _Language.Language AS Language,
  IntrastatServiceCode.TrdClassfctnNmbrSchmCntnt AS TrdClassfctnNmbrSchmCntnt,
  IntrastatServiceCode,
  IntrastatServiceCode.ValidityStartDate AS ValidityStartDate,
  IntrastatServiceCode.ValidityEndDate AS ValidityEndDate,
  TrdClassfctnNmbrForOfclDesc,
  TrdClassfctnNmbrForCnctntdDesc,
  CreatedByUser,
  CreationDateTime,
  LastChangedByUser,
  LastChangeDateTime
FROM I_IntrastatServiceCode AS IntrastatServiceCode
CROSS JOIN I_Language AS _Language
LEFT OUTER JOIN I_TrdClassfctnNmbrOfclDescByLa AS _OfficialDescOnLanguage ON _OfficialDescOnLanguage.TrdClassfctnNmbrSchmCntnt = TrdClassfctnNmbrSchmCntnt AND _OfficialDescOnLanguage.TrdClassfctnNmbr = IntrastatServiceCode AND _OfficialDescOnLanguage.ValidityStartDate = ValidityStartDate AND _OfficialDescOnLanguage.Language = _Language.Language  -- association [0..1]
LEFT OUTER JOIN I_TrdClassfctnNmbrCoDescByLa AS _CnctntdDescOnLanguage ON _CnctntdDescOnLanguage.TrdClassfctnNmbrSchmCntnt = TrdClassfctnNmbrSchmCntnt AND _CnctntdDescOnLanguage.TrdClassfctnNmbr = IntrastatServiceCode AND _CnctntdDescOnLanguage.ValidityStartDate = ValidityStartDate AND _CnctntdDescOnLanguage.Language = _Language.Language  -- association [0..1]
;