I_DuplicateSupplierInvoice

DDL: I_DUPLICATESUPPLIERINVOICE SQL: ISUPPLIERINVOIDS Type: view COMPOSITE Package: ODATA_GRC_FC_CONTROLS
28 Fields 1 Data Sources 2 Associations

Suspicious Duplicate Supplier Invoices

I_DuplicateSupplierInvoice is a Composite CDS View that provides data about "Suspicious Duplicate Supplier Invoices" in SAP S/4HANA. It reads from 1 data source (P_SUPPLIERINVOICEDATA) and exposes 28 fields with key fields SupplierInvoice, PurchaseOrder. It has 2 associations to related views. Part of development package ODATA_GRC_FC_CONTROLS.

Data Sources (1)

SourceAliasJoin Type
P_SUPPLIERINVOICEDATA P_SUPPLIERINVOICEDATA from

Parameters (3)

NameTypeDefault
P_Threshold grcfc_threshold
P_AmountLimit grcfc_rmwwr
P_Currency waers

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_SupplierAccountGroupText _SupplierAccountGroupText P_SUPPLIERINVOICEDATA.SupplierAccountGroup = _SupplierAccountGroupText.SupplierAccountGroup and _SupplierAccountGroupText.Language = $session.system_language
[1..1] I_AccountingDocumentTypeText _AccountingTypeText P_SUPPLIERINVOICEDATA.AccountingDocumentType = _AccountingTypeText.AccountingDocumentType and _AccountingTypeText.Language = $session.system_language

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName ISUPPLIERINVOIDS view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Suspicious Duplicate Supplier Invoices view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
Search.searchable true view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.compositionRoot true view
ObjectModel.representativeKey SupplierInvoice view
AccessControl.personalData.blocking #NOT_REQUIRED view

Fields (28)

KeyFieldSource TableSource FieldDescription
KEY SupplierInvoice P_SUPPLIERINVOICEDATA SupplierInvoice
KEY PurchaseOrder P_SUPPLIERINVOICEDATA PurchaseOrder Purchasing Document
AccountingDocument P_SUPPLIERINVOICEDATA AccountingDocument Journal Entry
FiscalYear P_SUPPLIERINVOICEDATA FiscalYear G/L Fiscal Year
AccountingDocumentType P_SUPPLIERINVOICEDATA AccountingDocumentType Journal Entry Type
AccountingDocumentTypeName _AccountingTypeText AccountingDocumentTypeName
PostingPeriod P_SUPPLIERINVOICEDATA FiscalYearPeriod Period/Year
FiscalYearPeriod
CompanyCode P_SUPPLIERINVOICEDATA CompanyCode Receiver Company Code
CompanyCodeName P_SUPPLIERINVOICEDATA CompanyCodeName Company Name
DocumentDate P_SUPPLIERINVOICEDATA DocumentDate Journal Entry Date
PostingDate P_SUPPLIERINVOICEDATA PostingDate Posting Date for GR
CreatedByUser P_SUPPLIERINVOICEDATA CreatedByUser User Name
LastChangedByUser P_SUPPLIERINVOICEDATA LastChangedByUser User Name
DocumentCurrency P_SUPPLIERINVOICEDATA DocumentCurrency Document Currency
InvoiceAmountInInvoiceDocCrcy P_SUPPLIERINVOICEDATA InvoiceAmountInInvoiceDocCrcy
InvoiceAmountInTransactionCrcy P_SUPPLIERINVOICEDATA InvoiceAmountInReportingCrcy
ReportingCurrency P_SUPPLIERINVOICEDATA ReportingCurrency Currency
SupplierAccountGroup P_SUPPLIERINVOICEDATA SupplierAccountGroup Account group
SupplierAccountGroupName _SupplierAccountGroupText AccountGroupName
Supplier P_SUPPLIERINVOICEDATA InvoicingParty Supplier
SupplierName P_SUPPLIERINVOICEDATA SupplierName Supplier Name
CreatedByUserName P_SUPPLIERINVOICEDATA CreatedByUserName Person Resp.
ChangedByUserName P_SUPPLIERINVOICEDATA ChangedByUserName Full Name
ClearingDocumentNumber P_SUPPLIERINVOICEDATA ClearingDocumentNumber
ItemDescription P_SUPPLIERINVOICEDATA ItemDescription Description
AccountingDocExternalReference P_SUPPLIERINVOICEDATA ReferenceDocumentNumber
CurrentDate P_SUPPLIERINVOICEDATA CurrentDate

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_DuplicateSupplierInvoice.
-- 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: ISUPPLIERINVOIDS
-- Parameters: P_Threshold : grcfc_threshold, P_AmountLimit : grcfc_rmwwr, P_Currency : waers

