I_PT_SAFTSELFBILLGINVOICEITEM

CDS View

SAF-T PT Self-Billing Invoice Item

I_PT_SAFTSELFBILLGINVOICEITEM is a CDS View in S/4HANA. SAF-T PT Self-Billing Invoice Item. It contains 17 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
C_PT_SAFTSelfBillgInvoiceItemC view from CONSUMPTION SAF-T PT Self-Billing Invoice Item Cube

Fields (17)

KeyField CDS FieldsUsed in Views
KEY CompanyCode CompanyCode 1
KEY DocumentTransaction DocumentTransaction 1
KEY SourceDocumentItem SourceDocumentItem 1
CompanyCodeCurrency CompanyCodeCurrency 1
CreditAmountInCoCodeCrcy CreditAmountInCoCodeCrcy 1
DebitAmountInCoCodeCrcy DebitAmountInCoCodeCrcy 1
DocumentCurrency DocumentCurrency 1
DocumentItemText DocumentItemText 1
MaterialName MaterialName 1
NetPriceAmount NetPriceAmount 1
PortugueseInvoiceDate PortugueseInvoiceDate 1
PortugueseInvoiceNumber PortugueseInvoiceNumber 1
PortugueseMaterialWithVersion PortugueseMaterialWithVersion 1
PurchaseOrder PurchaseOrder 1
PurchaseOrderDate PurchaseOrderDate 1
PurchaseOrderQuantityUnit PurchaseOrderQuantityUnit 1
QuantityInPurchaseOrderUnit QuantityInPurchaseOrderUnit 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 Self-Billing Invoice Item
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_PT_SAFTSELFBILLGINVOICEITEM (
    COMPANYCODE,
    DOCUMENTTRANSACTION,
    SOURCEDOCUMENTITEM,
    COMPANYCODECURRENCY,
    CREDITAMOUNTINCOCODECRCY,
    DEBITAMOUNTINCOCODECRCY,
    DOCUMENTCURRENCY,
    DOCUMENTITEMTEXT,
    MATERIALNAME,
    NETPRICEAMOUNT,
    PORTUGUESEINVOICEDATE,
    PORTUGUESEINVOICENUMBER,
    PORTUGUESEMATERIALWITHVERSION,
    PURCHASEORDER,
    PURCHASEORDERDATE,
    PURCHASEORDERQUANTITYUNIT,
    QUANTITYINPURCHASEORDERUNIT,
    PRIMARY KEY (COMPANYCODE, DOCUMENTTRANSACTION, SOURCEDOCUMENTITEM)
);