C_EG_StRpDocItmWthAdjustedGrpg

Tax Item With Adjustment Grouping for Statutory Reporting | view: CEGSRDOCITMAGRPG | Extraction: Not supported | Component: Financials Egypt
Tables used: VBAP, VBRK, VBRP, CFIN_AV_SO_BIZ, VBAK, VBAP, VBKD, VEDA, BKPF, BSEG, CFIN_AV_CI_ROOT, CFIN_AV_CI_ITEM, CFIN_AV_CI_ROOT, CFIN_AV_SO_ITEM, FIVATGENC_T007L, FIVATGENC_T007K, T006, T006A, T001, T014, T007L, T007K
Column Name Description
StatryRptgEntity Reporting Entity
StatryRptCategory Report Category ID
StatryRptRunID Report Run ID
CompanyCode Company Code
FiscalYear Fiscal Year
AccountingDocument Journal Entry
AccountingDocumentItem Journal Entry Posting View Item
DocumentItemNumber null
TaxCode Tax on Sales/Purchases Code
TransactionTypeDetermination Transaction Key
TaxItemGroupingVersion Grouping Version for Advance Return for Tax on Sales/Purch.
TaxBox Tax Box
Column Name Description
💲 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
💲 Currency Key (CountryCurrency):
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
TaxInvoiceItemNetUnitPrice 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
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
Material Material Number MATNR
DocumentItemText Item Text TEXT50
TaxRate TaxRate (Percentage)
OriginalReferenceDocument Reference Key AWKEY
BusinessArea Business Place J_1BBRANCH
Supplier Supplier LIFNR
Customer Customer Number KUNNR
TaxNumber1 Tax Number 1 STCD1
TaxNumber2 Tax Number 2 STCD2
TaxNumber3 Tax Number 3 CHAR18
BusinessPartnerName Business Partner Name TEXT80
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_STRPDOCITMWTHADJUSTEDGRPG.UNITOFMEASUREISOCODE == T006I.ISOCODE
  • C_EG_STRPDOCITMWTHADJUSTEDGRPG.MANDT == T006I.CLIENT