T047A SAP (Account Level Dunning Control) Pooled Table details
Dictionary Type: Pooled Table
Description: Account Level Dunning Control
Description: Account Level Dunning Control
Pooled Table field list including key, data, relationships and ABAP select examples
T047A is a standard SAP Pooled Table which is used to store Account Level Dunning Control data and is available within R/3 SAP systems depending on the version and release level.
The T047A table consists of various fields, each holding specific information or linking keys about Account Level Dunning Control data available in SAP. These include MAHNA (Dunning Procedure), RHYTH (Dunning Interval in Days), MIVRZ (Days in arrears after which a dunning notice will be sent), KULEP (Grace periods per line item).. 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 = T047T
SAP T047A pooled 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 | |||
| MAHNA | Dunning Procedure | MAHNA | CHAR | 4 | MAHNA | ||||
| RHYTH | Dunning Interval in Days | RHYTH_047A | NUMC | 3 | NUM03 | ||||
| MIVRZ | Days in arrears after which a dunning notice will be sent | MIVRZ_047A | NUMC | 3 | NUM03 | ||||
| KULEP | Grace periods per line item | KULEP_047A | NUMC | 3 | NUM03 | ||||
| UMSKD | List of special G/L indicators to be edited | UMSKL_047A | CHAR | 20 | CHAR20 | ||||
| UMSKK | List of special G/L indicators to be edited | UMSKL_047A | CHAR | 20 | CHAR20 | ||||
| XNUMS | Include standard transactions? | XNUMS_047A | CHAR | 1 | XFELD | ||||
| VZSKZ | Interest calculation indicator for calc. of dunning interest | VZSKZ_047A | CHAR | 2 | T056 | VZSKZ | |||
| MAHNR | Reference Dunning Procedure for Text Selection | MAHNA_REF | CHAR | 4 | T047A | MAHNA | |||
| MAHNS | Dunning level from which all due items are to be totaled | MAHNS_047A | NUMC | 1 | MAHNS | ||||
| KALID | Public holiday calendar key | HIDENT_47A | CHAR | 2 | THOCI | HIDENT | HCI | ||
| XMGER | Always Print Dunning Notice in Legal Dunning Procedure? | XMGER_047A | CHAR | 1 | XFELD | ||||
| XSALSH | Dunning Notice Even for Credit Account Balance | XSALSH_047A | CHAR | 1 | XFELD |
| Key field | Non-key field |
How do I retrieve data from SAP table T047A using ABAP code
The following ABAP code Example will allow you to do a basic selection on T047A to SELECT all data from the tableDATA: WA_T047A TYPE T047A.
SELECT SINGLE *
FROM T047A
INTO CORRESPONDING FIELDS OF WA_T047A
WHERE...
How to access SAP table T047A
Within an ECC or HANA version of SAP you can also view further information about T047A 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