1. Home
  2. Resources
  3. SAP Tables
  4. PRICAT_K003 - PRICAT: Catalog item basic data

SAP Table PRICAT_K003

PRICAT: Catalog item basic data

PRICAT_K003 (PRICAT: Catalog item basic data) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link PRICAT_K003 to other SAP tables.

Source: PRICAT_K003 (PRICAT: Catalog item basic data)

PRICAT_K003 table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
PRINBR PRICAT: Unique internal catalog number PRINBR PRICAT_K001 CHAR 10 0
PRODUCTGROUP PRICAT: PGI or assortment module from Pricat IDoc PRIPRODUCTGROUP PRICAT_K002 CHAR 18 0
EAN_UPC_BASE PRICAT: EAN/UPC Code of Base Unit of Measure PRIEANBASIS CHAR 35 0
VALIDITY_BASE Price Catalog Inbound Start of Validity Period PRIVALIDITY DATS 8 0
EAN_UPC_TYPE Type of material identification PRIEANTYP CHAR 2 0
BEARB_STATUS PRICAT: Status of material/unit of measure processing PRIBEARBSTAT CHAR 2 0
00 To be processed
01 Updated
02 Never display again
STATEINDICATOR PRICAT: Movement Indicator for the Item PRISTATEINDICATOR CHAR 2 0
1 New entry
2 Deletion
3 Change
4 No change
5 Proposed New Creation
6 Reactivation
1E Error correction
PUR_GROUP Purchasing Group EKGRP T024 CHAR 3 0
MATERIAL_GROUP PRICAT: Material Group from Message PRIMATKL CHAR 35 0
MAT_ID_SENDER PRICAT: Material Number of the Sender of the Message PRIMATLIEF CHAR 35 0
SHELF_LIFE_MSG PRICAT: Shelf life expiration in time unit from message PRIMHD CHAR 6 0
SHELF_LIFE_QUAL PRICAT: Qualifier for periods PRIQUALPERIOD CHAR 3 0
COMPOSITION PRICAT: Product Composition PRICOMPOSITION CHAR 3 0
MATNR Material Number MATNR MARA CHAR 18 0
MATL_TYPE Material Type MTART T134 CHAR 4 0
MATL_GROUP Material Group MATKL CHAR 9 0
MATL_CAT Material Category ATTYP CHAR 2 0
NULL Single material (industry)
00 Single material
01 Generic material
02 Variant
10 Sales set
11 Prepack
12 Display
20 Material group material
21 Hierarchy material
22 Group material
30 Material group reference material
DEL_FLAG Flag Material for Deletion at Client Level LVOMA CHAR 1 0
X Yes
NULL No
CONTAINER Container requirements BEHVO T144 CHAR 2 0
STOR_CONDS Storage conditions RAUBE T142 CHAR 2 0
TEMP_CONDS Temperature conditions indicator TEMPB T143 CHAR 2 0
HAZ_MAT_NO Hazardous material number STOFF MGEF CHAR 18 0
DIVISION Division SPART TSPA CHAR 2 0
SEASON Season Category SAISO T6WSP CHAR 4 0
ALLOWED_WT Allowed packaging weight ERGEW QUAN 13 3
PACK_WT_UN Unit of weight (allowed packaging weight) ERGEI T006 UNIT 3 0
PACK_WT_UN_ISO Unit of weight (allowed packaging weight) in ISO code ERGEI_ISO T006I CHAR 3 0
ALLWD_VOL Allowed packaging volume ERVOL QUAN 13 3
PACK_VO_UN Volume unit (allowed packaging volume) ERVOE T006 UNIT 3 0
PACK_VO_UN_ISO Volume unit (allowed packaging volume) in ISO code ERVOE_ISO T006I CHAR 3 0
VAR_ORD_UN Variable Purchase Order Unit Active VABME CHAR 1 0
NULL Not active
1 Active
2 Active with own price
BATCH_MGMT Batch management requirement indicator XCHPF CHAR 1 0
X Yes
NULL No
SH_MAT_TYP Packaging Material Type VHIART TVTY CHAR 4 0
FILL_LEVEL Maximum level (by volume) FUELG DEC 3 0
STACK_FACT Stacking factor STFAK INT2 5 0
MAT_GRP_SM Material Group: Packaging Materials MAGRV TVEGR CHAR 4 0
MINREMLIFE Minimum Remaining Shelf Life MHDRZ DEC 4 0
SHELF_LIFE Total shelf life MHDHB DEC 4 0
STOR_PCT Storage percentage MHDLP DEC 3 0
SAESON_YR Season Year SAISJ CHAR 4 0
PRICE_BAND Price Band Category PLGTP TWPT CHAR 2 0
EMPTIESBOM Empties Bill of Material W_MITLEERG CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
EXTMATLGRP External Material Group EXTWG CHAR 18 0
CONT_UNIT Content unit INHME T006 UNIT 3 0
CONT_UNIT_ISO Content unit in ISO code INHME_ISO T006I CHAR 3 0
NET_CONT Net contents INHAL QUAN 13 3
COMPPRUNIT Comparison price unit VPREH DEC 5 0
GROSS_CONT Gross contents INHBR QUAN 13 3
ENVT_RLVT Environmentally Relevant KZUMW CHAR 1 0
X Yes
NULL No
SEASMATCAT Rollout in a Season SAITY T6WSA CHAR 2 0
HAZMATPROF Dangerous Goods Indicator Profile ADGE_PROFL TDG41 CHAR 3 0
HIGH_VISC Indicator: Highly Viscous ADGE_IHIVI CHAR 1 0
X Yes
NULL No
LOOSEORLIQ Indicator: In Bulk/Liquid ADGE_ILOOS CHAR 1 0
X Yes
NULL No
CLOSED_BOX Packaging Material is Closed Packaging KZGVH CHAR 1 0
X Yes
NULL No
APPD_B_REC Indicator: Approved batch record required XGCHP CHAR 1 0
X Yes
NULL No
PERIOD_IND_EXPIR Period Indicator for Shelf Life Expiration Date DATTP CHAR 1 0
ROUND_RULE_EXPIR Rounding rule for calculation of SLED RDMHD CHAR 1 0
NULL No rounding off
- Start of chosen period (week, month or year)
+ End of chosen period (week, month or year)
F Start of the following period (week, month, year)
PROD_COMP_PACKAG Indicator: Product composition printed on packaging PRZUS CHAR 1 0
X Yes
NULL No
SALES_UNIT Sales unit VRKME T006 UNIT 3 0
SALES_UNIT_ISO Sales unit in ISO code VRKME_ISO T006I CHAR 3 0
ISSUE_UNIT Unit of issue AUSME T006 UNIT 3 0
ISSUE_UNIT_ISO Unit of issue in ISO code AUSME_ISO T006I CHAR 3 0
COUNTRYORI Country of origin of the material HERKL T005 CHAR 3 0
COUNTRYORI_ISO Material's country of origin in ISO code HERKL_ISO CHAR 2 0
REGIONORIG Region of origin of material (non-preferential origin) HERKR T005S CHAR 3 0
COMM_CODE Commodity Code/Import Code Number for Foreign Trade STAWN T604 CHAR 17 0
LOCK_STATUS Lock Status (Yes or No) WRF_LOCK_STATUS CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
SATNR Cross-Plant Configurable Material SATNR CHAR 18 0
VENDOR_SATNR Price Catalog: Grouping Field: Generic Article Assignment WRF_VENDOR_SATNR CHAR 20 0
SATNR_HEAD_FLAG Master Variant WRF_MASTER_VARIANT CHAR 1 0
PROC_STATUS Processing Status WRF_PROCSTATUS WRF_PRICAT_PROC CHAR 2 0
TAKE_OVER_DATE Transfer Date (in PRICAT Data Pool) WRF_TAKE_OVER_DATE DATS 8 0
TRIGGER_DATE Primary Update Date Set Online WRF_TRIGGER_DATE DATS 8 0
MORE_MATNR Price Catalog Indicator EAN for Mat. No. = 1..n MORE_MATNR CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
REF_ARTICLE Material group reference material WWGDA MARA CHAR 18 0
HIER_ID Hierarchy WRF_HIER_CNT CHAR 2 0
HIER_NODE Hierarchy Node WRF_STRUC_NODE CHAR 18 0
MERKMALSPROFIL Characteristic Profile WRF_PROFIL CHAR 18 0
MANUAL_CHANGE Manual Change MANUAL_CHANGE CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
PROFILENAME Profile Name WRF_PROFILENAME CHAR 40 0
CAT_GROUP_1 KATALOG_GRUPPE CATALOGUE_GROUP WRF_CAT_GROUP CHAR 12 0
CAT_GROUP_2 KATALOG_GRUPPE CATALOGUE_GROUP WRF_CAT_GROUP CHAR 12 0
CAT_GROUP_3 KATALOG_GRUPPE CATALOGUE_GROUP WRF_CAT_GROUP CHAR 12 0

