FISVD_EXTERNALTAX_TARFCSTATUS

DDL: FISVD_EXTERNALTAX_TARFCSTATUS SQL: FISCDSEXTAXTSTA Type: view

TAX EXPOSTING MANAGE

FISVD_EXTERNALTAX_TARFCSTATUS is a CDS View that provides data about "TAX EXPOSTING MANAGE" in SAP S/4HANA. It reads from 2 data sources (dd07t, FISVD_EXTERNALTAX_TRFCQOUT) and exposes 10 fields with key fields host_id, process_id, time_stamp, counter, tid.

2 data source(s) 10 fields

Data Sources (2)

SourceAliasJoin Type
dd07t _recorded left_outer
FISVD_EXTERNALTAX_TRFCQOUT FISVD_EXTERNALTAX_TRFCQOUT from

Annotations (5)

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

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY host_id host_id
KEY process_id process_id
KEY time_stamp time_stamp
KEY counter counter
KEY tid tid
destion destion
qname qname
state state
errormes errormes
status dd07t ddtext 
@AbapCatalog.sqlViewName: 'FISCDSEXTAXTSTA'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'TAX EXPOSTING MANAGE'
@ObjectModel.usageType: {
  serviceQuality: #P
}

define view FISVD_EXTERNALTAX_TARFCSTATUS
  as select from    FISVD_EXTERNALTAX_TRFCQOUT
       left outer join dd07t as _recorded on  domname    = 'FIS_ETXDC_TRFCSTATUS'
                                       and ddlanguage = $session.system_language
                                       and _recorded.domvalue_l = FISVD_EXTERNALTAX_TRFCQOUT.state
{
  key   host_id                                                           as  host_id,
  key   process_id                                                        as  process_id,
  key   time_stamp                                                        as  time_stamp,
  key   counter                                                           as  counter,
  key   tid                                                               as  tid,
        destion                                                           as  destion,
        qname                                                             as  qname,
        state                                                             as  state,
        errormes                                                          as  errormes,
//        cast (case state

//        when 'READY'                                                   then _recorded.ddtext

//        when 'SYSFAIL'                                                 then _recorded.ddtext

//        end as fis_etxdc_trfcstatus)                                      as  status

        _recorded.ddtext                                                  as  status
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"FISVD_EXTERNALTAX_TRFCQOUT",
"DD07T"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0
}
}*/

Learn More