What is C_EG_StRpTaxDocItemQuery in SAP S/4HANA?

C_EG_StRpTaxDocItemQuery is a consumption CDS view in SAP S/4HANA. Tax Items for Statutory Reporting Egypt It contains 87 fields.

Which tables does C_EG_StRpTaxDocItemQuery read from?

C_EG_StRpTaxDocItemQuery reads data from: C_EG_StRpTaxDocItemCube.

What VDM layer is C_EG_StRpTaxDocItemQuery?

C_EG_StRpTaxDocItemQuery is classified as a Consumption view optimized for specific business scenarios and reporting.

C_EG_StRpTaxDocItemQuery

DDL: C_EG_STRPTAXDOCITEMQUERY SQL: CEGSRTAXDOCITMQ Type: view CONSUMPTION Package: GLO_FIN_IS_VAT_EG

87 Fields 1 Data Sources

Tax Items for Statutory Reporting Egypt

C_EG_StRpTaxDocItemQuery is a Consumption CDS View that provides data about "Tax Items for Statutory Reporting Egypt" in SAP S/4HANA. It reads from 1 data source (C_EG_StRpTaxDocItemCube) and exposes 87 fields with key fields CompanyCode, AccountingDocument, FiscalYear, AccountingDocumentItem, DocumentItemNumber. Part of development package GLO_FIN_IS_VAT_EG.

Data Sources (1)

Source	Alias	Join Type
C_EG_StRpTaxDocItemCube	C_EG_StRpTaxDocItemCube	from

Parameters (5)

Name	Type	Default
P_TaxReportingFromDate	vatdate
P_AdjustmentDocumentIsDerived	glo_derive_adjustment
P_StatryRptgEntity	srf_reporting_entity
P_StatryRptCategory	srf_rep_cat_id
P_StatryRptRunID	srf_report_run_id

Annotations (11)

Name	Value	Level
VDM.lifecycle.status	#DEPRECATED	view
VDM.lifecycle.successor	<C_EG_StRpTaxDocItemQuery_2>	view
AbapCatalog.sqlViewName	CEGSRTAXDOCITMQ	view
VDM.viewType	#CONSUMPTION	view
Analytics.query	true	view
AccessControl.authorizationCheck	#PRIVILEGED_ONLY	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
ObjectModel.usageType.sizeCategory	#XL	view
ObjectModel.usageType.serviceQuality	#D	view
ObjectModel.usageType.dataClass	#MIXED	view
EndUserText.label	Tax Items for Statutory Reporting Egypt	view

Fields (87)

