I_GLAccountLineItemStdVH

DDL: I_GLACCOUNTLINEITEMSTDVH Type: view COMPOSITE

G/L Account Line Item

I_GLAccountLineItemStdVH is a Composite CDS View (Dimension) that provides data about "G/L Account Line Item" in SAP S/4HANA. It reads from 1 data source (I_GLAccountLineItem) and exposes 50 fields with key fields SourceLedger, CompanyCode, FiscalYear, AccountingDocument, LedgerGLLineItem.

1 data source(s) 50 fields

Data Sources (1)

SourceAliasJoin Type
I_GLAccountLineItem I_GLAccountLineItem from

Annotations (18)

NameValueLevelField
AbapCatalog.sqlViewName IFIGLALI__VH view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
Analytics.dataCategory #DIMENSION view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label G/L Account Line Item view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.representativeKey LedgerGLLineItem view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.modelingPattern #VALUE_HELP_PROVIDER view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
VDM.viewType #COMPOSITE view

Fields (50)

KeyFieldSource TableSource FieldDescription
KEY SourceLedger SourceLedger
KEY CompanyCode CompanyCode
KEY FiscalYear FiscalYear
KEY AccountingDocument AccountingDocument
KEY LedgerGLLineItem LedgerGLLineItem
KEY Ledger Ledger
AccountingDocumentType AccountingDocumentType
ControllingArea ControllingArea
CostCenter CostCenter
ProfitCenter ProfitCenter
Customer Customer
MasterFixedAsset MasterFixedAsset
FixedAsset FixedAsset
GLAccount GLAccount
Supplier Supplier
BusinessArea BusinessArea
DistributionChannel DistributionChannel
FinancialAccountType FinancialAccountType
OrderType OrderType
OrganizationDivision OrganizationDivision
Plant Plant
SalesOrderType SalesOrderType
SalesOrganization SalesOrganization
Segment Segment
ValuationArea ValuationArea
SalesDocument SalesDocument
OrderID OrderID
ServiceDocumentType ServiceDocumentType
ServiceDocument ServiceDocument
AssetClass AssetClass
PostingDate PostingDate
FunctionalArea FunctionalArea
_CostCenter _CostCenter
_ProfitCenter _ProfitCenter
_SourceLedger _SourceLedger
_CompanyCode _CompanyCode
_FiscalYear _FiscalYear
_JournalEntry _JournalEntry
_Ledger _Ledger
_AccountingDocumentType _AccountingDocumentType
_ControllingArea _ControllingArea
_CurrentCostCenter _CurrentCostCenter
_CurrentProfitCenter _CurrentProfitCenter
_Customer _Customer
_FixedAsset _FixedAsset
_GLAccountInCompanyCode _GLAccountInCompanyCode
_Supplier _Supplier
_SalesDocument _SalesDocument
_ServiceDocument _ServiceDocument
_Order _Order 
@AbapCatalog: { sqlViewName: 'IFIGLALI__VH',
                preserveKey: true,
                compiler.compareFilter: true }
