P_KZ_DSVATRetInDoc1

DDL: P_KZ_DSVATRETINDOC1 SQL: PKZDSVATRETIND1 Type: view COMPOSITE Package: GLO_FIN_IS_VAT_KZ_RETURN
13 Fields 2 Data Sources

Data sselection for paper customer invoices

P_KZ_DSVATRetInDoc1 is a Composite CDS View that provides data about "Data sselection for paper customer invoices" in SAP S/4HANA. It reads from 2 data sources (I_KZ_VATReturnCustomizing, I_JournalEntry) and exposes 13 fields with key fields StatryRptgEntity, StatryRptCategory, StatryRptRunID, CompanyCode, FiscalYear. Part of development package GLO_FIN_IS_VAT_KZ_RETURN.

Data Sources (2)

SourceAliasJoin Type
I_KZ_VATReturnCustomizing Customazing inner
I_JournalEntry JournalEntry from

Parameters (6)

NameTypeDefault
P_StatryRptgEntity srf_reporting_entity
P_StatryRptCategory srf_rep_cat_id
P_StatryRptRunID srf_report_run_id
P_VATReturnVersion j_3rvatdversion
P_ReportingPeriodStartDate datum
P_ReportingPeriodEndDate datum

Annotations (7)

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

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY StatryRptgEntity
KEY StatryRptCategory
KEY StatryRptRunID
KEY CompanyCode I_JournalEntry CompanyCode Receiver Company Code
KEY FiscalYear I_JournalEntry FiscalYear G/L Fiscal Year
KEY AccountingDocument I_JournalEntry AccountingDocument Journal Entry
KEY AccountingDocumentItem TaxItem TaxItem Tax Item
KEY SectionNum I_KZ_VATReturnCustomizing KZ_VATReturnSection
KEY LineItem I_KZ_VATReturnCustomizing KZ_VATLineItem
KEY OperationCode I_KZ_VATReturnCustomizing KZ_VATOperationCode Operation Code
KEY ColumnNum I_KZ_VATReturnCustomizing KZ_VATReturnSectionColumn
TaxReportingDate I_JournalEntry TaxReportingDate Tax Reporting Date
Supplier DocumentItem Supplier Supplier

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_DSVATRetInDoc1.
-- 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: PKZDSVATRETIND1
-- Parameters: P_StatryRptgEntity : srf_reporting_entity, P_StatryRptCategory : srf_rep_cat_id, P_StatryRptRunID : srf_report_run_id, P_VATReturnVersion : j_3rvatdversion, P_ReportingPeriodStartDate : datum, P_ReportingPeriodEndDate : datum

CREATE VIEW P_KZ_DSVATRetInDoc1 AS
SELECT
  $parameters.P_StatryRptgEntity AS StatryRptgEntity,
  $parameters.P_StatryRptCategory AS StatryRptCategory,
  $parameters.P_StatryRptRunID AS StatryRptRunID,
  JournalEntry.CompanyCode AS CompanyCode,
  JournalEntry.FiscalYear AS FiscalYear,
  JournalEntry.AccountingDocument AS AccountingDocument,
  TaxItem.TaxItem AS AccountingDocumentItem,
  Customazing.KZ_VATReturnSection AS SectionNum,
  Customazing.KZ_VATLineItem AS LineItem,
  Customazing.KZ_VATOperationCode AS OperationCode,
  Customazing.KZ_VATReturnSectionColumn AS ColumnNum,
  JournalEntry.TaxReportingDate AS TaxReportingDate,
  DocumentItem.Supplier AS Supplier
FROM I_JournalEntry AS JournalEntry
INNER JOIN I_KZ_VATReturnCustomizing AS Customazing ON /* join condition not captured in parsed metadata */
;

Learn More