P_RU_VatSalesPurchaseLedgers5

S/P Ledgers: Reversal Processing | view: PRUVATSPLD5 | 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, T005, T163B, T007A, T001, T014, FIRUD_VATSEC, FIRUD_VATVERS, FIRUD_VATSUBSC, FIRUD_VATSET, FIRUD_EXT_NUM, FIRUD_VATSUBIT, T007K, T001Z, FIRUD_VATSUBAS
Column Name Description
Column Name Description
AmountInCompanyCodeCurrency null
TaxAmountInCoCodeCrcy null
AmountInTransactionCurrency null
TaxAmountInTransCrcy null
TxBaseAmtWithTxRate0InCCCrcy null
TxBaseAmtWithTxRate10InCCCrcy null
TxBaseAmtWithTxRate18InCCCrcy null
TxAmtWithTxRate10InCCCrcy null
TxAmtWithTxRate18InCCCrcy null
BaseAmtWithoutTxInCCCrcy null
Column Name Description
Column Name Description
PostingDate null
TaxReportingDate null
DocumentDate Journal Entry Date
ExternalAcctgDocumentDate null
RevisionInvoiceDate null
OriginalInvoiceRevisionDate null
Column Name Description
RU_VATReturnSectionType VAT Return Section Type Show values
BusinessPartnerType Business Partner Show values
PaymentOrderOutputType Payment Order Show values
MatlRcptDateIsRead Date of Material Receipt Output Indicator Show values
AgentType Business Partner (Agent) Show values
ImprtCstmsDeclnIsRead ImCD/RNPT Option Show values
IsReversal Indicator: Item is Reversing Another Item Show values
IsReversed Indicator: Item is Reversed Show values
Column Name Description Domain name
AccountingDocument Journal Entry BELNR
FiscalYear Fiscal Year GJAHR
DocumentReferenceID Reference Document Number XBLNR1
RU_VATReturnVersion VAT Return Version CHAR10
MatlRcptFinDateType null
MatlRcptMatlMgmtDateType null
ReferenceDocumentType Reference Document Type AWTYP
OriginalReferenceDocument Object key AWKEY
RU_TxRateOutpColumn null
VatInTransit 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
ItemWithTax null
InvoiceSupplier null
InvoiceCustomer null
VatInTransitBillingDocument null
ReversedDocument Journal Entry BELNR
ReversedDocumentFiscalYear Fiscal Year GJAHR
ReferenceDocumentNumber null
ImportCustomsDecln null
ForeignPartnerSupplier null
ActionRuleIsGenerated null
Master Data Relations Join Conditions
Company Code
  • Client
  • Company Code
  • P_RU_VATSALESPURCHASELEDGERS5.MANDT == T001.MANDT
  • P_RU_VATSALESPURCHASELEDGERS5.COMPANYCODE == T001.BUKRS
Currency Key
  • Client
  • Currency Key
  • P_RU_VATSALESPURCHASELEDGERS5.MANDT == TCURC.MANDT
  • P_RU_VATSALESPURCHASELEDGERS5.CURRENCY == TCURC.WAERS
Operation Type Code (Organization)
  • Client
  • Operation Type Code (Organization)
Operation Type Code (Person)
  • Client
  • Operation Type Code (Person)
  • P_RU_VATSALESPURCHASELEDGERS5.MANDT == FIRUD_VATOPTYP.MANDT
  • P_RU_VATSALESPURCHASELEDGERS5.RU_PERSONOPERATIONTYPE == FIRUD_VATOPTYP.OPC_TYPE
VAT Scenario P_RU_VATSALESPURCHASELEDGERS5.RU_VATSCENARIO == FIRUD_VATSCEN.SCENARIO
VAT Subscenario
  • Client
  • ?
  • VAT Subscenario
  • P_RU_VATSALESPURCHASELEDGERS5.MANDT == FIRUD_VATSUBSC.MANDT
  • P_RU_VATSALESPURCHASELEDGERS5.[column in domain "FIRU_VATSUBSV"] == FIRUD_VATSUBSC.VERS_SUBS
  • P_RU_VATSALESPURCHASELEDGERS5.RU_VATSUBSCENARIO == FIRUD_VATSUBSC.SUBSCENARIO
VAT Subscenario Version
  • Client
  • VAT Subscenario Version
  • P_RU_VATSALESPURCHASELEDGERS5.MANDT == FIRUD_VATSUBSV.MANDT
  • P_RU_VATSALESPURCHASELEDGERS5.RU_VATSUBSCENARIOVERSION == FIRUD_VATSUBSV.VERS_SUBS
Tax on sales/purchases code
  • ?
  • Client
  • Tax on sales/purchases code
  • P_RU_VATSALESPURCHASELEDGERS5.[column in domain "KALSM_D"] == T007A.KALSM
  • P_RU_VATSALESPURCHASELEDGERS5.MANDT == T007A.MANDT
  • P_RU_VATSALESPURCHASELEDGERS5.TAXCODE == T007A.MWSKZ