Key	Field	Source Table	Source Field	Description
KEY	CompanyCode		CompanyCode	Receiver Company Code
KEY	AccountingDocument		AccountingDocument	Accounting Document
KEY	FiscalYear		FiscalYear	G/L Fiscal Year
KEY	AccountingDocumentItem		AccountingDocumentItem	Accounting Document Item
KEY	DocumentItemNumber		DocumentItemNumber	Item
KEY	StatryRptgEntity		StatryRptgEntity	Reporting Entity
KEY	StatryRptCategory		StatryRptCategory	Report ID
KEY	StatryRptRunID		StatryRptRunID	Report Run ID
KEY	TaxCode		TaxCode	Tax Code
KEY	TransactionTypeDetermination		TransactionTypeDetermination	Transaction Key
KEY	TaxBox		TaxBox	Tax.Bs.Gp.No.
KEY	TaxItemGroupingVersion		TaxItemGroupingVersion	Tax Grping Ver.
	TaxGroupName		TaxGroupName
	FinancialAccountType		FinancialAccountType	Financial Account Type
	AccountType		AccountType	Accounting Type(dtl)
	EG_DocumentType		EG_DocumentType
	EG_TaxType		EG_TaxType	ETA Tax Type
	EG_ScheduleTaxType		EG_ScheduleTaxType
	EG_DocumentItemNature		EG_DocumentItemNature
	EG_DocumentItemType		EG_DocumentItemType
	VATRegistration		VATRegistration	VAT Registration No.
	TaxFilingNumber		TaxFilingNumber	VAT Reg. No.
	NationalIDNumber		NationalIDNumber
	MobileNumber		MobileNumber	Mobile Number
	Supplier		Supplier	Supplier
	Customer		Customer	Sold-to Party
	BusinessPartnerName		BusinessPartnerName	Business Partner Name
	CustomerSupplierAddress		CustomerSupplierAddress	Partner Address
	SupplierAccountGroup		SupplierAccountGroup	Account group
	Material		Material	Vehicle Model
	ProductDescription		ProductDescription	Product Description
	TaxRate		TaxRate	Tax Rate
	UnitOfMeasure		UnitOfMeasureISOCode
	QuantityUnit		QuantityUnit	Unit of measure
	QuantityInActlPostg		QuantityInActlPostg
	ReportingCountry		ReportingCountry
	ReportingDate		ReportingDate	Reporting Date
	DateFormat		DateFormat	Short Description
	PostingDate		PostingDate	Posting Date
	DocumentDate		DocumentDate	Journal Entry Date
	FiscalPeriod		FiscalPeriod	Tax period
	TaxDeclnAmountType		TaxDeclnAmountType
	SupplierInvoice		SupplierInvoice	Supplier Invoice
	SupplierInvoiceItem		SupplierInvoiceItem
	BillingDocument		BillingDocument	Billing Document
	BillingDocumentItem		BillingDocumentItem	Item
	TaxType		TaxType	Tax Type
	TaxItemGroup		TaxItemGroup	Tax doc. item number
	AccountingDocumentType		AccountingDocumentType	Journal Entry Type
	AccountingDocumentItemType		AccountingDocumentItemType	Line Item ID
	ReferenceDocumentType		ReferenceDocumentType	Reference Document Type
	PostingKey		PostingKey	Posting Key
	DebitCreditCode		DebitCreditCode	Single-Character Flag
	GLAccount		GLAccount	General Ledger
	OriginalReferenceDocument		OriginalReferenceDocument	Reference Key
	BusinessArea		BusinessArea	Business Area
	ReverseDocument		ReverseDocument	Reversed With
	ReverseDocumentFiscalYear		ReverseDocumentFiscalYear	Year
	InvoiceReference		InvoiceReference	Invoice Reference
	InvoiceReferenceFiscalYear		InvoiceReferenceFiscalYear	Invoice Reference Fiscal Year
	ReferenceDocumentNumber		ReferenceDocumentNumber	Reference Document Number
	ReferenceDocumentFiscalYear		ReferenceDocumentFiscalYear	Year Cur.Period
	RefAccountingDocument		RefAccountingDocument	Reference Accounting Document
	RefAccountingDocumentPostgDate		RefAccountingDocumentPostgDate	Ref Accounting Document Posting Date
	DocumentCurrency		DocumentCurrency	Document Currency
	CompanyCodeCurrency		CompanyCodeCurrency	Local Currency
	ReportingCurrency		ReportingCurrency	Currency
	CountryCurrency		CountryCurrency	Country Currency
	AdditionalCurrency1		AdditionalCurrency1	Local curr. 2
	AdditionalCurrency2		AdditionalCurrency2	Local curr. 3
	TaxBaseAmountInRptgCrcy		TaxBaseAmountInRptgCrcy	Base Amount
	TaxAmountInRptgCrcy		TaxAmountInRptgCrcy	Tax Rept. Crcy
	TaxBaseAmountInCoCodeCrcy		TaxBaseAmountInCoCodeCrcy	TxBaseAmt CoCodeCrcy
	TaxAmountInCoCodeCrcy		TaxAmountInCoCodeCrcy	Tax Amount in Company Code Currency
	TaxBaseAmountInTransCrcy		TaxBaseAmountInTransCrcy	Value-Added Tax
	TaxAmount		TaxAmount	Tax Amt in Rptg Crcy
	TaxBaseAmtInAdditionalCrcy1		TaxBaseAmtInAdditionalCrcy1	LC 2 Base
	TaxAmountInAdditionalCurrency1		TaxAmountInAdditionalCurrency1	LC 2 Tax
	TaxBaseAmtInAdditionalCrcy2		TaxBaseAmtInAdditionalCrcy2	LC 3 Base
	TaxAmountInAdditionalCurrency2		TaxAmountInAdditionalCurrency2	LC 3 Tax
	GrossAmount		GrossAmount	Gross value
	TaxInvoiceItemNetUnitPrice		TaxInvoiceItemNetUnitPrice
	CashDiscountBaseAmount		CashDiscountBaseAmount	Cash Dscnt Base Amt
	CashDiscountAmount		CashDiscountAmount	CD Amount
	TaxRateValidityStartDate	C_EG_StRpTaxDocItemCube	TaxRateValidityStartDate	Tax Rate Validity Start Date
	TaxBoxStrucValidityStartDate	C_EG_StRpTaxDocItemCube	TaxBoxStrucValidityStartDate
	TaxBoxStrucValidityEndDate	C_EG_StRpTaxDocItemCube	TaxBoxStrucValidityEndDate

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_EG_StRpTaxDocItemQuery.
-- 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: CEGSRTAXDOCITMQ
-- Parameters: P_TaxReportingFromDate : vatdate, P_AdjustmentDocumentIsDerived : glo_derive_adjustment, P_StatryRptgEntity : srf_reporting_entity, P_StatryRptCategory : srf_rep_cat_id, P_StatryRptRunID : srf_report_run_id

