P_RU_VatSalesPurchaseLedgers4

S/P Ledgers: Revision through Reversal | view: PRUVATSPLD4 | Extraction: Not supported | Component: Financials Russia
Tables used: BKPF, EKKO, J_3RFGTD_HEADER, J_3RFGTD_ITEM, FIRUD_ACCT_RPITM, FIRUD_VATREF, FIRUD_VAT_LTXT, RBKP, RBKPB, BKPF, BSEG, RBDRSEG, RSEG, EKBE, EKBEH, BSET, T003, T001, TKA02, T163B, T001, T014, FIRUD_VATSEC, FIRUD_VATVERS, FIRUD_VATSUBSC, FIRUD_VATSET, FIRUD_EXT_NUM, FIRUD_VATSUBIT, T007K, FIRUD_VATSUBAS
Column Name Description
Column Name Description
TaxRate Tax Rate
TaxBaseSumHW Tax Base Amount in Local Currency
TaxBaseSumFW Tax Base Amount in Document Currency
TaxSumHW Tax Amount in Local Currency
TaxSumFW Tax Amount in Document Currency
Column Name Description
Column Name Description
PostingDate Posting Date
DocumentDate Journal Entry Date
TaxReportingDate Tax Reporting Date
ExternalAcctgDocumentDate null
OriginalInvoiceRevisionDate null
RevisionInvoiceDate null
RevisionTaxReportingDate null
Column Name Description
IsReversal Indicator: Item is Reversing Another Item Show values
IsReversed Indicator: Item is Reversed Show values
MatlRcptDateIsRead Date of Material Receipt Output Indicator Show values
RU_VATReturnSectionType VAT Return Section Type Show values
BusinessPartnerType Business Partner Show values
PaymentOrderOutputType Payment Order Show values
AgentType Business Partner (Agent) Show values
ImprtCstmsDeclnIsRead ImCD/RNPT Option Show values
ReverseDocsInCurPerdAreShown Reversals in Same Period Show values
Column Name Description Domain name
AccountingDocument Journal Entry BELNR
FiscalYear Fiscal Year GJAHR
ReverseDocument Reverse Document Number BELNR
ReverseDocumentFiscalYear Fiscal Year of Reversal Document GJAHR
OriginalReferenceDocument Object key AWKEY
ReferenceDocumentType Reference Document Type AWTYP
DocumentReferenceID Reference Document Number XBLNR1
BusinessTransactionType Business Transaction Category FINS_BTTYPE
RU_TxRateOutpColumn null
MatlRcptFinDateType null
MatlRcptMatlMgmtDateType null
RU_VATReturnSection Section of VAT Return CHAR10
RU_VATReturnVersion VAT Return Version CHAR10
SelectedDocument Document Number of an Accounting Document BELNR
VatInTransit null
VatInTransitBillingDocument null
OriginalDocument Original Document Number BELNR
OriginalDocumentYear Original Document Fiscal Year GJAHR
ExternalOriginalDocument null
ExternalOriginalDocCustomer Real Buyer for Commission Trade KUNNR
ExternalOriginalDocSupplier Real Seller for Commission Trade LIFNR
Invoice null
InvoiceYear null
CorrectionInvoice null
CorrectionInvoiceYear null
RevisionNumber null
RevisionInvoice null
RevisionInvoiceYear null
OriginalInvoiceRevisionNumber null
CompanyCodeName null
RU_CompanyCodeINN null
RU_CompanyCodeKPP null
BusinessPartnerName null
RU_PartnerOrganizationINN null
RU_PartnerOrganizationKPP null
RealPartnerName null
RealPartnerINN null
RealPartnerKPP null
ForeignPartnerName null
ForeignPartnerINN null
ForeignPartnerKPP null
LedgerLineSign Entry Number in Reporting
IsRevisionReversed null
ReferenceType null
ReferenceDocumentNumber null
ReferenceDocumentYear null
ImportCustomsDecln null
ActionRuleIsGenerated null
RevisionThroughReversal null
Master Data Relations Join Conditions
Company Code
  • Company Code
  • Client
  • P_RU_VATSALESPURCHASELEDGERS4.COMPANYCODE == T001.BUKRS
  • P_RU_VATSALESPURCHASELEDGERS4.MANDT == T001.MANDT
Currency Key
  • Currency Key
  • Client
  • P_RU_VATSALESPURCHASELEDGERS4.CURRENCY == TCURC.WAERS
  • P_RU_VATSALESPURCHASELEDGERS4.MANDT == TCURC.MANDT
Operation Type Code (Organization)
  • Operation Type Code (Organization)
  • Client
Operation Type Code (Person)
  • Operation Type Code (Person)
  • Client
  • P_RU_VATSALESPURCHASELEDGERS4.RU_PERSONOPERATIONTYPE == FIRUD_VATOPTYP.OPC_TYPE
  • P_RU_VATSALESPURCHASELEDGERS4.MANDT == FIRUD_VATOPTYP.MANDT
VAT Scenario P_RU_VATSALESPURCHASELEDGERS4.RU_VATSCENARIO == FIRUD_VATSCEN.SCENARIO
VAT Subscenario
  • VAT Subscenario
  • ?
  • Client
  • P_RU_VATSALESPURCHASELEDGERS4.RU_VATSUBSCENARIO == FIRUD_VATSUBSC.SUBSCENARIO
  • P_RU_VATSALESPURCHASELEDGERS4.[column in domain "FIRU_VATSUBSV"] == FIRUD_VATSUBSC.VERS_SUBS
  • P_RU_VATSALESPURCHASELEDGERS4.MANDT == FIRUD_VATSUBSC.MANDT
VAT Subscenario Version
  • VAT Subscenario Version
  • Client
  • P_RU_VATSALESPURCHASELEDGERS4.RU_VATSUBSCENARIOVERSION == FIRUD_VATSUBSV.VERS_SUBS
  • P_RU_VATSALESPURCHASELEDGERS4.MANDT == FIRUD_VATSUBSV.MANDT
Tax on sales/purchases code
  • Tax on sales/purchases code
  • ?
  • Client
  • P_RU_VATSALESPURCHASELEDGERS4.TAXCODE == T007A.MWSKZ
  • P_RU_VATSALESPURCHASELEDGERS4.[column in domain "KALSM_D"] == T007A.KALSM
  • P_RU_VATSALESPURCHASELEDGERS4.MANDT == T007A.MANDT