SAP table PRICAT_K003 (PRICAT: Catalog item basic data)

SAP table PRICAT_K003 has 5 primary key fields being MANDT,PRINBR,PRODUCTGROUP,EAN_UPC_BASE,VALIDITY_BASE.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

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

PRICAT_K003 foreign key relationships

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