CREATE VIEW C_EG_StRpTaxDocItemQuery AS
SELECT
  CompanyCode,
  AccountingDocument,
  FiscalYear,
  AccountingDocumentItem,
  DocumentItemNumber,
  StatryRptgEntity,
  StatryRptCategory,
  StatryRptRunID,
  TaxCode,
  TransactionTypeDetermination,
  TaxBox,
  TaxItemGroupingVersion,
  TaxGroupName,
  FinancialAccountType,
  AccountType,
  EG_DocumentType,
  EG_TaxType,
  EG_ScheduleTaxType,
  EG_DocumentItemNature,
  EG_DocumentItemType,
  VATRegistration,
  TaxFilingNumber,
  NationalIDNumber,
  MobileNumber,
  Supplier,
  Customer,
  BusinessPartnerName,
  CustomerSupplierAddress,
  SupplierAccountGroup,
  Material,
  ProductDescription,
  TaxRate,
  UnitOfMeasureISOCode AS UnitOfMeasure,
  QuantityUnit,
  QuantityInActlPostg,
  ReportingCountry,
  ReportingDate,
  DateFormat,
  PostingDate,
  DocumentDate,
  FiscalPeriod,
  TaxDeclnAmountType,
  SupplierInvoice,
  SupplierInvoiceItem,
  BillingDocument,
  BillingDocumentItem,
  TaxType,
  TaxItemGroup,
  AccountingDocumentType,
  AccountingDocumentItemType,
  ReferenceDocumentType,
  PostingKey,
  DebitCreditCode,
  GLAccount,
  OriginalReferenceDocument,
  BusinessArea,
  ReverseDocument,
  ReverseDocumentFiscalYear,
  InvoiceReference,
  InvoiceReferenceFiscalYear,
  ReferenceDocumentNumber,
  ReferenceDocumentFiscalYear,
  RefAccountingDocument,
  RefAccountingDocumentPostgDate,
  DocumentCurrency,
  CompanyCodeCurrency,
  ReportingCurrency,
  CountryCurrency,
  AdditionalCurrency1,
  AdditionalCurrency2,
  TaxBaseAmountInRptgCrcy,
  TaxAmountInRptgCrcy,
  TaxBaseAmountInCoCodeCrcy,
  TaxAmountInCoCodeCrcy,
  TaxBaseAmountInTransCrcy,
  TaxAmount,
  TaxBaseAmtInAdditionalCrcy1,
  TaxAmountInAdditionalCurrency1,
  TaxBaseAmtInAdditionalCrcy2,
  TaxAmountInAdditionalCurrency2,
  GrossAmount,
  TaxInvoiceItemNetUnitPrice,
  CashDiscountBaseAmount,
  CashDiscountAmount,
  C_EG_StRpTaxDocItemCube.TaxRateValidityStartDate AS TaxRateValidityStartDate,
  C_EG_StRpTaxDocItemCube.TaxBoxStrucValidityStartDate AS TaxBoxStrucValidityStartDate,
  C_EG_StRpTaxDocItemCube.TaxBoxStrucValidityEndDate AS TaxBoxStrucValidityEndDate
FROM C_EG_StRpTaxDocItemCube
;

Depth:

C_EG_StRpTaxDocItemQuery view

C_EG_StRpTaxDocItemCube view