I_GLACCOUNTINOPERATINGCOA

CDS View

GL Account Changes in Operating COA

I_GLACCOUNTINOPERATINGCOA is a CDS View in S/4HANA. GL Account Changes in Operating COA. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_GLAccountStagingInCOA view from COMPOSITE G/L Account Staging CoA 
@AbapCatalog.sqlViewName: 'IGLACCTCOAITM'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'GL Account Changes in Operating COA'
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #M
@ObjectModel.usageType.dataClass: #MASTER
@VDM.viewType: #BASIC  
@ClientHandling.algorithm: #SESSION_VARIABLE
define view I_GLAccountInOperatingCOA as select from coachnglistactiv
//association [0..1] to I_COAChangeListItemStatus as _itemstatus on coachnglistactiv.itemstatus = _itemstatus.COAChangeListItemStatus

  association [0..1] to I_COAChangeListActionStatus as _actionstatus on coachnglistactiv.action = _actionstatus.COAChangeListAction
{

key itemnumber                as COAChangeListItemUUID,
    ktopl                     as ChartOfAccounts,
    target_saknr              as COAChangeListTargetNumber,
    target_short_description  as COAChangeListTargetAccountDesc,
    target_long_description   as GLAccountLongName,
    saknr                     as GLAccount,
    action                    as COAChangeListAction,
    _actionstatus             as _ActionStatusText,
    itemstatus                as COAChangeListItemStatus,
//    _itemstatus                          as _ItemStatusText, 

    check_result              as COAChangeListCheckResults, 
    importuuid                as COAChangeListImportUUID,
    created_by                as COAChangeListCreatedByUser,
    created_on                as COAChangeListCreationDateTime,
    grouping                  as WorkItemIDGroupText
}

//{


//key ktopl as ChartOfAccounts,

//key target_saknr as COAChangeListTargetNumber,

//    target_short_description as COAChangeListTargetAccountDesc,

//    target_long_description as GLAccountLongName,

//    saknr as GLAccount,

//    action as COAChangeListAction,

//    itemstatus as COAChangeListItemStatus,

//    check_result as COAChangeListCheckResults, 

////    COAChangeListUUID,

////    COAChangeListImportUUID,

//    created_by as COAChangeListCreatedByUser,

////    COAChangeListCreationDateTime

////    'X' as  IsNewAccount,

//    grouping as WorkItemIDGroupText

//

//  

//}

// union select from I_GLAccountInChartOfAccounts

// 

//{

//

//  ChartOfAccounts,

//  GLAccountExternal as COAChangeListTargetNumber, 

//  _Text[1: Language =  $session.system_language].GLAccountName as COAChangeListTargetAccountDesc,

//  _Text[1: Language =  $session.system_language].GLAccountLongName as GLAccountLongName,

//   '' as GLAccount,

//   '' as COAChangeListAction,

//   '' as COAChangeListItemStatus,

////   '' as ItemStatusName,

//   '' as COAChangeListCheckResults, 

////  '' as  COAChangeListUUID,

////   '' as COAChangeListImportUUID,

//   '' as COAChangeListCreatedByUser,

////   '' as COAChangeListCreationDateTime

////     '' as IsNewAccount,

//     '' as WorkItemIDGroupText

//}

//

//

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

Learn More