I_PT_SAFTINVOICELISTITEM

CDS View
23 Fields 3 CDS Views

SAF-T PT Invoice List Item

I_PT_SAFTINVOICELISTITEM is a CDS View in S/4HANA. SAF-T PT Invoice List Item. It contains 23 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
C_PT_SAFTBillingItemOrderRef view union CONSUMPTION SAF-T Sales Invoice Order References
C_PT_SAFTSalesInvoiceItemC view union CONSUMPTION SAF-T PT Sales Invoice Item Cube
C_PT_SAFTSlsInvoiceItmRef view union CONSUMPTION SAF-T PT Sales Invoice Item References

Fields (23)

KeyField CDS FieldsUsed in Views
KEY CompanyCode CompanyCode 1
KEY DocumentReferenceID InvoiceReference 1
KEY PortugueseInvoiceNumber PortugueseInvoiceNumber 3
KEY SalesDocument SalesDocument 1
ActiveTaxType TaxType 1
BillingDocumentItemText BillingDocumentItemText 1
CompanyCurrency CompanyCurrency 1
ConditionAmount NetAmount 1
ConditionRateValue TaxRate 1
ConditionType PortugueseMaterialWithVersion 1
ControlNature TargetTaxCode 1
CountryCreditRating TaxReturnCountry 1
DocumentBillingStatus DocumentBillingStatus 1
ExemptionReason ExemptionReason 1
ExemptionReasonText ExemptionReasonText 1
NetAmount NetAmount 1
PortugueseInvoiceDate PortugueseInvoiceDate 1
Quantity Quantity 1
SDDocumentReason SDDocumentReason 1
TaxAmount TaxAmount 1
TaxCode TaxCode 1
TaxRate TaxRate 1
UnitOfMeasure UnitOfMeasure 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.

-- SAF-T PT Invoice List Item
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_PT_SAFTINVOICELISTITEM (
    COMPANYCODE,
    DOCUMENTREFERENCEID,
    PORTUGUESEINVOICENUMBER,
    SALESDOCUMENT,
    ACTIVETAXTYPE,
    BILLINGDOCUMENTITEMTEXT,
    COMPANYCURRENCY,
    CONDITIONAMOUNT,
    CONDITIONRATEVALUE,
    CONDITIONTYPE,
    CONTROLNATURE,
    COUNTRYCREDITRATING,
    DOCUMENTBILLINGSTATUS,
    EXEMPTIONREASON,
    EXEMPTIONREASONTEXT,
    NETAMOUNT,
    PORTUGUESEINVOICEDATE,
    QUANTITY,
    SDDOCUMENTREASON,
    TAXAMOUNT,
    TAXCODE,
    TAXRATE,
    UNITOFMEASURE,
    PRIMARY KEY (COMPANYCODE, DOCUMENTREFERENCEID, PORTUGUESEINVOICENUMBER, SALESDOCUMENT)
);

Learn More