The KNA1 table in SAP contains customer master data and is used to store information about customers. Here’s a simplified representation of the KNA1 table schema as a CSV list:
Field Name,Data Type,Description
MANDT,CHAR(3),Client (SAP System)
KUNNR,CHAR(10),Customer Number
KTOKD,CHAR(4),Customer Account Group
BUKRS,CHAR(4),Company Code
NAME1,CHAR(35),Name 1 (Organization)
NAME2,CHAR(35),Name 2 (Organization)
SORTL,CHAR(20),Search Term 1
STRAS,CHAR(35),Street and House Number
PFACH,CHAR(10),P.O. Box
PSTLZ,CHAR(10),Postal Code
ORT01,CHAR(35),City
REGIO,CHAR(3),Region (e.g., State or Province)
LAND1,CHAR(3),Country Key
Telf1,CHAR(16),Telephone Number 1
Telfx,CHAR(31),Fax Number
TELFX,CHAR(31),Telex Number
XCPDK,CHAR(3),Central Person (e.g., Contact Person)
SPERR,CHAR(1),Customer Master Record Blocked for Posting
LOEVG,CHAR(1),Deletion Indicator for a Customer
The actual KNA1 table in your SAP system may have additional fields or details depending on your system’s configuration and the version of SAP you are using.
This is a simplified representation for illustration purposes, and the data types and lengths of fields may vary in your specific SAP environment.
You should refer to your SAP system’s documentation or consult with your SAP administrator for precise information about the KNA1 table schema in your system.