P_FINS_GL_OPENITEM_AMOUNT

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 P_FINS_GL_OPENITEM_AMOUNT.
-- 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: PFINSGLOIAMT

CREATE VIEW P_FINS_GL_OPENITEM_AMOUNT AS
SELECT
  rbukrs AS CompanyCode,
  racct AS GLAccount,
  acdoca.gjahr AS FiscalYear,
  acdoca.belnr AS AccountingDocumentNumber,
  awitem AS ItemNumber,
  bkpf.budat AS PostingDate,
  bkpf.ldgrp AS LedgerGroup,
  skat.txt50 AS GLAccountName,
  ska1.glaccount_type AS GLAccountType,
  t001.waers AS CompanyCodeCurrency,
  t001.butxt AS CompanyCodeName,
  acdoca.hsl AS BalanceAmountInCompanyCodeCrcy,
  begru AS GLAccountAuthorizationGroup,
  altkt AS AlternativeGLAccount,
  alttxt.txt50 AS AlternativeGLAccountName,
  t001.ktopl AS ChartOfAccounts
FROM acdoca
INNER JOIN bkpf ON /* join condition not captured in parsed metadata */
INNER JOIN P_FINS_REPRESENTIVE_LEDGER AS ledger ON /* join condition not captured in parsed metadata */
INNER JOIN t001 ON /* join condition not captured in parsed metadata */
INNER JOIN skb1 ON /* join condition not captured in parsed metadata */
INNER JOIN skat ON /* join condition not captured in parsed metadata */
INNER JOIN ska1 ON /* join condition not captured in parsed metadata */
;