C_AR_StRpSalesTaxItemLogQuery

Query View for Argentina Sales w/LogData | view: CARSRSLSTXITMLGQ | Extraction: Not supported | Component: Financials Argentina
Tables used: VBRK, VBRP, BSEC, ACCT_SRF_REP_ITM, ACCT_SRF_RPIT_TI, ACCT_SRF_RPIT_WI, BKPF, BSEG, BSET, T028M, J_1AOFTP, CFIN_AV_CI_ROOT, CFIN_AV_CI_ITEM, CFIN_AV_CI_ROOT, T001, TKA02, T005, KNA1, T007A, T007S, T001, T014, J_1AFRID, J_1AOTDETR, FIARC_TAXID, T003_I
Column Name Description
CompanyCode Company Code
FiscalYear Fiscal Year
DocumentDate Journal Entry Date
AR_Branch Branch
AR_PrintCharacter Character to be printed on the document
AR_OfficialDocumentNumber Official Document Number
AccountingDocument Journal Entry
AccountingDocumentItem Journal Entry Posting View Item
TaxItem Number of Tax Line Item
StatryRptgEntity FK Reporting Entity
StatryRptCategory FK Report Category ID
StatryRptRunID Report Run ID
TaxCode Tax on Sales/Purchases Code
Column Name Description
💲 Company Code Currency (CompanyCodeCurrency):
AmountInCompanyCodeCurrency Amount in Company Code Currency
TaxAmountInCoCodeCrcy Tax Amount In Company Code Currency
TaxBaseAmountInCoCodeCrcy Tax Base Amount in Company Code Currency
💲 Transaction Currency (TransactionCurrency):
AmountInTransactionCurrency Amount in Transaction Currency
TaxAmountInTransCrcy Tax Amount in Transaction Currency
TaxBaseAmountInTransCrcy Tax Base Amount In Transaction Currency
💲 Reporting Currency (ReportingCurrency):
AmountInReportingCurrency Amount in Reporting Currency
NotTaxedAmount Not Taxed Amount
NotRegisteredBPTxAmtInRptgCrcy Not Registered Business Partner Tax Amount
TaxExemptionAmount Exempted Tax Base Amt
PerceptionVATAmount Perception VAT Amount
GrossIncomeTaxAmount Provincial/Regional Tax amount
MunicipalTaxAmount Municipal Tax Amount
OpenTotalTaxAmount Internal Tax Amount
OtherTaxAmount Argentina Tax Amounts for Other Tax Code(s)
NetTaxAmount Taxable Net Amount
TaxedAmountInRptgCrcy Taxed base amount
TaxAmountInRptgCrcy Tax Amount in Reporting Currency
TaxBaseAmountInRptgCrcy Tax Base Amount in Reporting Currency
Column Name Description
Column Name Description
DocumentDate Journal Entry Date
PostingDate Posting Date
ReportingDate Reporting Date
NetDueDate Due Date for Net Payment
Column Name Description
TaxType Tax Type Show values
AR_VATRateCode VAT Rate Code Show values
IsReversal Indicator: Item is Reversing Another Item Show values
IsReversed Indicator: Item is Reversed Show values
FinancialAccountType Account Type Show values
StRpTaxClassification Tax Class Show values
Column Name Description Domain name
DocumentReferenceID Document Reference ID XBLNR1
TaxRate Tax Rate
ZeroVATRsn Reason for Zero VAT J_1ARFZVAT
FiscalPeriod Fiscal Period POPER
ReverseDocument Reverse Document BELNR
AlternativeCurrencyKey Alternative key for currencies CHAR3
ExchangeRate Exchange Rate UKURS
CompanyCodeCountry Country/Region Key LAND1
ReferenceDocumentType Reference Document Type AWTYP
OriginalReferenceDocument Object key AWKEY
Customer Customer Number KUNNR
Supplier Supplier LIFNR
BusinessPartnerName Business Partner Name BUSINESSPARTNERNAME
BusinessPartnerCountry Business Partner Country/Region Key LAND1
TaxNumber1 Tax Number 1 STCD1
TaxNumberType Tax Number Type J_1ATOID
NmbrOfVATRates Total Number of VAT rates in a Document INT1
Master Data Relations Join Conditions
Official document class
  • ?
  • Client
  • Official document class
  • C_AR_STRPSALESTAXITEMLOGQUERY.[column in domain "LAND1"] == DOCCLSS.LAND1
  • C_AR_STRPSALESTAXITEMLOGQUERY.MANDT == DOCCLSS.MANDT
  • C_AR_STRPSALESTAXITEMLOGQUERY.AR_OFFICIALDOCUMENTCLASS == DOCCLSS.DOCCLS
Official document type
  • Official document type
  • Client
  • C_AR_STRPSALESTAXITEMLOGQUERY.AR_OFFICIALDOCUMENTTYPE == J_1AOFTP.J_1AOFTP
  • C_AR_STRPSALESTAXITEMLOGQUERY.MANDT == J_1AOFTP.MANDT
Reporting Entity
  • Reporting Entity
  • Client
  • C_AR_STRPSALESTAXITEMLOGQUERY.STATRYRPTGENTITY == SRF_RPG_ENT.REPORTING_ENTITY
  • C_AR_STRPSALESTAXITEMLOGQUERY.MANDT == SRF_RPG_ENT.MANDT