P_KZ_DSVATRetInDoc

DDL: P_KZ_DSVATRETINDOC SQL: PKZDSVATRETINDOC Type: view COMPOSITE
12 Fields

P_KZ_DSVATRetInDoc is a Composite CDS View in SAP S/4HANA.

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 PKZDSVATRETINDOC 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 (12)

KeyFieldSource TableSource FieldDescription
KEY StatryRptgEntity StatryRptgEntity Reporting Entity
KEY StatryRptCategory StatryRptCategory Report ID
KEY StatryRptRunID StatryRptRunID Report Run ID
KEY CompanyCode VATRETInDoc CompanyCode Receiver Company Code
KEY FiscalYear FiscalYear G/L Fiscal Year
KEY AccountingDocument AccountingDocument Journal Entry
KEY AccountingDocumentItem AccountingDocumentItem Posting View Item
KEY SectionNum SectionNum VAT Return Section
KEY LineItem LineItem VAT Return Line Item
KEY OperationCode OperationCode Operation Code
KEY ColumnNum ColumnNum Column Number
Supplier VATRETInDoc 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_DSVATRetInDoc.
-- 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: PKZDSVATRETINDOC
-- 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_DSVATRetInDoc AS
SELECT
  StatryRptgEntity,
  StatryRptCategory,
  StatryRptRunID,
  VATRETInDoc.CompanyCode AS CompanyCode,
  FiscalYear,
  AccountingDocument,
  AccountingDocumentItem,
  SectionNum,
  LineItem,
  OperationCode,
  ColumnNum,
  VATRETInDoc.Supplier AS Supplier
;

Learn More