FISVD_EXTERNALTAX_NOBKPF

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 FISVD_EXTERNALTAX_NOBKPF.
-- 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: FISCDSEXTAXNB

CREATE VIEW FISVD_EXTERNALTAX_NOBKPF AS
SELECT
  rfcstate.tid AS uniquekey,
  etxh.docnr AS externaldoc,
  awref AS referencedoc,
  awtyp AS documenttype,
  awtyp,
  aworg,
  docstatuschanged AS process_date,
  rfcstate.status AS state,
  rfcstate.destion AS destination,
  rfcstate.qname AS qname,
  errormes AS errormessage,
  etxh.errcode AS errorcode,
  etxh.error_line AS errorline,
  etxh.errmsg AS errmsg,
  etxh.usnam AS username,
  rfcstate.state AS docstatus,
  etxf.bukrs AS companycode,
  etxf.belnr AS belnr,
  etxf.gjahr AS fiscalyear
FROM FISVD_EXTERNALTAX_TARFCSTATUS AS rfcstate
LEFT OUTER JOIN etxdch AS etxh ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN etxdcf AS etxf ON /* join condition not captured in parsed metadata */
;