DFKKZWFP

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: Umgeb. Ford.
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE DFKKZWFP (
    MANDT,       -- Client [mandt]
    OPBEL,       -- Document Number [opbel_kk]
    OPUPW,       -- Repetition Item [opupw_kk]
    OPUPK,       -- Item [opupk_kk]
    BUDAT,       -- Posting Date [budat_kk]
    BWBER,       -- Valuation Area [bwber_kk]
    LFDNR,       -- Sequence Number [lfdnr_kk]
    BUKRS,       -- Company Code [bukrs]
    GPART,       -- Bus. Partner [gpart_kk]
    VKONT,       -- Contract Acct [vkont_kk]
    WAERS,       -- Currency [waers_kk]
    WBUBT,       -- Vl.Aj Postd Amt [wbubt_kk]
    WBUDT,       -- ValAdjTransDate [wbudt_kk]
    SBETU,       -- Posted tax amt [sbetu_kk]
    SBETW,       -- Tax Amount [sbetw_kk]
    WZUBT,       -- Doubt.post. amt [wzubt_kk]
    WZUDT,       -- TrDateDoubtEn [wzudt_kk]
    BFBDT,       -- DoubtEntryDate [wzdat_kk]
    PROZT,       -- Percent (0-100%) [prozt_kk]
    WBBTR,       -- Spec. Val.Adj.Amt [wbbtr_kk]
    WFZBT,       -- Doubtful Amount [wfzbt_kk]
    EWBBT,       -- ValAdj Amt [ewbbt_kk]
    GRUND,       -- Adj. reason [grund_kk]
    RGRND,       -- Reset Reason [rgrnd_kk]
    REDAT,       -- Reset date [redat_kk]
    AENAM,       -- Changed By [aenam_kk]
    ACPDT,       -- Changed On [acpdt_kk]
    ACPTM,       -- Changed At [acptm_kk]
    FIKEY,       -- Reconcil. Key [fikey_kk]
    LAUFD,       -- Date ID [laufd_kk]
    LAUFI,       -- Run ID [laufi_kk]
    WZKON,       -- DoubtEntryAcct [wzkon_kk]
    WBAKO,       -- ExpAccValAdjust [wbako_kk]
    WBKKO,       -- AdjAcct:ValAdj. [wbkko_kk]
    WZKKO,       -- Adjustmnt acct [wzkko_kk]
    STOZW,       -- Rev adj rec [stozw_kk]
    GBRAB,       -- Val. Adj. Reset [gbrab_kk]
    GSRAB,       -- ValAdjResetAmt [gsrab_kk]
    GBRZB,       -- Val. Adj. Reset [gbrzb_kk]
    GSRZB,       -- Adj.ResetAmount [gsrzb_kk]
    WBRAK,       -- Reset/Write-Off [wbrak_kk]
    WBRZK,       -- Reset/Payment [wbrzk_kk]
    GBRWB,       -- AmtPstdVAResetChng [gbrwb_kk]
    GSRWB,       -- TtlAmtVAResetChng [gsrwb_kk]
    WBRWK,       -- AcctResetVAChange [wbrwk_kk]
    GBRVB,       -- AmtPstdVAResetS [gbrvb_kk]
    GSRVB,       -- TtlAmtVAResetSale [gsrvb_kk]
    WBRVK,       -- AcctResetVASale [wbrvk_kk]
    GBRSB,       -- AmtPstdVAResetR [gbrsb_kk]
    GSRSB,       -- TtlAmtVAResetRev. [gsrsb_kk]
    WBRSK,       -- AcctResetVARev [wbrsk_kk]
    WBNET,       -- Net Amount [wbnet_kk]
    WBSKO,       -- Tax A/c Ind.Val.Adj. [wbsko_kk]
    COLOGRP,     -- Col.GroupBus.Partner [cologrp_bp_kk]
    RISK_CLASS,  -- Risk Class [ukm_risk_class]
    ECL_RATE,    -- ECL Rate (%) [fins_ecl_rate]
    INCRMNT,     -- Increment [fins_incrmnt]
    AGING,       -- Aging [fins_aging]
    VA_PURPOSE,  -- VA Purpose [va_purpose_kk]
    BWVAR,       -- Valuation Variant [bwvar_kk_obsolete]
    DWBUBTH,     -- Transfer amt of value adjustment in local currency [wbubth_kk]
    DWBUBT2,     -- Transfer Amt of Value Adjustment in Parallel Currency 2 [wbubt2_kk]
    DWBUBT3,     -- Transfer amt of value adjustment in parallel currency 3 [wbubt3_kk]
    EWBBTH,      -- ValAdj Amt [ewbbth_kk]
    EWBBT2,      -- ValAdj Amt [ewbbt2_kk]
    EWBBT3,      -- ValAdj Amt [ewbbt3_kk]
    GBRABH,      -- Val. Adj. Reset [gbrabh_kk]
    GBRAB2,      -- Val. Adj. Reset [gbrab2_kk]
    GBRAB3,      -- Val. Adj. Reset [gbrab3_kk]
    GSRABH,      -- ValAdjResetAmt [gsrabh_kk]
    GSRAB2,      -- ValAdjResetAmt [gsrab2_kk]
    GSRAB3,      -- ValAdjResetAmt [gsrab3_kk]
    GBRZBH,      -- Val. Adj. Reset [gbrzbh_kk]
    GBRZB2,      -- Val. Adj. Reset [gbrzb2_kk]
    GBRZB3,      -- Val. Adj. Reset [gbrzb3_kk]
    GSRZBH,      -- ValAdjResetAmt [gsrzbh_kk]
    GSRZB2,      -- ValAdjResetAmt [gsrzb2_kk]
    GSRZB3,      -- ValAdjResetAmt [gsrzb3_kk]
    GBRWBH,      -- AmtPstdVAResetChng [gbrwbh_kk]
    GBRWB2,      -- AmtPstdVAResetChng [gbrwb2_kk]
    GBRWB3,      -- AmtPstdVAResetChng [gbrwb3_kk]
    GSRWBH,      -- TtlAmtVAResetChng [gsrwbh_kk]
    GSRWB2,      -- TtlAmtVAResetChng [gsrwb2_kk]
    GSRWB3,      -- TtlAmtVAResetChng [gsrwb3_kk]
    GBRVBH,      -- AmtPstdVAResetS [gbrvbh_kk]
    GBRVB2,      -- AmtPstdVAResetS [gbrvb2_kk]
    GBRVB3,      -- AmtPstdVAResetS [gbrvb3_kk]
    GSRVBH,      -- TtlAmtVAResetSale [gsrvbh_kk]
    GSRVB2,      -- TtlAmtVAResetSale [gsrvb2_kk]
    GSRVB3,      -- TtlAmtVAResetSale [gsrvb3_kk]
    GBRSBH,      -- AmtPstdVAResetR [gbrsbh_kk]
    GBRSB2,      -- AmtPstdVAResetR [gbrsb2_kk]
    GBRSB3,      -- AmtPstdVAResetR [gbrsb3_kk]
    GSRSBH,      -- TtlAmtVAResetRev. [gsrsbh_kk]
    GSRSB2,      -- TtlAmtVAResetRev. [gsrsb2_kk]
    GSRSB3,      -- TtlAmtVAResetRev. [gsrsb3_kk]
    GBFXBH,      -- ValAdjRealizedAmt [gbfxbh_kk]
    GBFXB2,      -- ValAdjRealizedAmt [gbfxb2_kk]
    GBFXB3,      -- ValAdjRealizedAmt [gbfxb3_kk]
    GRFXBH,      -- ValAdjRealizedAmt [grfxbh_kk]
    GRFXB2,      -- ValAdjRealizedAmt [grfxb2_kk]
    GRFXB3,      -- ValAdjRealizedAmt [grfxb3_kk]
    WFXLKO,      -- Valuation loss [wfxlko_kk]
    WFXGKO,      -- Valuation Gains [wfxgko_kk]
    GBRTB,       -- AmtPstdResetTyChg [gbrtb_kk]
    GBRTBH,      -- AmtPstdResetTyChg [gbrtbh_kk]
    GBRTB2,      -- AmtPstdResetTyChg [gbrtb2_kk]
    GBRTB3,      -- AmtPstdResetTyChg [gbrtb3_kk]
    GSRTB,       -- TtlAmtVAResetTypChg [gsrtb_kk]
    GSRTBH,      -- TtlAmtVAResetTypChg [gsrtbh_kk]
    GSRTB2,      -- TtlAmtVAResetTypChg [gsrtb2_kk]
    GSRTB3,      -- TtlAmtVAResetTypChg [gsrtb3_kk]
    WBRTK_G,     -- Valuation Gains [wbrtk_g_kk]
    WBRTK_L,     -- Valuation loss [wbrtk_l_kk]
    AWSTB,       -- IVA Calc. Type [awstb_kk]
    PRIMARY KEY (MANDT, OPBEL, OPUPW, OPUPK, BUDAT, BWBER, LFDNR)
);