FIAU_SUP_AMT_LOG

Transparent Table Application Table
13 Fields 1 CDS Views

AU TPAR Supplier and its corresponding Amount Log

FIAU_SUP_AMT_LOG is an SAP database table in S/4HANA. AU TPAR Supplier and its corresponding Amount Log. It contains 13 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_AU_StRpTPARSupplierAmountLog view from BASIC Australia TPAR Supplier Amount Log

Fields (13)

KeyField Data ElementDescription DomainTypeLength
KEY client 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 companycode bukrs Company Code
KEY supplier lifnr Supplier
KEY au_tparservicetype fiau_tpar_service_type Service Type
KEY glaccount hkont G/L Acct
KEY au_tpargrantobject fiau_tpar_grant_object TPAR Grant Obj
au_tpargrantdate fiau_tpar_grant_date Grant Date
totalgrossamountincocodecrcy dmbtr Amount in LC
totalvatamtincocodecrcy hwste LC Tax
reportingcurrency waers Currency

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.

-- AU TPAR Supplier and its corresponding Amount Log
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FIAU_SUP_AMT_LOG (
    CLIENT,                        -- Client [mandt]
    STATRYRPTGENTITY,              -- Reporting Entity [srf_reporting_entity]
    STATRYRPTCATEGORY,             -- Report ID [srf_rep_cat_id]
    STATRYRPTRUNID,                -- Report Run ID [srf_report_run_id]
    COMPANYCODE,                   -- Company Code [bukrs]
    SUPPLIER,                      -- Supplier [lifnr]
    AU_TPARSERVICETYPE,            -- Service Type [fiau_tpar_service_type]
    GLACCOUNT,                     -- G/L Acct [hkont]
    AU_TPARGRANTOBJECT,            -- TPAR Grant Obj [fiau_tpar_grant_object]
    AU_TPARGRANTDATE,              -- Grant Date [fiau_tpar_grant_date]
    TOTALGROSSAMOUNTINCOCODECRCY,  -- Amount in LC [dmbtr]
    TOTALVATAMTINCOCODECRCY,       -- LC Tax [hwste]
    REPORTINGCURRENCY,             -- Currency [waers]
    PRIMARY KEY (CLIENT, STATRYRPTGENTITY, STATRYRPTCATEGORY, STATRYRPTRUNID, COMPANYCODE, SUPPLIER, AU_TPARSERVICETYPE, GLACCOUNT, AU_TPARGRANTOBJECT)
);

Learn More