MSCA SAP table for – Sales Orders on Hand with Vendor

Here we would like to draw your attention to MSCA table in SAP. As we know it is being mainly used with the SAP LO-MD (Logistics Basic Data in LO) component which is coming under LO module (Logistics). MSCA is a SAP standard transparent table used for storing Sales Orders on Hand with Vendor related data in SAP. It comes under the package MG.

SAP MSCA table

Table MSCA technical data

TableMSCA
Data storingSales Orders on Hand with Vendor
ModuleLO
ComponentLO-MD
SAP PackageMG
Delivery ClassA – Application table (master and transaction data)
Table CategoryTRANSPARENT

SAP MSCA 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 MSCA table.

  • MANDT : Client
    Its a key field. Its data type is C (Character String) with field length 3
  • LFMON
    Its data type is N (Character String with Digits Only) with field length 2
  • CALAB
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • CASPE
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • CAVIN
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • CAVSP
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • CAILQ
    Its data type is C (Character String) with field length 3
  • CAVLL
    Its data type is C (Character String) with field length 3
  • CAFLL
    Its data type is C (Character String) with field length 3
  • CAFLS
    Its data type is C (Character String) with field length 3
  • CAJIN
    Its data type is N (Character String with Digits Only) with field length 4
  • WERKS : Plant
    Its a key field. Its data type is C (Character String) with field length 4
  • LIFNR : Vendor’s account number
    Its a key field. Its data type is C (Character String) with field length 10
  • VBELN : Sales and Distribution Document Number
    Its a key field. Its data type is C (Character String) with field length 10