DFKKRH

Transparent Table Application Table

Returns History

DFKKRH is an SAP database table in S/4HANA. Returns History. It contains 75 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_CAReturnHistory view_entity from BASIC Rückläuferhistorie

Fields (75)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY gpart GPART_KK Bus. Partner
KEY vkont VKONT_KK Contract Acct
KEY rlbel RLBEL_KK Returns Doc.
keyr1 KEYR1_KK Returns lot
posra POSRA_KK Item
opbel OPBEL_KK Document Number
urbel URBEL_KK Receivable doc.no.
betrwr BETRWR_KK Partial Amount
betrr BETRR_KK Return amount
btrb1 BTRB1_KK Bank 1 charge
btrb2 BTRB2_KK Bank 2 charge
stbb1 STBB1_KK Tax Bank Chg. 1
stbb2 STBB2_KK Bank 2 tax
btrv1 BTRV1_KK Charge 1
btrv2 BTRV2_KK Charge 2
stbv1 STBV1_KK Tax - Charges 1
stbv2 STBV2_KK Tax on Charge 2
waers WAERS Currency
budat BUDAT_KK Posting Date
bldat BLDAT Document Date
valut VALUT Value date
rlgrd RLGRD_KK Return Reason
bankl GPBANKS BPBank Ctry/Reg
bankk GPBANKK BP bank number
bankn GPBANKN Acct BusPartner
iban IBAN IBAN
checf CHECF_KK Check number
nrzas NRZAS_KK Payment Form
hbkid HBKID House Bank
hktid HKTID Account ID
rlmod RLMOD_KK Type of posting
stodt STODT_KK Reversal date
stblg STBLG_KK Reverse doc. no
xstor XSTOR_KK Reversed
rlanz RLANZ_KK No. of Retrns
bonit BONIT_KK FI-CA Creditwth
togru TOGRU_KK Tolerance group
xgebv XGEBV_KK Pass charges on
xgebs XGEBS_KK Calc.Grad.Chrge
xezsp XEZSP_KK CL item
xezsb XEZSB_KK CL bank
xbvbl XBVBL_KK Delete bank det
stunt STUNT_KK Deferral days
studt STUDT_KK Deferral To
mspop MSPOP_KK Item Dun. Locks
mspop_days MSPOP_DAYS_KK Item dun lock:days
pspop PSPOP_KK Item Pymt Locks
pspop_days PSPOP_DAYS_KK Lock duration days
mspko MSPKO_KK CA Dunning Lock
mspko_days MSPKO_DAYS_KK Dun lock: days
ezsko EZSKO_KK Inc. Pmt Lock
ezsko_days EZSKO_DAYS_KK Lock duration days
azsko AZSKO_KK Out. payt lock
azsko_days AZSKO_DAYS_KK Lock Duration Days
ezawe EZAWE_KK Inc.Payt Method
gebst GEBST_KK Stat. charges
xdelezawe XDELEZAWE_KK Delete PymtMeth
xdelazawe XDELAZAWE_KK Delete outgPMeth
machg MACHG_KK Change Master
bsnte BSNTE_KK Inform Spec.
bcorr BCORR_KK Create Corr.
ezvtg EZVTG_KK IncmPaytLock contr
ezvtg_days EZVTG_DAYS_KK Lock duration days
azvtg AZVTG_KK OutgPayt lock contr.
azvtg_days AZVTG_DAYS_KK Lock Duration Days
msvtg MSVTG_KK Dunn.lock contr
msvtg_days MSVTG_DAYS_KK Dun lock: days
xdelpzawe XDELPZAWE_KK Del. Pymt Method
xcorpzawe XCORPZAWE_KK Change Item PM
versn VERSN_KK Version
infcon INFCON_KK InfoContain
xstor_ranf XSTOR_RANF_KK Rev. Repayt Request
formkey FORMKEY Applicat. form
swift SWIFT SWIFT/BIC

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.

