I_GLAccountStagingInCOA

DDL: I_GLACCOUNTSTAGINGINCOA SQL: IGLACCTSTAGING Type: view COMPOSITE

G/L Account Staging CoA

I_GLAccountStagingInCOA is a Composite CDS View that provides data about "G/L Account Staging CoA" in SAP S/4HANA. It reads from 2 data sources (I_GLAccountInOperatingCOA, I_GLAccountInChartOfAccounts) and exposes 23 fields with key fields ChartOfAccounts, COAChangeListTargetNumber.

2 data source(s) 23 fields

Data Sources (2)

SourceAliasJoin Type
I_GLAccountInOperatingCOA I_GLAccountInOperatingCOA from
I_GLAccountInChartOfAccounts SKa1 union

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IGLACCTSTAGING view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label G/L Account Staging CoA view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (23)

KeyFieldSource TableSource FieldDescription
KEY ChartOfAccounts ChartOfAccounts
KEY COAChangeListTargetNumber COAChangeListTargetNumber
COAChangeListTargetAccountDesc COAChangeListTargetAccountDesc
GLAccountLongName GLAccountLongName
GLAccountExternal COAChangeListTargetNumber
GLAccount GLAccount
COAChangeListAction COAChangeListAction
COAChangeListItemStatus COAChangeListItemStatus
COAChangeListCheckResults COAChangeListCheckResults
COAChangeListItemUUID COAChangeListItemUUID
COAChangeListCreatedByUser COAChangeListCreatedByUser
ChartOfAccounts
COAChangeListTargetNumber I_GLAccountInChartOfAccounts GLAccount
COAChangeListTargetAccountDesc
GLAccountLongName
GLAccountExternal I_GLAccountInChartOfAccounts GLAccount
GLAccount
COAChangeListAction
COAChangeListItemStatus
COAChangeListCheckResults
COAChangeListItemUUID dummy COAChangeListItemUUID
COAChangeListCreatedByUser
WorkItemIDGroupText 
@AbapCatalog.sqlViewName: 'IGLACCTSTAGING'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'G/L Account Staging CoA'
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #M
@ObjectModel.usageType.dataClass: #MASTER
@VDM.viewType: #COMPOSITE  
@ClientHandling.algorithm: #SESSION_VARIABLE

define view I_GLAccountStagingInCOA as select from I_GLAccountInOperatingCOA
//association [0..1] to I_COAChangeListItemStatus as _itemstatus on coachnglistactiv.itemstatus = _itemstatus.COAChangeListItemStatus

{

key ChartOfAccounts,
key COAChangeListTargetNumber,
    COAChangeListTargetAccountDesc,
    GLAccountLongName,
    COAChangeListTargetNumber as GLAccountExternal,    
    GLAccount,
    COAChangeListAction,
    COAChangeListItemStatus,
    COAChangeListCheckResults, 
//    bintohex( COAChangeListItemUUID ) as 

    COAChangeListItemUUID,
    COAChangeListCreatedByUser,
//    COAChangeListCreationDateTime,

    WorkItemIDGroupText
  
}
 union select from I_GLAccountInChartOfAccounts as SKa1 left outer to one join I_GLAccountInOperatingCOA as dummy on
                                           SKa1.ChartOfAccounts = dummy.ChartOfAccounts and
                                           SKa1.GLAccount = dummy.COAChangeListTargetNumber 
 
{

  SKa1.ChartOfAccounts,
  SKa1.GLAccount as COAChangeListTargetNumber, 
  SKa1._Text[1: Language =  $session.system_language].GLAccountName as COAChangeListTargetAccountDesc,
  SKa1._Text[1: Language =  $session.system_language].GLAccountLongName as GLAccountLongName,
  SKa1.GLAccount                                                        as GLAccountExternal,
   '' as GLAccount,
   '' as COAChangeListAction,
   '' as COAChangeListItemStatus,
   '' as COAChangeListCheckResults, 
   dummy.COAChangeListItemUUID,
   '' as COAChangeListCreatedByUser,
   '' as WorkItemIDGroupText
}


/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_GLACCOUNTINCHARTOFACCOUNTS",
"I_GLACCOUNTINOPERATINGCOA",
"I_GLACCOUNTTEXT"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More