FMUSFGA_COMPAT

DDL: FMUSFGA_COMPAT SQL: FMUSFGA_COMPAT_V Type: view

Compatibility view for FMUSFGA replace with ACDOCA

FMUSFGA_COMPAT is a CDS View that provides data about "Compatibility view for FMUSFGA replace with ACDOCA" in SAP S/4HANA. It reads from 3 data sources (acdoca, fmfg_uj_activ, fmusfga) and exposes 35 fields.

Data Sources (3)

SourceAliasJoin Type
acdoca acdoca union_all
fmfg_uj_activ activation inner
fmusfga fmusfga from

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName FMUSFGA_COMPAT_V view
ClientHandling.algorithm #AUTOMATED view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Compatibility view for FMUSFGA replace with ACDOCA view

Fields (35)

KeyFieldSource TableSource FieldDescription
gl_sirid gl_sirid Record number
rldnr rldnr Ledger (Compat.)
rrcty rrcty Record Type
rvers rvers Version: Tax rt
ryear ryear Ref. Year1
rtcur fmusfga rtcur Currency
drcrk drcrk Debit/Credit
poper poper Posting periods
docct docct Document Categ.
docnr docnr SD Document
docln docln Matching Document Line Item
rbukrs rbukrs Company Code
racct racct GL Account From
rbusa rbusa Business Area
rprctr rprctr Profit Centers
rcntr rcntr Cost Center
rprojk rprojk WBS Element
rfarea rfarea R FuncArea
rldnr Ledger (Compat.)
rrcty acdoca rrcty Record Type
rvers Version: Tax rt
ryear acdoca ryear Ref. Year1
rtcur acdoca rtcur Currency
drcrk acdoca drcrk Debit/Credit
poper acdoca poper Posting periods
docct Document Categ.
docnr acdoca belnr SD Document
docln acdoca docln Matching Document Line Item
rbukrs acdoca rbukrs Company Code
racct acdoca racct GL Account From
rbusa acdoca rbusa Business Area
rprctr acdoca prctr Profit Centers
rcntr acdoca rcntr Cost Center
rfarea acdoca rfarea R FuncArea
rfund acdoca rfund Fund

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 FMUSFGA_COMPAT.
-- 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.
-- SQL view name: FMUSFGA_COMPAT_V

CREATE VIEW FMUSFGA_COMPAT AS
SELECT
  gl_sirid,
  rldnr,
  rrcty,
  rvers,
  ryear,
  fmusfga.rtcur AS rtcur,
  drcrk,
  poper,
  docct,
  docnr,
  docln,
  rbukrs,
  racct,
  rbusa,
  rprctr,
  rcntr,
  rprojk,
  rfarea,
  acdoca.rfund AS rfund
FROM fmusfga
INNER JOIN fmfg_uj_activ AS activation ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): acdoca
;