FAA_UPA_MIG_DA_DRVD_DOCIT

DDL: FAA_UPA_MIG_DA_DRVD_DOCIT Type: view_entity Package: FINS_FAA_UPA_MIG_TECH_LEDGER

Derived area DOC_IT

FAA_UPA_MIG_DA_DRVD_DOCIT is a CDS View that provides data about "Derived area DOC_IT" in SAP S/4HANA. It reads from 2 data sources (FAA_UPA_MIG_DA_DRVD_AREA, acdoca) and exposes 67 fields with key fields bukrs, anln1, anln2, gjahr, awtyp. Part of development package FINS_FAA_UPA_MIG_TECH_LEDGER.

2 data source(s) 67 fields

Data Sources (2)

SourceAliasJoin Type
FAA_UPA_MIG_DA_DRVD_AREA DerivedArea inner
acdoca Values from

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Derived area DOC_IT view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (67)

KeyFieldSource TableSource FieldDescription
KEY bukrs acdoca rbukrs
KEY anln1 acdoca anln1
KEY anln2 acdoca anln2
KEY gjahr acdoca gjahr
KEY awtyp acdoca awtyp
KEY awref acdoca awref
KEY aworg acdoca aworg
KEY awsys acdoca awsys
KEY subta acdoca subta
KEY afabe acdoca afabe
KEY slalittype acdoca slalittype
KEY drcrk acdoca drcrk
awitem acdoca awitem
vorgn acdoca vorgn
budat acdoca budat
bzdat acdoca bzdat
poper acdoca poper
bwasl acdoca anbwa
movcat acdoca movcat
hsl acdoca hsl
ksl acdoca ksl
osl acdoca osl
vsl acdoca vsl
bsl acdoca bsl
csl acdoca csl
dsl acdoca dsl
esl acdoca esl
fsl acdoca fsl
gsl acdoca gsl
rhcur acdoca rhcur
rkcur acdoca rkcur
rocur acdoca rocur
rvcur acdoca rvcur
rbcur acdoca rbcur
rccur acdoca rccur
rdcur acdoca rdcur
recur acdoca recur
rfcur acdoca rfcur
rgcur acdoca rgcur
xreversing acdoca xreversing
xreversed acdoca xreversed
xsettling acdoca xsettling
xsettled acdoca xsettled
prec_awtyp acdoca prec_awtyp
prec_aworg acdoca prec_aworg
prec_awref acdoca prec_awref
prec_subta acdoca prec_subta
awtyp_rev acdoca awtyp_rev
awref_rev acdoca awref_rev
aworg_rev acdoca aworg_rev
subta_rev acdoca subta_rev
anlkl acdoca anlkl
ktogr acdoca ktogr
panl1 acdoca panl1
panl2 acdoca panl2
bldat acdoca bldat
sgtxt acdoca sgtxt
zuonr acdoca zuonr
anln2_pn acdoca anln2_pn
bwasl_pn acdoca bwasl_pn
bzdat_pn acdoca bzdat_pn
ubzdt_pn acdoca ubzdt_pn
xvabg_pn acdoca xvabg_pn
prozs_pn acdoca prozs_pn
origin Origin
bstat acdoca bstat
bttype acdoca bttype 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Derived area DOC_IT'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #X,
  sizeCategory: #S,
  dataClass: #MIXED
}
// Copy from FAA_CalctDrvdAreaDocit04

