C_RU_VATReturnMainSectionItemC

VAT Return Sections 1-7: Cube view | view: CRUVATRETMSIC | TRAN | Extraction: Not supported | Component: Financials Russia
Tables used: BKPF, BSE_CLR, FIRUD_ACCT_RPITM, FIRUD_VATREF, FIRUD_VAT_LTXT, BKPF, BSEG, BSET, T003, BUT000, DFKKBPTAXNUM, T001, TKA02, T005, FIRUD_VATITEMT, LFA1, CVI_VEND_LINK, T007A, T001, T014, ADRC, ADRP, FIRUD_VATSEC, FIRUD_VATVERS, FIRUD_VATSUBSC, FIRUD_EXT_NUM, FIRUD_VATSUBIT, T007K, T001Z, FINSC_FISC_DATE, FINSC_PERIOD, SRF_RPG_CAT4, J_3RVENDOKTMO, FIRUD_VATSUBAS
Column Name Description
Column Name Description
💲 Company Code Currency (CompanyCodeCurrency):
TaxBaseAmountInCoCodeCrcy Tax Base Amount in Company Code Currency
TaxAmountInCoCodeCrcy Tax Amount in Company Code Currency
Column Name Description
Column Name Description
PostingDate Posting Date
TaxReportingDate Tax Reporting Date
DocumentDate Journal Entry Date
InvoiceDate External Document Date
Column Name Description
IsReversal Indicator: Item is Reversing Another Item Show values
IsReversed Indicator: Item is Reversed Show values
RU_VATReturnSectionType VAT Return Section Type Show values
Column Name Description Domain name
AccountingDocument Document Number of an Accounting Document BELNR
FiscalYear Fiscal Year GJAHR
SourceDocument Original Document Number BELNR
SourceDocumentFiscalYear Original Document Fiscal Year GJAHR
ExternalInvoice External Number TEXT50
BusinessTransactionType Business Transaction Category FINS_BTTYPE
AccountingDocumentType Journal Entry Type BLART
Supplier Business Partner Number BU_PARTNER
SupplierName Business Partner Name J_3RF_TEXT255
RU_PartnerOrganizationINN Business Partner INN STCD1
RU_PartnerOrganizationKPP Business Partner KPP CHAR18
RU_PartnerPersonINN Business Partner INN (Person) STCD1
FirstName Business Partner First Name (Person) TEXT50
LastName Business Partner Last Name (Person) TEXT50
MiddleName Business Partner Middle Name (Person) TEXT50
RU_TerritoryClassfctnOKTMO null
VATReturnOperation Operation Code of VAT Return CHAR20
ExportInvcConfirmedFiscalYear Reporting Year
FiscalPeriod Tax period CIS
RU_VATReturnVersion VAT Return Version CHAR10
RU_VATReturnSection Section of VAT Return CHAR10
TaxBoxByTaxAuthority Number of VAT Return Line Item CHAR6
VATReturnItemDescription Description of VAT Return Line Item TEXT255
AuthorizationGroup Authorization Group BRGRU
StatryRptRunID Report Run ID SRF_REPORT_RUN_ID
Master Data Relations Join Conditions
Company Code
  • Company Code
  • Client
  • C_RU_VATRETURNMAINSECTIONITEMC.COMPANYCODE == T001.BUKRS
  • C_RU_VATRETURNMAINSECTIONITEMC.MANDT == T001.MANDT
VAT Scenario C_RU_VATRETURNMAINSECTIONITEMC.RU_VATSCENARIO == FIRUD_VATSCEN.SCENARIO
VAT Subscenario
  • ?
  • Client
  • VAT Subscenario
  • C_RU_VATRETURNMAINSECTIONITEMC.[column in domain "FIRU_VATSUBSV"] == FIRUD_VATSUBSC.VERS_SUBS
  • C_RU_VATRETURNMAINSECTIONITEMC.MANDT == FIRUD_VATSUBSC.MANDT
  • C_RU_VATRETURNMAINSECTIONITEMC.RU_VATSUBSCENARIO == FIRUD_VATSUBSC.SUBSCENARIO
VAT Subscenario Version
  • VAT Subscenario Version
  • Client
  • C_RU_VATRETURNMAINSECTIONITEMC.RU_VATSUBSCENARIOVERSION == FIRUD_VATSUBSV.VERS_SUBS
  • C_RU_VATRETURNMAINSECTIONITEMC.MANDT == FIRUD_VATSUBSV.MANDT
Reporting Entity
  • Client
  • Reporting Entity
  • C_RU_VATRETURNMAINSECTIONITEMC.MANDT == SRF_RPG_ENT.MANDT
  • C_RU_VATRETURNMAINSECTIONITEMC.STATRYRPTGENTITY == SRF_RPG_ENT.REPORTING_ENTITY
Tax on sales/purchases code
  • ?
  • Client
  • Tax on sales/purchases code
  • C_RU_VATRETURNMAINSECTIONITEMC.[column in domain "KALSM_D"] == T007A.KALSM
  • C_RU_VATRETURNMAINSECTIONITEMC.MANDT == T007A.MANDT
  • C_RU_VATRETURNMAINSECTIONITEMC.TAXCODE == T007A.MWSKZ