C_InventoryGLAcctBalCube

DDL: C_INVENTORYGLACCTBALCUBE SQL: CINVTRGLACBALC Type: view CONSUMPTION Package: GLO_FIN_IS_TR

Turkey Inventory CDS cube view

C_InventoryGLAcctBalCube is a Consumption CDS View (Cube) that provides data about "Turkey Inventory CDS cube view" in SAP S/4HANA. It reads from 7 data sources and exposes 34 fields with key fields CompanyCode, FiscalYear, SourceLedger, AccountingDocument, LedgerGLLineItem. Part of development package GLO_FIN_IS_TR.

7 data source(s) 34 fields

Data Sources (7)

SourceAliasJoin Type
I_BillOfExchange _BSED left_outer
I_FsvHierarchyInCoa _FSV inner
I_GLAcctWithGrpChartOfAccounts _GpCOA left_outer
I_StRpJournalEntryLog _ReportedItemsLog left_outer
I_TransactionTypeStdGLAcct _T030 left_outer
I_BillOfExchangePortfolio _T045P left_outer
I_GLAccountText _Text left_outer

Parameters (3)

NameTypeDefault
P_FromPostingDate fis_budat_from
P_ToPostingDate fis_budat_to
P_FinancialStatementVersion versn_011

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName CINVTRGLACBALC view
Analytics.dataCategory #CUBE view
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AccessControl.personalData.blocking #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.serviceQuality #X view
EndUserText.label Turkey Inventory CDS cube view view
Metadata.allowExtensions true view
AccessControl.blocking #BLOCKED_DATA_INCLUDED view