PRICAT_K003 foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
PRICAT_K003 CAT_GROUP_1 PRICAT_K003 MANDT WRF_CAT_GROUP Catalog Group MANDT
PRICAT_K003 CAT_GROUP_1 PRICAT_K003 CAT_GROUP_1 WRF_CAT_GROUP Catalog Group CATALOGUE_GROUP
PRICAT_K003 CAT_GROUP_2 PRICAT_K003 MANDT WRF_CAT_GROUP Catalog Group MANDT
PRICAT_K003 CAT_GROUP_2 PRICAT_K003 CAT_GROUP_2 WRF_CAT_GROUP Catalog Group CATALOGUE_GROUP
PRICAT_K003 CAT_GROUP_3 PRICAT_K003 MANDT WRF_CAT_GROUP Catalog Group MANDT
PRICAT_K003 CAT_GROUP_3 PRICAT_K003 CAT_GROUP_3 WRF_CAT_GROUP Catalog Group CATALOGUE_GROUP
PRICAT_K003 COMM_CODE PRICAT_K003 COMM_CODE T604 Foreign Trade: Commodity Code / Import Code Number STAWN
PRICAT_K003 COMM_CODE T130S LAND1 T604 Foreign Trade: Commodity Code / Import Code Number LAND1
PRICAT_K003 COMM_CODE SYST MANDT T604 Foreign Trade: Commodity Code / Import Code Number MANDT
PRICAT_K003 CONTAINER PRICAT_K003 CONTAINER T144 Container Requirements for Storing Materials BEHVO
PRICAT_K003 CONTAINER SYST MANDT T144 Container Requirements for Storing Materials MANDT
PRICAT_K003 CONT_UNIT SYST MANDT T006 Units of Measurement MANDT
PRICAT_K003 CONT_UNIT PRICAT_K003 CONT_UNIT T006 Units of Measurement MSEHI
PRICAT_K003 CONT_UNIT_ISO PRICAT_K003 CONT_UNIT_ISO T006I ISO codes for units of measurement ISOCODE
PRICAT_K003 CONT_UNIT_ISO SYST MANDT T006I ISO codes for units of measurement CLIENT
PRICAT_K003 COUNTRYORI SYST MANDT T005 Countries MANDT
PRICAT_K003 COUNTRYORI PRICAT_K003 COUNTRYORI T005 Countries LAND1
PRICAT_K003 DIVISION SYST MANDT TSPA Organizational Unit: Sales Divisions MANDT
PRICAT_K003 DIVISION PRICAT_K003 DIVISION TSPA Organizational Unit: Sales Divisions SPART
PRICAT_K003 HAZMATPROF PRICAT_K003 HAZMATPROF TDG41 DG: DG Indicator Profiles for Material Master PROFL
PRICAT_K003 HAZMATPROF SYST MANDT TDG41 DG: DG Indicator Profiles for Material Master MANDT
PRICAT_K003 HAZ_MAT_NO SYST MANDT MGEF Hazardous materials MANDT
PRICAT_K003 HAZ_MAT_NO PRICAT_K003 HAZ_MAT_NO MGEF Hazardous materials STOFF
PRICAT_K003 HAZ_MAT_NO * MGEF Hazardous materials REGKZ
PRICAT_K003 ISSUE_UNIT SYST MANDT T006 Units of Measurement MANDT
PRICAT_K003 ISSUE_UNIT PRICAT_K003 ISSUE_UNIT T006 Units of Measurement MSEHI
PRICAT_K003 ISSUE_UNIT_ISO SYST MANDT T006I ISO codes for units of measurement CLIENT
PRICAT_K003 ISSUE_UNIT_ISO PRICAT_K003 ISSUE_UNIT_ISO T006I ISO codes for units of measurement ISOCODE
PRICAT_K003 MANDT PRICAT_K003 MANDT T000 Clients MANDT
PRICAT_K003 MATL_TYPE SYST MANDT T134 Material Types MANDT
PRICAT_K003 MATL_TYPE PRICAT_K003 MATL_TYPE T134 Material Types MTART
PRICAT_K003 MATNR SYST MANDT MARA General Material Data MANDT
PRICAT_K003 MATNR PRICAT_K003 MATNR MARA General Material Data MATNR
PRICAT_K003 MAT_GRP_SM PRICAT_K003 MAT_GRP_SM TVEGR Material Group: Packaging Materials MAGRV
PRICAT_K003 MAT_GRP_SM SYST MANDT TVEGR Material Group: Packaging Materials MANDT
PRICAT_K003 PACK_VO_UN SYST MANDT T006 Units of Measurement MANDT
PRICAT_K003 PACK_VO_UN PRICAT_K003 PACK_VO_UN T006 Units of Measurement MSEHI
PRICAT_K003 PACK_VO_UN_ISO PRICAT_K003 PACK_VO_UN_ISO T006I ISO codes for units of measurement ISOCODE
PRICAT_K003 PACK_VO_UN_ISO SYST MANDT T006I ISO codes for units of measurement CLIENT
PRICAT_K003 PACK_WT_UN SYST MANDT T006 Units of Measurement MANDT
PRICAT_K003 PACK_WT_UN PRICAT_K003 PACK_WT_UN T006 Units of Measurement MSEHI
PRICAT_K003 PACK_WT_UN_ISO PRICAT_K003 PACK_WT_UN_ISO T006I ISO codes for units of measurement ISOCODE
PRICAT_K003 PACK_WT_UN_ISO SYST MANDT T006I ISO codes for units of measurement CLIENT
PRICAT_K003 PRICE_BAND SYST MANDT TWPT Price band categories MANDT
PRICAT_K003 PRICE_BAND PRICAT_K003 PRICE_BAND TWPT Price band categories PLGTP
PRICAT_K003 PRINBR PRICAT_K003 MANDT PRICAT_K001 PRICAT: Catalog header MANDT
PRICAT_K003 PRINBR PRICAT_K003 PRINBR PRICAT_K001 PRICAT: Catalog header PRINBR
PRICAT_K003 PROC_STATUS * WRF_PRICAT_PROC Price Catalog Value Table for Processing Status MANDT
PRICAT_K003 PROC_STATUS PRICAT_K003 PROC_STATUS WRF_PRICAT_PROC Price Catalog Value Table for Processing Status WRF_PROCSTATUS
PRICAT_K003 PRODUCTGROUP PRICAT_K003 MANDT PRICAT_K002 PRICAT: Catalog item product groups MANDT
PRICAT_K003 PRODUCTGROUP PRICAT_K003 PRINBR PRICAT_K002 PRICAT: Catalog item product groups PRINBR
PRICAT_K003 PRODUCTGROUP PRICAT_K003 PRODUCTGROUP PRICAT_K002 PRICAT: Catalog item product groups PRODUCTGROUP
PRICAT_K003 PUR_GROUP PRICAT_K003 PUR_GROUP T024 Purchasing Groups EKGRP
PRICAT_K003 PUR_GROUP PRICAT_K003 MANDT T024 Purchasing Groups MANDT
PRICAT_K003 REF_ARTICLE PRICAT_K003 MANDT MARA General Material Data MANDT
PRICAT_K003 REF_ARTICLE PRICAT_K003 REF_ARTICLE MARA General Material Data MATNR
PRICAT_K003 REGIONORIG PRICAT_K003 REGIONORIG T005S Taxes: Region (Province) Key BLAND
PRICAT_K003 REGIONORIG PRICAT_K003 COUNTRYORI T005S Taxes: Region (Province) Key LAND1
PRICAT_K003 REGIONORIG SYST MANDT T005S Taxes: Region (Province) Key MANDT
PRICAT_K003 SALES_UNIT PRICAT_K003 SALES_UNIT T006 Units of Measurement MSEHI
PRICAT_K003 SALES_UNIT SYST MANDT T006 Units of Measurement MANDT
PRICAT_K003 SALES_UNIT_ISO SYST MANDT T006I ISO codes for units of measurement CLIENT
PRICAT_K003 SALES_UNIT_ISO PRICAT_K003 SALES_UNIT_ISO T006I ISO codes for units of measurement ISOCODE
PRICAT_K003 SEASMATCAT PRICAT_K003 SEASMATCAT T6WSA Categories of seasonal materials SAITY
PRICAT_K003 SEASMATCAT SYST MANDT T6WSA Categories of seasonal materials MANDT
PRICAT_K003 SEASON PRICAT_K003 SEASON T6WSP Check Table for Season Indicator SAISO
PRICAT_K003 SEASON SYST MANDT T6WSP Check Table for Season Indicator MANDT
PRICAT_K003 SH_MAT_TYP PRICAT_K003 SH_MAT_TYP TVTY Packaging Material Types TRATY
PRICAT_K003 SH_MAT_TYP SYST MANDT TVTY Packaging Material Types MANDT
PRICAT_K003 STOR_CONDS SYST MANDT T142 Storage Conditions for Materials MANDT
PRICAT_K003 STOR_CONDS PRICAT_K003 STOR_CONDS T142 Storage Conditions for Materials RAUBE
PRICAT_K003 TEMP_CONDS PRICAT_K003 TEMP_CONDS T143 Temperature Conditions for Storing Materials TEMPB
PRICAT_K003 TEMP_CONDS SYST MANDT T143 Temperature Conditions for Storing Materials MANDT