SAP TABLES | Logistics - General | Logistics Basic Data | Customer Master(LO-MD-BP-CM) SAP LO

KNB4 SAP Customer Payment History Table and data







KNB4 is a standard SAP Table which is used to store Customer Payment History data and is available within R/3 SAP systems depending on the version and release level.

Below is the standard documentation available and a few details of the fields which make up this Table. You can view further information about SAP KNB4 Table and the data within it using relevant transactions such as SE11, SE80 or SE16. Also check out the Comments section below to view or add related contributions and example screen shots.

Delivery Class: A - Application table containing master and transaction data

Display/Maintenance via SM30: Yes but with Restrictions

Enhancement category i: Can be enhanced (character-type or numeric)
See here for more information about this and other SAP enhancement categories

==>View Table relationships


SAP KNB4 Table fields within data Dictionary





FieldData ElementData Typelength (Decimals)Check tableDescriptionConversion Routine
MANDTMANDTCLNT3 T000Client
KUNNRKUNNRCHAR10 KNA1Customer NumberALPHA
BUKRSBUKRSCHAR4 T001Company Code
AUFZDAUFZDDATS8 Date as from when the payment history was recorded
JAH01KALJAHRNUMC4 Calendar YearGJAHR
MON01KMONA_FINUMC2 Calendar Month
AGS01AGSXXCURR15(2) Gross Total of Cleared Items without Cash Discount Loss
VZS01VZSXXDEC3 Average arrears with cash discount payments
AGN01AGNXXCURR15(2) Gross Total of Cleared Items with Cash Discount Not Taken
VZN01VZNXXDEC3 Average arrears with payments without cash discount taken
ANZ01ANZXXDEC3 Number of Incoming Payments during the Period
JAH02KALJAHRNUMC4 Calendar YearGJAHR
MON02KMONA_FINUMC2 Calendar Month
AGS02AGSXXCURR15(2) Gross Total of Cleared Items without Cash Discount Loss
VZS02VZSXXDEC3 Average arrears with cash discount payments
AGN02AGNXXCURR15(2) Gross Total of Cleared Items with Cash Discount Not Taken
VZN02VZNXXDEC3 Average arrears with payments without cash discount taken
ANZ02ANZXXDEC3 Number of Incoming Payments during the Period
JAH03KALJAHRNUMC4 Calendar YearGJAHR
MON03KMONA_FINUMC2 Calendar Month
AGS03AGSXXCURR15(2) Gross Total of Cleared Items without Cash Discount Loss
VZS03VZSXXDEC3 Average arrears with cash discount payments
AGN03AGNXXCURR15(2) Gross Total of Cleared Items with Cash Discount Not Taken
VZN03VZNXXDEC3 Average arrears with payments without cash discount taken
ANZ03ANZXXDEC3 Number of Incoming Payments during the Period
JAH04KALJAHRNUMC4 Calendar YearGJAHR
MON04KMONA_FINUMC2 Calendar Month
AGS04AGSXXCURR15(2) Gross Total of Cleared Items without Cash Discount Loss
VZS04VZSXXDEC3 Average arrears with cash discount payments
AGN04AGNXXCURR15(2) Gross Total of Cleared Items with Cash Discount Not Taken
VZN04VZNXXDEC3 Average arrears with payments without cash discount taken
ANZ04ANZXXDEC3 Number of Incoming Payments during the Period
JAH05KALJAHRNUMC4 Calendar YearGJAHR
MON05KMONA_FINUMC2 Calendar Month
AGS05AGSXXCURR15(2) Gross Total of Cleared Items without Cash Discount Loss
VZS05VZSXXDEC3 Average arrears with cash discount payments
AGN05AGNXXCURR15(2) Gross Total of Cleared Items with Cash Discount Not Taken
VZN05VZNXXDEC3 Average arrears with payments without cash discount taken
ANZ05ANZXXDEC3 Number of Incoming Payments during the Period


