C_EG_StRpTaxDocItemQuery

Tax Items for Statutory Reporting Egypt | view: CEGSRTAXDOCITMQ | Extraction: Not supported | Component: Financials Egypt
Column Name Description
CompanyCode Company Code
AccountingDocument Journal Entry
FiscalYear Fiscal Year
AccountingDocumentItem Journal Entry Posting View Item
DocumentItemNumber null
StatryRptgEntity Reporting Entity
StatryRptCategory Report Category ID
StatryRptRunID Report Run ID
TaxCode Tax on Sales/Purchases Code
TransactionTypeDetermination Transaction Key
TaxBox Tax Box
TaxItemGroupingVersion Grouping Version for Advance Return for Tax on Sales/Purch.
Column Name Description
💲 Additional Currency 2 (AdditionalCurrency2):
TaxBaseAmountInRptgCrcy null
TaxBaseAmtInAdditionalCrcy2 null
TaxAmountInAdditionalCurrency2 null
💲 Currency Key (CountryCurrency):
TaxAmountInRptgCrcy null
GrossAmount null
TaxInvoiceItemNetUnitPrice null
💲 Company Code Currency (CompanyCodeCurrency):
TaxBaseAmountInCoCodeCrcy null
TaxAmountInCoCodeCrcy null
CashDiscountBaseAmount null
CashDiscountAmount Condition Value
💲 Currency Key (DocumentCurrency):
TaxBaseAmountInTransCrcy null
TaxAmount null
💲 Additional Currency 1 (AdditionalCurrency1):
TaxBaseAmtInAdditionalCrcy1 null
TaxAmountInAdditionalCurrency1 null
Column Name Description
📏 Base Unit of Measure (QuantityUnit):
QuantityInActlPostg Quantity
Column Name Description
ReportingDate Posting Date in the Document
PostingDate Posting Date
DocumentDate Journal Entry Date
RefAccountingDocumentPostgDate null
Column Name Description
TaxDeclnAmountType Amount Type for Statutory Reporting Show values
DebitCreditCode Debit/Credit Code Show values
Column Name Description Domain name
TaxGroupName Tax Box text TEXT200
FinancialAccountType null
AccountType null
EG_DocumentType null
EG_TaxType null
EG_ScheduleTaxType null
EG_DocumentItemNature null
EG_DocumentItemType null
VATRegistration Tax Number 2 STCD2
TaxFilingNumber Tax Number 1 STCD1
NationalIDNumber null
MobileNumber null
Supplier Supplier LIFNR
Customer Customer Number KUNNR
BusinessPartnerName null
CustomerSupplierAddress Business Partner Address
SupplierAccountGroup Vendor account group KTOKK
Material Material Number MATNR
ProductDescription null
TaxRate Character field 13 digits CHAR13
ReportingCountry Country/Region for Tax Report LAND1
DateFormat null
FiscalPeriod Fiscal Period POPER
SupplierInvoice Document Number of an Invoice Document BELNR
SupplierInvoiceItem Document Item in Invoice Document NUMC6
BillingDocument Document Number of an Invoice Document BELNR
BillingDocumentItem Billing Item POSNR
TaxItemGroup Counter NUM03
AccountingDocumentType Journal Entry Type BLART
AccountingDocumentItemType Identification of the Line Item CHAR1
ReferenceDocumentType Reference procedure AWTYP
PostingKey Posting Key BSCHL
GLAccount G/L Account SAKNR
OriginalReferenceDocument Reference Key AWKEY
BusinessArea Business Place J_1BBRANCH
ReverseDocument Reverse Document Number BELNR
ReverseDocumentFiscalYear Fiscal Year of Reversal Document GJAHR
InvoiceReference Invoice Reference BELNR
InvoiceReferenceFiscalYear Invoice Reference Fiscal Year GJAHR
ReferenceDocumentNumber null
ReferenceDocumentFiscalYear null
RefAccountingDocument null
Master Data Relations Join Conditions
ISO code for unit of measurement
  • Client
  • ISO code for unit of measurement
  • C_EG_STRPTAXDOCITEMQUERY.MANDT == T006I.CLIENT
  • C_EG_STRPTAXDOCITEMQUERY.UNITOFMEASURE == T006I.ISOCODE