P_FixedAssetLineItem1

DDL: P_FIXEDASSETLINEITEM1 Type: view COMPOSITE Package: FINS_FIS_AA_MD
205 Fields 2 Data Sources

P_FixedAssetLineItem1

P_FixedAssetLineItem1 is a Composite CDS View that provides data about "P_FixedAssetLineItem1" in SAP S/4HANA. It reads from 2 data sources (I_FxdAstActualLineItem, I_AssetSimulatedDueDeprValues) and exposes 205 fields with key fields AssetDepreciationArea, CompanyCode, FiscalYear, MasterFixedAsset, FixedAsset. Part of development package FINS_FIS_AA_MD.

Data Sources (2)

SourceAliasJoin Type
I_FxdAstActualLineItem acdoca from
I_AssetSimulatedDueDeprValues duevalues union_all

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName PFASSETLINEITEM view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.buffering.status #NOT_ALLOWED view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
VDM.private true view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (205)

KeyFieldSource TableSource FieldDescription
KEY AssetDepreciationArea I_FxdAstActualLineItem AssetDepreciationArea Deprec. Area
KEY CompanyCode I_FxdAstActualLineItem CompanyCode Receiver Company Code
KEY FiscalYear I_FxdAstActualLineItem FiscalYear G/L Fiscal Year
KEY MasterFixedAsset I_FxdAstActualLineItem MasterFixedAsset Fixed Asset
KEY FixedAsset I_FxdAstActualLineItem FixedAsset Sub-number
KEY SubLedgerAcctLineItemType I_FxdAstActualLineItem SubLedgerAcctLineItemType SLALineItemType
KEY FiscalPeriod I_FxdAstActualLineItem FiscalPeriod Tax period
KEY LedgerGroup Ledger Group
KEY AccountingDocument I_FxdAstActualLineItem AccountingDocument Journal Entry
KEY LedgerGLLineItem LedgerGLLineItem Journal Entry Item
KEY Ledger I_FxdAstActualLineItem Ledger Ledger
KEY TransactionSubitem I_FxdAstActualLineItem TransactionSubitem Sub Transaction
KEY DebitCreditCode I_FxdAstActualLineItem DebitCreditCode Single-Character Flag
AccountingPrinciple I_FxdAstActualLineItem AccountingPrinciple AP Ledger/CoCode
LedgerFiscalYear I_FxdAstActualLineItem LedgerFiscalYear
FiscalYearVariant I_FxdAstActualLineItem FiscalYearVariant FY Variant
FiscalYearPeriod I_FxdAstActualLineItem FiscalYearPeriod Period/Year
ChartOfAccounts I_FxdAstActualLineItem ChartOfAccounts Node Class
GLAccount I_FxdAstActualLineItem GLAccount General Ledger
CountryChartOfAccounts I_FxdAstActualLineItem CountryChartOfAccounts Chart of Accts
AlternativeGLAccount
IsStatisticalDocument IsStatisticalDocument
AssetAcctTransClassfctn I_FxdAstActualLineItem AssetAcctTransClassfctn Trans.Type Cat.
GroupMasterFixedAsset I_FxdAstActualLineItem GroupMasterFixedAsset Group Asset
GroupFixedAsset I_FxdAstActualLineItem GroupFixedAsset Subnumber
FinancialAccountType I_FxdAstActualLineItem FinancialAccountType Fin. Account Type
ChartOfDepreciation I_FxdAstActualLineItem ChartOfDepreciation
ReferenceDocumentItem I_FxdAstActualLineItem ReferenceDocumentItem Reference item
ReferenceDocumentType I_FxdAstActualLineItem ReferenceDocumentType Reference Document Type
LogicalSystem I_FxdAstActualLineItem LogicalSystem Logical System
ReferenceDocument I_FxdAstActualLineItem ReferenceDocument Reference Document
ReferenceDocumentContext I_FxdAstActualLineItem ReferenceDocumentContext Reference Document Context
PredecessorReferenceDocument I_FxdAstActualLineItem PredecessorReferenceDocument Predecessor Reference Document
PredecessorReferenceDocItem I_FxdAstActualLineItem PredecessorReferenceDocItem Prec. Ref. Doc. Item
PredecessorJournalEntry I_FxdAstActualLineItem PredecessorJournalEntry Predecessor Journal Entry
PredecessorReferenceDocCntxt I_FxdAstActualLineItem PredecessorReferenceDocCntxt Predecessor Reference Document Context
PredecessorReferenceDocType I_FxdAstActualLineItem PredecessorReferenceDocType Predecessor Reference Document Type
ReversalReferenceDocument
ReversalReferenceDocumentCntxt I_FxdAstActualLineItem ReversalReferenceDocumentCntxt Reversal Reference Document Context
IsReversal I_FxdAstActualLineItem IsReversal Reversal doc.
IsReversed I_FxdAstActualLineItem IsReversed Reversed?
DocumentDate I_FxdAstActualLineItem DocumentDate Journal Entry Date
PostingDate I_FxdAstActualLineItem PostingDate Posting Date for GR
AssetTransactionType I_FxdAstActualLineItem AssetTransactionType Trans.Type
AssetValueDate I_FxdAstActualLineItem AssetValueDate Reference date
AccountingDocumentCreationDate I_FxdAstActualLineItem AccountingDocumentCreationDate Journal Entry Date
CreationTime I_FxdAstActualLineItem CreationTime Time of Change
DocumentItemText I_FxdAstActualLineItem DocumentItemText Text
AccountingDocCreatedByUser I_FxdAstActualLineItem AccountingDocCreatedByUser User which created overhead document
GLBusinessTransactionType I_FxdAstActualLineItem GLBusinessTransactionType Transact. Type
FinancialClosingStep I_FxdAstActualLineItem FinancialClosingStep Closing Step
BusinessTransactionType I_FxdAstActualLineItem BusinessTransactionType Bus.transaction
BusinessTransactionCategory I_FxdAstActualLineItem BusinessTransactionCategory Business Transaction Category
AssignmentReference I_FxdAstActualLineItem AssignmentReference Assignment Reference
JointVentureCostRecoveryCode I_FxdAstActualLineItem JointVentureCostRecoveryCode Recovery Ind.
DepreciationFiscalPeriod I_FxdAstActualLineItem DepreciationFiscalPeriod Deprec. Period
AccountingDocumentItem I_FxdAstActualLineItem AccountingDocumentItem Posting View Item
ReversalTransactionSubitem I_FxdAstActualLineItem ReversalTransactionSubitem Reversal Sub Trans
PurchasingDocument I_FxdAstActualLineItem PurchasingDocument Purchasing Document
PurchasingDocumentItem I_FxdAstActualLineItem PurchasingDocumentItem Purchasing Doc. Item
CostCenter I_FxdAstActualLineItem CostCenter Cost Center
Plant I_FxdAstActualLineItem Plant Valuation Area
BusinessArea I_FxdAstActualLineItem BusinessArea Business Area
PersonnelNumber I_FxdAstActualLineItem PersonnelNumber Personnel No.
FinancialManagementArea I_FxdAstActualLineItem FinancialManagementArea FM Area
Fund I_FxdAstActualLineItem Fund Sender Fund
GrantID I_FxdAstActualLineItem GrantID Sender Grant
FunctionalArea I_FxdAstActualLineItem FunctionalArea Sendr Fctl Area
BudgetPeriod I_FxdAstActualLineItem BudgetPeriod Budget Period
ProfitCenter I_FxdAstActualLineItem ProfitCenter Profit Center
Segment I_FxdAstActualLineItem Segment Segment number
ControllingArea I_FxdAstActualLineItem ControllingArea Controlling Area
Country I_CompanyCode Country Venue: Ctry/Reg
FundsCenter I_FxdAstActualLineItem FundsCenter Funds Center
AccountingDocumentType AccountingDocumentType Journal Entry Type
PartnerCompanyCode I_FxdAstActualLineItem PartnerCompanyCode Partner Company Code
PartnerMasterFixedAsset I_FxdAstActualLineItem PartnerMasterFixedAsset Partner Asset
PartnerFixedAsset I_FxdAstActualLineItem PartnerFixedAsset Partner Sub-No.
JrnlEntryItemMigrationSource I_FxdAstActualLineItem JrnlEntryItemMigrationSource
CompanyCodeCurrency I_FxdAstActualLineItem CompanyCodeCurrency Local Currency
AmountInCompanyCodeCurrency I_FxdAstActualLineItem AmountInCompanyCodeCurrency Local Crcy Amt
GlobalCurrency I_FxdAstActualLineItem GlobalCurrency GM Billing Element: Global Currency
AmountInGlobalCurrency I_FxdAstActualLineItem AmountInGlobalCurrency Amount in Global Currency
FunctionalCurrency I_FxdAstActualLineItem FunctionalCurrency Functional Currency
AmountInFunctionalCurrency I_FxdAstActualLineItem AmountInFunctionalCurrency Amount in Functional Currency
FreeDefinedCurrency1 I_FxdAstActualLineItem FreeDefinedCurrency1 Freely Defined Currency 1
AmountInFreeDefinedCurrency1 I_FxdAstActualLineItem AmountInFreeDefinedCurrency1 Amount in Freely Defined Currency 1
FreeDefinedCurrency2 I_FxdAstActualLineItem FreeDefinedCurrency2 Freely Defined Currency 2
AmountInFreeDefinedCurrency2 I_FxdAstActualLineItem AmountInFreeDefinedCurrency2 Amount in Freely Defined Currency 2
FreeDefinedCurrency3 I_FxdAstActualLineItem FreeDefinedCurrency3 Freely Defined Currency 3
AmountInFreeDefinedCurrency3 I_FxdAstActualLineItem AmountInFreeDefinedCurrency3 Amount in Freely Defined Currency 3
FreeDefinedCurrency4 I_FxdAstActualLineItem FreeDefinedCurrency4 Freely Defined Currency 4
AmountInFreeDefinedCurrency4 I_FxdAstActualLineItem AmountInFreeDefinedCurrency4 Amount in Freely Defined Currency 4
FreeDefinedCurrency5 I_FxdAstActualLineItem FreeDefinedCurrency5 Freely Defined Currency 5
AmountInFreeDefinedCurrency5 I_FxdAstActualLineItem AmountInFreeDefinedCurrency5 Amount in Freely Defined Currency 5
FreeDefinedCurrency6 I_FxdAstActualLineItem FreeDefinedCurrency6 Freely Defined Currency 6
AmountInFreeDefinedCurrency6 I_FxdAstActualLineItem AmountInFreeDefinedCurrency6 Amount in Freely Defined Currency 6
FreeDefinedCurrency7 I_FxdAstActualLineItem FreeDefinedCurrency7 Freely Defined Currency 7
AmountInFreeDefinedCurrency7 I_FxdAstActualLineItem AmountInFreeDefinedCurrency7 Amount in Freely Defined Currency 7
FreeDefinedCurrency8 I_FxdAstActualLineItem FreeDefinedCurrency8 Freely Defined Currency 8
AmountInFreeDefinedCurrency8 I_FxdAstActualLineItem AmountInFreeDefinedCurrency8 Amount in Freely Defined Currency 8
BaseUnit I_FxdAstActualLineItem BaseUnit Unit of Measure
AssetDepreciationArea Deprec. Area
KEY CompanyCode I_AssetSimulatedDueDeprValues CompanyCode Receiver Company Code
KEY FiscalYear I_AssetSimulatedDueDeprValues FiscalYear G/L Fiscal Year
KEY MasterFixedAsset I_AssetSimulatedDueDeprValues MasterFixedAsset Fixed Asset
KEY FixedAsset I_AssetSimulatedDueDeprValues FixedAsset Sub-number
KEY SubLedgerAcctLineItemType I_AssetSimulatedDueDeprValues SubLedgerAcctLineItemType SLALineItemType
KEY FiscalPeriod I_AssetSimulatedDueDeprValues FiscalPeriod Tax period
KEY LedgerGroup I_AssetSimulatedDueDeprValues LedgerGroup Ledger Group
KEY AccountingDocument Journal Entry
KEY LedgerGLLineItem Journal Entry Item
KEY Ledger I_AssetSimulatedDueDeprValues Ledger Ledger
KEY TransactionSubitem Sub Transaction
KEY DebitCreditCode Single-Character Flag
AccountingPrinciple I_AssetSimulatedDueDeprValues AccountingPrinciple AP Ledger/CoCode
LedgerFiscalYear LedgerFiscalYear
FiscalYearVariant I_CompanyCode FiscalYearVariant FY Variant
FiscalYearPeriod Period/Year
ChartOfAccounts Node Class
GLAccount General Ledger
CountryChartOfAccounts I_CompanyCode CountryChartOfAccounts Chart of Accts
AlternativeGLAccount
IsStatisticalDocument
AssetAcctTransClassfctn I_AssetSimulatedDueDeprValues AssetAcctTransClassfctn Trans.Type Cat.
GroupMasterFixedAsset I_AssetSimulatedDueDeprValues GroupMasterFixedAsset Group Asset
GroupFixedAsset I_AssetSimulatedDueDeprValues GroupFixedAsset Subnumber
FinancialAccountType Fin. Account Type
ChartOfDepreciation I_ChartOfDeprForAcctgPrinciple ChartOfDepreciation
ReferenceDocumentItem Reference item
ReferenceDocumentType Reference Document Type
LogicalSystem Logical System
ReferenceDocument Reference Document
ReferenceDocumentContext Reference Document Context
PredecessorReferenceDocument Predecessor Reference Document
PredecessorReferenceDocItem Prec. Ref. Doc. Item
PredecessorJournalEntry Predecessor Journal Entry
PredecessorReferenceDocCntxt Predecessor Reference Document Context
PredecessorReferenceDocType Predecessor Reference Document Type
ReversalReferenceDocument
ReversalReferenceDocumentCntxt Reversal Reference Document Context
IsReversal Reversal doc.
IsReversed Reversed?
DocumentDate Journal Entry Date
PostingDate Posting Date for GR
AssetTransactionType I_AssetSimulatedDueDeprValues AssetTransactionType Trans.Type
AssetValueDate Reference date
AccountingDocumentCreationDate Journal Entry Date
CreationTime Time of Change
DocumentItemText Text
AccountingDocCreatedByUser User which created overhead document
GLBusinessTransactionType Transact. Type
FinancialClosingStep Closing Step
BusinessTransactionType Bus.transaction
BusinessTransactionCategory Business Transaction Category
AssignmentReference Assignment Reference
JointVentureCostRecoveryCode Recovery Ind.
DepreciationFiscalPeriod Deprec. Period
AccountingDocumentItem Posting View Item
ReversalTransactionSubitem Reversal Sub Trans
PurchasingDocument Purchasing Document
PurchasingDocumentItem Purchasing Doc. Item
CostCenter Cost Center
Plant Valuation Area
BusinessArea Business Area
PersonnelNumber Personnel No.
FinancialManagementArea I_CompanyCode FinancialManagementArea FM Area
Fund Sender Fund
GrantID Sender Grant
FunctionalArea Sendr Fctl Area
BudgetPeriod Budget Period
ProfitCenter Profit Center
Segment Segment number
ControllingArea I_CompanyCode ControllingArea Controlling Area
Country I_CompanyCode Country Venue: Ctry/Reg
FundsCenter Funds Center
AccountingDocumentType Journal Entry Type
PartnerCompanyCode Partner Company Code
PartnerMasterFixedAsset Partner Asset
PartnerFixedAsset Partner Sub-No.
JrnlEntryItemMigrationSource
CompanyCodeCurrency I_AssetSimulatedDueDeprValues CompanyCodeCurrency Local Currency
AmountInCompanyCodeCurrency I_AssetSimulatedDueDeprValues AmountInCompanyCodeCurrency Local Crcy Amt
GlobalCurrency I_AssetSimulatedDueDeprValues GlobalCurrency GM Billing Element: Global Currency
AmountInGlobalCurrency I_AssetSimulatedDueDeprValues AmountInGlobalCurrency Amount in Global Currency
FunctionalCurrency Functional Currency
AmountInFunctionalCurrency Amount in Functional Currency
FreeDefinedCurrency1 I_AssetSimulatedDueDeprValues FreeDefinedCurrency1 Freely Defined Currency 1
AmountInFreeDefinedCurrency1 I_AssetSimulatedDueDeprValues AmountInFreeDefinedCurrency1 Amount in Freely Defined Currency 1
FreeDefinedCurrency2 I_AssetSimulatedDueDeprValues FreeDefinedCurrency2 Freely Defined Currency 2
AmountInFreeDefinedCurrency2 I_AssetSimulatedDueDeprValues AmountInFreeDefinedCurrency2 Amount in Freely Defined Currency 2
FreeDefinedCurrency3 I_AssetSimulatedDueDeprValues FreeDefinedCurrency3 Freely Defined Currency 3
AmountInFreeDefinedCurrency3 I_AssetSimulatedDueDeprValues AmountInFreeDefinedCurrency3 Amount in Freely Defined Currency 3
FreeDefinedCurrency4 I_AssetSimulatedDueDeprValues FreeDefinedCurrency4 Freely Defined Currency 4
AmountInFreeDefinedCurrency4 I_AssetSimulatedDueDeprValues AmountInFreeDefinedCurrency4 Amount in Freely Defined Currency 4
FreeDefinedCurrency5 I_AssetSimulatedDueDeprValues FreeDefinedCurrency5 Freely Defined Currency 5
AmountInFreeDefinedCurrency5 I_AssetSimulatedDueDeprValues AmountInFreeDefinedCurrency5 Amount in Freely Defined Currency 5
FreeDefinedCurrency6 I_AssetSimulatedDueDeprValues FreeDefinedCurrency6 Freely Defined Currency 6
AmountInFreeDefinedCurrency6 I_AssetSimulatedDueDeprValues AmountInFreeDefinedCurrency6 Amount in Freely Defined Currency 6
FreeDefinedCurrency7 I_AssetSimulatedDueDeprValues FreeDefinedCurrency7 Freely Defined Currency 7
AmountInFreeDefinedCurrency7 I_AssetSimulatedDueDeprValues AmountInFreeDefinedCurrency7 Amount in Freely Defined Currency 7
FreeDefinedCurrency8 I_AssetSimulatedDueDeprValues FreeDefinedCurrency8 Freely Defined Currency 8
AmountInFreeDefinedCurrency8 I_AssetSimulatedDueDeprValues AmountInFreeDefinedCurrency8 Amount in Freely Defined Currency 8
BaseUnit Unit of Measure
Quantity

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

