C_EG_StRpTaxDocItemQuery

DDL: C_EG_STRPTAXDOCITEMQUERY SQL: CEGSRTAXDOCITMQ Type: view CONSUMPTION
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.

Data Sources (1)

SourceAliasJoin Type
C_EG_StRpTaxDocItemCube C_EG_StRpTaxDocItemCube from

Parameters (5)

NameTypeDefault
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 (10)

NameValueLevelField
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
AbapCatalog.preserveKey true view
EndUserText.label Tax Items for Statutory Reporting Egypt view

Fields (87)

KeyFieldSource TableSource FieldDescription
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
;

Learn More