C_SupplierDuplicateInvoice

DDL: C_SUPPLIERDUPLICATEINVOICE Type: view_entity CONSUMPTION Package: FINS_FIS_GRC_APPS
14 Fields 1 Data Sources

Duplicate Suppier Invoice documents

C_SupplierDuplicateInvoice is a Consumption CDS View that provides data about "Duplicate Suppier Invoice documents" in SAP S/4HANA. It reads from 1 data source (P_SupplierDuplicateInvoice) and exposes 14 fields with key fields CompanyCode, FiscalYear, AccountingDocument, DuplicateOplAcctgDocument. Part of development package FINS_FIS_GRC_APPS.

Data Sources (1)

SourceAliasJoin Type
P_SupplierDuplicateInvoice P_SupplierDuplicateInvoice from

Parameters (4)

NameTypeDefault
P_ComparisonDurationInDays grcfc_days
P_AmtComprnVarianceInPercent grcfc_amtvarpctage
P_DuplicateSupplierIsChecked grcfc_dupsuppcheck
P_DplBankAccountIsChecked grcfc_dupbankcheck

Annotations (8)

NameValueLevelField
VDM.viewType #CONSUMPTION view
OData.publish true view
AccessControl.personalData.blocking #REQUIRED view
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MIXED view
EndUserText.label Duplicate Suppier Invoice documents view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode _SupplierAccountingDocument CompanyCode Receiver Company Code
KEY FiscalYear _SupplierAccountingDocument FiscalYear G/L Fiscal Year
KEY AccountingDocument _SupplierAccountingDocument AccountingDocument Accounting Document
KEY DuplicateOplAcctgDocument _SupplierAccountingDocument DuplicateAccountingDocNumber Duplicate Acctg Document
InvoiceGrossAmount _SupplierAccountingDocument InvoiceGrossAmount Invoice Gross Amount
InvoiceAmountInTransactionCrcy _SupplierAccountingDocument DuplicateInvoiceGrossAmount Duplicate Invoice Gross Amount
AccountingDocumentCreationDate _SupplierAccountingDocument AccountingDocumentCreationDate Accounting Document Creation Date
DplOplAcctgDocCreationDate _SupplierAccountingDocument DuplicateDocumentEntryDate Duplicate Acctg Doc Creation Date
Supplier _SupplierAccountingDocument Supplier Supplier
DplOplAcctgDocumentSupplier _SupplierAccountingDocument DuplicateDocumentSupplier Duplicate Acctg Document Supplier
DplOplAcctgDocumentFiscalYear _SupplierAccountingDocument DuplicateDocumentFiscalYear Duplicate Acctg Document FiscalYear
TransactionCurrency _SupplierAccountingDocument TransactionCurrency Transaction Currency
AccountingDocumentType _SupplierAccountingDocument AccountingDocumentType Journal Entry Type
DocumentReferenceID _SupplierAccountingDocument DocumentReferenceID Reference

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_SupplierDuplicateInvoice.
-- 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.
-- Parameters: P_ComparisonDurationInDays : grcfc_days, P_AmtComprnVarianceInPercent : grcfc_amtvarpctage, P_DuplicateSupplierIsChecked : grcfc_dupsuppcheck, P_DplBankAccountIsChecked : grcfc_dupbankcheck

CREATE VIEW C_SupplierDuplicateInvoice AS
SELECT
  _SupplierAccountingDocument.CompanyCode AS CompanyCode,
  _SupplierAccountingDocument.FiscalYear AS FiscalYear,
  _SupplierAccountingDocument.AccountingDocument AS AccountingDocument,
  _SupplierAccountingDocument.DuplicateAccountingDocNumber AS DuplicateOplAcctgDocument,
  _SupplierAccountingDocument.InvoiceGrossAmount AS InvoiceGrossAmount,
  _SupplierAccountingDocument.DuplicateInvoiceGrossAmount AS InvoiceAmountInTransactionCrcy,
  _SupplierAccountingDocument.AccountingDocumentCreationDate AS AccountingDocumentCreationDate,
  _SupplierAccountingDocument.DuplicateDocumentEntryDate AS DplOplAcctgDocCreationDate,
  _SupplierAccountingDocument.Supplier AS Supplier,
  _SupplierAccountingDocument.DuplicateDocumentSupplier AS DplOplAcctgDocumentSupplier,
  _SupplierAccountingDocument.DuplicateDocumentFiscalYear AS DplOplAcctgDocumentFiscalYear,
  _SupplierAccountingDocument.TransactionCurrency AS TransactionCurrency,
  _SupplierAccountingDocument.AccountingDocumentType AS AccountingDocumentType,
  _SupplierAccountingDocument.DocumentReferenceID AS DocumentReferenceID
FROM P_SupplierDuplicateInvoice
;

Learn More