Deprecated
This CDS view is deprecated in S/4HANA. Use I_StRpTaxReturnBoxCube instead. View all deprecated CDS views →

I_HR_StRpTaxReturnPeriodDetail

DDL: I_HR_STRPTAXRETURNPERIODDETAIL Type: view_entity COMPOSITE
18 Fields 1 Data Sources

Croatia Tax Return Period

I_HR_StRpTaxReturnPeriodDetail is a Composite CDS View that provides data about "Croatia Tax Return Period" in SAP S/4HANA. It reads from 1 data source (I_FiscalYearPeriod) and exposes 18 fields with key fields FiscalYear, FiscalPeriod, FiscalYearVariant, FiscalPeriodStartDate, FiscalPeriodEndDate.

Data Sources (1)

SourceAliasJoin Type
I_FiscalYearPeriod Period from

Parameters (10)

NameTypeDefault
P_StatryRptgEntity srf_reporting_entity
P_StatryRptCategory srf_rep_cat_id
P_StatryRptRunID srf_report_run_id
P_ReportingCountry land1
P_FromReportingDate fis_period_date_from
P_ToReportingDate fis_period_date_to
P_TaxIsDeferredRelevant figen_deferred_check
P_TaxIsMossRelevant figen_moss_check
P_TaxBoxConfiguration figen_tdt_taxbox_config
P_FiscalYearVariant fis_periv

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Croatia Tax Return Period view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #COMPOSITE view
AccessControl.personalData.blocking #BLOCKED_DATA_INCLUDED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.lifecycle.status #DEPRECATED view
VDM.lifecycle.successor I_StRpTaxReturnBoxCube view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY FiscalYear I_FiscalYearPeriod FiscalYear G/L Fiscal Year
KEY FiscalPeriod I_FiscalYearPeriod FiscalPeriod Tax period
KEY FiscalYearVariant I_FiscalYearPeriod FiscalYearVariant FY Variant
KEY FiscalPeriodStartDate I_FiscalYearPeriod FiscalPeriodStartDate Start Date
KEY FiscalPeriodEndDate I_FiscalYearPeriod FiscalPeriodEndDate End Date
KEY CompanyCode TaxReturn CompanyCode Receiver Company Code
KEY UnifiedTaxBoxStructureType TaxReturn UnifiedTaxBoxStructureType
KEY TaxBoxStructureType TaxReturn TaxBoxStructureType
KEY TaxBoxStrucValidityStartDate TaxReturn TaxBoxStrucValidityStartDate
KEY TaxBox TaxReturn TaxBox Tax.Bs.Gp.No.
TaxBoxStrucValidityEndDate TaxReturn TaxBoxStrucValidityEndDate
VATRegistrationWithoutPrefix TaxReturn VATRegistrationWithoutPrefix
StatryRptgEntity TaxReturn StatryRptgEntity Reporting Entity
StatryRptCategory TaxReturn StatryRptCategory Report ID
StatryRptRunID TaxReturn StatryRptRunID Report Run ID
ReportingCountry TaxReturn ReportingCountry
ReportingCurrency TaxReturn ReportingCurrency Currency
TotalVATBaseAmtInRptgCrcy

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_HR_StRpTaxReturnPeriodDetail.
-- 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.
-- Parameters: P_StatryRptgEntity : srf_reporting_entity, P_StatryRptCategory : srf_rep_cat_id, P_StatryRptRunID : srf_report_run_id, P_ReportingCountry : land1, P_FromReportingDate : fis_period_date_from, P_ToReportingDate : fis_period_date_to, P_TaxIsDeferredRelevant : figen_deferred_check, P_TaxIsMossRelevant : figen_moss_check, P_TaxBoxConfiguration : figen_tdt_taxbox_config, P_FiscalYearVariant : fis_periv

CREATE VIEW I_HR_StRpTaxReturnPeriodDetail AS
SELECT
  Period.FiscalYear AS FiscalYear,
  Period.FiscalPeriod AS FiscalPeriod,
  Period.FiscalYearVariant AS FiscalYearVariant,
  Period.FiscalPeriodStartDate AS FiscalPeriodStartDate,
  Period.FiscalPeriodEndDate AS FiscalPeriodEndDate,
  TaxReturn.CompanyCode AS CompanyCode,
  TaxReturn.UnifiedTaxBoxStructureType AS UnifiedTaxBoxStructureType,
  TaxReturn.TaxBoxStructureType AS TaxBoxStructureType,
  TaxReturn.TaxBoxStrucValidityStartDate AS TaxBoxStrucValidityStartDate,
  TaxReturn.TaxBox AS TaxBox,
  TaxReturn.TaxBoxStrucValidityEndDate AS TaxBoxStrucValidityEndDate,
  TaxReturn.VATRegistrationWithoutPrefix AS VATRegistrationWithoutPrefix,
  TaxReturn.StatryRptgEntity AS StatryRptgEntity,
  TaxReturn.StatryRptCategory AS StatryRptCategory,
  TaxReturn.StatryRptRunID AS StatryRptRunID,
  TaxReturn.ReportingCountry AS ReportingCountry,
  TaxReturn.ReportingCurrency AS ReportingCurrency,
  cast( ( sum(TaxReturn.AmountInReportingCurrency ) * -1 ) as fiisvat_tax_base_sum ) AS TotalVATBaseAmtInRptgCrcy
FROM I_FiscalYearPeriod AS Period
;

Learn More