C_AccountingVATReturnDocItem

To get details of Acct VAT Return Docs | view: CACVATRETDOCITM | Extraction: Not supported | Component: Financials Arabic Emirates
Tables used: BSEGT001T014
Column Name Description
StatryRptgEntity Reporting Entity
StatryRptCategory Report Category ID
StatryRptRunID Report Run ID
CompanyCode Company Code
AccountingDocument Journal Entry
FiscalYear Fiscal Year
AccountingDocumentItem Journal Entry Posting View Item
Column Name Description
💲 Company Code Currency (CompanyCodeCurrency):
DistributedTaxAmountInCCrcy Amount in Company Code Currency
DistrdTaxBaseAmountInCCrcy Distributed Tax Base Amount in Company Code Currency
💲 Currency Key (DocumentCurrency):
DistributedTaxAmountInTC Tax Base Amount in Local Currency
DistrdTaxBaseAmountInTransCrcy Distributed Tax Base Amount in Transaction Currency
💲 Currency Key (CountryCurrency):
DistributedTaxAmtInCountryCrcy Distributed Tax Amount in Local Currency
DistrdTaxBaseAmountInCntryCrcy Distributed Tax Base Amount in Local Currency
💲 Additional Currency 1 (AdditionalCurrency1):
DistrdTaxAmountInAddlCrcy1 Tax Amount in Local Currency 2
DistrdTaxBaseAmountInAddlCrcy1 Tax Base Amount in Local Currency 2
💲 Additional Currency 2 (AdditionalCurrency2):
DistrdTaxAmountInAddlCrcy2 Tax Amount in Local Currency 3
DistrdTaxBaseAmountInAddlCrcy2 Tax Base Amount in Local Currency 3
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
Column Name Description
DebitCreditCode Debit/Credit Code Show values
Column Name Description Domain name
DocumentItemNumber null
TaxCode Tax on Sales/Purchases Code MWSKZ
TaxItemGroup Counter NUM03
AccountingDocumentType Journal Entry Type BLART
AccountingDocumentItemType Identification of the Line Item CHAR1
ReferenceDocumentType Reference procedure AWTYP
TransactionTypeDetermination Transaction Key CHAR3
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
SupplierAccountGroup Vendor account group KTOKK
ReportingCountry Country/Region for Tax Report LAND1
CompanyCodeCountry Country/Region Key LAND1
TaxNumber1 Tax Number 1 STCD1
TaxNumber2 Tax Number 2 STCD2
TaxNumber3 Tax Number 3 CHAR18
BusinessPartnerName Business Partner Name TEXT80
CustomerSupplierAddress Business Partner Address
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
Master Data Relations Join Conditions
Customer Number
  • Customer Number
  • Client
  • C_ACCOUNTINGVATRETURNDOCITEM.CUSTOMER == KNA1.KUNNR
  • C_ACCOUNTINGVATRETURNDOCITEM.MANDT == KNA1.MANDT
Supplier
  • Supplier
  • Client
  • C_ACCOUNTINGVATRETURNDOCITEM.SUPPLIER == LFA1.LIFNR
  • C_ACCOUNTINGVATRETURNDOCITEM.MANDT == LFA1.MANDT