What is C_EG_StRpTaxDocItemCube in SAP S/4HANA?

C_EG_StRpTaxDocItemCube is a consumption CDS view in SAP S/4HANA. Egypt specific Tax Item Cube View for Statutory Reporting It contains 95 fields.

Which tables does C_EG_StRpTaxDocItemCube read from?

C_EG_StRpTaxDocItemCube reads data from: C_EG_StRpDocItmWthAdjustedGrpg.

What VDM layer is C_EG_StRpTaxDocItemCube?

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

C_EG_StRpTaxDocItemCube

DDL: C_EG_STRPTAXDOCITEMCUBE SQL: CEGSRTAXDOCITEMC Type: view CONSUMPTION

95 Fields 1 Data Sources 1 Associations

Egypt specific Tax Item Cube View for Statutory Reporting

C_EG_StRpTaxDocItemCube is a Consumption CDS View (Cube) that provides data about "Egypt specific Tax Item Cube View for Statutory Reporting" in SAP S/4HANA. It reads from 1 data source (C_EG_StRpDocItmWthAdjustedGrpg) and exposes 95 fields with key fields CompanyCode, FiscalYear, AccountingDocument, AccountingDocumentItem, DocumentItemNumber. It has 1 association to related views.

Data Sources (1)

Source	Alias	Join Type
C_EG_StRpDocItmWthAdjustedGrpg	C_EG_StRpDocItmWthAdjustedGrpg	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

Associations (1)

Cardinality	Target	Alias	Condition
[0..*]	I_TaxGroupingText	_TaxGroupName	`$projection.ReportingCountry = _TaxGroupName.Country and $projection.TaxItemGroupingVersion = _TaxGroupName.TaxItemGroupingVersion and $projection.TaxBox = _TaxGroupName.TaxBox`

Annotations (15)

Name	Value	Level
VDM.lifecycle.status	#DEPRECATED	view
VDM.lifecycle.successor	<I_EG_StRpTaxItemBoxCube>	view
AbapCatalog.sqlViewName	CEGSRTAXDOCITEMC	view
AbapCatalog.compiler.compareFilter	true	view
AccessControl.authorizationCheck	#CHECK	view
VDM.viewType	#CONSUMPTION	view
Analytics.dataCategory	#CUBE	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
ObjectModel.usageType.sizeCategory	#XL	view
ObjectModel.usageType.serviceQuality	#D	view
ObjectModel.usageType.dataClass	#MIXED	view
AccessControl.personalData.blocking	#BLOCKED_DATA_INCLUDED	view
Metadata.allowExtensions	true	view
AbapCatalog.preserveKey	true	view
EndUserText.label	Egypt specific Tax Item Cube View for Statutory Reporting	view

Fields (95)

