P_RU_VATSPLedgersJournal2

SPLedgers/Journal: Correction and Revision Processing-2, Ext | view: PRUVATSPLDJ2 | Extraction: Not supported | Component: Financials Russia
Tables used: BKPF, BSE_CLR, FIRUD_ACCT_RPITM, FIRUD_VATREF, FIRUD_VAT_LTXT, BKPF, BSEG, BSET, T003, T001, TKA02, T005, T007A, T001, T014, FIRUD_VATSEC, FIRUD_VATVERS, FIRUD_VATSUBSC, FIRUD_VATSET, FIRUD_EXT_NUM, T001Z, FIRUD_VATSUBAS
Column Name Description
Column Name Description
TaxRate Tax Rate
AmountInCompanyCodeCurrency null
TaxBaseAmountInCoCodeCrcy null
TaxAmountInCoCodeCrcy null
AmountInTransactionCurrency null
TaxBaseAmountInTransCrcy null
TaxAmount null
Column Name Description
Column Name Description
PostingDate Posting Date
TaxReportingDate Tax Reporting Date
DocumentDate Journal Entry Date
InvoiceDate External Document Date
OriginalInvoiceRevisionDate Revision Date of Original Inv.in Corrective Inv.
CorrectionInvoiceDate Date of Corrective VAT Invoice
CorrectionInvoiceRevisionDate Revision Date of Correction
RevisionInvoiceDate Revision Date
Column Name Description
IsReversal Indicator: Item is Reversing Another Item Show values
IsReversed Indicator: Item is Reversed Show values
IsNegativePosting Is Negative Posting Show values
DebitCreditCode Debit/Credit Indicator Show values
RU_VATReturnSectionType VAT Return Section Type Show values
RU_TotalAmountCalcType Total Amount Source Show values
RU_TaxBaseAmountCalcType VAT Base Source Show values
BusinessPartnerType Business Partner Show values
AgentType Business Partner (Agent) Show values
PaymentOrderOutputType Payment Order Show values
ImprtCstmsDeclnIsRead ImCD/RNPT Option Show values
MatlRcptDateIsRead Date of Material Receipt Output Indicator Show values
RU_CustomerOutputType Real Buyer in Commission Trade Show values
RU_SupplierAgentOutputType Real Seller in Commission Trade Show values
RU_SupplierOutputType Seller(option) Show values
RU_SubagentOutputType Subagent in Commission Trade 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
OriginalReferenceDocument Object key AWKEY
ReferenceDocumentType Reference Document Type AWTYP
BusinessTransactionType Business Transaction Category FINS_BTTYPE
SenderLogicalSystem Sender Logical System LOGSYS
Invoice null
InvoiceYear null
ExternalInvoice External Number TEXT50
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
RevisionInvoice Revision Invoice Number BELNR
RevisionInvoiceYear Revision Invoice Year GJAHR
CorRev_CompanyCodeName Company Code Name J_3RF_TEXT255
CorRev_CompanyCodeINN Company Code INN STCD1
CorRev_CompanyCodeKPP Company Code KPP STCD3
CorRev_BusinessPartnerName Business Partner Name J_3RF_TEXT255
CorRev_BusinessPartnerINN Business Partner INN STCD1
CorRev_BusinessPartnerKPP Business Partner KPP CHAR18
CorRev_BusinessPartnerIsOrg null
CorRev_BusinessPartnerIsNP null
CorRev_SupplierName Foreign Partner Name J_3RF_TEXT255
CorRev_SupplierINN Foreign Partner INN STCD1
CorRev_SupplierKPP Foreign Partner KPP CHAR18
CorRev_SupplierIsOrg null
CorRev_SupplierIsNP null
CorRev_CommisTradeSupplierName Real Seller Name J_3RF_TEXT255
CorRev_CommisTradeSupplierINN Real Seller INN STCD1
CorRev_CommisTradeSupplierKPP Real Seller KPP CHAR18
CorRev_CommisTradeSupplIsOrg null
CorRev_CommisTradeSupplIsNP null
CorRev_CommisTradeCustomerName Real Buyer Name J_3RF_TEXT255
CorRev_CommisTradeCustomerINN Real Buyer INN STCD1
CorRev_CommisTradeCustomerKPP Real Buyer KPP CHAR18
CorRev_CommisTradeCustIsOrg null
CorRev_CommisTradeCustIsNP null
LedgerLineSign null
IsRevisionReversed null
IsLastDocumentCorRevChain null
RU_VATReturnVersion VAT Return Version CHAR10
RU_VATReturnSection Section of VAT Return CHAR10
RU_VATReturnLine Number of VAT Return Line Item CHAR6
SourceDocument Original Document Number BELNR
SourceDocumentFiscalYear Original Document Fiscal Year GJAHR
RevisionNumber Revision Number NUM03
StatryRptRunID Report Run ID SRF_REPORT_RUN_ID
Master Data Relations Join Conditions
Journal Entry Type
  • Client
  • Journal Entry Type
  • P_RU_VATSPLEDGERSJOURNAL2.MANDT == T003.MANDT
  • P_RU_VATSPLEDGERSJOURNAL2.ACCOUNTINGDOCUMENTTYPE == T003.BLART
Company Code
  • Company Code
  • Client
  • P_RU_VATSPLEDGERSJOURNAL2.COMPANYCODE == T001.BUKRS
  • P_RU_VATSPLEDGERSJOURNAL2.MANDT == T001.MANDT
Currency Key
  • Client
  • Currency Key
  • P_RU_VATSPLEDGERSJOURNAL2.MANDT == TCURC.MANDT
  • P_RU_VATSPLEDGERSJOURNAL2.CURRENCY == TCURC.WAERS
Operation Type Code (Organization)
  • Client
  • Operation Type Code (Organization)
Operation Type Code (Person)
  • Client
  • Operation Type Code (Person)
VAT Scenario P_RU_VATSPLEDGERSJOURNAL2.RU_VATSCENARIO == FIRUD_VATSCEN.SCENARIO
VAT Subscenario
  • ?
  • Client
  • VAT Subscenario
  • P_RU_VATSPLEDGERSJOURNAL2.[column in domain "FIRU_VATSUBSV"] == FIRUD_VATSUBSC.VERS_SUBS
  • P_RU_VATSPLEDGERSJOURNAL2.MANDT == FIRUD_VATSUBSC.MANDT
  • P_RU_VATSPLEDGERSJOURNAL2.RU_VATSUBSCENARIO == FIRUD_VATSUBSC.SUBSCENARIO
VAT Subscenario Version
  • Client
  • VAT Subscenario Version
Reporting Entity
  • Client
  • Reporting Entity
  • P_RU_VATSPLEDGERSJOURNAL2.MANDT == SRF_RPG_ENT.MANDT
  • P_RU_VATSPLEDGERSJOURNAL2.STATRYRPTGENTITY == SRF_RPG_ENT.REPORTING_ENTITY
Tax on sales/purchases code
  • Client
  • Tax on sales/purchases code
  • ?
  • P_RU_VATSPLEDGERSJOURNAL2.MANDT == T007A.MANDT
  • P_RU_VATSPLEDGERSJOURNAL2.TAXCODE == T007A.MWSKZ
  • P_RU_VATSPLEDGERSJOURNAL2.[column in domain "KALSM_D"] == T007A.KALSM