C_CN_TaxInputInvcStsChgLg

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_CN_TaxInputInvcStsChgLg.
-- 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.

CREATE VIEW C_CN_TaxInputInvcStsChgLg AS
SELECT
  _log.CN_TaxInvcStsChgLgUUID AS CN_TaxInvcStsChgLgUUID,
  _Invoice.CN_TaxEntityID AS CN_TaxEntityID,
  _log.CN_TaxInputInvcActn AS CN_TaxInputInvcActn,
  _log.CN_TaxInvcUUID AS CN_TaxInvcUUID,
  _log.ARCommentText AS ARCommentText,
  _log.LastChangedByUser AS LastChangedByUser,
  cast ( _log.LastChangedByUserName as ficntaxinvc_processor ) AS LastChangedByUserName,
  _log.LastChangeDateTime AS LastChangeDateTime,
  cast (_NextInvoiceStatus.DocumentStatusDesc as ficntaxinvc_status_text) AS DocumentStatusDesc
FROM I_CN_TaxInputInvcStsChgLg
LEFT OUTER JOIN C_CN_TaxInvcInptProcgSts AS _InitialInvoiceStatus ON CN_TaxInvcChgLgStatus = _InitialInvoiceStatus.CN_TaxInvcInptProcgSts  -- association [1..1]
LEFT OUTER JOIN C_CN_TaxInvcInptProcgSts AS _NextInvoiceStatus ON CN_TaxInvcChgLgNextStatus = _NextInvoiceStatus.CN_TaxInvcInptProcgSts  -- association [1..1]
LEFT OUTER JOIN C_CN_TaxInputInvc AS _Invoice ON CN_TaxInvcUUID = _Invoice.CN_TaxInvcUUID  -- association [1..1]
;