DFKKZW
Zweifelhafte/einzelwertberichtigte Forderungen - Trigger
DFKKZW is an SAP database table in S/4HANA. Zweifelhafte/einzelwertberichtigte Forderungen - Trigger. It contains 35 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_CAValueAdjmtInactiveValnArea | view | from | BASIC | View for DFKKZW and DFKKZW2 |
Fields (35)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | mandt | Client | |||
| KEY | opbel | opbel_kk | Document Number | |||
| KEY | opupw | opupw_kk | Repetition Item | |||
| KEY | opupk | opupk_kk | Item | |||
| bukrs | bukrs | Company Code | ||||
| gpart | gpart_kk | Bus. Partner | ||||
| vkont | vkont_kk | Contract Acct | ||||
| waers | waers_kk | Currency | ||||
| offbt | offbt_kk | Open amount | ||||
| awstb | awstb_kk | IVA Calc. Type | ||||
| budat | wzdat_kk | DoubtEntryDate | ||||
| kennz | kennz_kk | Dbtfl/IVA indicator | ||||
| grund | grund_kk | Adj. reason | ||||
| prozt | prozt_kk | Percent (0-100%) | ||||
| rgrnd | rgrnd_kk | Reset Reason | ||||
| redat | redat_kk | Reset date | ||||
| ernam | ernam_kk | Created By | ||||
| ecpdt | cpudt | Entered On | ||||
| ecptm | cputm | Entered at | ||||
| aenam | aenam_kk | Changed By | ||||
| acpdt | acpdt_kk | Changed On | ||||
| acptm | acptm_kk | Changed At | ||||
| wzkon | wzkon_kk | DoubtEntryAcct | ||||
| wbako | wbako_kk | ExpAccValAdjust | ||||
| wbkko | wbkko_kk | AdjAcct:ValAdj. | ||||
| wzkko | wzkko_kk | Adjustmnt acct | ||||
| wbeko | wbeko_kk | RevAcct val.adj | ||||
| wbbtr | wbbtr_kk | Spec. Val.Adj.Amt | ||||
| bwber | bwber_kk | Valuation Area | ||||
| wbsko | wbsko_kk | Tax A/c Ind.Val.Adj. | ||||
| c4eye | c4eye_kk | Check Reason | ||||
| cologrp | cologrp_bp_kk | Col.GroupBus.Partner | ||||
| ecl_rate | fins_ecl_rate | ECL Rate (%) | ||||
| incrmnt | fins_incrmnt | Increment | ||||
| aging | fins_aging | Aging |
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.
-- Zweifelhafte/einzelwertberichtigte Forderungen - Trigger
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE DFKKZW (
MANDT, -- Client [mandt]
OPBEL, -- Document Number [opbel_kk]
OPUPW, -- Repetition Item [opupw_kk]
OPUPK, -- Item [opupk_kk]
BUKRS, -- Company Code [bukrs]
GPART, -- Bus. Partner [gpart_kk]
VKONT, -- Contract Acct [vkont_kk]
WAERS, -- Currency [waers_kk]
OFFBT, -- Open amount [offbt_kk]
AWSTB, -- IVA Calc. Type [awstb_kk]
BUDAT, -- DoubtEntryDate [wzdat_kk]
KENNZ, -- Dbtfl/IVA indicator [kennz_kk]
GRUND, -- Adj. reason [grund_kk]
PROZT, -- Percent (0-100%) [prozt_kk]
RGRND, -- Reset Reason [rgrnd_kk]
REDAT, -- Reset date [redat_kk]
ERNAM, -- Created By [ernam_kk]
ECPDT, -- Entered On [cpudt]
ECPTM, -- Entered at [cputm]
AENAM, -- Changed By [aenam_kk]
ACPDT, -- Changed On [acpdt_kk]
ACPTM, -- Changed At [acptm_kk]
WZKON, -- DoubtEntryAcct [wzkon_kk]
WBAKO, -- ExpAccValAdjust [wbako_kk]
WBKKO, -- AdjAcct:ValAdj. [wbkko_kk]
WZKKO, -- Adjustmnt acct [wzkko_kk]
WBEKO, -- RevAcct val.adj [wbeko_kk]
WBBTR, -- Spec. Val.Adj.Amt [wbbtr_kk]
BWBER, -- Valuation Area [bwber_kk]
WBSKO, -- Tax A/c Ind.Val.Adj. [wbsko_kk]
C4EYE, -- Check Reason [c4eye_kk]
COLOGRP, -- Col.GroupBus.Partner [cologrp_bp_kk]
ECL_RATE, -- ECL Rate (%) [fins_ecl_rate]
INCRMNT, -- Increment [fins_incrmnt]
AGING, -- Aging [fins_aging]
PRIMARY KEY (MANDT, OPBEL, OPUPW, OPUPK)
);
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