FAA_UPA_MIG_BAL_DOC

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 FAA_UPA_MIG_BAL_DOC.
-- 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 FAA_UPA_MIG_BAL_DOC AS
SELECT
  acdoca.rbukrs AS CompanyCode,
  acdoca.anln1 AS MasterFixedAsset,
  acdoca.anln2 AS FixedAsset,
  acdoca.gjahr AS FiscalYear,
  cast(acdoca.belnr as fis_belnr preserving type) AS AccountingDocument,
  cast(acdoca.docln as fis_docln preserving type) AS LedgerGLLineItem,
  acdoca.subta AS TransactionSubitem,
  acdoca.afabe AS AssetDepreciationArea,
  cast(acdoca.slalittype as fis_slalittype preserving type) AS SubLedgerAcctLineItemType,
  acdoca.poper AS FiscalPeriod,
  acdoca.rldnr AS Ledger,
  acdoca.drcrk AS DebitCreditCode,
  cast(acdoca.awtyp as fis_awtyp preserving type) AS ReferenceDocumentType,
  acdoca.awref AS ReferenceDocument,
  acdoca.aworg AS ReferenceDocumentContext,
  acdoca.awsys AS LogicalSystem,
  acdoca.movcat AS AssetAcctTransClassfctn,
  acdoca.depr_period AS DepreciationFiscalPeriod,
  LedgerCompanyCodeCrcyRoles.CompanyCodeCurrencyRole AS CompanyCodeCurrencyRole,
  acdoca.rhcur AS CompanyCodeCurrency,
  acdoca.hsl AS AmountInCompanyCodeCurrency,
  LedgerCompanyCodeCrcyRoles.GlobalCurrencyRole AS GlobalCurrencyRole,
  acdoca.rkcur AS GlobalCurrency,
  acdoca.ksl AS AmountInGlobalCurrency,
  LedgerCompanyCodeCrcyRoles.FreeDefinedCurrency1Role AS FreeDefinedCurrency1Role,
  acdoca.rocur AS FreeDefinedCurrency1,
  acdoca.osl AS AmountInFreeDefinedCurrency1,
  LedgerCompanyCodeCrcyRoles.FreeDefinedCurrency2Role AS FreeDefinedCurrency2Role,
  acdoca.rvcur AS FreeDefinedCurrency2,
  acdoca.vsl AS AmountInFreeDefinedCurrency2,
  LedgerCompanyCodeCrcyRoles.FreeDefinedCurrency3Role AS FreeDefinedCurrency3Role,
  acdoca.rbcur AS FreeDefinedCurrency3,
  acdoca.bsl AS AmountInFreeDefinedCurrency3,
  LedgerCompanyCodeCrcyRoles.FreeDefinedCurrency4Role AS FreeDefinedCurrency4Role,
  acdoca.rccur AS FreeDefinedCurrency4,
  acdoca.csl AS AmountInFreeDefinedCurrency4,
  LedgerCompanyCodeCrcyRoles.FreeDefinedCurrency5Role AS FreeDefinedCurrency5Role,
  acdoca.rdcur AS FreeDefinedCurrency5,
  acdoca.dsl AS AmountInFreeDefinedCurrency5,
  LedgerCompanyCodeCrcyRoles.FreeDefinedCurrency6Role AS FreeDefinedCurrency6Role,
  acdoca.recur AS FreeDefinedCurrency6,
  acdoca.esl AS AmountInFreeDefinedCurrency6,
  LedgerCompanyCodeCrcyRoles.FreeDefinedCurrency7Role AS FreeDefinedCurrency7Role,
  acdoca.rfcur AS FreeDefinedCurrency7,
  acdoca.fsl AS AmountInFreeDefinedCurrency7,
  LedgerCompanyCodeCrcyRoles.FreeDefinedCurrency8Role AS FreeDefinedCurrency8Role,
  acdoca.rgcur AS FreeDefinedCurrency8,
  acdoca.gsl as AmountInFreeDefinedCurrency8 AS rbukrsasCompanyCode,
  acdoca.gsl as AmountInFreeDefinedCurrency8 AS bukrsasCompanyCode,
  duevalues.gsl AS AmountInFreeDefinedCurrency8
FROM acdoca
INNER JOIN I_LedgerCompanyCodeCrcyRoles AS LedgerCompanyCodeCrcyRoles ON /* join condition not captured in parsed metadata */
INNER JOIN I_TechnicalLedger AS TechnicalLedger ON /* join condition not captured in parsed metadata */
INNER JOIN I_LedgerGroupAssignment AS LedgerGroupAssignment ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): acdoca, faat_doc_it, faat_plan_values
;