FISVD_EXTERNALTAX_TERMINATION

DDL: FISVD_EXTERNALTAX_TERMINATION SQL: FISCDSEXTAXTERON Type: view
19 Fields 3 Data Sources

TAX EXPOSTING MANAGE

FISVD_EXTERNALTAX_TERMINATION is a CDS View that provides data about "TAX EXPOSTING MANAGE" in SAP S/4HANA. It reads from 3 data sources (etxdcf, etxdch, FISVD_EXTERNALTAX_TARFCSTATUS) and exposes 19 fields with key field uniquekey.

Data Sources (3)

SourceAliasJoin Type
etxdcf etxf left_outer
etxdch etxh left_outer
FISVD_EXTERNALTAX_TARFCSTATUS rfcstate from

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName FISCDSEXTAXTERON view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label TAX EXPOSTING MANAGE view
ObjectModel.usageType.serviceQuality #P view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY uniquekey FISVD_EXTERNALTAX_TARFCSTATUS tid Transaction ID for updating external tax system
documenttype awtyp Reference Document Type
externaldoc etxdch docnr Well doc.no.
referencedoc awref Reference Doc.
awtyp awtyp Reference Document Type
aworg aworg Refer. Org.Unit
process_date docstatuschanged Date status changed
state FISVD_EXTERNALTAX_TARFCSTATUS status Workflow Status
destination FISVD_EXTERNALTAX_TARFCSTATUS destion
qname FISVD_EXTERNALTAX_TARFCSTATUS qname User
errormessage errormes
errorcode etxdch errcode Output: Error number
errorline etxdch error_line Line number
errmsg etxdch errmsg Tax error messages
username etxdch usnam User Name
docstatus FISVD_EXTERNALTAX_TARFCSTATUS state Vehicle Region
companycode etxdcf bukrs Value
belnr etxdcf belnr SD Document
fiscalyear etxdcf gjahr Settlement Year

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_TERMINATION.
-- 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: FISCDSEXTAXTERON

CREATE VIEW FISVD_EXTERNALTAX_TERMINATION AS
SELECT
  rfcstate.tid AS uniquekey,
  awtyp AS documenttype,
  etxh.docnr AS externaldoc,
  awref AS referencedoc,
  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 */
;

Learn More