I_GLAcctInCOAImplementStat

DDL: I_GLACCTINCOAIMPLEMENTSTAT Type: view BASIC

Implementation Status of GL Acct on COA

I_GLAcctInCOAImplementStat is a Basic CDS View that provides data about "Implementation Status of GL Acct on COA" in SAP S/4HANA. It reads from 1 data source (ska_imst) and exposes 5 fields with key fields ChartOfAccounts, GLAccount. It has 1 association to related views.

1 data source(s) 5 fields

Data Sources (1)

SourceAliasJoin Type
ska_imst ska_imst from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_GLACCTINCOAIMPSTATTYPETEXT _GLAccountImpStTypeText $projection.GLAcctCOAImplementStatus = _GLAccountImpStTypeText.GLAcctCOAImplementStatus

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName IFIGLACCINCOAIMS view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AbapCatalog.buffering.status #ACTIVE view
AbapCatalog.buffering.type #GENERIC view
AbapCatalog.buffering.numberOfKeyFields 1 view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #BASIC view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
EndUserText.label Implementation Status of GL Acct on COA view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY ChartOfAccounts ska_imst ktopl
KEY GLAccount ska_imst saknr
GLAcctCOAImplementStatus ska_imst imst
GLAccountCOAIsDeliveredBySAP ska_imst delivered_by_sap
_GLAccountImpStTypeText _GLAccountImpStTypeText 
@AbapCatalog: {
  sqlViewName: 'IFIGLACCINCOAIMS',
  compiler.compareFilter: true,
  preserveKey: true,
  buffering:{
    status: #ACTIVE,
    type: #GENERIC,
    numberOfKeyFields: 1
  }
}

@AccessControl.authorizationCheck: #NOT_REQUIRED

@ClientHandling.algorithm: #SESSION_VARIABLE

@Metadata.ignorePropagatedAnnotations: true

@VDM.viewType: #BASIC

@ObjectModel: {
  semanticKey:  [ 'GLAccount', 'ChartOfAccounts' ], 
//  representativeKey: 'ChartOfAccounts',

  usageType: {
    dataClass: #CUSTOMIZING,
    serviceQuality: #A,
    sizeCategory: #S
  }
}


@EndUserText.label: 'Implementation Status of GL Acct on COA'
define view I_GLAcctInCOAImplementStat 
  as select from ska_imst 
     association [0..*] to I_GLACCTINCOAIMPSTATTYPETEXT as _GLAccountImpStTypeText on $projection.GLAcctCOAImplementStatus = _GLAccountImpStTypeText.GLAcctCOAImplementStatus
  {
    key ska_imst.ktopl            as ChartOfAccounts,
//        @ObjectModel.foreignKey.association

    key ska_imst.saknr            as GLAccount,
        ska_imst.imst             as GLAcctCOAImplementStatus,
        ska_imst.delivered_by_sap as GLAccountCOAIsDeliveredBySAP,
        _GLAccountImpStTypeText
//        case ska_imst.imst

//          when '' then 

//            'I'    //in process for SAP Delivered Content after Migration

//          else 

//        ska_imst.imst

//        end as GLAcctCOAImplementStatus,

//        case ska_imst.imst

//          when '' then 

//            'X'    //in process for SAP Delivered Content after Migration

//          else 

//            ska_imst.delivered_by_sap

//          end as GLAccountCOAIsDeliveredBySAP      

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

Learn More