/BEV1/CLDEB SAP table for – Customer Information

Here we would like to draw your attention to /BEV1/CLDEB table in SAP. As we know it is being mainly used with the SAP SD-SLS (Sales in SD) component which is coming under SD module (Sales & Distribution). /BEV1/CLDEB is a SAP standard transparent table used for storing Customer Information related data in SAP. It comes under the package /BEV1/CL.

SAP /BEV1/CLDEB table

Table /BEV1/CLDEB technical data

Table/BEV1/CLDEB
Data storingCustomer Information
ModuleSD
ComponentSD-SLS
SAP Package/BEV1/CL
Delivery ClassA – Application table (master and transaction data)
Table CategoryTRANSPARENT

SAP /BEV1/CLDEB Table Fields

Here is the details of each fields in this table.You can find the discription, data type and assigned lenth of each of the fields in /BEV1/CLDEB table.

  • MANDT : Client
    Its a key field. Its data type is C (Character String) with field length 3
  • PFACH
    Its data type is C (Character String) with field length 10
  • PSTL2
    Its data type is C (Character String) with field length 10
  • PSTLZ : Postal Code
    Its data type is C (Character String) with field length 10
  • PFORT
    Its data type is C (Character String) with field length 35
  • LAND1 : Country Key
    Its data type is C (Character String) with field length 3
  • REGIO : Region (State, Province, County)
    Its data type is C (Character String) with field length 3
  • STRAS
    Its data type is C (Character String) with field length 30
  • COTGR
    Its data type is N (Character String with Digits Only) with field length 3
  • SPRAS : Language Key
    Its data type is C (Character String) with field length 1
  • TELX1
    Its data type is C (Character String) with field length 30
  • KUNNR : Customer number
    Its a key field. Its data type is C (Character String) with field length 10
  • TELF1
    Its data type is C (Character String) with field length 16
  • TELFX
    Its data type is C (Character String) with field length 31
  • TELF2
    Its data type is C (Character String) with field length 16
  • TELTX
    Its data type is C (Character String) with field length 30
  • TELBX
    Its data type is C (Character String) with field length 15
  • DATLT
    Its data type is C (Character String) with field length 14
  • MATNR : Material Number
    Its data type is C (Character String) with field length 18
  • CODE : Code
    Its data type is C (Character String) with field length 4
  • MAXGE
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • STEUNR
    Its data type is C (Character String) with field length 20
  • ANRED
    Its data type is C (Character String) with field length 15
  • KAISCH
    Its data type is X (Byte string) with field length 1
  • DOOR
    Its data type is C (Character String) with field length 4
  • FREIGT
    Its data type is C (Character String) with field length 40
  • PAID
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • SALES
    Its data type is C (Character String) with field length 4
  • NACHL
    Its data type is C (Character String) with field length 4
  • JA
    Its data type is C (Character String) with field length 1
  • GRENZE
    Its data type is C (Character String) with field length 2
  • VERPTX
    Its data type is C (Character String) with field length 50
  • KUNDE
    Its data type is C (Character String) with field length 20
  • NAME1 : Name 1
    Its data type is C (Character String) with field length 35
  • ERGEI
    Its data type is C (Character String) with field length 3
  • NAME2 : Name 2
    Its data type is C (Character String) with field length 35
  • NAME3 : Name 3
    Its data type is C (Character String) with field length 35
  • NAME4 : Name 4
    Its data type is C (Character String) with field length 35
  • ORT01
    Its data type is C (Character String) with field length 35
  • ORT02
    Its data type is C (Character String) with field length 35