P_KZ_VATReturnItem

DDL: P_KZ_VATRETURNITEM SQL: PKZVATRETITEM Type: view BASIC Package: GLO_FIN_IS_VAT_KZ_RETURN
6 Fields 1 Data Sources

VAT Return KZ Cust

P_KZ_VATReturnItem is a Basic CDS View that provides data about "VAT Return KZ Cust" in SAP S/4HANA. It reads from 1 data source (fikzd_vatitem) and exposes 6 fields with key fields KZ_VATReturnVersion, KZ_VATReturnSection, KZ_LineItem, OperationCode. Part of development package GLO_FIN_IS_VAT_KZ_RETURN.

Data Sources (1)

SourceAliasJoin Type
fikzd_vatitem fikzd_vatitem from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PKZVATRETITEM view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view
VDM.viewType #BASIC view
VDM.private true view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY KZ_VATReturnVersion version XML Vers.
KEY KZ_VATReturnSection sect VAT Return Section
KEY KZ_LineItem line VAT Return Line Item
KEY OperationCode operation_code Operation Code
KZ_TaxNormCode id WorklistID
KZ_TotalLine flag_total Total Line

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_VATReturnItem.
-- 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: PKZVATRETITEM

CREATE VIEW P_KZ_VATReturnItem AS
SELECT
  version AS KZ_VATReturnVersion,
  sect AS KZ_VATReturnSection,
  line AS KZ_LineItem,
  operation_code AS OperationCode,
  id AS KZ_TaxNormCode,
  flag_total AS KZ_TotalLine
FROM fikzd_vatitem
;

Learn More