FISVD_EXTERNALTAX_ETXDCH_FI

DDL: FISVD_EXTERNALTAX_ETXDCH_FI SQL: FISCDSETXDCHFI Type: view

TAX EXPOSTING MANAGE

FISVD_EXTERNALTAX_ETXDCH_FI is a CDS View that provides data about "TAX EXPOSTING MANAGE" in SAP S/4HANA. It reads from 2 data sources (dd07t, etxdch) and exposes 14 fields with key field externaldoc.

2 data source(s) 14 fields

Data Sources (2)

SourceAliasJoin Type
dd07t _action left_outer
etxdch _etx from

Annotations (5)

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

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY externaldoc docnr
uniquekey tid
referencedoc etxdch awref
documenttype etxdch awtyp
postsystem etxdch awsys
documentkey
process_date docstatuschanged
username etxdch usnam
errorcode errcode
errorline error_line
errormessage errmsg
action rec_status
actiondes dd07t ddtext
feed_count feed_count 
@AbapCatalog.sqlViewName: 'FISCDSETXDCHFI'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'TAX EXPOSTING MANAGE'

@ObjectModel.usageType: {
  serviceQuality: #P
}


define view FISVD_EXTERNALTAX_ETXDCH_FI
  as select from etxdch as _etx
  left outer join dd07t as _action on _action.domname    = 'FIS_D_ETXDC_ACTION'
                                  and _action.ddlanguage = $session.system_language
                                  and _action.domvalue_l = _etx.rec_status

                                     
{
  key docnr             as externaldoc,
      tid               as uniquekey,
      _etx.awref        as referencedoc,
      _etx.awtyp        as documenttype,
      _etx.aworg        as organizationunit,
      _etx.awsys        as postsystem,
      concat(_etx.awref, _etx.aworg) as documentkey,
      docstatuschanged  as process_date,
      _etx.usnam             as username,
      errcode           as errorcode,
      error_line        as errorline,
      errmsg            as errormessage,
      rec_status        as action,
      _action.ddtext    as actiondes,
      feed_count        as feed_count
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"DD07T",
"ETXDCH"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0
}
}*/

Learn More