I_PT_SAFTBILLGINVCLISTITEM

CDS View
17 Fields 5 CDS Views

Invoice List Document Item

I_PT_SAFTBILLGINVCLISTITEM is a CDS View in S/4HANA. Invoice List Document Item. It contains 17 fields. 5 CDS views read from this table.

CDS Views using this table (5)

ViewTypeJoinVDMDescription
C_PT_SAFTBillgSlsInvcItemC view_entity union CONSUMPTION Sales Invoices Document Item - Cube
C_PT_SAFTSlsItemOrdRef view_entity union CONSUMPTION Sales Inv Header Order References - Cube
C_PT_SAFTSlsItemRef view_entity union CONSUMPTION Sales Invoices Line References - Cube
I_PT_SAFTBillgInvcListItmAmt view_entity from COMPOSITE Invoice List Items Amount
I_PT_SAFTBillgInvcListProd view_entity from COMPOSITE Product from Invoice List Document

Fields (17)

KeyField CDS FieldsUsed in Views
KEY CompanyCode CompanyCode 2
KEY PortugueseInvoiceDate PortugueseInvoiceDate 1
KEY Product Product 1
KEY PT_SAFTDocumentNumber PT_SAFTDocumentNumber 3
KEY PT_SAFTLineNumber PT_SAFTLineNumber 3
KEY SalesDocument SalesDocument 1
BillingPlanRule BillingPlanRule 1
CompanyCodeCurrency CompanyCodeCurrency 1
DocumentBillingStatus DocumentBillingStatus 1
ExchangeRateDate ExchangeRateDate 1
ReferenceDocSDDocCategory ReferenceDocSDDocCategory 1
SalesDocumentDate InvoiceDate,SalesDocumentDate 2
SDDocumentCategory SDDocumentCategory 1
TotalGrossAmount TotalGrossAmount 1
TotalNetAmount TotalNetAmount 1
TotalTaxAmount TotalTaxAmount 1
TransactionCurrency TransactionCurrency 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.

-- Invoice List Document Item
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_PT_SAFTBILLGINVCLISTITEM (
    COMPANYCODE,
    PORTUGUESEINVOICEDATE,
    PRODUCT,
    PT_SAFTDOCUMENTNUMBER,
    PT_SAFTLINENUMBER,
    SALESDOCUMENT,
    BILLINGPLANRULE,
    COMPANYCODECURRENCY,
    DOCUMENTBILLINGSTATUS,
    EXCHANGERATEDATE,
    REFERENCEDOCSDDOCCATEGORY,
    SALESDOCUMENTDATE,
    SDDOCUMENTCATEGORY,
    TOTALGROSSAMOUNT,
    TOTALNETAMOUNT,
    TOTALTAXAMOUNT,
    TRANSACTIONCURRENCY,
    PRIMARY KEY (COMPANYCODE, PORTUGUESEINVOICEDATE, PRODUCT, PT_SAFTDOCUMENTNUMBER, PT_SAFTLINENUMBER, SALESDOCUMENT)
);

Learn More