DFKKZWFP

Transparent Table Application Table
115 Fields 2 CDS Views

Doubtful/Individually Adjusted Receivables: Tfrd Receivables

DFKKZWFP is an SAP database table in S/4HANA. Doubtful/Individually Adjusted Receivables: Tfrd Receivables. It contains 115 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_CAValueAdjmtActiveValnArea view from BASIC View for DFKKZWFP
I_CAValueAdjustmentPosting view from BASIC Basic view of table DFKKZWFP

Fields (115)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY opbel OPBEL_KK Document Number
KEY opupw OPUPW_KK Repetition Item
KEY opupk OPUPK_KK Item
KEY budat BUDAT_KK Posting Date
KEY bwber BWBER_KK Valuation Area
KEY lfdnr LFDNR_KK Sequence Number
bukrs BUKRS Company Code
gpart GPART_KK Bus. Partner
vkont VKONT_KK Contract Acct
waers WAERS_KK Currency
wbubt WBUBT_KK Vl.Aj Postd Amt
wbudt WBUDT_KK ValAdjTransDate
sbetu SBETU_KK Posted tax amt
sbetw SBETW_KK Tax Amount
wzubt WZUBT_KK Doubt.post. amt
wzudt WZUDT_KK TrDateDoubtEn
bfbdt WZDAT_KK DoubtEntryDate
prozt PROZT_KK Percent (0-100%)
wbbtr WBBTR_KK Spec. Val.Adj.Amt
wfzbt WFZBT_KK Doubtful Amount
ewbbt EWBBT_KK ValAdj Amt
grund GRUND_KK Adj. reason
rgrnd RGRND_KK Reset Reason
redat REDAT_KK Reset date
aenam AENAM_KK Changed By
acpdt ACPDT_KK Changed On
acptm ACPTM_KK Changed At
fikey FIKEY_KK Reconcil. Key
laufd LAUFD_KK Date ID
laufi LAUFI_KK Run ID
wzkon WZKON_KK DoubtEntryAcct
wbako WBAKO_KK ExpAccValAdjust
wbkko WBKKO_KK AdjAcct:ValAdj.
wzkko WZKKO_KK Adjustmnt acct
stozw STOZW_KK Rev adj rec
gbrab GBRAB_KK Val. Adj. Reset
gsrab GSRAB_KK ValAdjResetAmt
gbrzb GBRZB_KK Val. Adj. Reset
gsrzb GSRZB_KK Adj.ResetAmount
wbrak WBRAK_KK Reset/Write-Off
wbrzk WBRZK_KK Reset/Payment
gbrwb GBRWB_KK AmtPstdVAResetChng
gsrwb GSRWB_KK TtlAmtVAResetChng
wbrwk WBRWK_KK AcctResetVAChange
gbrvb GBRVB_KK AmtPstdVAResetS
gsrvb GSRVB_KK TtlAmtVAResetSale
wbrvk WBRVK_KK AcctResetVASale
gbrsb GBRSB_KK AmtPstdVAResetR
gsrsb GSRSB_KK TtlAmtVAResetRev.
wbrsk WBRSK_KK AcctResetVARev
wbnet WBNET_KK Net Amount
wbsko WBSKO_KK Tax A/c Ind.Val.Adj.
cologrp COLOGRP_BP_KK Col.GroupBus.Partner
risk_class UKM_RISK_CLASS Risk Class
ecl_rate FINS_ECL_RATE ECL Rate (%)
incrmnt FINS_INCRMNT Increment
aging FINS_AGING Aging
va_purpose VA_PURPOSE_KK VA Purpose
bwvar BWVAR_KK_OBSOLETE Valuation Variant
dwbubth WBUBTH_KK Transfer amt of value adjustment in local currency
dwbubt2 WBUBT2_KK Transfer Amt of Value Adjustment in Parallel Currency 2
dwbubt3 WBUBT3_KK Transfer amt of value adjustment in parallel currency 3
ewbbth EWBBTH_KK ValAdj Amt
ewbbt2 EWBBT2_KK ValAdj Amt
ewbbt3 EWBBT3_KK ValAdj Amt
gbrabh GBRABH_KK Val. Adj. Reset
gbrab2 GBRAB2_KK Val. Adj. Reset
gbrab3 GBRAB3_KK Val. Adj. Reset
gsrabh GSRABH_KK ValAdjResetAmt
gsrab2 GSRAB2_KK ValAdjResetAmt
gsrab3 GSRAB3_KK ValAdjResetAmt
gbrzbh GBRZBH_KK Val. Adj. Reset
gbrzb2 GBRZB2_KK Val. Adj. Reset
gbrzb3 GBRZB3_KK Val. Adj. Reset
gsrzbh GSRZBH_KK ValAdjResetAmt
gsrzb2 GSRZB2_KK ValAdjResetAmt
gsrzb3 GSRZB3_KK ValAdjResetAmt
gbrwbh GBRWBH_KK AmtPstdVAResetChng
gbrwb2 GBRWB2_KK AmtPstdVAResetChng
gbrwb3 GBRWB3_KK AmtPstdVAResetChng
gsrwbh GSRWBH_KK TtlAmtVAResetChng
gsrwb2 GSRWB2_KK TtlAmtVAResetChng
gsrwb3 GSRWB3_KK TtlAmtVAResetChng
gbrvbh GBRVBH_KK AmtPstdVAResetS
gbrvb2 GBRVB2_KK AmtPstdVAResetS
gbrvb3 GBRVB3_KK AmtPstdVAResetS
gsrvbh GSRVBH_KK TtlAmtVAResetSale
gsrvb2 GSRVB2_KK TtlAmtVAResetSale
gsrvb3 GSRVB3_KK TtlAmtVAResetSale
gbrsbh GBRSBH_KK AmtPstdVAResetR
gbrsb2 GBRSB2_KK AmtPstdVAResetR
gbrsb3 GBRSB3_KK AmtPstdVAResetR
gsrsbh GSRSBH_KK TtlAmtVAResetRev.
gsrsb2 GSRSB2_KK TtlAmtVAResetRev.
gsrsb3 GSRSB3_KK TtlAmtVAResetRev.
gbfxbh GBFXBH_KK ValAdjRealizedAmt
gbfxb2 GBFXB2_KK ValAdjRealizedAmt
gbfxb3 GBFXB3_KK ValAdjRealizedAmt
grfxbh GRFXBH_KK ValAdjRealizedAmt
grfxb2 GRFXB2_KK ValAdjRealizedAmt
grfxb3 GRFXB3_KK ValAdjRealizedAmt
wfxlko WFXLKO_KK Valuation loss
wfxgko WFXGKO_KK Valuation Gains
gbrtb GBRTB_KK AmtPstdResetTyChg
gbrtbh GBRTBH_KK AmtPstdResetTyChg
gbrtb2 GBRTB2_KK AmtPstdResetTyChg
gbrtb3 GBRTB3_KK AmtPstdResetTyChg
gsrtb GSRTB_KK TtlAmtVAResetTypChg
gsrtbh GSRTBH_KK TtlAmtVAResetTypChg
gsrtb2 GSRTB2_KK TtlAmtVAResetTypChg
gsrtb3 GSRTB3_KK TtlAmtVAResetTypChg
wbrtk_g WBRTK_G_KK Valuation Gains
wbrtk_l WBRTK_L_KK Valuation loss
awstb AWSTB_KK IVA Calc. Type

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.

-- Doubtful/Individually Adjusted Receivables: Tfrd Receivables
-- 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)
);

Learn More