C_SupplierInvcVATReturnDocItem
To get details of SuppInv VAT ReturnDocs
C_SupplierInvcVATReturnDocItem is a Consumption CDS View that provides data about "To get details of SuppInv VAT ReturnDocs" in SAP S/4HANA. It reads from 1 data source (P_SupplierInvcVATReturnDocItem) and exposes 55 fields with key fields StatryRptgEntity, StatryRptCategory, StatryRptRunID, CompanyCode, FiscalYear. It has 2 associations to related views.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| P_SupplierInvcVATReturnDocItem | P_SupplierInvcVATReturnDocItem | from |
Parameters (3)
| Name | Type | Default |
|---|---|---|
| P_StatryRptgEntity | srf_reporting_entity | |
| P_StatryRptCategory | srf_rep_cat_id | |
| P_StatryRptRunID | srf_report_run_id |
Associations (2)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [0..1] | I_Product | _Product | $projection.Material = _Product.Product |
| [0..*] | I_ProductDescription | _ProductText | $projection.Material = _ProductText.Product |
Annotations (13)
| Name | Value | Level | Field |
|---|---|---|---|
| VDM.lifecycle.status | #DEPRECATED | view | |
| VDM.lifecycle.successor | <P_EG_StRpTaxLineItem> | view | |
| AbapCatalog.sqlViewName | CMMVATRETDOCITM | view | |
| AbapCatalog.compiler.compareFilter | true | view | |
| AbapCatalog.preserveKey | true | view | |
| VDM.viewType | #CONSUMPTION | view | |
| ClientHandling.algorithm | #SESSION_VARIABLE | view | |
| AccessControl.personalData.blocking | #BLOCKED_DATA_INCLUDED | view | |
| AccessControl.authorizationCheck | #CHECK | view | |
| ObjectModel.usageType.sizeCategory | #XL | view | |
| ObjectModel.usageType.serviceQuality | #D | view | |
| ObjectModel.usageType.dataClass | #MIXED | view | |
| EndUserText.label | To get details of SuppInv VAT ReturnDocs | view |
Fields (55)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | StatryRptgEntity | _Item | StatryRptgEntity | Reporting Entity |
| KEY | StatryRptCategory | _Item | StatryRptCategory | Report ID |
| KEY | StatryRptRunID | _Item | StatryRptRunID | Report Run ID |
| KEY | CompanyCode | _Item | CompanyCode | Receiver Company Code |
| KEY | FiscalYear | _Item | FiscalYear | G/L Fiscal Year |
| KEY | AccountingDocument | _Item | AccountingDocument | Journal Entry |
| KEY | SupplierInvoice | _Item | SupplierInvoice | |
| KEY | SupplierInvoiceItem | _Item | SupplierInvoiceItem | |
| KEY | TransactionTypeDetermination | _Item | TransactionTypeDetermination | Transaction Key |
| KEY | TaxCode | _Item | TaxCode | Tax Code |
| DocumentItemNumber | _Item | SupplierInvoiceItem | ||
| AccountingDocumentItem | _Item | AccountingDocumentItem | Posting View Item | |
| OriginalReferenceDocument | _Item | OriginalReferenceDocument | Reference Key | |
| FinancialAccountType | _Item | FinancialAccountType | Fin. Account Type | |
| AccountType | _Item | FinancialAccountType | Fin. Account Type | |
| DebitCreditCode | _Item | DebitCreditCode | Single-Character Flag | |
| AccountingDocumentType | _Item | AccountingDocumentType | Journal Entry Type | |
| AccountingDocumentItemType | _Item | AccountingDocumentItemType | Line Item ID | |
| ReferenceDocumentType | _Item | ReferenceDocumentType | Reference Document Type | |
| GLAccount | _Item | GLAccount | General Ledger | |
| FiscalPeriod | _Item | FiscalPeriod | Tax period | |
| ReportingDate | _Item | ReportingDate | ||
| PostingDate | _Item | PostingDate | Posting Date for GR | |
| DocumentDate | _Item | DocumentDate | Journal Entry Date | |
| DocumentCurrency | _Item | DocumentCurrency | Document Currency | |
| CompanyCodeCurrency | _Item | CompanyCodeCurrency | Local Currency | |
| ReportingCurrency | _Item | ReportingCurrency | Currency | |
| DebitCreditCodeIsChanged | _Item | DebitCreditCodeIsChanged | ||
| CountryCurrency | _Item | CountryCurrency | Currency | |
| AdditionalCurrency1 | _Item | AdditionalCurrency1 | Local curr. 2 | |
| AdditionalCurrency2 | _Item | AdditionalCurrency2 | Local curr. 3 | |
| Material | _Item | Material | Vehicle Model | |
| QuantityInActlPostg | _Item | QuantityInActlPostg | ||
| QuantityUnit | _Item | QuantityUnit | Unit of measure | |
| TaxRate | _Item | TaxRate | Tax Rate | |
| BusinessArea | _Item | BusinessArea | Business Area | |
| Customer | _Item | Customer | Sold-to Party | |
| Supplier | _Item | Supplier | Supplier | |
| SupplierAccountGroup | _Item | SupplierAccountGroup | Account group | |
| ReportingCountry | _Item | ReportingCountry | ||
| CompanyCodeCountry | _Item | CompanyCodeCountry | Reporting Ctry/Reg. | |
| TaxNumber1 | _Item | TaxNumber1 | VAT Reg. No. | |
| TaxNumber2 | _Item | TaxNumber2 | Tax Number 2 | |
| TaxNumber3 | _Item | TaxNumber3 | ||
| BusinessPartnerName | _Item | BusinessPartnerName | Extracted Customer Name | |
| CustomerSupplierAddress | _Item | CustomerSupplierAddress | ||
| ReverseDocument | _Item | ReverseDocument | Reversed With | |
| ReverseDocumentFiscalYear | _Item | ReverseDocumentFiscalYear | Year | |
| InvoiceReference | _Item | InvoiceReference | Invoice Reference | |
| InvoiceReferenceFiscalYear | _Item | InvoiceReferenceFiscalYear | Invoice Reference Fiscal Year | |
| TaxCalculationProcedure | TaxCalculationProcedure | Tax Procedure | ||
| TaxRateValidityStartDate | TaxRateValidityStartDate | Tax Rate Validity Start Date | ||
| _Product | _Product | |||
| _ProductText | _ProductText | |||
| DocumentReferenceID | DocumentReferenceID | Reference |
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 C_SupplierInvcVATReturnDocItem.
-- 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: CMMVATRETDOCITM
-- Parameters: P_StatryRptgEntity : srf_reporting_entity, P_StatryRptCategory : srf_rep_cat_id, P_StatryRptRunID : srf_report_run_id
CREATE VIEW C_SupplierInvcVATReturnDocItem AS
SELECT
_Item.StatryRptgEntity AS StatryRptgEntity,
_Item.StatryRptCategory AS StatryRptCategory,
_Item.StatryRptRunID AS StatryRptRunID,
_Item.CompanyCode AS CompanyCode,
_Item.FiscalYear AS FiscalYear,
_Item.AccountingDocument AS AccountingDocument,
_Item.SupplierInvoice AS SupplierInvoice,
_Item.SupplierInvoiceItem AS SupplierInvoiceItem,
_Item.TransactionTypeDetermination AS TransactionTypeDetermination,
_Item.TaxCode AS TaxCode,
_Item.SupplierInvoiceItem AS DocumentItemNumber,
_Item.AccountingDocumentItem AS AccountingDocumentItem,
_Item.OriginalReferenceDocument AS OriginalReferenceDocument,
_Item.FinancialAccountType AS FinancialAccountType,
_Item.FinancialAccountType AS AccountType,
_Item.DebitCreditCode AS DebitCreditCode,
_Item.AccountingDocumentType AS AccountingDocumentType,
_Item.AccountingDocumentItemType AS AccountingDocumentItemType,
_Item.ReferenceDocumentType AS ReferenceDocumentType,
_Item.GLAccount AS GLAccount,
_Item.FiscalPeriod AS FiscalPeriod,
_Item.ReportingDate AS ReportingDate,
_Item.PostingDate AS PostingDate,
_Item.DocumentDate AS DocumentDate,
_Item.DocumentCurrency AS DocumentCurrency,
_Item.CompanyCodeCurrency AS CompanyCodeCurrency,
_Item.ReportingCurrency AS ReportingCurrency,
_Item.DebitCreditCodeIsChanged AS DebitCreditCodeIsChanged,
_Item.CountryCurrency AS CountryCurrency,
_Item.AdditionalCurrency1 AS AdditionalCurrency1,
_Item.AdditionalCurrency2 AS AdditionalCurrency2,
_Item.Material AS Material,
_Item.QuantityInActlPostg AS QuantityInActlPostg,
_Item.QuantityUnit AS QuantityUnit,
_Item.TaxRate AS TaxRate,
_Item.BusinessArea AS BusinessArea,
_Item.Customer AS Customer,
_Item.Supplier AS Supplier,
_Item.SupplierAccountGroup AS SupplierAccountGroup,
_Item.ReportingCountry AS ReportingCountry,
_Item.CompanyCodeCountry AS CompanyCodeCountry,
_Item.TaxNumber1 AS TaxNumber1,
_Item.TaxNumber2 AS TaxNumber2,
_Item.TaxNumber3 AS TaxNumber3,
_Item.BusinessPartnerName AS BusinessPartnerName,
_Item.CustomerSupplierAddress AS CustomerSupplierAddress,
_Item.ReverseDocument AS ReverseDocument,
_Item.ReverseDocumentFiscalYear AS ReverseDocumentFiscalYear,
_Item.InvoiceReference AS InvoiceReference,
_Item.InvoiceReferenceFiscalYear AS InvoiceReferenceFiscalYear,
TaxCalculationProcedure,
TaxRateValidityStartDate,
DocumentReferenceID
FROM P_SupplierInvcVATReturnDocItem
LEFT OUTER JOIN I_Product AS _Product ON Material = _Product.Product -- association [0..1]
LEFT OUTER JOIN I_ProductDescription AS _ProductText ON Material = _ProductText.Product -- association [0..*]
;Learn More
- S/4HANA CDS View Deprecation: What You Need to Know
- 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
- 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