C_AR_StRpSalesTaxItemLogCube

Cube View for AR Sls Scenario with Reptd Item Log Data | view: CARSRSLSTXITMLGC | TRAN | 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 FK Company Code
FiscalYear Fiscal Year
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
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
ForeignTaxAmount Foreign Tax Amount
💲 Transaction Currency (TransactionCurrency):
AmountInTransactionCurrency Amount in Transaction Currency
TaxAmountInTransCrcy Tax Amount in Transaction Currency
TaxBaseAmountInTransCrcy Tax Base Amount In Transaction Currency
TotalCreditAmountInTransCrcy Total Credit
💲 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
💲 Document Currency (DocumentCurrency):
TaxAmount Tax Amount in Transaction Currency
Column Name Description
Column Name Description
DocumentDate Journal Entry Date
PostingDate Posting Date
ReportingDate Reporting Date
NetDueDate Due Date for Net Payment
DueCalculationBaseDate Baseline Date for Due Date Calculation
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
TaxCode Tax on Sales/Purchases Code MWSKZ
TaxRate Tax Rate
ZeroVATRsn Reason for Zero VAT J_1ARFZVAT
FiscalPeriod Fiscal Period POPER
AR_Branch Branch
AR_PrintCharacter Character to be printed on the document J_1APCHAR
AR_OfficialDocumentNumber Official Document Number CHAR9
ReverseDocument Reverse Document BELNR
AlternativeCurrencyKey Alternative key for currencies CHAR3
ExchangeRate Exchange Rate UKURS
ReferenceDocumentType Reference Document Type AWTYP
DocumentReferenceID Document Reference ID XBLNR1
ReferenceDocumentLogicalSystem Logical System of Reference Document LOGSYS
OriginalReferenceDocument Object key AWKEY
Customer Customer Number KUNNR
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
NetPaymentDays null
CashDiscount2Days null
CashDiscount1Days null
Supplier Supplier LIFNR
Master Data Relations Join Conditions
Official document class
  • Official document class
  • Client
  • Country/Region Key
  • C_AR_STRPSALESTAXITEMLOGCUBE.AR_OFFICIALDOCUMENTCLASS == DOCCLSS.DOCCLS
  • C_AR_STRPSALESTAXITEMLOGCUBE.MANDT == DOCCLSS.MANDT
  • C_AR_STRPSALESTAXITEMLOGCUBE.COMPANYCODECOUNTRY == DOCCLSS.LAND1
Official document type
  • Official document type
  • Client
  • C_AR_STRPSALESTAXITEMLOGCUBE.AR_OFFICIALDOCUMENTTYPE == J_1AOFTP.J_1AOFTP
  • C_AR_STRPSALESTAXITEMLOGCUBE.MANDT == J_1AOFTP.MANDT
Company Code
  • Client
  • Company Code
  • C_AR_STRPSALESTAXITEMLOGCUBE.MANDT == T001.MANDT
  • C_AR_STRPSALESTAXITEMLOGCUBE.COMPANYCODE == T001.BUKRS
Country/Region Key
  • Client
  • Country/Region Key
  • C_AR_STRPSALESTAXITEMLOGCUBE.MANDT == T005.MANDT
  • C_AR_STRPSALESTAXITEMLOGCUBE.COMPANYCODECOUNTRY == T005.LAND1
Company Code Currency
  • Company Code Currency
  • Document Currency
  • Transaction Currency
  • Client
  • C_AR_STRPSALESTAXITEMLOGCUBE.COMPANYCODECURRENCY == TCURC.WAERS
  • C_AR_STRPSALESTAXITEMLOGCUBE.DOCUMENTCURRENCY == TCURC.WAERS
  • C_AR_STRPSALESTAXITEMLOGCUBE.TRANSACTIONCURRENCY == TCURC.WAERS
  • C_AR_STRPSALESTAXITEMLOGCUBE.MANDT == TCURC.MANDT
Document Currency
  • Company Code Currency
  • Document Currency
  • Transaction Currency
  • Client
  • C_AR_STRPSALESTAXITEMLOGCUBE.COMPANYCODECURRENCY == TCURC.WAERS
  • C_AR_STRPSALESTAXITEMLOGCUBE.DOCUMENTCURRENCY == TCURC.WAERS
  • C_AR_STRPSALESTAXITEMLOGCUBE.TRANSACTIONCURRENCY == TCURC.WAERS
  • C_AR_STRPSALESTAXITEMLOGCUBE.MANDT == TCURC.MANDT
Reporting Entity
  • Reporting Entity
  • Client
  • C_AR_STRPSALESTAXITEMLOGCUBE.STATRYRPTGENTITY == SRF_RPG_ENT.REPORTING_ENTITY
  • C_AR_STRPSALESTAXITEMLOGCUBE.MANDT == SRF_RPG_ENT.MANDT
Transaction Currency
  • Company Code Currency
  • Document Currency
  • Transaction Currency
  • Client
  • C_AR_STRPSALESTAXITEMLOGCUBE.COMPANYCODECURRENCY == TCURC.WAERS
  • C_AR_STRPSALESTAXITEMLOGCUBE.DOCUMENTCURRENCY == TCURC.WAERS
  • C_AR_STRPSALESTAXITEMLOGCUBE.TRANSACTIONCURRENCY == TCURC.WAERS
  • C_AR_STRPSALESTAXITEMLOGCUBE.MANDT == TCURC.MANDT