JAH06KALJAHRNUMC4 Calendar YearGJAHR
MON06KMONA_FINUMC2 Calendar Month
AGS06AGSXXCURR15(2) Gross Total of Cleared Items without Cash Discount Loss
VZS06VZSXXDEC3 Average arrears with cash discount payments
AGN06AGNXXCURR15(2) Gross Total of Cleared Items with Cash Discount Not Taken
VZN06VZNXXDEC3 Average arrears with payments without cash discount taken
ANZ06ANZXXDEC3 Number of Incoming Payments during the Period
JAH07KALJAHRNUMC4 Calendar YearGJAHR
MON07KMONA_FINUMC2 Calendar Month
AGS07AGSXXCURR15(2) Gross Total of Cleared Items without Cash Discount Loss
VZS07VZSXXDEC3 Average arrears with cash discount payments
AGN07AGNXXCURR15(2) Gross Total of Cleared Items with Cash Discount Not Taken
VZN07VZNXXDEC3 Average arrears with payments without cash discount taken
ANZ07ANZXXDEC3 Number of Incoming Payments during the Period
JAH08KALJAHRNUMC4 Calendar YearGJAHR
MON08KMONA_FINUMC2 Calendar Month
AGS08AGSXXCURR15(2) Gross Total of Cleared Items without Cash Discount Loss
VZS08VZSXXDEC3 Average arrears with cash discount payments
AGN08AGNXXCURR15(2) Gross Total of Cleared Items with Cash Discount Not Taken
VZN08VZNXXDEC3 Average arrears with payments without cash discount taken
ANZ08ANZXXDEC3 Number of Incoming Payments during the Period
JAH09KALJAHRNUMC4 Calendar YearGJAHR
MON09KMONA_FINUMC2 Calendar Month
AGS09AGSXXCURR15(2) Gross Total of Cleared Items without Cash Discount Loss
VZS09VZSXXDEC3 Average arrears with cash discount payments
AGN09AGNXXCURR15(2) Gross Total of Cleared Items with Cash Discount Not Taken
VZN09VZNXXDEC3 Average arrears with payments without cash discount taken
ANZ09ANZXXDEC3 Number of Incoming Payments during the Period
JAH10KALJAHRNUMC4 Calendar YearGJAHR
MON10KMONA_FINUMC2 Calendar Month
AGS10AGSXXCURR15(2) Gross Total of Cleared Items without Cash Discount Loss
VZS10VZSXXDEC3 Average arrears with cash discount payments
AGN10AGNXXCURR15(2) Gross Total of Cleared Items with Cash Discount Not Taken
VZN10VZNXXDEC3 Average arrears with payments without cash discount taken
ANZ10ANZXXDEC3 Number of Incoming Payments during the Period
JAH11KALJAHRNUMC4 Calendar YearGJAHR
MON11KMONA_FINUMC2 Calendar Month
AGS11AGSXXCURR15(2) Gross Total of Cleared Items without Cash Discount Loss
VZS11VZSXXDEC3 Average arrears with cash discount payments


