FISVD_EXTERNALTAX_TRFCQOUT

DDL: FISVD_EXTERNALTAX_TRFCQOUT SQL: FISCDSEXTAXTRFC Type: view

TAX EXPOSTING MANAGE

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

2 data source(s) 8 fields

Data Sources (2)

SourceAliasJoin Type
dd07t _recorded left_outer
trfcqout trfcqout from

Annotations (5)

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

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY host_id arfcipid
KEY process_id arfcpid
KEY time_stamp arfctime
KEY counter arfctidcnt
KEY tid
destion dest
qname qname
state qstate 
@AbapCatalog.sqlViewName: 'FISCDSEXTAXTRFC'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'TAX EXPOSTING MANAGE'
@ObjectModel.usageType: {
  serviceQuality: #P
}

define view FISVD_EXTERNALTAX_TRFCQOUT
  as select from    trfcqout
    left outer join dd07t as _recorded on  domname    = 'FIS_EXTDC_RECORDED'
                                       and ddlanguage = $session.system_language
{
  key  arfcipid                                                       as  host_id,
  key  arfcpid                                                        as  process_id,
  key  arfctime                                                       as  time_stamp,
  key  arfctidcnt                                                     as  counter,
  key  concat  (arfcipid,concat(arfcpid,concat(arfctime,arfctidcnt))) as  tid,
       dest                                                           as  destion,
       qname                                                          as  qname,
       qstate                                                         as  state,
       cast(case qstate 
       when 'READY'                                                   then _recorded.ddtext
       else                                                           errmess
       end as natxt)                                                  as  errormes
}
where
  qname = 'TIF_UPDATE_AUDIT_FILE'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"DD07T",
"TRFCQOUT"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0
}
}*/

Learn More