/CBAD/CONTRACT_I SAP table for – Advanced Order Processing and Billing: Item Data

Here we would like to draw your attention to /CBAD/CONTRACT_I 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). /CBAD/CONTRACT_I is a SAP standard transparent table used for storing Advanced Order Processing and Billing: Item Data related data in SAP. It comes under the package /CBAD/CONTRACT_MOD.

SAP /CBAD/CONTRACT_I table

Table /CBAD/CONTRACT_I technical data

Table/CBAD/CONTRACT_I
Data storingAdvanced Order Processing and Billing: Item Data
ModuleSD
ComponentSD-SLS
SAP Package/CBAD/CONTRACT_MOD
Delivery ClassA – Application table (master and transaction data)
Table CategoryTRANSPARENT

SAP /CBAD/CONTRACT_I 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 /CBAD/CONTRACT_I table.

  • MANDT : Client
    Its a key field. Its data type is C (Character String) with field length 3
  • BILL_TYP
    Its data type is C (Character String) with field length 1
  • NOPAC
    Its data type is C (Character String) with field length 1
  • FUN_SOU
    Its data type is C (Character String) with field length 1
  • REQ_DEF_DATE
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • DEF_DATE
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • DEF_MOD_NO
    Its data type is C (Character String) with field length 10
  • PER_ST_DATE
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • PER_END_DATE
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • DESCR : Simple Setup: Description
    Its data type is C (Character String) with field length 40
  • ERNAM : Name of Person who Created the Object
    Its data type is C (Character String) with field length 12
  • CVBELN
    Its a key field. Its data type is C (Character String) with field length 10
  • ERDAT : Date on which the record was created
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • AENAM : Name of Person Who Changed Object
    Its data type is C (Character String) with field length 12
  • AEDAT : (8-character) Date for SYST
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • USR01 : User field with 20 characters
    Its data type is C (Character String) with field length 15
  • USR02 : User field with 10 characters
    Its data type is C (Character String) with field length 20
  • USR03 : User field with 10 characters
    Its data type is C (Character String) with field length 30
  • USR04 : User field for quantity (length 10.3)
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • USR05 : User field for quantity (length 10.3)
    Its data type is C (Character String) with field length 3
  • USR06 : User-defined field for values (length 10,3)
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • USR07 : User-defined field for values (length 10,3)
    Its data type is C (Character String) with field length 5
  • CPOSNR
    Its a key field. Its data type is N (Character String with Digits Only) with field length 6
  • USER_POSNR
    Its data type is C (Character String) with field length 10
  • MOD_ID
    Its data type is C (Character String) with field length 15
  • VER_NO
    Its a key field. Its data type is N (Character String with Digits Only) with field length 6
  • POS_TYPE
    Its data type is C (Character String) with field length 1
  • DEL_FLAG : Replacement for Real Boolean Type: ‘X’ == True ” == False
    Its data type is C (Character String) with field length 1
  • POSNR : Item number of the SD document
    Its data type is N (Character String with Digits Only) with field length 6
  • PAR_CPOSNR
    Its data type is N (Character String with Digits Only) with field length 6
  • EFF_DATE
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8