C_AT_StRpAuditAssetTransacQ

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_AT_StRpAuditAssetTransacQ.
-- 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: CATSTRAUDASTTRAQ
-- Parameters: P_Language : sylangu, P_KeyDate : fagl_keydate, P_BusinessUser : syuname, P_AssetAccountingKeyFigureSet : faa_key_figure_set, P_CompanyCode : fis_bukrs, P_Ledger : fis_rldnr, P_AssetDepreciationArea : fis_afabe, P_FiscalYear : fis_gjahr, P_FiscalPeriod : fis_period_to, P_CurrencyRole : fins_curtp, P_FiscalPeriodEndDate : fagl_keydate, P_SelectedCurrencyBranch : fis_curtp

CREATE VIEW C_AT_StRpAuditAssetTransacQ AS
SELECT
  lookupEntity: 'I_UserSettingsForCompanyCode' AS lookupEntityI_UserSettingsForCompanyCode,
  resultElement: 'CompanyCode' AS resultElementCompanyCode,
  resultElement: 'Ledger' AS resultElementLedger,
  resultElement: 'AssetDepreciationArea' AS resultElementAssetDepreciationArea,
  resultElement: 'FiscalYear' AS resultElementFiscalYear,
  resultElement: 'FiscalPeriod' AS resultElementFiscalPeriod,
  resultElement: 'CompanyCodeCurrencyRole' AS resultElementCompanyCodeCurrencyRole,
  resultElement: 'FiscalPeriodEndDate' AS resultElementFiscalPeriodEndDate,
  resultElement: 'SelectedCurrencyBranch' AS resultElementSelectedCurrencyBranch,
  AssetBal.AssetClass AS AssetClass,
  AssetBal.AssetAccountingSortedKeyFigure AS AssetAccountingKeyFigure,
  AssetBal.DisplayCurrency AS DisplayCurrency,
  cast ( AssetBal.AmountInDisplayCurrency as fis_balance_amount ) AS AmountInDisplayCurrency,
  AssetBal.AcqnProdnCostGLAccount AS AcqnProdnCostGLAccount,
  AssetBal.ChartOfAccounts AS ChartOfAccounts,
  AssetBal.CompanyCode AS CompanyCode,
  AssetBal.LedgerGroup AS LedgerGroup,
  AssetBal.Ledger AS Ledger,
  AssetBal.AssetDepreciationArea AS AssetDepreciationArea,
  AssetBal.ChartOfDepreciation AS ChartOfDepreciation,
  AssetBal.FiscalYear AS FiscalYear,
  AssetBal.FiscalPeriod AS FiscalPeriod,
  AssetBal.FinancialStatementVariant AS FinancialStatementVariant,
  AssetBal.ControllingArea AS ControllingArea,
  AssetBal.AssetPlant AS AssetPlant,
  AssetBal.CostCenter AS CostCenter,
  AssetBal.ProfitCenter AS ProfitCenter,
  AssetBal.Segment AS Segment,
  AssetBal.FundsCenter AS FundsCenter,
  AssetBal.BusinessArea AS BusinessArea,
  AssetBal.MasterFixedAsset AS MasterFixedAsset,
  AssetBal.FixedAsset AS FixedAsset,
  cast(AssetBal.GroupMasterFixedAsset as fis_anlgr) AS GroupMasterFixedAsset,
  cast(AssetBal.GroupFixedAsset as fis_anlgr2) AS GroupFixedAsset,
  AssetBal.PersonnelNumber AS PersonnelNumber,
  AssetBal.AssetPersonnelNumber AS AssetPersonnelNumber,
  AssetBal.FinancialManagementArea AS FinancialManagementArea,
  AssetBal.Fund AS Fund,
  AssetBal.GrantID AS GrantID,
  AssetBal.FunctionalArea AS FunctionalArea,
  AssetBal.BudgetPeriod AS BudgetPeriod,
  AssetBal.SubLedgerAcctLineItemType AS SubLedgerAcctLineItemType,
  AssetBal.AssetTransactionType AS AssetTransactionType,
  AssetBal.AssetAcctTransClassfctn AS AssetAcctTransClassfctn,
  AssetBal.FinancialAccountType AS FinancialAccountType,
  AssetBal.AccountingDocumentCreationDate AS AccountingDocumentCreationDate,
  AssetBal.CreationTime AS CreationTime,
  AssetBal.JointVentureCostRecoveryCode AS JointVentureCostRecoveryCode,
  AssetBal.AccountingPrinciple AS AccountingPrinciple,
  AssetBal.FiscalYearVariant AS FiscalYearVariant,
  AssetBal.CountryChartOfAccounts AS CountryChartOfAccounts,
  AssetBal.GLAccount AS GLAccount,
  AssetBal.AlternativeGLAccount AS AlternativeGLAccount,
  AssetBal.AssetBusinessArea AS AssetBusinessArea,
  AssetBal.AssetCostCenter AS AssetCostCenter,
  AssetBal.AssetProfitCenter AS AssetProfitCenter,
  AssetBal.AssetSegment AS AssetSegment,
  AssetBal.AssetBudgetPeriod AS AssetBudgetPeriod,
  AssetBal.AssetGrant AS AssetGrant,
  AssetBal.AssetFund AS AssetFund,
  AssetBal.AssetLocation AS AssetLocation,
  AssetBal.AssetFundsCenter AS AssetFundsCenter,
  AssetBal.RealEstateObject AS RealEstateObject,
  AssetBal.AssetCostCtrActivityType AS AssetCostCtrActivityType,
  AssetBal.FirstAcquisitionFiscalYear AS FirstAcquisitionFiscalYear,
  AssetBal.FirstAcquisitionFiscalPeriod AS FirstAcquisitionFiscalPeriod,
  AssetBal.AssetCapitalizationDate AS AssetCapitalizationDate,
  AssetBal.AssetDeactivationDate AS AssetDeactivationDate,
  AssetBal.FixedAssetGroup AS FixedAssetGroup,
  AssetBal.Supplier AS Supplier,
  AssetBal.AssetSupplierName AS AssetSupplierName,
  AssetBal.InvestmentOrder AS InvestmentOrder,
  AssetBal.BaseUnit AS BaseUnit,
  AssetBal.InventoryIsCounted AS InventoryIsCounted,
  AssetBal.LastInventoryDate AS LastInventoryDate,
  AssetBal.Inventory AS Inventory,
  AssetBal.Group1AssetEvaluationKey AS Group1AssetEvaluationKey,
  AssetBal.Group2AssetEvaluationKey AS Group2AssetEvaluationKey,
  AssetBal.Group3AssetEvaluationKey AS Group3AssetEvaluationKey,
  AssetBal.Group4AssetEvaluationKey AS Group4AssetEvaluationKey,
  AssetBal.Group5AssetEvaluationKey AS Group5AssetEvaluationKey,
  AssetBal.AssetSerialNumber AS AssetSerialNumber,
  AssetBal.InvestmentSupportMeasure AS InvestmentSupportMeasure,
  AssetBal.DepreciationStartDate AS DepreciationStartDate,
  AssetBal.SpecialDeprStartDate AS SpecialDeprStartDate,
  AssetBal.DepreciationKey AS DepreciationKey,
  AssetBal.PlannedUsefulLifeInYears AS PlannedUsefulLifeInYears,
  AssetBal.PlannedUsefulLifeInPeriods AS PlannedUsefulLifeInPeriods,
  AssetBal.Country AS Country,
  AssetBal.NationalClassification AS NationalClassification,
  AssetBal.TaxDepreciationGroup AS TaxDepreciationGroup,
  AssetBal.AccountingDocument AS AccountingDocument,
  AssetBal.Room AS Room,
  AssetBal.VehicleLicensePlateNumber AS VehicleLicensePlateNumber,
  AssetBal.TaxJurisdiction AS TaxJurisdiction,
  AssetBal.WBSElementExternalID AS WBSElementExternalID
FROM I_AssetBalanceCube
LEFT OUTER JOIN I_AssetKeyFigureSet AS _AssetKeyFigureSet ON _AssetKeyFigureSet.AssetAccountingKeyFigureSet = :P_AssetAccountingKeyFigureSet AND _AssetKeyFigureSet.AssetAcctgKeyFigSetAnlytlCntxt = '02'  -- association [0..1]
LEFT OUTER JOIN I_CompanyCodeAsset AS _CompanyCodeAssetVH ON _CompanyCodeAssetVH.CompanyCode = :P_CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_FiscalYearForCompanyCode AS _FiscalYearVH ON _FiscalYearVH.FiscalYear = :P_FiscalYear AND _FiscalYearVH.CompanyCode = :P_CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_FiscalYearPeriodForLedger AS _FiscalYearPeriodVH ON _FiscalYearPeriodVH.CompanyCode = :P_CompanyCode AND _FiscalYearPeriodVH.Ledger = :P_Ledger AND _FiscalYearPeriodVH.FiscalYear = :P_FiscalYear AND _FiscalYearPeriodVH.FiscalPeriod = :P_FiscalPeriod  -- association [0..1]
;