PRICAT_K004 SAP (PRICAT:Cat. item units of measure, dimensions, weights,EANs) Table details
Description: PRICAT:Cat. item units of measure, dimensions, weights,EANs
Table field list including key, data, relationships and ABAP select examples
PRICAT_K004 is a standard SAP Table which is used to store PRICAT:Cat. item units of measure, dimensions, weights,EANs data and is available within R/3 SAP systems depending on the version and release level.
The PRICAT_K004 table consists of various fields, each holding specific information or linking keys about PRICAT:Cat. item units of measure, dimensions, weights,EANs data available in SAP. These include PRINBR (PRICAT: Unique internal catalog number), PRODUCTGROUP (PRICAT: PGI or assortment module from Pricat IDoc), EAN_UPC_ALTUNIT (PRICAT: EAN/UPC code of the unit of measure), VALIDITY_UNIT (PRICAT: Date From Which the Unit Change is Valid).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP PRICAT_K004 table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
PRINBR | PRICAT: Unique internal catalog number | PRINBR | CHAR | 10 | PRICAT_K001 | PRINBR | PRN | PRICAT_HEADER | |
PRODUCTGROUP | PRICAT: PGI or assortment module from Pricat IDoc | PRIPRODUCTGROUP | CHAR | 18 | PRICAT_K002 | PRIPRODUCTGROUP | |||
EAN_UPC_ALTUNIT | PRICAT: EAN/UPC code of the unit of measure | PRIEANUNIT | CHAR | 35 | PRIEAN | ||||
VALIDITY_UNIT | PRICAT: Date From Which the Unit Change is Valid | PRIVALIDITYU | DATS | 8 | DATUM | ||||
VALIDITY_BASE | Price Catalog Inbound Start of Validity Period | PRIVALIDITY | DATS | 8 | PRICAT_K003 | DATUM | |||
EAN_UPC_TYPE | Type of material identification | PRIEANTYP | CHAR | 2 | PRIEANTYP | ||||
EAN_UPC_BASE | PRICAT: EAN/UPC Code of Base Unit of Measure | PRIEANBASIS | CHAR | 35 | PRICAT_K003 | PRIEAN | |||
EAN_UPC_SUBLINE | PRICAT: Higher-level unit of measure of base unit of measure | PRISUBLINE | CHAR | 35 | PRIEAN | ||||
QUANTITY_SUBLINE | PRICAT: Quantity of lower-level material unit | PRIQTYSUBL | NUMC | 15 | PRINUMC15 | ||||
QUANTITY_UNIT | PRICAT: No. of base units contained | PRIQTYUNIT | NUMC | 15 | PRINUMC15 | ||||
DELIVERY_UNIT_ID | PRICAT: Unit is delivery unit of the sender | PRIDELUNIT | NUMC | 17 | PRINUMC17 | ||||
INVOICE_UNIT_ID | PRICAT: Unit is billing unit of the sender | PRIINVUNIT | NUMC | 17 | PRINUMC17 | ||||
ORDER_UNIT_ID | PRICAT: Unit is the order unit of the sender | PRIORDUNIT | NUMC | 17 | PRINUMC17 | ||||
PACKAGE_TYPE | PRICAT: Packing type of the unit | PRIPACKTYP | CHAR | 17 | PRICHAR17 | ||||
PROD_ID_SENDER | PRICAT: Internal Naterial no. of Sender for Unit of Measure | PRIPRODID | CHAR | 35 | PRICHAR35 | ||||
BEARB_STATUS | PRICAT: Status of material/unit of measure processing | PRIBEARBSTAT | CHAR | 2 | PRIBEARBSTAT | ||||
TRANSPORT | PRICAT: ID for Transfer | PRIKZTRANSPORT | CHAR | 1 | XFELD | ||||
ITEM_NUMBER | PRICAT: Print sequence of the vendor | PRIPRODGRP | NUMC | 6 | PRIPRODGRP | ||||
NON_PUBLIC | PRICAT: Customer-specific material or unit of measure (y/n) | PRINONPUBL | CHAR | 1 | XFELD | ||||
NON_PUBLIC_ILN | PRICAT: Cust.-spec. Material or Unit of Measure for this ILN | PRINONPUBLILN | CHAR | 35 | PRICHAR35 | ||||
NON_PUBLIC_ILN2 | PRICAT: Cust.-spec. Material or Unit of Measure for this ILN | PRINONPUBLILN2 | CHAR | 35 | PRICHAR35 | ||||
NON_PUBLIC_ILN3 | PRICAT: Cust.-spec. Material or Unit of Measure for this ILN | PRINONPUBLILN3 | CHAR | 35 | PRICHAR35 | ||||
NON_PUBLIC_ILN4 | PRICAT: Cust.-spec. Material or Unit of Measure for this ILN | PRINONPUBLILN4 | CHAR | 35 | PRICHAR35 | ||||
NON_PUBLIC_ILN5 | PRICAT: Cust.-spec. Material or Unit of Measure for this ILN | PRINONPUBLILN5 | CHAR | 35 | PRICHAR35 | ||||
ALT_UNIT | Alternative Unit of Measure for Stockkeeping Unit | LRMEI | UNIT | 3 | T006 | CUNIT | MEINS | ||
ALT_UNIT_ISO | Alternative unit of measure to stockkeeping unit in ISO code | LRMEI_ISO | CHAR | 3 | T006I | ISOCD_UNIT | |||
NUMERATOR | Numerator for Conversion to Base Units of Measure | UMREZ | DEC | 5 | UMBSZ | ||||
DENOMINATR | Denominator for conversion to base units of measure | UMREN | DEC | 5 | UMBSN | ||||
LENGTH | Length | LAENG | QUAN | 13(3) | MENG13 | ||||
WIDTH | Width | BREIT | QUAN | 13(3) | MENG13 | ||||
HEIGHT | Height | HOEHE | QUAN | 13(3) | MENG13 | ||||
UNIT_LENGTH | PRICAT: Unit for length | PRIUNITLN | UNIT | 3 | T006 | CUNIT | MEINS | ||
UNIT_LENGTH_ISO | PRICAT: Unit for length | PRIUNITLNISO | CHAR | 3 | T006I | ISOCD_UNIT | |||
UNIT_WIDTH | PRICAT: Unit for width | PRIUNITWD | UNIT | 3 | T006 | CUNIT | MEINS | ||
UNIT_WIDTH_ISO | PRICAT: Unit for width in ISO | PRIUNITWDISO | CHAR | 3 | T006I | ISOCD_UNIT | |||
UNIT_HEIGHT | PRICAT: Unit for height | PRIUNITHT | UNIT | 3 | T006 | CUNIT | MEINS | ||
UNIT_HEIGHT_ISO | PRICAT: Unit for height in ISO code | PRIUNITHTISO | CHAR | 3 | T006I | ISOCD_UNIT | |||
VOLUME | Volume | VOLUM | QUAN | 13(3) | MENG13 | ||||
VOLUMEUNIT | Volume unit | VOLEH | UNIT | 3 | T006 | CUNIT | MEINS | ||
VOLUMEUNIT_ISO | Volume unit in ISO code | VOLEH_ISO | CHAR | 3 | T006I | ISOCD_UNIT | |||
GROSS_WT | Gross Weight | BRGEW | QUAN | 13(3) | MENG13 | ||||
UNIT_OF_WT | Weight Unit | GEWEI | UNIT | 3 | T006 | CUNIT | MEINS | ||
UNIT_OF_WT_ISO | Unit of weight in ISO code | GEWEI_ISO | CHAR | 3 | T006I | ISOCD_UNIT | |||
UNIT_BASE | PRICAT: Lower-level unit of measure in a packing hierarchy | PRIUNITBASE | UNIT | 3 | T006 | CUNIT | MEINS | ||
UNIT_BASE_ISO | PRICAT: Lower-lvl unit of measure in packing hierarchy (ISO) | PRIUNITBASE_ISO | CHAR | 3 | T006I | ISOCD_UNIT | |||
UNIT_PURORD | PRICAT: Display unit for the order unit | PRIUNITPURORD | UNIT | 3 | T006 | CUNIT | MEINS | ||
UNIT_PURORD_ISO | PRICAT: Display unit of the order unit in ISO code | PRIUNITPURORD_ISO | CHAR | 3 | T006I | ISOCD_UNIT | |||
NET_WEIGHT | Net Weight | NTGEW | QUAN | 13(3) | MENG13 | ||||
UNIT_OF_NET | Weight unit for net weight | PRINTGEWEI | UNIT | 3 | T006 | CUNIT | MEINS | ||
UNIT_OF_NET_ISO | Weight unit for net weight in ISO code | PRINTGEWEI_ISO | CHAR | 3 | T006I | ISOCD_UNIT | |||
HAZARD_LIMIT | PRICAT: Dangerous goods indicator limited quantity | PRIHAZLIM | CHAR | 17 | PRICHAR17 | ||||
BARCODE_ID | PRICAT: Bar code indicator on package | PRIBARCODE | CHAR | 3 | PRICHAR3 | ||||
PALLET_HANDL | PRICAT: Pallet handling (disposable, reusable etc.) | PRIPALHAND | CHAR | 17 | PRICHAR17 | ||||
PALLET_TYPE | PRICAT: Pallet type (ISO, Europallet etc.) | PRIPALTYPE | CHAR | 17 | PRICHAR17 | ||||
PALLET_LAYER | PRICAT: Number of layers per load container | PRIPALLAYR | NUMC | 18 | PRINUMC18 | ||||
PALLET_UNITS | PRICAT: Number of units per load carrier | PRIPALUNIT | NUMC | 18 | PRINUMC18 | ||||
PALLET_HIGHT | PRICAT: Pallet load height | PRIPALHIGH | NUMC | 18 | PRINUMC18 | ||||
UNIT_PALHT_ISO | PRICAT: Unit for pallet height in ISO code | PRIPALHT_ISO | CHAR | 3 | Assigned to domain | ISOCD_UNIT | |||
PALLET_STACK | PRICAT: Pallet stacking factor | PRIPALSTAK | NUMC | 18 | PRINUMC18 | ||||
STATE_INFO | PRICAT: Movement Indicator for the Item | PRISTATEINDICATOR | CHAR | 2 | PRISTATEINDICATOR | ||||
HPEAN | Indicator: Main EAN | HPEAN | CHAR | 1 | XFELD |
Key field | Non-key field |
How do I retrieve data from SAP table PRICAT_K004 using ABAP code
The following ABAP code Example will allow you to do a basic selection on PRICAT_K004 to SELECT all data from the tableDATA: WA_PRICAT_K004 TYPE PRICAT_K004.
SELECT SINGLE *
FROM PRICAT_K004
INTO CORRESPONDING FIELDS OF WA_PRICAT_K004
WHERE...
How to access SAP table PRICAT_K004
Within an ECC or HANA version of SAP you can also view further information about PRICAT_K004 and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects