TFIBLFFPVAR

Transparent Table Application Table
32 Fields 1 CDS Views

Online Payment: Variants

TFIBLFFPVAR is an SAP database table in S/4HANA. Online Payment: Variants. It contains 32 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_PaytReqVariantPostingData view_entity from BASIC Post Data Variant for Payt Request

Fields (32)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY var_id FIBL_OPVAR Variant Name
name DZNME1 Name
acct_hold KOINH_FI Account holder
bank_ctry BANKS Bank Ctry/Reg.
bank_key BANKK Bank Key
bank_acct BANKN Bank Account
ctrl_key BKONT Control Key
bank_ref BKREF Reference
comp_code BUKRS Company Code
bus_area GSBER Business Area
acct_type BF_KOARTAV Account type
debited_acct DEBITED_ACCT Account
doc_ref_txt INTREF Item Text
doc_type BLART Document Type
formofaddr ANRED Title
name_2 NAME2_GP Name 2
name_3 NAME3_GP Name 3
name_4 NAME4_GP Name 4
postl_code PSTLZ Postal Code
city ORT01_GP City
pobx_pcd PSTL2 PO Box PCode
street STRAS_GP Street
po_box PFACH PO Box
country LAND1 Country/Reg.
region REGIO Region
fax_number TELFX Fax Number
langu SPRAS Language
tax_no_1 STCD1 Tax Number 1
zpayment_system PAYEE_PAYMENT_SYSTEM Payee Payment System
zalias_type PAYEE_ALIAS_TYPE Payee Alias Type
zbank_alias PAYEE_BANK_ALIAS Payee Alias

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.

-- Online Payment: Variants
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TFIBLFFPVAR (
    MANDT,            -- Client [MANDT]
    VAR_ID,           -- Variant Name [FIBL_OPVAR]
    NAME,             -- Name [DZNME1]
    ACCT_HOLD,        -- Account holder [KOINH_FI]
    BANK_CTRY,        -- Bank Ctry/Reg. [BANKS]
    BANK_KEY,         -- Bank Key [BANKK]
    BANK_ACCT,        -- Bank Account [BANKN]
    CTRL_KEY,         -- Control Key [BKONT]
    BANK_REF,         -- Reference [BKREF]
    COMP_CODE,        -- Company Code [BUKRS]
    BUS_AREA,         -- Business Area [GSBER]
    ACCT_TYPE,        -- Account type [BF_KOARTAV]
    DEBITED_ACCT,     -- Account [DEBITED_ACCT]
    DOC_REF_TXT,      -- Item Text [INTREF]
    DOC_TYPE,         -- Document Type [BLART]
    FORMOFADDR,       -- Title [ANRED]
    NAME_2,           -- Name 2 [NAME2_GP]
    NAME_3,           -- Name 3 [NAME3_GP]
    NAME_4,           -- Name 4 [NAME4_GP]
    POSTL_CODE,       -- Postal Code [PSTLZ]
    CITY,             -- City [ORT01_GP]
    POBX_PCD,         -- PO Box PCode [PSTL2]
    STREET,           -- Street [STRAS_GP]
    PO_BOX,           -- PO Box [PFACH]
    COUNTRY,          -- Country/Reg. [LAND1]
    REGION,           -- Region [REGIO]
    FAX_NUMBER,       -- Fax Number [TELFX]
    LANGU,            -- Language [SPRAS]
    TAX_NO_1,         -- Tax Number 1 [STCD1]
    ZPAYMENT_SYSTEM,  -- Payee Payment System [PAYEE_PAYMENT_SYSTEM]
    ZALIAS_TYPE,      -- Payee Alias Type [PAYEE_ALIAS_TYPE]
    ZBANK_ALIAS,      -- Payee Alias [PAYEE_BANK_ALIAS]
    PRIMARY KEY (MANDT, VAR_ID)
);

Learn More