C_BR_ImprtFxdAstCrdtAmtSummary

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 C_BR_ImprtFxdAstCrdtAmtSummary.
-- 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: CBRIMPFXDASTSUM

CREATE VIEW C_BR_ImprtFxdAstCrdtAmtSummary AS
SELECT
  CompanyCode,
  AssetClass,
  FiscalYear,
  FiscalPeriod,
  BR_AssetIdentification,
  BR_AssetUsage,
  CreditRecoveryType,
  BR_GLAssetAccount,
  TotalNumberOfAssets,
  BR_AstCrdtQtaBaseAmtInRptgCrcy,
  BR_PISTaxAmount,
  BR_COFINSTaxAmount,
  Currency,
  BR_AssetInfoImportResult,
  GLAccountHierarchy,
  GLAccountHierarchyNode,
  _BR_ImprtAstCrdtAmtSmmrySts.BackgroundJob AS BackgroundJob,
  _BR_ImprtAstCrdtAmtSmmrySts.BackgroundJobName AS BackgroundJobName
FROM I_BR_ImprtFxdAstCrdtAmtSummary
LEFT OUTER JOIN C_BR_ImprtFxdAstCrdtAmountItem AS _BR_ImprtFxdAstCrdtAmountItem ON _BR_ImprtFxdAstCrdtAmountItem.CompanyCode = CompanyCode AND _BR_ImprtFxdAstCrdtAmountItem.AssetClass = AssetClass AND _BR_ImprtFxdAstCrdtAmountItem.FiscalYear = FiscalYear AND _BR_ImprtFxdAstCrdtAmountItem.FiscalPeriod = FiscalPeriod  -- association [1..*]
LEFT OUTER JOIN I_BR_CrdtCtrlCompanyCodeVH AS _CompanyCodeVH ON _CompanyCodeVH.CompanyCode = CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_BR_AssetClassVH AS _AssetClassVH ON _AssetClassVH.CompanyCode = CompanyCode AND _AssetClassVH.AssetClass = AssetClass  -- association [0..1]
LEFT OUTER JOIN I_CreditRecoveryTypeText AS _CreditRecoveryTypeText ON _CreditRecoveryTypeText.CreditRecoveryType = CreditRecoveryType AND _CreditRecoveryTypeText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_BR_AssetInfoImportResult AS _AssetInfoImportResult ON _AssetInfoImportResult.BR_AssetInfoImportResult = BR_AssetInfoImportResult  -- association [1..1]
LEFT OUTER JOIN I_BR_AssetInfoImportResultText AS _AssetInfoImportResultText ON _AssetInfoImportResultText.BR_AssetInfoImportResult = BR_AssetInfoImportResult AND _AssetInfoImportResultText.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN I_BR_AssetIdentificationText AS _BR_AssetIdentificationText ON _BR_AssetIdentificationText.BR_AssetIdentification = BR_AssetIdentification AND _BR_AssetIdentificationText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_BR_AssetUsageText AS _BR_AssetUsageText ON _BR_AssetUsageText.BR_AssetUsage = BR_AssetUsage AND _BR_AssetUsageText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_BR_GLAccountVH AS _GLAccountVH ON _GLAccountVH.BR_GLAssetAccount = BR_GLAssetAccount AND _GLAccountVH.CompanyCode = CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_BR_ImprtAstCrdtAmtSmmrySts AS _BR_ImprtAstCrdtAmtSmmrySts ON _BR_ImprtAstCrdtAmtSmmrySts.CompanyCode = CompanyCode AND _BR_ImprtAstCrdtAmtSmmrySts.AssetClass = AssetClass AND _BR_ImprtAstCrdtAmtSmmrySts.FiscalYear = FiscalYear AND _BR_ImprtAstCrdtAmtSmmrySts.FiscalPeriod = FiscalPeriod association[0..*] to C_HierRuntimeRprstnDplLeafNode as _GLAccountHierLeafNode on BR_GLAssetAccount = _GLAccountHierLeafNode.UnivHierarchyBusinessEntity AND _GLAccountHierLeafNode.ValidityStartDate <= $session.system_date AND _GLAccountHierLeafNode.ValidityEndDate >= $session.system_date AND _GLAccountHierLeafNode.HierarchyType = 'FSVN' association[0..*] to C_GLAcctHierarchyInnerNodeVH as _GLAccountHierarchyInnerNodeVH on BR_GLAssetAccount = _GLAccountHierarchyInnerNodeVH.UniversalHierarchy  -- association [0..1]
;