@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
serviceQuality: #X,
sizeCategory: #S,
dataClass: #MIXED
}
@VDM.private:true
@VDM.viewType: #COMPOSITE
define view entity P_GLAcctBalbyPeriod01 with parameters
P_Ledger : fis_rldnr,
P_FiscalYear : fins_gjahr,
P_StartFiscalPeriod : fins_fiscalperiod,
P_EndFiscalPeriod : fins_fiscalperiod
as select from I_GLAccountLineItem as GLAccountLineItem
inner join I_LedgerCompanyCodeCrcyRoles as LedgerCompanyCodeCrcyRole
on LedgerCompanyCodeCrcyRole.CompanyCode = GLAccountLineItem.CompanyCode
and LedgerCompanyCodeCrcyRole.Ledger = GLAccountLineItem.Ledger
{
key GLAccountLineItem.Ledger as Ledger,
key GLAccountLineItem.CompanyCode as CompanyCode,
key GLAccountLineItem.FiscalYear as FiscalYear,
key GLAccountLineItem.AccountingDocument,
key GLAccountLineItem.LedgerGLLineItem,
GLAccountLineItem.LedgerFiscalYear,
GLAccountLineItem.ChartOfAccounts,
GLAccountLineItem.AccountingDocumentType,
GLAccountLineItem.GLAccount,
GLAccountLineItem.CountryChartOfAccounts,
GLAccountLineItem.AlternativeGLAccount,
GLAccountLineItem.ControllingArea,
GLAccountLineItem.CostCenter,
GLAccountLineItem.ProfitCenter,
GLAccountLineItem.FinancialTransactionType,
GLAccountLineItem.FunctionalArea,
GLAccountLineItem.BusinessArea,
GLAccountLineItem.Segment,
GLAccountLineItem.DebitCreditCode,
GLAccountLineItem.PostingDate,
GLAccountLineItem.FiscalPeriod as FiscalPeriod,
GLAccountLineItem.PartnerCompany,
GLAccountLineItem.WBSElement,
GLAccountLineItem.GLAccountType,
LedgerCompanyCodeCrcyRole.CompanyCodeCurrencyRole,
LedgerCompanyCodeCrcyRole.GlobalCurrencyRole,
LedgerCompanyCodeCrcyRole.FreeDefinedCurrency1Role,
LedgerCompanyCodeCrcyRole.FreeDefinedCurrency2Role,
LedgerCompanyCodeCrcyRole.FreeDefinedCurrency3Role,
LedgerCompanyCodeCrcyRole.FreeDefinedCurrency4Role,
LedgerCompanyCodeCrcyRole.FreeDefinedCurrency5Role,
LedgerCompanyCodeCrcyRole.FreeDefinedCurrency6Role,
LedgerCompanyCodeCrcyRole.FreeDefinedCurrency7Role,
LedgerCompanyCodeCrcyRole.FreeDefinedCurrency8Role,
LedgerCompanyCodeCrcyRole.FunctionalCurrencyRole,
// @Semantics.currencyCode:true
GLAccountLineItem.CompanyCodeCurrency,
@Semantics.amount.currencyCode: 'CompanyCodeCurrency'
GLAccountLineItem.DebitAmountInCoCodeCrcy as DebitAmtInCoCodeCrcy,
@Semantics.amount.currencyCode: 'CompanyCodeCurrency'
GLAccountLineItem.CreditAmountInCoCodeCrcy as CreditAmtInCoCodeCrcy,
// @Semantics.currencyCode:true
GLAccountLineItem.GlobalCurrency,
@Semantics.amount.currencyCode: 'GlobalCurrency'
GLAccountLineItem.DebitAmountInGlobalCrcy as DebitAmtInGlobalCrcy,
@Semantics.amount.currencyCode: 'GlobalCurrency'
GLAccountLineItem.CreditAmountInGlobalCrcy as CreditAmtInGlobalCrcy,
// @Semantics.currencyCode:true
GLAccountLineItem.FreeDefinedCurrency1,
@Semantics.amount.currencyCode: 'FreeDefinedCurrency1'
GLAccountLineItem.DebitAmountInFreeDefinedCrcy1 as DebitAmtInFreeDefinedCrcy1,
@Semantics.amount.currencyCode: 'FreeDefinedCurrency1'
GLAccountLineItem.CreditAmountInFreeDefinedCrcy1 as CreditAmtInFreeDefinedCrcy1,
// @Semantics.currencyCode:true
GLAccountLineItem.FreeDefinedCurrency2,
@Semantics.amount.currencyCode: 'FreeDefinedCurrency2'
GLAccountLineItem.DebitAmountInFreeDefinedCrcy2 as DebitAmtInFreeDefinedCrcy2,
@Semantics.amount.currencyCode: 'FreeDefinedCurrency2'
GLAccountLineItem.CreditAmountInFreeDefinedCrcy2 as CreditAmtInFreeDefinedCrcy2,
// @Semantics.currencyCode:true
GLAccountLineItem.FreeDefinedCurrency3,
@Semantics.amount.currencyCode: 'FreeDefinedCurrency3'
GLAccountLineItem.DebitAmountInFreeDefinedCrcy3 as DebitAmtInFreeDefinedCrcy3,
@Semantics.amount.currencyCode: 'FreeDefinedCurrency3'
GLAccountLineItem.CreditAmountInFreeDefinedCrcy3 as CreditAmtInFreeDefinedCrcy3,
// @Semantics.currencyCode:true
GLAccountLineItem.FreeDefinedCurrency4,
@Semantics.amount.currencyCode: 'FreeDefinedCurrency4'
GLAccountLineItem.DebitAmountInFreeDefinedCrcy4 as DebitAmtInFreeDefinedCrcy4,
@Semantics.amount.currencyCode: 'FreeDefinedCurrency4'
GLAccountLineItem.CreditAmountInFreeDefinedCrcy4 as CreditAmtInFreeDefinedCrcy4,
// @Semantics.currencyCode:true
GLAccountLineItem.FreeDefinedCurrency5,
@Semantics.amount.currencyCode: 'FreeDefinedCurrency5'
GLAccountLineItem.DebitAmountInFreeDefinedCrcy5 as DebitAmtInFreeDefinedCrcy5,
@Semantics.amount.currencyCode: 'FreeDefinedCurrency5'
GLAccountLineItem.CreditAmountInFreeDefinedCrcy5 as CreditAmtInFreeDefinedCrcy5,
// @Semantics.currencyCode:true
GLAccountLineItem.FreeDefinedCurrency6,
@Semantics.amount.currencyCode: 'FreeDefinedCurrency6'
GLAccountLineItem.DebitAmountInFreeDefinedCrcy6 as DebitAmtInFreeDefinedCrcy6,
@Semantics.amount.currencyCode: 'FreeDefinedCurrency6'
GLAccountLineItem.CreditAmountInFreeDefinedCrcy6 as CreditAmtInFreeDefinedCrcy6,
// @Semantics.currencyCode:true
GLAccountLineItem.FreeDefinedCurrency7,
@Semantics.amount.currencyCode: 'FreeDefinedCurrency7'
GLAccountLineItem.DebitAmountInFreeDefinedCrcy7 as DebitAmtInFreeDefinedCrcy7,
@Semantics.amount.currencyCode: 'FreeDefinedCurrency7'
GLAccountLineItem.CreditAmountInFreeDefinedCrcy7 as CreditAmtInFreeDefinedCrcy7,
// @Semantics.currencyCode:true
GLAccountLineItem.FreeDefinedCurrency8,
@Semantics.amount.currencyCode: 'FreeDefinedCurrency8'
GLAccountLineItem.DebitAmountInFreeDefinedCrcy8 as DebitAmtInFreeDefinedCrcy8,
@Semantics.amount.currencyCode: 'FreeDefinedCurrency8'
GLAccountLineItem.CreditAmountInFreeDefinedCrcy8 as CreditAmtInFreeDefinedCrcy8,
// @Semantics.currencyCode:true
GLAccountLineItem.FunctionalCurrency,
@Semantics.amount.currencyCode: 'FunctionalCurrency'
GLAccountLineItem.DebitAmountInFunctionalCrcy as DebitAmountInFunctionalCrcy,
@Semantics.amount.currencyCode: 'FunctionalCurrency'
GLAccountLineItem.CreditAmountInFunctionalCrcy as CreditAmountInFunctionalCrcy,
'O' as PeriodFlag
}
where
GLAccountLineItem.Ledger = $parameters.P_Ledger
and GLAccountLineItem.LedgerFiscalYear = $parameters.P_FiscalYear
// and GLAccountLineItem.FiscalPeriod <= $parameters.P_EndFiscalPeriod
// and GLAccountLineItem.FiscalPeriod >= $parameters.P_StartFiscalPeriod
and GLAccountLineItem.FiscalPeriod < $parameters.P_StartFiscalPeriod
and GLAccountLineItem.FiscalPeriod > '000'
and GLAccountLineItem.GLRecordType = '0'
//Enhancement to Financial Statement for Querying with Period
union all
select distinct from I_GLAccountLineItem as GLAccountLineItem
inner join I_LedgerCompanyCodeCrcyRoles as LedgerCompanyCodeCrcyRole
on LedgerCompanyCodeCrcyRole.CompanyCode = GLAccountLineItem.CompanyCode
and LedgerCompanyCodeCrcyRole.Ledger = GLAccountLineItem.Ledger
{
key GLAccountLineItem.Ledger as Ledger,
key GLAccountLineItem.CompanyCode as CompanyCode,
key GLAccountLineItem.FiscalYear as FiscalYear,
key GLAccountLineItem.AccountingDocument,
key GLAccountLineItem.LedgerGLLineItem,
GLAccountLineItem.LedgerFiscalYear,
GLAccountLineItem.ChartOfAccounts,
GLAccountLineItem.AccountingDocumentType,
GLAccountLineItem.GLAccount,
GLAccountLineItem.CountryChartOfAccounts,
GLAccountLineItem.AlternativeGLAccount,
GLAccountLineItem.ControllingArea,
GLAccountLineItem.CostCenter,
GLAccountLineItem.ProfitCenter,
GLAccountLineItem.FinancialTransactionType,
GLAccountLineItem.FunctionalArea,
GLAccountLineItem.BusinessArea,
GLAccountLineItem.Segment,
GLAccountLineItem.DebitCreditCode,
GLAccountLineItem.PostingDate,
GLAccountLineItem.FiscalPeriod as FiscalPeriod,
GLAccountLineItem.PartnerCompany,
GLAccountLineItem.WBSElement,
GLAccountLineItem.GLAccountType,
LedgerCompanyCodeCrcyRole.CompanyCodeCurrencyRole,
LedgerCompanyCodeCrcyRole.GlobalCurrencyRole,
LedgerCompanyCodeCrcyRole.FreeDefinedCurrency1Role,
LedgerCompanyCodeCrcyRole.FreeDefinedCurrency2Role,
LedgerCompanyCodeCrcyRole.FreeDefinedCurrency3Role,
LedgerCompanyCodeCrcyRole.FreeDefinedCurrency4Role,
LedgerCompanyCodeCrcyRole.FreeDefinedCurrency5Role,
LedgerCompanyCodeCrcyRole.FreeDefinedCurrency6Role,
LedgerCompanyCodeCrcyRole.FreeDefinedCurrency7Role,
LedgerCompanyCodeCrcyRole.FreeDefinedCurrency8Role,
LedgerCompanyCodeCrcyRole.FunctionalCurrencyRole,
// @Semantics.currencyCode:true
GLAccountLineItem.CompanyCodeCurrency,
// @Semantics.amount.currencyCode: 'CompanyCodeCurrency'
GLAccountLineItem.DebitAmountInCoCodeCrcy as DebitAmtInCoCodeCrcy,
// @Semantics.amount.currencyCode: 'CompanyCodeCurrency'
GLAccountLineItem.CreditAmountInCoCodeCrcy as CreditAmtInCoCodeCrcy,
// @Semantics.currencyCode:true
GLAccountLineItem.GlobalCurrency,
// @Semantics.amount.currencyCode: 'GlobalCurrency'
GLAccountLineItem.DebitAmountInGlobalCrcy as DebitAmtInGlobalCrcy,
// @Semantics.amount.currencyCode: 'GlobalCurrency'
GLAccountLineItem.CreditAmountInGlobalCrcy as CreditAmtInGlobalCrcy,
// @Semantics.currencyCode:true
GLAccountLineItem.FreeDefinedCurrency1,
// @Semantics.amount.currencyCode: 'FreeDefinedCurrency1'
GLAccountLineItem.DebitAmountInFreeDefinedCrcy1 as DebitAmtInFreeDefinedCrcy1,
// @Semantics.amount.currencyCode: 'FreeDefinedCurrency1'
GLAccountLineItem.CreditAmountInFreeDefinedCrcy1 as CreditAmtInFreeDefinedCrcy1,
// @Semantics.currencyCode:true
GLAccountLineItem.FreeDefinedCurrency2,
// @Semantics.amount.currencyCode: 'FreeDefinedCurrency2'
GLAccountLineItem.DebitAmountInFreeDefinedCrcy2 as DebitAmtInFreeDefinedCrcy2,
// @Semantics.amount.currencyCode: 'FreeDefinedCurrency2'
GLAccountLineItem.CreditAmountInFreeDefinedCrcy2 as CreditAmtInFreeDefinedCrcy2,
// @Semantics.currencyCode:true
GLAccountLineItem.FreeDefinedCurrency3,
// @Semantics.amount.currencyCode: 'FreeDefinedCurrency3'
GLAccountLineItem.DebitAmountInFreeDefinedCrcy3 as DebitAmtInFreeDefinedCrcy3,
// @Semantics.amount.currencyCode: 'FreeDefinedCurrency3'
GLAccountLineItem.CreditAmountInFreeDefinedCrcy3 as CreditAmtInFreeDefinedCrcy3,
// @Semantics.currencyCode:true
GLAccountLineItem.FreeDefinedCurrency4,
// @Semantics.amount.currencyCode: 'FreeDefinedCurrency4'
GLAccountLineItem.DebitAmountInFreeDefinedCrcy4 as DebitAmtInFreeDefinedCrcy4,
// @Semantics.amount.currencyCode: 'FreeDefinedCurrency4'
GLAccountLineItem.CreditAmountInFreeDefinedCrcy4 as CreditAmtInFreeDefinedCrcy4,
// @Semantics.currencyCode:true
GLAccountLineItem.FreeDefinedCurrency5,
// @Semantics.amount.currencyCode: 'FreeDefinedCurrency5'
GLAccountLineItem.DebitAmountInFreeDefinedCrcy5 as DebitAmtInFreeDefinedCrcy5,
// @Semantics.amount.currencyCode: 'FreeDefinedCurrency5'
GLAccountLineItem.CreditAmountInFreeDefinedCrcy5 as CreditAmtInFreeDefinedCrcy5,
// @Semantics.currencyCode:true
GLAccountLineItem.FreeDefinedCurrency6,
// @Semantics.amount.currencyCode: 'FreeDefinedCurrency6'
GLAccountLineItem.DebitAmountInFreeDefinedCrcy6 as DebitAmtInFreeDefinedCrcy6,
// @Semantics.amount.currencyCode: 'FreeDefinedCurrency6'
GLAccountLineItem.CreditAmountInFreeDefinedCrcy6 as CreditAmtInFreeDefinedCrcy6,
// @Semantics.currencyCode:true
GLAccountLineItem.FreeDefinedCurrency7,
// @Semantics.amount.currencyCode: 'FreeDefinedCurrency7'
GLAccountLineItem.DebitAmountInFreeDefinedCrcy7 as DebitAmtInFreeDefinedCrcy7,
// @Semantics.amount.currencyCode: 'FreeDefinedCurrency7'
GLAccountLineItem.CreditAmountInFreeDefinedCrcy7 as CreditAmtInFreeDefinedCrcy7,
// @Semantics.currencyCode:true
GLAccountLineItem.FreeDefinedCurrency8,
// @Semantics.amount.currencyCode: 'FreeDefinedCurrency8'
GLAccountLineItem.DebitAmountInFreeDefinedCrcy8 as DebitAmtInFreeDefinedCrcy8,
// @Semantics.amount.currencyCode: 'FreeDefinedCurrency8'
GLAccountLineItem.CreditAmountInFreeDefinedCrcy8 as CreditAmtInFreeDefinedCrcy8,
// @Semantics.currencyCode:true
GLAccountLineItem.FunctionalCurrency,
// @Semantics.amount.currencyCode: 'FunctionalCurrency'
GLAccountLineItem.DebitAmountInFunctionalCrcy as DebitAmountInFunctionalCrcy,
// @Semantics.amount.currencyCode: 'FunctionalCurrency'
GLAccountLineItem.CreditAmountInFunctionalCrcy as CreditAmountInFunctionalCrcy,
'Y' as PeriodFlag
}
where
GLAccountLineItem.Ledger = $parameters.P_Ledger and
GLAccountLineItem.LedgerFiscalYear = $parameters.P_FiscalYear and
// GLAccountLineItem.FiscalYear = FiscalPeriodForLedger.FiscalYear and
GLAccountLineItem.FiscalPeriod = '000' and
GLAccountLineItem.AccountingDocumentCategory = 'C'
and GLAccountLineItem.GLRecordType = '0'
union all
select from I_GLAccountLineItem as GLAccountLineItem
inner join I_LedgerCompanyCodeCrcyRoles as LedgerCompanyCodeCrcyRole
on LedgerCompanyCodeCrcyRole.CompanyCode = GLAccountLineItem.CompanyCode
and LedgerCompanyCodeCrcyRole.Ledger = GLAccountLineItem.Ledger
// inner join I_FiscalCalYearPeriodForLedger as FiscalPeriodForLedger
//// on GLAccountLineItem.FiscalYearVariant = FiscalPeriodForLedger.FiscalYearVariant
// on GLAccountLineItem.Ledger = FiscalPeriodForLedger.Ledger
// and GLAccountLineItem.CompanyCode = FiscalPeriodForLedger.CompanyCode
// and GLAccountLineItem.FiscalPeriod = FiscalPeriodForLedger.FiscalPeriod
//// and FiscalPeriodForLedger.FiscalPeriodStartDate <= $parameters.P_StartPostingDate
//// and FiscalPeriodForLedger.FiscalPeriodEndDate >= $parameters.P_StartPostingDate
{
key GLAccountLineItem.Ledger as Ledger,
key GLAccountLineItem.CompanyCode as CompanyCode,
key GLAccountLineItem.FiscalYear as FiscalYear,
key GLAccountLineItem.AccountingDocument,
key GLAccountLineItem.LedgerGLLineItem,
GLAccountLineItem.LedgerFiscalYear,
GLAccountLineItem.ChartOfAccounts,
GLAccountLineItem.AccountingDocumentType,
GLAccountLineItem.GLAccount,
GLAccountLineItem.CountryChartOfAccounts,
GLAccountLineItem.AlternativeGLAccount,
GLAccountLineItem.ControllingArea,
GLAccountLineItem.CostCenter,
GLAccountLineItem.ProfitCenter,
GLAccountLineItem.FinancialTransactionType,
GLAccountLineItem.FunctionalArea,
GLAccountLineItem.BusinessArea,
GLAccountLineItem.Segment,
GLAccountLineItem.DebitCreditCode,
GLAccountLineItem.PostingDate,
GLAccountLineItem.FiscalPeriod as FiscalPeriod,
GLAccountLineItem.PartnerCompany,
GLAccountLineItem.WBSElement,
GLAccountLineItem.GLAccountType,
LedgerCompanyCodeCrcyRole.CompanyCodeCurrencyRole,
LedgerCompanyCodeCrcyRole.GlobalCurrencyRole,
LedgerCompanyCodeCrcyRole.FreeDefinedCurrency1Role,
LedgerCompanyCodeCrcyRole.FreeDefinedCurrency2Role,
LedgerCompanyCodeCrcyRole.FreeDefinedCurrency3Role,
LedgerCompanyCodeCrcyRole.FreeDefinedCurrency4Role,
LedgerCompanyCodeCrcyRole.FreeDefinedCurrency5Role,
LedgerCompanyCodeCrcyRole.FreeDefinedCurrency6Role,
LedgerCompanyCodeCrcyRole.FreeDefinedCurrency7Role,
LedgerCompanyCodeCrcyRole.FreeDefinedCurrency8Role,
LedgerCompanyCodeCrcyRole.FunctionalCurrencyRole,
// @Semantics.currencyCode:true
GLAccountLineItem.CompanyCodeCurrency,
// @Semantics.amount.currencyCode: 'CompanyCodeCurrency'
GLAccountLineItem.DebitAmountInCoCodeCrcy as DebitAmtInCoCodeCrcy,
// @Semantics.amount.currencyCode: 'CompanyCodeCurrency'
GLAccountLineItem.CreditAmountInCoCodeCrcy as CreditAmtInCoCodeCrcy,
// @Semantics.currencyCode:true
GLAccountLineItem.GlobalCurrency,
// @Semantics.amount.currencyCode: 'GlobalCurrency'
GLAccountLineItem.DebitAmountInGlobalCrcy as DebitAmtInGlobalCrcy,
// @Semantics.amount.currencyCode: 'GlobalCurrency'
GLAccountLineItem.CreditAmountInGlobalCrcy as CreditAmtInGlobalCrcy,
// @Semantics.currencyCode:true
GLAccountLineItem.FreeDefinedCurrency1,
// @Semantics.amount.currencyCode: 'FreeDefinedCurrency1'
GLAccountLineItem.DebitAmountInFreeDefinedCrcy1 as DebitAmtInFreeDefinedCrcy1,
// @Semantics.amount.currencyCode: 'FreeDefinedCurrency1'
GLAccountLineItem.CreditAmountInFreeDefinedCrcy1 as CreditAmtInFreeDefinedCrcy1,
// @Semantics.currencyCode:true
GLAccountLineItem.FreeDefinedCurrency2,
// @Semantics.amount.currencyCode: 'FreeDefinedCurrency2'
GLAccountLineItem.DebitAmountInFreeDefinedCrcy2 as DebitAmtInFreeDefinedCrcy2,
// @Semantics.amount.currencyCode: 'FreeDefinedCurrency2'
GLAccountLineItem.CreditAmountInFreeDefinedCrcy2 as CreditAmtInFreeDefinedCrcy2,
// @Semantics.currencyCode:true
GLAccountLineItem.FreeDefinedCurrency3,
// @Semantics.amount.currencyCode: 'FreeDefinedCurrency3'
GLAccountLineItem.DebitAmountInFreeDefinedCrcy3 as DebitAmtInFreeDefinedCrcy3,
// @Semantics.amount.currencyCode: 'FreeDefinedCurrency3'
GLAccountLineItem.CreditAmountInFreeDefinedCrcy3 as CreditAmtInFreeDefinedCrcy3,
// @Semantics.currencyCode:true
GLAccountLineItem.FreeDefinedCurrency4,
// @Semantics.amount.currencyCode: 'FreeDefinedCurrency4'
GLAccountLineItem.DebitAmountInFreeDefinedCrcy4 as DebitAmtInFreeDefinedCrcy4,
// @Semantics.amount.currencyCode: 'FreeDefinedCurrency4'
GLAccountLineItem.CreditAmountInFreeDefinedCrcy4 as CreditAmtInFreeDefinedCrcy4,
// @Semantics.currencyCode:true
GLAccountLineItem.FreeDefinedCurrency5,
// @Semantics.amount.currencyCode: 'FreeDefinedCurrency5'
GLAccountLineItem.DebitAmountInFreeDefinedCrcy5 as DebitAmtInFreeDefinedCrcy5,
// @Semantics.amount.currencyCode: 'FreeDefinedCurrency5'
GLAccountLineItem.CreditAmountInFreeDefinedCrcy5 as CreditAmtInFreeDefinedCrcy5,
// @Semantics.currencyCode:true
GLAccountLineItem.FreeDefinedCurrency6,
// @Semantics.amount.currencyCode: 'FreeDefinedCurrency6'
GLAccountLineItem.DebitAmountInFreeDefinedCrcy6 as DebitAmtInFreeDefinedCrcy6,
// @Semantics.amount.currencyCode: 'FreeDefinedCurrency6'
GLAccountLineItem.CreditAmountInFreeDefinedCrcy6 as CreditAmtInFreeDefinedCrcy6,
// @Semantics.currencyCode:true
GLAccountLineItem.FreeDefinedCurrency7,
// @Semantics.amount.currencyCode: 'FreeDefinedCurrency7'
GLAccountLineItem.DebitAmountInFreeDefinedCrcy7 as DebitAmtInFreeDefinedCrcy7,
// @Semantics.amount.currencyCode: 'FreeDefinedCurrency7'
GLAccountLineItem.CreditAmountInFreeDefinedCrcy7 as CreditAmtInFreeDefinedCrcy7,
// @Semantics.currencyCode:true
GLAccountLineItem.FreeDefinedCurrency8,
// @Semantics.amount.currencyCode: 'FreeDefinedCurrency8'
GLAccountLineItem.DebitAmountInFreeDefinedCrcy8 as DebitAmtInFreeDefinedCrcy8,
// @Semantics.amount.currencyCode: 'FreeDefinedCurrency8'
GLAccountLineItem.CreditAmountInFreeDefinedCrcy8 as CreditAmtInFreeDefinedCrcy8,
// @Semantics.currencyCode:true
GLAccountLineItem.FunctionalCurrency,
// @Semantics.amount.currencyCode: 'FunctionalCurrency'
GLAccountLineItem.DebitAmountInFunctionalCrcy as DebitAmountInFunctionalCrcy,
// @Semantics.amount.currencyCode: 'FunctionalCurrency'
GLAccountLineItem.CreditAmountInFunctionalCrcy as CreditAmountInFunctionalCrcy,
'R' as PeriodFlag
}
where
GLAccountLineItem.Ledger = $parameters.P_Ledger
and GLAccountLineItem.LedgerFiscalYear = $parameters.P_FiscalYear
and GLAccountLineItem.FiscalPeriod <= $parameters.P_EndFiscalPeriod
and GLAccountLineItem.FiscalPeriod >= $parameters.P_StartFiscalPeriod
and
(GLAccountLineItem.FiscalPeriod > '000' or (GLAccountLineItem.FiscalPeriod = '000' and GLAccountLineItem.AccountingDocumentCategory <> 'C') )