FINS_GL_DOCUMENT_AMT_DOCLN

DDL: FINS_GL_DOCUMENT_AMT_DOCLN SQL: FINSGLDOCAMTLN Type: view
89 Fields 21 Data Sources

Get Amounts from all ledgers via DOCLN

FINS_GL_DOCUMENT_AMT_DOCLN is a CDS View that provides data about "Get Amounts from all ledgers via DOCLN" in SAP S/4HANA. It reads from 21 data sources and exposes 89 fields with key fields bukrs, gjahr, belnr, docln, currencyType.

Data Sources (21)

SourceAliasJoin Type
acdoca acdoca from
acdoca acdoca union
acdoca acdoca union
acdoca acdoca union
acdoca acdoca union
acdoca acdoca union
acdoca acdoca union
acdoca acdoca union
acdoca acdoca union
acdoca acdoca union
acdoca acdoca union
finsc_ld_cmp currency_type inner
finsc_ld_cmp currency_type inner
finsc_ld_cmp currency_type inner
finsc_ld_cmp currency_type inner
finsc_ld_cmp currency_type inner
finsc_ld_cmp currency_type inner
finsc_ld_cmp currency_type inner
finsc_ld_cmp currency_type inner
finsc_ld_cmp currency_type inner
finsc_ld_cmp currency_type inner

Parameters (1)

NameTypeDefault
ledger rldnr

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName FINSGLDOCAMTLN view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Get Amounts from all ledgers via DOCLN view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.serviceQuality #X view

Fields (89)

KeyFieldSource TableSource FieldDescription
KEY bukrs rbukrs Company Code
KEY gjahr gjahr Settlement Year
KEY belnr belnr SD Document
KEY docln docln Matching Document Line Item
KEY currencyType FreeDef Crcy 8
awitem awitem Ref. Doc. Line Item
hkont racct GL Account From
amount wsl Amount in Currency 8
bukrs Company Code
KEY gjahr acdoca gjahr Settlement Year
KEY belnr acdoca belnr SD Document
KEY docln acdoca docln Matching Document Line Item
KEY currencyType finsc_ld_cmp curtph FreeDef Crcy 8
awitem acdoca awitem Ref. Doc. Line Item
hkont acdoca racct GL Account From
amount acdoca hsl Amount in Currency 8
bukrs Company Code
KEY gjahr acdoca gjahr Settlement Year
KEY belnr acdoca belnr SD Document
KEY docln acdoca docln Matching Document Line Item
KEY currencyType finsc_ld_cmp curtpk FreeDef Crcy 8
awitem acdoca awitem Ref. Doc. Line Item
hkont acdoca racct GL Account From
amount acdoca ksl Amount in Currency 8
bukrs Company Code
KEY gjahr acdoca gjahr Settlement Year
KEY belnr acdoca belnr SD Document
KEY docln acdoca docln Matching Document Line Item
KEY currencyType finsc_ld_cmp curtpo FreeDef Crcy 8
awitem acdoca awitem Ref. Doc. Line Item
hkont acdoca racct GL Account From
amount acdoca osl Amount in Currency 8
bukrs Company Code
KEY gjahr acdoca gjahr Settlement Year
KEY belnr acdoca belnr SD Document
KEY docln acdoca docln Matching Document Line Item
KEY currencyType finsc_ld_cmp curtpv FreeDef Crcy 8
awitem acdoca awitem Ref. Doc. Line Item
hkont acdoca racct GL Account From
amount acdoca vsl Amount in Currency 8
bukrs Company Code
KEY gjahr acdoca gjahr Settlement Year
KEY belnr acdoca belnr SD Document
KEY docln acdoca docln Matching Document Line Item
KEY currencyType finsc_ld_cmp curtpb FreeDef Crcy 8
awitem acdoca awitem Ref. Doc. Line Item
hkont acdoca racct GL Account From
amount acdoca bsl Amount in Currency 8
bukrs Company Code
KEY gjahr acdoca gjahr Settlement Year
KEY belnr acdoca belnr SD Document
KEY docln acdoca docln Matching Document Line Item
KEY currencyType finsc_ld_cmp curtpc FreeDef Crcy 8
awitem acdoca awitem Ref. Doc. Line Item
hkont acdoca racct GL Account From
amount acdoca csl Amount in Currency 8
bukrs Company Code
KEY gjahr acdoca gjahr Settlement Year
KEY belnr acdoca belnr SD Document
KEY docln acdoca docln Matching Document Line Item
KEY CurrencyType finsc_ld_cmp curtpd FreeDef Crcy 5
awitem acdoca awitem Ref. Doc. Line Item
hkont acdoca racct GL Account From
amount acdoca dsl Amount in Currency 8
bukrs Company Code
KEY gjahr acdoca gjahr Settlement Year
KEY belnr acdoca belnr SD Document
KEY docln acdoca docln Matching Document Line Item
KEY currencyType finsc_ld_cmp curtpe FreeDef Crcy 8
awitem acdoca awitem Ref. Doc. Line Item
hkont acdoca racct GL Account From
amount acdoca esl Amount in Currency 8
bukrs Company Code
KEY gjahr acdoca gjahr Settlement Year
KEY belnr acdoca belnr SD Document
KEY docln acdoca docln Matching Document Line Item
KEY currencyType finsc_ld_cmp curtpf FreeDef Crcy 8
awitem acdoca awitem Ref. Doc. Line Item
hkont acdoca racct GL Account From
amount acdoca fsl Amount in Currency 8
bukrs Company Code
KEY gjahr acdoca gjahr Settlement Year
KEY belnr acdoca belnr SD Document
KEY docln acdoca docln Matching Document Line Item
KEY currencyType finsc_ld_cmp curtpg FreeDef Crcy 8
awitem acdoca awitem Ref. Doc. Line Item
hkont acdoca racct GL Account From
amount acdoca gsl Amount in Currency 8
currency acdoca rgcur Free Defined Crcy 8

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_GL_DOCUMENT_AMT_DOCLN.
-- 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: FINSGLDOCAMTLN
-- Parameters: ledger : rldnr

CREATE VIEW FINS_GL_DOCUMENT_AMT_DOCLN AS
SELECT
  rbukrs AS bukrs,
  gjahr,
  belnr,
  docln,
  cast( '00' as fins_curtype ) AS currencyType,
  awitem,
  racct AS hkont,
  wsl AS amount,
  acdoca.rgcur AS currency
FROM acdoca
INNER JOIN finsc_ld_cmp AS currency_type ON /* join condition not captured in parsed metadata */
-- UNION with additional select branch(es): acdoca
;

Learn More