SAFT_PTD_WOKD_A

Transparent Table Temporary Data
33 Fields 1 CDS Views

SAF-T PT Working Document Analytics

SAFT_PTD_WOKD_A is an SAP database table in S/4HANA. SAF-T PT Working Document Analytics. It contains 33 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_PT_SAFTWorkingDocStructure view_entity from BASIC

Fields (33)

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
documenttype DOKAR Document Type
sourcedocument CDS_SOURCE_DOCUMENT Document
companycodecurrency WAERS Currency
documentbillingstatus FKSAA Ord.Rel.BillgSt
businesspartnercustomer abap.char
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
portuguesematerialwithversion SIPT_MATNR_WITH_VERSION Material w/ Version
materialname MAKTX Description
quantity QUAN1_12 Quantity
unitofmeasure MEINS Base Unit
unitofmeasurename MSEHT Meas. Unit Text
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_saftunitpricevalue SAFT_LINEAMOUNT LineAmount
pt_saftdebitlinevalue SAFT_DEBITLINEAMOUNT DebAmount
pt_saftcreditlinevalue SAFT_CREDITLINEAMOUNT CredAmount
pt_saftcashdiscountvalue SAFT_DISCOUNTLINEAMOUNT DsctAmount

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 Working Document Analytics
-- Category TRANSPARENT · Delivery class L
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SAFT_PTD_WOKD_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]
    DOCUMENTTYPE,                   -- Document Type [DOKAR]
    SOURCEDOCUMENT,                 -- Document [CDS_SOURCE_DOCUMENT]
    COMPANYCODECURRENCY,            -- Currency [WAERS]
    DOCUMENTBILLINGSTATUS,          -- Ord.Rel.BillgSt [FKSAA]
    BUSINESSPARTNERCUSTOMER,        -- abap.char
    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]
    PORTUGUESEMATERIALWITHVERSION,  -- Material w/ Version [SIPT_MATNR_WITH_VERSION]
    MATERIALNAME,                   -- Description [MAKTX]
    QUANTITY,                       -- Quantity [QUAN1_12]
    UNITOFMEASURE,                  -- Base Unit [MEINS]
    UNITOFMEASURENAME,              -- Meas. Unit Text [MSEHT]
    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_SAFTUNITPRICEVALUE,          -- LineAmount [SAFT_LINEAMOUNT]
    PT_SAFTDEBITLINEVALUE,          -- DebAmount [SAFT_DEBITLINEAMOUNT]
    PT_SAFTCREDITLINEVALUE,         -- CredAmount [SAFT_CREDITLINEAMOUNT]
    PT_SAFTCASHDISCOUNTVALUE,       -- DsctAmount [SAFT_DISCOUNTLINEAMOUNT]
    PRIMARY KEY (MANDT, COMPANYCODE, PT_SAFTDOCUMENTNUMBER, PT_SAFTLINENUMBER, PORTUGUESEINVOICEDATE)
);

Learn More