C_UA_VATReturnQuery

DDL: C_UA_VATRETURNQUERY SQL: CUAVATANX4 Type: view CONSUMPTION Package: GLO_FIN_IS_VAT_UA_RETURN
58 Fields 1 Data Sources

Ukraine VAT Annex4 Analytical Query

C_UA_VATReturnQuery is a Consumption CDS View that provides data about "Ukraine VAT Annex4 Analytical Query" in SAP S/4HANA. It reads from 1 data source (I_UA_VATReturnCube) and exposes 58 fields. Part of development package GLO_FIN_IS_VAT_UA_RETURN.

Data Sources (1)

SourceAliasJoin Type
I_UA_VATReturnCube I_UA_VATReturnCube from

Parameters (8)

NameTypeDefault
P_TaxIsDeferredRelevant figen_deferred_check
P_TaxIsMossRelevant figen_moss_check
P_StatryRptgEntity srf_reporting_entity
P_StatryRptCategory srf_rep_cat_id
P_StatryRptRunID srf_report_run_id
P_ReportingCountry land1
P_UA_VATReturnSubmissionDate fiua_vatret_sub_date
P_TaxBoxConfiguration figen_tdt_taxbox_config

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName CUAVATANX4 view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
EndUserText.label Ukraine VAT Annex4 Analytical Query view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MIXED view
AccessControl.personalData.blocking #NOT_REQUIRED view
Analytics.query true view

Fields (58)

KeyFieldSource TableSource FieldDescription
CompanyCode CompanyCode Receiver Company Code
FiscalYear FiscalYear G/L Fiscal Year
PostingDate PostingDate Posting Date for GR
ReportingDate ReportingDate
ReportingCountry ReportingCountry
TaxItem TaxItem Tax Item
TaxCode TaxCode Tax Code
TransactionTypeDetermination TransactionTypeDetermination Transaction Key
TaxBox TaxBox Tax.Bs.Gp.No.
TaxGroup TaxGroup Tax Group
Country Country Venue: Ctry/Reg
TaxDeclnAmountType TaxDeclnAmountType
TaxBoxStrucValidityStartDate TaxBoxStrucValidityStartDate
UnifiedTaxBoxStructureType UnifiedTaxBoxStructureType
StatryRptgEntity StatryRptgEntity Reporting Entity
StatryRptCategory StatryRptCategory Report ID
StatryRptRunID StatryRptRunID Report Run ID
StatryRptRun StatryRptRun
TaxBoxStructureType TaxBoxStructureType
TaxBoxStrucValidityEndDate TaxBoxStrucValidityEndDate
DebitCreditCode DebitCreditCode Single-Character Flag
UA_XMLFileIsFound UA_XMLFileIsFound Has corresponding XML File
TaxType TaxType Tax Type
TaxBoxStructure TaxBoxStructure
TaxBoxStructureName TaxBoxStructureName
UA_CustomerIndividualNumber UA_CustomerIndividualNumber Customer Individual Tax Number
UA_DocumentIsRegistered UA_DocumentIsRegistered Document is Registered
UA_ArticleOfTaxLaw UA_ArticleOfTaxLaw Article of Tax Law
UA_VATExemptionCode UA_VATExemptionCode Tax Exemption Сode
AccountingDocument AccountingDocument Document Number
AccountingDocumentType AccountingDocumentType Document Type
VATIncomingDocumentDate VATIncomingDocumentDate Tax Invoice Document Date
UA_TaxDocumentCategory UA_TaxDocumentCategory Tax Document Category
UA_TaxDocumentNumber UA_TaxDocumentNumber Tax Document Number
AccountingDocumentHeaderText AccountingDocumentHeaderText Document Header Text
UA_AssetIsNotCurrent UA_AssetIsNotCurrent Is Non Current Asset (NCA)
Customer Customer Customer Number
IsReversal IsReversal Reversal doc.
IsReversed IsReversed Reversed?
CompanyCodeCountry CompanyCodeCountry Reporting Ctry/Reg.
CompanyCodeCurrency CompanyCodeCurrency Local Currency
ReportingCurrency ReportingCurrency Currency
TaxBaseAmountInRptgCrcy TaxBaseAmountInRptgCrcy Tax Base Amount in Reporting Currency
TaxAmountInRptgCrcy TaxAmountInRptgCrcy Tax Amount in Reporting Currency
HasNegativeSign HasNegativeSign XML has Negative Sign
BusinessPartner BusinessPartner Issuing Authority
BusinessPartnerName BusinessPartnerName Customer Name
BusinessPartnerCountry BusinessPartnerCountry BP Ctry/Reg.
TaxIsNotDeductible TaxIsNotDeductible Non-Deductible
TaxBoxName TaxBoxName
TaxBoxCondition TaxBoxCondition
LatestRegistrationDate LatestRegistrationDate Tax Document RegistrationDate
VATCorrectionDocumentDate VATCorrectionDocumentDate Correction Tax Invoice Document Date
UA_BranchNumber UA_BranchNumber Customer Branch Number
UA_VATOperationDescription UA_VATOperationDescription Article of Tax Law Description
UA_VATExemptionCodeText UA_VATExemptionCodeText Tax Exemption Code Description
_TaxTypeText _TaxTypeText
_TaxDocumentCategoryText _TaxDocumentCategoryText

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_UA_VATReturnQuery.
-- 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: CUAVATANX4
-- Parameters: P_TaxIsDeferredRelevant : figen_deferred_check, P_TaxIsMossRelevant : figen_moss_check, P_StatryRptgEntity : srf_reporting_entity, P_StatryRptCategory : srf_rep_cat_id, P_StatryRptRunID : srf_report_run_id, P_ReportingCountry : land1, P_UA_VATReturnSubmissionDate : fiua_vatret_sub_date, P_TaxBoxConfiguration : figen_tdt_taxbox_config

