P_GLAccountLineItemSemanticTag

DDL: P_GLACCOUNTLINEITEMSEMANTICTAG Type: view_entity COMPOSITE Package: FINS_REV_REC_MON_PROJ

EBRR Monitor: Project (2) - helper CDS for Semantic Tags

P_GLAccountLineItemSemanticTag is a Composite CDS View that provides data about "EBRR Monitor: Project (2) - helper CDS for Semantic Tags" in SAP S/4HANA. It reads from 1 data source (I_GLAccountLineItem) and exposes 11 fields with key fields WBSElementInternalID, Ledger, CompanyCode. Part of development package FINS_REV_REC_MON_PROJ.

Data Sources (1)

SourceAliasJoin Type
I_GLAccountLineItem acdoca from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
VDM.private true view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
Metadata.ignorePropagatedAnnotations true view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY WBSElementInternalID WBSElementInternalID
KEY Ledger I_GLAccountLineItem Ledger
KEY CompanyCode I_GLAccountLineItem CompanyCode
GLAccount GLAccount
ChartOfAccounts ChartOfAccounts
BusinessTransactionType BusinessTransactionType
CompanyCodeCurrency CompanyCodeCurrency
FiscalYearPeriod FiscalYearPeriod
FiscalPeriod FiscalPeriod
FiscalYear FiscalYear
AmountInCompanyCodeCurrency AmountInCompanyCodeCurrency
@AccessControl.authorizationCheck: #NOT_REQUIRED

@VDM.viewType: #COMPOSITE
@VDM.private:true

@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass:  #MIXED
@ObjectModel.usageType.serviceQuality: #D

@Metadata.ignorePropagatedAnnotations: true

define view entity P_GLAccountLineItemSemanticTag
  as select from I_GLAccountLineItem as acdoca
{
  key WBSElementInternalID,
  key acdoca.Ledger,
  key acdoca.CompanyCode,
      GLAccount,
      ChartOfAccounts,
      BusinessTransactionType,
      CompanyCodeCurrency,
      FiscalYearPeriod,
      FiscalPeriod,
      FiscalYear,
      @Semantics.amount.currencyCode: 'COMPANYCODECURRENCY'
      AmountInCompanyCodeCurrency
}
where
  //      BusinessTransactionType     <> 'TBRR'

      AccountAssignmentType       =  'PR'
  and FiscalYearPeriod            <> '0000000'
  and AmountInCompanyCodeCurrency <> 0