I_APPostedInvoice

DDL: I_APPOSTEDINVOICE SQL: IAPPSTDINVCSOVP Type: view COMPOSITE Package: ODATA_APOVERVIEWPAGE
24 Fields 1 Data Sources

Posted Invoices for AP OVP

I_APPostedInvoice is a Composite CDS View that provides data about "Posted Invoices for AP OVP" in SAP S/4HANA. It reads from 1 data source (R_AccountsPayablesItem) and exposes 24 fields with key fields CompanyCode, AccountingDocument, AccountingDocumentItem, FiscalYear. Part of development package ODATA_APOVERVIEWPAGE.

Data Sources (1)

SourceAliasJoin Type
R_AccountsPayablesItem R_AccountsPayablesItem from

Parameters (3)

NameTypeDefault
P_KeyDate vdm_v_key_date
P_TodayDate sydate
P_Language sylangu

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IAPPSTDINVCSOVP view
EndUserText.label Posted Invoices for AP OVP view
Metadata.ignorePropagatedAnnotations true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED 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 (24)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CompanyCode Receiver Company Code
KEY AccountingDocument AccountingDocument Journal Entry
KEY AccountingDocumentItem AccountingDocumentItem Posting View Item
KEY FiscalYear FiscalYear G/L Fiscal Year
AccountingDocumentCreationDate AccountingDocumentCreationDate Journal Entry Date
AmountInCompanyCodeCurrency
NumberOfItems
AccountingDocCreatedByUser AccountingDocCreatedByUser User which created overhead document
CompanyCodeCurrency CompanyCodeCurrency Local Currency
FiscalPeriod FiscalPeriod Tax period
PostingDate PostingDate Posting Date for GR
BusinessArea BusinessArea Business Area
Supplier Supplier Supplier
SupplierCountry SupplierCountry
AccountingClerk AccountingClerk Clerk Abbrev.
ReconciliationAccount ReconciliationAccount Recon. account
FinancialAccountType FinancialAccountType Fin. Account Type
SupplierFinsAuthorizationGrp SupplierFinsAuthorizationGrp
SupplierBasicAuthorizationGrp SupplierBasicAuthorizationGrp
DueItemType DueItemType
IsSalesRelated IsSalesRelated Is Sales Related
FiscalYearPeriod R_AccountsPayablesItem FiscalYearPeriod Period/Year
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_APPostedInvoice.
-- 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: IAPPSTDINVCSOVP
-- Parameters: P_KeyDate : vdm_v_key_date, P_TodayDate : sydate, P_Language : sylangu

CREATE VIEW I_APPostedInvoice AS
SELECT
  CompanyCode,
  AccountingDocument,
  AccountingDocumentItem,
  FiscalYear,
  AccountingDocumentCreationDate,
  cast(-AmountInCompanyCodeCurrency as dmshb_farp) AS AmountInCompanyCodeCurrency,
  cast( 1 as abap.int4 ) AS NumberOfItems,
  AccountingDocCreatedByUser,
  CompanyCodeCurrency,
  FiscalPeriod,
  PostingDate,
  BusinessArea,
  Supplier,
  SupplierCountry,
  AccountingClerk,
  ReconciliationAccount,
  FinancialAccountType,
  SupplierFinsAuthorizationGrp,
  SupplierBasicAuthorizationGrp,
  DueItemType,
  IsSalesRelated,
  R_AccountsPayablesItem.FiscalYearPeriod AS FiscalYearPeriod,
  Debtor,
  AccountingDocumentType
FROM R_AccountsPayablesItem
;

Learn More