I_INVOICELIST

CDS View
35 Fields 15 CDS Views

Invoice List

I_INVOICELIST is a CDS View in S/4HANA. Invoice List. It contains 35 fields. 15 CDS views read from this table.

CDS Views using this table (15)

ViewTypeJoinVDMDescription
C_InvoiceListObjPg view from CONSUMPTION Invoice List
C_InvoiceListWorklist view from CONSUMPTION Invoice List
ESH_N_INVOICELIST view from Anchor view -INVOICELIST
I_InvoiceListEnhancedFields view_entity from COMPOSITE Invoice List Enhanced Fields
I_InvoiceListStdVH view_entity from COMPOSITE Invoice List
I_PT_BillgDocCustAddrVers view inner COMPOSITE PT BillingDoc CustAddr Version
I_PT_SAFTBillgInvcListHeader view_entity from COMPOSITE Sales Invoice List Document Header
I_PT_SAFTBillingOneTimeAddr view_entity union COMPOSITE One Time Customer Addr for Billing Docs
I_PT_SAFTInvcListSettlement view_entity from COMPOSITE Billing Invoices List Settlement Info
I_PT_SAFTOneTimeCustBillg view_entity union COMPOSITE One Time Customer from Billing Document
I_PT_SAFTSlsInvcBillgCust view_entity inner COMPOSITE Customer from Billing Document
I_SAFTBillingCustomer view union COMPOSITE SAF-T Regular Billing Customers
I_SAFTBillingOneTimeCustomer view union COMPOSITE SAF-T Billing OneTimeCustomers
I_SAFTInvoiceListHeader view from BASIC SAF-T Invoice List Header
P_SAFT_BillDocOnInvoiceList view inner COMPOSITE SAF-T Billing Document On Invoice List

Fields (35)

KeyField CDS FieldsUsed in Views
KEY BillingDocument AccountingDocument,BillingDocument 5
KEY BillingDocumentDate DocumentDate,InvoiceDate 4
KEY CompanyCode CompanyCode 9
KEY FiscalYear FiscalYear 6
KEY InvoiceList BillingDocument,InvoiceList 5
KEY InvoiceListBillingDate BillingDocumentDate,DocumentDate,InvoiceDate 8
KEY PayerParty Customer,PayerParty 7
_AccountingDocument _AccountingDocument 1
_AccountingTransferStatus _AccountingTransferStatus 2
_CancelledInvoiceList _CancelledBillingDocumentBasic 1
_CompanyCode _CompanyCode 3
_CustomerPaymentTerms _CustomerPaymentTerms 1
_InvoiceListType _BillingDocumentType 1
_PayerParty _PayerParty 5
_SalesOrganization _SalesOrganization 2
_TransactionCurrency _TransactionCurrency 1
AccountingDocument AccountingDocument 3
AccountingExchangeRate AccountingExchangeRate 2
AccountingTransferStatus AccountingTransferStatus 4
CancelledInvoiceList CancelledBillingDocument 3
CreatedByUser CreatedByUser 2
CreationDate CreationDate 2
CreationTime CreationTime 2
CustomerPaymentTerms CustomerPaymentTerms 4
DocumentReferenceID DocumentReferenceID 2
ExchangeRateDate ExchangeRateDate 2
InvoiceListIsCancelled BillingDocumentIsCancelled 2
InvoiceListType BillingDocumentType 1
SalesOrganization SalesOrganization 2
SDDocumentCategory SDDocumentCategory 4
TotalNetAmount TotalNetAmount 4
TotalTaxAmount TotalTaxAmount 4
TransactionCurrency TransactionCurrency 6
VATRegistration VATRegistration 3
VATRegistrationCountry VATRegistrationCountry 2

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.

-- Invoice List
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_INVOICELIST (
    BILLINGDOCUMENT,
    BILLINGDOCUMENTDATE,
    COMPANYCODE,
    FISCALYEAR,
    INVOICELIST,
    INVOICELISTBILLINGDATE,
    PAYERPARTY,
    _ACCOUNTINGDOCUMENT,
    _ACCOUNTINGTRANSFERSTATUS,
    _CANCELLEDINVOICELIST,
    _COMPANYCODE,
    _CUSTOMERPAYMENTTERMS,
    _INVOICELISTTYPE,
    _PAYERPARTY,
    _SALESORGANIZATION,
    _TRANSACTIONCURRENCY,
    ACCOUNTINGDOCUMENT,
    ACCOUNTINGEXCHANGERATE,
    ACCOUNTINGTRANSFERSTATUS,
    CANCELLEDINVOICELIST,
    CREATEDBYUSER,
    CREATIONDATE,
    CREATIONTIME,
    CUSTOMERPAYMENTTERMS,
    DOCUMENTREFERENCEID,
    EXCHANGERATEDATE,
    INVOICELISTISCANCELLED,
    INVOICELISTTYPE,
    SALESORGANIZATION,
    SDDOCUMENTCATEGORY,
    TOTALNETAMOUNT,
    TOTALTAXAMOUNT,
    TRANSACTIONCURRENCY,
    VATREGISTRATION,
    VATREGISTRATIONCOUNTRY,
    PRIMARY KEY (BILLINGDOCUMENT, BILLINGDOCUMENTDATE, COMPANYCODE, FISCALYEAR, INVOICELIST, INVOICELISTBILLINGDATE, PAYERPARTY)
);

Learn More