C_SupplierInvcVATReturnDocItem

To get details of SuppInv VAT ReturnDocs | view: CMMVATRETDOCITM | 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
FiscalYear Fiscal Year
AccountingDocument Journal Entry
SupplierInvoice Document Number of an Invoice Document
SupplierInvoiceItem Document Item in Invoice Document
TransactionTypeDetermination Transaction Key
TaxCode Tax on Sales/Purchases Code
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
FinancialAccountType Account Type Show values
AccountType Account Type Show values
DebitCreditCode Debit/Credit Code Show values
Column Name Description Domain name
DocumentItemNumber Document Item in Invoice Document NUMC6
AccountingDocumentItem Journal Entry Posting View Item BUZEI
OriginalReferenceDocument Reference Key AWKEY
AccountingDocumentType Journal Entry Type BLART
AccountingDocumentItemType Identification of the Line Item CHAR1
ReferenceDocumentType Reference procedure AWTYP
GLAccount G/L Account SAKNR
FiscalPeriod Fiscal Period POPER
Material Material Number MATNR
TaxRate TaxRate (Percentage)
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
Business Area
  • Client
  • Business Area
  • C_SUPPLIERINVCVATRETURNDOCITEM.MANDT == TGSB.MANDT
  • C_SUPPLIERINVCVATRETURNDOCITEM.BUSINESSAREA == TGSB.GSBER
Customer Number
  • Customer Number
  • Client
  • C_SUPPLIERINVCVATRETURNDOCITEM.CUSTOMER == KNA1.KUNNR
  • C_SUPPLIERINVCVATRETURNDOCITEM.MANDT == KNA1.MANDT
Supplier
  • Client
  • Supplier
  • C_SUPPLIERINVCVATRETURNDOCITEM.MANDT == LFA1.MANDT
  • C_SUPPLIERINVCVATRETURNDOCITEM.SUPPLIER == LFA1.LIFNR