I_FundAcctgLineItemCube

DDL: I_FUNDACCTGLINEITEMCUBE Type: view COMPOSITE Package: ODATA_PSM_S4C_FA_REPORTING
95 Fields 1 Data Sources 3 Associations

Fund Accounting Line Item - Cube

I_FundAcctgLineItemCube (Composite)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Public Edition with built-in and side-by-side extension capabilities.

Cross Applications

I_FundAcctgLineItemCube is a Composite CDS View (Cube) that provides data about "Fund Accounting Line Item - Cube" in SAP S/4HANA. It reads from 1 data source (I_GLAccountLineItem) and exposes 95 fields with key fields Ledger, SourceLedger, CompanyCode, FiscalYear, AccountingDocument. It has 3 associations to related views. Part of development package ODATA_PSM_S4C_FA_REPORTING.

SAP API Hub

CategoryComposite
StateC1
Line of BusinessCross Applications
Application ComponentPSM-FM-IS
CapabilitiesData Provider for Analytical Queries,Data Source in SQL Select,Data Source for Defining CDS Entities
Extensible (Key User)No
Extensible (Developer)No
Release State (Key User)Released
Release State (Developer)Not Released
PackageCross Applications for SAP S/4HANA Cloud Public Edition

Documentation

Data Sources (1)

SourceAliasJoin Type
I_GLAccountLineItem I_GLAccountLineItem from

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_FundType _FundType $projection.FinancialManagementArea = _FundType.FinancialManagementArea and $projection.fundtype = _FundType.FundType
[0..1] I_Grant _Grant $projection.GrantID = _Grant.GrantID
[0..1] I_GrantType _GrantType $projection.granttype = _GrantType.GrantType

Annotations (18)

NameValueLevelField
AbapCatalog.sqlViewName IFALINEITEMC view
AbapCatalog.preserveKey true view
AbapCatalog.buffering.status #NOT_ALLOWED view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
Analytics.dataCategory #CUBE view
Analytics.internalName #LOCAL view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Fund Accounting Line Item - Cube view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.modelingPattern #ANALYTICAL_CUBE view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
VDM.viewType #COMPOSITE view

Fields (95)

