P_AssetLedgerQuantity

DDL: P_ASSETLEDGERQUANTITY SQL: PASTLDGRQTY Type: view COMPOSITE

P_AssetLedgerQuantity is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_GLAccountLineItem) and exposes 7 fields with key fields CompanyCode, MasterFixedAsset, FixedAsset, Ledger, FiscalYear.

1 data source(s) 7 fields

Data Sources (1)

SourceAliasJoin Type
I_GLAccountLineItem I_GLAccountLineItem from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName PASTLDGRQTY view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.private true view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XXL view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CompanyCode
KEY MasterFixedAsset MasterFixedAsset
KEY FixedAsset FixedAsset
KEY Ledger Ledger
KEY FiscalYear LedgerFiscalYear
BaseUnit BaseUnit
Quantity 
@AbapCatalog.sqlViewName: 'PASTLDGRQTY'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM: {
    private: true,
    viewType: #COMPOSITE}
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #XXL


define view P_AssetLedgerQuantity
  as select from I_GLAccountLineItem
{

  key    CompanyCode,

  key    MasterFixedAsset,

  key    FixedAsset,

  key    Ledger,

  key    LedgerFiscalYear as FiscalYear,

         //_FixedAsset.BaseUnit,//Performance improvement

         BaseUnit, 
          
         sum( I_GLAccountLineItem.Quantity) as Quantity
}
where
       MasterFixedAsset          <> ''
  and  FixedAsset                <> ''
  and(
       SubLedgerAcctLineItemType =  '07000'
    or SubLedgerAcctLineItemType =  '07040'
  )
  and Quantity <> 0 // Performance improvement

//  and  FinancialAccountType      =  'A'

group by
  CompanyCode,
  MasterFixedAsset,
  FixedAsset,
  Ledger,
  LedgerFiscalYear,
  BaseUnit
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_GLACCOUNTLINEITEM"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More