P_KZ_VATRetInDoc

DDL: P_KZ_VATRETINDOC SQL: PKZVATRETINDOC Type: view CONSUMPTION
46 Fields 2 Data Sources

P_KZ_VATRetInDoc is a Consumption CDS View in SAP S/4HANA. It reads from 2 data sources (I_OperationalAcctgDocItem, P_KZ_PurMaterialDetails) and exposes 46 fields.

Data Sources (2)

SourceAliasJoin Type
I_OperationalAcctgDocItem DocumentItem left_outer
P_KZ_PurMaterialDetails PurchasingDocument left_outer

Annotations (6)

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

Fields (46)

KeyFieldSource TableSource FieldDescription
CompanyCode LogItems CompanyCode Receiver Company Code
AccountingDocument LogItems AccountingDocument Journal Entry
FiscalYear LogItems FiscalYear G/L Fiscal Year
TaxCode LogItems TaxCode Tax Code
TaxRate LogItems TaxRate Tax Rate
AmountSign LogItems AmountSign
NegativeSign NegativeSign
AmountInCompanyCodeCurrency I_OperationalAcctgDocItem AmountInCompanyCodeCurrency Local Crcy Amt
TaxBaseAmountInCoCodeCrcy LogItems TaxBaseAmountInCoCodeCrcy TxBaseAmt CoCodeCrcy
TaxAmountInCoCodeCrcy LogItems TaxAmountInCoCodeCrcy Tax Amount in Company Code Currency
TaxBaseAmountInCoCodeCrcyABS
AmountInCompanyCodeCurrencyABS
TaxBaseAmountInCoCodeCrcyTot LogItems TaxBaseAmountInCoCodeCrcy TxBaseAmt CoCodeCrcy
TaxAmountInCoCodeCrcyTot LogItems TaxAmountInCoCodeCrcy Tax Amount in Company Code Currency
TransactionTypeDetermination LogItems TransactionTypeDetermination Transaction Key
PostingDate LogItems PostingDate Posting Date for GR
TaxReportingDate TaxReportingDate Tax Reporting Date
AccountingDocumentType LogItems AccountingDocumentType Journal Entry Type
IsReversal IsReversal Reversal doc.
IsReversed IsReversed Reversed?
OriginalReferenceDocument LogItems OriginalReferenceDocument Reference Key
ReferenceDocumentType LogItems ReferenceDocumentType Reference Document Type
DocumentReferenceID DocumentReferenceID Reference
BusinessTransactionType BusinessTransactionType Bus.transaction
SenderLogicalSystem LogItems SenderLogicalSystem Sender Logical System
AccountingDocumentHeaderText LogItems AccountingDocumentHeaderText Doc.Header Text
AccountingDocCreatedByUser LogItems AccountingDocCreatedByUser User which created overhead document
Reference1InDocumentHeader LogItems Reference1InDocumentHeader Reference 1
Reference2InDocumentHeader LogItems Reference2InDocumentHeader Reference 2
DocumentItemText LogItems DocumentItemText Text
CompanyCodeCurrency LogItems CompanyCodeCurrency Local Currency
Currency Currency Valuation Crcy
StatryRptgEntity StatryRptgEntity Reporting Entity
StatryRptCategory StatryRptCategory Report ID
StatryRptRunID StatryRptRunID Report Run ID
AccountingDocumentItem LogItems AccountingDocumentItem Posting View Item
KZ_VATReturnSectionType KZ_VATReturnSectionType
Material I_OperationalAcctgDocItem Material Vehicle Model
PurchasingDocument I_OperationalAcctgDocItem PurchasingDocument Purchasing Document
PurchasingDocumentItem I_OperationalAcctgDocItem PurchasingDocumentItem Purchasing Doc. Item
MaterialNameelseendasMaterialName
ActivityendasActivity
KZ_MaterialSubGroup P_KZ_PurMaterialDetails KZ_MaterialSubGroup
AnalyticQuantityUnit P_KZ_PurMaterialDetails QuantityUnit Unit of measure
AnalyticQuantity P_KZ_PurMaterialDetails Quantity Value
AnalyticMaterialName P_KZ_PurMaterialDetails MaterialName Material Description

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_VATRetInDoc.
-- 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: PKZVATRETINDOC

