P_RU_VatSalesPurchaseLedgers7

Column Name Description
Column Name Description
TaxAmountInCoCodeCrcy null
AmountInTransactionCurrency null
AmountInCompanyCodeCurrency null
TxBaseAmtWithTxRate0InCCCrcy null
TxBaseAmtWithTxRate10InCCCrcy null
TxBaseAmtWithTxRate18InCCCrcy null
BaseAmtWithoutTxInCCCrcy null
TxAmtWithTxRate10InCCCrcy null
TxAmtWithTxRate18InCCCrcy null
Column Name Description
Column Name Description
OriginalInvoiceRevisionDate null
CorrectionInvoiceRevisionDate null
TaxReportingDate null
PostingDate null
DocumentDate Journal Entry Date
CorrectionInvoiceDate External Document Date
SourceDocumentDate External Document Date
Column Name Description
RU_VATReturnSectionType VAT Return Section Type Show values
MatlRcptDateIsRead Date of Material Receipt Output Indicator Show values
PaymentOrderOutputType Payment Order Show values
ImprtCstmsDeclnIsRead ImCD/RNPT Option Show values
BusinessPartnerCategory Business Partner Category Show values
BusinessPartnerType Business Partner 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
OriginalInvoiceRevisionNumber null
CorrectionInvoiceRevisionNmbr null
ExternalInvoice null
InvoiceDate null
ExternalCorrectionInvoice External Number TEXT50
TaxInvoiceNumber Journal Entry BELNR
SourceDocument null
SourceDocumentFiscalYear Original Document Fiscal Year GJAHR
Invoice null
InvoiceYear null
CurrencyISOCode Currency ISO Code
ItemWithTax null
PartnerCustomer Sold-to Party KUNNR
PartnerSupplier null
PartnerCC Company Code BUKRS
AgentCustomer null
AgentSupplier null
BusinessPartner null
BusinessPartnerIsOrganization null
BusinessPartnerName null
RU_PartnerOrganizationKPP Parameter value TEXT48
RU_PartnerOrganizationINN Parameter value TEXT48
INN null
PartnerINN_length null
SupplierINN Business Partner INN STCD1
CustomerINN Business Partner INN STCD1
RU_PartnerPersonINN Business Partner INN (Person) STCD1
AgentOrganizationName null
RU_AgentOrganizationINN Business Partner INN STCD1
RU_AgentOrganizationKPP Business Partner KPP CHAR18
RU_AgentPersonINN Business Partner INN (Person) STCD1
AgentPersonSurname Business Partner Last Name (Person) TEXT50
AgentPersonName Business Partner First Name (Person) TEXT50
AgentPersonMiddleName Business Partner Middle Name (Person) TEXT50
LedgerLineSign Entry Number in Reporting
StatryRptgEntity null
StatryRptCategory null
StatryRptRunID null
RU_OrgOperationType Operation Type Code (Organization) FIRU_VATOPTYPE
ActionRuleIsGenerated null
Master Data Relations Join Conditions
Company Code
  • Company Code
  • Client
  • P_RU_VATSALESPURCHASELEDGERS7.COMPANYCODE == T001.BUKRS
  • P_RU_VATSALESPURCHASELEDGERS7.MANDT == T001.MANDT
Currency Key
  • Currency Key
  • Client
  • P_RU_VATSALESPURCHASELEDGERS7.CURRENCY == TCURC.WAERS
  • P_RU_VATSALESPURCHASELEDGERS7.MANDT == TCURC.MANDT
Tax on sales/purchases code
  • Tax on sales/purchases code
  • ?
  • Client
  • P_RU_VATSALESPURCHASELEDGERS7.TAXCODE == T007A.MWSKZ
  • P_RU_VATSALESPURCHASELEDGERS7.[column in domain "KALSM_D"] == T007A.KALSM
  • P_RU_VATSALESPURCHASELEDGERS7.MANDT == T007A.MANDT