P_RU_VatSalesPurchaseLedgers6

S/P Ledgers: Business Partner Determination | view: PRUVATSPLD6 | Extraction: Not supported | Component: Financials Russia
Tables used: BKPF, VBRK, 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, TCURC, TCURX, T163B, J_3RJ_CURR_CONV, 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
AmountInTransactionCurrency null
AmountInCompanyCodeCurrency null
TaxAmountInCoCodeCrcy null
TxBaseAmtWithTxRate0InCCCrcy null
TxBaseAmtWithTxRate10InCCCrcy null
TxBaseAmtWithTxRate18InCCCrcy null
BaseAmtWithoutTxInCCCrcy null
TxAmtWithTxRate10InCCCrcy null
TxAmtWithTxRate18InCCCrcy null
Column Name Description
Column Name Description
SourceDocumentDate null
OriginalInvoiceRevisionDate null
CorrectionInvoiceRevisionDate null
TaxReportingDate null
PostingDate null
DocumentDate Journal Entry Date
CorrectionInvoiceDate External Document Date
Column Name Description
MatlRcptDateIsRead Date of Material Receipt Output Indicator Show values
PaymentOrderOutputType Payment Order Show values
ImprtCstmsDeclnIsRead ImCD/RNPT Option Show values
BusinessPartnerType Business Partner Show values
AgentType Business Partner (Agent) Show values
RU_VATReturnSectionType VAT Return Section Type Show values
Column Name Description Domain name
FiscalYear Fiscal Year GJAHR
AccountingDocument Journal Entry BELNR
RU_VATSubScenario VAT Subscenario CHAR10
RU_VATScenario VAT Scenario CHAR10
RU_VATSubScenarioVersion VAT Subscenario Version CHAR10
RU_VATReturnVersion VAT Return Version CHAR10
MatlRcptFinDateType null
MatlRcptMatlMgmtDateType null
ReferenceDocumentType Reference Document Type AWTYP
OriginalReferenceDocument Object key AWKEY
SourceDocument null
SourceDocumentFiscalYear Original Document Fiscal Year GJAHR
Invoice null
InvoiceYear null
CorrectionInvoice null
CorrectionInvoiceYear null
RevisionNumber null
RevisionInvoice null
RevisionInvoiceYear null
OriginalInvoiceRevisionNumber null
CorrectionInvoiceRevisionNmbr null
CompanyCodeName null
RU_CompanyCodeINN null
RU_CompanyCodeKPP null
BusinessPartnerName null
RU_PartnerOrganizationINN null
PartnerINN_length null
RU_PartnerOrganizationKPP null
RealPartnerName null
RealPartnerINN null
RealPartnerINN_length null
RealPartnerKPP null
ForeignPartnerName null
ForeignPartnerINN null
ForeignPartnerINN_length null
ForeignPartnerKPP null
LedgerLineSign Entry Number in Reporting
RU_OrgOperationType Operation Type Code (Organization) FIRU_VATOPTYPE
RU_PersonOperationType Operation Type Code (Person) FIRU_VATOPTYPE
ExternalInvoice null
InvoiceDate null
ExternalCorrectionInvoice External Number TEXT50
TaxInvoiceNumber Journal Entry BELNR
AlternativeCurrencyKey null
CurrencyISOCode Currency ISO Code
ItemWithTax null
AgentCustomer null
AgentSupplier null
PartnerCustomer Sold-to Party KUNNR
PartnerSupplier null
PartnerCC Company Code BUKRS
ActionRuleIsGenerated null
Master Data Relations Join Conditions
Company Code
  • Client
  • Company Code
  • P_RU_VATSALESPURCHASELEDGERS6.MANDT == T001.MANDT
  • P_RU_VATSALESPURCHASELEDGERS6.COMPANYCODE == T001.BUKRS
Currency Key
  • Client
  • Currency Key
  • P_RU_VATSALESPURCHASELEDGERS6.MANDT == TCURC.MANDT
  • P_RU_VATSALESPURCHASELEDGERS6.CURRENCY == TCURC.WAERS
Tax on sales/purchases code
  • Client
  • Tax on sales/purchases code
  • ?
  • P_RU_VATSALESPURCHASELEDGERS6.MANDT == T007A.MANDT
  • P_RU_VATSALESPURCHASELEDGERS6.TAXCODE == T007A.MWSKZ
  • P_RU_VATSALESPURCHASELEDGERS6.[column in domain "KALSM_D"] == T007A.KALSM