T042IY
Kontenfindung für Zahlprogramme
T042IY is an SAP database table in S/4HANA. Kontenfindung für Zahlprogramme. It contains 12 fields. 2 CDS views read from this table.
CDS Views using this table (2)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_HouseBankPaymentMethRankOrd | view_entity | from | BASIC | Ranked account for payment method |
| I_HouseBkAcctInPaymentConfign | view | union | BASIC | House Bank Acct in payment configuration |
Fields (12)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | mandt | Client | |||
| KEY | zbukr | dzbukr | Paying co. code | |||
| KEY | hbkid | hbkid | House Bank | |||
| KEY | zlsch | dzlsch | Pymt Meth. | |||
| KEY | waers | waers | Currency | |||
| KEY | appli | fibl_applid | Program Indicator | |||
| KEY | rangf | fibl_042iy_order | Ranking Order | |||
| hktid | hktid | Account ID | ||||
| ukont | ukont_042i | Bank Subacct | ||||
| vkont | vkont_042i | Clearing Account | ||||
| gebkz | gebkz | Charge Ind. | ||||
| gsber | gsber_bank | Bus. Area |
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.
-- Kontenfindung für Zahlprogramme
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE T042IY (
MANDT, -- Client [mandt]
ZBUKR, -- Paying co. code [dzbukr]
HBKID, -- House Bank [hbkid]
ZLSCH, -- Pymt Meth. [dzlsch]
WAERS, -- Currency [waers]
APPLI, -- Program Indicator [fibl_applid]
RANGF, -- Ranking Order [fibl_042iy_order]
HKTID, -- Account ID [hktid]
UKONT, -- Bank Subacct [ukont_042i]
VKONT, -- Clearing Account [vkont_042i]
GEBKZ, -- Charge Ind. [gebkz]
GSBER, -- Bus. Area [gsber_bank]
PRIMARY KEY (MANDT, ZBUKR, HBKID, ZLSCH, WAERS, APPLI, RANGF)
);
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