KeyFieldSource TableSource FieldDescription
KEY Ledger Ledger Ledger in General Ledger Accounting
KEY SourceLedger SourceLedger Source Ledger
KEY CompanyCode CompanyCode Receiver Company Code
KEY FiscalYear G/L Fiscal Year
KEY AccountingDocument AccountingDocument Journal Entry
KEY LedgerGLLineItem LedgerGLLineItem General Ledger Journal Entry Line Item
LedgerFiscalYear LedgerFiscalYear Fiscal Year of Ledger
ControllingArea ControllingArea Controlling Area
ChartOfAccounts ChartOfAccounts Chart of Accounts
GLAccount GLAccount General Ledger
CostCenter CostCenter Cost Center
ProfitCenter ProfitCenter Profit Center
FunctionalArea FunctionalArea Sendr Fctl Area
FiscalPeriod FiscalPeriod Fiscal Period
FiscalYearVariant FiscalYearVariant Fiscal Year Variant
PostingDate PostingDate Posting Date for GR
AccountingDocumentType AccountingDocumentType Journal Entry Type
AlternativeGLAccount AlternativeGLAccount Alternative G/L Account Number In Company Code
CountryChartOfAccounts CountryChartOfAccounts Alternative Chart of Accounts for Country/Region
InvoiceReference InvoiceReference Invoice Reference
InvoiceReferenceFiscalYear InvoiceReferenceFiscalYear Invoice Reference Fiscal Year
InvoiceItemReference InvoiceItemReference Invoice Item Reference
SalesDocument SalesDocument Sales Document
Product Product Product Sold
Plant Plant Valuation Area
Supplier Supplier Supplier
Customer Customer Customer Number
FinancialAccountType FinancialAccountType Fin. Account Type
IsOpenItemManaged IsOpenItemManaged Managed on an Open Item Basis
ClearingDate ClearingDate Clearing Date
ClearingDocFiscalYear ClearingDocFiscalYear Fiscal Year of Clearing Journal Entry (Deprecated)
Segment Segment Segment for Segmental Reporting
BusinessArea BusinessArea Business Area
CostObject CostObject Cost Object
FinancialTransactionType FinancialTransactionType Financial Transaction Type
Fund Fund Sender Fund
FundType _Fund FundType Fund Type
FinancialManagementArea FinancialManagementArea Financial Management Area
GLAccountType GLAccountType Type of a General Ledger Account
GrantID GrantID Sender Grant
GrantType _Grant GrantType Grant Type
AssetClass AssetClass Asset Class
DistributionChannel DistributionChannel Distribution Channel
OrganizationDivision OrganizationDivision Org. Division
SalesOrganization SalesOrganization Sales Organization
ServiceDocumentType ServiceDocumentType Service Document Type
ValuationArea ValuationArea Valuation Area
OrderID OrderID Order ID
ServiceDocument ServiceDocument Service Document ID
OrderCategory OrderCategory Order Category
CompanyCodeCurrency CompanyCodeCurrency Company Code Currency
AmountInCompanyCodeCurrency AmountInCompanyCodeCurrency Amount in Company Code Currency
GrantIsNotRelevantGrant _Grant GrantIsNotRelevantGrant Identify the Not Relevant Grant
GrantLifecycleStatus _Grant GrantLifecycleStatus Lifecycle Status
GrantAuthznGrp _Grant GrantAuthznGrp Grants Management: Authorization Groups
GranteeMgmtSponsor _Grant GranteeMgmtSponsor Grant Sponsor
_FinancialManagementArea _FinancialManagementArea
_Grant _Grant
_Sponsor _Grant _Sponsor
_GrantType _GrantType
_FundType _FundType
_JournalEntry _JournalEntry
_CompanyCode _CompanyCode
_FiscalYear _FiscalYear
_FiscalPeriodForVariant _FiscalPeriodForVariant
_LedgerFiscalYearForVariant _LedgerFiscalYearForVariant
_FiscalYearVariant _FiscalYearVariant
_Fund _Fund
_ControllingArea _ControllingArea
_GLAccountType _GLAccountType
_Product _Product
_CompanyCodeCurrency _CompanyCodeCurrency
_Segment _Segment
_ProfitCenter _ProfitCenter
_CostCenter _CostCenter
_SalesDocument _SalesDocument
_BusinessArea _BusinessArea
_FunctionalArea _FunctionalArea
_GLAccountInChartOfAccounts _GLAccountInChartOfAccounts
_GLAccountInCompanyCode _GLAccountInCompanyCode
_ChartOfAccounts _ChartOfAccounts
_AccountingDocumentType _AccountingDocumentType
_FinancialAccountType _FinancialAccountType
_Plant _Plant
_Ledger _Ledger
_SourceLedger _SourceLedger
_Customer _Customer
_Supplier _Supplier
_FinancialTransactionType _FinancialTransactionType
_AlternativeGLAccount _AlternativeGLAccount
_CountryChartOfAccounts _CountryChartOfAccounts
_CurrentCostCenter _CurrentCostCenter
_CurrentProfitCenter _CurrentProfitCenter
_Order _Order
_ServiceDocument _ServiceDocument

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_FundAcctgLineItemCube.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW I_FundAcctgLineItemCube AS
SELECT
  Ledger,
  SourceLedger,
  CompanyCode,
  cast( FiscalYear as fis_gjahr_no_conv preserving type ) AS FiscalYear,
  AccountingDocument,
  LedgerGLLineItem,
  LedgerFiscalYear,
  ControllingArea,
  ChartOfAccounts,
  GLAccount,
  CostCenter,
  ProfitCenter,
  FunctionalArea,
  FiscalPeriod,
  FiscalYearVariant,
  PostingDate,
  AccountingDocumentType,
  AlternativeGLAccount,
  CountryChartOfAccounts,
  InvoiceReference,
  InvoiceReferenceFiscalYear,
  InvoiceItemReference,
  SalesDocument,
  Product,
  Plant,
  Supplier,
  Customer,
  FinancialAccountType,
  IsOpenItemManaged,
  ClearingDate,
  ClearingDocFiscalYear,
  Segment,
  BusinessArea,
  CostObject,
  FinancialTransactionType,
  Fund,
  _Fund.FundType AS FundType,
  FinancialManagementArea,
  GLAccountType,
  GrantID,
  _Grant.GrantType AS GrantType,
  AssetClass,
  DistributionChannel,
  OrganizationDivision,
  SalesOrganization,
  ServiceDocumentType,
  ValuationArea,
  OrderID,
  ServiceDocument,
  OrderCategory,
  CompanyCodeCurrency,
  AmountInCompanyCodeCurrency,
  _Grant.GrantIsNotRelevantGrant AS GrantIsNotRelevantGrant,
  _Grant.GrantLifecycleStatus AS GrantLifecycleStatus,
  _Grant.GrantAuthznGrp AS GrantAuthznGrp,
  _Grant.GranteeMgmtSponsor AS GranteeMgmtSponsor,
  _Grant._Sponsor AS _Sponsor
FROM I_GLAccountLineItem
LEFT OUTER JOIN I_FundType AS _FundType ON FinancialManagementArea = _FundType.FinancialManagementArea AND fundtype = _FundType.FundType  -- association [0..1]
LEFT OUTER JOIN I_Grant AS _Grant ON GrantID = _Grant.GrantID  -- association [0..1]
LEFT OUTER JOIN I_GrantType AS _GrantType ON granttype = _GrantType.GrantType  -- association [0..1]
;

Learn More