SAP ABAP Table FIN_F150_DUNN_SF_MHND_PDF (Dunning Notice: Structure for PDF Output)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ FBM (Package) Dunning

Basic Data

Table Category	INTTAB	Structure
Structure	FIN_F150_DUNN_SF_MHND_PDF	Table Relationship Diagram
Short Description	Dunning Notice: Structure for PDF Output

Delivery and Maintenance

Pool/cluster
Delivery Class
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	TEXT_E	☐	TEXT60	TEXT60	CHAR	60	0	Text Field of Length 60
2	TEXT_S	☐	TEXT60	TEXT60	CHAR	60	0	Text Field of Length 60
3	SGTXT	☐	SGTXT	TEXT50	CHAR	50	0	Item Text
4	.INCLUDE	☐				0	0	Dunning Data
5	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
6	LAUFD	☐	LAUFD	DATUM	DATS	8	0	Date on Which the Program Is to Be Run
7	LAUFI	☐	LAUFI	LAUFI	CHAR	6	0	Additional Identification
8	KOART	☐	KOART	KOART	CHAR	1	0	Account type
9	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
10	KUNNR	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	KNA1
11	LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	LFA1
12	CPDKY	☐	CPDKY	TEXT16	CHAR	16	0	Sort field for one-time accounts
13	SKNRZE	☐	KNRZE	KUNNR	CHAR	10	0	Head office account number (in branch accounts)	KNA1
14	SMABER	☐	MABER	MABER	CHAR	2	0	Dunning Area	T047M
15	SMAHSK	☐	MAHNS_D	MAHNS	NUMC	1	0	Dunning Level
16	BBUKRS	☐	BBUKRS	BUKRS	CHAR	4	0	Document company code	*
17	BELNR	☐	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
18	GJAHR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
19	BUZEI	☐	BUZEI	BUZEI	NUMC	3	0	Number of Line Item Within Accounting Document
20	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
21	XBLNR	☐	XBLNR1	XBLNR1	CHAR	16	0	Reference Document Number
22	ZUONR	☐	DZUONR	ZUONR	CHAR	18	0	Assignment number
23	BUDAT	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
24	BLDAT	☐	BLDAT	DATUM	DATS	8	0	Document Date in Document
25	CPUDT	☐	CPUDT	DATUM	DATS	8	0	Accounting document entry date
26	ZFBDT	☐	DZFBDT	DATUM	DATS	8	0	Baseline date for due date calculation
27	FAEDT	☐	NETDT	DATUM	DATS	8	0	Due Date for Net Payment
28	BLART	☐	BLART	BLART	CHAR	2	0	Document type	T003
29	BSCHL	☐	BSCHL	BSCHL	CHAR	2	0	Posting Key	TBSL
30	MSCHL	☐	MSCHL	MSCHL	CHAR	1	0	Dunning key	T040
31	SMSCHL	☐	MSCHL_MHND	MSCHL	CHAR	1	0	Dunning key if separate printout is active; otherwise blank	T040
32	MANSP	☐	MANSP	MANSP	CHAR	1	0	Dunning block	T040S
33	MABER	☐	MABER	MABER	CHAR	2	0	Dunning Area	T047M
34	MADAT	☐	MADAT	DATUM	DATS	8	0	Date of Last Dunning Notice
35	MAHNS	☐	MAHNS_ALT	MAHNS	NUMC	1	0	Old dunning level
36	MAHNN	☐	MAHNS_D	MAHNS	NUMC	1	0	Dunning Level
37	ZLSPR	☐	DZLSPR	ZAHLS	CHAR	1	0	Payment Block Key	T008
38	XZALB	☐	XZALB_MHND	XFELD	CHAR	1	0	Indicator: items payable (not to be dunned) ?
39	XFAEL	☐	XFAEL	XFELD	CHAR	1	0	Indicator: line items overdue ?
40	VERZN	☐	VERZN	WRTV3	DEC	5	0	Days in Arrears by Net Due Date
41	UMSKS	☐	UMSKS	UMSKS	CHAR	1	0	Special G/L Transaction Type
42	UMSKZ	☐	UMSKZ	UMSKZ	CHAR	1	0	Special G/L Indicator	T074U
43	SHKZG	☐	SHKZG	SHKZG	CHAR	1	0	Debit/Credit Indicator
44	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
45	DMSHB	☐	DMSHB	WRTV7	CURR	13	2	Amount in Local Currency with +/- Signs
46	WRSHB	☐	WRSHB	WRTV7	CURR	13	2	Foreign Currency Amount with Signs (+/-)
47	ZINST	☐	DZINST	WRTV3	DEC	5	0	Number of days for which interest is calculated
48	ZINSS	☐	DZINSS	PRZ43	DEC	7	3	Interest rate
49	ZSBTR	☐	DZSBTR	WRTV7	CURR	13	2	Interest amount in local currency
50	WZSBT	☐	WZSBT	WRTV7	CURR	13	2	Interest amount in foreign currency
51	FILKD	☐	FILKD	MAXKK	CHAR	10	0	Account Number of the Branch
52	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
53	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVTW
54	SPART	☐	SPART	SPART	CHAR	2	0	Division	TSPA
55	XZINS	☐	XZINS_MHND	XFELD	CHAR	1	0	Indicator: Do not display interest in the item
56	REBZG	☐	REBZG	BELNR	CHAR	10	0	Number of the Invoice the Transaction Belongs to
57	REBZJ	☐	REBZJ	GJAHR	NUMC	4	0	Fiscal Year of the Relevant Invoice (for Credit Memo)
58	REBZZ	☐	REBZZ	BUZEI	NUMC	3	0	Line Item in the Relevant Invoice
59	VERTN	☐	RANL	RANL	CHAR	13	0	Contract Number
60	VERTT	☐	RANTYP	RANTYP	CHAR	1	0	Contract Type
61	ZLSCH	☐	DZLSCH	ZLSCH	CHAR	1	0	Payment method	*
62	BKOART	☐	BKOART	KOART	CHAR	1	0	Document account type (K=BSIK, D=BSID)
63	.INCLUDE	☐				0	0	Additional Sort Fields for Dunning
64	VNAME	☐	JV_NAME	JV_NAME	CHAR	6	0	Joint venture	*
65	EGRUP	☐	JV_EGROUP	JV_EGROUP	CHAR	3	0	Equity group	*
66	BTYPE	☐	JV_BILIND	JV_BILIND	CHAR	2	0	Payroll Type	*
67	XREF1	☐	XREF1	CHAR12	CHAR	12	0	Business partner reference key
68	XREF2	☐	XREF2	CHAR12	CHAR	12	0	Business partner reference key
69	ZINKZ	☐	MHND_ZINKZ		CHAR	2	0	Public Sector Industry Solution: Exempt from Interest Calc.

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	FIN_F150_DUNN_SF_MHND_PDF	BLART	T003	BLART	REF	1	CN
2	FIN_F150_DUNN_SF_MHND_PDF	BSCHL	TBSL	BSCHL	REF	1	CN
3	FIN_F150_DUNN_SF_MHND_PDF	BUKRS	T001	BUKRS	KEY	1	CN
4	FIN_F150_DUNN_SF_MHND_PDF	GSBER	TGSB	GSBER	REF	C	CN
5	FIN_F150_DUNN_SF_MHND_PDF	KUNNR	KNA1	KUNNR	KEY	1	CN
6	FIN_F150_DUNN_SF_MHND_PDF	LIFNR	LFA1	LIFNR	KEY	1	CN
7	FIN_F150_DUNN_SF_MHND_PDF	MABER	T047M	MABER	REF	C	CN
8	FIN_F150_DUNN_SF_MHND_PDF	MANDT	T000	MANDT	KEY	1	CN
9	FIN_F150_DUNN_SF_MHND_PDF	MANSP	T040S	MANSP	REF	C	CN
10	FIN_F150_DUNN_SF_MHND_PDF	MSCHL	T040	MSCHL	REF	C	CN
11	FIN_F150_DUNN_SF_MHND_PDF	SKNRZE	KNA1	KUNNR	KEY	1	CN
12	FIN_F150_DUNN_SF_MHND_PDF	SMABER	T047M	MABER	KEY	1	CN
13	FIN_F150_DUNN_SF_MHND_PDF	SMSCHL	T040	MSCHL	REF	C	CN
14	FIN_F150_DUNN_SF_MHND_PDF	SPART	TSPA	SPART	REF	C	CN
15	FIN_F150_DUNN_SF_MHND_PDF	UMSKZ	T074U	UMSKZ	REF	C	CN
16	FIN_F150_DUNN_SF_MHND_PDF	VKORG	TVKO	VKORG	REF	C	CN
17	FIN_F150_DUNN_SF_MHND_PDF	VTWEG	TVTW	VTWEG	REF	C	CN
18	FIN_F150_DUNN_SF_MHND_PDF	WAERS	TCURC	WAERS	REF	1	CN
19	FIN_F150_DUNN_SF_MHND_PDF	ZLSPR	T008	ZAHLS	REF	C	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in	600