I_IL_CAValueAddedTaxReturnCube

DDL: I_IL_CAVALUEADDEDTAXRETURNCUBE Type: view_entity COMPOSITE
26 Fields 1 Data Sources

IL VAT Return - Cube

I_IL_CAValueAddedTaxReturnCube is a Composite CDS View (Cube) that provides data about "IL VAT Return - Cube" in SAP S/4HANA. It reads from 1 data source (P_IL_CAValAddTaxRetRcdTypCndns) and exposes 26 fields with key fields StatryRptgEntity, StatryRptCategory, StatryRptRunID, CADocument, CAGLItemNumber.

Data Sources (1)

SourceAliasJoin Type
P_IL_CAValAddTaxRetRcdTypCndns VatData from

Annotations (12)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #BLOCKED_DATA_INCLUDED view
Analytics.dataCategory #CUBE view
Analytics.internalName #LOCAL view
Analytics.technicalName IILCAValueAddedTaxReturnCube view
EndUserText.label IL VAT Return - Cube view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #COMPOSITE view

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY StatryRptgEntity P_IL_CAValAddTaxRetRcdTypCndns StatryRptgEntity Reporting Entity
KEY StatryRptCategory P_IL_CAValAddTaxRetRcdTypCndns StatryRptCategory Report ID
KEY StatryRptRunID P_IL_CAValAddTaxRetRcdTypCndns StatryRptRunID Report Run ID
KEY CADocument P_IL_CAValAddTaxRetRcdTypCndns CADocument CA Document No.
KEY CAGLItemNumber P_IL_CAValAddTaxRetRcdTypCndns CAGLItemNumber Item
KEY CompanyCode P_IL_CAValAddTaxRetRcdTypCndns CompanyCode Receiver Company Code
FiscalYearVariant
SystemMessageTextLong P_IL_CAValAddTaxRetRcdTypCndns SystemMessageTextLong
SystemMessageType P_IL_CAValAddTaxRetRcdTypCndns SystemMessageType Message type
IL_VATRecordType
TaxCode P_IL_CAValAddTaxRetRcdTypCndns TaxCode Tax Code
DocumentDate P_IL_CAValAddTaxRetRcdTypCndns DocumentDate Journal Entry Date
PostingDate P_IL_CAValAddTaxRetRcdTypCndns CAPostingDate Posting Date
BusinessPartner P_IL_CAValAddTaxRetRcdTypCndns BusinessPartner Issuing Authority
CAReferenceDocument P_IL_CAValAddTaxRetRcdTypCndns CAReferenceDocument Reference
Currency P_IL_CAValAddTaxRetRcdTypCndns Currency Valuation Crcy
AdditionalCurrency1 P_IL_CAValAddTaxRetRcdTypCndns AdditionalCurrency1 Local curr. 2
AdditionalCurrency2 P_IL_CAValAddTaxRetRcdTypCndns AdditionalCurrency2 Local curr. 3
CAAmountInLocalCurrency P_IL_CAValAddTaxRetRcdTypCndns CAAmountInLocalCurrency Local Crcy Amt
CAAmountInSecondCurrency P_IL_CAValAddTaxRetRcdTypCndns CAAmountInSecondCurrency Amount in LC 2
CAAmountInThirdCurrency P_IL_CAValAddTaxRetRcdTypCndns CAAmountInThirdCurrency Amount in LC3
CATaxAmountInLocalCurrency P_IL_CAValAddTaxRetRcdTypCndns CATaxAmountInLocalCurrency LC Tax
CATaxAmountInSecondCurrency P_IL_CAValAddTaxRetRcdTypCndns CATaxAmountInSecondCurrency LC 2 Tax
CATaxAmountInThirdCurrency P_IL_CAValAddTaxRetRcdTypCndns CATaxAmountInThirdCurrency LC 3 tax
_CompanyCode P_IL_CAValAddTaxRetRcdTypCndns _CompanyCode
_BusinessPartner P_IL_CAValAddTaxRetRcdTypCndns _BusinessPartner

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 I_IL_CAValueAddedTaxReturnCube.
-- 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.

CREATE VIEW I_IL_CAValueAddedTaxReturnCube AS
SELECT
  VatData.StatryRptgEntity AS StatryRptgEntity,
  VatData.StatryRptCategory AS StatryRptCategory,
  VatData.StatryRptRunID AS StatryRptRunID,
  VatData.CADocument AS CADocument,
  VatData.CAGLItemNumber AS CAGLItemNumber,
  VatData.CompanyCode AS CompanyCode,
  VatData._CompanyCode.FiscalYearVariant AS FiscalYearVariant,
  VatData.SystemMessageTextLong AS SystemMessageTextLong,
  VatData.SystemMessageType AS SystemMessageType,
  max(VatData.IL_VATRecordType) AS IL_VATRecordType,
  VatData.TaxCode AS TaxCode,
  VatData.DocumentDate AS DocumentDate,
  VatData.CAPostingDate AS PostingDate,
  VatData.BusinessPartner AS BusinessPartner,
  VatData.CAReferenceDocument AS CAReferenceDocument,
  VatData.Currency AS Currency,
  VatData.AdditionalCurrency1 AS AdditionalCurrency1,
  VatData.AdditionalCurrency2 AS AdditionalCurrency2,
  VatData.CAAmountInLocalCurrency AS CAAmountInLocalCurrency,
  VatData.CAAmountInSecondCurrency AS CAAmountInSecondCurrency,
  VatData.CAAmountInThirdCurrency AS CAAmountInThirdCurrency,
  VatData.CATaxAmountInLocalCurrency AS CATaxAmountInLocalCurrency,
  VatData.CATaxAmountInSecondCurrency AS CATaxAmountInSecondCurrency,
  VatData.CATaxAmountInThirdCurrency AS CATaxAmountInThirdCurrency,
  VatData._CompanyCode AS _CompanyCode,
  VatData._BusinessPartner AS _BusinessPartner
FROM P_IL_CAValAddTaxRetRcdTypCndns AS VatData
;

Learn More