COMPSQU SAP table for – OCM: Comparison results; Single records for sequences

Here we would like to draw your attention to COMPSQU table in SAP. As we know it is being mainly used with the SAP PP-SFC (Production Orders – PP) component which is coming under PP module (Production Planning). COMPSQU is a SAP standard transparent table used for storing OCM: Comparison results; Single records for sequences related data in SAP. It comes under the package COCM.

SAP COMPSQU table

Table COMPSQU technical data

TableCOMPSQU
Data storingOCM: Comparison results; Single records for sequences
ModulePP
ComponentPP-SFC
SAP PackageCOCM
Delivery ClassA – Application table (master and transaction data)
Table CategoryTRANSPARENT

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

  • MANDT : Client
    Its a key field. Its data type is C (Character String) with field length 3
  • APLZL2
    Its data type is N (Character String with Digits Only) with field length 8
  • PLNFL2
    Its data type is C (Character String) with field length 6
  • RESULT
    Its data type is C (Character String) with field length 1
  • LOWDIFF
    Its data type is C (Character String) with field length 1
  • CONFTYP
    Its data type is N (Character String with Digits Only) with field length 1
  • STATUS : AC: Context Status
    Its data type is C (Character String) with field length 1
  • EXKEY
    Its data type is C (Character String) with field length 30
  • LTXA1 : Sequence description
    Its data type is C (Character String) with field length 40
  • AENNR : Change Number
    Its data type is C (Character String) with field length 12
  • COMPNUM
    Its a key field. Its data type is N (Character String with Digits Only) with field length 10
  • COMPCNT
    Its a key field. Its data type is N (Character String with Digits Only) with field length 6
  • VSNMR1
    Its data type is C (Character String) with field length 12
  • AUFPL1
    Its data type is N (Character String with Digits Only) with field length 10
  • APLZL1
    Its data type is N (Character String with Digits Only) with field length 8
  • PLNFL1
    Its data type is C (Character String) with field length 6
  • VSNMR2
    Its data type is C (Character String) with field length 12
  • AUFPL2
    Its data type is N (Character String with Digits Only) with field length 10