P_RU_VATReturnSection12

VAT Return Sections 12 | view: PRUVATRET12 | Extraction: Not supported | Component: Financials Russia
Tables used: BKPF, BSE_CLR, FIRUD_ACCT_RPITM, FIRUD_VAT_LTXT, BKPF, BSEG, BSET, T003, BUT000, DFKKBPTAXNUM, T001, TKA02, T005, KNA1, CVI_CUST_LINK, J_3RJ_CURR_CONV, T007A, T001, T014, ADRC, ADRP, FIRUD_VATSEC, FIRUD_VATVERS, FIRUD_VATSUBSC, FIRUD_EXT_NUM, T001Z, FIRUD_VATSUBAS
Column Name Description
Column Name Description
TotalAmountInTransactionCrcy null
TotalAmountInCoCodeCrcy Total Amount In Company Code Currency
TaxAmountInTransCrcy null
TaxAmountInCoCodeCrcy null
TaxBaseAmountInTransCrcy null
TaxBaseAmountInCoCodeCrcy null
TxBaseAmtWithTxRate0InCCCrcy Tax Base Amount with Tax Rate 0% in Company Code Currency
TxBaseAmtWithTxRate10InCCCrcy Tax Base Amount with Tax Rate 10% in Company Code Currency
TxBaseAmtWithTxRate18InCCCrcy Tax Base Amount with Tax Rate 18% in Company Code Currency
TxBaseAmtWithTxRate20InCCCrcy Tax Base Amount with Tax Rate 20% in Company Code Currency
BaseAmtWithoutTxInCCCrcy Base Amount without Tax in Company Code Currency
TxAmtWithTxRate10InCCCrcy Tax Amount with Tax Rate 10% in Company Code Currency
TxAmtWithTxRate18InCCCrcy Tax Amount with Tax Rate 18% in Company Code Currency
TxAmtWithTxRate20InCCCrcy Tax Amount with Tax Rate 20% in Company Code Currency
CommsnTradeInvoiceLinkedAmount Commission Trade Linked Amount
CommsnTradeInvcLinkedVATAmount Commission Trade Linked VAT
OriginalAmountInTransacCrcy Amount Original In Transaction Currency
OriginalTaxAmountInTransacCrcy Tax Amount Original In Transaction Currency
DifferenceAmtInTransCrcy Amount Difference In Transaction Currency
DifferenceTaxAmtInTransCrcy Tax Amount Difference In Transaction Currency
Column Name Description
Column Name Description
InvoiceDate External Document Date
OriginalInvoiceRevisionDate Revision Date of Original Inv.in Corrective Inv.
CorrectionInvoiceDate Date of Corrective VAT Invoice
CorrectionInvoiceRevisionDate Revision Date of Correction
TaxReportingDate Tax Reporting Date
RU_IncomingInvoiceDate Incoming Invoice External Document Date
Column Name Description
RU_VATReturnSectionType VAT Return Section Type Show values
IsReversal Indicator: Item is Reversing Another Item Show values
IsReversed Indicator: Item is Reversed Show values
RU_InvoiceType Invoice Type Show values
Sign +/- Sign Show values
BusinessPartnerIsOrganization Indicator if Business Partner is an Organization Show values
BusinessPartnerIsNaturalPerson Business Partner Is a Natural Person Under the Tax Laws Show values
AgentIsOrganization Indicator if Agent is an Organization Show values
RU_IncomingInvoiceType Incoming Invoice Type Show values
SalesDealType Deal Type in Commission Trade Show values
Column Name Description Domain name
AccountingDocument Document Number of an Accounting Document BELNR
FiscalYear Fiscal Year GJAHR
TaxItem Number of Line Item Within Accounting Document BUZEI
OriginalDocument Original Document Number BELNR
OriginalDocumentYear Original Document Fiscal Year GJAHR
RevisionNumber Revision Number NUM03
Invoice Original Invoice Number BELNR
InvoiceYear Original Invoice Year GJAHR
ExternalInvoice External Number TEXT50
RevisionInvoice Revision Invoice Number BELNR
RevisionInvoiceYear Revision Invoice Year GJAHR
OriginalInvoiceRevisionNumber Revision Number of Original Inv.in Corrective Inv. NUM03
CorrectionInvoice Corrective Invoice Number BELNR
CorrectionInvoiceYear Corrective Invoice Year GJAHR
ExternalCorrectionInvoice External Number of Corrective VAT Invoice TEXT50
CorrectionInvoiceRevisionNmbr Number of Revision of Correction NUM03
TaxItemGroupingVersion Grouping Version for Advance Return for Tax on Sales/Purch. CHAR4
CurrencyISOCode Currency ISO Code
BusinessPartner Business Partner Number BU_PARTNER
BusinessPartnerName 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
BusinessPartnerCountry Business Partner Country/Region Key LAND1
Agent Agent ID CHAR10
AgentOrganizationName Agent Name J_3RF_TEXT255
RU_AgentOrganizationINN Agent INN STCD1
RU_AgentOrganizationKPP Agent KPP CHAR18
RU_AgentPersonINN Agent INN (Person) STCD1
AgentPersonSurname Agent Last Name (Person) TEXT50
AgentPersonName Agent First Name (Person) TEXT50
AgentPersonMiddleName Agent Middle Name (Person) TEXT50
RU_IncomingInvoiceCompanyCode Incoming Company Code BUKRS
RU_IncomingInvoiceNumber Incoming Original Invoice Number BELNR
RU_IncomingInvoiceFiscalYear Incoming Original Invoice Year GJAHR
IncomingCorrectionInvoice Incoming Corrective Invoice Number BELNR
IncomingCorrectionInvoiceYear Incoming Corrective Invoice Year GJAHR
IncomingRevisionNumber Incoming Revision Number NUM03
IncomingExternalInvoice Incoming Invoice External Number TEXT50
IncgInvoiceTransCrcyISOCode Incoming Invoice Currency ISO Code
RU_VATOperationType Operation Type Code CHAR2
RU_TerritoryClassfctnOKTMO null
VATReturnOperation null
ExportInvcConfirmedFiscalYear null
FiscalPeriod null
RU_VATReturnSection Section of VAT Return CHAR10
RU_VATReturnLine Number of VAT Return Line Item CHAR6
RU_VATReturnVersion VAT Return Version CHAR10
StatryRptRunID Report Run ID SRF_REPORT_RUN_ID
Master Data Relations Join Conditions
Company Code
  • Company Code
  • Client
  • P_RU_VATRETURNSECTION12.COMPANYCODE == T001.BUKRS
  • P_RU_VATRETURNSECTION12.MANDT == T001.MANDT
