P_KZ_VATRetForeignDoc
Selection for foriegn documentss
P_KZ_VATRetForeignDoc is a Composite CDS View that provides data about "Selection for foriegn documentss" in SAP S/4HANA. It reads from 1 data source (P_KZ_VATRETURNFOREIGN1) and exposes 81 fields. Part of development package GLO_FIN_IS_VAT_KZ_RETURN.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| P_KZ_VATRETURNFOREIGN1 | ForeignDoc | from |
Parameters (2)
| Name | Type | Default |
|---|---|---|
| P_ReportingPeriodStartDate | datum | |
| P_ReportingPeriodEndDate | datum |
Annotations (6)
| Name | Value | Level | Field |
|---|---|---|---|
| AbapCatalog.sqlViewName | PKZVATRETFOREIGN | 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 (81)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| CompanyCode | P_KZ_VATRETURNFOREIGN1 | CompanyCode | Receiver Company Code | |
| AccountingDocument | P_KZ_VATRETURNFOREIGN1 | AccountingDocument | Journal Entry | |
| FiscalYear | P_KZ_VATRETURNFOREIGN1 | FiscalYear | G/L Fiscal Year | |
| TaxAmountInCoCodeCrcy | P_KZ_VATRETURNFOREIGN1 | TaxAmountInCoCodeCrcy | Tax Amount in Company Code Currency | |
| TaxAmount | P_KZ_VATRETURNFOREIGN1 | TaxAmount | Tax Amt in Rptg Crcy | |
| PostingDate | P_KZ_VATRETURNFOREIGN1 | PostingDate | Posting Date for GR | |
| TaxReportingDate | P_KZ_VATRETURNFOREIGN1 | TaxReportingDate | Tax Reporting Date | |
| DocumentDate | P_KZ_VATRETURNFOREIGN1 | DocumentDate | Journal Entry Date | |
| AccountingDocumentType | P_KZ_VATRETURNFOREIGN1 | AccountingDocumentType | Journal Entry Type | |
| IsReversal | P_KZ_VATRETURNFOREIGN1 | IsReversal | Reversal doc. | |
| IsReversed | P_KZ_VATRETURNFOREIGN1 | IsReversed | Reversed? | |
| OriginalReferenceDocument | P_KZ_VATRETURNFOREIGN1 | OriginalReferenceDocument | Reference Key | |
| ReferenceDocumentType | P_KZ_VATRETURNFOREIGN1 | ReferenceDocumentType | Reference Document Type | |
| DocumentReferenceID | P_KZ_VATRETURNFOREIGN1 | DocumentReferenceID | Reference | |
| BusinessTransactionType | P_KZ_VATRETURNFOREIGN1 | BusinessTransactionType | Bus.transaction | |
| SenderLogicalSystem | P_KZ_VATRETURNFOREIGN1 | SenderLogicalSystem | Sender Logical System | |
| AccountingDocumentHeaderText | P_KZ_VATRETURNFOREIGN1 | AccountingDocumentHeaderText | Doc.Header Text | |
| AccountingDocCreatedByUser | P_KZ_VATRETURNFOREIGN1 | AccountingDocCreatedByUser | User which created overhead document | |
| Reference1InDocumentHeader | P_KZ_VATRETURNFOREIGN1 | Reference1InDocumentHeader | Reference 1 | |
| Reference2InDocumentHeader | P_KZ_VATRETURNFOREIGN1 | Reference2InDocumentHeader | Reference 2 | |
| DocumentItemText | P_KZ_VATRETURNFOREIGN1 | DocumentItemText | Text | |
| CompanyCodeCurrency | P_KZ_VATRETURNFOREIGN1 | CompanyCodeCurrency | Local Currency | |
| DocumentCurrency | P_KZ_VATRETURNFOREIGN1 | DocumentCurrency | Document Currency | |
| Currency | Currency | Valuation Crcy | ||
| VATToBePaid | P_KZ_VATRETURNFOREIGN1 | TaxBaseAmountInCoCodeCrcy | TxBaseAmt CoCodeCrcy | |
| SupplierName | SupplierData | SupplierName | Supplier Name | |
| Country | Country | CountryISOCode | ||
| CountryThreeDigitISOCode | Country | CountryThreeDigitISOCode | ||
| TaxNumber1 | RootSuplierData | TaxNumber1 | VAT Reg. No. | |
| TaxNumber3 | RootSuplierData | TaxNumber3 | ||
| TaxCode | P_KZ_VATRETURNFOREIGN1 | TaxCode | Tax Code | |
| StatryRptgEntity | StatryRptgEntity | Reporting Entity | ||
| StatryRptCategory | StatryRptCategory | Report ID | ||
| StatryRptRunID | StatryRptRunID | Report Run ID | ||
| AccountingDocumentItem | P_KZ_VATRETURNFOREIGN1 | AccountingDocumentItem | Posting View Item | |
| KZ_VATReturnSectionType | KZ_VATReturnSectionType | |||
| KZ_LineItem | KZ_LineItem | |||
| Description | Description | Well Code Des. | ||
| FiscalPeriod | P_KZ_VATRETURNFOREIGN1 | FiscalPeriod | Tax period | |
| ControllingArea | BusinessPartnerItem | ControllingArea | Controlling Area | |
| Segment | BusinessPartnerItem | Segment | Segment number | |
| ProfitCenter | BusinessPartnerItem | ProfitCenter | Profit Center | |
| CostCenter | BusinessPartnerItem | CostCenter | Cost Center | |
| BusinessArea | BusinessPartnerItem | BusinessArea | Business Area | |
| Supplier | BusinessPartnerItem | Supplier | Supplier | |
| Customer | BusinessPartnerItem | Customer | Sold-to Party | |
| MasterFixedAsset | BusinessPartnerItem | MasterFixedAsset | Fixed Asset | |
| FixedAsset | BusinessPartnerItem | FixedAsset | Sub-number | |
| AssetClass | BusinessPartnerItem | AssetClass | Asset Class | |
| AssignmentReference | BusinessPartnerItem | AssignmentReference | Assignment Reference | |
| Plant | BusinessPartnerItem | Plant | Valuation Area | |
| InventoryValuationType | BusinessPartnerItem | InventoryValuationType | Valuation Type | |
| ValuationArea | BusinessPartnerItem | ValuationArea | Valuation Area | |
| Product | ProductItem | Product | Product Sold | |
| FunctionalArea | BusinessPartnerItem | FunctionalArea | Sendr Fctl Area | |
| Material | BusinessPartnerItem | Material | Vehicle Model | |
| _Customer | BusinessPartnerItem | _Customer | ||
| _Supplier | BusinessPartnerItem | _Supplier | ||
| _ProfitCenter | BusinessPartnerItem | _ProfitCenter | ||
| _CostCenter | BusinessPartnerItem | _CostCenter | ||
| _BusinessArea | BusinessPartnerItem | _BusinessArea | ||
| _FunctionalArea | BusinessPartnerItem | _FunctionalArea | ||
| _ControllingArea | BusinessPartnerItem | _ControllingArea | ||
| _Segment | BusinessPartnerItem | _Segment | ||
| _InventoryValuationType | BusinessPartnerItem | _InventoryValuationType | ||
| _Product | ProductItem | _Product | ||
| _Material | BusinessPartnerItem | _Material | ||
| KZ_VATReturnVersion | KZ_VATReturnVersion | |||
| AccountingDocumentCategory | P_KZ_VATRETURNFOREIGN1 | AccountingDocumentCategory | Journal Entry Category | |
| _ReferenceDocumentType | P_KZ_VATRETURNFOREIGN1 | _ReferenceDocumentType | ||
| _BusinessTransactionType | P_KZ_VATRETURNFOREIGN1 | _BusinessTransactionType | ||
| _CompanyCodeCurrency | P_KZ_VATRETURNFOREIGN1 | _CompanyCodeCurrency | ||
| _AccountingDocumentType | P_KZ_VATRETURNFOREIGN1 | _AccountingDocumentType | ||
| _AccountingDocumentCategory | P_KZ_VATRETURNFOREIGN1 | _AccountingDocumentCategory | ||
| _FiscalYear | P_KZ_VATRETURNFOREIGN1 | _FiscalYear | ||
| _FiscalPeriod | P_KZ_VATRETURNFOREIGN1 | _FiscalPeriod | ||
| _CompanyCode | P_KZ_VATRETURNFOREIGN1 | _CompanyCode | ||
| _AccountingDocumentTypeText | P_KZ_VATRETURNFOREIGN1 | _AccountingDocumentTypeText | ||
| _BusinessTransactionTypeText | P_KZ_VATRETURNFOREIGN1 | _BusinessTransactionTypeText | ||
| _TransactionCurrency | P_KZ_VATRETURNFOREIGN1 | _TransactionCurrency | ||
| _Contract | _Contract |
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_VATRetForeignDoc.
-- 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: PKZVATRETFOREIGN
-- Parameters: P_ReportingPeriodStartDate : datum, P_ReportingPeriodEndDate : datum
CREATE VIEW P_KZ_VATRetForeignDoc AS
SELECT
ForeignDoc.CompanyCode AS CompanyCode,
ForeignDoc.AccountingDocument AS AccountingDocument,
ForeignDoc.FiscalYear AS FiscalYear,
ForeignDoc.TaxAmountInCoCodeCrcy AS TaxAmountInCoCodeCrcy,
ForeignDoc.TaxAmount AS TaxAmount,
ForeignDoc.PostingDate AS PostingDate,
ForeignDoc.TaxReportingDate AS TaxReportingDate,
ForeignDoc.DocumentDate AS DocumentDate,
ForeignDoc.AccountingDocumentType AS AccountingDocumentType,
ForeignDoc.IsReversal AS IsReversal,
ForeignDoc.IsReversed AS IsReversed,
ForeignDoc.OriginalReferenceDocument AS OriginalReferenceDocument,
ForeignDoc.ReferenceDocumentType AS ReferenceDocumentType,
ForeignDoc.DocumentReferenceID AS DocumentReferenceID,
ForeignDoc.BusinessTransactionType AS BusinessTransactionType,
ForeignDoc.SenderLogicalSystem AS SenderLogicalSystem,
ForeignDoc.AccountingDocumentHeaderText AS AccountingDocumentHeaderText,
ForeignDoc.AccountingDocCreatedByUser AS AccountingDocCreatedByUser,
ForeignDoc.Reference1InDocumentHeader AS Reference1InDocumentHeader,
ForeignDoc.Reference2InDocumentHeader AS Reference2InDocumentHeader,
ForeignDoc.DocumentItemText AS DocumentItemText,
ForeignDoc.CompanyCodeCurrency AS CompanyCodeCurrency,
ForeignDoc.DocumentCurrency AS DocumentCurrency,
Currency,
ForeignDoc.TaxBaseAmountInCoCodeCrcy AS VATToBePaid,
SupplierData.SupplierName AS SupplierName,
Country.CountryISOCode AS Country,
Country.CountryThreeDigitISOCode AS CountryThreeDigitISOCode,
RootSuplierData.TaxNumber1 AS TaxNumber1,
RootSuplierData.TaxNumber3 AS TaxNumber3,
ForeignDoc.TaxCode AS TaxCode,
StatryRptgEntity,
StatryRptCategory,
StatryRptRunID,
ForeignDoc.AccountingDocumentItem AS AccountingDocumentItem,
KZ_VATReturnSectionType,
KZ_LineItem,
Description,
ForeignDoc.FiscalPeriod AS FiscalPeriod,
BusinessPartnerItem.ControllingArea AS ControllingArea,
BusinessPartnerItem.Segment AS Segment,
BusinessPartnerItem.ProfitCenter AS ProfitCenter,
BusinessPartnerItem.CostCenter AS CostCenter,
BusinessPartnerItem.BusinessArea AS BusinessArea,
BusinessPartnerItem.Supplier AS Supplier,
BusinessPartnerItem.Customer AS Customer,
BusinessPartnerItem.MasterFixedAsset AS MasterFixedAsset,
BusinessPartnerItem.FixedAsset AS FixedAsset,
BusinessPartnerItem.AssetClass AS AssetClass,
BusinessPartnerItem.AssignmentReference AS AssignmentReference,
BusinessPartnerItem.Plant AS Plant,
BusinessPartnerItem.InventoryValuationType AS InventoryValuationType,
BusinessPartnerItem.ValuationArea AS ValuationArea,
ProductItem.Product AS Product,
BusinessPartnerItem.FunctionalArea AS FunctionalArea,
BusinessPartnerItem.Material AS Material,
BusinessPartnerItem._Customer AS _Customer,
BusinessPartnerItem._Supplier AS _Supplier,
BusinessPartnerItem._ProfitCenter AS _ProfitCenter,
BusinessPartnerItem._CostCenter AS _CostCenter,
BusinessPartnerItem._BusinessArea AS _BusinessArea,
BusinessPartnerItem._FunctionalArea AS _FunctionalArea,
BusinessPartnerItem._ControllingArea AS _ControllingArea,
BusinessPartnerItem._Segment AS _Segment,
BusinessPartnerItem._InventoryValuationType AS _InventoryValuationType,
ProductItem._Product AS _Product,
BusinessPartnerItem._Material AS _Material,
KZ_VATReturnVersion,
ForeignDoc.AccountingDocumentCategory AS AccountingDocumentCategory,
ForeignDoc._ReferenceDocumentType AS _ReferenceDocumentType,
ForeignDoc._BusinessTransactionType AS _BusinessTransactionType,
ForeignDoc._CompanyCodeCurrency AS _CompanyCodeCurrency,
ForeignDoc._AccountingDocumentType AS _AccountingDocumentType,
ForeignDoc._AccountingDocumentCategory AS _AccountingDocumentCategory,
ForeignDoc._FiscalYear AS _FiscalYear,
ForeignDoc._FiscalPeriod AS _FiscalPeriod,
ForeignDoc._CompanyCode AS _CompanyCode,
ForeignDoc._AccountingDocumentTypeText AS _AccountingDocumentTypeText,
ForeignDoc._BusinessTransactionTypeText AS _BusinessTransactionTypeText,
ForeignDoc._TransactionCurrency AS _TransactionCurrency
FROM P_KZ_VATRETURNFOREIGN1 AS ForeignDoc
;Learn More
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- CDS View Annotations — A Complete Guide
- What Is a CDS View in SAP S/4HANA?
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- BW Extractor to CDS View Migration Guide
- S/4HANA CDS View Deprecation: What You Need to Know
- ABAP CDS View Tutorial — From Basics to Real-World Examples
- RAP and CDS Views — Building Transactional Apps in SAP S/4HANA
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA