What is I_IN_StRpGSTRet in SAP S/4HANA?

I_IN_StRpGSTRet is a composite CDS view in SAP S/4HANA. Tax Item Details for GST Returns It contains 82 fields.

Which tables does I_IN_StRpGSTRet read from?

I_IN_StRpGSTRet reads data from: I_BillingDocument, I_TaxDefCondType, I_Customer, P_IN_GST_TAXITEMRATE, I_OperationalAcctgDocItem and more.

What VDM layer is I_IN_StRpGSTRet?

I_IN_StRpGSTRet is classified as a Composite view that combines data from multiple basic views.

I_IN_StRpGSTRet

DDL: I_IN_STRPGSTRET SQL: ISTRPGSTTAXITEM Type: view COMPOSITE

82 Fields 8 Data Sources

Tax Item Details for GST Returns

I_IN_StRpGSTRet is a Composite CDS View (Cube) that provides data about "Tax Item Details for GST Returns" in SAP S/4HANA. It reads from 8 data sources and exposes 82 fields with key fields CompanyCode, AccountingDocument, FiscalYear, TaxItem.

Data Sources (8)

Source	Alias	Join Type
I_BillingDocument	_BillingDocument	left_outer
I_TaxDefCondType	_CndnName	left_outer
I_Customer	_CustomerInfo	left_outer
P_IN_GST_TAXITEMRATE	_GstTaxItemRate	left_outer
I_OperationalAcctgDocItem	_MatlRblsPyblsItem	left_outer
P_IN_GST_ISRCM	_RCMTaxItem	left_outer
I_Supplier	_SupplierInfo	left_outer
I_CustSalesAreaTax	CustSalesAreaTax	left_outer

Annotations (14)

Name	Value	Level
AbapCatalog.sqlViewName	ISTRPGSTTAXITEM	view
AbapCatalog.compiler.compareFilter	true	view
AbapCatalog.preserveKey	true	view
VDM.viewType	#COMPOSITE	view
Analytics.dataCategory	#CUBE	view
AccessControl.authorizationCheck	#CHECK	view
AccessControl.personalData.blocking	#NOT_REQUIRED	view
Analytics.internalName	#LOCAL	view
EndUserText.label	Tax Item Details for GST Returns	view
ObjectModel.usageType.sizeCategory	#XL	view
ObjectModel.usageType.serviceQuality	#X	view
ObjectModel.usageType.dataClass	#MIXED	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
Metadata.allowExtensions	true	view

Fields (82)

