FAA_UPA_MIG_DI_BALANCE02

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_DI_BALANCE02.
-- 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_DI_BALANCE02 AS
SELECT
  docit.bukrs AS CompanyCode,
  docit.anln1 AS MasterFixedAsset,
  docit.anln2 AS FixedAsset,
  docit.gjahr AS FiscalYear,
  cast('' as fis_belnr) AS AccountingDocument,
  cast('' as fis_docln) AS LedgerGLLineItem,
  docit.subta AS TransactionSubitem,
  docit.afabe AS AssetDepreciationArea,
  cast(docit.slalittype as fis_slalittype preserving type) AS SubLedgerAcctLineItemType,
  docit.poper AS FiscalPeriod,
  LedgerGroupAssignment.rldnr AS Ledger,
  docit.drcrk AS DebitCreditCode,
  cast( docit.awtyp as fis_awtyp preserving type ) AS ReferenceDocumentType,
  docit.awref AS ReferenceDocument,
  docit.aworg AS ReferenceDocumentContext,
  docit.awsys AS LogicalSystem,
  docit.movcat AS AssetAcctTransClassfctn,
  cast( '000' as fis_peraf preserving type ) AS DepreciationFiscalPeriod,
  docit.rhcur AS CompanyCodeCurrency,
  docit.hsl AS AmountInCompanyCodeCurrency,
  docit.rkcur AS GlobalCurrency,
  docit.ksl AS AmountInGlobalCurrency,
  docit.rocur AS FreeDefinedCurrency1,
  docit.osl AS AmountInFreeDefinedCurrency1,
  docit.rvcur AS FreeDefinedCurrency2,
  docit.vsl AS AmountInFreeDefinedCurrency2,
  docit.rbcur AS FreeDefinedCurrency3,
  docit.bsl AS AmountInFreeDefinedCurrency3,
  docit.rccur AS FreeDefinedCurrency4,
  docit.csl AS AmountInFreeDefinedCurrency4,
  docit.rdcur AS FreeDefinedCurrency5,
  docit.dsl AS AmountInFreeDefinedCurrency5,
  docit.recur AS FreeDefinedCurrency6,
  docit.esl AS AmountInFreeDefinedCurrency6,
  docit.rfcur AS FreeDefinedCurrency7,
  docit.fsl AS AmountInFreeDefinedCurrency7,
  docit.rgcur AS FreeDefinedCurrency8,
  docit.gsl as AmountInFreeDefinedCurrency8 AS bukrsasCompanyCode,
  docit.gsl AS AmountInFreeDefinedCurrency8
FROM faat_doc_it AS docit
INNER JOIN faac_cmp_da0 AS cmp_da0 ON /* join condition not captured in parsed metadata */
INNER JOIN FAA_UPA_MIG_DA_MATH_FMLA AS math_fmla ON /* join condition not captured in parsed metadata */
INNER JOIN faac_valview1a AS valview1a ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): faat_doc_it
;