SAP Table PRICAT_K003
PRICAT: Catalog item basic data
Recommended Now
All-new Echo Dot Smart speaker with Alexa
This bundle includes Echo Dot (3rd Gen) Charcoal and Philips Hue White A19 Medium Lumen Smart Bulb, 1100 Lumens. Built in Smart Home hub. Ask Alexa to control Zigbee-compatible devices. No additional Philips Hue hub required. Two choices for easy smart lighting - Start setting the mood with Hue Smart bulbs and your Echo device, supporting up to 5 Hue Bluetooth & Zigbee smart bulbs. Add the Hue Hub for whole-home smart lighting (up to 50 light points) and bonus features.
Check it out on amazon.com →
The table PRICAT_K003 (PRICAT: Catalog item basic data) is a standard table in SAP ERP. It belongs to the package VPRI.
Technical Information
| Table | PRICAT_K003 |
| Short Text | PRICAT: Catalog item basic data |
| Package | VPRI |
| Table Type | Transparent Table |
Fields for Table PRICAT_K003
| Field Name | Key | Description | Data Element | Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | ✔ | Client | MANDT | CLNT | 3 | T000 |
| PRINBR | ✔ | PRICAT: Unique internal catalog number | PRINBR | CHAR | 10 | PRICAT_K001 |
| PRODUCTGROUP | ✔ | PRICAT: PGI or assortment module from Pricat IDoc | PRIPRODUCTGROUP | CHAR | 18 | PRICAT_K002 |
| EAN_UPC_BASE | ✔ | PRICAT: EAN/UPC Code of Base Unit of Measure | PRIEANBASIS | CHAR | 35 | |
| VALIDITY_BASE | ✔ | Price Catalog Inbound Start of Validity Period | PRIVALIDITY | DATS | 8 | |
| EAN_UPC_TYPE | Type of material identification | PRIEANTYP | CHAR | 2 | ||
| BEARB_STATUS | PRICAT: Status of material/unit of measure processing | PRIBEARBSTAT | CHAR | 2 | ||
| STATEINDICATOR | PRICAT: Movement Indicator for the Item | PRISTATEINDICATOR | CHAR | 2 | ||
| PUR_GROUP | Purchasing Group | EKGRP | CHAR | 3 | T024 | |
| MATERIAL_GROUP | PRICAT: Material Group from Message | PRIMATKL | CHAR | 35 | ||
| MAT_ID_SENDER | PRICAT: Material Number of the Sender of the Message | PRIMATLIEF | CHAR | 35 | ||
| SHELF_LIFE_MSG | PRICAT: Shelf life expiration in time unit from message | PRIMHD | CHAR | 6 | ||
| SHELF_LIFE_QUAL | PRICAT: Qualifier for periods | PRIQUALPERIOD | CHAR | 3 | ||
| COMPOSITION | PRICAT: Product Composition | PRICOMPOSITION | CHAR | 3 | ||
| MATNR | Material Number | MATNR | CHAR | 18 | MARA | |
| MATL_TYPE | Material Type | MTART | CHAR | 4 | T134 | |
| MATL_GROUP | Material Group | MATKL | CHAR | 9 | * | |
| MATL_CAT | Material Category | ATTYP | CHAR | 2 | ||
| DEL_FLAG | Flag Material for Deletion at Client Level | LVOMA | CHAR | 1 | ||
| CONTAINER | Container requirements | BEHVO | CHAR | 2 | T144 | |
| STOR_CONDS | Storage conditions | RAUBE | CHAR | 2 | T142 | |
| TEMP_CONDS | Temperature conditions indicator | TEMPB | CHAR | 2 | T143 | |
| HAZ_MAT_NO | Hazardous material number | STOFF | CHAR | 18 | MGEF | |
| DIVISION | Division | SPART | CHAR | 2 | TSPA | |
| SEASON | Season Category | SAISO | CHAR | 4 | T6WSP | |
| ALLOWED_WT | Allowed packaging weight | ERGEW | QUAN | 13 | ||
| PACK_WT_UN | Unit of weight (allowed packaging weight) | ERGEI | UNIT | 3 | T006 | |
| PACK_WT_UN_ISO | Unit of weight (allowed packaging weight) in ISO code | ERGEI_ISO | CHAR | 3 | T006I | |
| ALLWD_VOL | Allowed packaging volume | ERVOL | QUAN | 13 | ||
| PACK_VO_UN | Volume unit (allowed packaging volume) | ERVOE | UNIT | 3 | T006 | |
| PACK_VO_UN_ISO | Volume unit (allowed packaging volume) in ISO code | ERVOE_ISO | CHAR | 3 | T006I | |
| VAR_ORD_UN | Variable Purchase Order Unit Active | VABME | CHAR | 1 | ||
| BATCH_MGMT | Batch management requirement indicator | XCHPF | CHAR | 1 | ||
| SH_MAT_TYP | Packaging Material Type | VHIART | CHAR | 4 | TVTY | |
| FILL_LEVEL | Maximum level (by volume) | FUELG | DEC | 3 | ||
| STACK_FACT | Stacking factor | STFAK | INT2 | 5 | ||
| MAT_GRP_SM | Material Group: Packaging Materials | MAGRV | CHAR | 4 | TVEGR | |
| MINREMLIFE | Minimum Remaining Shelf Life | MHDRZ | DEC | 4 | ||
| SHELF_LIFE | Total shelf life | MHDHB | DEC | 4 | ||
| STOR_PCT | Storage percentage | MHDLP | DEC | 3 | ||
| SAESON_YR | Season Year | SAISJ | CHAR | 4 | ||
| PRICE_BAND | Price Band Category | PLGTP | CHAR | 2 | TWPT | |
| EMPTIESBOM | Empties Bill of Material | W_MITLEERG | CHAR | 1 | ||
| EXTMATLGRP | External Material Group | EXTWG | CHAR | 18 | * | |
| CONT_UNIT | Content unit | INHME | UNIT | 3 | T006 | |
| CONT_UNIT_ISO | Content unit in ISO code | INHME_ISO | CHAR | 3 | T006I | |
| NET_CONT | Net contents | INHAL | QUAN | 13 | ||
| COMPPRUNIT | Comparison price unit | VPREH | DEC | 5 | ||
| GROSS_CONT | Gross contents | INHBR | QUAN | 13 | ||
| ENVT_RLVT | Environmentally Relevant | KZUMW | CHAR | 1 | ||
| SEASMATCAT | Rollout in a Season | SAITY | CHAR | 2 | T6WSA | |
| HAZMATPROF | Dangerous Goods Indicator Profile | ADGE_PROFL | CHAR | 3 | TDG41 | |
| HIGH_VISC | Indicator: Highly Viscous | ADGE_IHIVI | CHAR | 1 | ||
| LOOSEORLIQ | Indicator: In Bulk/Liquid | ADGE_ILOOS | CHAR | 1 | ||
| CLOSED_BOX | Packaging Material is Closed Packaging | KZGVH | CHAR | 1 | ||
| APPD_B_REC | Indicator: Approved batch record required | XGCHP | CHAR | 1 | ||
| PERIOD_IND_EXPIR | Period Indicator for Shelf Life Expiration Date | DATTP | CHAR | 1 | ||
| ROUND_RULE_EXPIR | Rounding rule for calculation of SLED | RDMHD | CHAR | 1 | ||
| PROD_COMP_PACKAG | Indicator: Product composition printed on packaging | PRZUS | CHAR | 1 | ||
| SALES_UNIT | Sales unit | VRKME | UNIT | 3 | T006 | |
| SALES_UNIT_ISO | Sales unit in ISO code | VRKME_ISO | CHAR | 3 | T006I | |
| ISSUE_UNIT | Unit of issue | AUSME | UNIT | 3 | T006 | |
| ISSUE_UNIT_ISO | Unit of issue in ISO code | AUSME_ISO | CHAR | 3 | T006I | |
| COUNTRYORI | Country of origin of the material | HERKL | CHAR | 3 | T005 | |
| COUNTRYORI_ISO | Material's country of origin in ISO code | HERKL_ISO | CHAR | 2 | ||
| REGIONORIG | Region of origin of material (non-preferential origin) | HERKR | CHAR | 3 | T005S | |
| COMM_CODE | Commodity Code/Import Code Number for Foreign Trade | STAWN | CHAR | 17 | T604 | |
| LOCK_STATUS | Lock Status (Yes or No) | WRF_LOCK_STATUS | CHAR | 1 | ||
| SATNR | Cross-Plant Configurable Material | SATNR | CHAR | 18 | * | |
| VENDOR_SATNR | Price Catalog: Grouping Field: Generic Article Assignment | WRF_VENDOR_SATNR | CHAR | 20 | ||
| SATNR_HEAD_FLAG | Master Variant | WRF_MASTER_VARIANT | CHAR | 1 | ||
| PROC_STATUS | Processing Status | WRF_PROCSTATUS | CHAR | 2 | WRF_PRICAT_PROC | |
| TAKE_OVER_DATE | Transfer Date (in PRICAT Data Pool) | WRF_TAKE_OVER_DATE | DATS | 8 | ||
| TRIGGER_DATE | Primary Update Date Set Online | WRF_TRIGGER_DATE | DATS | 8 | ||
| MORE_MATNR | Price Catalog Indicator EAN for Mat. No. = 1..n | MORE_MATNR | CHAR | 1 | ||
| REF_ARTICLE | Material group reference material | WWGDA | CHAR | 18 | MARA | |
| HIER_ID | Hierarchy | WRF_HIER_CNT | CHAR | 2 | ||
| HIER_NODE | Hierarchy Node | WRF_STRUC_NODE | CHAR | 18 | ||
| MERKMALSPROFIL | Characteristic Profile | WRF_PROFIL | CHAR | 18 | ||
| MANUAL_CHANGE | Manual Change | MANUAL_CHANGE | CHAR | 1 | ||
| PROFILENAME | Profile Name | WRF_PROFILENAME | CHAR | 40 | ||
| CAT_GROUP_1 | KATALOG_GRUPPE | CATALOGUE_GROUP | CHAR | 12 | WRF_CAT_GROUP | |
| CAT_GROUP_2 | KATALOG_GRUPPE | CATALOGUE_GROUP | CHAR | 12 | WRF_CAT_GROUP | |
| CAT_GROUP_3 | KATALOG_GRUPPE | CATALOGUE_GROUP | CHAR | 12 | WRF_CAT_GROUP |