P_FixedAssetValue

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_FixedAssetValue.
-- 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

CREATE VIEW P_FixedAssetValue AS
SELECT
  values.AssetDepreciationArea AS AssetDepreciationArea,
  values.CompanyCode AS CompanyCode,
  values.FiscalYear AS FiscalYear,
  values.MasterFixedAsset AS MasterFixedAsset,
  values.FixedAsset AS FixedAsset,
  values.AccountingDocument AS AccountingDocument,
  values.TransactionSubitem AS TransactionSubitem,
  values.Ledger AS Ledger,
  values.FiscalPeriod AS FiscalPeriod,
  values.SubLedgerAcctLineItemType AS SubLedgerAcctLineItemType,
  values.AssetAcctTransClassfctn AS AssetAcctTransClassfctn,
  values.DebitCreditCode AS DebitCreditCode,
  LedgerFiscalYear,
  FiscalYearVariant,
  FiscalYearPeriod,
  DepreciationFiscalPeriod,
  AssetKeyFigureSetSpec.AssetAccountingSortedKeyFigure AS AssetAccountingSortedKeyFigure,
  values.AssetAcctAnlytlTransClassfctn AS AssetAcctAnlytlTransClassfctn,
  values.LedgerGroup AS LedgerGroup,
  values.ChartOfAccounts AS ChartOfAccounts,
  values.CountryChartOfAccounts AS CountryChartOfAccounts,
  values.GLAccount AS GLAccount,
  values.AlternativeGLAccount AS AlternativeGLAccount,
  values.GroupMasterFixedAsset AS GroupMasterFixedAsset,
  values.GroupFixedAsset AS GroupFixedAsset,
  values.FinancialAccountType AS FinancialAccountType,
  values.ChartOfDepreciation AS ChartOfDepreciation,
  values.AccountingDocumentCreationDate AS AccountingDocumentCreationDate,
  values.CreationTime AS CreationTime,
  values.AccountingDocCreatedByUser AS AccountingDocCreatedByUser,
  values.JointVentureCostRecoveryCode AS JointVentureCostRecoveryCode,
  values.CostCenter AS CostCenter,
  values.Plant AS Plant,
  values.BusinessArea AS BusinessArea,
  values.PersonnelNumber AS PersonnelNumber,
  values.FinancialManagementArea AS FinancialManagementArea,
  values.Fund AS Fund,
  values.GrantID AS GrantID,
  values.FunctionalArea AS FunctionalArea,
  values.BudgetPeriod AS BudgetPeriod,
  values.ProfitCenter AS ProfitCenter,
  values.Segment AS Segment,
  values.FundsCenter AS FundsCenter,
  values.AssetTransactionType AS AssetTransactionType,
  values.AssetDeactivationDate AS AssetDeactivationDate,
  AssetKeyFigureSpec.AssetAccountingKeyFigure AS AssetAccountingKeyFigure,
  AssetKeyFigureSpec.PlannedValueIsInclusive AS PlannedValueIsInclusive,
  values.ReferenceDocumentItem AS ReferenceDocumentItem,
  values.ReferenceDocumentType AS ReferenceDocumentType,
  values.LogicalSystem AS LogicalSystem,
  values.ReferenceDocument AS ReferenceDocument,
  values.ReferenceDocumentContext AS ReferenceDocumentContext,
  values.ReversalReferenceDocument AS ReversalReferenceDocument,
  values.ReversalReferenceDocumentCntxt AS ReversalReferenceDocumentCntxt,
  values.ReversalTransactionSubitem AS ReversalTransactionSubitem,
  values.IsReversal AS IsReversal,
  values.IsReversed AS IsReversed,
  values.DocumentDate AS DocumentDate,
  values.PostingDate AS PostingDate,
  values.AssetValueDate AS AssetValueDate,
  values.AccountingDocumentType AS AccountingDocumentType,
  values.AssignmentReference AS AssignmentReference,
  values.DocumentItemText AS DocumentItemText,
  values.IsStatisticalDocument AS IsStatisticalDocument,
  values.GLBusinessTransactionType AS GLBusinessTransactionType,
  values.PartnerMasterFixedAsset AS PartnerMasterFixedAsset,
  values.PartnerFixedAsset AS PartnerFixedAsset,
  values.CompanyCodeCurrency AS CompanyCodeCurrency,
  values.GlobalCurrency AS GlobalCurrency,
  values.FreeDefinedCurrency1 AS FreeDefinedCurrency1,
  values.FreeDefinedCurrency2 AS FreeDefinedCurrency2,
  values.FreeDefinedCurrency3 AS FreeDefinedCurrency3,
  values.FreeDefinedCurrency4 AS FreeDefinedCurrency4,
  values.FreeDefinedCurrency5 AS FreeDefinedCurrency5,
  values.FreeDefinedCurrency6 AS FreeDefinedCurrency6,
  values.FreeDefinedCurrency7 AS FreeDefinedCurrency7,
  values.FreeDefinedCurrency8 AS FreeDefinedCurrency8,
  values.ActualAmountInCompanyCodeCrcy AS ActualAmountInCompanyCodeCrcy,
  values.ActualAmountInGlobalCurrency AS ActualAmountInGlobalCurrency,
  values.ActualAmountInFreeDfndCrcy1 AS ActualAmountInFreeDfndCrcy1,
  values.ActualAmountInFreeDfndCrcy2 AS ActualAmountInFreeDfndCrcy2,
  values.ActualAmountInFreeDfndCrcy3 AS ActualAmountInFreeDfndCrcy3,
  values.ActualAmountInFreeDfndCrcy4 AS ActualAmountInFreeDfndCrcy4,
  values.ActualAmountInFreeDfndCrcy5 AS ActualAmountInFreeDfndCrcy5,
  values.ActualAmountInFreeDfndCrcy6 AS ActualAmountInFreeDfndCrcy6,
  values.ActualAmountInFreeDfndCrcy7 AS ActualAmountInFreeDfndCrcy7,
  values.ActualAmountInFreeDfndCrcy8 AS ActualAmountInFreeDfndCrcy8,
  values.PlanAmountInCompanyCodeCrcy AS PlanAmountInCompanyCodeCrcy,
  values.PlanAmountInGlobalCurrency AS PlanAmountInGlobalCurrency,
  values.PlanAmountInFreeDefinedCrcy1 AS PlanAmountInFreeDefinedCrcy1,
  values.PlanAmountInFreeDefinedCrcy2 AS PlanAmountInFreeDefinedCrcy2,
  values.PlanAmountInFreeDefinedCrcy3 AS PlanAmountInFreeDefinedCrcy3,
  values.PlanAmountInFreeDefinedCrcy4 AS PlanAmountInFreeDefinedCrcy4,
  values.PlanAmountInFreeDefinedCrcy5 AS PlanAmountInFreeDefinedCrcy5,
  values.PlanAmountInFreeDefinedCrcy6 AS PlanAmountInFreeDefinedCrcy6,
  values.PlanAmountInFreeDefinedCrcy7 AS PlanAmountInFreeDefinedCrcy7,
  values.PlanAmountInFreeDefinedCrcy8 AS PlanAmountInFreeDefinedCrcy8,
  BaseUnit,
  Quantity
FROM P_FixedAssetValueWthDetn
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 */
;