P_SUPPLIERINVOICEDATA

CDS View
25 Fields 1 CDS Views

Supplier Invoice Header Data

P_SUPPLIERINVOICEDATA is a CDS View in S/4HANA. Supplier Invoice Header Data. It contains 25 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_DuplicateSupplierInvoice view from COMPOSITE Suspicious Duplicate Supplier Invoices

Fields (25)

KeyField CDS FieldsUsed in Views
KEY PurchaseOrder PurchaseOrder 1
KEY SupplierInvoice SupplierInvoice 1
AccountingDocument AccountingDocument 1
AccountingDocumentType AccountingDocumentType 1
ChangedByUserName ChangedByUserName 1
ClearingDocumentNumber ClearingDocumentNumber 1
CompanyCode CompanyCode 1
CompanyCodeName CompanyCodeName 1
CreatedByUser CreatedByUser 1
CreatedByUserName CreatedByUserName 1
CurrentDate CurrentDate 1
DocumentCurrency DocumentCurrency 1
DocumentDate DocumentDate 1
FiscalYear FiscalYear 1
FiscalYearPeriod PostingPeriod 1
InvoiceAmountInInvoiceDocCrcy InvoiceAmountInInvoiceDocCrcy 1
InvoiceAmountInReportingCrcy InvoiceAmountInTransactionCrcy 1
InvoicingParty Supplier 1
ItemDescription ItemDescription 1
LastChangedByUser LastChangedByUser 1
PostingDate PostingDate 1
ReferenceDocumentNumber AccountingDocExternalReference 1
ReportingCurrency ReportingCurrency 1
SupplierAccountGroup SupplierAccountGroup 1
SupplierName SupplierName 1

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Supplier Invoice Header Data
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_SUPPLIERINVOICEDATA (
    PURCHASEORDER,
    SUPPLIERINVOICE,
    ACCOUNTINGDOCUMENT,
    ACCOUNTINGDOCUMENTTYPE,
    CHANGEDBYUSERNAME,
    CLEARINGDOCUMENTNUMBER,
    COMPANYCODE,
    COMPANYCODENAME,
    CREATEDBYUSER,
    CREATEDBYUSERNAME,
    CURRENTDATE,
    DOCUMENTCURRENCY,
    DOCUMENTDATE,
    FISCALYEAR,
    FISCALYEARPERIOD,
    INVOICEAMOUNTININVOICEDOCCRCY,
    INVOICEAMOUNTINREPORTINGCRCY,
    INVOICINGPARTY,
    ITEMDESCRIPTION,
    LASTCHANGEDBYUSER,
    POSTINGDATE,
    REFERENCEDOCUMENTNUMBER,
    REPORTINGCURRENCY,
    SUPPLIERACCOUNTGROUP,
    SUPPLIERNAME,
    PRIMARY KEY (PURCHASEORDER, SUPPLIERINVOICE)
);

Learn More