P_RU_INVOICEJOURNAL6

InvJournal: Get Ext. Data, Partner and Agent (obsoleted) | view: PRUINVCJRNL6 | Extraction: Not supported | Component: Financials Russia
Tables used: BKPF, FIRUD_INVJ_LINK, FIRUD_ACCT_RPITM, FIRUD_VATREF, FIRUD_VAT_LTXT, BKPF, BSEG, BSET, T003, BUT000, DFKKBPTAXNUM, T001, TKA02, TCURC, TCURX, KNA1, CVI_CUST_LINK, J_3RJ_CURR_CONV, LFA1, CVI_VEND_LINK, T001, T014, ADRC, ADRP, FIRUD_VATSEC, FIRUD_VATVERS, FIRUD_VATSUBSC, FIRUD_EXT_NUM, FIRUD_VATSUBIT, T007K, FIRUD_VATSUBAS
Column Name Description
Column Name Description
TaxBaseAmountInTransCrcy Tax Base Amount in Document Currency
TaxAmount Tax Amount in Document Currency
TaxBaseAmountInCoCodeCrcy Tax Base Amount in Local Currency
TaxAmountInCoCodeCrcy Tax Amount in Local Currency
AmountInTransactionCurrency null
TaxAmountInTransCrcy Tax Amount in Local Currency
AmountDifferenceInTransCrcy null
TaxAmountDifferenceInTransCrcy null
Column Name Description
Column Name Description
PostingDate Posting Date
RU_RegistrationInvoiceDate null
OriginalInvoiceRevisionDate null
CorrectionInvoiceRevisionDate null
Column Name Description
RU_VATReturnSectionType VAT Return Section Type Show values
DebitCreditCode Debit/Credit Indicator Show values
RU_SupplierAgentOutputType Real Seller in Commission Trade Show values
RU_SupplierOutputType Seller(option) Show values
Column Name Description Domain name
AccountingDocument Journal Entry BELNR
FiscalYear Fiscal Year GJAHR
RU_VATSubScenario VAT Subscenario CHAR10
RU_VATReturnSection Section of VAT Return CHAR10
RU_VATReturnVersion VAT Return Version CHAR10
RU_VATSubScenarioVersion VAT Subscenario Version CHAR10
RU_VATScenario VAT Scenario CHAR10
CurrencyISOCode Currency ISO Code
ItemWithTax null
Invoice Original Invoice Number BELNR
InvoiceYear Original Invoice Year GJAHR
ExternalInvoice null
InvoiceDate null
CorrectionInvoice null
CorrectionInvoiceYear null
ExternalCorrectionInvoice null
CorrectionInvoiceDate null
RevisionNumber null
OriginalInvoiceRevisionNumber null
CorrectionInvoiceRevisionNmbr null
BusinessPartner null
BusinessPartnerName null
RU_PartnerOrganizationKPP Business Partner KPP CHAR18
RU_PartnerOrganizationINN null
BusinessPartnerCategory null
Agent null
AgentCategory null
AgentOrganizationName null
RU_AgentOrganizationINN null
RU_AgentOrganizationKPP Business Partner KPP CHAR18
AgentPersonSurname Business Partner Last Name (Person) TEXT50
AgentPersonName Business Partner First Name (Person) TEXT50
AgentPersonMiddleName Business Partner Middle Name (Person) TEXT50
IncomingInvoiceNumber Incoming Invoice Number for Commission Trade TEXT50
IncomingInvoiceDate null
SalesDealType null
Buyer null
Subagent null
Seller null
SellerAgent null
ActionRuleIsGenerated null
Master Data Relations Join Conditions
Company Code
  • Company Code
  • Client
  • P_RU_INVOICEJOURNAL6.COMPANYCODE == T001.BUKRS
  • P_RU_INVOICEJOURNAL6.MANDT == T001.MANDT
Currency Key
  • Client
  • Currency Key
  • P_RU_INVOICEJOURNAL6.MANDT == TCURC.MANDT
  • P_RU_INVOICEJOURNAL6.CURRENCY == TCURC.WAERS
Tax on sales/purchases code
  • Tax on sales/purchases code
  • ?
  • Client
  • P_RU_INVOICEJOURNAL6.TAXCODE == T007A.MWSKZ
  • P_RU_INVOICEJOURNAL6.[column in domain "KALSM_D"] == T007A.KALSM
  • P_RU_INVOICEJOURNAL6.MANDT == T007A.MANDT