P_KZ_VATReturnSection

DDL: P_KZ_VATRETURNSECTION SQL: PKZVATRETDOC Type: view COMPOSITE Package: GLO_FIN_IS_VAT_KZ_RETURN
61 Fields 1 Data Sources

Selection for main ssections 0,1,2,4,6

P_KZ_VATReturnSection is a Composite CDS View that provides data about "Selection for main ssections 0,1,2,4,6" in SAP S/4HANA. It reads from 1 data source (I_KZ_VATItemLog) and exposes 61 fields. Part of development package GLO_FIN_IS_VAT_KZ_RETURN.

Data Sources (1)

SourceAliasJoin Type
I_KZ_VATItemLog Main from

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PKZVATRETDOC 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 (61)

KeyFieldSource TableSource FieldDescription
CompanyCode AccountingDocument CompanyCode Receiver Company Code
AccountingDocument AccountingDocument AccountingDocument Journal Entry
FiscalYear AccountingDocument FiscalYear G/L Fiscal Year
PostingDate AccountingDocument PostingDate Posting Date for GR
TaxReportingDate AccountingDocument TaxReportingDate Tax Reporting Date
DocumentDate AccountingDocument DocumentDate Journal Entry Date
AccountingDocumentType AccountingDocument AccountingDocumentType Journal Entry Type
IsReversal AccountingDocument IsReversal Reversal doc.
IsReversed AccountingDocument IsReversed Reversed?
OriginalReferenceDocument AccountingDocument OriginalReferenceDocument Reference Key
ReferenceDocumentType AccountingDocument ReferenceDocumentType Reference Document Type
DocumentReferenceID AccountingDocument DocumentReferenceID Reference
BusinessTransactionType AccountingDocument BusinessTransactionType Bus.transaction
SenderLogicalSystem AccountingDocument SenderLogicalSystem Sender Logical System
CompanyCodeCurrency AccountingDocument CompanyCodeCurrency Local Currency
TransactionCurrency AccountingDocument TransactionCurrency Transaction Currency
Currency
JrnlEntryCntrySpecificRef1 AccountingDocument JrnlEntryCntrySpecificRef1 Country/Region Specific Reference 1
JrnlEntryCntrySpecificDate1 AccountingDocument JrnlEntryCntrySpecificDate1 Country/Region Specific Date 1
AccountingDocumentHeaderText AccountingDocument AccountingDocumentHeaderText Doc.Header Text
AccountingDocCreatedByUser AccountingDocument AccountingDocCreatedByUser User which created overhead document
Reference1InDocumentHeader AccountingDocument Reference1InDocumentHeader Reference 1
Reference2InDocumentHeader AccountingDocument Reference2InDocumentHeader Reference 2
StatryRptgEntity I_KZ_VATItemLog StatryRptgEntity Reporting Entity
StatryRptCategory I_KZ_VATItemLog StatryRptCategory Report ID
StatryRptRunID I_KZ_VATItemLog StatryRptRunID Report Run ID
AccountingDocumentItem I_KZ_VATItemLog AccountingDocumentItem Posting View Item
Customer Customer Customer Sold-to Party
Supplier Supplier Supplier Supplier
CountryelseendasBusinessPartnerCountry
TaxNumber3else0endasTaxNumber3
KZ_VATReturnVersion Customizing KZ_VATReturnVersion XML Vers.
KZ_VATReturnSection KZ_VATReturnSection
KZ_LineItem I_KZ_VATItemLog KZ_VATLineItem VAT Return Line Item
OperationCode I_KZ_VATItemLog KZ_VATOperationCode Operation Code
KZ_VATReturnSectionColumn I_KZ_VATItemLog KZ_VATReturnSectionColumn Column Number
ConditionNumber KZ_VATConditionNumber
KZ_VATReturnSectionType I_KZ_VATItemLog KZ_VATReturnSectionType VAT Return Section
TaxCode Customizing TaxCode Tax Code
TransactionTypeDetermination Customizing TransactionTypeDetermination Transaction Key
KZ_TaxTurnoverCode Customizing KZ_TaxTurnoverCode
DebitCreditCode Customizing DebitCreditCode Single-Character Flag
KZ_AmountType TaxDeclnAmountType
NegativeSign HasNegativeSign
KZ_TaxNormCode KZ_TaxNormID
Description VATReturnItemDescription
AccountingDocumentCategory AccountingDocument AccountingDocumentCategory Journal Entry Category
_ReferenceDocumentType AccountingDocument _ReferenceDocumentType
_BusinessTransactionType AccountingDocument _BusinessTransactionType
_CompanyCodeCurrency AccountingDocument _CompanyCodeCurrency
_AccountingDocumentType AccountingDocument _AccountingDocumentType
_AccountingDocumentCategory AccountingDocument _AccountingDocumentCategory
_FiscalYear AccountingDocument _FiscalYear
FiscalPeriod AccountingDocument FiscalPeriod Tax period
_FiscalPeriod AccountingDocument _FiscalPeriod
_CompanyCode AccountingDocument _CompanyCode
_AccountingDocumentTypeText AccountingDocument _AccountingDocumentTypeText
_BusinessTransactionTypeText AccountingDocument _BusinessTransactionTypeText
_TransactionCurrency AccountingDocument _TransactionCurrency
_CustomerText Customer _CustomerText
_SupplierText Supplier _SupplierText

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_VATReturnSection.
-- 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: PKZVATRETDOC

