FAC_DART_Z3_VNDRCHGDOC_BASE

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_VNDRCHGDOC_BASE.
-- 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_DZVNDRCHGDB

CREATE VIEW FAC_DART_Z3_VNDRCHGDOC_BASE AS
SELECT
  Vendor,
  cast( substring( ChangeDocTableKey, 14, 4 ) as bukrs ) AS CompanyCode,
  _item.ChangeDocObject AS ChangeDocObject,
  _item.ChangeDocObjectClass AS ChangeDocObjectClass,
  _item.ChangeDocument AS ChangeDocument,
  _item.DatabaseTable AS DatabaseTable,
  _item.ChangeDocTableKey AS ChangeDocTableKey,
  _item.ChangeDocDatabaseTableField AS ChangeDocDatabaseTableField,
  _item.ChangeDocItemChangeType AS ChangeDocItemChangeType,
  _item.ChangeDocNewFieldValue AS ChangeDocNewFieldValue,
  _item.ChangeDocPreviousFieldValue AS ChangeDocPreviousFieldValue,
  _item.ChangeDocPreviousUnit AS ChangeDocPreviousUnit,
  _item.ChangeDocNewUnit AS ChangeDocNewUnit,
  _item.ChangeDocPreviousCurrency AS ChangeDocPreviousCurrency,
  _item.ChangeDocNewCurrency AS ChangeDocNewCurrency,
  _item.ChangeDocTextIsChanged AS ChangeDocTextIsChanged,
  Length(_item.ChangeDocNewFieldValue) AS newLength,
  Length(_item.ChangeDocPreviousFieldValue) AS oldLength,
  _header.CreatedByUser AS CreatedByUser,
  _header.CreationDate AS CreationDate,
  _header.CreationTime AS CreationTime,
  _header.ChangeTransactionCode AS ChangeTransactionCode,
  _header.ChangeDocChangeType AS ChangeDocChangeType,
  _header.ChangeDocLanguage AS ChangeDocLanguage
FROM FAC_DART_Z3_VNDRCHGDOC_BASE_B AS _item
LEFT OUTER JOIN I_ChangeDocument AS _header ON ChangeDocObjectClass = _header.ChangeDocObjectClass AND ChangeDocObject = _header.ChangeDocObject AND ChangeDocument = _header.ChangeDocument  -- association [0..1]
LEFT OUTER JOIN I_SupplierCompany AS _vendor ON Vendor = _vendor.Supplier  -- association [0..*]
-- UNION with additional select branch(es): FAC_DART_Z3_VNDRCHGDOC_BASE_B
;