C_AR_StRpDailyVATRptdJrnlEntrC

DDL: C_AR_STRPDAILYVATRPTDJRNLENTRC SQL: CARSTRPDVATRJE Type: view CONSUMPTION

Reported Journal Entries in Daily VAT

C_AR_StRpDailyVATRptdJrnlEntrC is a Consumption CDS View that provides data about "Reported Journal Entries in Daily VAT" in SAP S/4HANA. It reads from 1 data source (C_AR_StRpDailyVATAmountSplit) and exposes 60 fields with key fields StatryRptgEntity, StatryRptCategory, StatryRptRunID, CompanyCode, FiscalYear.

Data Sources (1)

SourceAliasJoin Type
C_AR_StRpDailyVATAmountSplit DVAT_SplitTaxAmt from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName CARSTRPDVATRJE view
EndUserText.label Reported Journal Entries in Daily VAT view
VDM.viewType #CONSUMPTION view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.buffering.status #NOT_ALLOWED view
AccessControl.personalData.blocking #BLOCKED_DATA_INCLUDED view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view

Fields (60)

KeyFieldSource TableSource FieldDescription
KEY StatryRptgEntity _StRpJournalEntryLog StatryRptgEntity Reporting Entity
KEY StatryRptCategory _StRpJournalEntryLog StatryRptCategory Report ID
KEY StatryRptRunID _StRpJournalEntryLog StatryRptRunID Report Run ID
KEY CompanyCode C_AR_StRpDailyVATAmountSplit CompanyCode Receiver Company Code
KEY FiscalYear C_AR_StRpDailyVATAmountSplit FiscalYear G/L Fiscal Year
KEY AccountingDocument C_AR_StRpDailyVATAmountSplit AccountingDocument Journal Entry
KEY TaxItem TaxItem Tax Item
KEY Supplier Supplier Supplier
KEY Customer Customer Sold-to Party
KEY TaxType TaxType Tax Type
TaxCode TaxCode Tax Code
TransactionTypeDetermination TransactionTypeDetermination Transaction Key
TaxCalculationProcedure TaxCalculationProcedure Tax Procedure
TaxRate TaxRate Tax Rate
ExchangeRate ExchangeRate Exchange rate
AccountingDocumentType AccountingDocumentType Journal Entry Type
AR_OfficialDocumentClass AR_OfficialDocumentClass
CompanyCodeCountry CompanyCodeCountry Reporting Ctry/Reg.
PostingDate PostingDate Posting Date for GR
DocumentDate DocumentDate Journal Entry Date
ReportingDate ReportingDate
ReferenceDocumentType ReferenceDocumentType Reference Document Type
DocumentReferenceID DocumentReferenceID Reference
OriginalReferenceDocument OriginalReferenceDocument Reference Key
ClearingDate ClearingDate Clearing Date
ClearingAccountingDocument ClearingAccountingDocument Clearing Journal Entry
FinancialAccountType FinancialAccountType Fin. Account Type
AR_Branch AR_Branch
AR_PrintCharacter AR_PrintCharacter
AR_OfficialDocumentNumber AR_OfficialDocumentNumber
StRpTaxClassification StRpTaxClassification
ZeroVATRsn ZeroVATRsn Reason for Zero VAT
CompanyCodeCurrency CompanyCodeCurrency Local Currency
TaxBaseAmountInCoCodeCrcy TaxBaseAmountInCoCodeCrcy TxBaseAmt CoCodeCrcy
TaxAmountInCoCodeCrcy TaxAmountInCoCodeCrcy Tax Amount in Company Code Currency
AmountInCompanyCodeCurrency AmountInCompanyCodeCurrency Local Crcy Amt
TransactionCurrency TransactionCurrency Transaction Currency
AmountInTransactionCurrency AmountInTransactionCurrency Pt Crcy Amt
TaxedAmountInCoCoCrcy TaxedAmountInCoCoCrcy
NotTaxedAmount NotTaxedAmount
TaxExemptionAmount TaxExemptionAmount Tax Exemption
ExportOperationTaxAmount ExportOperationTaxAmount
ImportAmountInCompanyCodeCrcy ImportAmountInCompanyCodeCrcy
RegisteredBPTaxAmount RegisteredBPTaxAmount
NotRegisteredBPTxAmtInCoCoCrcy NotRegisteredBPTxAmtInCoCoCrcy
PerceptionVATAmount PerceptionVATAmount
OtherTaxAmount OtherTaxAmount
GrossIncomeTaxAmount GrossIncomeTaxAmount
MunicipalTaxAmount MunicipalTaxAmount
_CompanyCode _CompanyCode
_FiscalYear _FiscalYear
_AccountingDocumentType _AccountingDocumentType
_CompanyCodeCountry _CompanyCodeCountry
_ReferenceDocumentType _ReferenceDocumentType
_FinancialAccountType _FinancialAccountType
_Supplier _Supplier
_Customer _Customer
_CompanyCodeCurrency _CompanyCodeCurrency
_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_StRpDailyVATRptdJrnlEntrC.
-- 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: CARSTRPDVATRJE

CREATE VIEW C_AR_StRpDailyVATRptdJrnlEntrC AS
SELECT
  _StRpJournalEntryLog.StatryRptgEntity AS StatryRptgEntity,
  _StRpJournalEntryLog.StatryRptCategory AS StatryRptCategory,
  _StRpJournalEntryLog.StatryRptRunID AS StatryRptRunID,
  DVAT_SplitTaxAmt.CompanyCode AS CompanyCode,
  DVAT_SplitTaxAmt.FiscalYear AS FiscalYear,
  DVAT_SplitTaxAmt.AccountingDocument AS AccountingDocument,
  TaxItem,
  Supplier,
  Customer,
  TaxType,
  TaxCode,
  TransactionTypeDetermination,
  TaxCalculationProcedure,
  TaxRate,
  ExchangeRate,
  AccountingDocumentType,
  AR_OfficialDocumentClass,
  CompanyCodeCountry,
  PostingDate,
  DocumentDate,
  ReportingDate,
  ReferenceDocumentType,
  DocumentReferenceID,
  OriginalReferenceDocument,
  ClearingDate,
  ClearingAccountingDocument,
  FinancialAccountType,
  AR_Branch,
  AR_PrintCharacter,
  AR_OfficialDocumentNumber,
  StRpTaxClassification,
  ZeroVATRsn,
  CompanyCodeCurrency,
  TaxBaseAmountInCoCodeCrcy,
  TaxAmountInCoCodeCrcy,
  AmountInCompanyCodeCurrency,
  TransactionCurrency,
  AmountInTransactionCurrency,
  TaxedAmountInCoCoCrcy,
  NotTaxedAmount,
  TaxExemptionAmount,
  ExportOperationTaxAmount,
  ImportAmountInCompanyCodeCrcy,
  RegisteredBPTaxAmount,
  NotRegisteredBPTxAmtInCoCoCrcy,
  PerceptionVATAmount,
  OtherTaxAmount,
  GrossIncomeTaxAmount,
  MunicipalTaxAmount
FROM C_AR_StRpDailyVATAmountSplit AS DVAT_SplitTaxAmt
;