C_APProcessFlowInvoiceVH

DDL: C_APPROCESSFLOWINVOICEVH Type: view_entity CONSUMPTION Package: ODATA_PROCESS_FLOW_AP

Display Process Flow AP Invoices

C_APProcessFlowInvoiceVH is a Consumption CDS View that provides data about "Display Process Flow AP Invoices" in SAP S/4HANA. It reads from 1 data source (I_SupplierInvoice) and exposes 12 fields with key fields SupplierInvoice, FiscalYear. It is exposed through 1 OData service (ASQL_F2691). Part of development package ODATA_PROCESS_FLOW_AP.

Data Sources (1)

SourceAliasJoin Type
I_SupplierInvoice I_SupplierInvoice from

Annotations (12)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Display Process Flow AP Invoices view
ObjectModel.representativeKey SupplierInvoice view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
Consumption.ranked true view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #CONSUMPTION view
ObjectModel.dataCategory #VALUE_HELP view
Search.searchable true view

OData Services (1)

ServiceBindingVersionContractRelease
ASQL_F2691 ASQL_F2691 C2 NOT_RELEASED

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY SupplierInvoice SupplierInvoice SD Document
KEY FiscalYear G/L Fiscal Year
CompanyCode CompanyCode Receiver Company Code
CompanyCodeName _CompanyCode CompanyCodeName Company Name
Supplier InvoicingParty Supplier
SupplierName _Supplier SupplierName Supplier Name
DocumentDate Journal Entry Date
SupplierInvoiceIDByInvcgParty SupplierInvoiceIDByInvcgParty Reference
InvoiceReceiptDate InvoiceReceiptDate Invoice Receipt Date
InvoiceGrossAmount InvoiceGrossAmount Gross Invoice Amount
DocumentCurrency DocumentCurrency Document Currency
IsEndOfPurposeBlocked IsEndOfPurposeBlocked Busin. Purp. Cmpltd.

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_APProcessFlowInvoiceVH.
-- 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.

CREATE VIEW C_APProcessFlowInvoiceVH AS
SELECT
  SupplierInvoice,
  cast(FiscalYear as fis_gjahr_no_conv preserving type) AS FiscalYear,
  CompanyCode,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  InvoicingParty AS Supplier,
  _Supplier.SupplierName AS SupplierName,
  cast(DocumentDate as bldat preserving type) AS DocumentDate,
  SupplierInvoiceIDByInvcgParty,
  InvoiceReceiptDate,
  InvoiceGrossAmount,
  DocumentCurrency,
  IsEndOfPurposeBlocked
FROM I_SupplierInvoice
;