Fields (34)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_GLAcctBalance CompanyCode
KEY FiscalYear I_GLAcctBalance FiscalYear
KEY SourceLedger I_GLAcctBalance SourceLedger
KEY AccountingDocument I_GLAcctBalance AccountingDocument
KEY LedgerGLLineItem I_GLAcctBalance LedgerGLLineItem
KEY Ledger I_GLAcctBalance Ledger
KEY StatryRptCategory I_StRpJournalEntryLog StatryRptCategory
KEY StatryRptgEntity I_StRpJournalEntryLog StatryRptgEntity
KEY StatryRptRunID I_StRpJournalEntryLog StatryRptRunID
GLAccount I_GLAcctBalance GLAccount
BusinessArea BusinessArea
ChartOfAccounts I_GLAcctBalance ChartOfAccounts
AlternativeGLAccount I_GLAcctBalance AlternativeGLAccount
Material I_GLAcctBalance Material
Supplier Supplier
Customer Customer
CompanyCodeCurrency I_GLAcctBalance CompanyCodeCurrency
AmountInCompanyCodeCurrency I_GLAcctBalance AmountInCompanyCodeCurrency
MasterFixedAsset MasterFixedAsset
FixedAsset FixedAsset
Cheque I_BillOfExchange Cheque
CorporateGroupChartOfAccounts I_GLAcctWithGrpChartOfAccounts ChartOfAccounts
GLAccountGroup I_GLAcctWithGrpChartOfAccounts GLAccountGroup
GLAccountLongName I_GLAccountText GLAccountLongName
ValuationArea I_GLAcctBalance ValuationArea
SalesDocument SalesDocument
SalesDocumentItem SalesDocumentItem
InvtrySpclStockWBSElmntIntID InvtrySpclStockWBSElmntIntID
DebitAmountInCoCodeCrcy DebitAmountInCoCodeCrcy
CreditAmountInCoCodeCrcy CreditAmountInCoCodeCrcy
AssetDepreciationArea AssetDepreciationArea
BaseUnit I_GLAcctBalance BaseUnit
InventoryQty ValuationQuantity
CountryChartOfAccounts I_GLAcctBalance CountryChartOfAccounts 
@AbapCatalog.sqlViewName: 'CINVTRGLACBALC'
@Analytics: { dataCategory: #CUBE }
@VDM.viewType: #CONSUMPTION
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.compiler.compareFilter: true
@AccessControl.personalData.blocking: #NOT_REQUIRED
@Metadata.ignorePropagatedAnnotations:true
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.serviceQuality: #X
@EndUserText.label: 'Turkey Inventory CDS cube view'  
@AbapCatalog: {
  dbHints: [{dbSystem: #HDB, hint:'NO_USE_OLAP_PLAN'}]
} 
@Metadata.allowExtensions: true
@AccessControl.blocking:#BLOCKED_DATA_INCLUDED

define view C_InventoryGLAcctBalCube
  with parameters
    P_FromPostingDate           : fis_budat_from,
    P_ToPostingDate             : fis_budat_to,
    P_FinancialStatementVersion : versn_011
    //P_FiscalYear                : gjahr

  as select distinct from I_GLAccountLineItem as I_GLAcctBalance
  //Audit trail changes joins start

    inner join            I_FsvHierarchyInCoa                                         as _FSV              on (
                                                                                                                I_GLAcctBalance.GLAccount                = _FSV.GLAccount
                                                                                                                or 
                                                                                                                I_GLAcctBalance.AlternativeGLAccount    = _FSV.GLAccount
                                                                                                               )
                                                                                                           and _FSV.FinancialStatementVariant     = $parameters.P_FinancialStatementVersion
                                                                                                           and _FSV.DrillDownIsImpossible         = 'leaf'
                                                                                                           and
                                                                                                              ( I_GLAcctBalance.ChartOfAccounts = _FSV.ChartOfAccounts
                                                                                                                 or 
                                                                                                                I_GLAcctBalance.CountryChartOfAccounts = _FSV.ChartOfAccounts
                                                                                                              )
                                                                                                            and _FSV.GLAcctHierarchyNodeCategory    is null 
                                                                                                           
    left outer join       I_StRpJournalEntryLog                                       as _ReportedItemsLog on  _ReportedItemsLog.CompanyCode        = I_GLAcctBalance.CompanyCode
                                                                                                           and _ReportedItemsLog.AccountingDocument = I_GLAcctBalance.AccountingDocument
                                                                                                           and _ReportedItemsLog.FiscalYear         = I_GLAcctBalance.FiscalYear
  // end of audit trail changes---- joins

    left outer join       I_GLAcctWithGrpChartOfAccounts                              as _GpCOA            on  I_GLAcctBalance.ChartOfAccounts = _GpCOA.ChartOfAccounts
                                                                                                           and I_GLAcctBalance.GLAccount       = _GpCOA.GLAccount

    left outer join       I_GLAccountText                                             as _Text             on  I_GLAcctBalance.ChartOfAccounts = _Text.ChartOfAccounts
                                                                                                           and I_GLAcctBalance.GLAccount       = _Text.GLAccount
                                                                                                           and _Text.Language                  = $session.system_language

    left outer join       I_BillOfExchange                                            as _BSED             on  I_GLAcctBalance.CompanyCode        = _BSED.CompanyCode
                                                                                                           and I_GLAcctBalance.FiscalYear         = _BSED.FiscalYear
                                                                                                           and I_GLAcctBalance.AccountingDocument = _BSED.AccountingDocument

    left outer join       I_BillOfExchangePortfolio                                   as _T045P            on  I_GLAcctBalance.CompanyCode = _T045P.CompanyCode
                                                                                                           and I_GLAcctBalance.GLAccount   = _T045P.BillOfExchReceivablesAccount

    left outer join       I_TransactionTypeStdGLAcct                                  as _T030             on  I_GLAcctBalance.ChartOfAccounts    = _T030.ChartOfAccounts
                                                                                                           and _T030.TransactionTypeDetermination = 'BSX'
                                                                                                           and I_GLAcctBalance.GLAccount          = _T030.CreditGLAccount
                                                                                                           and I_GLAcctBalance.GLAccount          = _T030.DebitGLAccount

   /*left outer join       I_ML_Balance( P_CalendarDate: $parameters.P_ToPostingDate ) as ML_Balance        on  I_GLAcctBalance.Material           = ML_Balance.Material
                                                                                                           and _T030.ValuationClass               = ML_Balance.MaterialValuationClass
                                                                                                           and I_GLAcctBalance.CompanyCode        = ML_Balance.CompanyCode
                                                                                                           and I_GLAcctBalance.ValuationArea      = ML_Balance.ValuationArea
                                                                                                           and _T030.CreditGLAccount              = ML_Balance.GLAccount
                                                                                                           and ML_Balance.InventoryValuationType  = ' '
                                                                                                           and I_GLAcctBalance.ChartOfAccounts    = ML_Balance.ChartOfAccounts
                                                                                                           and I_GLAcctBalance.AccountingDocument = ML_Balance.AccountingDocument*/

{
      //I_GLAcctBalance

  key I_GLAcctBalance.CompanyCode, 
  key I_GLAcctBalance.FiscalYear, 
  key I_GLAcctBalance.SourceLedger,
  key I_GLAcctBalance.AccountingDocument,
  key I_GLAcctBalance.LedgerGLLineItem,
  key I_GLAcctBalance.Ledger,

      // Audit trail key fields for accounting document


  key _ReportedItemsLog.StatryRptCategory,
  key _ReportedItemsLog.StatryRptgEntity,
  key _ReportedItemsLog.StatryRptRunID,
      // Audit trail fields end for accounting document



      I_GLAcctBalance.GLAccount, 
      BusinessArea,

      I_GLAcctBalance.ChartOfAccounts, 
      I_GLAcctBalance.AlternativeGLAccount, 
      I_GLAcctBalance.Material, 
      Supplier, 
      Customer, 
      I_GLAcctBalance.CompanyCodeCurrency,
      @DefaultAggregation:#SUM
      @Semantics.amount.currencyCode: 'CompanyCodeCurrency'
      I_GLAcctBalance.AmountInCompanyCodeCurrency, 
      MasterFixedAsset, 
      FixedAsset, 
     _BSED.Cheque, 

      case
            when I_GLAcctBalance.GLAccount = _T045P.BillOfExchReceivablesAccount
            then _BSED.BillOfExchangeDrawee
            else
               case
               when _GLAccountInCompanyCode.ReconciliationAccountType = '' or _GLAccountInCompanyCode.ReconciliationAccountType = ' '
               then
                   case
                   when I_GLAcctBalance.GLAccount = _T030.CreditGLAccount and I_GLAcctBalance.GLAccount = _T030.DebitGLAccount
                   then I_GLAcctBalance._Material._Text[1:Language = $session.system_language].MaterialName
                // else _Text.GLAccountLongName

                   else GLAccountName
                   end
                   else
                   case
                   when _GLAccountInCompanyCode.ReconciliationAccountType = 'D'
                   then _Customer.CustomerFullName
                   when _GLAccountInCompanyCode.ReconciliationAccountType = 'K'
                   then _Supplier.SupplierFullName
                   when _GLAccountInCompanyCode.ReconciliationAccountType = 'A'
                   then  _FixedAsset.FixedAssetDescription
                   else ''                   
                   end
               end
            end                         as  InventoryDescription, 


      case
      when I_GLAcctBalance.GLAccount = _T045P.BillOfExchReceivablesAccount
      then 'C'
      else
         case
         when _GLAccountInCompanyCode.ReconciliationAccountType = '' or _GLAccountInCompanyCode.ReconciliationAccountType = ' '
         then
             case
             when I_GLAcctBalance.GLAccount = _T030.CreditGLAccount and I_GLAcctBalance.GLAccount = _T030.DebitGLAccount
             then 'M'
             else ''
             end
             else _GLAccountInCompanyCode.ReconciliationAccountType
         end
      end                               as ReconciliationAccountType, 


      // Line Item Text

      _GpCOA.ChartOfAccounts            as CorporateGroupChartOfAccounts, 
      _GpCOA.GLAccountGroup, 
     
      _Text.GLAccountLongName, 
      //materials

      I_GLAcctBalance.ValuationArea,
      SalesDocument,
      SalesDocumentItem,
      InvtrySpclStockWBSElmntIntID,
      @DefaultAggregation:#SUM
      @Semantics.amount.currencyCode: 'CompanyCodeCurrency'
      DebitAmountInCoCodeCrcy,
      @DefaultAggregation:#SUM
      @Semantics.amount.currencyCode: 'CompanyCodeCurrency'
      CreditAmountInCoCodeCrcy,
      AssetDepreciationArea,
      @Semantics.unitOfMeasure:true
      I_GLAcctBalance.BaseUnit,
      @DefaultAggregation: #SUM
      @Semantics: { quantity : {unitOfMeasure: 'BaseUnit'} }
      ValuationQuantity as InventoryQty,
      I_GLAcctBalance.CountryChartOfAccounts
}
where I_GLAcctBalance.AmountInCompanyCodeCurrency <> 0
and I_GLAcctBalance.PostingDate between $parameters.P_FromPostingDate and $parameters.P_ToPostingDate

Learn More