SAP ABAP Table KNB4 (Customer Payment History)
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷
CRM-BF (Application Component) Basic Functions
⤷
VSCORE (Package) B2R: BAPI Structures
⤷
⤷
Basic Data
| Table Category | TRANSP | Transparent table |
| Transparent table | KNB4 |
|
| 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 | CLNT | 3 | 0 | Client | T000 | |
| 2 | |
KUNNR | KUNNR | CHAR | 10 | 0 | Customer Number | KNA1 | |
| 3 | |
BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | T001 | |
| 4 | |
AUFZD | DATUM | DATS | 8 | 0 | Date as from when the payment history was recorded | ||
| 5 | |
KALJAHR | GJAHR | NUMC | 4 | 0 | Calendar Year | ||
| 6 | |
KMONA_FI | MONAT | NUMC | 2 | 0 | Calendar Month | ||
| 7 | |
AGSXX | WRTV8 | CURR | 15 | 2 | Gross Total of Cleared Items without Cash Discount Loss | ||
| 8 | |
VZSXX | WRTV2 | DEC | 3 | 0 | Average arrears with cash discount payments | ||
| 9 | |
AGNXX | WRTV8 | CURR | 15 | 2 | Gross Total of Cleared Items with Cash Discount Not Taken | ||
| 10 | |
VZNXX | WRTV2 | DEC | 3 | 0 | Average arrears with payments without cash discount taken | ||
| 11 | |
ANZXX | WERT2 | DEC | 3 | 0 | Number of Incoming Payments during the Period | ||
| 12 | |
KALJAHR | GJAHR | NUMC | 4 | 0 | Calendar Year | ||
| 13 | |
KMONA_FI | MONAT | NUMC | 2 | 0 | Calendar Month | ||
| 14 | |
AGSXX | WRTV8 | CURR | 15 | 2 | Gross Total of Cleared Items without Cash Discount Loss | ||
| 15 | |
VZSXX | WRTV2 | DEC | 3 | 0 | Average arrears with cash discount payments | ||
| 16 | |
AGNXX | WRTV8 | CURR | 15 | 2 | Gross Total of Cleared Items with Cash Discount Not Taken | ||
| 17 | |
VZNXX | WRTV2 | DEC | 3 | 0 | Average arrears with payments without cash discount taken | ||
| 18 | |
ANZXX | WERT2 | DEC | 3 | 0 | Number of Incoming Payments during the Period | ||
| 19 | |
KALJAHR | GJAHR | NUMC | 4 | 0 | Calendar Year | ||
| 20 | |
KMONA_FI | MONAT | NUMC | 2 | 0 | Calendar Month | ||
| 21 | |
AGSXX | WRTV8 | CURR | 15 | 2 | Gross Total of Cleared Items without Cash Discount Loss | ||
| 22 | |
VZSXX | WRTV2 | DEC | 3 | 0 | Average arrears with cash discount payments | ||
| 23 | |
AGNXX | WRTV8 | CURR | 15 | 2 | Gross Total of Cleared Items with Cash Discount Not Taken | ||
| 24 | |
VZNXX | WRTV2 | DEC | 3 | 0 | Average arrears with payments without cash discount taken | ||
| 25 | |
ANZXX | WERT2 | DEC | 3 | 0 | Number of Incoming Payments during the Period | ||
| 26 | |
KALJAHR | GJAHR | NUMC | 4 | 0 | Calendar Year | ||
| 27 | |
KMONA_FI | MONAT | NUMC | 2 | 0 | Calendar Month | ||
| 28 | |
AGSXX | WRTV8 | CURR | 15 | 2 | Gross Total of Cleared Items without Cash Discount Loss | ||
| 29 | |
VZSXX | WRTV2 | DEC | 3 | 0 | Average arrears with cash discount payments | ||
| 30 | |
AGNXX | WRTV8 | CURR | 15 | 2 | Gross Total of Cleared Items with Cash Discount Not Taken | ||
| 31 | |
VZNXX | WRTV2 | DEC | 3 | 0 | Average arrears with payments without cash discount taken | ||
| 32 | |
ANZXX | WERT2 | DEC | 3 | 0 | Number of Incoming Payments during the Period | ||
| 33 | |
KALJAHR | GJAHR | NUMC | 4 | 0 | Calendar Year | ||
| 34 | |
KMONA_FI | MONAT | NUMC | 2 | 0 | Calendar Month | ||
| 35 | |
AGSXX | WRTV8 | CURR | 15 | 2 | Gross Total of Cleared Items without Cash Discount Loss | ||
| 36 | |
VZSXX | WRTV2 | DEC | 3 | 0 | Average arrears with cash discount payments | ||
| 37 | |
AGNXX | WRTV8 | CURR | 15 | 2 | Gross Total of Cleared Items with Cash Discount Not Taken | ||
| 38 | |
VZNXX | WRTV2 | DEC | 3 | 0 | Average arrears with payments without cash discount taken | ||
| 39 | |
ANZXX | WERT2 | DEC | 3 | 0 | Number of Incoming Payments during the Period | ||
| 40 | |
KALJAHR | GJAHR | NUMC | 4 | 0 | Calendar Year | ||
| 41 | |
KMONA_FI | MONAT | NUMC | 2 | 0 | Calendar Month | ||
| 42 | |
AGSXX | WRTV8 | CURR | 15 | 2 | Gross Total of Cleared Items without Cash Discount Loss | ||
| 43 | |
VZSXX | WRTV2 | DEC | 3 | 0 | Average arrears with cash discount payments | ||
| 44 | |
AGNXX | WRTV8 | CURR | 15 | 2 | Gross Total of Cleared Items with Cash Discount Not Taken | ||
| 45 | |
VZNXX | WRTV2 | DEC | 3 | 0 | Average arrears with payments without cash discount taken | ||
| 46 | |
ANZXX | WERT2 | DEC | 3 | 0 | Number of Incoming Payments during the Period | ||
| 47 | |
KALJAHR | GJAHR | NUMC | 4 | 0 | Calendar Year | ||
| 48 | |
KMONA_FI | MONAT | NUMC | 2 | 0 | Calendar Month | ||
| 49 | |
AGSXX | WRTV8 | CURR | 15 | 2 | Gross Total of Cleared Items without Cash Discount Loss | ||
| 50 | |
VZSXX | WRTV2 | DEC | 3 | 0 | Average arrears with cash discount payments | ||
| 51 | |
AGNXX | WRTV8 | CURR | 15 | 2 | Gross Total of Cleared Items with Cash Discount Not Taken | ||
| 52 | |
VZNXX | WRTV2 | DEC | 3 | 0 | Average arrears with payments without cash discount taken | ||
| 53 | |
ANZXX | WERT2 | DEC | 3 | 0 | Number of Incoming Payments during the Period | ||
| 54 | |
KALJAHR | GJAHR | NUMC | 4 | 0 | Calendar Year | ||
| 55 | |
KMONA_FI | MONAT | NUMC | 2 | 0 | Calendar Month | ||
| 56 | |
AGSXX | WRTV8 | CURR | 15 | 2 | Gross Total of Cleared Items without Cash Discount Loss | ||
| 57 | |
VZSXX | WRTV2 | DEC | 3 | 0 | Average arrears with cash discount payments | ||
| 58 | |
AGNXX | WRTV8 | CURR | 15 | 2 | Gross Total of Cleared Items with Cash Discount Not Taken | ||
| 59 | |
VZNXX | WRTV2 | DEC | 3 | 0 | Average arrears with payments without cash discount taken | ||
| 60 | |
ANZXX | WERT2 | DEC | 3 | 0 | Number of Incoming Payments during the Period | ||
| 61 | |
KALJAHR | GJAHR | NUMC | 4 | 0 | Calendar Year | ||
| 62 | |
KMONA_FI | MONAT | NUMC | 2 | 0 | Calendar Month | ||
| 63 | |
AGSXX | WRTV8 | CURR | 15 | 2 | Gross Total of Cleared Items without Cash Discount Loss | ||
| 64 | |
VZSXX | WRTV2 | DEC | 3 | 0 | Average arrears with cash discount payments | ||
| 65 | |
AGNXX | WRTV8 | CURR | 15 | 2 | Gross Total of Cleared Items with Cash Discount Not Taken | ||
| 66 | |
VZNXX | WRTV2 | DEC | 3 | 0 | Average arrears with payments without cash discount taken | ||
| 67 | |
ANZXX | WERT2 | DEC | 3 | 0 | Number of Incoming Payments during the Period | ||
| 68 | |
KALJAHR | GJAHR | NUMC | 4 | 0 | Calendar Year | ||
| 69 | |
KMONA_FI | MONAT | NUMC | 2 | 0 | Calendar Month | ||
| 70 | |
AGSXX | WRTV8 | CURR | 15 | 2 | Gross Total of Cleared Items without Cash Discount Loss | ||
| 71 | |
VZSXX | WRTV2 | DEC | 3 | 0 | Average arrears with cash discount payments | ||
| 72 | |
AGNXX | WRTV8 | CURR | 15 | 2 | Gross Total of Cleared Items with Cash Discount Not Taken | ||
| 73 | |
VZNXX | WRTV2 | DEC | 3 | 0 | Average arrears with payments without cash discount taken | ||
| 74 | |
ANZXX | WERT2 | DEC | 3 | 0 | Number of Incoming Payments during the Period | ||
| 75 | |
KALJAHR | GJAHR | NUMC | 4 | 0 | Calendar Year | ||
| 76 | |
KMONA_FI | MONAT | NUMC | 2 | 0 | Calendar Month | ||
| 77 | |
AGSXX | WRTV8 | CURR | 15 | 2 | Gross Total of Cleared Items without Cash Discount Loss | ||
| 78 | |
VZSXX | WRTV2 | DEC | 3 | 0 | Average arrears with cash discount payments | ||
| 79 | |
AGNXX | WRTV8 | CURR | 15 | 2 | Gross Total of Cleared Items with Cash Discount Not Taken | ||
| 80 | |
VZNXX | WRTV2 | DEC | 3 | 0 | Average arrears with payments without cash discount taken | ||
| 81 | |
ANZXX | WERT2 | DEC | 3 | 0 | Number of Incoming Payments during the Period | ||
| 82 | |
KALJAHR | GJAHR | NUMC | 4 | 0 | Calendar Year | ||
| 83 | |
KMONA_FI | MONAT | NUMC | 2 | 0 | Calendar Month | ||
| 84 | |
AGSXX | WRTV8 | CURR | 15 | 2 | Gross Total of Cleared Items without Cash Discount Loss | ||
| 85 | |
VZSXX | WRTV2 | DEC | 3 | 0 | Average arrears with cash discount payments | ||
| 86 | |
AGNXX | WRTV8 | CURR | 15 | 2 | Gross Total of Cleared Items with Cash Discount Not Taken | ||
| 87 | |
VZNXX | WRTV2 | DEC | 3 | 0 | Average arrears with payments without cash discount taken | ||
| 88 | |
ANZXX | WERT2 | DEC | 3 | 0 | Number of Incoming Payments during the Period | ||
| 89 | |
KALJAHR | GJAHR | NUMC | 4 | 0 | Calendar Year | ||
| 90 | |
KMONA_FI | MONAT | NUMC | 2 | 0 | Calendar Month | ||
| 91 | |
AGSXX | WRTV8 | CURR | 15 | 2 | Gross Total of Cleared Items without Cash Discount Loss | ||
| 92 | |
VZSXX | WRTV2 | DEC | 3 | 0 | Average arrears with cash discount payments | ||
| 93 | |
AGNXX | WRTV8 | CURR | 15 | 2 | Gross Total of Cleared Items with Cash Discount Not Taken | ||
| 94 | |
VZNXX | WRTV2 | DEC | 3 | 0 | Average arrears with payments without cash discount taken | ||
| 95 | |
ANZXX | WERT2 | DEC | 3 | 0 | Number of Incoming Payments during the Period | ||
| 96 | |
KALJAHR | GJAHR | NUMC | 4 | 0 | Calendar Year | ||
| 97 | |
KMONA_FI | MONAT | NUMC | 2 | 0 | Calendar Month | ||
| 98 | |
AGSXX | WRTV8 | CURR | 15 | 2 | Gross Total of Cleared Items without Cash Discount Loss | ||
| 99 | |
VZSXX | WRTV2 | DEC | 3 | 0 | Average arrears with cash discount payments | ||
| 100 | |
AGNXX | WRTV8 | CURR | 15 | 2 | Gross Total of Cleared Items with Cash Discount Not Taken | ||
| 101 | |
VZNXX | WRTV2 | DEC | 3 | 0 | Average arrears with payments without cash discount taken | ||
| 102 | |
ANZXX | WERT2 | DEC | 3 | 0 | Number of Incoming Payments during the Period | ||
| 103 | |
KALJAHR | GJAHR | NUMC | 4 | 0 | Calendar Year | ||
| 104 | |
KMONA_FI | MONAT | NUMC | 2 | 0 | Calendar Month | ||
| 105 | |
AGSXX | WRTV8 | CURR | 15 | 2 | Gross Total of Cleared Items without Cash Discount Loss | ||
| 106 | |
VZSXX | WRTV2 | DEC | 3 | 0 | Average arrears with cash discount payments | ||
| 107 | |
AGNXX | WRTV8 | CURR | 15 | 2 | Gross Total of Cleared Items with Cash Discount Not Taken | ||
| 108 | |
VZNXX | WRTV2 | DEC | 3 | 0 | Average arrears with payments without cash discount taken | ||
| 109 | |
ANZXX | WERT2 | DEC | 3 | 0 | Number of Incoming Payments during the Period | ||
| 110 | |
KALJAHR | GJAHR | NUMC | 4 | 0 | Calendar Year | ||
| 111 | |
KMONA_FI | MONAT | NUMC | 2 | 0 | Calendar Month | ||
| 112 | |
AGSXX | WRTV8 | CURR | 15 | 2 | Gross Total of Cleared Items without Cash Discount Loss | ||
| 113 | |
VZSXX | WRTV2 | DEC | 3 | 0 | Average arrears with cash discount payments | ||
| 114 | |
AGNXX | WRTV8 | CURR | 15 | 2 | Gross Total of Cleared Items with Cash Discount Not Taken | ||
| 115 | |
VZNXX | WRTV2 | DEC | 3 | 0 | Average arrears with payments without cash discount taken | ||
| 116 | |
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 | |
|
KEY | 1 | CN |
| 2 | KNB4 | KUNNR | |
|
KEY | 1 | CN |
| 3 | KNB4 | MANDT | |
|
KEY | 1 | CN |
History
| Last changed by/on | SAP | 20131127 |
| SAP Release Created in |