P_KZ_VATRetForeignDocTotalsRen

DDL: P_KZ_VATRETFOREIGNDOCTOTALSREN SQL: PKZVATRETFORTR Type: view COMPOSITE Package: GLO_FIN_FI_KZ
12 Fields 1 Data Sources

Totls for section 5 of old VAT Retunr curr period

P_KZ_VATRetForeignDocTotalsRen is a Composite CDS View that provides data about "Totls for section 5 of old VAT Retunr curr period" in SAP S/4HANA. It reads from 1 data source (P_KZ_VATRetForeignDocRoundRen) and exposes 12 fields. Part of development package GLO_FIN_FI_KZ.

Data Sources (1)

SourceAliasJoin Type
P_KZ_VATRetForeignDocRoundRen P_KZ_VATRetForeignDocRoundRen from

Parameters (4)

NameTypeDefault
P_VATReturnVersion j_3rvatdversion
P_TaxItemGroupingVersion verstax
P_ReportingPeriodStartDate datum
P_ReportingPeriodEndDate datum

Annotations (6)

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

Fields (12)

KeyFieldSource TableSource FieldDescription
CompanyCode CompanyCode Receiver Company Code
TaxBaseAmountInCoCodeCrcy
TaxAmountInCoCodeCrcy
VATToBePaid
PaidVAT
SupplierName SupplierName Supplier Name
Country Country Venue: Ctry/Reg
TaxNumber1 TaxNumber1 VAT Reg. No.
Supplier Supplier Supplier
AssignmentReference AssignmentReference Assignment Reference
Currency CompanyCodeCurrency Local Currency
KZ_TaxTurnoverCode KZ_TaxTurnoverCode

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_VATRetForeignDocTotalsRen.
-- 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: PKZVATRETFORTR
-- Parameters: P_VATReturnVersion : j_3rvatdversion, P_TaxItemGroupingVersion : verstax, P_ReportingPeriodStartDate : datum, P_ReportingPeriodEndDate : datum

CREATE VIEW P_KZ_VATRetForeignDocTotalsRen AS
SELECT
  CompanyCode,
  sum(TaxBaseAmountInCoCodeCrcy) AS TaxBaseAmountInCoCodeCrcy,
  sum(TaxAmountInCoCodeCrcy) AS TaxAmountInCoCodeCrcy,
  sum(VATToBePaid) AS VATToBePaid,
  sum(PaidVAT) AS PaidVAT,
  SupplierName,
  Country,
  TaxNumber1,
  Supplier,
  AssignmentReference,
  CompanyCodeCurrency AS Currency,
  KZ_TaxTurnoverCode
FROM P_KZ_VATRetForeignDocRoundRen
;

Learn More