P_AstBalDeprOvrDeprComprn

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 P_AstBalDeprOvrDeprComprn.
-- 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.
-- Parameters: P_AssetAccountingKeyFigureSet : faa_key_figure_set, P_FiscalYear : fis_ryear, P_FiscalPeriod : fis_period_to, P_FiscalYearEndDate : fagl_keydate, P_FiscalPeriodEndDate : fagl_keydate, P_AssetDepreciationArea : fis_afabe_d, P_ComparisonDepreciationArea : fis_afabe_d

CREATE VIEW P_AstBalDeprOvrDeprComprn AS
SELECT
  AssetBal.CompanyCode AS CompanyCode,
  AssetBal.AssetDepreciationArea AS AssetDepreciationArea,
  AssetBal.MasterFixedAsset AS MasterFixedAsset,
  AssetBal.FixedAsset AS FixedAsset,
  AssetBal.Ledger AS Ledger,
  AssetBal.FiscalYear AS FiscalYear,
  AssetBal.FiscalPeriod AS FiscalPeriod,
  AssetBal.SubLedgerAcctLineItemType AS SubLedgerAcctLineItemType,
  AssetBal.AssetAcctTransClassfctn AS AssetAcctTransClassfctn,
  AssetBal.AssetAccountingKeyFigure AS AssetAccountingKeyFigure,
  AssetBal.AssetAccountingKeyFigureSet AS AssetAccountingKeyFigureSet,
  AssetBal.AccountingDocument AS AccountingDocument,
  AssetBal.LedgerGLLineItem AS LedgerGLLineItem,
  AssetBal.TransactionSubitem AS TransactionSubitem,
  AssetBal.DebitCreditCode AS DebitCreditCode,
  AssetBal.CurrencyRole AS CurrencyRole,
  AssetBal.AssetAccountDetermination AS AssetAccountDetermination,
  AssetBal.AssetClass AS AssetClass,
  AssetBal.AssetAccountingSortedKeyFigure AS AssetAccountingSortedKeyFigure,
  AssetBal.Quantity AS Quantity,
  AssetBal.AcqnProdnCostGLAccount AS AcqnProdnCostGLAccount,
  AssetBal.ChartOfAccounts AS ChartOfAccounts,
  AssetBal.AssetPlant AS AssetPlant,
  AssetBal.CostCenter AS CostCenter,
  AssetBal.ProfitCenter AS ProfitCenter,
  AssetBal.Segment AS Segment,
  AssetBal.FundsCenter AS FundsCenter,
  AssetBal.FunctionalArea AS FunctionalArea,
  AssetBal.AssetTransactionType AS AssetTransactionType,
  AssetBal.BusinessTransactionCategory AS BusinessTransactionCategory,
  AssetBal.BusinessTransactionType AS BusinessTransactionType,
  AssetBal.FinancialClosingStep AS FinancialClosingStep,
  AssetBal.AccountingDocumentCreationDate AS AccountingDocumentCreationDate,
  AssetBal.PostingDate AS PostingDate,
  AssetBal.CreationTime AS CreationTime,
  AssetBal.FiscalYearVariant AS FiscalYearVariant,
  AssetBal.GLAccount AS GLAccount,
  AssetBal.AlternativeGLAccount AS AlternativeGLAccount,
  AssetBal.AssetCostCenter AS AssetCostCenter,
  AssetBal.AssetWBSElementExternalID AS AssetWBSElementExternalID,
  AssetBal.AssetProfitCenter AS AssetProfitCenter,
  AssetBal.AssetSegment AS AssetSegment,
  AssetBal.AssetFunctionalArea AS AssetFunctionalArea,
  AssetBal.GrantID AS GrantID,
  AssetBal.AssetGrant AS AssetGrant,
  AssetBal.Fund AS Fund,
  AssetBal.AssetFund AS AssetFund,
  AssetBal.AssetLocation AS AssetLocation,
  AssetBal.AssetFundsCenter AS AssetFundsCenter,
  AssetBal.FirstAcquisitionFiscalYear AS FirstAcquisitionFiscalYear,
  AssetBal.FirstAcquisitionFiscalPeriod AS FirstAcquisitionFiscalPeriod,
  AssetBal.AssetCapitalizationDate AS AssetCapitalizationDate,
  AssetBal.AssetDeactivationDate AS AssetDeactivationDate,
  AssetBal.Supplier AS Supplier,
  AssetBal.AssetSupplierName AS AssetSupplierName,
  AssetBal.LastInventoryDate AS LastInventoryDate,
  AssetBal.Inventory AS Inventory,
  AssetBal.AssetSerialNumber AS AssetSerialNumber,
  AssetBal.DepreciationStartDate AS DepreciationStartDate,
  AssetBal.SpecialDeprStartDate AS SpecialDeprStartDate,
  AssetBal.DepreciationKey AS DepreciationKey,
  AssetBal.PlannedUsefulLifeInYears AS PlannedUsefulLifeInYears,
  AssetBal.PlannedUsefulLifeInPeriods AS PlannedUsefulLifeInPeriods,
  AssetBal.FixedAssetUsageObject AS FixedAssetUsageObject,
  AssetBal.AssetRevaluationIndex AS AssetRevaluationIndex,
  AssetBal.Country AS Country,
  AssetBal.Room AS Room,
  AssetBal.VehicleLicensePlateNumber AS VehicleLicensePlateNumber,
  AssetBal.TaxJurisdiction AS TaxJurisdiction,
  AssetBal.WBSElementExternalID AS WBSElementExternalID,
  AssetBal.SelectedCurrencyBranch AS SelectedCurrencyBranch,
  AssetBal.AmountInDisplayCurrency AS AmountInDisplayCurrency,
  AssetBal.DisplayCurrency AS DisplayCurrency,
  AssetBal.BaseUnit AS BaseUnit
FROM I_AssetBalanceCube
;