I_GLAcctOvhdAllocGLAcctIntvl

DDL: I_GLACCTOVHDALLOCGLACCTINTVL SQL: IOVHDACCTINTVL Type: view COMPOSITE

GLAcct fr Intvl to Overhead Alloc GLAcct

I_GLAcctOvhdAllocGLAcctIntvl is a Composite CDS View that provides data about "GLAcct fr Intvl to Overhead Alloc GLAcct" in SAP S/4HANA. It reads from 3 data sources (I_AllocStrucOvhdAllocGLAcct, I_ControllingArea, I_GLAccountInChartOfAccounts) and exposes 6 fields with key fields GLAccount, AllocationStructure, AllocationStructureAssignment, ControllingArea.

3 data source(s) 6 fields

Data Sources (3)

SourceAliasJoin Type
I_AllocStrucOvhdAllocGLAcct I_AllocStrucOvhdAllocGLAcct inner
I_ControllingArea I_ControllingArea inner
I_GLAccountInChartOfAccounts I_GLAccountInChartOfAccounts from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName IOVHDACCTINTVL view
AbapCatalog.compiler.compareFilter true view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #C view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #MANDATORY view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label GLAcct fr Intvl to Overhead Alloc GLAcct view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY GLAccount I_GLAccountInChartOfAccounts GLAccount
KEY AllocationStructure I_AllocStrucSrceGLAccts AllocationStructure
KEY AllocationStructureAssignment I_AllocStrucSrceGLAccts AllocationStructureAssignment
KEY ControllingArea I_AllocStrucSrceGLAccts ControllingArea
OverheadAllocationGLAccount I_AllocStrucOvhdAllocGLAcct OverheadAllocationGLAccount
ChartOfAccounts I_GLAccountInChartOfAccounts ChartOfAccounts 
@AbapCatalog.sqlViewName: 'IOVHDACCTINTVL'
@AbapCatalog.compiler.compareFilter: true
@ObjectModel.usageType.dataClass: #CUSTOMIZING
@ObjectModel.usageType.sizeCategory: #M
@ObjectModel.usageType.serviceQuality: #C
@VDM.viewType: #COMPOSITE
@AccessControl.authorizationCheck: #MANDATORY
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'GLAcct fr Intvl to Overhead Alloc GLAcct'
define view I_GLAcctOvhdAllocGLAcctIntvl
  as select from I_GLAccountInChartOfAccounts
    join         I_AllocStrucSrceGLAccts     on  I_AllocStrucSrceGLAccts.ToGLAccount   >= I_GLAccountInChartOfAccounts.GLAccount
                                             and I_AllocStrucSrceGLAccts.FromGLAccount <= I_GLAccountInChartOfAccounts.GLAccount
                                             and I_AllocStrucSrceGLAccts.FromGLAccount <> ''
                                             and I_AllocStrucSrceGLAccts.ToGLAccount   <> ''
    inner join   I_ControllingArea           on  I_AllocStrucSrceGLAccts.ControllingArea      = I_ControllingArea.ControllingArea
                                             and I_GLAccountInChartOfAccounts.ChartOfAccounts = I_ControllingArea.ChartOfAccounts
    inner join   I_AllocStrucOvhdAllocGLAcct on  I_AllocStrucSrceGLAccts.AllocationStructure           = I_AllocStrucOvhdAllocGLAcct.AllocationStructure
                                             and I_AllocStrucSrceGLAccts.AllocationStructureAssignment = I_AllocStrucOvhdAllocGLAcct.AllocationStructureAssignment
                                             and I_AllocStrucSrceGLAccts.ControllingArea               = I_AllocStrucOvhdAllocGLAcct.ControllingArea

{
  key I_GLAccountInChartOfAccounts.GLAccount,
  key I_AllocStrucSrceGLAccts.AllocationStructure,
  key I_AllocStrucSrceGLAccts.AllocationStructureAssignment,
  key I_AllocStrucSrceGLAccts.ControllingArea,
      I_AllocStrucOvhdAllocGLAcct.OverheadAllocationGLAccount,
      I_GLAccountInChartOfAccounts.ChartOfAccounts
}
where
      I_AllocStrucSrceGLAccts.AllocStrucSrceFldName           =  'KSTAR'
  and I_AllocStrucOvhdAllocGLAcct.OverheadAllocationGLAccount <> '';

Learn More