define view entity FAA_UPA_MIG_DA_DRVD_DOCIT
  as select from acdoca                   as Values
    inner join   FAA_UPA_MIG_DA_DRVD_AREA as DerivedArea on  Values.rbukrs =  DerivedArea.CompanyCode
                                                         and Values.afabe  =  DerivedArea.AssetDepreciationArea
                                                         and Values.awtyp  <> 'AMDP'
{
  key Values.rbukrs as bukrs,
  key Values.anln1,
  key Values.anln2,
  key Values.gjahr,
  key Values.awtyp,

  key Values.awref,
  key Values.aworg,
  key Values.awsys,
  key Values.subta,
  key Values.afabe,
  key Values.slalittype,
  key Values.drcrk,

      Values.awitem,
      //CalculatedAssetValuationView.LedgerGroup                as ldgrp,

      Values.vorgn,
      Values.budat,
      Values.bzdat,
      Values.poper,
      Values.anbwa  as bwasl,
      Values.movcat,

      @Aggregation.default: #SUM
      @Semantics.amount.currencyCode: 'rhcur'
      Values.hsl,
      @Aggregation.default: #SUM
      @Semantics.amount.currencyCode: 'rkcur'
      Values.ksl,
      @Aggregation.default: #SUM
      @Semantics.amount.currencyCode: 'rocur'
      Values.osl,
      @Aggregation.default: #SUM
      @Semantics.amount.currencyCode: 'rvcur'
      Values.vsl,
      @Aggregation.default: #SUM
      @Semantics.amount.currencyCode: 'rbcur'
      Values.bsl,
      @Aggregation.default: #SUM
      @Semantics.amount.currencyCode: 'rccur'
      Values.csl,
      @Aggregation.default: #SUM
      @Semantics.amount.currencyCode: 'rdcur'
      Values.dsl,
      @Aggregation.default: #SUM
      @Semantics.amount.currencyCode: 'recur'
      Values.esl,
      @Aggregation.default: #SUM
      @Semantics.amount.currencyCode: 'rfcur'
      Values.fsl,
      @Aggregation.default: #SUM
      @Semantics.amount.currencyCode: 'rgcur'
      Values.gsl,

      Values.rhcur,
      Values.rkcur,
      Values.rocur,
      Values.rvcur,
      Values.rbcur,
      Values.rccur,
      Values.rdcur,
      Values.recur,
      Values.rfcur,
      Values.rgcur,
      //Values.has_fi_doc,

      //Values.afabe_fi_doc,

      Values.xreversing,
      Values.xreversed,
      Values.xsettling,
      Values.xsettled,
      Values.prec_awtyp,
      Values.prec_aworg,
      Values.prec_awref,
      Values.prec_subta,
      Values.awtyp_rev,
      Values.awref_rev,
      Values.aworg_rev,
      Values.subta_rev,
      Values.anlkl,
      Values.ktogr,
      Values.panl1,
      Values.panl2,
      //Values.anlgr,

      //Values.anlgr2,

      //Values.mig_source,

      //Values.recid,


      Values.bldat,
      //Values.cpudt,

      //Values.cputm,

      //Values.usnam,

      //Values.tcode,

      Values.sgtxt,
      //Values.xblnr,

      Values.zuonr,
      //Values.obart,

      //Values.objid,


      //Values.trava_pn,

      //Values.ldgrpspec_pn,

      //Values.afabespec_pn,


      Values.anln2_pn,
      Values.bwasl_pn,
      Values.bzdat_pn,
      Values.ubzdt_pn,
      Values.xvabg_pn,
      //Values.anbtr_pn,

      Values.prozs_pn,
      Values.xmanpropval_pn,

      //Values.sdm_curr_conv_src,

      //Values.sdm_curr_adjust,

      //Values.sdm_xvabg_set,

      //Values.sdm_status

      @EndUserText.label: 'Origin'
      @EndUserText.quickInfo: 'Original Table'
      'A'           as origin,
      Values.bstat,
      Values.bttype
}
where
         Values.slalittype    <> '07904'
  and    Values.slalittype    <> '07903'
  and    Values.slalittype    <> '07902'
  and    Values.slalittype    <> '07906'
  and    Values.slalittype    <> '07905'
  and    Values.slalittype    <> '07980'
  and    Values.slalittype    <> '07999'
  and    Values.mig_source    <> 'R'
  and    not(
       (
         Values.rldnr         =  '0L'
         or Values.rldnr      =  '2L'
         or Values.rldnr      =  '3L'
       )
       and(
            Values.slalittype =  '07900'
         or Values.slalittype =  '07940'
       )
     )
/*It´s the following SLALITTYPES excluded for DOC_IT:
7904
7903
7902
7906
7905
7980
7999*/

Learn More