Currency Key
  • Currency Key
  • Client
  • P_RU_VATRETURNSECTION12.CURRENCY == TCURC.WAERS
  • P_RU_VATRETURNSECTION12.MANDT == TCURC.MANDT
VAT Scenario P_RU_VATRETURNSECTION12.RU_VATSCENARIO == FIRUD_VATSCEN.SCENARIO
VAT Subscenario
  • ?
  • VAT Subscenario
  • Client
  • P_RU_VATRETURNSECTION12.[column in domain "FIRU_VATSUBSV"] == FIRUD_VATSUBSC.VERS_SUBS
  • P_RU_VATRETURNSECTION12.RU_VATSUBSCENARIO == FIRUD_VATSUBSC.SUBSCENARIO
  • P_RU_VATRETURNSECTION12.MANDT == FIRUD_VATSUBSC.MANDT
VAT Subscenario Version
  • VAT Subscenario Version
  • Client
Reporting Entity
  • Client
  • Reporting Entity
  • P_RU_VATRETURNSECTION12.MANDT == SRF_RPG_ENT.MANDT
  • P_RU_VATRETURNSECTION12.STATRYRPTGENTITY == SRF_RPG_ENT.REPORTING_ENTITY
Tax on sales/purchases code
  • ?
  • Tax on sales/purchases code
  • Client
  • P_RU_VATRETURNSECTION12.[column in domain "KALSM_D"] == T007A.KALSM
  • P_RU_VATRETURNSECTION12.TAXCODE == T007A.MWSKZ
  • P_RU_VATRETURNSECTION12.MANDT == T007A.MANDT