FAC_AUDIT_Z3_Customer_change

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_Customer_change.
-- 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_AUDCUSTCHG
-- 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_Customer_change AS
SELECT
  Customer,
  ChangeLog.CompanyCode AS CompanyCode,
  ChangeDocObject,
  ChangeDocument,
  ChangeDocDatabaseTableField,
  ChangeDocItemChangeType,
  ChangeDocObjectClass,
  DatabaseTable,
  ChangeDocTableKey,
  _ChgDocItemChangeTypeText[1: Language = $parameters.P_Language].ChangeDocItemChangeTypeText AS ChangeDocItemChangeTypeText,
  ChangeTransactionCode,
  _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_Customer_change_p AS ChangeLog
LEFT OUTER JOIN I_LedgerCompanyCodeCrcyRoles ON /* join condition not captured in parsed metadata */
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_CustomerCompany AS _CustomerCompany ON ChangeLog.Customer = _CustomerCompany.Customer AND _CustomerCompany.CompanyCode = ChangeLog.CompanyCode  -- association [0..1]
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]
;