FINS_REV_REC_COS_ACDOCP_VIEW

DDL: FINS_REV_REC_COS_ACDOCP_VIEW Type: view_entity Package: FINS_REV_REC_UTIL

Planvalues from ACDOCP

FINS_REV_REC_COS_ACDOCP_VIEW is a CDS View that provides data about "Planvalues from ACDOCP" in SAP S/4HANA. It reads from 2 data sources (acdocp, t006) and exposes 20 fields. Part of development package FINS_REV_REC_UTIL.

2 data source(s) 20 fields

Data Sources (2)

SourceAliasJoin Type
acdocp a from
t006 b left_outer

Annotations (5)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Planvalues from ACDOCP view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view

Fields (20)

KeyFieldSource TableSource FieldDescription
category acdocp category
rldnr acdocp rldnr
bukrs acdocp rbukrs
hkont acdocp racct
aufnr acdocp aufnr
kdauf acdocp kdauf
kdpos acdocp kdpos
ps_posid acdocp ps_posid
ps_psp_pnr acdocp ps_psp_pnr
rwcur acdocp rwcur
rhcur acdocp rhcur
rkcur acdocp rkcur
rco_ocur acdocp rco_ocur
rvunit acdocp rvunit
dimid t006 dimid
wsl
ksl
hsl
co_osl
vmsl 
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Planvalues from ACDOCP'

@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #MIXED

//Adds dimension type of quantity unit to ACDOCP   

//Selects from ACDOCP and T006


define view entity FINS_REV_REC_COS_ACDOCP_VIEW
  as select
  from acdocp as a
  left outer join t006 as b on a.rvunit = b.msehi
{
    a.category,
    a.rldnr,      
    a.rbukrs as bukrs,
    a.racct as hkont,
    a.aufnr,      
    a.kdauf,
    a.kdpos,
    a.ps_posid,
    a.ps_psp_pnr,
    a.service_doc_id,
    a.service_doc_item_id, 
    a.rwcur,
    a.rhcur,
    a.rkcur,
    a.rco_ocur,
    a.rvunit,       
    b.dimid as dimid,
    @Semantics.amount.currencyCode: 'rwcur'
    sum(a.wsl) as wsl,
    @Semantics.amount.currencyCode: 'rkcur'
    sum(a.ksl) as ksl,
    @Semantics.amount.currencyCode: 'rhcur'
    sum(a.hsl) as hsl,
    @Semantics.amount.currencyCode: 'rco_ocur'
    sum(a.co_osl) as co_osl,
    @Semantics.quantity.unitOfMeasure: 'rvunit'
    sum(a.vmsl) as vmsl
}
  group by
    a.category,
    a.rldnr,      
    a.rbukrs,
    a.racct,      
    a.aufnr,      
    a.kdauf,
    a.kdpos,
    a.ps_posid,
    a.ps_psp_pnr,
    a.service_doc_id,
    a.service_doc_item_id,    
    a.rwcur,
    a.rhcur,
    a.rkcur,
    a.rco_ocur,
    a.rvunit,       
    b.dimid      
    ;

Learn More