C_APPostedInvoice

DDL: C_APPOSTEDINVOICE SQL: CAPPSTDINVCSOVP Type: view CONSUMPTION
24 Fields 1 Data Sources

Posted Invoices

C_APPostedInvoice is a Consumption CDS View that provides data about "Posted Invoices" in SAP S/4HANA. It reads from 1 data source (I_APPostedInvoice) and exposes 24 fields with key fields AccountingDocument, FiscalYear, AccountingDocumentItem.

Data Sources (1)

SourceAliasJoin Type
I_APPostedInvoice I_APPostedInvoice from

Parameters (5)

NameTypeDefault
P_KeyDate vdm_v_key_date
P_TodayDate sydate
P_Language sylangu
P_DisplayCurrency vdm_v_display_currency
P_FiscalPeriodStartDate sydate

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName CAPPSTDINVCSOVP view
Metadata.ignorePropagatedAnnotations true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Posted Invoices 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 #CONSUMPTION view

Fields (24)

KeyFieldSource TableSource FieldDescription
lookupEntityC_APMinFiscalPeriodStartDate
resultElementFiscalPeriodStartDate
P_KeyDate
P_TodayDate
CompanyCode
KEY AccountingDocument I_APPostedInvoice AccountingDocument Journal Entry
KEY FiscalYear I_APPostedInvoice FiscalYear G/L Fiscal Year
KEY AccountingDocumentItem I_APPostedInvoice AccountingDocumentItem Posting View Item
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 Number of Items
DisplayCurrency
Debtor Debtor Debtor
PostingDate PostingDate Posting Date for GR
BusinessArea BusinessArea Business Area
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 C_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: CAPPSTDINVCSOVP
-- Parameters: P_KeyDate : vdm_v_key_date, P_TodayDate : sydate, P_Language : sylangu, P_DisplayCurrency : vdm_v_display_currency, P_FiscalPeriodStartDate : sydate

CREATE VIEW C_APPostedInvoice AS
SELECT
  lookupEntity: 'C_APMinFiscalPeriodStartDate' AS lookupEntityC_APMinFiscalPeriodStartDate,
  resultElement: 'FiscalPeriodStartDate' AS resultElementFiscalPeriodStartDate,
  binding: [{ targetParameter: 'P_TodayDate', type : #SYSTEM_FIELD, value : '#SYSTEM_DATE' AS P_KeyDate,
  P_TodayDate: $parameters.P_TodayDate AS P_TodayDate,
  I_APPostedInvoice.AccountingDocument AS AccountingDocument,
  I_APPostedInvoice.FiscalYear AS FiscalYear,
  I_APPostedInvoice.AccountingDocumentItem AS AccountingDocumentItem,
  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,
  $parameters.P_DisplayCurrency AS DisplayCurrency,
  Debtor,
  PostingDate,
  BusinessArea,
  AccountingDocumentType
FROM I_APPostedInvoice
;

Learn More