CREATE VIEW C_UA_VATReturnQuery AS
SELECT
  CompanyCode,
  FiscalYear,
  PostingDate,
  ReportingDate,
  ReportingCountry,
  TaxItem,
  TaxCode,
  TransactionTypeDetermination,
  TaxBox,
  TaxGroup,
  Country,
  TaxDeclnAmountType,
  TaxBoxStrucValidityStartDate,
  UnifiedTaxBoxStructureType,
  StatryRptgEntity,
  StatryRptCategory,
  StatryRptRunID,
  StatryRptRun,
  TaxBoxStructureType,
  TaxBoxStrucValidityEndDate,
  DebitCreditCode,
  UA_XMLFileIsFound,
  TaxType,
  TaxBoxStructure,
  TaxBoxStructureName,
  UA_CustomerIndividualNumber,
  UA_DocumentIsRegistered,
  UA_ArticleOfTaxLaw,
  UA_VATExemptionCode,
  AccountingDocument,
  AccountingDocumentType,
  VATIncomingDocumentDate,
  UA_TaxDocumentCategory,
  UA_TaxDocumentNumber,
  AccountingDocumentHeaderText,
  UA_AssetIsNotCurrent,
  Customer,
  IsReversal,
  IsReversed,
  CompanyCodeCountry,
  CompanyCodeCurrency,
  ReportingCurrency,
  TaxBaseAmountInRptgCrcy,
  TaxAmountInRptgCrcy,
  HasNegativeSign,
  BusinessPartner,
  BusinessPartnerName,
  BusinessPartnerCountry,
  TaxIsNotDeductible,
  TaxBoxName,
  TaxBoxCondition,
  LatestRegistrationDate,
  VATCorrectionDocumentDate,
  UA_BranchNumber,
  UA_VATOperationDescription,
  UA_VATExemptionCodeText
FROM I_UA_VATReturnCube
;

Learn More