FAA_SDM_BALANCE01

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_BALANCE01.
-- 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: FAAVBALANCE01
-- Parameters: P_AssetAccountingKeyFigureSet : faa_key_figure_set, P_FiscalYear : fis_gjahr, P_FiscalPeriod : fis_poper

CREATE VIEW FAA_SDM_BALANCE01 AS
SELECT
  Values.CompanyCode AS CompanyCode,
  Values.AssetDepreciationArea AS AssetDepreciationArea,
  Values.MasterFixedAsset AS MasterFixedAsset,
  Values.FixedAsset AS FixedAsset,
  Values.Ledger AS Ledger,
  Values.FiscalYear AS FiscalYear,
  Values.FiscalPeriod AS FiscalPeriod,
  Values.SubLedgerAcctLineItemType AS SubLedgerAcctLineItemType,
  Values.AssetAcctTransClassfctn AS AssetAcctTransClassfctn,
  AssetKeyFigureSetSpec.AssetAccountingKeyFigure AS AssetAccountingKeyFigure,
  AssetKeyFigureSetSpec.AssetAccountingKeyFigureSet AS AssetAccountingKeyFigureSet,
  Values.AccountingDocument AS AccountingDocument,
  Values.LedgerGLLineItem AS LedgerGLLineItem,
  Values.TransactionSubitem AS TransactionSubitem,
  Values.DebitCreditCode AS DebitCreditCode,
  Values.ReferenceDocument AS ReferenceDocument,
  Values.LogicalSystem AS LogicalSystem,
  Values.ReferenceDocumentContext AS ReferenceDocumentContext,
  Values.ReferenceDocumentType AS ReferenceDocumentType,
  Values.CompanyCodeCurrency AS CompanyCodeCurrency,
  Values.GlobalCurrency AS GlobalCurrency,
  Values.FreeDefinedCurrency1 AS FreeDefinedCurrency1,
  Values.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  Values.AmountInGlobalCurrency AS AmountInGlobalCurrency,
  Values.AmountInFreeDefinedCurrency1 AS AmountInFreeDefinedCurrency1,
  cast( LedgerCompanyCodeCrcyRole.curtph as fis_cc_currole preserving type ) AS CompanyCodeCurrencyRole,
  cast( LedgerCompanyCodeCrcyRole.curtpk as fis_gc_currole preserving type ) AS GlobalCurrencyRole,
  cast( LedgerCompanyCodeCrcyRole.curtpo as fis_gc_currole preserving type ) AS FreeDefinedCurrency1Role
FROM finsc_ld_cmp AS LedgerCompanyCodeCrcyRole
INNER JOIN FAA_SDM_BALANCE02 AS Values ON /* join condition not captured in parsed metadata */
INNER JOIN I_AssetKeyFigureSetSpec AS AssetKeyFigureSetSpec ON /* join condition not captured in parsed metadata */
INNER JOIN I_AssetKeyFigureSpecification AS AssetKeyFigureSpec ON /* join condition not captured in parsed metadata */
INNER JOIN faat_md_root AS FixedAsset ON /* join condition not captured in parsed metadata */
INNER JOIN FAA_SDM_BALANCE03 AS Values ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): finsc_ld_cmp
;