P_EG_StRpTaxLineItem

DDL: P_EG_STRPTAXLINEITEM Type: view_entity COMPOSITE Package: GLO_FIN_IS_VAT_EG
63 Fields 1 Data Sources

Tax Line Items

P_EG_StRpTaxLineItem is a Composite CDS View that provides data about "Tax Line Items" in SAP S/4HANA. It reads from 1 data source (I_StRpTaxItem) and exposes 63 fields with key fields StatryRptgEntity, StatryRptCategory, StatryRptRunID, CompanyCode, FiscalYear. Part of development package GLO_FIN_IS_VAT_EG.

Data Sources (1)

SourceAliasJoin Type
I_StRpTaxItem item from

Annotations (7)

NameValueLevelField
VDM.viewType #COMPOSITE view
VDM.private true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.dataClass #MIXED view
AccessControl.personalData.blocking #BLOCKED_DATA_INCLUDED view

Fields (63)

KeyFieldSource TableSource FieldDescription
KEY StatryRptgEntity
KEY StatryRptCategory
KEY StatryRptRunID
KEY CompanyCode I_StRpTaxItem CompanyCode Receiver Company Code
KEY FiscalYear I_StRpTaxItem FiscalYear G/L Fiscal Year
KEY AccountingDocument I_StRpTaxItem AccountingDocument Journal Entry
KEY TaxItem I_StRpTaxItem TaxItem Tax Item
SenderLogicalSystem I_StRpTaxItem SenderLogicalSystem Sender Logical System
TaxCode I_StRpTaxItem TaxCode Tax Code
TaxRate I_StRpTaxItem TaxRate Tax Rate
TaxItemGroup I_StRpTaxItem TaxItemGroup Tax doc. item number
TransactionTypeDetermination I_StRpTaxItem TransactionTypeDetermination Transaction Key
TaxTypeendasTaxType
DebitCreditCode I_StRpTaxItem DebitCreditCode Single-Character Flag
AccountingDocumentType I_StRpTaxItem AccountingDocumentType Journal Entry Type
ReportingCountry I_StRpTaxItem ReportingCountry
CompanyCodeCountry I_StRpTaxItem CompanyCodeCountry Reporting Ctry/Reg.
ReportingDate
PostingDate I_StRpTaxItem PostingDate Posting Date for GR
DocumentDate I_StRpTaxItem DocumentDate Journal Entry Date
TaxReportingDocumentDate I_StRpTaxItem TaxReportingDocumentDate
DocumentCurrency
CompanyCodeCurrency I_StRpTaxItem CompanyCodeCurrency Local Currency
ReportingCurrency I_StRpTaxItem ReportingCurrency Currency
CountryCurrency I_StRpTaxItem CountryCurrency Currency
AdditionalCurrency1 I_StRpTaxItem AdditionalCurrency1 Local curr. 2
AdditionalCurrency2 I_StRpTaxItem AdditionalCurrency2 Local curr. 3
TaxNumber1 I_StRpTaxItem TaxNumber1 VAT Reg. No.
TaxNumber2 I_StRpTaxItem TaxNumber2 Tax Number 2
TaxNumber3 I_StRpTaxItem TaxNumber3
TaxBaseAmountInRptgCrcy
TaxAmountInRptgCrcy I_StRpTaxItem TaxAmountInRptgCrcy Tax Rept. Crcy
TaxBaseAmountInCoCodeCrcy I_StRpTaxItem TaxBaseAmountInCoCodeCrcy TxBaseAmt CoCodeCrcy
TaxAmountInCoCodeCrcy I_StRpTaxItem TaxAmountInCoCodeCrcy Tax Amount in Company Code Currency
TaxBaseAmountInTransCrcy I_StRpTaxItem TaxBaseAmountInTransCrcy Value-Added Tax
TaxAmount I_StRpTaxItem TaxAmount Tax Amt in Rptg Crcy
TaxBaseAmountInCountryCrcy I_StRpTaxItem TaxBaseAmountInCountryCrcy Base Amount
TaxAmountInCountryCrcy I_StRpTaxItem TaxAmountInCountryCrcy Tax Rept. Crcy
TaxBaseAmtInAdditionalCrcy1 TaxBaseAmtInAdditionalCrcy1 LC 2 Base
TaxAmountInAdditionalCurrency1 TaxAmountInAdditionalCurrency1 LC 2 Tax
TaxBaseAmtInAdditionalCrcy2 TaxBaseAmtInAdditionalCrcy2 LC 3 Base
TaxAmountInAdditionalCurrency2 TaxAmountInAdditionalCurrency2 LC 3 Tax
OriginalReferenceDocument I_StRpTaxItem OriginalReferenceDocument Reference Key
IsReversal I_StRpTaxItem IsReversal Reversal doc.
IsReversed I_StRpTaxItem IsReversed Reversed?
ReverseDocument I_StRpTaxItem ReverseDocument Reversed With
ReverseDocumentFiscalYear I_StRpTaxItem ReverseDocumentFiscalYear Year
TaxJurisdiction I_StRpTaxItem TaxJurisdiction Tax Jurisdiction
TaxCountry I_StRpTaxItem TaxCountry Tax Ctry/Reg.
ReferenceDocumentType I_StRpTaxItem ReferenceDocumentType Reference Document Type
GLAccount I_StRpTaxItem GLAccount General Ledger
InvoiceReference
Customer
_Customer
Supplier
_Supplier
BusinessPartnerCountry
BusinessPartnerName I_StRpTaxItem BusinessPartnerName Extracted Customer Name
BusinessPartner
IsNaturalPerson
TaxRateValidityStartDate I_StRpTaxItem TaxRateValidityStartDate Tax Rate Validity Start Date
_CustomerSupplierLineItem _CustomerSupplierLineItem
_DebtorCreditorRblsPyblsItem _DebtorCreditorRblsPyblsItem

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 P_EG_StRpTaxLineItem.
-- 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 P_EG_StRpTaxLineItem AS
SELECT
  item._ReportedItemsLog.StatryRptgEntity AS StatryRptgEntity,
  item._ReportedItemsLog.StatryRptCategory AS StatryRptCategory,
  item._ReportedItemsLog.StatryRptRunID AS StatryRptRunID,
  item.CompanyCode AS CompanyCode,
  item.FiscalYear AS FiscalYear,
  item.AccountingDocument AS AccountingDocument,
  item.TaxItem AS TaxItem,
  item.SenderLogicalSystem AS SenderLogicalSystem,
  item.TaxCode AS TaxCode,
  item.TaxRate AS TaxRate,
  item.TaxItemGroup AS TaxItemGroup,
  item.TransactionTypeDetermination AS TransactionTypeDetermination,
  case when item.TransactionTypeDetermination = 'ESA' then 'A' when item.TransactionTypeDetermination = 'ESE' then 'V' else item.TaxType end as TaxType AS TaxTypeendasTaxType,
  item.DebitCreditCode AS DebitCreditCode,
  item.AccountingDocumentType AS AccountingDocumentType,
  item.ReportingCountry AS ReportingCountry,
  item.CompanyCodeCountry AS CompanyCodeCountry,
  item.PostingDate AS PostingDate,
  item.DocumentDate AS DocumentDate,
  item.TaxReportingDocumentDate AS TaxReportingDocumentDate,
  item.CompanyCodeCurrency AS CompanyCodeCurrency,
  item.ReportingCurrency AS ReportingCurrency,
  item.CountryCurrency AS CountryCurrency,
  item.AdditionalCurrency1 AS AdditionalCurrency1,
  item.AdditionalCurrency2 AS AdditionalCurrency2,
  item.TaxNumber1 AS TaxNumber1,
  item.TaxNumber2 AS TaxNumber2,
  item.TaxNumber3 AS TaxNumber3,
  item.TaxAmountInRptgCrcy AS TaxAmountInRptgCrcy,
  item.TaxBaseAmountInCoCodeCrcy AS TaxBaseAmountInCoCodeCrcy,
  item.TaxAmountInCoCodeCrcy AS TaxAmountInCoCodeCrcy,
  item.TaxBaseAmountInTransCrcy AS TaxBaseAmountInTransCrcy,
  item.TaxAmount AS TaxAmount,
  item.TaxBaseAmountInCountryCrcy AS TaxBaseAmountInCountryCrcy,
  item.TaxAmountInCountryCrcy AS TaxAmountInCountryCrcy,
  TaxBaseAmtInAdditionalCrcy1,
  TaxAmountInAdditionalCurrency1,
  TaxBaseAmtInAdditionalCrcy2,
  TaxAmountInAdditionalCurrency2,
  item.OriginalReferenceDocument AS OriginalReferenceDocument,
  item.IsReversal AS IsReversal,
  item.IsReversed AS IsReversed,
  item.ReverseDocument AS ReverseDocument,
  item.ReverseDocumentFiscalYear AS ReverseDocumentFiscalYear,
  item.TaxJurisdiction AS TaxJurisdiction,
  item.TaxCountry AS TaxCountry,
  item.ReferenceDocumentType AS ReferenceDocumentType,
  item.GLAccount AS GLAccount,
  item._CustomerSupplierLineItem.InvoiceReference AS InvoiceReference,
  item._CustomerSupplierLineItem.Customer AS Customer,
  item._CustomerSupplierLineItem._Customer AS _Customer,
  item._CustomerSupplierLineItem.Supplier AS Supplier,
  item._CustomerSupplierLineItem._Supplier AS _Supplier,
  item.BusinessPartnerName AS BusinessPartnerName,
  coalesce(_CustomerSupplierLineItem._Customer._CustomerToBusinessPartner._BusinessPartner.BusinessPartner, _CustomerSupplierLineItem._Supplier._SupplierToBusinessPartner._BusinessPartner.BusinessPartner ) AS BusinessPartner,
  coalesce( _CustomerSupplierLineItem._OneTimeAccountBP.IsNaturalPerson , coalesce(_CustomerSupplierLineItem._Customer.NFPartnerIsNaturalPerson,_CustomerSupplierLineItem._Supplier.IsNaturalPerson )) AS IsNaturalPerson,
  item.TaxRateValidityStartDate AS TaxRateValidityStartDate
FROM I_StRpTaxItem AS item
;

Learn More