P_GLAccountLineItemSlalitype

DDL: P_GLACCOUNTLINEITEMSLALITYPE Type: view_entity COMPOSITE Package: FINS_REV_REC_MON_PROJ

EBRR Monitor: Project (2) - helper CDS for Slalittypes

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

1 data source(s) 10 fields

Data Sources (1)

SourceAliasJoin Type
I_GLAccountLineItem acdoca from

Annotations (4)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
VDM.private true view
Metadata.ignorePropagatedAnnotations true view

Fields (10)

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

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

define view entity P_GLAccountLineItemSlalitype

  as select from I_GLAccountLineItem as acdoca
{
  key WBSElementInternalID,
  key Ledger,
  key CompanyCode,
      FiscalYearPeriod,
      FiscalPeriod,
      FiscalYear,
      SubLedgerAcctLineItemType,
      BusinessTransactionType,
      CompanyCodeCurrency,
      @Semantics.amount.currencyCode: 'COMPANYCODECURRENCY'
      AmountInCompanyCodeCurrency
}
where
      AccountAssignmentType       =  'PR'
  and FiscalYearPeriod            <> '0000000'
  and AmountInCompanyCodeCurrency <> 0

Learn More