DFKKRH
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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_CAReturnHistory | view_entity | from | BASIC | Rückläuferhistorie |
Fields (75)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| 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)
);
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