SAP ABAP Table MHNK (Dunning data (account entries))
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷ CRM (Application Component) Customer Relationship Management
⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
⤷ FBM (Package) Dunning
⤷ CRM (Application Component) Customer Relationship Management
⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
⤷ FBM (Package) Dunning
Basic Data
Table Category | TRANSP | Transparent table |
Transparent table | MHNK | Table Relationship Diagram |
Short Description | Dunning data (account entries) |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | A | Application Table (Master- and Transaction Data) |
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
2 | LAUFD | LAUFD | DATUM | DATS | 8 | 0 | Date on Which the Program Is to Be Run | ||
3 | LAUFI | LAUFI | LAUFI | CHAR | 6 | 0 | Additional Identification | ||
4 | KOART | KOART | KOART | CHAR | 1 | 0 | Account type | ||
5 | BUKRS | BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | T001 | |
6 | KUNNR | KUNNR | KUNNR | CHAR | 10 | 0 | Customer Number | KNA1 | |
7 | LIFNR | LIFNR | LIFNR | CHAR | 10 | 0 | Account Number of Vendor or Creditor | LFA1 | |
8 | CPDKY | CPDKY | TEXT16 | CHAR | 16 | 0 | Sort field for one-time accounts | ||
9 | SKNRZE | KNRZE | KUNNR | CHAR | 10 | 0 | Head office account number (in branch accounts) | KNA1 | |
10 | SMABER | MABER | MABER | CHAR | 2 | 0 | Dunning Area | T047M | |
11 | SMAHSK | MAHNS_D | MAHNS | NUMC | 1 | 0 | Dunning Level | ||
12 | BUSAB | BUSAB_MA | BUSAB | CHAR | 2 | 0 | Dunning clerk | T001S | |
13 | AUSDT | AUSDT_F150 | DATUM | DATS | 8 | 0 | Dunning date | ||
14 | GRDAT | GRDAT_F150 | DATUM | DATS | 8 | 0 | Posting date up to which documents are included | ||
15 | KNRMA | KNRMA | KUNNR | CHAR | 10 | 0 | Account number of the dunning recipient | KNA1 | |
16 | GMVDT | GMVDT | DATUM | DATS | 8 | 0 | Date of the legal dunning proceedings | ||
17 | MAHNA | MAHNA | MAHNA | CHAR | 4 | 0 | Dunning Procedure | T047A | |
18 | MAHNS | MAHNS_D | MAHNS | NUMC | 1 | 0 | Dunning Level | ||
19 | VZSKZ | VZSKZ | VZSKZ | CHAR | 2 | 0 | Interest calculation indicator | T056 | |
20 | WAERS | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | TCURC | |
21 | SALDO | SALFW_MHNK | WRTV8 | CURR | 15 | 2 | Balance in dunning area in dunning currency | ||
22 | SALHW | SALHW_MHNK | WRTV8 | CURR | 15 | 2 | Balance in dunning area local currency | ||
23 | GSFBT | GSFBT_MHNK | WRTV8 | CURR | 15 | 2 | Total of blocked and due items | ||
24 | GSNBT | GSNBT_MHNK | WRTV8 | CURR | 15 | 2 | Total balance of blocked items not due | ||
25 | FAEBT | FAEBT_MHNK | WRTV8 | CURR | 15 | 2 | Total of line items due | ||
26 | FAEHW | FAEHW_MHNK | WRTV8 | CURR | 15 | 2 | Total of due items in local currency | ||
27 | XMFLG | XMFLG_MHNK | XFELD | CHAR | 1 | 0 | Indicator: Is a dunning notice sent? | ||
28 | MANSP | MANSP | MANSP | CHAR | 1 | 0 | Dunning block | T040S | |
29 | MAHSK | MAHNS_MHNK | MAHNS | NUMC | 1 | 0 | Highest dunning level for account in dunning area | ||
30 | ZINBT | DZINBT_MHN | WRTV8 | CURR | 15 | 2 | Interest total for dunning notice in dunning currency | ||
31 | ZINHW | DZINHW_MHN | WRTV8 | CURR | 15 | 2 | Interest total for dunning notice in company code currency | ||
32 | XZINS | XZINS_MHNK | XFELD | CHAR | 1 | 0 | Indicator: Do not display interest in the dunning notice | ||
33 | MGRUP | MGRUP | MGRUP | CHAR | 2 | 0 | Key for dunning notice grouping | T047R | |
34 | VERTN | RANL | RANL | CHAR | 13 | 0 | Contract Number | ||
35 | VERTT | RANTYP | RANTYP | CHAR | 1 | 0 | Contract Type | ||
36 | IMKEY | IMKEY | IMKEY | CHAR | 8 | 0 | Internal Key for Real Estate Object | ||
37 | FAMSM | FAMSM_MHNK | WRTV8 | CURR | 15 | 2 | Total due itemsin dunning currency from dunning level | ||
38 | FAMSH | FAMSH_MHNK | WRTV8 | CURR | 15 | 2 | Total due items in local currency from dunning level | ||
39 | PSTLZ | PSTLZ | PSTLZ | CHAR | 10 | 0 | Postal Code | ||
40 | ORT01 | ORT01_GP | TEXT35 | CHAR | 35 | 0 | City | ||
41 | STRAS | STRAS_GP | TEXT35 | CHAR | 35 | 0 | House number and street | ||
42 | PFACH | PFACH | PFACH | CHAR | 10 | 0 | PO Box | ||
43 | LAND1 | LAND1 | LAND1 | CHAR | 3 | 0 | Country Key | T005 | |
44 | AVSID | AVSID | AVSID | CHAR | 16 | 0 | Payment Advice Number | ||
45 | APPLK | APPLK_BF | APPLK_BF | CHAR | 6 | 0 | Application Indicator | * | |
46 | CPDKY_GRP | CPDKY | TEXT16 | CHAR | 16 | 0 | Sort field for one-time accounts | ||
47 | CPDKY_CPD | CPDKY | TEXT16 | CHAR | 16 | 0 | Sort field for one-time accounts | ||
48 | MHNGH | MHNGH_F150 | WRTV8 | CURR | 15 | 2 | Dunning charge in local currency | ||
49 | MHNGF | MHNGF_F150 | WRTV8 | CURR | 15 | 2 | Dunning charge in foreign currency | ||
50 | PRNDT | PRNDT | DATUM | DATS | 8 | 0 | Dunning notice: Date of printing | ||
51 | PRNDT_BEFORE | PRNDT_BEFORE | DATUM | DATS | 8 | 0 | Print Date of Last Dunning Notice | ||
52 | .INCLUDE | 0 | 0 | Include for supplements MHNK for SAP applications | |||||
53 | .INCLU-LO | 0 | 0 | Loans: SI Include for MHNK | |||||
54 | SDUNNDOCLO | SDUNNDOC | SDUNNDOC | CHAR | 1 | 0 | Type of Dunning Letter | ||
55 | SRANLPOSTLO | RANL | RANL | CHAR | 13 | 0 | Contract Number | ||
56 | DBUDATLO | BUDAT | DATUM | DATS | 8 | 0 | Posting Date in the Document | ||
57 | .INCLUDE | 0 | 0 | Real Estate | |||||
58 | SWENR | SWENR | SWENR | CHAR | 8 | 0 | Business Entity Number | * | |
59 | SMENR | SMENR | SMENR | CHAR | 8 | 0 | Number of Rental Unit | * | |
60 | .INCLU--AP | 0 | 0 | Holder for Include PSO | |||||
61 | .INCLUDE | 0 | 0 | ISPS: SI Include for MHNK | |||||
62 | PSOMD | PSOMD | XFELD | CHAR | 1 | 0 | Dunning Notice Already Printed | ||
63 | .INCLUDE | 0 | 0 |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | MHNK | BUKRS | T001 | BUKRS | KEY | 1 | CN |
2 | MHNK | BUSAB | T001S | BUSAB | KEY | 1 | CN |
3 | MHNK | KNRMA | KNA1 | KUNNR | REF | C | CN |
4 | MHNK | KUNNR | KNA1 | KUNNR | KEY | 1 | CN |
5 | MHNK | LAND1 | T005 | LAND1 | REF | C | CN |
6 | MHNK | LIFNR | LFA1 | LIFNR | KEY | 1 | CN |
7 | MHNK | MAHNA | T047A | MAHNA | REF | C | CN |
8 | MHNK | MANDT | T000 | MANDT | KEY | 1 | CN |
9 | MHNK | MANSP | T040S | MANSP | REF | C | CN |
10 | MHNK | MGRUP | T047R | MGRUP | REF | C | CN |
11 | MHNK | SKNRZE | KNA1 | KUNNR | KEY | 1 | CN |
12 | MHNK | SMABER | T047M | MABER | KEY | 1 | CN |
13 | MHNK | VZSKZ | T056 | VZSKZ | REF | 1 | CN |
14 | MHNK | WAERS | TCURC | WAERS | REF | 1 | CN |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in |