KNB4_AEDAT SAP (Generated Table for View) Table View details

Dictionary Type: Table View
Description: Generated Table for View




ABAP Code to SELECT data from KNB4_AEDAT
Related tables to KNB4_AEDAT
Access table KNB4_AEDAT




Table View field list including key, data, relationships and ABAP select examples

KNB4_AEDAT is a standard SAP Table View which is used to store Generated Table for View data and is available within R/3 SAP systems depending on the version and release level.

The KNB4_AEDAT table consists of various fields, each holding specific information or linking keys about Generated Table for View data available in SAP. These include KUNNR (Customer Numbers), BUKRS (Company Code), TABNAME (Table Name), KKBER (Credit control area).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified


SAP KNB4_AEDAT table view fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3T000MANDT
KUNNRCustomer Numbers KUNNRCHAR10KNA1ALPHAKUNNRKUNC_KUNNR
BUKRSCompany Code BUKRSCHAR4T001BUKRSBUKC_T001
TABNAMETable Name TABNAMECHAR30AS4TABDTB
KKBERCredit control area KKBERCHAR4KKBERKKB
AUFZDDate as from when the payment history was recorded AUFZDDATS8DATUM
JAH01Calendar Year KALJAHRNUMC4GJAHRGJAHR
MON01Calendar Month KMONA_FINUMC2MONAT
AGS01Gross Total of Cleared Items without Cash Discount Loss AGSXXCURR15(2) WRTV8
VZS01Average arrears with cash discount payments VZSXXDEC3WRTV2
AGN01Gross Total of Cleared Items with Cash Discount Not Taken AGNXXCURR15(2) WRTV8
VZN01Average arrears with payments without cash discount taken VZNXXDEC3WRTV2
ANZ01Number of Incoming Payments during the Period ANZXXDEC3WERT2
JAH02Calendar Year KALJAHRNUMC4GJAHRGJAHR
MON02Calendar Month KMONA_FINUMC2MONAT
AGS02Gross Total of Cleared Items without Cash Discount Loss AGSXXCURR15(2) WRTV8
VZS02Average arrears with cash discount payments VZSXXDEC3WRTV2
AGN02Gross Total of Cleared Items with Cash Discount Not Taken AGNXXCURR15(2) WRTV8
VZN02Average arrears with payments without cash discount taken VZNXXDEC3WRTV2
ANZ02Number of Incoming Payments during the Period ANZXXDEC3WERT2
JAH03Calendar Year KALJAHRNUMC4GJAHRGJAHR
MON03Calendar Month KMONA_FINUMC2MONAT
AGS03Gross Total of Cleared Items without Cash Discount Loss AGSXXCURR15(2) WRTV8
VZS03Average arrears with cash discount payments VZSXXDEC3WRTV2
AGN03Gross Total of Cleared Items with Cash Discount Not Taken AGNXXCURR15(2) WRTV8
VZN03Average arrears with payments without cash discount taken VZNXXDEC3WRTV2
ANZ03Number of Incoming Payments during the Period ANZXXDEC3WERT2
JAH04Calendar Year KALJAHRNUMC4GJAHRGJAHR
MON04Calendar Month KMONA_FINUMC2MONAT
AGS04Gross Total of Cleared Items without Cash Discount Loss AGSXXCURR15(2) WRTV8
VZS04Average arrears with cash discount payments VZSXXDEC3WRTV2
AGN04Gross Total of Cleared Items with Cash Discount Not Taken AGNXXCURR15(2) WRTV8
VZN04Average arrears with payments without cash discount taken VZNXXDEC3WRTV2
ANZ04Number of Incoming Payments during the Period ANZXXDEC3WERT2
JAH05Calendar Year KALJAHRNUMC4GJAHRGJAHR
MON05Calendar Month KMONA_FINUMC2MONAT
AGS05Gross Total of Cleared Items without Cash Discount Loss AGSXXCURR15(2) WRTV8
VZS05Average arrears with cash discount payments VZSXXDEC3WRTV2
AGN05Gross Total of Cleared Items with Cash Discount Not Taken AGNXXCURR15(2) WRTV8
VZN05Average arrears with payments without cash discount taken VZNXXDEC3WRTV2
ANZ05Number of Incoming Payments during the Period ANZXXDEC3WERT2
JAH06Calendar Year KALJAHRNUMC4GJAHRGJAHR
MON06Calendar Month KMONA_FINUMC2MONAT
AGS06Gross Total of Cleared Items without Cash Discount Loss AGSXXCURR15(2) WRTV8
VZS06Average arrears with cash discount payments VZSXXDEC3WRTV2
AGN06Gross Total of Cleared Items with Cash Discount Not Taken AGNXXCURR15(2) WRTV8
VZN06Average arrears with payments without cash discount taken VZNXXDEC3WRTV2
ANZ06Number of Incoming Payments during the Period ANZXXDEC3WERT2
JAH07Calendar Year KALJAHRNUMC4GJAHRGJAHR
MON07Calendar Month KMONA_FINUMC2MONAT
AGS07Gross Total of Cleared Items without Cash Discount Loss AGSXXCURR15(2) WRTV8
VZS07Average arrears with cash discount payments VZSXXDEC3WRTV2
AGN07Gross Total of Cleared Items with Cash Discount Not Taken AGNXXCURR15(2) WRTV8
VZN07Average arrears with payments without cash discount taken VZNXXDEC3WRTV2
ANZ07Number of Incoming Payments during the Period ANZXXDEC3WERT2
JAH08Calendar Year KALJAHRNUMC4GJAHRGJAHR
MON08Calendar Month KMONA_FINUMC2MONAT
AGS08Gross Total of Cleared Items without Cash Discount Loss AGSXXCURR15(2) WRTV8
VZS08Average arrears with cash discount payments VZSXXDEC3WRTV2
AGN08Gross Total of Cleared Items with Cash Discount Not Taken AGNXXCURR15(2) WRTV8
VZN08Average arrears with payments without cash discount taken VZNXXDEC3WRTV2
ANZ08Number of Incoming Payments during the Period ANZXXDEC3WERT2
JAH09Calendar Year KALJAHRNUMC4GJAHRGJAHR
MON09Calendar Month KMONA_FINUMC2MONAT
AGS09Gross Total of Cleared Items without Cash Discount Loss AGSXXCURR15(2) WRTV8
VZS09Average arrears with cash discount payments VZSXXDEC3WRTV2
AGN09Gross Total of Cleared Items with Cash Discount Not Taken AGNXXCURR15(2) WRTV8
VZN09Average arrears with payments without cash discount taken VZNXXDEC3WRTV2
ANZ09Number of Incoming Payments during the Period ANZXXDEC3WERT2
JAH10Calendar Year KALJAHRNUMC4GJAHRGJAHR
MON10Calendar Month KMONA_FINUMC2MONAT
AGS10Gross Total of Cleared Items without Cash Discount Loss AGSXXCURR15(2) WRTV8
VZS10Average arrears with cash discount payments VZSXXDEC3WRTV2
AGN10Gross Total of Cleared Items with Cash Discount Not Taken AGNXXCURR15(2) WRTV8
VZN10Average arrears with payments without cash discount taken VZNXXDEC3WRTV2
ANZ10Number of Incoming Payments during the Period ANZXXDEC3WERT2
JAH11Calendar Year KALJAHRNUMC4GJAHRGJAHR
MON11Calendar Month KMONA_FINUMC2MONAT
AGS11Gross Total of Cleared Items without Cash Discount Loss AGSXXCURR15(2) WRTV8
VZS11Average arrears with cash discount payments VZSXXDEC3WRTV2
AGN11Gross Total of Cleared Items with Cash Discount Not Taken AGNXXCURR15(2) WRTV8
VZN11Average arrears with payments without cash discount taken VZNXXDEC3WRTV2
ANZ11Number of Incoming Payments during the Period ANZXXDEC3WERT2
JAH12Calendar Year KALJAHRNUMC4GJAHRGJAHR
MON12Calendar Month KMONA_FINUMC2MONAT
AGS12Gross Total of Cleared Items without Cash Discount Loss AGSXXCURR15(2) WRTV8
VZS12Average arrears with cash discount payments VZSXXDEC3WRTV2
AGN12Gross Total of Cleared Items with Cash Discount Not Taken AGNXXCURR15(2) WRTV8
VZN12Average arrears with payments without cash discount taken VZNXXDEC3WRTV2
ANZ12Number of Incoming Payments during the Period ANZXXDEC3WERT2
JAH13Calendar Year KALJAHRNUMC4GJAHRGJAHR
MON13Calendar Month KMONA_FINUMC2MONAT
AGS13Gross Total of Cleared Items without Cash Discount Loss AGSXXCURR15(2) WRTV8
VZS13Average arrears with cash discount payments VZSXXDEC3WRTV2
AGN13Gross Total of Cleared Items with Cash Discount Not Taken AGNXXCURR15(2) WRTV8
VZN13Average arrears with payments without cash discount taken VZNXXDEC3WRTV2
ANZ13Number of Incoming Payments during the Period ANZXXDEC3WERT2
JAH14Calendar Year KALJAHRNUMC4GJAHRGJAHR
MON14Calendar Month KMONA_FINUMC2MONAT
AGS14Gross Total of Cleared Items without Cash Discount Loss AGSXXCURR15(2) WRTV8
VZS14Average arrears with cash discount payments VZSXXDEC3WRTV2
AGN14Gross Total of Cleared Items with Cash Discount Not Taken AGNXXCURR15(2) WRTV8
VZN14Average arrears with payments without cash discount taken VZNXXDEC3WRTV2
ANZ14Number of Incoming Payments during the Period ANZXXDEC3WERT2
JAH15Calendar Year KALJAHRNUMC4GJAHRGJAHR
MON15Calendar Month KMONA_FINUMC2MONAT
AGS15Gross Total of Cleared Items without Cash Discount Loss AGSXXCURR15(2) WRTV8
VZS15Average arrears with cash discount payments VZSXXDEC3WRTV2
AGN15Gross Total of Cleared Items with Cash Discount Not Taken AGNXXCURR15(2) WRTV8
VZN15Average arrears with payments without cash discount taken VZNXXDEC3WRTV2
ANZ15Number of Incoming Payments during the Period ANZXXDEC3WERT2
JAH16Calendar Year KALJAHRNUMC4GJAHRGJAHR
MON16Calendar Month KMONA_FINUMC2MONAT
AGS16Gross Total of Cleared Items without Cash Discount Loss AGSXXCURR15(2) WRTV8
VZS16Average arrears with cash discount payments VZSXXDEC3WRTV2
AGN16Gross Total of Cleared Items with Cash Discount Not Taken AGNXXCURR15(2) WRTV8
VZN16Average arrears with payments without cash discount taken VZNXXDEC3WRTV2
ANZ16Number of Incoming Payments during the Period ANZXXDEC3WERT2
AEDATDate of the Last Document Change by Transaction AEDAT_BKPFDATS8DATUM
AETIMTime of Entry CPUTMTIMS6UZEIT

Key field Non-key field



How do I retrieve data from SAP table KNB4_AEDAT using ABAP code

The following ABAP code Example will allow you to do a basic selection on KNB4_AEDAT to SELECT all data from the table
DATA: WA_KNB4_AEDAT TYPE KNB4_AEDAT.

SELECT SINGLE *
FROM KNB4_AEDAT
INTO CORRESPONDING FIELDS OF WA_KNB4_AEDAT
WHERE...

How to access SAP table KNB4_AEDAT

Within an ECC or HANA version of SAP you can also view further information about KNB4_AEDAT and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!