TFK045E SAP (Returns Activities (Returns Lot)) Table details
Dictionary Type: Table
Description: Returns Activities (Returns Lot)
Description: Returns Activities (Returns Lot)
Table field list including key, data, relationships and ABAP select examples
TFK045E is a standard SAP Table which is used to store Returns Activities (Returns Lot) data and is available within R/3 SAP systems depending on the version and release level.
The TFK045E table consists of various fields, each holding specific information or linking keys about Returns Activities (Returns Lot) data available in SAP. These include OPBUK (Company Code), RLGRD (Return reason), HBKID (Short Key for a House Bank), RLANZ (Number Of Returns That Occurred in The Observation Period).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: C - Customising table, maintenance only by custDisplay/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
Text table = TFK045ET
SAP TFK045E table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
OPBUK | Company Code | BUKRS | CHAR | 4 | T001 | BUKRS | BUK | C_T001 | |
RLGRD | Return reason | RLGRD_KK | CHAR | 3 | TFK045A | RLGRD_KK | |||
HBKID | Short Key for a House Bank | HBKID | CHAR | 5 | Assigned to domain | HBKID | |||
RLANZ | Number Of Returns That Occurred in The Observation Period | RLANZ_KK | NUMC | 2 | RLANZ_KK | ||||
BONIT | Creditworthiness | BONIT_KK | NUMC | 4 | BONIT_KK | ||||
TOGRU | Tolerance group for contract account | TOGRU_KK | CHAR | 4 | TFK043 | TOGRU_KK | |||
XGEBV | Pass On Bank Charges | XGEBV_KK | CHAR | 1 | XFELD | ||||
XGEBS | Calculate Graduated Charges | XGEBS_KK | CHAR | 1 | XFELD | ||||
XEZSP | Field is obsolete | XEZSP_KK | CHAR | 1 | XFELD | ||||
XEZSB | Field is obsolete | XEZSB_KK | CHAR | 1 | XFELD | ||||
STUNT | Deferral days | STUNT_KK | NUMC | 3 | STUNT_KK | ||||
MSPOP | Dunning Lock Reason for Line Item | MSPOP_KK | CHAR | 1 | TFK047S | MANSP_KK | |||
MSPOP_DAYS | Item dunning lock: days | MSPOP_DAYS_KK | INT4 | 10 | INT4 | ||||
PSPOP | Payment lock reason for item | PSPOP_KK | CHAR | 1 | TFK008 | SPZAH_KK | |||
PSPOP_DAYS | Payment lock for incoming payments: Duration in days | PSPOP_DAYS_KK | INT4 | 10 | INT4 | ||||
MSPKO | Dunning lock reason for contract account | MSPKO_KK | CHAR | 1 | TFK047S | MANSP_KK | |||
MSPKO_DAYS | Contract acct dunn. lock: days | MSPKO_DAYS_KK | INT4 | 10 | INT4 | ||||
EZSKO | Reason for Lock on Incoming Payment for Contract Account | EZSKO_KK | CHAR | 1 | TFK008 | SPZAH_KK | |||
EZSKO_DAYS | Contract account incoming payment lock: Duration in days | EZSKO_DAYS_KK | INT4 | 10 | INT4 | ||||
AZSKO | Reason for Outgoing Payment Lock for Contract Account | AZSKO_KK | CHAR | 1 | TFK008 | SPZAH_KK | |||
AZSKO_DAYS | Contract account outgoing payments lock: Duration in days | AZSKO_DAYS_KK | INT4 | 10 | INT4 | ||||
EZAWE | Incoming Payment Method | EZAWE_KK | CHAR | 1 | CHAR1 | ||||
GEBST | Post Charges Statistically | GEBST_KK | CHAR | 1 | XFELD | ||||
MACHG | Activate Event for Changing Master Data | MACHG_KK | CHAR | 1 | XFELD | ||||
BSNTE | Inform Specialist | BSNTE_KK | CHAR | 1 | XFELD | ||||
BCORR | Activate Event for Creating Correspondence | BCORR_KK | CHAR | 1 | XFELD | ||||
XDELEZAWE | Delete payment method with account instead of changing | XDELEZAWE_KK | CHAR | 1 | XDELEZAWE_KK | ||||
XDELAZAWE | Returns Activity: Delete Outgoing Payment Method in Account | XDELAZAWE_KK | CHAR | 1 | XFELD | ||||
EZVTG | Incoming Payment Lock in Contract | EZVTG_KK | CHAR | 1 | TFK008 | SPZAH_KK | |||
EZVTG_DAYS | Incoming Payment Lock in Contract: Duration in Days | EZVTG_DAYS_KK | INT4 | 10 | |||||
AZVTG | Outgoing Payment Lock Reason for Contract | AZVTG_KK | CHAR | 1 | TFK008 | SPZAH_KK | |||
AZVTG_DAYS | Outgoing Payment Lock Contract: Duration in Days | AZVTG_DAYS_KK | INT4 | 10 | |||||
MSVTG | Dunning Lock Reason for Contract | MSVTG_KK | CHAR | 1 | TFK047S | MANSP_KK | |||
MSVTG_DAYS | Dunning Lock in Contract: Duration in Days | MSVTG_DAYS_KK | INT4 | 10 | |||||
XDELPZAWE | Delete Payment Method in Item | XDELPZAWE_KK | CHAR | 1 | XDELPZAWE_KK | ||||
XCORPZAWE | Change Pymt Meth. in Item | XCORPZAWE_KK | CHAR | 1 | XCORPZAWE_KK | ||||
XNEWBV | Reaction to Changed Bank Details Returns | XNEWBV_KK | CHAR | 1 | XNEWBV_KK | ||||
XRLGRD | Return reason | RLGRD_KK | CHAR | 3 | TFK045A | RLGRD_KK | |||
INFCON | Write Entry in Information Container | INFCON_KK | CHAR | 1 | XFELD | ||||
XPPRV | Reverse Prepaid Refill | XPPRV_KK | CHAR | 1 | XFELD | ||||
XCHPP | Debit Charges to Prepaid Account | XCHPP_KK | CHAR | 1 | XFELD | ||||
DELMANDUSE | Delete Use in Mandate | DELMANDUSE_KK | CHAR | 1 | DELMANDUSE_KK | ||||
NEWMANDSTAT | SEPA: Mandate Status | SEPA_STATUS | CHAR | 1 | SEPA_STATUS | ||||
LOCKIBAN_DAYS | Duration of Lock for Mandate in Days | LOCKIBAN_DAYS_KK | NUMC | 3 | LOCKIBAN_DAYS_KK |
Key field | Non-key field |
How do I retrieve data from SAP table TFK045E using ABAP code
The following ABAP code Example will allow you to do a basic selection on TFK045E to SELECT all data from the tableDATA: WA_TFK045E TYPE TFK045E.
SELECT SINGLE *
FROM TFK045E
INTO CORRESPONDING FIELDS OF WA_TFK045E
WHERE...
How to access SAP table TFK045E
Within an ECC or HANA version of SAP you can also view further information about TFK045E and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects