SAFT_PTA_ICUSLOG

Transparent Table Application Table
31 Fields 1 CDS Views

SAF-T PT: Customer Log Table

SAFT_PTA_ICUSLOG is an SAP database table in S/4HANA. SAF-T PT: Customer Log Table. It contains 31 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_PT_SAFTIntgtdCustomerLog view_entity from BASIC Customer Log for PT SAFT Integrated

Fields (31)

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 ledger fins_ledger Ledger
KEY chartofaccounts fis_ktopl Chart of Accounts
KEY companycode bukrs Company Code
KEY businesspartnercustomer abap.char
KEY glaccount fis_racct G/L Account
KEY pt_saftdocumentnumber abap.char
KEY fiscalyear fis_gjahr Fiscal Year
KEY portugueseinvoicedate dats Date
KEY accountingdocument farp_belnr_d Journal Entry
pt_saftreconciliationaccount pt_saft_glaccount
customervatregistration stceg VAT Reg. No.
citclassificationcodedesc ficite_clsfcodename Clsfcn Code Name
isonetimeaccount xcpdk One-time acct
customer kunnr Customer
companyname pt_saft_companyname
companycontactpersonfullname ad_namtext Full Name
streetname ad_street Street
cityname ad_city1 City
postalcode ad_pstcd1 Postal Code
pt_saftcountrytext pt_saft_country
phonenumber ad_tlnmbr Telephone
faxnumber telfx Fax Number
emailaddress ad_smtpadr E-Mail Address
websiteurl text200 Text
billingdocument vbeln_vf Billing Doc.
_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: Customer Log Table
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SAFT_PTA_ICUSLOG (
    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
    LEDGER,                        -- Ledger [fins_ledger]
    CHARTOFACCOUNTS,               -- Chart of Accounts [fis_ktopl]
    COMPANYCODE,                   -- Company Code [bukrs]
    BUSINESSPARTNERCUSTOMER,       -- abap.char
    GLACCOUNT,                     -- G/L Account [fis_racct]
    PT_SAFTDOCUMENTNUMBER,         -- abap.char
    FISCALYEAR,                    -- Fiscal Year [fis_gjahr]
    PORTUGUESEINVOICEDATE,         -- Date [dats]
    ACCOUNTINGDOCUMENT,            -- Journal Entry [farp_belnr_d]
    PT_SAFTRECONCILIATIONACCOUNT,  -- pt_saft_glaccount
    CUSTOMERVATREGISTRATION,       -- VAT Reg. No. [stceg]
    CITCLASSIFICATIONCODEDESC,     -- Clsfcn Code Name [ficite_clsfcodename]
    ISONETIMEACCOUNT,              -- One-time acct [xcpdk]
    CUSTOMER,                      -- Customer [kunnr]
    COMPANYNAME,                   -- pt_saft_companyname
    COMPANYCONTACTPERSONFULLNAME,  -- Full Name [ad_namtext]
    STREETNAME,                    -- Street [ad_street]
    CITYNAME,                      -- City [ad_city1]
    POSTALCODE,                    -- Postal Code [ad_pstcd1]
    PT_SAFTCOUNTRYTEXT,            -- pt_saft_country
    PHONENUMBER,                   -- Telephone [ad_tlnmbr]
    FAXNUMBER,                     -- Fax Number [telfx]
    EMAILADDRESS,                  -- E-Mail Address [ad_smtpadr]
    WEBSITEURL,                    -- Text [text200]
    BILLINGDOCUMENT,               -- Billing Doc. [vbeln_vf]
    _DATAAGING,                    -- Data Aging [data_temperature]
    PRIMARY KEY (MANDT, STATRYRPTGENTITY, STATRYRPTCATEGORY, STATRYRPTRUNID, SAFTMODULE, LEDGER, CHARTOFACCOUNTS, COMPANYCODE, BUSINESSPARTNERCUSTOMER, GLACCOUNT, PT_SAFTDOCUMENTNUMBER, FISCALYEAR, PORTUGUESEINVOICEDATE, ACCOUNTINGDOCUMENT)
);

Learn More