KNB4

Customer Payment History | #masterdata | Component: Customer Master
Column Name Description
MANDT FK Client
KUNNR FK Customer Number
BUKRS FK Company Code
Column Name Description
💲 Currency Key (T001.WAERS):
AGS01 Gross Total of Cleared Items Without Cash Discount Loss
AGN01 Gross Total of Cleared Items with Cash Discount Not Taken
AGS02 Gross Total of Cleared Items Without Cash Discount Loss
AGN02 Gross Total of Cleared Items with Cash Discount Not Taken
AGS03 Gross Total of Cleared Items Without Cash Discount Loss
AGN03 Gross Total of Cleared Items with Cash Discount Not Taken
AGS04 Gross Total of Cleared Items Without Cash Discount Loss
AGN04 Gross Total of Cleared Items with Cash Discount Not Taken
AGS05 Gross Total of Cleared Items Without Cash Discount Loss
AGN05 Gross Total of Cleared Items with Cash Discount Not Taken
AGS06 Gross Total of Cleared Items Without Cash Discount Loss
AGN06 Gross Total of Cleared Items with Cash Discount Not Taken
AGS07 Gross Total of Cleared Items Without Cash Discount Loss
AGN07 Gross Total of Cleared Items with Cash Discount Not Taken
AGS08 Gross Total of Cleared Items Without Cash Discount Loss
AGN08 Gross Total of Cleared Items with Cash Discount Not Taken
AGS09 Gross Total of Cleared Items Without Cash Discount Loss
AGN09 Gross Total of Cleared Items with Cash Discount Not Taken
AGS10 Gross Total of Cleared Items Without Cash Discount Loss
AGN10 Gross Total of Cleared Items with Cash Discount Not Taken
AGS11 Gross Total of Cleared Items Without Cash Discount Loss
AGN11 Gross Total of Cleared Items with Cash Discount Not Taken
AGS12 Gross Total of Cleared Items Without Cash Discount Loss
AGN12 Gross Total of Cleared Items with Cash Discount Not Taken
AGS13 Gross Total of Cleared Items Without Cash Discount Loss
AGN13 Gross Total of Cleared Items with Cash Discount Not Taken
AGS14 Gross Total of Cleared Items Without Cash Discount Loss
AGN14 Gross Total of Cleared Items with Cash Discount Not Taken
AGS15 Gross Total of Cleared Items Without Cash Discount Loss
AGN15 Gross Total of Cleared Items with Cash Discount Not Taken
AGS16 Gross Total of Cleared Items Without Cash Discount Loss
AGN16 Gross Total of Cleared Items with Cash Discount Not Taken
Column Name Description
Column Name Description
AUFZD Date as from When the Payment History Was Recorded
Column Name Description
Column Name Description Domain name
JAH01 Calendar Year GJAHR
MON01 Calendar Month MONAT
VZS01 Average Arrears with Cash Discount Payments WRTV2
VZN01 Average Arrears for Payments Where No Cash Discount Taken WRTV2
ANZ01 Number of Incoming Payments During the Period WERT2
JAH02 Calendar Year GJAHR
MON02 Calendar Month MONAT
VZS02 Average Arrears with Cash Discount Payments WRTV2
VZN02 Average Arrears for Payments Where No Cash Discount Taken WRTV2
ANZ02 Number of Incoming Payments During the Period WERT2
JAH03 Calendar Year GJAHR
MON03 Calendar Month MONAT
VZS03 Average Arrears with Cash Discount Payments WRTV2
VZN03 Average Arrears for Payments Where No Cash Discount Taken WRTV2
ANZ03 Number of Incoming Payments During the Period WERT2
JAH04 Calendar Year GJAHR
MON04 Calendar Month MONAT
VZS04 Average Arrears with Cash Discount Payments WRTV2
VZN04 Average Arrears for Payments Where No Cash Discount Taken WRTV2
ANZ04 Number of Incoming Payments During the Period WERT2
JAH05 Calendar Year GJAHR
MON05 Calendar Month MONAT
VZS05 Average Arrears with Cash Discount Payments WRTV2
VZN05 Average Arrears for Payments Where No Cash Discount Taken WRTV2
ANZ05 Number of Incoming Payments During the Period WERT2
JAH06 Calendar Year GJAHR
MON06 Calendar Month MONAT
VZS06 Average Arrears with Cash Discount Payments WRTV2
VZN06 Average Arrears for Payments Where No Cash Discount Taken WRTV2
ANZ06 Number of Incoming Payments During the Period WERT2
JAH07 Calendar Year GJAHR
MON07 Calendar Month MONAT
VZS07 Average Arrears with Cash Discount Payments WRTV2
VZN07 Average Arrears for Payments Where No Cash Discount Taken WRTV2
ANZ07 Number of Incoming Payments During the Period WERT2
JAH08 Calendar Year GJAHR
MON08 Calendar Month MONAT
VZS08 Average Arrears with Cash Discount Payments WRTV2
VZN08 Average Arrears for Payments Where No Cash Discount Taken WRTV2
ANZ08 Number of Incoming Payments During the Period WERT2
JAH09 Calendar Year GJAHR
MON09 Calendar Month MONAT
VZS09 Average Arrears with Cash Discount Payments WRTV2
VZN09 Average Arrears for Payments Where No Cash Discount Taken WRTV2
ANZ09 Number of Incoming Payments During the Period WERT2
JAH10 Calendar Year GJAHR
MON10 Calendar Month MONAT
VZS10 Average Arrears with Cash Discount Payments WRTV2
VZN10 Average Arrears for Payments Where No Cash Discount Taken WRTV2
ANZ10 Number of Incoming Payments During the Period WERT2
JAH11 Calendar Year GJAHR
MON11 Calendar Month MONAT
VZS11 Average Arrears with Cash Discount Payments WRTV2
VZN11 Average Arrears for Payments Where No Cash Discount Taken WRTV2
ANZ11 Number of Incoming Payments During the Period WERT2
JAH12 Calendar Year GJAHR
MON12 Calendar Month MONAT
VZS12 Average Arrears with Cash Discount Payments WRTV2
VZN12 Average Arrears for Payments Where No Cash Discount Taken WRTV2
ANZ12 Number of Incoming Payments During the Period WERT2
JAH13 Calendar Year GJAHR
MON13 Calendar Month MONAT
VZS13 Average Arrears with Cash Discount Payments WRTV2
VZN13 Average Arrears for Payments Where No Cash Discount Taken WRTV2
ANZ13 Number of Incoming Payments During the Period WERT2
JAH14 Calendar Year GJAHR
MON14 Calendar Month MONAT
VZS14 Average Arrears with Cash Discount Payments WRTV2
VZN14 Average Arrears for Payments Where No Cash Discount Taken WRTV2
ANZ14 Number of Incoming Payments During the Period WERT2
JAH15 Calendar Year GJAHR
MON15 Calendar Month MONAT
VZS15 Average Arrears with Cash Discount Payments WRTV2
VZN15 Average Arrears for Payments Where No Cash Discount Taken WRTV2
ANZ15 Number of Incoming Payments During the Period WERT2
JAH16 Calendar Year GJAHR
MON16 Calendar Month MONAT
VZS16 Average Arrears with Cash Discount Payments WRTV2
VZN16 Average Arrears for Payments Where No Cash Discount Taken WRTV2
ANZ16 Number of Incoming Payments During the Period WERT2
Master Data Relations Join Conditions
Company Code
  • KNB4.MANDT == T001.MANDT
  • KNB4.BUKRS == T001.BUKRS
Customer Number
  • KNB4.MANDT == KNA1.MANDT
  • KNB4.KUNNR == KNA1.KUNNR
Client KNB4.MANDT == T000.MANDT