Key	Field	Source Table	Source Field	Description
KEY	CompanyCode	I_StRpTaxItem	CompanyCode	Receiver Company Code
KEY	AccountingDocument	I_StRpTaxItem	AccountingDocument	Journal Entry
KEY	FiscalYear	I_StRpTaxItem	FiscalYear	G/L Fiscal Year
KEY	TaxItem	I_StRpTaxItem	TaxItem	Tax Item
	TaxCode	I_StRpTaxItem	TaxCode	Tax Code
	TransactionTypeDetermination	I_StRpTaxItem	TransactionTypeDetermination	Transaction Key
	TaxCalculationProcedure	I_StRpTaxItem	TaxCalculationProcedure	Tax Procedure
	TaxRate	P_IN_GST_TAXITEMRATE	TaxRate	Tax Rate
	GLAccount	I_StRpTaxItem	GLAccount	General Ledger
	TaxItemGroup	I_StRpTaxItem	TaxItemGroup	Tax doc. item number
	TaxJurisdiction	I_StRpTaxItem	TaxJurisdiction	Tax Jurisdiction
	BusinessPlace	I_StRpTaxItem	BusinessPlace	Business place
	AccountingDocumentType	I_StRpTaxItem	AccountingDocumentType	Journal Entry Type
	ReferenceDocumentType	I_StRpTaxItem	ReferenceDocumentType	Reference Document Type
	ReverseDocument	I_StRpTaxItem	ReverseDocument	Reversed With
	ReverseDocumentFiscalYear	I_StRpTaxItem	ReverseDocumentFiscalYear	Year
	EUTaxClassification	I_StRpTaxItem	EUTaxClassification
	Ledger	I_StRpTaxItem	Ledger	Ledger
	LedgerGroup	I_StRpTaxItem	LedgerGroup	Ledger Group
	PostingDate	I_StRpTaxItem	PostingDate	Posting Date for GR
	TaxReportingDate	I_StRpTaxItem	TaxReportingDate	Tax Reporting Date
	ReportingDate	I_StRpTaxItem	ReportingDate
	FiscalPeriod	I_StRpTaxItem	FiscalPeriod	Tax period
	ExchangeRate	I_StRpTaxItem	ExchangeRate	Exchange rate
	IsReversal	I_StRpTaxItem	IsReversal	Reversal doc.
	IsReversed	I_StRpTaxItem	IsReversed	Reversed?
	CompanyCodeCountry	I_StRpTaxItem	CompanyCodeCountry	Reporting Ctry/Reg.
	ReportingCountry	I_StRpTaxItem	ReportingCountry
	TaxReturnCountry	I_StRpTaxItem	TaxReturnCountry	Reporting C/R
	CompanyCodeCurrency	I_StRpTaxItem	CompanyCodeCurrency	Local Currency
	CountryCurrency	I_StRpTaxItem	CountryCurrency	Currency
	DocumentCurrency	I_StRpTaxItem	DocumentCurrency	Document Currency
	ReportingCurrency	I_StRpTaxItem	ReportingCurrency	Currency
	AdditionalCurrency1	I_StRpTaxItem	AdditionalCurrency1	Local curr. 2
	AdditionalCurrency2	I_StRpTaxItem	AdditionalCurrency2	Local curr. 3
	TaxBaseAmountInRptgCrcy	I_StRpTaxItem	TaxBaseAmountInRptgCrcy	Base Amount
	TaxAmountInRptgCrcy	I_StRpTaxItem	TaxAmountInRptgCrcy	Tax Rept. Crcy
	TaxAmountInCoCodeCrcy	I_StRpTaxItem	TaxAmountInCoCodeCrcy	Tax Amount in Company Code Currency
	TaxBaseAmountInCoCodeCrcy	I_StRpTaxItem	TaxBaseAmountInCoCodeCrcy	TxBaseAmt CoCodeCrcy
	TaxAmount	I_StRpTaxItem	TaxAmount	Tax Amt in Rptg Crcy
	TaxBaseAmountInCountryCrcy	I_StRpTaxItem	TaxBaseAmountInCountryCrcy	Base Amount
	TaxAmountInCountryCrcy	I_StRpTaxItem	TaxAmountInCountryCrcy	Tax Rept. Crcy
	TaxBaseAmountInTransCrcy	I_StRpTaxItem	TaxBaseAmountInTransCrcy	Value-Added Tax
	TaxBaseAmtInAdditionalCrcy1	I_StRpTaxItem	TaxBaseAmtInAdditionalCrcy1	LC 2 Base
	TaxBaseAmtInAdditionalCrcy2	I_StRpTaxItem	TaxBaseAmtInAdditionalCrcy2	LC 3 Base
	TaxAmountInAdditionalCurrency1	I_StRpTaxItem	TaxAmountInAdditionalCurrency1	LC 2 Tax
	TaxAmountInAdditionalCurrency2	I_StRpTaxItem	TaxAmountInAdditionalCurrency2	LC 3 Tax
	Customer	I_StRpTaxItem	Customer	Sold-to Party
	Supplier	I_StRpTaxItem	Supplier	Supplier
	SupplierName
	TaxType	I_StRpTaxItem	TaxType	Tax Type
	TargetTaxCode	I_StRpTaxItem	TargetTaxCode
	TaxNumber1	I_StRpTaxItem	TaxNumber1	VAT Reg. No.
	TaxNumber2	I_StRpTaxItem	TaxNumber2	Tax Number 2
	TaxNumber3	I_StRpTaxItem	TaxNumber3
	BusinessPartner	I_StRpTaxItem	BusinessPartner	Issuing Authority
	BusinessPartnerName	I_StRpTaxItem	BusinessPartnerName	Extracted Customer Name
	CustomerSupplierAddress	I_StRpTaxItem	CustomerSupplierAddress
	SupplierAccountGroup	I_StRpTaxItem	SupplierAccountGroup	Account group
	ConditionType	I_StRpTaxItem	ConditionType	Condition type
	TaxIsNotDeductible	I_StRpTaxItem	TaxIsNotDeductible	Non-Deductible
	AmountInCompanyCodeCurrency	_DebtorCreditorRblsPyblsItem	AmountInCompanyCodeCurrency	Local Crcy Amt
	SpecialGLTransactionType	_DebtorCreditorRblsPyblsItem	SpecialGLTransactionType	Transact.Type
	DebitCreditCode	_DebtorCreditorRblsPyblsItem	DebitCreditCode	Single-Character Flag
	InvoiceReference	_DebtorCreditorRblsPyblsItem	InvoiceReference	Invoice Reference
	InvoiceReferenceFiscalYear	_DebtorCreditorRblsPyblsItem	InvoiceReferenceFiscalYear	Invoice Reference Fiscal Year
	InvoiceItemReference	_DebtorCreditorRblsPyblsItem	InvoiceItemReference	Item
	FollowOnDocumentType	_DebtorCreditorRblsPyblsItem	FollowOnDocumentType	Follow-On Document Type
	FinancialAccountType	_DebtorCreditorRblsPyblsItem	FinancialAccountType	Fin. Account Type
	IN_GSTPlaceOfSupply	_DebtorCreditorRblsPyblsItem	IN_GSTPlaceOfSupply	Place of Supply
	IN_HSNOrSACCode	I_OperationalAcctgDocItem	IN_HSNOrSACCode	HSN/SAC Code
	DocumentDate
	DocumentReferenceID
	Country	I_Customer	Country	Venue: Ctry/Reg
	CustomerTaxClassification	I_CustSalesAreaTax	CustomerTaxClassification	Tax Classific.
	IndianTaxConditionName	I_TaxDefCondType	IndianTaxConditionName	Condition Name
	IN_GSTSupplierClassification	I_Supplier	IN_GSTSupplierClassification
	SDDocumentCategory	I_BillingDocument	SDDocumentCategory	Document Cat.
	00endasIN_IntegratedGSTAmount
	00endasIN_StateGSTAmount
	00endasIN_CentralGSTAmount
	00endasIN_CessGSTAmtInCoCodeCrcy

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_IN_StRpGSTRet.
-- 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: ISTRPGSTTAXITEM

