PRICAT_K003 SAP table for – PRICAT: Catalog item basic data

Here we would like to draw your attention to PRICAT_K003 table in SAP. As we know it is being mainly used with the SAP SD-EDI (Electronic Data Interchange in SD) component which is coming under SD module (Sales & Distribution). PRICAT_K003 is a SAP standard transparent table used for storing PRICAT: Catalog item basic data related data in SAP. It comes under the package VPRI.

SAP PRICAT_K003 table

Table PRICAT_K003 technical data

TablePRICAT_K003
Data storingPRICAT: Catalog item basic data
ModuleSD
ComponentSD-EDI
SAP PackageVPRI
Delivery ClassA – Application table (master and transaction data)
Table CategoryTRANSPARENT

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

  • MATERIAL_GROUP
    Its data type is C (Character String) with field length 35
  • SHELF_LIFE_MSG
    Its data type is C (Character String) with field length 6
  • COMPOSITION
    Its data type is C (Character String) with field length 3
  • MATNR : Material Number
    Its data type is C (Character String) with field length 18
  • MATL_GROUP
    Its data type is C (Character String) with field length 9
  • PRINBR
    Its a key field. Its data type is C (Character String) with field length 10
  • DEL_FLAG : Replacement for Real Boolean Type: ‘X’ == True ” == False
    Its data type is C (Character String) with field length 1
  • STOR_CONDS
    Its data type is C (Character String) with field length 2
  • HAZ_MAT_NO
    Its data type is C (Character String) with field length 18
  • SEASON
    Its data type is C (Character String) with field length 4
  • PACK_WT_UN
    Its data type is C (Character String) with field length 3
  • PRODUCTGROUP
    Its a key field. Its data type is C (Character String) with field length 18
  • ALLWD_VOL
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • PACK_VO_UN_ISO
    Its data type is C (Character String) with field length 3
  • SH_MAT_TYP
    Its data type is C (Character String) with field length 4
  • FILL_LEVEL
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 2
  • STACK_FACT
    Its data type is X (Byte string) with field length 2
  • MINREMLIFE
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 3
  • EAN_UPC_BASE
    Its a key field. Its data type is C (Character String) with field length 35
  • STOR_PCT
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 2
  • SAESON_YR
    Its data type is C (Character String) with field length 4
  • EXTMATLGRP
    Its data type is C (Character String) with field length 18
  • CONT_UNIT
    Its data type is C (Character String) with field length 3
  • NET_CONT
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • ENVT_RLVT
    Its data type is C (Character String) with field length 1
  • HAZMATPROF
    Its data type is C (Character String) with field length 3
  • LOOSEORLIQ
    Its data type is C (Character String) with field length 1
  • CLOSED_BOX
    Its data type is C (Character String) with field length 1
  • PERIOD_IND_EXPIR
    Its data type is C (Character String) with field length 1
  • EAN_UPC_TYPE
    Its data type is C (Character String) with field length 2
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes
    Its include structure/component is is PRIMAW1RT
  • SALES_UNIT_ISO
    Its data type is C (Character String) with field length 3
  • ISSUE_UNIT_ISO
    Its data type is C (Character String) with field length 3
  • COUNTRYORI_ISO
    Its data type is C (Character String) with field length 2
  • COMM_CODE
    Its data type is C (Character String) with field length 17
  • BEARB_STATUS
    Its data type is C (Character String) with field length 2
  • LOCK_STATUS
    Its data type is C (Character String) with field length 1
  • VENDOR_SATNR
    Its data type is C (Character String) with field length 20
  • PROC_STATUS
    Its data type is C (Character String) with field length 2
  • TAKE_OVER_DATE
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • MORE_MATNR
    Its data type is C (Character String) with field length 1
  • STATEINDICATOR
    Its data type is C (Character String) with field length 2
  • HIER_ID
    Its data type is C (Character String) with field length 2
  • MERKMALSPROFIL
    Its data type is C (Character String) with field length 18
  • PROFILENAME
    Its data type is C (Character String) with field length 40
  • PUR_GROUP
    Its data type is C (Character String) with field length 3