@AccessControl: { authorizationCheck: #CHECK,
                  personalData.blocking: #BLOCKED_DATA_EXCLUDED }
@Analytics.dataCategory: #DIMENSION
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'G/L Account Line Item'
@ObjectModel: { dataCategory: #VALUE_HELP,
                representativeKey: 'LedgerGLLineItem',
                usageType: { sizeCategory: #XXL,
                             dataClass: #MIXED,
                             serviceQuality: #C },
                supportedCapabilities: [#VALUE_HELP_PROVIDER],
                modelingPattern: #VALUE_HELP_PROVIDER }                             
@Metadata.ignorePropagatedAnnotations: true
@Metadata.allowExtensions:true
@VDM.lifecycle.contract.type: #PUBLIC_LOCAL_API
@VDM.viewType: #COMPOSITE

define view I_GLAccountLineItemStdVH as select from I_GLAccountLineItem {
  @ObjectModel.foreignKey.association: '_SourceLedger'
  key SourceLedger,
  @ObjectModel.foreignKey.association: '_CompanyCode'
  key CompanyCode,
  @ObjectModel.foreignKey.association: '_FiscalYear'
  key FiscalYear,
  @ObjectModel.foreignKey.association: '_JournalEntry'
  key AccountingDocument,
  key LedgerGLLineItem,
  @ObjectModel.foreignKey.association: '_Ledger'
  key Ledger,

  @Consumption.hidden: true
  AccountingDocumentType,
  @Consumption.hidden: true
  @ObjectModel.foreignKey.association: '_ControllingArea'
  ControllingArea,
  @Consumption.hidden: true
  @ObjectModel.foreignKey.association: '_CostCenter'
  CostCenter,
  @Consumption.hidden: true
  @ObjectModel.foreignKey.association: '_ProfitCenter'
  ProfitCenter,
  @Consumption.hidden: true
  Customer,
  @Consumption.hidden: true
  MasterFixedAsset,
  @Consumption.hidden: true
  FixedAsset,
  @Consumption.hidden: true
  GLAccount,
  @Consumption.hidden: true
  Supplier,
  @Consumption.hidden: true
  BusinessArea,
  @Consumption.hidden: true
  DistributionChannel,
  @Consumption.hidden: true
  FinancialAccountType,
  @Consumption.hidden: true
  OrderType,
  @Consumption.hidden: true
  OrganizationDivision,
  @Consumption.hidden: true
  Plant,
  @Consumption.hidden: true
  SalesOrderType,
  @Consumption.hidden: true
  SalesOrganization,
  @Consumption.hidden: true
  Segment,
  @Consumption.hidden: true
  ValuationArea,
  @Consumption.hidden: true
  SalesDocument,
  @Consumption.hidden: true
  OrderID,
  @Consumption.hidden: true
  ServiceDocumentType,  
  @Consumption.hidden: true
  ServiceDocument,  
  @Consumption.hidden: true
  AssetClass,    
  @Consumption.hidden: true
  PostingDate,  
  @Consumption.hidden: true
  FunctionalArea,
  
  @Consumption.hidden: true
  _CostCenter,
  @Consumption.hidden: true
  _ProfitCenter,
  
  @Consumption.hidden: true
  _SourceLedger,
  @Consumption.hidden: true
  _CompanyCode,
  @Consumption.hidden: true
  _FiscalYear,
  @Consumption.hidden: true
  _JournalEntry,
  @Consumption.hidden: true
  _Ledger,
  @Consumption.hidden: true
  _AccountingDocumentType,
  @Consumption.hidden: true
  _ControllingArea,  
  @Consumption.hidden: true
  _CurrentCostCenter,
  @Consumption.hidden: true
  _CurrentProfitCenter,
  @Consumption.hidden: true
  _Customer,
  @Consumption.hidden: true
  _FixedAsset,
  @Consumption.hidden: true
  _GLAccountInCompanyCode,
  @Consumption.hidden: true
  _Supplier,
    @Consumption.hidden: true
  _SalesDocument,
  @Consumption.hidden: true
  _ServiceDocument,
  @Consumption.hidden: true
  _Order
}

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_GLACCOUNTLINEITEM"
],
"ASSOCIATED":
[
"I_ACCOUNTINGDOCUMENTTYPE",
"I_COMPANYCODE",
"I_CONTROLLINGAREA",
"I_COSTCENTER",
"I_CUSTOMER",
"I_FISCALYEARFORCOMPANYCODE",
"I_FIXEDASSET",
"I_GLACCOUNTINCOMPANYCODE",
"I_JOURNALENTRY",
"I_LEDGER",
"I_ORDER",
"I_PROFITCENTER",
"I_SALESDOCUMENT",
"I_SRVCDOCBYDOCUMENTTYPE",
"I_SUPPLIER"
],
"BASE":
[
"I_GLACCOUNTLINEITEM"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More