SAFT_PTA_SLV_LOG

Transparent Table Application Table
23 Fields 1 CDS Views

SAf-T Pt: Sales invoice Log

SAFT_PTA_SLV_LOG is an SAP database table in S/4HANA. SAf-T Pt: Sales invoice Log. It contains 23 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_PT_SAFTSalesInvoicesLog view_entity from BASIC Sales Inv Entry Log for PT SAFT Billing

Fields (23)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY statryrptgentity srf_reporting_entity Reporting Entity
KEY statryrptcategory srf_rep_cat_id Report ID
KEY statryrptrunid srf_report_run_id Report Run ID
KEY saftmodule saft_module
KEY companycode bukrs Company Code
KEY portugueseinvoicedate dats Date
KEY pt_saftdocumentnumber saft_pt_documentnumber
pt_seriesdocumentnumber glo_pt_atcud ATCUD Code
documentbillingstatus saft_pt_inv_status Inv.Status
lastchangedatetimetext sipt_sy_date Sys. Date-Time
reversalreasonname fac_rvsl_rsn_name Rev. Reason Name
lastchangedbyuser abp_lastchange_user Changed By
fiscalperiod fins_fiscalperiod Fiscal Period
documenttype char3 3-Byte field
documenttransaction fieu_transid Transaction ID
sourcedocument cds_source_document Document
sourcebillingdocumenttype fkart_von Billing Type
portuguesedigitalsignature sipt_signature_char1333 Digital Signature
portuguesedgtlsgntrkeyversion sipt_key_vers Key Version
createdbyuser ernam Created By
ptdgtlsgntrsystemdatetimetext sipt_sy_date Sys. Date-Time
_dataaging data_temperature Data Aging

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 Log
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SAFT_PTA_SLV_LOG (
    MANDT,                          -- Client [mandt]
    STATRYRPTGENTITY,               -- Reporting Entity [srf_reporting_entity]
    STATRYRPTCATEGORY,              -- Report ID [srf_rep_cat_id]
    STATRYRPTRUNID,                 -- Report Run ID [srf_report_run_id]
    SAFTMODULE,                     -- saft_module
    COMPANYCODE,                    -- Company Code [bukrs]
    PORTUGUESEINVOICEDATE,          -- Date [dats]
    PT_SAFTDOCUMENTNUMBER,          -- saft_pt_documentnumber
    PT_SERIESDOCUMENTNUMBER,        -- ATCUD Code [glo_pt_atcud]
    DOCUMENTBILLINGSTATUS,          -- Inv.Status [saft_pt_inv_status]
    LASTCHANGEDATETIMETEXT,         -- Sys. Date-Time [sipt_sy_date]
    REVERSALREASONNAME,             -- Rev. Reason Name [fac_rvsl_rsn_name]
    LASTCHANGEDBYUSER,              -- Changed By [abp_lastchange_user]
    FISCALPERIOD,                   -- Fiscal Period [fins_fiscalperiod]
    DOCUMENTTYPE,                   -- 3-Byte field [char3]
    DOCUMENTTRANSACTION,            -- Transaction ID [fieu_transid]
    SOURCEDOCUMENT,                 -- Document [cds_source_document]
    SOURCEBILLINGDOCUMENTTYPE,      -- Billing Type [fkart_von]
    PORTUGUESEDIGITALSIGNATURE,     -- Digital Signature [sipt_signature_char1333]
    PORTUGUESEDGTLSGNTRKEYVERSION,  -- Key Version [sipt_key_vers]
    CREATEDBYUSER,                  -- Created By [ernam]
    PTDGTLSGNTRSYSTEMDATETIMETEXT,  -- Sys. Date-Time [sipt_sy_date]
    _DATAAGING,                     -- Data Aging [data_temperature]
    PRIMARY KEY (MANDT, STATRYRPTGENTITY, STATRYRPTCATEGORY, STATRYRPTRUNID, SAFTMODULE, COMPANYCODE, PORTUGUESEINVOICEDATE, PT_SAFTDOCUMENTNUMBER)
);

Learn More