I_PRAGLAccountText

DDL: I_PRAGLACCOUNTTEXT SQL: IPVPRAGLACCOUNTT Type: view BASIC Package: OIU_VDM_CDS

PRA General Ledger Account - Text

I_PRAGLAccountText is a Basic CDS View that provides data about "PRA General Ledger Account - Text" in SAP S/4HANA. It reads from 2 data sources (I_CompanyCode, I_GLAccountText) and exposes 8 fields with key fields CompanyCode, GLAccount, Language. It has 2 associations to related views. Part of development package OIU_VDM_CDS.

2 data source(s) 8 fields

Data Sources (2)

SourceAliasJoin Type
I_CompanyCode I_CompanyCode inner
I_GLAccountText I_GLAccountText from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_CompanyCode _CompanyCode $projection.CompanyCode = _CompanyCode.CompanyCode
[0..1] I_GLAccountInChartOfAccounts _GLAccountInChartOfAccounts $projection.ChartOfAccounts = _GLAccountInChartOfAccounts.ChartOfAccounts and $projection.GLAccount = _GLAccountInChartOfAccounts.GLAccount

Annotations (13)

NameValueLevelField
EndUserText.label PRA General Ledger Account - Text view
ObjectModel.dataCategory #TEXT view
Analytics.dataExtraction.enabled true view
VDM.viewType #BASIC view
AbapCatalog.sqlViewName IPVPRAGLACCOUNTT view
AccessControl.authorizationCheck #CHECK view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.representativeKey GLAccount view
ObjectModel.modelingPattern #LANGUAGE_DEPENDENT_TEXT view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MASTER view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_CompanyCode CompanyCode
KEY GLAccount GLAccount
KEY Language I_GLAccountText Language
ChartOfAccounts I_CompanyCode ChartOfAccounts
GLAccountName GLAccountName
GLAccountLongName GLAccountLongName
_CompanyCode _CompanyCode
_GLAccountInChartOfAccounts _GLAccountInChartOfAccounts 
@EndUserText.label: 'PRA General Ledger Account - Text'
@ObjectModel.dataCategory: #TEXT
@Analytics.dataExtraction.enabled: true
@VDM.viewType: #BASIC
@AbapCatalog.sqlViewName: 'IPVPRAGLACCOUNTT'
@AccessControl.authorizationCheck: #CHECK
@Metadata.ignorePropagatedAnnotations:true
@ObjectModel.representativeKey: 'GLAccount'

@ObjectModel.supportedCapabilities: [#LANGUAGE_DEPENDENT_TEXT , #SQL_DATA_SOURCE , #CDS_MODELING_DATA_SOURCE , #CDS_MODELING_ASSOCIATION_TARGET]
@ObjectModel.modelingPattern: #LANGUAGE_DEPENDENT_TEXT

@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.sizeCategory: #S
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.dataClass: #MASTER

// PRA GL Account references do not use COA, rather it is derived from company

// therefore we create this view to expose the text based on a key component of company code


define view I_PRAGLAccountText
  as select from I_GLAccountText
    inner join   I_CompanyCode on I_CompanyCode.ChartOfAccounts = I_GLAccountText.ChartOfAccounts

  association [0..1] to I_CompanyCode                as _CompanyCode                on  $projection.CompanyCode = _CompanyCode.CompanyCode
  association [0..1] to I_GLAccountInChartOfAccounts as _GLAccountInChartOfAccounts on  $projection.ChartOfAccounts = _GLAccountInChartOfAccounts.ChartOfAccounts
                                                                                    and $projection.GLAccount       = _GLAccountInChartOfAccounts.GLAccount
{
      @ObjectModel.foreignKey.association: '_CompanyCode'
  key I_CompanyCode.CompanyCode     as CompanyCode,
  key GLAccount,
      @Semantics.language: true
  key I_GLAccountText.Language      as Language,
      I_CompanyCode.ChartOfAccounts as ChartOfAccounts,
      @Semantics.text: true
      GLAccountName,
      @Semantics.text: true
      GLAccountLongName,
      _CompanyCode,
      _GLAccountInChartOfAccounts
};

Learn More