P_KZ_VATRETSECTION2SUBTOTALS1

DDL: P_KZ_VATRETSECTION2SUBTOTALS1 SQL: PKZVATRETSEC2ST1 Type: view COMPOSITE Package: GLO_FIN_IS_VAT_KZ_RETURN
10 Fields 1 Data Sources

Section 2: Calculate subtotals

P_KZ_VATRETSECTION2SUBTOTALS1 is a Composite CDS View that provides data about "Section 2: Calculate subtotals" in SAP S/4HANA. It reads from 1 data source (P_KZ_VATRETURNMAINSECTION_RND) and exposes 10 fields. Part of development package GLO_FIN_IS_VAT_KZ_RETURN.

Data Sources (1)

SourceAliasJoin Type
P_KZ_VATRETURNMAINSECTION_RND P_KZ_VATRETURNMAINSECTION_RND from

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName PKZVATRETSEC2ST1 view
VDM.viewType #COMPOSITE view
VDM.private true view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (10)

KeyFieldSource TableSource FieldDescription
StatryRptgEntity StatryRptgEntity Reporting Entity
StatryRptCategory StatryRptCategory Report ID
StatryRptRunID StatryRptRunID Report Run ID
KZ_LineItem KZ_LineItem
OperationCode OperationCode Operation Code
TaxNormCode KZ_TaxNormCode
TotalTaxBaseAmount
TotalTaxAmount
Description Description Well Code Des.
Currency CompanyCodeCurrency Local Currency

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 P_KZ_VATRETSECTION2SUBTOTALS1.
-- 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: PKZVATRETSEC2ST1

CREATE VIEW P_KZ_VATRETSECTION2SUBTOTALS1 AS
SELECT
  StatryRptgEntity,
  StatryRptCategory,
  StatryRptRunID,
  KZ_LineItem,
  OperationCode,
  KZ_TaxNormCode AS TaxNormCode,
  sum( TaxBaseAmountInCoCodeCrcy ) AS TotalTaxBaseAmount,
  sum( TaxAmountInCoCodeCrcy ) AS TotalTaxAmount,
  Description,
  CompanyCodeCurrency AS Currency
FROM P_KZ_VATRETURNMAINSECTION_RND
;

Learn More