I_IE_InvcGeneralLedgerItem

DDL: I_IE_INVCGENERALLEDGERITEM Type: view_entity COMPOSITE
12 Fields 1 Data Sources

ERR GL Item

I_IE_InvcGeneralLedgerItem is a Composite CDS View that provides data about "ERR GL Item" in SAP S/4HANA. It reads from 1 data source (I_OperationalAcctgDocItem) and exposes 12 fields with key fields CompanyCode, FiscalYear, AccountingDocument, AccountingDocumentItem.

Data Sources (1)

SourceAliasJoin Type
I_OperationalAcctgDocItem I_OperationalAcctgDocItem from

Annotations (8)

NameValueLevelField
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label ERR GL Item view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_OperationalAcctgDocItem CompanyCode Receiver Company Code
KEY FiscalYear I_OperationalAcctgDocItem FiscalYear G/L Fiscal Year
KEY AccountingDocument I_OperationalAcctgDocItem AccountingDocument Journal Entry
KEY AccountingDocumentItem I_OperationalAcctgDocItem AccountingDocumentItem Posting View Item
GLAccount I_OperationalAcctgDocItem GLAccount General Ledger
PostingDate I_OperationalAcctgDocItem PostingDate Posting Date for GR
CompanyCodeCurrency I_OperationalAcctgDocItem CompanyCodeCurrency Local Currency
AmountInCompanyCodeCurrency I_OperationalAcctgDocItem AmountInCompanyCodeCurrency Local Crcy Amt
PersonnelNumber I_OperationalAcctgDocItem PersonnelNumber Personnel No.
AssignmentReference I_OperationalAcctgDocItem AssignmentReference Assignment Reference
ExpenseTypeCategory Mapping ExpenseTypeCategory
ExpenseTypeSubcategory Mapping ExpenseTypeSubcategory

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_IE_InvcGeneralLedgerItem.
-- 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_IE_InvcGeneralLedgerItem AS
SELECT
  I_OperationalAcctgDocItem.CompanyCode AS CompanyCode,
  I_OperationalAcctgDocItem.FiscalYear AS FiscalYear,
  I_OperationalAcctgDocItem.AccountingDocument AS AccountingDocument,
  I_OperationalAcctgDocItem.AccountingDocumentItem AS AccountingDocumentItem,
  I_OperationalAcctgDocItem.GLAccount AS GLAccount,
  I_OperationalAcctgDocItem.PostingDate AS PostingDate,
  I_OperationalAcctgDocItem.CompanyCodeCurrency AS CompanyCodeCurrency,
  I_OperationalAcctgDocItem.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  I_OperationalAcctgDocItem.PersonnelNumber AS PersonnelNumber,
  I_OperationalAcctgDocItem.AssignmentReference AS AssignmentReference,
  Mapping.ExpenseTypeCategory AS ExpenseTypeCategory,
  Mapping.ExpenseTypeSubcategory AS ExpenseTypeSubcategory
FROM I_OperationalAcctgDocItem
;

Learn More