CREATE VIEW I_DuplicateSupplierInvoice AS
SELECT
  P_SUPPLIERINVOICEDATA.SupplierInvoice AS SupplierInvoice,
  P_SUPPLIERINVOICEDATA.PurchaseOrder AS PurchaseOrder,
  P_SUPPLIERINVOICEDATA.AccountingDocument AS AccountingDocument,
  P_SUPPLIERINVOICEDATA.FiscalYear AS FiscalYear,
  P_SUPPLIERINVOICEDATA.AccountingDocumentType AS AccountingDocumentType,
  _AccountingTypeText.AccountingDocumentTypeName AS AccountingDocumentTypeName,
  P_SUPPLIERINVOICEDATA.FiscalYearPeriod AS PostingPeriod,
  cast(CONCAT( P_SUPPLIERINVOICEDATA.FiscalYear,P_SUPPLIERINVOICEDATA.FiscalYearPeriod ) as abap.numc( 7 )) AS FiscalYearPeriod,
  P_SUPPLIERINVOICEDATA.CompanyCode AS CompanyCode,
  P_SUPPLIERINVOICEDATA.CompanyCodeName AS CompanyCodeName,
  P_SUPPLIERINVOICEDATA.DocumentDate AS DocumentDate,
  P_SUPPLIERINVOICEDATA.PostingDate AS PostingDate,
  P_SUPPLIERINVOICEDATA.CreatedByUser AS CreatedByUser,
  P_SUPPLIERINVOICEDATA.LastChangedByUser AS LastChangedByUser,
  P_SUPPLIERINVOICEDATA.DocumentCurrency AS DocumentCurrency,
  P_SUPPLIERINVOICEDATA.InvoiceAmountInInvoiceDocCrcy AS InvoiceAmountInInvoiceDocCrcy,
  P_SUPPLIERINVOICEDATA.InvoiceAmountInReportingCrcy AS InvoiceAmountInTransactionCrcy,
  P_SUPPLIERINVOICEDATA.ReportingCurrency AS ReportingCurrency,
  P_SUPPLIERINVOICEDATA.SupplierAccountGroup AS SupplierAccountGroup,
  _SupplierAccountGroupText.AccountGroupName AS SupplierAccountGroupName,
  P_SUPPLIERINVOICEDATA.InvoicingParty AS Supplier,
  P_SUPPLIERINVOICEDATA.SupplierName AS SupplierName,
  P_SUPPLIERINVOICEDATA.CreatedByUserName AS CreatedByUserName,
  P_SUPPLIERINVOICEDATA.ChangedByUserName AS ChangedByUserName,
  P_SUPPLIERINVOICEDATA.ClearingDocumentNumber AS ClearingDocumentNumber,
  P_SUPPLIERINVOICEDATA.ItemDescription AS ItemDescription,
  P_SUPPLIERINVOICEDATA.ReferenceDocumentNumber AS AccountingDocExternalReference,
  P_SUPPLIERINVOICEDATA.CurrentDate AS CurrentDate
FROM P_SUPPLIERINVOICEDATA
LEFT OUTER JOIN I_SupplierAccountGroupText AS _SupplierAccountGroupText ON P_SUPPLIERINVOICEDATA.SupplierAccountGroup = _SupplierAccountGroupText.SupplierAccountGroup AND _SupplierAccountGroupText.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN I_AccountingDocumentTypeText AS _AccountingTypeText ON P_SUPPLIERINVOICEDATA.AccountingDocumentType = _AccountingTypeText.AccountingDocumentType AND _AccountingTypeText.Language = $session.system_language  -- association [1..1]
;

Learn More