Key	Field	Source Table	Source Field	Description
KEY	CompanyCode		CompanyCode	Receiver Company Code
KEY	FiscalYear		FiscalYear	G/L Fiscal Year
KEY	AccountingDocument		AccountingDocument	Journal Entry
KEY	AccountingDocumentItem		AccountingDocumentItem	Posting View 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
	EG_DocumentTypeendasEG_DocumentType
	TaxRate		TaxRate	Tax Rate
	TaxDeclnAmountType		TaxDeclnAmountType
	SupplierInvoice		SupplierInvoice
	SupplierInvoiceItem		SupplierInvoiceItem
	BillingDocument		BillingDocument	SD 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
	FinancialAccountType		FinancialAccountType	Fin. Account Type
	AccountType		AccountType	Accounting Type(dtl)
	FiscalPeriod		FiscalPeriod	Tax period
	ReportingDate		ReportingDate
	DateFormat
	PostingDate		PostingDate	Posting Date for GR
	DocumentDate		DocumentDate	Journal Entry Date
	Material		Material	Vehicle Model
	DocumentItemText		DocumentItemText	Text
	QuantityUnit		QuantityUnit	Unit of measure
	UnitOfMeasureISOCode		UnitOfMeasureISOCode
	OriginalReferenceDocument		OriginalReferenceDocument	Reference Key
	BusinessArea		BusinessArea	Business Area
	Supplier		Supplier	Supplier
	Customer		Customer	Sold-to Party
	BusinessPartnerName		BusinessPartnerName	Extracted Customer Name
	TaxFilingNumber		TaxNumber1	VAT Reg. No.
	TaxNumber2		TaxNumber2	Tax Number 2
	TaxNumber3		TaxNumber3
	VATRegistration		VATRegistration	VAT Registration No.
	NationalIDNumber		NationalIDNumber
	MobileNumber		MobileNumber	Telephone
	ProductDescription		ProductDescription	Description
	CustomerSupplierAddress		CustomerSupplierAddress
	SupplierAccountGroup		SupplierAccountGroup	Account group
	ReportingCountry		ReportingCountry
	ReverseDocument		ReverseDocument	Reversed With
	ReverseDocumentFiscalYear		ReverseDocumentFiscalYear	Year
	InvoiceReference		InvoiceReference	Invoice Reference
	InvoiceReferenceFiscalYear		InvoiceReferenceFiscalYear	Invoice Reference Fiscal Year
	ReferenceDocumentNumber		ReferenceDocumentNumber
	ReferenceDocumentFiscalYear		ReferenceDocumentFiscalYear	Year Cur.Period
	RefAccountingDocument		RefAccountingDocument	Document Number
	RefAccountingDocumentPostgDate		RefAccountingDocumentPostgDate
	TaxInvoiceItemNetUnitPrice		TaxInvoiceItemNetUnitPrice
	DocumentCurrency		DocumentCurrency	Document Currency
	CompanyCodeCurrency		CompanyCodeCurrency	Local Currency
	ReportingCurrency		ReportingCurrency	Currency
	CountryCurrency		CountryCurrency	Currency
	AdditionalCurrency1		AdditionalCurrency1	Local curr. 2
	AdditionalCurrency2		AdditionalCurrency2	Local curr. 3
	DistributedTaxAmountInCCrcy		DistributedTaxAmountInCCrcy
	DistrdTaxBaseAmountInCCrcy		DistrdTaxBaseAmountInCCrcy
	DistributedTaxAmountInTC		DistributedTaxAmountInTC
	DistrdTaxBaseAmountInTransCrcy		DistrdTaxBaseAmountInTransCrcy
	DistributedTaxAmtInCountryCrcy		DistributedTaxAmtInCountryCrcy
	DistrdTaxBaseAmountInCntryCrcy		DistrdTaxBaseAmountInCntryCrcy
	AmountInReportingCurrency		AmountInReportingCurrency
	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
	TaxBaseAmountInCountryCrcy		TaxBaseAmountInCountryCrcy	Base Amount
	TaxAmountInCountryCrcy		TaxAmountInCountryCrcy	Tax Rept. Crcy
	TaxBaseAmtInAdditionalCrcy1		TaxBaseAmtInAdditionalCrcy1	LC 2 Base
	TaxAmountInAdditionalCurrency1		TaxAmountInAdditionalCurrency1	LC 2 Tax
	TaxBaseAmtInAdditionalCrcy2		TaxBaseAmtInAdditionalCrcy2	LC 3 Base
	TaxAmountInAdditionalCurrency2		TaxAmountInAdditionalCurrency2	LC 3 Tax
	GrossAmount
	ItemIsReportingRelevant		ItemIsReportingRelevant	Item Reporting Relv
	CashDiscountBaseAmount		CashDiscountBaseAmount	Cash Dscnt Base Amt
	CashDiscountAmount		CashDiscountAmount	CD Amount
	TaxRateValidityStartDate	C_EG_StRpDocItmWthAdjustedGrpg	TaxRateValidityStartDate	Tax Rate Validity Start Date
	TaxBoxStrucValidityStartDate	C_EG_StRpDocItmWthAdjustedGrpg	TaxBoxStrucValidityStartDate
	TaxBoxStrucValidityEndDate	C_EG_StRpDocItmWthAdjustedGrpg	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_StRpTaxDocItemCube.
