P_RU_VATSPLedgers4

Column Name Description
Column Name Description
TotalAmountInTransactionCrcy null
TotalAmountInCoCodeCrcy null
TaxAmountInTransCrcy null
TaxAmountInCoCodeCrcy null
TaxBaseAmountInTransCrcy null
TaxBaseAmountInCoCodeCrcy null
TxBaseAmtWithTxRate0InCCCrcy null
TxBaseAmtWithTxRate10InCCCrcy null
TxBaseAmtWithTxRate18InCCCrcy null
TxBaseAmtWithTxRate20InCCCrcy null
TxAmtWithTxRate10InCCCrcy null
TxAmtWithTxRate18InCCCrcy null
TxAmtWithTxRate20InCCCrcy null
BaseAmtWithoutTxInCCCrcy null
Column Name Description
Column Name Description
PostingDate Posting Date
TaxReportingDate Tax Reporting Date
InvoiceDate External Document Date
OriginalInvoiceRevisionDate Revision Date of Original Inv.in Corrective Inv.
CorrectionInvoiceDate Date of Corrective VAT Invoice
CorrectionInvoiceRevisionDate Revision Date of Correction
Column Name Description
IsReversal Indicator: Item is Reversing Another Item Show values
IsReversed Indicator: Item is Reversed Show values
Sign +/- Sign Show values
RU_VATReturnSectionType VAT Return Section Type Show values
AgentType Business Partner (Agent) Show values
PaymentOrderOutputType Payment Order Show values
ImprtCstmsDeclnIsRead ImCD/RNPT Option Show values
MatlRcptDateIsRead Date of Material Receipt Output Indicator Show values
Column Name Description Domain name
CompanyCode Company Code BUKRS
AccountingDocument Document Number of an Accounting Document BELNR
FiscalYear Fiscal Year GJAHR
TaxItem Number of Line Item Within Accounting Document BUZEI
AccountingDocumentType Journal Entry Type BLART
ReferenceDocumentType Reference Document Type AWTYP
TaxCode Tax on sales/purchases code MWSKZ
Invoice null
InvoiceYear null
ExternalInvoice External Number TEXT50
OriginalInvoiceRevisionNumber Revision Number of Original Inv.in Corrective Inv. NUM03
CorrectionInvoice Corrective Invoice Number BELNR
CorrectionInvoiceYear Corrective Invoice Year GJAHR
ExternalCorrectionInvoice External Number of Corrective VAT Invoice TEXT50
CorrectionInvoiceRevisionNmbr Number of Revision of Correction NUM03
RevisionInvoice Revision Invoice Number BELNR
RevisionInvoiceYear Revision Invoice Year GJAHR
RU_InvoiceType null
TaxTransferDocument Document Number of an Accounting Document BELNR
CurrencyISOCode Currency ISO Code
TaxItemGroupingVersion null
PartnerCustomer Customer Number KUNNR
PartnerSupplier Supplier LIFNR
PartnerCC Company Code BUKRS
BusinessPartner Supplier LIFNR
BusinessPartnerIsOrganization null
BusinessPartnerIsNaturalPerson null
BusinessPartnerName Foreign Partner Name J_3RF_TEXT255
RU_PartnerOrganizationINN Parameter value TEXT48
RU_PartnerOrganizationKPP Parameter value TEXT48
RU_PartnerPersonINN null
AgentCustomer Customer Number KUNNR
AgentSupplier Supplier LIFNR
Agent Supplier LIFNR
AgentIsOrganization null
AgentOrganizationName null
RU_AgentOrganizationINN null
RU_AgentOrganizationKPP null
RU_AgentPersonINN null
AgentPersonSurname Business Partner Last Name (Person) TEXT50
AgentPersonName Business Partner First Name (Person) TEXT50
AgentPersonMiddleName Business Partner Middle Name (Person) TEXT50
RU_VATReturnVersion VAT Return Version CHAR10
RU_VATReturnSection Section of VAT Return CHAR10
RU_VATReturnLine Number of VAT Return Line Item CHAR6
RU_VATSubScenarioVersion VAT Subscenario Version CHAR10
RU_VATSubScenario VAT Subscenario CHAR10
RU_VATScenario VAT Scenario CHAR10
RU_OrgOperationType Operation Type Code (Organization) FIRU_VATOPTYPE
RU_PersonOperationType Operation Type Code (Person) FIRU_VATOPTYPE
RU_VATOperationType Operation Type Code CHAR2
SourceDocument Original Document Number BELNR
SourceDocumentFiscalYear Original Document Fiscal Year GJAHR
RevisionNumber Revision Number NUM03
StatryRptgEntity Reporting Entity SRF_REPORTING_ENTITY
StatryRptCategory Report Category ID SRF_REP_CAT_ID
StatryRptRunID Report Run ID SRF_REPORT_RUN_ID
ActionRuleIsGenerated null
Master Data Relations Join Conditions
Country/Region Key
  • Country/Region Key
  • Client
  • P_RU_VATSPLEDGERS4.CUSTOMERCOUNTRY == T005.LAND1
  • P_RU_VATSPLEDGERS4.MANDT == T005.MANDT