CREATE VIEW P_KZ_VATRetInDoc AS
SELECT
  LogItems.CompanyCode AS CompanyCode,
  LogItems.AccountingDocument AS AccountingDocument,
  LogItems.FiscalYear AS FiscalYear,
  LogItems.TaxCode AS TaxCode,
  LogItems.TaxRate AS TaxRate,
  LogItems.AmountSign AS AmountSign,
  NegativeSign,
  DocumentItem.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  LogItems.TaxBaseAmountInCoCodeCrcy AS TaxBaseAmountInCoCodeCrcy,
  LogItems.TaxAmountInCoCodeCrcy AS TaxAmountInCoCodeCrcy,
  abs( LogItems.TaxBaseAmountInCoCodeCrcy ) AS TaxBaseAmountInCoCodeCrcyABS,
  abs( DocumentItem.AmountInCompanyCodeCurrency ) AS AmountInCompanyCodeCurrencyABS,
  LogItems.TaxBaseAmountInCoCodeCrcy AS TaxBaseAmountInCoCodeCrcyTot,
  LogItems.TaxAmountInCoCodeCrcy AS TaxAmountInCoCodeCrcyTot,
  LogItems.TransactionTypeDetermination AS TransactionTypeDetermination,
  LogItems.PostingDate AS PostingDate,
  TaxReportingDate,
  LogItems.AccountingDocumentType AS AccountingDocumentType,
  IsReversal,
  IsReversed,
  LogItems.OriginalReferenceDocument AS OriginalReferenceDocument,
  LogItems.ReferenceDocumentType AS ReferenceDocumentType,
  DocumentReferenceID,
  BusinessTransactionType,
  LogItems.SenderLogicalSystem AS SenderLogicalSystem,
  LogItems.AccountingDocumentHeaderText AS AccountingDocumentHeaderText,
  LogItems.AccountingDocCreatedByUser AS AccountingDocCreatedByUser,
  LogItems.Reference1InDocumentHeader AS Reference1InDocumentHeader,
  LogItems.Reference2InDocumentHeader AS Reference2InDocumentHeader,
  LogItems.DocumentItemText AS DocumentItemText,
  LogItems.CompanyCodeCurrency AS CompanyCodeCurrency,
  Currency,
  StatryRptgEntity,
  StatryRptCategory,
  StatryRptRunID,
  LogItems.AccountingDocumentItem AS AccountingDocumentItem,
  KZ_VATReturnSectionType,
  DocumentItem.Material AS Material,
  DocumentItem.PurchasingDocument AS PurchasingDocument,
  DocumentItem.PurchasingDocumentItem AS PurchasingDocumentItem,
  case PurchasingDocument.KZ_MaterialSubGroup when 'MIN' then PurchasingDocument.MaterialName else '' end as MaterialName AS MaterialNameelseendasMaterialName,
  case PurchasingDocument.Activity when '' then '1' else PurchasingDocument.Activity end as Activity AS ActivityendasActivity,
  PurchasingDocument.KZ_MaterialSubGroup AS KZ_MaterialSubGroup,
  PurchasingDocument.QuantityUnit AS AnalyticQuantityUnit,
  PurchasingDocument.Quantity AS AnalyticQuantity,
  PurchasingDocument.MaterialName AS AnalyticMaterialName
LEFT OUTER JOIN P_KZ_PurMaterialDetails AS PurchasingDocument ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_OperationalAcctgDocItem AS DocumentItem ON /* join condition not captured in parsed metadata */
;

Learn More