-- 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: CEGSRTAXDOCITEMC
-- 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_StRpTaxDocItemCube AS
SELECT
  CompanyCode,
  FiscalYear,
  AccountingDocument,
  AccountingDocumentItem,
  DocumentItemNumber,
  StatryRptgEntity,
  StatryRptCategory,
  StatryRptRunID,
  TaxCode,
  TransactionTypeDetermination,
  TaxBox,
  TaxItemGroupingVersion,
  _TaxGroupName[1:Language = $session.system_language].TaxGroupName AS TaxGroupName,
  case when C_EG_StRpDocItmWthAdjustedGrpg.EG_DocumentItemNature = '5' and TaxType = 'A' and DebitCreditCode = 'H' then '2' when C_EG_StRpDocItmWthAdjustedGrpg.EG_DocumentItemNature = '5' and TaxType = 'A' and DebitCreditCode = 'S' then '3' when C_EG_StRpDocItmWthAdjustedGrpg.EG_DocumentItemNature = '5' and TaxType = 'V' and DebitCreditCode = 'S' then '2' when C_EG_StRpDocItmWthAdjustedGrpg.EG_DocumentItemNature = '5' and TaxType = 'V' and DebitCreditCode = 'H' then '3' else C_EG_StRpDocItmWthAdjustedGrpg.EG_DocumentType end as EG_DocumentType AS EG_DocumentTypeendasEG_DocumentType,
  TaxRate,
  TaxDeclnAmountType,
  SupplierInvoice,
  SupplierInvoiceItem,
  BillingDocument,
  BillingDocumentItem,
  TaxType,
  TaxItemGroup,
  AccountingDocumentType,
  AccountingDocumentItemType,
  ReferenceDocumentType,
  PostingKey,
  DebitCreditCode,
  GLAccount,
  FinancialAccountType,
  AccountType,
  FiscalPeriod,
  ReportingDate,
  concat((concat(concat(substring(ReportingDate, 7, 2), '/'),concat(substring(ReportingDate, 5, 2), '/'))), substring(ReportingDate, 1, 4)) AS DateFormat,
  PostingDate,
  DocumentDate,
  Material,
  DocumentItemText,
  QuantityUnit,
  UnitOfMeasureISOCode,
  OriginalReferenceDocument,
  BusinessArea,
  Supplier,
  Customer,
  BusinessPartnerName,
  TaxNumber1 AS TaxFilingNumber,
  TaxNumber2,
  TaxNumber3,
  VATRegistration,
  NationalIDNumber,
  MobileNumber,
  ProductDescription,
  CustomerSupplierAddress,
  SupplierAccountGroup,
  ReportingCountry,
  ReverseDocument,
  ReverseDocumentFiscalYear,
  InvoiceReference,
  InvoiceReferenceFiscalYear,
  ReferenceDocumentNumber,
  ReferenceDocumentFiscalYear,
  RefAccountingDocument,
  RefAccountingDocumentPostgDate,
  TaxInvoiceItemNetUnitPrice,
  DocumentCurrency,
  CompanyCodeCurrency,
  ReportingCurrency,
  CountryCurrency,
  AdditionalCurrency1,
  AdditionalCurrency2,
  DistributedTaxAmountInCCrcy,
  DistrdTaxBaseAmountInCCrcy,
  DistributedTaxAmountInTC,
  DistrdTaxBaseAmountInTransCrcy,
  DistributedTaxAmtInCountryCrcy,
  DistrdTaxBaseAmountInCntryCrcy,
  AmountInReportingCurrency,
  TaxBaseAmountInRptgCrcy,
  TaxAmountInRptgCrcy,
  TaxBaseAmountInCoCodeCrcy,
  TaxAmountInCoCodeCrcy,
  TaxBaseAmountInTransCrcy,
  TaxAmount,
  TaxBaseAmountInCountryCrcy,
  TaxAmountInCountryCrcy,
  TaxBaseAmtInAdditionalCrcy1,
  TaxAmountInAdditionalCurrency1,
  TaxBaseAmtInAdditionalCrcy2,
  TaxAmountInAdditionalCurrency2,
  (TaxBaseAmountInRptgCrcy + TaxAmountInRptgCrcy) AS GrossAmount,
  ItemIsReportingRelevant,
  CashDiscountBaseAmount,
  CashDiscountAmount,
  C_EG_StRpDocItmWthAdjustedGrpg.TaxRateValidityStartDate AS TaxRateValidityStartDate,
  C_EG_StRpDocItmWthAdjustedGrpg.TaxBoxStrucValidityStartDate AS TaxBoxStrucValidityStartDate,
  C_EG_StRpDocItmWthAdjustedGrpg.TaxBoxStrucValidityEndDate AS TaxBoxStrucValidityEndDate
FROM C_EG_StRpDocItmWthAdjustedGrpg
LEFT OUTER JOIN I_TaxGroupingText AS _TaxGroupName ON ReportingCountry = _TaxGroupName.Country AND TaxItemGroupingVersion = _TaxGroupName.TaxItemGroupingVersion AND TaxBox = _TaxGroupName.TaxBox  -- association [0..*]
;

Depth:

C_EG_StRpTaxDocItemCube view

C_EG_StRpDocItmWthAdjustedGrpg view

C_EG_StRpTaxDocItemQuery view