FAA_SDM_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_SDM_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.
-- SQL view name: FAAVBALANCE02

CREATE VIEW FAA_SDM_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) AS ReferenceDocumentType,
  docit.awref AS ReferenceDocument,
  docit.aworg AS ReferenceDocumentContext,
  docit.awsys AS LogicalSystem,
  docit.movcat AS AssetAcctTransClassfctn,
  cast('000' as fis_peraf) AS DepreciationFiscalPeriod,
  docit.hsl AS AmountInCompanyCodeCurrency,
  docit.ksl AS AmountInGlobalCurrency,
  docit.rocur AS FreeDefinedCurrency1,
  docit.osl AS AmountInFreeDefinedCurrency1
FROM faat_doc_it AS docit
INNER JOIN faac_cmp_da0 AS cmp_da0 ON /* join condition not captured in parsed metadata */
;