FINS_REV_REC_COSACT_VIEW4_BAS

DDL: FINS_REV_REC_COSACT_VIEW4_BAS Type: view_entity Package: FINS_REV_REC_UTIL
49 Fields 2 Data Sources

Actuals for data with CO objects

FINS_REV_REC_COSACT_VIEW4_BAS is a CDS View that provides data about "Actuals for data with CO objects" in SAP S/4HANA. It reads from 2 data sources (acdoca, finsc_ld_cmp) and exposes 49 fields. Part of development package FINS_REV_REC_UTIL.

Data Sources (2)

SourceAliasJoin Type
acdoca a from
finsc_ld_cmp v inner

Annotations (5)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Actuals for data with CO objects view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view

Fields (49)

KeyFieldSource TableSource FieldDescription
rldnr acdoca rldnr Ledger (Compat.)
objnr acdoca objnr Val. Obj. No.
pspnr acdoca ps_posid WBS Element
pspid acdoca ps_pspid Project def.
ps_psp_pnr acdoca ps_psp_pnr WBS Element
aufnr acdoca aufnr SettlementOrder
vbeln acdoca kdauf SD Document
vbposnr acdoca kdpos Sales Ord. Item
gjahr acdoca ryear Ref. Year1
perio acdoca poper Posting periods
fiscyearper acdoca fiscyearper Period/Year
budat acdoca budat Posting Date
bldat acdoca bldat Journal Entry Date
valdt acdoca fbuda Services Rendered Date
kstar acdoca racct GL Account From
kokrs acdoca kokrs Org. Value
bukrs acdoca rbukrs Company Code
werks acdoca werks Receiving Plant
gsber acdoca rbusa Business Area
prctr acdoca prctr Profit Centers
matnr acdoca matnr Vehicle Model
uspob acdoca uspob Source Object
plstar acdoca plstar ParActvy
pkostl acdoca ukostl OrigCCtr
parob1 acdoca parob1 Partner Object
work_item_id acdoca work_item_id Work Item ID
pernr acdoca pernr Personnel no.
uprctr acdoca uprctr Origin Profit Center
hrkft acdoca hrkft Origin group order
bemot acdoca bemot AcctIndicator
rsrce acdoca rsrce Resource
overtimecat acdoca overtimecat Overtime Category
bttype acdoca bttype Business Transaction Type
bttype_tec
vrgng acdoca vrgng Bus.Transaction
beltp acdoca beltp Debit Type
xreversed acdoca xreversed Reversed
xreversing acdoca xreversing Reversal doc.
twaer acdoca rwcur Transaction Currency
owaer acdoca rhcur Local Currency
kwaer acdoca rkcur Ledger curr.
meinh acdoca runit Unit/Area
meinb acdoca runit Unit/Area
wtgbtr
wogbtr
wkgbtr
wkfbtr
mbgbtr
mbfbtr

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view FINS_REV_REC_COSACT_VIEW4_BAS.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW FINS_REV_REC_COSACT_VIEW4_BAS AS
SELECT
  a.rldnr AS rldnr,
  a.objnr AS objnr,
  a.ps_posid AS pspnr,
  a.ps_pspid AS pspid,
  a.ps_psp_pnr AS ps_psp_pnr,
  a.aufnr AS aufnr,
  a.kdauf AS vbeln,
  a.kdpos AS vbposnr,
  a.ryear AS gjahr,
  a.poper AS perio,
  a.fiscyearper AS fiscyearper,
  a.budat AS budat,
  a.bldat AS bldat,
  a.fbuda AS valdt,
  a.racct AS kstar,
  a.kokrs AS kokrs,
  a.rbukrs AS bukrs,
  a.werks AS werks,
  a.rbusa AS gsber,
  a.prctr AS prctr,
  a.matnr AS matnr,
  a.uspob AS uspob,
  a.plstar AS plstar,
  a.ukostl AS pkostl,
  a.parob1 AS parob1,
  a.work_item_id AS work_item_id,
  a.pernr AS pernr,
  a.uprctr AS uprctr,
  a.hrkft AS hrkft,
  a.bemot AS bemot,
  a.rsrce AS rsrce,
  a.overtimecat AS overtimecat,
  a.bttype AS bttype,
  cast( case a.bttype when 'RFCV' then a.bttype else ( case a.vrgng when '' then a.vorgn when 'COIE' then a.vorgn when 'COIN' then a.vorgn else a.vrgng end ) end as fins_trr_bttype ) AS bttype_tec,
  a.vrgng AS vrgng,
  a.beltp AS beltp,
  a.xreversed AS xreversed,
  a.xreversing AS xreversing,
  a.rwcur AS twaer,
  a.rhcur AS owaer,
  a.rkcur AS kwaer,
  a.runit AS meinh,
  a.runit AS meinb,
  sum(a.wsl) AS wtgbtr,
  sum(a.hsl) AS wogbtr,
  sum(a.ksl) AS wkgbtr,
  sum(a.kfsl) AS wkfbtr,
  sum(a.msl) AS mbgbtr,
  sum(a.mfsl) AS mbfbtr
FROM acdoca AS a
INNER JOIN finsc_ld_cmp AS v ON /* join condition not captured in parsed metadata */
;

Learn More