SAFT_PTD_SLINV_A

Transparent Table Temporary Data
45 Fields 1 CDS Views

SAF-T PT Sales Invoice Analytics

SAFT_PTD_SLINV_A is an SAP database table in S/4HANA. SAF-T PT Sales Invoice Analytics. It contains 45 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_PT_SAFTSlsInvoiceStructure view_entity from BASIC

Fields (45)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY companycode BUKRS Company Code
KEY pt_saftdocumentnumber SAFT_PT_DOCUMENTNUMBER Document Number
KEY pt_saftlinenumber SAFT_PT_DOCLINENUMBER Line Numb
KEY portugueseinvoicedate DATS Date
pt_seriesdocumentnumber GLO_PT_ATCUD ATCUD Code
documentbillingstatus FKSAA Ord.Rel.BillgSt
documenttype DOKAR Document Type
documenttransaction FIEU_TRANSID Transaction ID
sourcedocument CDS_SOURCE_DOCUMENT Document
unitofmeasure MEINS Base Unit
unitofmeasurename MSEHT Meas. Unit Text
taxreportingdate VATDATE Tax Reporting Date
quantity QUAN1_12 Quantity
businesspartnercustomer abap.char
companycodecurrency WAERS Currency
pt_saftunitpricevalue SAFT_LINEAMOUNT LineAmount
pt_saftdebitlinevalue SAFT_DEBITLINEAMOUNT DebAmount
pt_saftcreditlinevalue SAFT_CREDITLINEAMOUNT CredAmount
pt_saftcashdiscountvalue SAFT_DISCOUNTLINEAMOUNT DsctAmount
pt_saftinvoicereference SAFT_PT_DOCUMENTNUMBER Document Number
sddocumentreasontext BEZEI40 Description
destinationlocationname TEXT40 Name
actualdeliverydate CO_LTRMI Delivery Date
transpdestlocationcityname /SCMTMS/DEST_LOC_CITY Destination City
transpdestlocationpostalcode /SCMTMS/DEST_LOC_ZIP Destination ZIP Code
transpordstagedestloccntry /SCMTMS/VDM_STG_DEST_COUNTRY Stage Destination Location Ctry/Region
transpordsrcelocationname /SCMTMS/VDM_SRC_LOC_NAME Source Location Name
transpsourcelocationpostalcode /SCMTMS/SOURCE_LOC_ZIP Source ZIP Code
transpordstagesrceloccntry LAND1 Country/Reg.
totaltaxamount WMWST_SHL Tax Amount
totalnetamount NETWR_AK Net Value
totalgrossamount SDBIL_ODATA_TOTAL_AMOUNT Total Amount
transactioncurrency FIS_RWCUR Transaction Currency
invoiceamountinfrgncurrency FIS_REFWR Invc. Amt Frgn Crcy
exchangerate FIS_EXCHANGE_RATE Exchange Rate
taxrate FITAXRATE Tax Rate
pt_safttaxcode SAFT_PT_TAX_CODE Tax Code
taxamount WMWST_SHL Tax Amount
pt_safttaxtype SAFT_PT_TAX_TYPE Tax Type
pt_saftcountrytext PT_SAFT_COUNTRY Country
exemptionreason abap.char
exemptionreasontext abap.char
pt_saftproductcode SAFT_PT_PRODUCTCODE ProductCd
productdescription MAKTX Description

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 Sales Invoice Analytics
-- Category TRANSPARENT · Delivery class L
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SAFT_PTD_SLINV_A (
    MANDT,                           -- Client [MANDT]
    COMPANYCODE,                     -- Company Code [BUKRS]
    PT_SAFTDOCUMENTNUMBER,           -- Document Number [SAFT_PT_DOCUMENTNUMBER]
    PT_SAFTLINENUMBER,               -- Line Numb [SAFT_PT_DOCLINENUMBER]
    PORTUGUESEINVOICEDATE,           -- Date [DATS]
    PT_SERIESDOCUMENTNUMBER,         -- ATCUD Code [GLO_PT_ATCUD]
    DOCUMENTBILLINGSTATUS,           -- Ord.Rel.BillgSt [FKSAA]
    DOCUMENTTYPE,                    -- Document Type [DOKAR]
    DOCUMENTTRANSACTION,             -- Transaction ID [FIEU_TRANSID]
    SOURCEDOCUMENT,                  -- Document [CDS_SOURCE_DOCUMENT]
    UNITOFMEASURE,                   -- Base Unit [MEINS]
    UNITOFMEASURENAME,               -- Meas. Unit Text [MSEHT]
    TAXREPORTINGDATE,                -- Tax Reporting Date [VATDATE]
    QUANTITY,                        -- Quantity [QUAN1_12]
    BUSINESSPARTNERCUSTOMER,         -- abap.char
    COMPANYCODECURRENCY,             -- Currency [WAERS]
    PT_SAFTUNITPRICEVALUE,           -- LineAmount [SAFT_LINEAMOUNT]
    PT_SAFTDEBITLINEVALUE,           -- DebAmount [SAFT_DEBITLINEAMOUNT]
    PT_SAFTCREDITLINEVALUE,          -- CredAmount [SAFT_CREDITLINEAMOUNT]
    PT_SAFTCASHDISCOUNTVALUE,        -- DsctAmount [SAFT_DISCOUNTLINEAMOUNT]
    PT_SAFTINVOICEREFERENCE,         -- Document Number [SAFT_PT_DOCUMENTNUMBER]
    SDDOCUMENTREASONTEXT,            -- Description [BEZEI40]
    DESTINATIONLOCATIONNAME,         -- Name [TEXT40]
    ACTUALDELIVERYDATE,              -- Delivery Date [CO_LTRMI]
    TRANSPDESTLOCATIONCITYNAME,      -- Destination City [/SCMTMS/DEST_LOC_CITY]
    TRANSPDESTLOCATIONPOSTALCODE,    -- Destination ZIP Code [/SCMTMS/DEST_LOC_ZIP]
    TRANSPORDSTAGEDESTLOCCNTRY,      -- Stage Destination Location Ctry/Region [/SCMTMS/VDM_STG_DEST_COUNTRY]
    TRANSPORDSRCELOCATIONNAME,       -- Source Location Name [/SCMTMS/VDM_SRC_LOC_NAME]
    TRANSPSOURCELOCATIONPOSTALCODE,  -- Source ZIP Code [/SCMTMS/SOURCE_LOC_ZIP]
    TRANSPORDSTAGESRCELOCCNTRY,      -- Country/Reg. [LAND1]
    TOTALTAXAMOUNT,                  -- Tax Amount [WMWST_SHL]
    TOTALNETAMOUNT,                  -- Net Value [NETWR_AK]
    TOTALGROSSAMOUNT,                -- Total Amount [SDBIL_ODATA_TOTAL_AMOUNT]
    TRANSACTIONCURRENCY,             -- Transaction Currency [FIS_RWCUR]
    INVOICEAMOUNTINFRGNCURRENCY,     -- Invc. Amt Frgn Crcy [FIS_REFWR]
    EXCHANGERATE,                    -- Exchange Rate [FIS_EXCHANGE_RATE]
    TAXRATE,                         -- Tax Rate [FITAXRATE]
    PT_SAFTTAXCODE,                  -- Tax Code [SAFT_PT_TAX_CODE]
    TAXAMOUNT,                       -- Tax Amount [WMWST_SHL]
    PT_SAFTTAXTYPE,                  -- Tax Type [SAFT_PT_TAX_TYPE]
    PT_SAFTCOUNTRYTEXT,              -- Country [PT_SAFT_COUNTRY]
    EXEMPTIONREASON,                 -- abap.char
    EXEMPTIONREASONTEXT,             -- abap.char
    PT_SAFTPRODUCTCODE,              -- ProductCd [SAFT_PT_PRODUCTCODE]
    PRODUCTDESCRIPTION,              -- Description [MAKTX]
    PRIMARY KEY (MANDT, COMPANYCODE, PT_SAFTDOCUMENTNUMBER, PT_SAFTLINENUMBER, PORTUGUESEINVOICEDATE)
);

Learn More