C_IE_InvcGenLedgerItemCube

DDL: C_IE_INVCGENLEDGERITEMCUBE Type: view_entity CONSUMPTION
29 Fields 1 Data Sources

ERR GL Item - Cube

C_IE_InvcGenLedgerItemCube is a Consumption CDS View (Cube) that provides data about "ERR GL Item - Cube" in SAP S/4HANA. It reads from 1 data source (I_IE_InvcGeneralLedgerItem) and exposes 29 fields with key fields StatryRptCategory, StatryRptgEntity, StatryRptRunID, CompanyCode, FiscalYear.

Data Sources (1)

SourceAliasJoin Type
I_IE_InvcGeneralLedgerItem GLItem from

Annotations (11)

NameValueLevelField
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #BLOCKED_DATA_INCLUDED view
EndUserText.label ERR GL Item - Cube view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
Analytics.internalName #LOCAL view
Analytics.dataCategory #CUBE view

Fields (29)

KeyFieldSource TableSource FieldDescription
KEY StatryRptCategory Log StatryRptCategory Report ID
KEY StatryRptgEntity Log StatryRptgEntity Reporting Entity
KEY StatryRptRunID Log StatryRptRunID Report Run ID
KEY CompanyCode I_IE_InvcGeneralLedgerItem CompanyCode Receiver Company Code
KEY FiscalYear I_IE_InvcGeneralLedgerItem FiscalYear G/L Fiscal Year
KEY AccountingDocument I_IE_InvcGeneralLedgerItem AccountingDocument Journal Entry
KEY AccountingDocumentItem I_IE_InvcGeneralLedgerItem AccountingDocumentItem Posting View Item
GLAccount I_IE_InvcGeneralLedgerItem GLAccount General Ledger
PostingDate I_IE_InvcGeneralLedgerItem PostingDate Posting Date for GR
CompanyCodeCurrency I_IE_InvcGeneralLedgerItem CompanyCodeCurrency Local Currency
AmountInCompanyCodeCurrency I_IE_InvcGeneralLedgerItem AmountInCompanyCodeCurrency Local Crcy Amt
ExpenseTypeCategory I_IE_InvcGeneralLedgerItem ExpenseTypeCategory
ExpenseTypeSubcategory I_IE_InvcGeneralLedgerItem ExpenseTypeSubcategory
PersonnelNumber I_IE_InvcGeneralLedgerItem PersonnelNumber Personnel No.
AssignmentReference I_IE_InvcGeneralLedgerItem AssignmentReference Assignment Reference
Supplier EmployeeItem Supplier Supplier
BusinessPartner EmployeeItem BusinessPartner Issuing Authority
TaxNumber3
TaxNumber4
ClearingDate EmployeeItem ClearingDate Clearing Date
DueCalculationBaseDate EmployeeItem DueCalculationBaseDate Due Calculation Base Date
FirstName EmployeeItem FirstName First Name
LastName EmployeeItem LastName Last Name
BirthDate EmployeeItem BirthDate Date of Birth
CountryThreeLetterISOCode
Region
StreetName
HouseNumber
PostalCode

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 C_IE_InvcGenLedgerItemCube.
-- 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 C_IE_InvcGenLedgerItemCube AS
SELECT
  Log.StatryRptCategory AS StatryRptCategory,
  Log.StatryRptgEntity AS StatryRptgEntity,
  Log.StatryRptRunID AS StatryRptRunID,
  GLItem.CompanyCode AS CompanyCode,
  GLItem.FiscalYear AS FiscalYear,
  GLItem.AccountingDocument AS AccountingDocument,
  GLItem.AccountingDocumentItem AS AccountingDocumentItem,
  GLItem.GLAccount AS GLAccount,
  GLItem.PostingDate AS PostingDate,
  GLItem.CompanyCodeCurrency AS CompanyCodeCurrency,
  GLItem.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  GLItem.ExpenseTypeCategory AS ExpenseTypeCategory,
  GLItem.ExpenseTypeSubcategory AS ExpenseTypeSubcategory,
  GLItem.PersonnelNumber AS PersonnelNumber,
  GLItem.AssignmentReference AS AssignmentReference,
  EmployeeItem.Supplier AS Supplier,
  EmployeeItem.BusinessPartner AS BusinessPartner,
  EmployeeItem._BPTaxNumber3.BPTaxNumber AS TaxNumber3,
  EmployeeItem._BPTaxNumber4.BPTaxNumber AS TaxNumber4,
  EmployeeItem.ClearingDate AS ClearingDate,
  EmployeeItem.DueCalculationBaseDate AS DueCalculationBaseDate,
  EmployeeItem.FirstName AS FirstName,
  EmployeeItem.LastName AS LastName,
  EmployeeItem.BirthDate AS BirthDate,
  case when TaxNumber3 is initial or TaxNumber3 is null then EmployeeItem.CountryThreeLetterISOCode else '' end AS CountryThreeLetterISOCode,
  case when TaxNumber3 is initial or TaxNumber3 is null then EmployeeItem.Region else '' end AS Region,
  case when TaxNumber3 is initial or TaxNumber3 is null then EmployeeItem.StreetName else '' end AS StreetName,
  case when TaxNumber3 is initial or TaxNumber3 is null then EmployeeItem.HouseNumber else '' end AS HouseNumber,
  case when TaxNumber3 is initial or TaxNumber3 is null then EmployeeItem.PostalCode else '' end AS PostalCode
FROM I_IE_InvcGeneralLedgerItem AS GLItem
;

Learn More