CREATE VIEW P_KZ_VATReturnSection AS
SELECT
  AccountingDocument.CompanyCode AS CompanyCode,
  AccountingDocument.AccountingDocument AS AccountingDocument,
  AccountingDocument.FiscalYear AS FiscalYear,
  AccountingDocument.PostingDate AS PostingDate,
  AccountingDocument.TaxReportingDate AS TaxReportingDate,
  AccountingDocument.DocumentDate AS DocumentDate,
  AccountingDocument.AccountingDocumentType AS AccountingDocumentType,
  AccountingDocument.IsReversal AS IsReversal,
  AccountingDocument.IsReversed AS IsReversed,
  AccountingDocument.OriginalReferenceDocument AS OriginalReferenceDocument,
  AccountingDocument.ReferenceDocumentType AS ReferenceDocumentType,
  AccountingDocument.DocumentReferenceID AS DocumentReferenceID,
  AccountingDocument.BusinessTransactionType AS BusinessTransactionType,
  AccountingDocument.SenderLogicalSystem AS SenderLogicalSystem,
  AccountingDocument.CompanyCodeCurrency AS CompanyCodeCurrency,
  AccountingDocument.TransactionCurrency AS TransactionCurrency,
  AccountingDocument._CompanyCodeCurrency.Currency AS Currency,
  AccountingDocument.JrnlEntryCntrySpecificRef1 AS JrnlEntryCntrySpecificRef1,
  AccountingDocument.JrnlEntryCntrySpecificDate1 AS JrnlEntryCntrySpecificDate1,
  AccountingDocument.AccountingDocumentHeaderText AS AccountingDocumentHeaderText,
  AccountingDocument.AccountingDocCreatedByUser AS AccountingDocCreatedByUser,
  AccountingDocument.Reference1InDocumentHeader AS Reference1InDocumentHeader,
  AccountingDocument.Reference2InDocumentHeader AS Reference2InDocumentHeader,
  Main.StatryRptgEntity AS StatryRptgEntity,
  Main.StatryRptCategory AS StatryRptCategory,
  Main.StatryRptRunID AS StatryRptRunID,
  Main.AccountingDocumentItem AS AccountingDocumentItem,
  Customer.Customer AS Customer,
  Supplier.Supplier AS Supplier,
  case when Customer._Customer.Country is not initial then Customer._Customer.Country when Supplier._Supplier.Country is not initial then Supplier._Supplier.Country else '' end as BusinessPartnerCountry AS CountryelseendasBusinessPartnerCountry,
  case when Customer.Customer is not initial then Customer._Customer.TaxNumber3 when Supplier.Supplier is not initial then Supplier._Supplier.TaxNumber3 else '0' end as TaxNumber3 AS TaxNumber3else0endasTaxNumber3,
  Customizing.KZ_VATReturnVersion AS KZ_VATReturnVersion,
  KZ_VATReturnSection,
  Main.KZ_VATLineItem AS KZ_LineItem,
  Main.KZ_VATOperationCode AS OperationCode,
  Main.KZ_VATReturnSectionColumn AS KZ_VATReturnSectionColumn,
  KZ_VATConditionNumber AS ConditionNumber,
  Main.KZ_VATReturnSectionType AS KZ_VATReturnSectionType,
  Customizing.TaxCode AS TaxCode,
  Customizing.TransactionTypeDetermination AS TransactionTypeDetermination,
  Customizing.KZ_TaxTurnoverCode AS KZ_TaxTurnoverCode,
  Customizing.DebitCreditCode AS DebitCreditCode,
  TaxDeclnAmountType AS KZ_AmountType,
  HasNegativeSign AS NegativeSign,
  KZ_TaxNormID AS KZ_TaxNormCode,
  VATReturnItemDescription AS Description,
  AccountingDocument.AccountingDocumentCategory AS AccountingDocumentCategory,
  AccountingDocument._ReferenceDocumentType AS _ReferenceDocumentType,
  AccountingDocument._BusinessTransactionType AS _BusinessTransactionType,
  AccountingDocument._CompanyCodeCurrency AS _CompanyCodeCurrency,
  AccountingDocument._AccountingDocumentType AS _AccountingDocumentType,
  AccountingDocument._AccountingDocumentCategory AS _AccountingDocumentCategory,
  AccountingDocument._FiscalYear AS _FiscalYear,
  AccountingDocument.FiscalPeriod AS FiscalPeriod,
  AccountingDocument._FiscalPeriod AS _FiscalPeriod,
  AccountingDocument._CompanyCode AS _CompanyCode,
  AccountingDocument._AccountingDocumentTypeText AS _AccountingDocumentTypeText,
  AccountingDocument._BusinessTransactionTypeText AS _BusinessTransactionTypeText,
  AccountingDocument._TransactionCurrency AS _TransactionCurrency,
  Customer._CustomerText AS _CustomerText,
  Supplier._SupplierText AS _SupplierText
FROM I_KZ_VATItemLog AS Main
;

Learn More