FAC_AUDIT_Z3_MATERIAL_CHGDOC

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_AUDIT_Z3_MATERIAL_CHGDOC.
-- 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_DZMATHGD
-- Parameters: P_Ledger : fins_ledger, P_FiscalYear : fins_gjahr, P_FromFiscalPeriod : fins_fagl_fiscper_from, P_ToFiscalPeriod : fins_fagl_fiscper_to, P_Language : sylangu

CREATE VIEW FAC_AUDIT_Z3_MATERIAL_CHGDOC AS
SELECT
  _cocod.CompanyCode AS CompanyCode,
  ChangeLog.Material AS Material,
  ChangeDocObject,
  ChangeDocument,
  ChangeDocDatabaseTableField,
  ChangeDocItemChangeType,
  ChangeDocObjectClass,
  DatabaseTable,
  ChangeDocTableKey,
  _ChgDocItemChangeTypeText[1: Language = $parameters.P_Language].ChangeDocItemChangeTypeText AS ChangeDocItemChangeTypeText,
  _ChangeLogDatabaseTableText[1: Language = $parameters.P_Language].DatabaseTableText AS DatabaseTableText,
  _ChangeDocFieldNames[1: Language = $parameters.P_Language].Text AS Text,
  ChangeDocPreviousUnit,
  ChangeDocNewUnit,
  ChangeDocPreviousCurrency,
  ChangeDocNewCurrency,
  ChangeDocNewFieldValue,
  ChangeDocPreviousFieldValue,
  CreatedByUser,
  CreationDate,
  CreationTime,
  ChangeDocLanguage,
  _ChangeDocument._ChangeDocLanguage._Text[1: Language = $parameters.P_Language].LanguageName AS LanguageName,
  ChangeDocTextIsChanged,
  I_LedgerCompanyCodeCrcyRoles.FiscalYearVariant AS FiscalYearVariant,
  cast ( $session.client as char3 ) AS SystemClient
FROM FAC_AUDIT_Z3_Material_CHGDOC_B AS ChangeLog
INNER JOIN FAC_AUDIT_Z3_Material_Cocod AS _cocod ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_LedgerCompanyCodeCrcyRoles ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_Material AS _Material ON ChangeLog.Material = _Material.Material  -- association [1..1]
LEFT OUTER JOIN I_ChangeLogDatabaseTableText AS _ChangeLogDatabaseTableText ON ChangeLog.DatabaseTable = _ChangeLogDatabaseTableText.DatabaseTable  -- association [0..*]
LEFT OUTER JOIN I_ChangeDocFieldNames AS _ChangeDocFieldNames ON ChangeLog.DatabaseTable = _ChangeDocFieldNames.DatabaseTable AND ChangeLog.ChangeDocDatabaseTableField = _ChangeDocFieldNames.Value  -- association [0..*]
LEFT OUTER JOIN I_ChgDocItemChangeTypeText AS _ChgDocItemChangeTypeText ON ChangeLog.ChangeDocItemChangeType = _ChgDocItemChangeTypeText.ChangeDocItemChangeType  -- association [0..*]
LEFT OUTER JOIN I_FiscalPeriodForVariant AS _ToFiscalPeriodForVariant ON _ToFiscalPeriodForVariant.FiscalYearVariant = FiscalYearVariant AND _ToFiscalPeriodForVariant.FiscalYear = $parameters.P_FiscalYear AND _ToFiscalPeriodForVariant.FiscalPeriod = $parameters.P_ToFiscalPeriod  -- association [0..1]
LEFT OUTER JOIN I_FiscalPeriodForVariant AS _FromFiscalPeriodForVariant ON _FromFiscalPeriodForVariant.FiscalYearVariant = FiscalYearVariant AND _FromFiscalPeriodForVariant.FiscalYear = $parameters.P_FiscalYear AND _FromFiscalPeriodForVariant.FiscalPeriod = $parameters.P_FromFiscalPeriod  -- association [0..1]
;