C_AR_StRpDailyVATAmountSplit

DDL: C_AR_STRPDAILYVATAMOUNTSPLIT SQL: CARSTRPDVATAMTS Type: view CONSUMPTION
61 Fields 1 Data Sources

Jrnl Entries with Tax Amount Columns

C_AR_StRpDailyVATAmountSplit is a Consumption CDS View that provides data about "Jrnl Entries with Tax Amount Columns" in SAP S/4HANA. It reads from 1 data source (C_AR_JournalEntryTaxItemDetail) and exposes 61 fields with key fields CompanyCode, FiscalYear, AccountingDocument, TaxItem, Supplier.

Data Sources (1)

SourceAliasJoin Type
C_AR_JournalEntryTaxItemDetail JournalEntryTaxDetail from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName CARSTRPDVATAMTS view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Jrnl Entries with Tax Amount Columns view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MIXED view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #BLOCKED_DATA_INCLUDED view

Fields (61)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CompanyCode Receiver Company Code
KEY FiscalYear FiscalYear G/L Fiscal Year
KEY AccountingDocument AccountingDocument Journal Entry
KEY TaxItem TaxItem Tax Item
KEY Supplier Supplier Supplier
KEY Customer Customer Sold-to Party
KEY TaxType TaxType Tax Type
CompanyCodeCountry CompanyCodeCountry Reporting Ctry/Reg.
AccountingDocumentType AccountingDocumentType Journal Entry Type
FinancialAccountType FinancialAccountType Fin. Account Type
ExchangeRateDate ExchangeRateDate Translatn Date
ExchangeRate ExchangeRate Exchange rate
FiscalPeriod FiscalPeriod Tax period
PostingDate PostingDate Posting Date for GR
DocumentDate DocumentDate Journal Entry Date
ReportingDate ReportingDate
ClearingDate ClearingDate Clearing Date
ClearingAccountingDocument ClearingAccountingDocument Clearing Journal Entry
AR_OfficialDocumentClass AR_OfficialDocumentClass
IsReversal IsReversal Reversal doc.
IsReversed IsReversed Reversed?
ReverseDocument ReverseDocument Reversed With
ReversalReferenceDocument ReversalReferenceDocument Reversal Reference Document
OriginalReferenceDocument OriginalReferenceDocument Reference Key
ReferenceDocumentType ReferenceDocumentType Reference Document Type
DocumentReferenceID DocumentReferenceID Reference
AR_Branch AR_Branch
AR_PrintCharacter AR_PrintCharacter
AR_OfficialDocumentNumber AR_OfficialDocumentNumber
AR_IsSelfIssuedDocument AR_IsSelfIssuedDocument
TaxCalculationProcedure TaxCalculationProcedure Tax Procedure
TaxCode TaxCode Tax Code
TaxCodeName TaxCodeName Tax Code Name
TransactionTypeDetermination TransactionTypeDetermination Transaction Key
TaxRate TaxRate Tax Rate
StRpTaxClassification StRpTaxClassification
ZeroVATRsn ZeroVATRsn Reason for Zero VAT
TransactionCurrency TransactionCurrency Transaction Currency
AmountInTransactionCurrency AmountInTransactionCurrency Pt Crcy Amt
CompanyCodeCurrency CompanyCodeCurrency Local Currency
AmountInCompanyCodeCurrency AmountInCompanyCodeCurrency Local Crcy Amt
TaxBaseAmountInCoCodeCrcy TaxBaseAmountInCoCodeCrcy TxBaseAmt CoCodeCrcy
TaxAmountInCoCodeCrcy TaxAmountInCoCodeCrcy Tax Amount in Company Code Currency
TaxedAmountInCoCoCrcy TaxedAmountInCoCoCrcy
NotTaxedAmount NotTaxedAmount
_AccountingDocumentType _AccountingDocumentType
_AltvCurrency _AltvCurrency
_AR_OfficialDocumentTypeDetn _AR_OfficialDocumentTypeDetn
_CompanyCode _CompanyCode
_CompanyCodeCountry _CompanyCodeCountry
_CompanyCodeCurrency _CompanyCodeCurrency
_Customer _Customer
_FinancialAccountType _FinancialAccountType
_FiscalPeriod _FiscalPeriod
_FiscalYear _FiscalYear
_OneTimeAccountBP _OneTimeAccountBP
_ReferenceDocumentType _ReferenceDocumentType
_StRpJournalEntryLog _StRpJournalEntryLog
_Supplier _Supplier
_TransactionCurrency _TransactionCurrency
_TaxType _TaxType

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_StRpDailyVATAmountSplit.
-- 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: CARSTRPDVATAMTS

CREATE VIEW C_AR_StRpDailyVATAmountSplit AS
SELECT
  CompanyCode,
  FiscalYear,
  AccountingDocument,
  TaxItem,
  Supplier,
  Customer,
  TaxType,
  CompanyCodeCountry,
  AccountingDocumentType,
  FinancialAccountType,
  ExchangeRateDate,
  ExchangeRate,
  FiscalPeriod,
  PostingDate,
  DocumentDate,
  ReportingDate,
  ClearingDate,
  ClearingAccountingDocument,
  AR_OfficialDocumentClass,
  IsReversal,
  IsReversed,
  ReverseDocument,
  ReversalReferenceDocument,
  OriginalReferenceDocument,
  ReferenceDocumentType,
  DocumentReferenceID,
  AR_Branch,
  AR_PrintCharacter,
  AR_OfficialDocumentNumber,
  AR_IsSelfIssuedDocument,
  TaxCalculationProcedure,
  TaxCode,
  TaxCodeName,
  TransactionTypeDetermination,
  TaxRate,
  StRpTaxClassification,
  ZeroVATRsn,
  TransactionCurrency,
  AmountInTransactionCurrency,
  CompanyCodeCurrency,
  AmountInCompanyCodeCurrency,
  TaxBaseAmountInCoCodeCrcy,
  TaxAmountInCoCodeCrcy,
  TaxedAmountInCoCoCrcy,
  NotTaxedAmount
FROM C_AR_JournalEntryTaxItemDetail AS JournalEntryTaxDetail
;

Learn More