1. SAP Tutorial
  2. SD Module

/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

    • /BEV1/CLDEB related tables

    • /BEV1/CLT901 : Table for Follow-Up Code Check
    • /BEV1/CLT998 : Table for Border Crossing Points
    • /BEV1/CLSCH : Ship Information
    • /BEV1/CLCONT1 : Container Information
    • /BEV1/CLT900 : Table for Door/Ramp Check
    • /BEV1/CLT999 : Table for Order Types Allowed in CL
    • /BEV1/CLT902 : Table for Representative Check
    • /BEV1/CLHAF : Port Master

    Related References

    Related Tutorials

    /BEV1/CLSCH SAP table for – Ship Information

    /BEV1/CLSCH table in SAP SD (Sales in SD) module. This tables is used for storing data of Ship Information. Here...

    /BEV1/CLCONT1 SAP table for – Container Information

    /BEV1/CLCONT1 table in SAP SD (Sales in SD) module. This tables is used for storing data of Container Information. Here...

    /BEV1/BO_VIS SAP table for – Sales Information Structures for Rebate Processing

    /BEV1/BO_VIS table in SAP SD (Sales in SD) module. This tables is used for storing data of Sales Information Structures...

    /BEV1/RSFFRCH SAP table for – General Information About Collection

    /BEV1/RSFFRCH table in SAP SD (Sales in SD) module. This tables is used for storing data of General Information About...

    /BEV1/BO_FIELDS SAP table for – Field Conversion Condition Table for Information Structure

    /BEV1/BO_FIELDS table in SAP SD (Sales in SD) module. This tables is used for storing data of Field Conversion Condition...

    /BEV1/CLT902 SAP table for – Table for Representative Check

    /BEV1/CLT902 table in SAP SD (Sales in SD) module. This tables is used for storing data of Table for Representative...

    /BEV1/RSFFROR SAP table for – Order Information for Account Assignment

    /BEV1/RSFFROR table in SAP SD (Sales in SD) module. This tables is used for storing data of Order Information for...

    «
    »