I_GLJrnlEntryTaxItem

DDL: I_GLJRNLENTRYTAXITEM SQL: IGLJETI Type: view BASIC
22 Fields 2 Data Sources

I View for Tax Item in Verify GJE

I_GLJrnlEntryTaxItem is a Basic CDS View that provides data about "I View for Tax Item in Verify GJE" in SAP S/4HANA. It reads from 2 data sources (bset, vbset) and exposes 22 fields with key fields SourceCompanyCode, AccountingDocument, FiscalYear, ParkedAccountingDocumentItem, AccountingDocument.

Data Sources (2)

SourceAliasJoin Type
bset bset union_all
vbset vbset from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IGLJETI view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
VDM.viewType #BASIC view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label I View for Tax Item in Verify GJE view

Fields (22)

KeyFieldSource TableSource FieldDescription
KEY SourceCompanyCode ausbk Source CoCode
KEY AccountingDocument belnr SD Document
KEY FiscalYear gjahr Settlement Year
KEY ParkedAccountingDocumentItem bzkey Posting View Item
DebitCreditCode shkzg Returns
TaxCode mwskz Tax Code
TaxJurisdiction txjcd Tax Jurisdict.
TaxAmountInTransCrcy fwste Tax Amount
TaxAmountInCoCodeCrcy hwste LC Tax
TaxAmountInAdditionalCurrency1 h2ste LC 2 Tax
TaxAmountInAdditionalCurrency2 h3ste LC 3 Tax
KEY AccountingDocument belnr SD Document
KEY FiscalYear gjahr Settlement Year
KEY ParkedAccountingDocumentItem buzei Posting View Item
DebitCreditCode shkzg Returns
TaxCode mwskz Tax Code
TaxJurisdiction txjcd Tax Jurisdict.
TaxAmountInTransCrcy fwste Tax Amount
TaxAmountInCoCodeCrcy hwste LC Tax
TaxAmountInAdditionalCurrency1 h2ste LC 2 Tax
TaxAmountInAdditionalCurrency2 h3ste LC 3 Tax
TaxRateValidityStartDate txdat_from Tax Rate Valid-From

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_GLJrnlEntryTaxItem.
-- 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.
-- SQL view name: IGLJETI

CREATE VIEW I_GLJrnlEntryTaxItem AS
SELECT
  ausbk AS SourceCompanyCode,
  belnr AS AccountingDocument,
  gjahr AS FiscalYear,
  bzkey AS ParkedAccountingDocumentItem,
  shkzg AS DebitCreditCode,
  mwskz AS TaxCode,
  txjcd AS TaxJurisdiction,
  fwste AS TaxAmountInTransCrcy,
  hwste AS TaxAmountInCoCodeCrcy,
  h2ste AS TaxAmountInAdditionalCurrency1,
  h3ste AS TaxAmountInAdditionalCurrency2,
  txdat_from AS TaxRateValidityStartDate
FROM vbset
-- UNION ALL with additional select branch(es): bset
;

Learn More