P_GLAccountLineItemSemanticTag

DDL: P_GLACCOUNTLINEITEMSEMANTICTAG SQL: PGLACCLINEITMSEM Type: view COMPOSITE

P_GLAccountLineItemSemanticTag is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_GLAccountLineItem) and exposes 11 fields with key fields WBSElementInternalID, Ledger, CompanyCode.

1 data source(s) 11 fields

Data Sources (1)

SourceAliasJoin Type
I_GLAccountLineItem acdoca from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PGLACCLINEITMSEM view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
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
ClientHandling.algorithm #SESSION_VARIABLE 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 
@AbapCatalog.sqlViewName: 'PGLACCLINEITMSEM'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED

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

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

@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true

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

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

Learn More