CREATE VIEW I_IN_StRpGSTRet AS
SELECT
  I_StRpTaxItem.CompanyCode AS CompanyCode,
  I_StRpTaxItem.AccountingDocument AS AccountingDocument,
  I_StRpTaxItem.FiscalYear AS FiscalYear,
  I_StRpTaxItem.TaxItem AS TaxItem,
  I_StRpTaxItem.TaxCode AS TaxCode,
  I_StRpTaxItem.TransactionTypeDetermination AS TransactionTypeDetermination,
  I_StRpTaxItem.TaxCalculationProcedure AS TaxCalculationProcedure,
  _GstTaxItemRate.TaxRate AS TaxRate,
  I_StRpTaxItem.GLAccount AS GLAccount,
  I_StRpTaxItem.TaxItemGroup AS TaxItemGroup,
  I_StRpTaxItem.TaxJurisdiction AS TaxJurisdiction,
  I_StRpTaxItem.BusinessPlace AS BusinessPlace,
  I_StRpTaxItem.AccountingDocumentType AS AccountingDocumentType,
  I_StRpTaxItem.ReferenceDocumentType AS ReferenceDocumentType,
  I_StRpTaxItem.ReverseDocument AS ReverseDocument,
  I_StRpTaxItem.ReverseDocumentFiscalYear AS ReverseDocumentFiscalYear,
  I_StRpTaxItem.EUTaxClassification AS EUTaxClassification,
  I_StRpTaxItem.Ledger AS Ledger,
  I_StRpTaxItem.LedgerGroup AS LedgerGroup,
  I_StRpTaxItem.PostingDate AS PostingDate,
  I_StRpTaxItem.TaxReportingDate AS TaxReportingDate,
  I_StRpTaxItem.ReportingDate AS ReportingDate,
  I_StRpTaxItem.FiscalPeriod AS FiscalPeriod,
  I_StRpTaxItem.ExchangeRate AS ExchangeRate,
  I_StRpTaxItem.IsReversal AS IsReversal,
  I_StRpTaxItem.IsReversed AS IsReversed,
  I_StRpTaxItem.CompanyCodeCountry AS CompanyCodeCountry,
  I_StRpTaxItem.ReportingCountry AS ReportingCountry,
  I_StRpTaxItem.TaxReturnCountry AS TaxReturnCountry,
  I_StRpTaxItem.CompanyCodeCurrency AS CompanyCodeCurrency,
  I_StRpTaxItem.CountryCurrency AS CountryCurrency,
  I_StRpTaxItem.DocumentCurrency AS DocumentCurrency,
  I_StRpTaxItem.ReportingCurrency AS ReportingCurrency,
  I_StRpTaxItem.AdditionalCurrency1 AS AdditionalCurrency1,
  I_StRpTaxItem.AdditionalCurrency2 AS AdditionalCurrency2,
  I_StRpTaxItem.TaxBaseAmountInRptgCrcy AS TaxBaseAmountInRptgCrcy,
  I_StRpTaxItem.TaxAmountInRptgCrcy AS TaxAmountInRptgCrcy,
  I_StRpTaxItem.TaxAmountInCoCodeCrcy AS TaxAmountInCoCodeCrcy,
  I_StRpTaxItem.TaxBaseAmountInCoCodeCrcy AS TaxBaseAmountInCoCodeCrcy,
  I_StRpTaxItem.TaxAmount AS TaxAmount,
  I_StRpTaxItem.TaxBaseAmountInCountryCrcy AS TaxBaseAmountInCountryCrcy,
  I_StRpTaxItem.TaxAmountInCountryCrcy AS TaxAmountInCountryCrcy,
  I_StRpTaxItem.TaxBaseAmountInTransCrcy AS TaxBaseAmountInTransCrcy,
  I_StRpTaxItem.TaxBaseAmtInAdditionalCrcy1 AS TaxBaseAmtInAdditionalCrcy1,
  I_StRpTaxItem.TaxBaseAmtInAdditionalCrcy2 AS TaxBaseAmtInAdditionalCrcy2,
  I_StRpTaxItem.TaxAmountInAdditionalCurrency1 AS TaxAmountInAdditionalCurrency1,
  I_StRpTaxItem.TaxAmountInAdditionalCurrency2 AS TaxAmountInAdditionalCurrency2,
  I_StRpTaxItem.Customer AS Customer,
  I_StRpTaxItem.Supplier AS Supplier,
  I_StRpTaxItem._Supplier.SupplierName AS SupplierName,
  I_StRpTaxItem.TaxType AS TaxType,
  I_StRpTaxItem.TargetTaxCode AS TargetTaxCode,
  I_StRpTaxItem.TaxNumber1 AS TaxNumber1,
  I_StRpTaxItem.TaxNumber2 AS TaxNumber2,
  I_StRpTaxItem.TaxNumber3 AS TaxNumber3,
  I_StRpTaxItem.BusinessPartner AS BusinessPartner,
  I_StRpTaxItem.BusinessPartnerName AS BusinessPartnerName,
  I_StRpTaxItem.CustomerSupplierAddress AS CustomerSupplierAddress,
  I_StRpTaxItem.SupplierAccountGroup AS SupplierAccountGroup,
  I_StRpTaxItem.ConditionType AS ConditionType,
  I_StRpTaxItem.TaxIsNotDeductible AS TaxIsNotDeductible,
  _DebtorCreditorRblsPyblsItem.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  _DebtorCreditorRblsPyblsItem.SpecialGLTransactionType AS SpecialGLTransactionType,
  _DebtorCreditorRblsPyblsItem.DebitCreditCode AS DebitCreditCode,
  _DebtorCreditorRblsPyblsItem.InvoiceReference AS InvoiceReference,
  _DebtorCreditorRblsPyblsItem.InvoiceReferenceFiscalYear AS InvoiceReferenceFiscalYear,
  _DebtorCreditorRblsPyblsItem.InvoiceItemReference AS InvoiceItemReference,
  _DebtorCreditorRblsPyblsItem.FollowOnDocumentType AS FollowOnDocumentType,
  _DebtorCreditorRblsPyblsItem.FinancialAccountType AS FinancialAccountType,
  _DebtorCreditorRblsPyblsItem.IN_GSTPlaceOfSupply AS IN_GSTPlaceOfSupply,
  _MatlRblsPyblsItem.IN_HSNOrSACCode AS IN_HSNOrSACCode,
  I_StRpTaxItem._JournalEntry.DocumentDate AS DocumentDate,
  I_StRpTaxItem._JournalEntry.DocumentReferenceID AS DocumentReferenceID,
  _CustomerInfo.Country AS Country,
  CustSalesAreaTax.CustomerTaxClassification AS CustomerTaxClassification,
  _CndnName.IndianTaxConditionName AS IndianTaxConditionName,
  _SupplierInfo.IN_GSTSupplierClassification AS IN_GSTSupplierClassification,
  _BillingDocument.SDDocumentCategory AS SDDocumentCategory,
  case when _CndnName.IndianTaxConditionName = 'IGSTAR' or _CndnName.IndianTaxConditionName = 'IGSTINVAP' or _CndnName.IndianTaxConditionName = 'IGSTSOFFAP' or _CndnName.IndianTaxConditionName = 'IGSTNVIMAP' or _CndnName.IndianTaxConditionName = 'IGSTIMPAP' or _CndnName.IndianTaxConditionName = 'IGSTRCMINV' then I_StRpTaxItem.TaxAmountInCoCodeCrcy else 0.00 end as IN_IntegratedGSTAmount AS 00endasIN_IntegratedGSTAmount,
  case when _CndnName.IndianTaxConditionName = 'SGSTAR' or _CndnName.IndianTaxConditionName = 'SGSTINVAP' or _CndnName.IndianTaxConditionName = 'SGSTSOFFAP' or _CndnName.IndianTaxConditionName = 'SGSTRCMINV' or _CndnName.IndianTaxConditionName = 'UTGSTAR' or _CndnName.IndianTaxConditionName = 'UTGSTINVAP' or _CndnName.IndianTaxConditionName = 'UTGSTOFFAP' or _CndnName.IndianTaxConditionName = 'UTGSTRCMINV' then I_StRpTaxItem.TaxAmountInCoCodeCrcy else 0.00 end as IN_StateGSTAmount AS 00endasIN_StateGSTAmount,
  case when _CndnName.IndianTaxConditionName = 'CGSTAR' or _CndnName.IndianTaxConditionName = 'CGSTINVAP' or _CndnName.IndianTaxConditionName = 'CGSTSOFFAP' or _CndnName.IndianTaxConditionName = 'CGSTRCMINV' then I_StRpTaxItem.TaxAmountInCoCodeCrcy else 0.00 end as IN_CentralGSTAmount AS 00endasIN_CentralGSTAmount,
  case when _CndnName.IndianTaxConditionName = 'CCQINVAP' or _CndnName.IndianTaxConditionName = 'CESSRCMINV' or _CndnName.IndianTaxConditionName = 'CCPSOFFAR' or _CndnName.IndianTaxConditionName = 'CCQSOFFAR' or _CndnName.IndianTaxConditionName = 'CCPSOFFAP' or _CndnName.IndianTaxConditionName = 'CCQSOFFAP' or _CndnName.IndianTaxConditionName = 'CCQIMPSEOF' or _CndnName.IndianTaxConditionName = 'CCQIMPINV' or _CndnName.IndianTaxConditionName = 'CCIMPSETOF' or _CndnName.IndianTaxConditionName = 'CCIMPINV' or _CndnName.IndianTaxConditionName = 'CCPINVAP' then I_StRpTaxItem.TaxAmountInCoCodeCrcy else 0.00 end as IN_CessGSTAmtInCoCodeCrcy AS 00endasIN_CessGSTAmtInCoCodeCrcy
LEFT OUTER JOIN P_IN_GST_TAXITEMRATE AS _GstTaxItemRate ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_OperationalAcctgDocItem AS _MatlRblsPyblsItem ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_BillingDocument AS _BillingDocument ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_TaxDefCondType AS _CndnName ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_Customer AS _CustomerInfo ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_Supplier AS _SupplierInfo ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CustSalesAreaTax AS CustSalesAreaTax ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_IN_GST_ISRCM AS _RCMTaxItem ON /* join condition not captured in parsed metadata */
;

Depth:

I_IN_StRpGSTRet view