FAA_ACDOCA_DOCIT

DDL: FAA_ACDOCA_DOCIT Type: view_entity

Union over ACDOCA and FAAT_DOC_IT

FAA_ACDOCA_DOCIT is a CDS View that provides data about "Union over ACDOCA and FAAT_DOC_IT" in SAP S/4HANA. It reads from 2 data sources (acdoca, faat_doc_it) and exposes 68 fields with key fields ledger, comp_code, asset_no, asset_subno, fisc_year.

2 data source(s) 68 fields

Data Sources (2)

SourceAliasJoin Type
acdoca acdoca from
faat_doc_it faat_doc_it union_all

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Union over ACDOCA and FAAT_DOC_IT view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (68)

KeyFieldSource TableSource FieldDescription
KEY ledger rldnr
KEY comp_code rbukrs
KEY asset_no anln1
KEY asset_subno anln2
KEY fisc_year ryear
KEY seq_number subta
KEY depr_area afabe
KEY slalittype slalittype
KEY debit_credit drcrk
awtyp awtyp
awref awref
aworg aworg
awsys awsys
ASSET_TTYPE anbwa
movement_cat movcat
hsl hsl
ksl ksl
osl osl
vsl vsl
bsl bsl
csl csl
dsl dsl
esl esl
fsl fsl
gsl gsl
RHCUR rhcur
RkCUR rkcur
RoCUR rocur
RvCUR rvcur
RbCUR rbcur
RcCUR rccur
RdCUR rdcur
ReCUR recur
RfCUR rfcur
KEY comp_code bukrs
KEY asset_no anln1
KEY asset_subno anln2
KEY fisc_year gjahr
KEY seq_number subta
KEY depr_area afabe
KEY slalittype slalittype
KEY debit_credit drcrk
awtyp awtyp
awref awref
aworg aworg
awsys awsys
ASSET_TTYPE bwasl
movement_cat movcat
hsl hsl
ksl ksl
osl osl
vsl vsl
bsl bsl
csl csl
dsl dsl
esl esl
fsl fsl
gsl gsl
RHCUR rhcur
RkCUR rkcur
RoCUR rocur
RvCUR rvcur
RbCUR rbcur
RcCUR rccur
RdCUR rdcur
ReCUR recur
RfCUR rfcur
RGCUR rgcur 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Union over ACDOCA and FAAT_DOC_IT'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #X,
  sizeCategory: #XXL,
  dataClass: #TRANSACTIONAL
}
define view entity FAA_ACDOCA_DOCIT
  as select from acdoca
{
  key rldnr      as ledger,
  key rbukrs     as comp_code,
  key anln1      as asset_no,
  key anln2      as asset_subno,
  key ryear      as fisc_year,
  key subta      as seq_number,
  key afabe      as depr_area,
  key slalittype as slalittype,
  key drcrk      as debit_credit,
      awtyp      as awtyp,
      awref      as awref,
      aworg      as aworg,
      awsys      as awsys,
      anbwa      as ASSET_TTYPE,
      movcat     as movement_cat,
      @Semantics.amount.currencyCode: 'RHCUR'
      hsl        as hsl,
      @Semantics.amount.currencyCode: 'RKCUR'
      ksl        as ksl,
      @Semantics.amount.currencyCode: 'ROCUR'
      osl        as osl,
      @Semantics.amount.currencyCode: 'RVCUR'
      vsl        as vsl,
      @Semantics.amount.currencyCode: 'RBCUR'
      bsl        as bsl,
      @Semantics.amount.currencyCode: 'RCCUR'
      csl        as csl,
      @Semantics.amount.currencyCode: 'RDCUR'
      dsl        as dsl,
      @Semantics.amount.currencyCode: 'RECUR'
      esl        as esl,
      @Semantics.amount.currencyCode: 'RFCUR'
      fsl        as fsl,
      @Semantics.amount.currencyCode: 'RGCUR'
      gsl        as gsl,
      rhcur      as RHCUR,
      rkcur      as RkCUR,
      rocur      as RoCUR,
      rvcur      as RvCUR,
      rbcur      as RbCUR,
      rccur      as RcCUR,
      rdcur      as RdCUR,
      recur      as ReCUR,
      rfcur      as RfCUR,
      rgcur      as RGCUR
}

union all

select from faat_doc_it
{
  key rldnr      as ledger,
  key bukrs      as comp_code,
  key anln1      as asset_no,
  key anln2      as asset_subno,
  key gjahr      as fisc_year,
  key subta      as seq_number,
  key afabe      as depr_area,
  key slalittype as slalittype,
  key drcrk      as debit_credit,
      awtyp      as awtyp,
      awref      as awref,
      aworg      as aworg,
      awsys      as awsys,
      bwasl      as ASSET_TTYPE,
      movcat     as movement_cat,
      hsl        as hsl,
      ksl        as ksl,
      osl        as osl,
      vsl        as vsl,
      bsl        as bsl,
      csl        as csl,
      dsl        as dsl,
      esl        as esl,
      fsl        as fsl,
      gsl        as gsl,
      rhcur      as RHCUR,
      rkcur      as RkCUR,
      rocur      as RoCUR,
      rvcur      as RvCUR,
      rbcur      as RbCUR,
      rccur      as RcCUR,
      rdcur      as RdCUR,
      recur      as ReCUR,
      rfcur      as RfCUR,
      rgcur      as RGCUR
}

Learn More