P_GLAccountLineItemSlalitype

DDL: P_GLACCOUNTLINEITEMSLALITYPE SQL: PGLACCLINEITEMSL Type: view COMPOSITE

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

1 data source(s) 10 fields

Data Sources (1)

SourceAliasJoin Type
I_GLAccountLineItem acdoca from

Annotations (8)

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

@VDM.viewType: #COMPOSITE
@VDM.private:true
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true

define view P_GLAccountLineItemSlalitype

  as select from I_GLAccountLineItem as acdoca
{
  key WBSElementInternalID,
  key Ledger,
  key CompanyCode,
      FiscalYearPeriod,
      FiscalPeriod,
      FiscalYear,
      SubLedgerAcctLineItemType,
      BusinessTransactionType,
      CompanyCodeCurrency,
      AmountInCompanyCodeCurrency
}
where
      AccountAssignmentType       =  'PR'
  and FiscalYearPeriod            <> '0000000'
  and AmountInCompanyCodeCurrency <> 0
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_GLACCOUNTLINEITEM"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More