-- Returns History
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE DFKKRH (
    MANDT,       -- Client [MANDT]
    GPART,       -- Bus. Partner [GPART_KK]
    VKONT,       -- Contract Acct [VKONT_KK]
    RLBEL,       -- Returns Doc. [RLBEL_KK]
    KEYR1,       -- Returns lot [KEYR1_KK]
    POSRA,       -- Item [POSRA_KK]
    OPBEL,       -- Document Number [OPBEL_KK]
    URBEL,       -- Receivable doc.no. [URBEL_KK]
    BETRWR,      -- Partial Amount [BETRWR_KK]
    BETRR,       -- Return amount [BETRR_KK]
    BTRB1,       -- Bank 1 charge [BTRB1_KK]
    BTRB2,       -- Bank 2 charge [BTRB2_KK]
    STBB1,       -- Tax Bank Chg. 1 [STBB1_KK]
    STBB2,       -- Bank 2 tax [STBB2_KK]
    BTRV1,       -- Charge 1 [BTRV1_KK]
    BTRV2,       -- Charge 2 [BTRV2_KK]
    STBV1,       -- Tax - Charges 1 [STBV1_KK]
    STBV2,       -- Tax on Charge 2 [STBV2_KK]
    WAERS,       -- Currency [WAERS]
    BUDAT,       -- Posting Date [BUDAT_KK]
    BLDAT,       -- Document Date [BLDAT]
    VALUT,       -- Value date [VALUT]
    RLGRD,       -- Return Reason [RLGRD_KK]
    BANKL,       -- BPBank Ctry/Reg [GPBANKS]
    BANKK,       -- BP bank number [GPBANKK]
    BANKN,       -- Acct BusPartner [GPBANKN]
    IBAN,        -- IBAN [IBAN]
    CHECF,       -- Check number [CHECF_KK]
    NRZAS,       -- Payment Form [NRZAS_KK]
    HBKID,       -- House Bank [HBKID]
    HKTID,       -- Account ID [HKTID]
    RLMOD,       -- Type of posting [RLMOD_KK]
    STODT,       -- Reversal date [STODT_KK]
    STBLG,       -- Reverse doc. no [STBLG_KK]
    XSTOR,       -- Reversed [XSTOR_KK]
    RLANZ,       -- No. of Retrns [RLANZ_KK]
    BONIT,       -- FI-CA Creditwth [BONIT_KK]
    TOGRU,       -- Tolerance group [TOGRU_KK]
    XGEBV,       -- Pass charges on [XGEBV_KK]
    XGEBS,       -- Calc.Grad.Chrge [XGEBS_KK]
    XEZSP,       -- CL item [XEZSP_KK]
    XEZSB,       -- CL bank [XEZSB_KK]
    XBVBL,       -- Delete bank det [XBVBL_KK]
    STUNT,       -- Deferral days [STUNT_KK]
    STUDT,       -- Deferral To [STUDT_KK]
    MSPOP,       -- Item Dun. Locks [MSPOP_KK]
    MSPOP_DAYS,  -- Item dun lock:days [MSPOP_DAYS_KK]
    PSPOP,       -- Item Pymt Locks [PSPOP_KK]
    PSPOP_DAYS,  -- Lock duration days [PSPOP_DAYS_KK]
    MSPKO,       -- CA Dunning Lock [MSPKO_KK]
    MSPKO_DAYS,  -- Dun lock: days [MSPKO_DAYS_KK]
    EZSKO,       -- Inc. Pmt Lock [EZSKO_KK]
    EZSKO_DAYS,  -- Lock duration days [EZSKO_DAYS_KK]
    AZSKO,       -- Out. payt lock [AZSKO_KK]
    AZSKO_DAYS,  -- Lock Duration Days [AZSKO_DAYS_KK]
    EZAWE,       -- Inc.Payt Method [EZAWE_KK]
    GEBST,       -- Stat. charges [GEBST_KK]
    XDELEZAWE,   -- Delete PymtMeth [XDELEZAWE_KK]
    XDELAZAWE,   -- Delete outgPMeth [XDELAZAWE_KK]
    MACHG,       -- Change Master [MACHG_KK]
    BSNTE,       -- Inform Spec. [BSNTE_KK]
    BCORR,       -- Create Corr. [BCORR_KK]
    EZVTG,       -- IncmPaytLock contr [EZVTG_KK]
    EZVTG_DAYS,  -- Lock duration days [EZVTG_DAYS_KK]
    AZVTG,       -- OutgPayt lock contr. [AZVTG_KK]
    AZVTG_DAYS,  -- Lock Duration Days [AZVTG_DAYS_KK]
    MSVTG,       -- Dunn.lock contr [MSVTG_KK]
    MSVTG_DAYS,  -- Dun lock: days [MSVTG_DAYS_KK]
    XDELPZAWE,   -- Del. Pymt Method [XDELPZAWE_KK]
    XCORPZAWE,   -- Change Item PM [XCORPZAWE_KK]
    VERSN,       -- Version [VERSN_KK]
    INFCON,      -- InfoContain [INFCON_KK]
    XSTOR_RANF,  -- Rev. Repayt Request [XSTOR_RANF_KK]
    FORMKEY,     -- Applicat. form [FORMKEY]
    SWIFT,       -- SWIFT/BIC [SWIFT]
    PRIMARY KEY (MANDT, GPART, VKONT, RLBEL)
);