P_SuplrInvcDocFilter

DDL: P_SUPLRINVCDOCFILTER SQL: PSUPINVDOCF Type: view COMPOSITE Package: FINS_FIS_GRC_APPS
12 Fields 1 Data Sources

Supplier Invoice Documents

P_SuplrInvcDocFilter is a Composite CDS View that provides data about "Supplier Invoice Documents" in SAP S/4HANA. It reads from 1 data source (P_SupplierInvoiceDocument) and exposes 12 fields with key fields CompanyCode, FiscalYear, AccountingDocument. Part of development package FINS_FIS_GRC_APPS.

Data Sources (1)

SourceAliasJoin Type
P_SupplierInvoiceDocument _SupplierAccountingDocument from

Parameters (2)

NameTypeDefault
P_DuplicateSupplierIsChecked mm_pur_yes_no
P_Threshold grcfc_threshold

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName PSUPINVDOCF view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.buffering.status #NOT_ALLOWED view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.private true view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode P_SupplierInvoiceDocument CompanyCode Receiver Company Code
KEY FiscalYear P_SupplierInvoiceDocument FiscalYear G/L Fiscal Year
KEY AccountingDocument P_SupplierInvoiceDocument AccountingDocument Journal Entry
AccountingDocumentCreationDate P_SupplierInvoiceDocument AccountingDocumentCreationDate Journal Entry Date
AccountingDocumentType P_SupplierInvoiceDocument AccountingDocumentType Journal Entry Type
DocumentReferenceID P_SupplierInvoiceDocument DocumentReferenceID Reference
Supplier P_SupplierInvoiceDocument Supplier Supplier
InvoiceGrossAmount
TransactionCurrency P_SupplierInvoiceDocument TransactionCurrency Transaction Currency
UpCurrencyAmount
TillCurrencyAmount
SupplierwhenthenendasSameSupplierCheck

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_SuplrInvcDocFilter.
-- 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: PSUPINVDOCF
-- Parameters: P_DuplicateSupplierIsChecked : mm_pur_yes_no, P_Threshold : grcfc_threshold

CREATE VIEW P_SuplrInvcDocFilter AS
SELECT
  _SupplierAccountingDocument.CompanyCode AS CompanyCode,
  _SupplierAccountingDocument.FiscalYear AS FiscalYear,
  _SupplierAccountingDocument.AccountingDocument AS AccountingDocument,
  _SupplierAccountingDocument.AccountingDocumentCreationDate AS AccountingDocumentCreationDate,
  _SupplierAccountingDocument.AccountingDocumentType AS AccountingDocumentType,
  _SupplierAccountingDocument.DocumentReferenceID AS DocumentReferenceID,
  _SupplierAccountingDocument.Supplier AS Supplier,
  ( _SupplierAccountingDocument.InvoiceGrossAmount * -1 ) AS InvoiceGrossAmount,
  _SupplierAccountingDocument.TransactionCurrency AS TransactionCurrency,
  cast( ( _SupplierAccountingDocument.InvoiceGrossAmount * -1 ) * ( 1 + division($parameters.P_Threshold,100,2) ) as abap.curr(23,2)) AS UpCurrencyAmount,
  cast( ( _SupplierAccountingDocument.InvoiceGrossAmount * -1) * ( 1 - division($parameters.P_Threshold,100,2) ) as abap.curr(23,2)) AS TillCurrencyAmount,
  case :P_DuplicateSupplierIsChecked when 'X' then _SupplierAccountingDocument.Supplier when '' then '' end as SameSupplierCheck AS SupplierwhenthenendasSameSupplierCheck
FROM P_SupplierInvoiceDocument AS _SupplierAccountingDocument
;

Learn More