C_AR_StRpSalesTaxItemLogQuery

DDL: C_AR_STRPSALESTAXITEMLOGQUERY SQL: CARSRSLSTXITMLGQ Type: view CONSUMPTION Package: GLO_FIN_IS_VAT_AR
63 Fields 1 Data Sources

Query View for Argentina Sales w/LogData

C_AR_StRpSalesTaxItemLogQuery is a Consumption CDS View that provides data about "Query View for Argentina Sales w/LogData" in SAP S/4HANA. It reads from 1 data source (C_AR_StRpSalesTaxItemLogCube) and exposes 63 fields with key fields CompanyCode, FiscalYear, DocumentDate, AR_Branch, AR_PrintCharacter. Part of development package GLO_FIN_IS_VAT_AR.

Data Sources (1)

SourceAliasJoin Type
C_AR_StRpSalesTaxItemLogCube C_AR_StRpSalesTaxItemLogCube from

Parameters (1)

NameTypeDefault
P_RptgAmountIsInTransCrcy fiar_use_transaction_currency

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName CARSRSLSTXITMLGQ view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
EndUserText.label Query View for Argentina Sales w/LogData view
Analytics.query true view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
AbapCatalog.preserveKey true view

Fields (63)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CompanyCode Receiver Company Code
KEY FiscalYear FiscalYear G/L Fiscal Year
KEY DocumentDate DocumentDate Journal Entry Date
KEY AR_Branch AR_Branch
KEY AR_PrintCharacter AR_PrintCharacter
KEY AR_OfficialDocumentNumber AR_OfficialDocumentNumber
KEY AccountingDocument AccountingDocument Journal Entry
KEY AccountingDocumentItem AccountingDocumentItem Posting View Item
KEY TaxItem TaxItem Tax Item
KEY StatryRptgEntity StatryRptgEntity Reporting Entity
KEY StatryRptCategory StatryRptCategory Report ID
KEY StatryRptRunID StatryRptRunID Report Run ID
KEY TaxCode TaxCode Tax Code
DocumentReferenceID DocumentReferenceID Reference
TaxType TaxType Tax Type
TaxRate TaxRate Tax Rate
ZeroVATRsn ZeroVATRsn Reason for Zero VAT
FiscalPeriod FiscalPeriod Tax period
PostingDate PostingDate Posting Date for GR
ReportingDate ReportingDate
NetDueDate NetDueDate Net Due Date
AR_OfficialDocumentType AR_OfficialDocumentType
AR_VATRateCode AR_VATRateCode
AR_OfficialDocumentClass AR_OfficialDocumentClass
IsReversal IsReversal Reversal doc.
IsReversed IsReversed Reversed?
ReverseDocument ReverseDocument Reversed With
AlternativeCurrencyKey AlternativeCurrencyKey
ExchangeRate ExchangeRate Exchange rate
CompanyCodeCountry CompanyCodeCountry Reporting Ctry/Reg.
ReferenceDocumentType ReferenceDocumentType Reference Document Type
OriginalReferenceDocument OriginalReferenceDocument Reference Key
FinancialAccountType FinancialAccountType Fin. Account Type
Customer Customer Sold-to Party
Supplier Supplier Supplier
BusinessPartnerName BusinessPartnerName Extracted Customer Name
BusinessPartnerCountry BusinessPartnerCountry BP Ctry/Reg.
TaxNumber1 TaxNumber1 VAT Reg. No.
TaxNumberType TaxNumberType Tax number type
NmbrOfVATRates NmbrOfVATRates
StRpTaxClassification StRpTaxClassification
CompanyCodeCurrency CompanyCodeCurrency Local Currency
TransactionCurrency TransactionCurrency Transaction Currency
ReportingCurrency ReportingCurrency Currency
AmountInCompanyCodeCurrency AmountInCompanyCodeCurrency Local Crcy Amt
AmountInTransactionCurrency AmountInTransactionCurrency Pt Crcy Amt
AmountInReportingCurrency AmountInReportingCurrency
NotTaxedAmount NotTaxedAmount
NotRegisteredBPTxAmtInRptgCrcy NotRegisteredBPTxAmtInRptgCrcy
TaxExemptionAmount TaxExemptionAmount Tax Exemption
PerceptionVATAmount PerceptionVATAmount
GrossIncomeTaxAmount GrossIncomeTaxAmount
MunicipalTaxAmount MunicipalTaxAmount
OpenTotalTaxAmount OpenTotalTaxAmount
OtherTaxAmount OtherTaxAmount
NetTaxAmount NetTaxAmount
TaxedAmountInRptgCrcy TaxedAmountInRptgCrcy
TaxAmountInCoCodeCrcy TaxAmountInCoCodeCrcy Tax Amount in Company Code Currency
TaxAmountInTransCrcy TaxAmountInTransCrcy TaxAmt in Tran. Crcy
TaxAmountInRptgCrcy TaxAmountInRptgCrcy Tax Rept. Crcy
TaxBaseAmountInCoCodeCrcy TaxBaseAmountInCoCodeCrcy TxBaseAmt CoCodeCrcy
TaxBaseAmountInTransCrcy TaxBaseAmountInTransCrcy Value-Added Tax
TaxBaseAmountInRptgCrcy TaxBaseAmountInRptgCrcy Base Amount

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view C_AR_StRpSalesTaxItemLogQuery.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: CARSRSLSTXITMLGQ
-- Parameters: P_RptgAmountIsInTransCrcy : fiar_use_transaction_currency

CREATE VIEW C_AR_StRpSalesTaxItemLogQuery AS
SELECT
  CompanyCode,
  FiscalYear,
  DocumentDate,
  AR_Branch,
  AR_PrintCharacter,
  AR_OfficialDocumentNumber,
  AccountingDocument,
  AccountingDocumentItem,
  TaxItem,
  StatryRptgEntity,
  StatryRptCategory,
  StatryRptRunID,
  TaxCode,
  DocumentReferenceID,
  TaxType,
  TaxRate,
  ZeroVATRsn,
  FiscalPeriod,
  PostingDate,
  ReportingDate,
  NetDueDate,
  AR_OfficialDocumentType,
  AR_VATRateCode,
  AR_OfficialDocumentClass,
  IsReversal,
  IsReversed,
  ReverseDocument,
  AlternativeCurrencyKey,
  ExchangeRate,
  CompanyCodeCountry,
  ReferenceDocumentType,
  OriginalReferenceDocument,
  FinancialAccountType,
  Customer,
  Supplier,
  BusinessPartnerName,
  BusinessPartnerCountry,
  TaxNumber1,
  TaxNumberType,
  NmbrOfVATRates,
  StRpTaxClassification,
  CompanyCodeCurrency,
  TransactionCurrency,
  ReportingCurrency,
  AmountInCompanyCodeCurrency,
  AmountInTransactionCurrency,
  AmountInReportingCurrency,
  NotTaxedAmount,
  NotRegisteredBPTxAmtInRptgCrcy,
  TaxExemptionAmount,
  PerceptionVATAmount,
  GrossIncomeTaxAmount,
  MunicipalTaxAmount,
  OpenTotalTaxAmount,
  OtherTaxAmount,
  NetTaxAmount,
  TaxedAmountInRptgCrcy,
  TaxAmountInCoCodeCrcy,
  TaxAmountInTransCrcy,
  TaxAmountInRptgCrcy,
  TaxBaseAmountInCoCodeCrcy,
  TaxBaseAmountInTransCrcy,
  TaxBaseAmountInRptgCrcy
FROM C_AR_StRpSalesTaxItemLogCube
;

Learn More