SAP ABAP Table KNB4 (Customer Payment History)
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷ CRM-BF (Application Component) Basic Functions
⤷ VSCORE (Package) B2R: BAPI Structures
⤷ CRM-BF (Application Component) Basic Functions
⤷ VSCORE (Package) B2R: BAPI Structures
Basic Data
Table Category | TRANSP | Transparent table |
Transparent table | KNB4 | Table Relationship Diagram |
Short Description | Customer Payment History |
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 | KUNNR | KUNNR | KUNNR | CHAR | 10 | 0 | Customer Number | KNA1 | |
3 | BUKRS | BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | T001 | |
4 | AUFZD | AUFZD | DATUM | DATS | 8 | 0 | Date as from when the payment history was recorded | ||
5 | JAH01 | KALJAHR | GJAHR | NUMC | 4 | 0 | Calendar Year | ||
6 | MON01 | KMONA_FI | MONAT | NUMC | 2 | 0 | Calendar Month | ||
7 | AGS01 | AGSXX | WRTV8 | CURR | 15 | 2 | Gross Total of Cleared Items without Cash Discount Loss | ||
8 | VZS01 | VZSXX | WRTV2 | DEC | 3 | 0 | Average arrears with cash discount payments | ||
9 | AGN01 | AGNXX | WRTV8 | CURR | 15 | 2 | Gross Total of Cleared Items with Cash Discount Not Taken | ||
10 | VZN01 | VZNXX | WRTV2 | DEC | 3 | 0 | Average arrears with payments without cash discount taken | ||
11 | ANZ01 | ANZXX | WERT2 | DEC | 3 | 0 | Number of Incoming Payments during the Period | ||
12 | JAH02 | KALJAHR | GJAHR | NUMC | 4 | 0 | Calendar Year | ||
13 | MON02 | KMONA_FI | MONAT | NUMC | 2 | 0 | Calendar Month | ||
14 | AGS02 | AGSXX | WRTV8 | CURR | 15 | 2 | Gross Total of Cleared Items without Cash Discount Loss | ||
15 | VZS02 | VZSXX | WRTV2 | DEC | 3 | 0 | Average arrears with cash discount payments | ||
16 | AGN02 | AGNXX | WRTV8 | CURR | 15 | 2 | Gross Total of Cleared Items with Cash Discount Not Taken | ||
17 | VZN02 | VZNXX | WRTV2 | DEC | 3 | 0 | Average arrears with payments without cash discount taken | ||
18 | ANZ02 | ANZXX | WERT2 | DEC | 3 | 0 | Number of Incoming Payments during the Period | ||
19 | JAH03 | KALJAHR | GJAHR | NUMC | 4 | 0 | Calendar Year | ||
20 | MON03 | KMONA_FI | MONAT | NUMC | 2 | 0 | Calendar Month | ||
21 | AGS03 | AGSXX | WRTV8 | CURR | 15 | 2 | Gross Total of Cleared Items without Cash Discount Loss | ||
22 | VZS03 | VZSXX | WRTV2 | DEC | 3 | 0 | Average arrears with cash discount payments | ||
23 | AGN03 | AGNXX | WRTV8 | CURR | 15 | 2 | Gross Total of Cleared Items with Cash Discount Not Taken | ||
24 | VZN03 | VZNXX | WRTV2 | DEC | 3 | 0 | Average arrears with payments without cash discount taken | ||
25 | ANZ03 | ANZXX | WERT2 | DEC | 3 | 0 | Number of Incoming Payments during the Period | ||
26 | JAH04 | KALJAHR | GJAHR | NUMC | 4 | 0 | Calendar Year | ||
27 | MON04 | KMONA_FI | MONAT | NUMC | 2 | 0 | Calendar Month | ||
28 | AGS04 | AGSXX | WRTV8 | CURR | 15 | 2 | Gross Total of Cleared Items without Cash Discount Loss | ||
29 | VZS04 | VZSXX | WRTV2 | DEC | 3 | 0 | Average arrears with cash discount payments | ||
30 | AGN04 | AGNXX | WRTV8 | CURR | 15 | 2 | Gross Total of Cleared Items with Cash Discount Not Taken | ||
31 | VZN04 | VZNXX | WRTV2 | DEC | 3 | 0 | Average arrears with payments without cash discount taken | ||
32 | ANZ04 | ANZXX | WERT2 | DEC | 3 | 0 | Number of Incoming Payments during the Period | ||
33 | JAH05 | KALJAHR | GJAHR | NUMC | 4 | 0 | Calendar Year | ||
34 | MON05 | KMONA_FI | MONAT | NUMC | 2 | 0 | Calendar Month | ||
35 | AGS05 | AGSXX | WRTV8 | CURR | 15 | 2 | Gross Total of Cleared Items without Cash Discount Loss | ||
36 | VZS05 | VZSXX | WRTV2 | DEC | 3 | 0 | Average arrears with cash discount payments | ||
37 | AGN05 | AGNXX | WRTV8 | CURR | 15 | 2 | Gross Total of Cleared Items with Cash Discount Not Taken | ||
38 | VZN05 | VZNXX | WRTV2 | DEC | 3 | 0 | Average arrears with payments without cash discount taken | ||
39 | ANZ05 | ANZXX | WERT2 | DEC | 3 | 0 | Number of Incoming Payments during the Period | ||
40 | JAH06 | KALJAHR | GJAHR | NUMC | 4 | 0 | Calendar Year | ||
41 | MON06 | KMONA_FI | MONAT | NUMC | 2 | 0 | Calendar Month | ||
42 | AGS06 | AGSXX | WRTV8 | CURR | 15 | 2 | Gross Total of Cleared Items without Cash Discount Loss | ||
43 | VZS06 | VZSXX | WRTV2 | DEC | 3 | 0 | Average arrears with cash discount payments | ||
44 | AGN06 | AGNXX | WRTV8 | CURR | 15 | 2 | Gross Total of Cleared Items with Cash Discount Not Taken | ||
45 | VZN06 | VZNXX | WRTV2 | DEC | 3 | 0 | Average arrears with payments without cash discount taken | ||
46 | ANZ06 | ANZXX | WERT2 | DEC | 3 | 0 | Number of Incoming Payments during the Period | ||
47 | JAH07 | KALJAHR | GJAHR | NUMC | 4 | 0 | Calendar Year | ||
48 | MON07 | KMONA_FI | MONAT | NUMC | 2 | 0 | Calendar Month | ||
49 | AGS07 | AGSXX | WRTV8 | CURR | 15 | 2 | Gross Total of Cleared Items without Cash Discount Loss | ||
50 | VZS07 | VZSXX | WRTV2 | DEC | 3 | 0 | Average arrears with cash discount payments | ||
51 | AGN07 | AGNXX | WRTV8 | CURR | 15 | 2 | Gross Total of Cleared Items with Cash Discount Not Taken | ||
52 | VZN07 | VZNXX | WRTV2 | DEC | 3 | 0 | Average arrears with payments without cash discount taken | ||
53 | ANZ07 | ANZXX | WERT2 | DEC | 3 | 0 | Number of Incoming Payments during the Period | ||
54 | JAH08 | KALJAHR | GJAHR | NUMC | 4 | 0 | Calendar Year | ||
55 | MON08 | KMONA_FI | MONAT | NUMC | 2 | 0 | Calendar Month | ||
56 | AGS08 | AGSXX | WRTV8 | CURR | 15 | 2 | Gross Total of Cleared Items without Cash Discount Loss | ||
57 | VZS08 | VZSXX | WRTV2 | DEC | 3 | 0 | Average arrears with cash discount payments | ||
58 | AGN08 | AGNXX | WRTV8 | CURR | 15 | 2 | Gross Total of Cleared Items with Cash Discount Not Taken | ||
59 | VZN08 | VZNXX | WRTV2 | DEC | 3 | 0 | Average arrears with payments without cash discount taken | ||
60 | ANZ08 | ANZXX | WERT2 | DEC | 3 | 0 | Number of Incoming Payments during the Period | ||
61 | JAH09 | KALJAHR | GJAHR | NUMC | 4 | 0 | Calendar Year | ||
62 | MON09 | KMONA_FI | MONAT | NUMC | 2 | 0 | Calendar Month | ||
63 | AGS09 | AGSXX | WRTV8 | CURR | 15 | 2 | Gross Total of Cleared Items without Cash Discount Loss | ||
64 | VZS09 | VZSXX | WRTV2 | DEC | 3 | 0 | Average arrears with cash discount payments | ||
65 | AGN09 | AGNXX | WRTV8 | CURR | 15 | 2 | Gross Total of Cleared Items with Cash Discount Not Taken | ||
66 | VZN09 | VZNXX | WRTV2 | DEC | 3 | 0 | Average arrears with payments without cash discount taken | ||
67 | ANZ09 | ANZXX | WERT2 | DEC | 3 | 0 | Number of Incoming Payments during the Period | ||
68 | JAH10 | KALJAHR | GJAHR | NUMC | 4 | 0 | Calendar Year | ||
69 | MON10 | KMONA_FI | MONAT | NUMC | 2 | 0 | Calendar Month | ||
70 | AGS10 | AGSXX | WRTV8 | CURR | 15 | 2 | Gross Total of Cleared Items without Cash Discount Loss | ||
71 | VZS10 | VZSXX | WRTV2 | DEC | 3 | 0 | Average arrears with cash discount payments | ||
72 | AGN10 | AGNXX | WRTV8 | CURR | 15 | 2 | Gross Total of Cleared Items with Cash Discount Not Taken | ||
73 | VZN10 | VZNXX | WRTV2 | DEC | 3 | 0 | Average arrears with payments without cash discount taken | ||
74 | ANZ10 | ANZXX | WERT2 | DEC | 3 | 0 | Number of Incoming Payments during the Period | ||
75 | JAH11 | KALJAHR | GJAHR | NUMC | 4 | 0 | Calendar Year | ||
76 | MON11 | KMONA_FI | MONAT | NUMC | 2 | 0 | Calendar Month | ||
77 | AGS11 | AGSXX | WRTV8 | CURR | 15 | 2 | Gross Total of Cleared Items without Cash Discount Loss | ||
78 | VZS11 | VZSXX | WRTV2 | DEC | 3 | 0 | Average arrears with cash discount payments | ||
79 | AGN11 | AGNXX | WRTV8 | CURR | 15 | 2 | Gross Total of Cleared Items with Cash Discount Not Taken | ||
80 | VZN11 | VZNXX | WRTV2 | DEC | 3 | 0 | Average arrears with payments without cash discount taken | ||
81 | ANZ11 | ANZXX | WERT2 | DEC | 3 | 0 | Number of Incoming Payments during the Period | ||
82 | JAH12 | KALJAHR | GJAHR | NUMC | 4 | 0 | Calendar Year | ||
83 | MON12 | KMONA_FI | MONAT | NUMC | 2 | 0 | Calendar Month | ||
84 | AGS12 | AGSXX | WRTV8 | CURR | 15 | 2 | Gross Total of Cleared Items without Cash Discount Loss | ||
85 | VZS12 | VZSXX | WRTV2 | DEC | 3 | 0 | Average arrears with cash discount payments | ||
86 | AGN12 | AGNXX | WRTV8 | CURR | 15 | 2 | Gross Total of Cleared Items with Cash Discount Not Taken | ||
87 | VZN12 | VZNXX | WRTV2 | DEC | 3 | 0 | Average arrears with payments without cash discount taken | ||
88 | ANZ12 | ANZXX | WERT2 | DEC | 3 | 0 | Number of Incoming Payments during the Period | ||
89 | JAH13 | KALJAHR | GJAHR | NUMC | 4 | 0 | Calendar Year | ||
90 | MON13 | KMONA_FI | MONAT | NUMC | 2 | 0 | Calendar Month | ||
91 | AGS13 | AGSXX | WRTV8 | CURR | 15 | 2 | Gross Total of Cleared Items without Cash Discount Loss | ||
92 | VZS13 | VZSXX | WRTV2 | DEC | 3 | 0 | Average arrears with cash discount payments | ||
93 | AGN13 | AGNXX | WRTV8 | CURR | 15 | 2 | Gross Total of Cleared Items with Cash Discount Not Taken | ||
94 | VZN13 | VZNXX | WRTV2 | DEC | 3 | 0 | Average arrears with payments without cash discount taken | ||
95 | ANZ13 | ANZXX | WERT2 | DEC | 3 | 0 | Number of Incoming Payments during the Period | ||
96 | JAH14 | KALJAHR | GJAHR | NUMC | 4 | 0 | Calendar Year | ||
97 | MON14 | KMONA_FI | MONAT | NUMC | 2 | 0 | Calendar Month | ||
98 | AGS14 | AGSXX | WRTV8 | CURR | 15 | 2 | Gross Total of Cleared Items without Cash Discount Loss | ||
99 | VZS14 | VZSXX | WRTV2 | DEC | 3 | 0 | Average arrears with cash discount payments | ||
100 | AGN14 | AGNXX | WRTV8 | CURR | 15 | 2 | Gross Total of Cleared Items with Cash Discount Not Taken | ||
101 | VZN14 | VZNXX | WRTV2 | DEC | 3 | 0 | Average arrears with payments without cash discount taken | ||
102 | ANZ14 | ANZXX | WERT2 | DEC | 3 | 0 | Number of Incoming Payments during the Period | ||
103 | JAH15 | KALJAHR | GJAHR | NUMC | 4 | 0 | Calendar Year | ||
104 | MON15 | KMONA_FI | MONAT | NUMC | 2 | 0 | Calendar Month | ||
105 | AGS15 | AGSXX | WRTV8 | CURR | 15 | 2 | Gross Total of Cleared Items without Cash Discount Loss | ||
106 | VZS15 | VZSXX | WRTV2 | DEC | 3 | 0 | Average arrears with cash discount payments | ||
107 | AGN15 | AGNXX | WRTV8 | CURR | 15 | 2 | Gross Total of Cleared Items with Cash Discount Not Taken | ||
108 | VZN15 | VZNXX | WRTV2 | DEC | 3 | 0 | Average arrears with payments without cash discount taken | ||
109 | ANZ15 | ANZXX | WERT2 | DEC | 3 | 0 | Number of Incoming Payments during the Period | ||
110 | JAH16 | KALJAHR | GJAHR | NUMC | 4 | 0 | Calendar Year | ||
111 | MON16 | KMONA_FI | MONAT | NUMC | 2 | 0 | Calendar Month | ||
112 | AGS16 | AGSXX | WRTV8 | CURR | 15 | 2 | Gross Total of Cleared Items without Cash Discount Loss | ||
113 | VZS16 | VZSXX | WRTV2 | DEC | 3 | 0 | Average arrears with cash discount payments | ||
114 | AGN16 | AGNXX | WRTV8 | CURR | 15 | 2 | Gross Total of Cleared Items with Cash Discount Not Taken | ||
115 | VZN16 | VZNXX | WRTV2 | DEC | 3 | 0 | Average arrears with payments without cash discount taken | ||
116 | ANZ16 | ANZXX | WERT2 | DEC | 3 | 0 | Number of Incoming Payments during the Period |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | KNB4 | BUKRS | T001 | BUKRS | KEY | 1 | CN |
2 | KNB4 | KUNNR | KNA1 | KUNNR | KEY | 1 | CN |
3 | KNB4 | MANDT | T000 | MANDT | KEY | 1 | CN |
History
Last changed by/on | SAP | 20131127 |
SAP Release Created in |