CREATE VIEW P_FixedAssetLineItem1 AS
SELECT
  acdoca.AssetDepreciationArea AS AssetDepreciationArea,
  acdoca.CompanyCode AS CompanyCode,
  acdoca.FiscalYear AS FiscalYear,
  acdoca.MasterFixedAsset AS MasterFixedAsset,
  acdoca.FixedAsset AS FixedAsset,
  acdoca.SubLedgerAcctLineItemType AS SubLedgerAcctLineItemType,
  acdoca.FiscalPeriod AS FiscalPeriod,
  cast('' as faa_deprecated_target_ldgrp) AS LedgerGroup,
  acdoca.AccountingDocument AS AccountingDocument,
  LedgerGLLineItem,
  acdoca.Ledger AS Ledger,
  acdoca.TransactionSubitem AS TransactionSubitem,
  acdoca.DebitCreditCode AS DebitCreditCode,
  acdoca.AccountingPrinciple AS AccountingPrinciple,
  acdoca.LedgerFiscalYear AS LedgerFiscalYear,
  acdoca.FiscalYearVariant AS FiscalYearVariant,
  acdoca.FiscalYearPeriod AS FiscalYearPeriod,
  acdoca.ChartOfAccounts AS ChartOfAccounts,
  acdoca.GLAccount AS GLAccount,
  acdoca.CountryChartOfAccounts AS CountryChartOfAccounts,
  cast(acdoca.AlternativeGLAccount as fis_altkt_skb1 preserving type) AS AlternativeGLAccount,
  IsStatisticalDocument,
  acdoca.AssetAcctTransClassfctn AS AssetAcctTransClassfctn,
  acdoca.GroupMasterFixedAsset AS GroupMasterFixedAsset,
  acdoca.GroupFixedAsset AS GroupFixedAsset,
  acdoca.FinancialAccountType AS FinancialAccountType,
  acdoca.ChartOfDepreciation AS ChartOfDepreciation,
  acdoca.ReferenceDocumentItem AS ReferenceDocumentItem,
  acdoca.ReferenceDocumentType AS ReferenceDocumentType,
  acdoca.LogicalSystem AS LogicalSystem,
  acdoca.ReferenceDocument AS ReferenceDocument,
  acdoca.ReferenceDocumentContext AS ReferenceDocumentContext,
  acdoca.PredecessorReferenceDocument AS PredecessorReferenceDocument,
  acdoca.PredecessorReferenceDocItem AS PredecessorReferenceDocItem,
  acdoca.PredecessorJournalEntry AS PredecessorJournalEntry,
  acdoca.PredecessorReferenceDocCntxt AS PredecessorReferenceDocCntxt,
  acdoca.PredecessorReferenceDocType AS PredecessorReferenceDocType,
  cast(acdoca.ReversalReferenceDocument as fis_stblg preserving type) AS ReversalReferenceDocument,
  acdoca.ReversalReferenceDocumentCntxt AS ReversalReferenceDocumentCntxt,
  acdoca.IsReversal AS IsReversal,
  acdoca.IsReversed AS IsReversed,
  acdoca.DocumentDate AS DocumentDate,
  acdoca.PostingDate AS PostingDate,
  acdoca.AssetTransactionType AS AssetTransactionType,
  acdoca.AssetValueDate AS AssetValueDate,
  acdoca.AccountingDocumentCreationDate AS AccountingDocumentCreationDate,
  acdoca.CreationTime AS CreationTime,
  acdoca.DocumentItemText AS DocumentItemText,
  acdoca.AccountingDocCreatedByUser AS AccountingDocCreatedByUser,
  acdoca.GLBusinessTransactionType AS GLBusinessTransactionType,
  acdoca.FinancialClosingStep AS FinancialClosingStep,
  acdoca.BusinessTransactionType AS BusinessTransactionType,
  acdoca.BusinessTransactionCategory AS BusinessTransactionCategory,
  acdoca.AssignmentReference AS AssignmentReference,
  acdoca.JointVentureCostRecoveryCode AS JointVentureCostRecoveryCode,
  acdoca.DepreciationFiscalPeriod AS DepreciationFiscalPeriod,
  acdoca.AccountingDocumentItem AS AccountingDocumentItem,
  acdoca.ReversalTransactionSubitem AS ReversalTransactionSubitem,
  acdoca.PurchasingDocument AS PurchasingDocument,
  acdoca.PurchasingDocumentItem AS PurchasingDocumentItem,
  acdoca.CostCenter AS CostCenter,
  acdoca.Plant AS Plant,
  acdoca.BusinessArea AS BusinessArea,
  acdoca.PersonnelNumber AS PersonnelNumber,
  acdoca.FinancialManagementArea AS FinancialManagementArea,
  acdoca.Fund AS Fund,
  acdoca.GrantID AS GrantID,
  acdoca.FunctionalArea AS FunctionalArea,
  acdoca.BudgetPeriod AS BudgetPeriod,
  acdoca.ProfitCenter AS ProfitCenter,
  acdoca.Segment AS Segment,
  acdoca.ControllingArea AS ControllingArea,
  I_CompanyCode.Country AS Country,
  acdoca.FundsCenter AS FundsCenter,
  AccountingDocumentType,
  acdoca.PartnerCompanyCode AS PartnerCompanyCode,
  acdoca.PartnerMasterFixedAsset AS PartnerMasterFixedAsset,
  acdoca.PartnerFixedAsset AS PartnerFixedAsset,
  acdoca.JrnlEntryItemMigrationSource AS JrnlEntryItemMigrationSource,
  acdoca.CompanyCodeCurrency AS CompanyCodeCurrency,
  acdoca.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  acdoca.GlobalCurrency AS GlobalCurrency,
  acdoca.AmountInGlobalCurrency AS AmountInGlobalCurrency,
  acdoca.FunctionalCurrency AS FunctionalCurrency,
  acdoca.AmountInFunctionalCurrency AS AmountInFunctionalCurrency,
  acdoca.FreeDefinedCurrency1 AS FreeDefinedCurrency1,
  acdoca.AmountInFreeDefinedCurrency1 AS AmountInFreeDefinedCurrency1,
  acdoca.FreeDefinedCurrency2 AS FreeDefinedCurrency2,
  acdoca.AmountInFreeDefinedCurrency2 AS AmountInFreeDefinedCurrency2,
  acdoca.FreeDefinedCurrency3 AS FreeDefinedCurrency3,
  acdoca.AmountInFreeDefinedCurrency3 AS AmountInFreeDefinedCurrency3,
  acdoca.FreeDefinedCurrency4 AS FreeDefinedCurrency4,
  acdoca.AmountInFreeDefinedCurrency4 AS AmountInFreeDefinedCurrency4,
  acdoca.FreeDefinedCurrency5 AS FreeDefinedCurrency5,
  acdoca.AmountInFreeDefinedCurrency5 AS AmountInFreeDefinedCurrency5,
  acdoca.FreeDefinedCurrency6 AS FreeDefinedCurrency6,
  acdoca.AmountInFreeDefinedCurrency6 AS AmountInFreeDefinedCurrency6,
  acdoca.FreeDefinedCurrency7 AS FreeDefinedCurrency7,
  acdoca.AmountInFreeDefinedCurrency7 AS AmountInFreeDefinedCurrency7,
  acdoca.FreeDefinedCurrency8 AS FreeDefinedCurrency8,
  acdoca.AmountInFreeDefinedCurrency8 AS AmountInFreeDefinedCurrency8,
  acdoca.BaseUnit AS BaseUnit,
  cast (0 as quan1_12) AS Quantity
FROM I_FxdAstActualLineItem AS acdoca
-- UNION ALL with additional select branch(es): I_AssetSimulatedDueDeprValues
;

Learn More