P_AssetBalanceLineItem1

DDL: P_ASSETBALANCELINEITEM1 Type: view COMPOSITE
185 Fields 2 Data Sources

P_AssetBalanceLineItem1 is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (I_FxdAstActualLineItem, I_FxdAstStatisticalLineItem) and exposes 185 fields with key fields AssetDepreciationArea, CompanyCode, FiscalYear, MasterFixedAsset, FixedAsset.

Data Sources (2)

SourceAliasJoin Type
I_FxdAstActualLineItem acdoca from
I_FxdAstStatisticalLineItem docit union_all

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName PASSTBALINEITMS1 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 (185)

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 I_AccountingPrincipleAssgmt 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
ReversalReferenceDocument Reversal Reference Document
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
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
PartnerMasterFixedAsset I_FxdAstActualLineItem PartnerMasterFixedAsset Partner Asset
PartnerFixedAsset I_FxdAstActualLineItem PartnerFixedAsset Partner Sub-No.
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_FxdAstStatisticalLineItem CompanyCode Receiver Company Code
KEY FiscalYear I_FxdAstStatisticalLineItem FiscalYear G/L Fiscal Year
KEY MasterFixedAsset I_FxdAstStatisticalLineItem MasterFixedAsset Fixed Asset
KEY FixedAsset I_FxdAstStatisticalLineItem FixedAsset Sub-number
KEY SubLedgerAcctLineItemType I_FxdAstStatisticalLineItem SubLedgerAcctLineItemType SLALineItemType
KEY FiscalPeriod I_FxdAstStatisticalLineItem FiscalPeriod Tax period
KEY LedgerGroup I_FxdAstStatisticalLineItem LedgerGroup Ledger Group
KEY AccountingDocument Journal Entry
KEY LedgerGLLineItem Journal Entry Item
Ledger I_FxdAstStatisticalLineItem Ledger Ledger
KEY TransactionSubitem I_FxdAstStatisticalLineItem TransactionSubitem Sub Transaction
KEY DebitCreditCode I_FxdAstStatisticalLineItem DebitCreditCode Single-Character Flag
AccountingPrinciple I_FxdAstStatisticalLineItem AccountingPrinciple AP Ledger/CoCode
LedgerFiscalYear
FiscalYearVariant FY Variant
FiscalYearPeriod Period/Year
ChartOfAccounts Node Class
GLAccount General Ledger
CountryChartOfAccounts I_CompanyCode CountryChartOfAccounts Chart of Accts
AlternativeGLAccount
IsStatisticalDocument
AssetAcctTransClassfctn I_FxdAstStatisticalLineItem AssetAcctTransClassfctn Trans.Type Cat.
GroupMasterFixedAsset I_FxdAstStatisticalLineItem GroupMasterFixedAsset Group Asset
GroupFixedAsset I_FxdAstStatisticalLineItem GroupFixedAsset Subnumber
FinancialAccountType Fin. Account Type
ChartOfDepreciation I_FxdAstStatisticalLineItem ChartOfDepreciation
ReferenceDocumentItem I_FxdAstStatisticalLineItem ReferenceDocumentItem Reference item
ReferenceDocumentType I_FxdAstStatisticalLineItem ReferenceDocumentType Reference Document Type
LogicalSystem I_FxdAstStatisticalLineItem LogicalSystem Logical System
ReferenceDocument I_FxdAstStatisticalLineItem ReferenceDocument Reference Document
ReferenceDocumentContext I_FxdAstStatisticalLineItem ReferenceDocumentContext Reference Document Context
ReversalReferenceDocument I_FxdAstStatisticalLineItem ReversalReferenceDocument Reversal Reference Document
ReversalReferenceDocumentCntxt I_FxdAstStatisticalLineItem ReversalReferenceDocumentCntxt Reversal Reference Document Context
IsReversal I_FxdAstStatisticalLineItem IsReversal Reversal doc.
IsReversed I_FxdAstStatisticalLineItem IsReversed Reversed?
DocumentDate I_FxdAstStatisticalLineItem DocumentDate Journal Entry Date
PostingDate I_FxdAstStatisticalLineItem PostingDate Posting Date for GR
AssetTransactionType I_FxdAstStatisticalLineItem AssetTransactionType Trans.Type
AssetValueDate I_FxdAstStatisticalLineItem AssetValueDate Reference date
AccountingDocumentCreationDate I_FxdAstStatisticalLineItem AccountingDocumentCreationDate Journal Entry Date
CreationTime I_FxdAstStatisticalLineItem CreationTime Time of Change
DocumentItemText I_FxdAstStatisticalLineItem DocumentItemText Text
AccountingDocCreatedByUser I_FxdAstStatisticalLineItem AccountingDocCreatedByUser User which created overhead document
GLBusinessTransactionType I_FxdAstStatisticalLineItem GLBusinessTransactionType Transact. Type
AssignmentReference I_FxdAstStatisticalLineItem AssignmentReference Assignment Reference
JointVentureCostRecoveryCode I_FxdAstStatisticalLineItem 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
PartnerMasterFixedAsset I_FxdAstStatisticalLineItem PartnerMasterFixedAsset Partner Asset
PartnerFixedAsset I_FxdAstStatisticalLineItem PartnerFixedAsset Partner Sub-No.
CompanyCodeCurrency I_FxdAstStatisticalLineItem CompanyCodeCurrency Local Currency
AmountInCompanyCodeCurrency I_FxdAstStatisticalLineItem AmountInCompanyCodeCurrency Local Crcy Amt
GlobalCurrency I_FxdAstStatisticalLineItem GlobalCurrency GM Billing Element: Global Currency
AmountInGlobalCurrency I_FxdAstStatisticalLineItem AmountInGlobalCurrency Amount in Global Currency
FunctionalCurrency Functional Currency
AmountInFunctionalCurrency Amount in Functional Currency
FreeDefinedCurrency1 I_FxdAstStatisticalLineItem FreeDefinedCurrency1 Freely Defined Currency 1
AmountInFreeDefinedCurrency1 I_FxdAstStatisticalLineItem AmountInFreeDefinedCurrency1 Amount in Freely Defined Currency 1
FreeDefinedCurrency2 I_FxdAstStatisticalLineItem FreeDefinedCurrency2 Freely Defined Currency 2
AmountInFreeDefinedCurrency2 I_FxdAstStatisticalLineItem AmountInFreeDefinedCurrency2 Amount in Freely Defined Currency 2
FreeDefinedCurrency3 I_FxdAstStatisticalLineItem FreeDefinedCurrency3 Freely Defined Currency 3
AmountInFreeDefinedCurrency3 I_FxdAstStatisticalLineItem AmountInFreeDefinedCurrency3 Amount in Freely Defined Currency 3
FreeDefinedCurrency4 I_FxdAstStatisticalLineItem FreeDefinedCurrency4 Freely Defined Currency 4
AmountInFreeDefinedCurrency4 I_FxdAstStatisticalLineItem AmountInFreeDefinedCurrency4 Amount in Freely Defined Currency 4
FreeDefinedCurrency5 I_FxdAstStatisticalLineItem FreeDefinedCurrency5 Freely Defined Currency 5
AmountInFreeDefinedCurrency5 I_FxdAstStatisticalLineItem AmountInFreeDefinedCurrency5 Amount in Freely Defined Currency 5
FreeDefinedCurrency6 I_FxdAstStatisticalLineItem FreeDefinedCurrency6 Freely Defined Currency 6
AmountInFreeDefinedCurrency6 I_FxdAstStatisticalLineItem AmountInFreeDefinedCurrency6 Amount in Freely Defined Currency 6
FreeDefinedCurrency7 I_FxdAstStatisticalLineItem FreeDefinedCurrency7 Freely Defined Currency 7
AmountInFreeDefinedCurrency7 I_FxdAstStatisticalLineItem AmountInFreeDefinedCurrency7 Amount in Freely Defined Currency 7
FreeDefinedCurrency8 I_FxdAstStatisticalLineItem FreeDefinedCurrency8 Freely Defined Currency 8
AmountInFreeDefinedCurrency8 I_FxdAstStatisticalLineItem 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_AssetBalanceLineItem1.
-- 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_AssetBalanceLineItem1 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,
  I_AccountingPrincipleAssgmt.LedgerGroup 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,
  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.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.PartnerMasterFixedAsset AS PartnerMasterFixedAsset,
  acdoca.PartnerFixedAsset AS PartnerFixedAsset,
  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_FxdAstStatisticalLineItem
;

Learn More