P_RU_InvoiceJournal5

InvJournal: Get Ext. Data, Partner and Agent (obsoleted) | view: PRUINVCJRNL5 | Extraction: Not supported | Component: Financials Russia
Tables used: BKPF, FIRUD_INVJ_LINK, FIRUD_ACCT_RPITM, FIRUD_VATREF, FIRUD_VAT_LTXT, BKPF, BSEG, BSET, T003, T001, TKA02, TCURC, TCURX, T001, T014, FIRUD_VATSEC, FIRUD_VATVERS, FIRUD_VATSUBSC, FIRUD_EXT_NUM, FIRUD_VATSUBIT, T007K, FIRUD_VATSUBAS
Column Name Description
Column Name Description
TotalAmountInTransCrcy null
TotalAmountInCoCodeCrcy null
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
CommsnTradeInvoiceLinkedAmount Commission Trade Linked Amount
CommsnTradeInvcLinkedVATAmount Commission Trade Linked VAT
Column Name Description
Column Name Description
PostingDate Posting Date
RevisionInvoiceDate null
OriginalInvoiceRevisionDate null
RU_RegistrationInvoiceDate null
Column Name Description
RU_VATReturnSectionType VAT Return Section Type 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
DebitCreditCode Debit/Credit Indicator Show values
Column Name Description Domain name
AccountingDocument Journal Entry BELNR
FiscalYear Fiscal Year GJAHR
RU_VATReturnSection Section of VAT Return CHAR10
RU_VATReturnVersion VAT Return Version CHAR10
ItemWithTax null
AlternativeCurrencyKey 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
Buyer null
SellerAgent null
Seller null
Subagent null
SalesDealType null
IncomingInvoiceNumber Incoming Invoice Number for Commission Trade TEXT50
IncomingInvoiceDate null
BusinessPartnerName null
RU_PartnerOrganizationINN null
RU_PartnerOrganizationKPP null
RU_CommissionTradeCustomerName null
RU_CommissionTradeCustomerINN null
RU_CommissionTradeCustomerKPP null
RU_CommissionTradeSupplierName null
RU_CommissionTradeSupplierINN null
RU_CommissionTradeSupplierKPP null
IncInvBusinessPartnerName null
IncInvPartnerOrganizationINN null
IncInvPartnerOrganizationKPP null
ActionRuleIsGenerated null
Master Data Relations Join Conditions
Company Code
  • Company Code
  • Client
  • P_RU_INVOICEJOURNAL5.COMPANYCODE == T001.BUKRS
  • P_RU_INVOICEJOURNAL5.MANDT == T001.MANDT
Currency Key
  • Client
  • Currency Key
  • P_RU_INVOICEJOURNAL5.MANDT == TCURC.MANDT
  • P_RU_INVOICEJOURNAL5.CURRENCY == TCURC.WAERS
VAT Scenario P_RU_INVOICEJOURNAL5.RU_VATSCENARIO == FIRUD_VATSCEN.SCENARIO
VAT Subscenario
  • ?
  • VAT Subscenario
  • Client
VAT Subscenario Version
  • VAT Subscenario Version
  • Client
Tax on sales/purchases code
  • ?
  • Tax on sales/purchases code
  • Client
  • P_RU_INVOICEJOURNAL5.[column in domain "KALSM_D"] == T007A.KALSM
  • P_RU_INVOICEJOURNAL5.TAXCODE == T007A.MWSKZ
  • P_RU_INVOICEJOURNAL5.MANDT == T007A.MANDT