C_EG_StRpTaxDocItemCube

Egypt specific Tax Item Cube View for Statutory Reporting | view: CEGSRTAXDOCITEMC | TRAN | Extraction: Not supported | Component: Financials Egypt
Column Name Description
CompanyCode Company Code
FiscalYear Fiscal Year
AccountingDocument Journal Entry
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
💲 Currency Key (CountryCurrency):
TaxInvoiceItemNetUnitPrice null
DistributedTaxAmtInCountryCrcy Distributed Tax Amount in Local Currency
DistrdTaxBaseAmountInCntryCrcy Distributed Tax Base Amount in Local Currency
AmountInReportingCurrency null
TaxBaseAmountInRptgCrcy null
TaxAmountInRptgCrcy null
TaxBaseAmountInCountryCrcy null
TaxAmountInCountryCrcy null
GrossAmount null
💲 Company Code Currency (CompanyCodeCurrency):
DistributedTaxAmountInCCrcy Amount in Company Code Currency
DistrdTaxBaseAmountInCCrcy Distributed Tax Base Amount in Company Code Currency
TaxBaseAmountInCoCodeCrcy null
TaxAmountInCoCodeCrcy null
CashDiscountBaseAmount null
CashDiscountAmount Condition Value
💲 Currency Key (DocumentCurrency):
DistributedTaxAmountInTC Tax Base Amount in Local Currency
DistrdTaxBaseAmountInTransCrcy Distributed Tax Base Amount in Transaction Currency
TaxBaseAmountInTransCrcy null
TaxAmount null
💲 Additional Currency 1 (AdditionalCurrency1):
TaxBaseAmtInAdditionalCrcy1 null
TaxAmountInAdditionalCurrency1 null
💲 Additional Currency 2 (AdditionalCurrency2):
TaxBaseAmtInAdditionalCrcy2 null
TaxAmountInAdditionalCurrency2 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
EG_DocumentType null
EG_TaxType null
EG_ScheduleTaxType null
EG_DocumentItemNature null
EG_DocumentItemType null
TaxRate Character field 13 digits CHAR13
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
FinancialAccountType null
AccountType null
FiscalPeriod Fiscal Period POPER
DateFormat null
Material Material Number MATNR
DocumentItemText Item Text TEXT50
OriginalReferenceDocument Reference Key AWKEY
BusinessArea Business Place J_1BBRANCH
Supplier Supplier LIFNR
Customer Customer Number KUNNR
BusinessPartnerName null
TaxFilingNumber Tax Number 1 STCD1
VATRegistration Tax Number 2 STCD2
TaxNumber3 Tax Number 3 CHAR18
NationalIDNumber null
MobileNumber null
ProductDescription null
CustomerSupplierAddress Business Partner Address
SupplierAccountGroup Vendor account group KTOKK
ReportingCountry Country/Region for Tax Report LAND1
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
ItemIsReportingRelevant null
Master Data Relations Join Conditions
ISO code for unit of measurement
  • ISO code for unit of measurement
  • Client
  • C_EG_STRPTAXDOCITEMCUBE.UNITOFMEASUREISOCODE == T006I.ISOCODE
  • C_EG_STRPTAXDOCITEMCUBE.MANDT == T006I.CLIENT