TFIBLMPVAR
Online Payment: Variants
TFIBLMPVAR is an SAP database table in S/4HANA. Online Payment: Variants. It contains 25 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_PaytReqVariantPaymentData | view_entity | from | BASIC | Payt Data Variant For Payt Request |
Fields (25)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | MANDT | Client | |||
| KEY | origin | FIBL_ORIGIN | Origin | |||
| KEY | var_id | FIBL_OPVAR | Variant Name | |||
| pay_comp_code | PRQ_ZBUKR | Paying CoCd | ||||
| housebankid | HBKID | House Bank | ||||
| housebankacctid | HKTID | Account ID | ||||
| paym_curr | PRQ_PACUR | Paymnt currency | ||||
| paym_amount | PRQ_AMTFC | PC Amount | ||||
| loc_currcy | HWAER | Local Currency | ||||
| loc_amount | DMBTR | Amount in LC | ||||
| paym_method | RZAWE | Payment Method | ||||
| item_text | REFTXT | Reference Text: | ||||
| indiv_payment | FIBL_XPORE | Single payment | ||||
| instr_key | DTAWS | Instruction Key | ||||
| instr1 | DTAT16 | Instruct. Key 1 | ||||
| instr2 | DTAT17 | Instruct. Key 2 | ||||
| instr3 | DTAT18 | Instruct. key 3 | ||||
| instr4 | DTAT19 | Instruct. key 4 | ||||
| scbank_ind | LZBKZ | SCB Ind. | ||||
| supcountry | LANDL | Supply C/R | ||||
| chainid | CHAINID | Bank Chain ID | ||||
| pmtmthsupl | UZAWE | Pmnt Meth. Sup. | ||||
| paymt_ref | KIDNO | Payment Ref. | ||||
| tax_no_1 | STCD1 | Tax Number 1 | ||||
| tax_no_1_master | XFELD | Checkbox |
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 TFIBLMPVAR (
MANDT, -- Client [MANDT]
ORIGIN, -- Origin [FIBL_ORIGIN]
VAR_ID, -- Variant Name [FIBL_OPVAR]
PAY_COMP_CODE, -- Paying CoCd [PRQ_ZBUKR]
HOUSEBANKID, -- House Bank [HBKID]
HOUSEBANKACCTID, -- Account ID [HKTID]
PAYM_CURR, -- Paymnt currency [PRQ_PACUR]
PAYM_AMOUNT, -- PC Amount [PRQ_AMTFC]
LOC_CURRCY, -- Local Currency [HWAER]
LOC_AMOUNT, -- Amount in LC [DMBTR]
PAYM_METHOD, -- Payment Method [RZAWE]
ITEM_TEXT, -- Reference Text: [REFTXT]
INDIV_PAYMENT, -- Single payment [FIBL_XPORE]
INSTR_KEY, -- Instruction Key [DTAWS]
INSTR1, -- Instruct. Key 1 [DTAT16]
INSTR2, -- Instruct. Key 2 [DTAT17]
INSTR3, -- Instruct. key 3 [DTAT18]
INSTR4, -- Instruct. key 4 [DTAT19]
SCBANK_IND, -- SCB Ind. [LZBKZ]
SUPCOUNTRY, -- Supply C/R [LANDL]
CHAINID, -- Bank Chain ID [CHAINID]
PMTMTHSUPL, -- Pmnt Meth. Sup. [UZAWE]
PAYMT_REF, -- Payment Ref. [KIDNO]
TAX_NO_1, -- Tax Number 1 [STCD1]
TAX_NO_1_MASTER, -- Checkbox [XFELD]
PRIMARY KEY (MANDT, ORIGIN, VAR_ID)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA