PRICAT_K003 - PRICAT: Catalog item basic data

PRICAT: Catalog item basic data information is stored in SAP table PRICAT_K003.
It is part of development package VPRI in software component LO-RFM-OBS. This development package consists of objects that can be grouped under "Application Development R/3 Retail/CP EDI messages".

Fields for table PRICAT_K003

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