FIAU_PTR_SBI

Transparent Table Application Table
9 Fields 1 CDS Views

AU PTR Small Business Identification(SBI)

FIAU_PTR_SBI is an SAP database table in S/4HANA. AU PTR Small Business Identification(SBI). It contains 9 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_AU_PTRBusinessIdentification view_entity from BASIC AU PTR Business Identification

Fields (9)

KeyField Data ElementDescription DomainTypeLength
KEY client mandt Client
KEY bukrs bukrs Company Code
KEY lifnr lifnr Supplier
KEY frmdate figen_rep_date_from Reporting Date From
KEY stceg stceg VAT Reg. No.
todate figen_rep_date_to Reporting Date To
usname uname User Name
timestamp timestamp Time Stamp
notsmallbusiness fiau_nonsb_identifier

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 PTR Small Business Identification(SBI)
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FIAU_PTR_SBI (
    CLIENT,            -- Client [mandt]
    BUKRS,             -- Company Code [bukrs]
    LIFNR,             -- Supplier [lifnr]
    FRMDATE,           -- Reporting Date From [figen_rep_date_from]
    STCEG,             -- VAT Reg. No. [stceg]
    TODATE,            -- Reporting Date To [figen_rep_date_to]
    USNAME,            -- User Name [uname]
    TIMESTAMP,         -- Time Stamp [timestamp]
    NOTSMALLBUSINESS,  -- fiau_nonsb_identifier
    PRIMARY KEY (CLIENT, BUKRS, LIFNR, FRMDATE, STCEG)
);

Learn More