P_CountOfSameTaxInvDoc2

DDL: P_COUNTOFSAMETAXINVDOC2 SQL: PCNTINVDOC2 Type: view CONSUMPTION
4 Fields 2 Data Sources

P_CountOfSameTaxInvDoc2 is a Consumption CDS View in SAP S/4HANA. It reads from 2 data sources (P_CountOfSameTaxInvDoc, I_Withholdingtaxitem) and exposes 4 fields with key fields CompanyCode, FiscalYear, TaxInvoiceNumber.

Data Sources (2)

SourceAliasJoin Type
P_CountOfSameTaxInvDoc _DueDeferredTaxItemCube from
I_Withholdingtaxitem _Withholdingtaxitem left_outer

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PCNTINVDOC2 view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
VDM.private true view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #P view
ObjectModel.usageType.dataClass #MIXED view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode P_CountOfSameTaxInvDoc CompanyCode Receiver Company Code
KEY FiscalYear P_CountOfSameTaxInvDoc FiscalYear G/L Fiscal Year
KEY TaxInvoiceNumber P_CountOfSameTaxInvDoc TaxInvoiceNumber Invoice Number
NumberOfDocuments

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_CountOfSameTaxInvDoc2.
-- 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: PCNTINVDOC2

CREATE VIEW P_CountOfSameTaxInvDoc2 AS
SELECT
  _DueDeferredTaxItemCube.CompanyCode AS CompanyCode,
  _DueDeferredTaxItemCube.FiscalYear AS FiscalYear,
  _DueDeferredTaxItemCube.TaxInvoiceNumber AS TaxInvoiceNumber,
  count(*) AS NumberOfDocuments
FROM P_CountOfSameTaxInvDoc AS _DueDeferredTaxItemCube
LEFT OUTER JOIN I_Withholdingtaxitem AS _Withholdingtaxitem ON /* join condition not captured in parsed metadata */
;

Learn More