In this post, I will try and describe everything you need to know about the SAP m047x table. What it is, including what type of data it stores.
A list of fields which make up the table structure and on an S/4Hana System for M047X what does this table look like.
And what relationships it has with other SAP tables.
Also see here for example ABAP code to select data from M047X....Right lets get started!
Object Name: M047X
Dictionary Type: Structure
Description: Help fields for maintaining dunning procedure
| Field | Data Element | Data Type | length (Dec) | Check table | Description | Conversion Routine | Domain Name | MemoryID | AppClass | SHLP | SHLP Field | ConvExit |
| XNEIN | XNEIN | CHAR | 1(0) | Answer to question asked: No | XFELD | FB | ||||||
| XJA | XJA | CHAR | 1(0) | Answer to question asked: Yes | XFELD | FB | ||||||
| MAXST | MAXST | NUMC | 1(0) | Highest Dunning Level of a Dunning Type | MAHNS | FBM | ||||||
| VERT1 | VERTG_047B | NUMC | 3(0) | Days in arrears | NUM03 | FBM | ||||||
| XZIN1 | XZINS_047B | CHAR | 1(0) | Calculate Interest? | XFELD | FBM | ||||||
| XPOS1 | XPOST_047B | CHAR | 1(0) | Print All Items? | XFELD | FBM | ||||||
| XAEN1 | XAEND_047B | CHAR | 1(0) | Send Dunning Notice Although No Changes Were Made? | XFELD | FBM | ||||||
| VERT2 | VERTG_047B | NUMC | 3(0) | Days in arrears | NUM03 | FBM | ||||||
| XZIN2 | XZINS_047B | CHAR | 1(0) | Calculate Interest? | XFELD | FBM | ||||||
| XPOS2 | XPOST_047B | CHAR | 1(0) | Print All Items? | XFELD | FBM | ||||||
| XAEN2 | XAEND_047B | CHAR | 1(0) | Send Dunning Notice Although No Changes Were Made? | XFELD | FBM | ||||||
| VERT3 | VERTG_047B | NUMC | 3(0) | Days in arrears | NUM03 | FBM | ||||||
| XZIN3 | XZINS_047B | CHAR | 1(0) | Calculate Interest? | XFELD | FBM | ||||||
| XPOS3 | XPOST_047B | CHAR | 1(0) | Print All Items? | XFELD | FBM | ||||||
| XAEN3 | XAEND_047B | CHAR | 1(0) | Send Dunning Notice Although No Changes Were Made? | XFELD | FBM | ||||||
| VERT4 | VERTG_047B | NUMC | 3(0) | Days in arrears | NUM03 | FBM | ||||||
| XZIN4 | XZINS_047B | CHAR | 1(0) | Calculate Interest? | XFELD | FBM | ||||||
| XPOS4 | XPOST_047B | CHAR | 1(0) | Print All Items? | XFELD | FBM | ||||||
| XAEN4 | XAEND_047B | CHAR | 1(0) | Send Dunning Notice Although No Changes Were Made? | XFELD | FBM | ||||||
| VERT5 | VERTG_047B | NUMC | 3(0) | Days in arrears | NUM03 | FBM | ||||||
| XZIN5 | XZINS_047B | CHAR | 1(0) | Calculate Interest? | XFELD | FBM | ||||||
| XPOS5 | XPOST_047B | CHAR | 1(0) | Print All Items? | XFELD | FBM | ||||||
| XAEN5 | XAEND_047B | CHAR | 1(0) | Send Dunning Notice Although No Changes Were Made? | XFELD | FBM | ||||||
| VERT6 | VERTG_047B | NUMC | 3(0) | Days in arrears | NUM03 | FBM | ||||||
| XZIN6 | XZINS_047B | CHAR | 1(0) | Calculate Interest? | XFELD | FBM | ||||||
| XPOS6 | XPOST_047B | CHAR | 1(0) | Print All Items? | XFELD | FBM | ||||||
| XAEN6 | XAEND_047B | CHAR | 1(0) | Send Dunning Notice Although No Changes Were Made? | XFELD | FBM | ||||||
| VERT7 | VERTG_047B | NUMC | 3(0) | Days in arrears | NUM03 | FBM | ||||||
| XZIN7 | XZINS_047B | CHAR | 1(0) | Calculate Interest? | XFELD | FBM | ||||||
| XPOS7 | XPOST_047B | CHAR | 1(0) | Print All Items? | XFELD | FBM | ||||||
| XAEN7 | XAEND_047B | CHAR | 1(0) | Send Dunning Notice Although No Changes Were Made? | XFELD | FBM | ||||||
| VERT8 | VERTG_047B | NUMC | 3(0) | Days in arrears | NUM03 | FBM | ||||||
| XZIN8 | XZINS_047B | CHAR | 1(0) | Calculate Interest? | XFELD | FBM | ||||||
| XPOS8 | XPOST_047B | CHAR | 1(0) | Print All Items? | XFELD | FBM | ||||||
| XAEN8 | XAEND_047B | CHAR | 1(0) | Send Dunning Notice Although No Changes Were Made? | XFELD | FBM | ||||||
| VERT9 | VERTG_047B | NUMC | 3(0) | Days in arrears | NUM03 | FBM | ||||||
| XZIN9 | XZINS_047B | CHAR | 1(0) | Calculate Interest? | XFELD | FBM | ||||||
| XPOS9 | XPOST_047B | CHAR | 1(0) | Print All Items? | XFELD | FBM | ||||||
| XAEN9 | XAEND_047B | CHAR | 1(0) | Send Dunning Notice Although No Changes Were Made? | XFELD | FBM | ||||||
| WAERS | WAERS | CUKY | 5(0) | TCURC | Currency Key | WAERS | FWS | FB | ||||
| WAER1 | WAERS | CUKY | 5(0) | TCURC | Currency Key | WAERS | FWS | FB | ||||
| BUKRS | BUKRS | CHAR | 4(0) | T001 | Company Code | BUKRS | BUK | FB | C_T001 | BUKRS | ||
| KOART | KOART | CHAR | 1(0) | Account Type | KOART | FB | ||||||
| UMSK1 | UMSKZ | CHAR | 1(0) | T074U | Special G/L Indicator | UMSKZ | FB | |||||
| TEXT1 | LTEXT_074T | CHAR | 30(0) | Long Text for Special G/L Indicators | TEXT30 | FB | ||||||
| UMSK2 | UMSKZ | CHAR | 1(0) | T074U | Special G/L Indicator | UMSKZ | FB | |||||
| TEXT2 | LTEXT_074T | CHAR | 30(0) | Long Text for Special G/L Indicators | TEXT30 | FB | ||||||
| XSUMS | XSUMS_047X | CHAR | 1(0) | Dun special G/L transactions? | XFELD | FBM | ||||||
| XFLD1 | XFELD_047X | CHAR | 1(0) | Indicator: Will the special G/L indicator be dunned ? | XFELD | FBM | ||||||
| XFLD2 | XFELD_047X | CHAR | 1(0) | Indicator: Will the special G/L indicator be dunned ? | XFELD | FBM | ||||||
| XDEBI | XDEBI_047A | CHAR | 1(0) | Indicator: Customer account type? | XFELD | |||||||
| XKRED | XKRED_047A | CHAR | 1(0) | Indicator: Vendor account type? | XFELD | |||||||
| JAPOS1 | VVJAPOS | CHAR | 1(0) | Indicator: Print cleared items ? | XFELD | |||||||
| ATAP1 | VVATAP | NUMC | 3(0) | Period for cleared items in days | NUM03 | |||||||
| JAPOS2 | VVJAPOS | CHAR | 1(0) | Indicator: Print cleared items ? | XFELD | |||||||
| ATAP2 | VVATAP | NUMC | 3(0) | Period for cleared items in days | NUM03 | |||||||
| JAPOS3 | VVJAPOS | CHAR | 1(0) | Indicator: Print cleared items ? | XFELD | |||||||
| ATAP3 | VVATAP | NUMC | 3(0) | Period for cleared items in days | NUM03 | |||||||
| JAPOS4 | VVJAPOS | CHAR | 1(0) | Indicator: Print cleared items ? | XFELD | |||||||
| ATAP4 | VVATAP | NUMC | 3(0) | Period for cleared items in days | NUM03 | |||||||
| JAPOS5 | VVJAPOS | CHAR | 1(0) | Indicator: Print cleared items ? | XFELD | |||||||
| ATAP5 | VVATAP | NUMC | 3(0) | Period for cleared items in days | NUM03 | |||||||
| JAPOS6 | VVJAPOS | CHAR | 1(0) | Indicator: Print cleared items ? | XFELD | |||||||
| ATAP6 | VVATAP | NUMC | 3(0) | Period for cleared items in days | NUM03 | |||||||
| JAPOS7 | VVJAPOS | CHAR | 1(0) | Indicator: Print cleared items ? | XFELD | |||||||
| ATAP7 | VVATAP | NUMC | 3(0) | Period for cleared items in days | NUM03 | |||||||
| JAPOS8 | VVJAPOS | CHAR | 1(0) | Indicator: Print cleared items ? | XFELD | |||||||
| ATAP8 | VVATAP | NUMC | 3(0) | Period for cleared items in days | NUM03 | |||||||
| JAPOS9 | VVJAPOS | CHAR | 1(0) | Indicator: Print cleared items ? | XFELD | |||||||
| ATAP9 | VVATAP | NUMC | 3(0) | Period for cleared items in days | NUM03 |