I_APInvoiceStatistics

DDL: I_APINVOICESTATISTICS SQL: IINVOICESTAT Type: view COMPOSITE
22 Fields 1 Data Sources

Invoice statistics for AP Overview Page.

I_APInvoiceStatistics is a Composite CDS View that provides data about "Invoice statistics for AP Overview Page." in SAP S/4HANA. It reads from 1 data source (I_APPostedInvoice) and exposes 22 fields with key fields CompanyCode, AccountingDocument, FiscalYear, AccountingDocumentItem.

Data Sources (1)

SourceAliasJoin Type
I_APPostedInvoice I_APPostedInvoice from

Parameters (4)

NameTypeDefault
P_KeyDate vdm_v_key_date
P_TodayDate sydate
P_Language sylangu
P_DisplayCurrency vdm_v_display_currency

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IINVOICESTAT view
Metadata.ignorePropagatedAnnotations true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Invoice statistics for AP Overview Page. view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view

Fields (22)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_APPostedInvoice CompanyCode Receiver Company Code
KEY AccountingDocument I_APPostedInvoice AccountingDocument Journal Entry
KEY FiscalYear I_APPostedInvoice FiscalYear G/L Fiscal Year
KEY AccountingDocumentItem I_APPostedInvoice AccountingDocumentItem Posting View Item
PostingDate I_APPostedInvoice PostingDate Posting Date for GR
BusinessArea I_APPostedInvoice BusinessArea Business Area
FiscalPeriod I_APPostedInvoice FiscalPeriod Tax period
AccountingDocCreatedByUser I_APPostedInvoice AccountingDocCreatedByUser User which created overhead document
AccountingDocumentCreationDate I_APPostedInvoice AccountingDocumentCreationDate Journal Entry Date
Supplier I_APPostedInvoice Supplier Supplier
SupplierCountry I_APPostedInvoice SupplierCountry
AccountingClerk I_APPostedInvoice AccountingClerk Clerk Abbrev.
ReconciliationAccount I_APPostedInvoice ReconciliationAccount Recon. account
FinancialAccountType I_APPostedInvoice FinancialAccountType Fin. Account Type
SupplierFinsAuthorizationGrp I_APPostedInvoice SupplierFinsAuthorizationGrp
SupplierBasicAuthorizationGrp I_APPostedInvoice SupplierBasicAuthorizationGrp
DueItemType I_APPostedInvoice DueItemType
NumberOfItems I_APPostedInvoice NumberOfItems
FiscalYearPeriod I_APPostedInvoice FiscalYearPeriod Period/Year
DisplayCurrency
Debtor Debtor Debtor
AccountingDocumentType AccountingDocumentType Journal Entry Type

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 I_APInvoiceStatistics.
-- 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: IINVOICESTAT
-- Parameters: P_KeyDate : vdm_v_key_date, P_TodayDate : sydate, P_Language : sylangu, P_DisplayCurrency : vdm_v_display_currency

CREATE VIEW I_APInvoiceStatistics AS
SELECT
  I_APPostedInvoice.CompanyCode AS CompanyCode,
  I_APPostedInvoice.AccountingDocument AS AccountingDocument,
  I_APPostedInvoice.FiscalYear AS FiscalYear,
  I_APPostedInvoice.AccountingDocumentItem AS AccountingDocumentItem,
  I_APPostedInvoice.PostingDate AS PostingDate,
  I_APPostedInvoice.BusinessArea AS BusinessArea,
  I_APPostedInvoice.FiscalPeriod AS FiscalPeriod,
  I_APPostedInvoice.AccountingDocCreatedByUser AS AccountingDocCreatedByUser,
  I_APPostedInvoice.AccountingDocumentCreationDate AS AccountingDocumentCreationDate,
  I_APPostedInvoice.Supplier AS Supplier,
  I_APPostedInvoice.SupplierCountry AS SupplierCountry,
  I_APPostedInvoice.AccountingClerk AS AccountingClerk,
  I_APPostedInvoice.ReconciliationAccount AS ReconciliationAccount,
  I_APPostedInvoice.FinancialAccountType AS FinancialAccountType,
  I_APPostedInvoice.SupplierFinsAuthorizationGrp AS SupplierFinsAuthorizationGrp,
  I_APPostedInvoice.SupplierBasicAuthorizationGrp AS SupplierBasicAuthorizationGrp,
  I_APPostedInvoice.DueItemType AS DueItemType,
  I_APPostedInvoice.NumberOfItems AS NumberOfItems,
  I_APPostedInvoice.FiscalYearPeriod AS FiscalYearPeriod,
  $parameters.P_DisplayCurrency AS DisplayCurrency,
  Debtor,
  AccountingDocumentType
FROM I_APPostedInvoice
;

Learn More