C_GLAccountInCompanyCode

@AbapCatalog.sqlViewName: 'CGLACCTINCOCD'
@EndUserText.label: 'Gl accounts in company code'
@VDM.viewType: #CONSUMPTION
//@AccessControl.authorizationCheck: #NOT_ALLOWED

@AccessControl.authorizationCheck: #CHECK

@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.dataClass: #MIXED

define view C_GLAccountInCompanyCode
  with parameters
    @Consumption.hidden: true
    @Environment.systemField: #SYSTEM_LANGUAGE
    P_Language        : sylangu,
    P_ChartOfAccounts : ktopl
  as select from    I_GLAccount as _GLAccount
  left outer to one join I_GLAcctImplementStatusActive on GLAccountIsImplementStatusAct is not null
  association [0..1] to I_GLAccountInChartOfAccounts as _AlternativeGLAccountExternal on  $projection.CountryChartOfAccounts = _AlternativeGLAccountExternal.ChartOfAccounts
                                                                                      and $projection.AlternativeGLAccount   = _AlternativeGLAccountExternal.GLAccount
{
  key ChartOfAccounts,
  key CompanyCode,
  key GLAccount,
      _Text[1: Language = $parameters.P_Language].GLAccountLongName,
      GLAccountExternal,
      _GLAccountInCompanyCode.AuthorizationGroup,
      _GLAccountInCompanyCode.AccountingClerk,
      cast ( _GLAccountInCompanyCode.LastInterestCalcRunDate as abap.char(8) )                                                as LastInterestCalcRunDate,
      cast ( _GLAccountInCompanyCode.CreationDate as abap.char(8) )                                                           as CreationDate,
      CreatedByUser,
      _GLAccountInCompanyCode._User.UserDescription                                                                           as PersonFullName,
      _GLAccountInCompanyCode.PlanningLevel,
      _GLAccountInCompanyCode.HouseBank,
      _GLAccountInCompanyCode.HouseBankAccount,
      _GLAccountInCompanyCode.ExchRateDifferencesAccountDetn,
      ReconciliationAccountType,
      _GLAccountInCompanyCode._Reconciliationaccttype._Text[1: Language = $parameters.P_Language].ReconciliationAccountTypeName,
      _GLAccountInCompanyCode.TaxCategory,
      _GLAccountInCompanyCode._TaxCategory._Text[1: Language = $parameters.P_Language].TaxCategoryName,
      _GLAccountInCompanyCode.InterestCalculationCode,
      _GLAccountInCompanyCode.GLAccountCurrency,
      _GLAccountInCompanyCode.IsManagedExternally,
      _GLAccountInCompanyCode.IsAutomaticallyPosted,
      LineItemDisplayIsEnabled,
      _GLAccountInCompanyCode.SupplementIsAllowed,
      IsOpenItemManaged,
      cast ( _GLAccountInCompanyCode.InterestCalculationDate as abap.char(8) )                                                as InterestCalculationDate,
      _GLAccountInCompanyCode.IntrstCalcFrequencyInMonths,
      AcctgDocItmDisplaySequenceRule,
      AlternativeGLAccount,
      CountryChartOfAccounts,
      _AlternativeGLAccountExternal.GLAccountExternal                                                                         as AlternativeGLAccountExternal,
      _GLAccountInCompanyCode.JointVentureRecoveryCode,
      _GLAccountInCompanyCode.CommitmentItem,
      _GLAccountInCompanyCode.TaxCodeIsRequired,
      _GLAccountInCompanyCode.BalanceHasLocalCurrency,
      _GLAccountInCompanyCode.ValuationGroup,
      _GLAccountInCompanyCode.APARToleranceGroup,
      _GLAccountInCompanyCode.CashPlanningGroup,
      _GLAccountInCompanyCode.IsCashFlowAccount,
      _GLAccountInCompanyCode.AccountIsBlockedForPosting,
      _GLAccountInCompanyCode.AccountIsMarkedForDeletion,
      _GLAccountInCompanyCode._GLAcctInCoCodeStatus.GLAcctCoCodeImplementStatus, 
      _GLAccountInCompanyCode._GLAcctInCoCodeStatus.GLAccountCoCodIsDeliveredBySAP,
      _AlternativeGLAccountExternal
}
where
      _CompanyCode.ChartOfAccounts     =  :P_ChartOfAccounts
      /*
  and ( 
        ( ( 
          _GLAccountInChartOfAccounts._GLAcctInChartOfAcctsProdn.GLAccountIsNotProdnRelevant <> 'X' or 
          _GLAccountInChartOfAccounts._GLAcctInChartOfAcctsProdn.GLAccountIsNotProdnRelevant is null ) and 
          I_GLAcctImplementStatusActive.GLAccountIsImplementStatusAct is null
        ) or
        (  I_GLAcctImplementStatusActive.GLAccountIsImplementStatusAct = 'X' and 
           _GLAccountInChartOfAccounts._GLAcctInChartOfAcctsStatus.GLAcctCOAImplementStatus = 'P'
        )  
  )
  */