AGN11AGNXXCURR15(2) Gross Total of Cleared Items with Cash Discount Not Taken
VZN11VZNXXDEC3 Average arrears with payments without cash discount taken
ANZ11ANZXXDEC3 Number of Incoming Payments during the Period
JAH12KALJAHRNUMC4 Calendar YearGJAHR
MON12KMONA_FINUMC2 Calendar Month
AGS12AGSXXCURR15(2) Gross Total of Cleared Items without Cash Discount Loss
VZS12VZSXXDEC3 Average arrears with cash discount payments
AGN12AGNXXCURR15(2) Gross Total of Cleared Items with Cash Discount Not Taken
VZN12VZNXXDEC3 Average arrears with payments without cash discount taken
ANZ12ANZXXDEC3 Number of Incoming Payments during the Period
JAH13KALJAHRNUMC4 Calendar YearGJAHR
MON13KMONA_FINUMC2 Calendar Month
AGS13AGSXXCURR15(2) Gross Total of Cleared Items without Cash Discount Loss
VZS13VZSXXDEC3 Average arrears with cash discount payments
AGN13AGNXXCURR15(2) Gross Total of Cleared Items with Cash Discount Not Taken
VZN13VZNXXDEC3 Average arrears with payments without cash discount taken
ANZ13ANZXXDEC3 Number of Incoming Payments during the Period
JAH14KALJAHRNUMC4 Calendar YearGJAHR
MON14KMONA_FINUMC2 Calendar Month
AGS14AGSXXCURR15(2) Gross Total of Cleared Items without Cash Discount Loss
VZS14VZSXXDEC3 Average arrears with cash discount payments
AGN14AGNXXCURR15(2) Gross Total of Cleared Items with Cash Discount Not Taken
VZN14VZNXXDEC3 Average arrears with payments without cash discount taken
ANZ14ANZXXDEC3 Number of Incoming Payments during the Period
JAH15KALJAHRNUMC4 Calendar YearGJAHR
MON15KMONA_FINUMC2 Calendar Month
AGS15AGSXXCURR15(2) Gross Total of Cleared Items without Cash Discount Loss
VZS15VZSXXDEC3 Average arrears with cash discount payments
AGN15AGNXXCURR15(2) Gross Total of Cleared Items with Cash Discount Not Taken
VZN15VZNXXDEC3 Average arrears with payments without cash discount taken
ANZ15ANZXXDEC3 Number of Incoming Payments during the Period
JAH16KALJAHRNUMC4 Calendar YearGJAHR
MON16KMONA_FINUMC2 Calendar Month
AGS16AGSXXCURR15(2) Gross Total of Cleared Items without Cash Discount Loss
VZS16VZSXXDEC3 Average arrears with cash discount payments
AGN16AGNXXCURR15(2) Gross Total of Cleared Items with Cash Discount Not Taken
VZN16VZNXXDEC3 Average arrears with payments without cash discount taken
ANZ16ANZXXDEC3 Number of Incoming Payments during the Period



Key field
Non-key field

KNB4 relationships with other tables


BOSG-Uppermost Hierarchy Segment for BRF
     BKPF-Accounting Document Header
          BSEG-Accounting Document Segment
          BSET-Tax Data Document Segment
          FAGLFREESEL-General Ledger: Custom Selections (Enhanced)
     KNA1-General Data in Customer Master
          KNBK-Customer Master (Bank Details)
          KNB1-Customer Master (Company Code)
               KNB4-Customer Payment History
               KNB5-Customer Master (Dunning Data)
               KNKK-Credit Management Cust. Mstr: Control Area Data
               KNC1-Customer Master (Transaction Figures)
               KNC3-Customer Master (Special G/L Transaction Figures)
     LFA1-Vendor Master (General Section)
          LFBK-Vendor Master (Bank Details)
          LFB1-Vendor Master (Company Code)
               LFB5-Vendor Master (Dunning Data)
               LFC1-Vendor Master (Transaction Figures)
               LFC3-Vendor Master (Transaction Figures) Special Ledger
     SKA1-G/L Account Master Record (Chart of Accounts)
          SKB1-G/L Account Master Record (Company Code)
               SKC1A-G/L Sales Segment Derived from GLDB - Internal
               SKC1C-G/L Account C-Segment from GLT0 -Currency Amounts-


KNA1-General Data in Customer Master
     ADDR1_VAL-Address Data
     KNAS-Customer Master (VAT Registration Nos Gen. Sel.)
     KNKA-Customer Master Credit Management: Central Data
     KNKK-Credit Management Cust. Mstr: Control Area Data
     KNBK-Customer Master (Bank Details)
     KNB1-Customer Master (Company Code)
          KNB4-Customer Payment History
          KNB5-Customer Master (Dunning Data)
          KNC1-Customer Master (Transaction Figures)
          KNC3-Customer Master (Special G/L Transaction Figures)
          BSID-Accounting: Secondary Index for Customers
               ADMI_FILES-Archive Files
               BSIDEXT-Secondary Index & Additions Section (bsega)
               BKPF-Accounting Document Header
                    BSEG-Accounting Document Segment
                         WITH_ITEM-Witholding Tax Info.per W/Tax Type and FI Line Itm
                         GSEG-Offsetting Items for B-Segment in Reporting