VTIAFINKO
Alternative Conditions Underlying
VTIAFINKO is an SAP database table in S/4HANA. Alternative Conditions Underlying. It contains 21 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_FinTransUndrlgAltvCondition | view | from | BASIC | Fin Trans Undrlg Alternative Condition |
Fields (21)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | MANDT | Client | |||
| KEY | rgatt | TI_RGATT | Class | |||
| KEY | rfha | TB_RFHA | Transaction | |||
| KEY | rfhazu | TB_RFHAZU | Activity | |||
| KEY | rkondgr | TB_RKONDGR | Direction | |||
| KEY | rkond | TB_KOND | Condition | |||
| KEY | dguel_kp | DGUEL_KP | Item Eff. From | |||
| KEY | nstufe | NSTUFE | Level Number | |||
| KEY | sformref | TB_XFORMBE | Formula Ref. | |||
| KEY | svarname | TB_VARNAME | Variable | |||
| cruser | TB_CRUSER | Entered By | ||||
| dcrdat | TB_DCRDAT | Entry Date | ||||
| tcrtim | TB_CRTIM | Entry time | ||||
| upuser | TB_UPUSER | Changed By | ||||
| dupdat | TB_DUPDAT | Changed On | ||||
| tuptim | TB_TUPTIM | Time Changed | ||||
| pkond | PKOND | Percentage Rate | ||||
| szsref | SZSREF | Ref. Int. Rate | ||||
| skalid | SKALID | Calendar | ||||
| skalid2 | SKALID | Calendar | ||||
| sherkunft | TB_SHERK | Source |
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.
-- Alternative Conditions Underlying
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE VTIAFINKO (
MANDT, -- Client [MANDT]
RGATT, -- Class [TI_RGATT]
RFHA, -- Transaction [TB_RFHA]
RFHAZU, -- Activity [TB_RFHAZU]
RKONDGR, -- Direction [TB_RKONDGR]
RKOND, -- Condition [TB_KOND]
DGUEL_KP, -- Item Eff. From [DGUEL_KP]
NSTUFE, -- Level Number [NSTUFE]
SFORMREF, -- Formula Ref. [TB_XFORMBE]
SVARNAME, -- Variable [TB_VARNAME]
CRUSER, -- Entered By [TB_CRUSER]
DCRDAT, -- Entry Date [TB_DCRDAT]
TCRTIM, -- Entry time [TB_CRTIM]
UPUSER, -- Changed By [TB_UPUSER]
DUPDAT, -- Changed On [TB_DUPDAT]
TUPTIM, -- Time Changed [TB_TUPTIM]
PKOND, -- Percentage Rate [PKOND]
SZSREF, -- Ref. Int. Rate [SZSREF]
SKALID, -- Calendar [SKALID]
SKALID2, -- Calendar [SKALID]
SHERKUNFT, -- Source [TB_SHERK]
PRIMARY KEY (MANDT, RGATT, RFHA, RFHAZU, RKONDGR, RKOND, DGUEL_KP, NSTUFE, SFORMREF, SVARNAME)
);
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