I_GLAccountStagingInCOA

DDL: I_GLACCOUNTSTAGINGINCOA Type: view_entity COMPOSITE Package: RAP_FI_GL_COA

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 25 fields with key fields ChartOfAccounts, COAChangeListTargetNumber, COAChangeListTargetNumber. Part of development package RAP_FI_GL_COA.

2 data source(s) 25 fields

Data Sources (2)

SourceAliasJoin Type
I_GLAccountInOperatingCOA I_GLAccountInOperatingCOA from
I_GLAccountInChartOfAccounts SKa1 union

Annotations (7)

NameValueLevelField
Metadata.ignorePropagatedAnnotations 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

Fields (25)

KeyFieldSource TableSource FieldDescription
KEY ChartOfAccounts ChartOfAccounts
KEY COAChangeListTargetNumber COAChangeListTargetNumber
GLAcctCOAImplementStatus
COAChangeListTargetAccountDesc COAChangeListTargetAccountDesc
GLAccountLongName GLAccountLongName
GLAccountExternal COAChangeListTargetNumber
GLAccount GLAccount
COAChangeListAction COAChangeListAction
COAChangeListItemStatus COAChangeListItemStatus
COAChangeListCheckResults COAChangeListCheckResults
COAChangeListItemUUID COAChangeListItemUUID
COAChangeListCreatedByUser COAChangeListCreatedByUser
ChartOfAccounts
KEY COAChangeListTargetNumber I_GLAccountInChartOfAccounts GLAccount
GLAcctCOAImplementStatus
COAChangeListTargetAccountDesc
GLAccountLongName
GLAccountExternal I_GLAccountInChartOfAccounts GLAccount
GLAccount
COAChangeListAction
COAChangeListItemStatus
COAChangeListCheckResults
COAChangeListItemUUID dummy COAChangeListItemUUID
COAChangeListCreatedByUser
WorkItemIDGroupText 
@Metadata.ignorePropagatedAnnotations: 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
define view entity I_GLAccountStagingInCOA
  as select from I_GLAccountInOperatingCOA
  //association [0..1] to I_COAChangeListItemStatus as _itemstatus on coachnglistactiv.itemstatus = _itemstatus.COAChangeListItemStatus

{

  key ChartOfAccounts,
  key COAChangeListTargetNumber,
      ''                        as GLAcctCOAImplementStatus,
      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

{

  key SKa1.ChartOfAccounts,
  key SKa1.GLAccount                                                        as COAChangeListTargetNumber,
  SKa1._GLAcctInChartOfAcctsStatus.GLAcctCOAImplementStatus             as GLAcctCOAImplementStatus,
  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
}

Learn More