SAP ABAP Table PRICAT_K004 (PRICAT:Cat. item units of measure, dimensions, weights,EANs)

Hierarchy

☛ EA-RETAIL (Software Component) SAP Enterprise Extension Retail
   ⤷ SD-EDI (Application Component) Electronic Data Interchange
     ⤷ VPRI (Package) Application Development R/3 Retail/CP EDI messages

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	PRICAT_K004	Table Relationship Diagram
Short Description	PRICAT:Cat. item units of measure, dimensions, weights,EANs

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	PRINBR	☑	PRINBR	PRINBR	CHAR	10	0	PRICAT: Unique internal catalog number	PRICAT_K001
3	PRODUCTGROUP	☑	PRIPRODUCTGROUP	PRIPRODUCTGROUP	CHAR	18	0	PRICAT: PGI or assortment module from Pricat IDoc	PRICAT_K002
4	EAN_UPC_ALTUNIT	☑	PRIEANUNIT	PRIEAN	CHAR	35	0	PRICAT: EAN/UPC code of the unit of measure
5	VALIDITY_UNIT	☑	PRIVALIDITYU	DATUM	DATS	8	0	PRICAT: Date From Which the Unit Change is Valid
6	VALIDITY_BASE	☐	PRIVALIDITY	DATUM	DATS	8	0	Price Catalog Inbound Start of Validity Period	PRICAT_K003
7	EAN_UPC_TYPE	☐	PRIEANTYP	PRIEANTYP	CHAR	2	0	Type of material identification
8	EAN_UPC_BASE	☐	PRIEANBASIS	PRIEAN	CHAR	35	0	PRICAT: EAN/UPC Code of the Base Unit of Measure	PRICAT_K003
9	EAN_UPC_SUBLINE	☐	PRISUBLINE	PRIEAN	CHAR	35	0	PRICAT: Higher-level unit of measure of base unit of measure
10	QUANTITY_SUBLINE	☐	PRIQTYSUBL	PRINUMC15	NUMC	15	0	PRICAT: Quantity of lower-level material unit
11	QUANTITY_UNIT	☐	PRIQTYUNIT	PRINUMC15	NUMC	15	0	PRICAT: No. of base units contained
12	DELIVERY_UNIT_ID	☐	PRIDELUNIT	PRINUMC17	NUMC	17	0	PRICAT: Unit is delivery unit of the sender
13	INVOICE_UNIT_ID	☐	PRIINVUNIT	PRINUMC17	NUMC	17	0	PRICAT: Unit is billing unit of the sender
14	ORDER_UNIT_ID	☐	PRIORDUNIT	PRINUMC17	NUMC	17	0	PRICAT: Unit is the order unit of the sender
15	PACKAGE_TYPE	☐	PRIPACKTYP	PRICHAR17	CHAR	17	0	PRICAT: Packing type of the unit
16	PROD_ID_SENDER	☐	PRIPRODID	PRICHAR35	CHAR	35	0	PRICAT: Internal Naterial no. of Sender for Unit of Measure
17	BEARB_STATUS	☐	PRIBEARBSTAT	PRIBEARBSTAT	CHAR	2	0	PRICAT: Status of material/unit of measure processing
18	TRANSPORT	☐	PRIKZTRANSPORT	XFELD	CHAR	1	0	PRICAT: ID for Transfer
19	ITEM_NUMBER	☐	PRIPRODGRP	PRIPRODGRP	NUMC	6	0	PRICAT: Print sequence of the vendor
20	NON_PUBLIC	☐	PRINONPUBL	XFELD	CHAR	1	0	PRICAT: Customer-specific material or unit of measure (y/n)
21	NON_PUBLIC_ILN	☐	PRINONPUBLILN	PRICHAR35	CHAR	35	0	PRICAT: Cust.-spec. Material or Unit of Measure for this ILN
22	NON_PUBLIC_ILN2	☐	PRINONPUBLILN2	PRICHAR35	CHAR	35	0	PRICAT: Cust.-spec. Material or Unit of Measure for this ILN
23	NON_PUBLIC_ILN3	☐	PRINONPUBLILN3	PRICHAR35	CHAR	35	0	PRICAT: Cust.-spec. Material or Unit of Measure for this ILN
24	NON_PUBLIC_ILN4	☐	PRINONPUBLILN4	PRICHAR35	CHAR	35	0	PRICAT: Cust.-spec. Material or Unit of Measure for this ILN
25	NON_PUBLIC_ILN5	☐	PRINONPUBLILN5	PRICHAR35	CHAR	35	0	PRICAT: Cust.-spec. Material or Unit of Measure for this ILN
26	.INCLUDE	☐				0	0	PRICAT: Catalog item unit of measure from MARMRT segment
27	ALT_UNIT	☐	LRMEI	MEINS	UNIT	3	0	Alternative Unit of Measure for Stockkeeping Unit	T006
28	ALT_UNIT_ISO	☐	LRMEI_ISO	ISOCD_UNIT	CHAR	3	0	Alternative unit of measure to stockkeeping unit in ISO code	T006I
29	NUMERATOR	☐	UMREZ	UMBSZ	DEC	5	0	Numerator for Conversion to Base Units of Measure
30	DENOMINATR	☐	UMREN	UMBSN	DEC	5	0	Denominator for conversion to base units of measure
31	LENGTH	☐	LAENG	MENG13	QUAN	13	3	Length
32	WIDTH	☐	BREIT	MENG13	QUAN	13	3	Width
33	HEIGHT	☐	HOEHE	MENG13	QUAN	13	3	Height
34	UNIT_LENGTH	☐	PRIUNITLN	MEINS	UNIT	3	0	PRICAT: Unit for length	T006
35	UNIT_LENGTH_ISO	☐	PRIUNITLNISO	ISOCD_UNIT	CHAR	3	0	PRICAT: Unit for length	T006I
36	UNIT_WIDTH	☐	PRIUNITWD	MEINS	UNIT	3	0	PRICAT: Unit for width	T006
37	UNIT_WIDTH_ISO	☐	PRIUNITWDISO	ISOCD_UNIT	CHAR	3	0	PRICAT: Unit for width in ISO	T006I
38	UNIT_HEIGHT	☐	PRIUNITHT	MEINS	UNIT	3	0	PRICAT: Unit for height	T006
39	UNIT_HEIGHT_ISO	☐	PRIUNITHTISO	ISOCD_UNIT	CHAR	3	0	PRICAT: Unit for height in ISO code	T006I
40	VOLUME	☐	VOLUM	MENG13	QUAN	13	3	Volume
41	VOLUMEUNIT	☐	VOLEH	MEINS	UNIT	3	0	Volume unit	T006
42	VOLUMEUNIT_ISO	☐	VOLEH_ISO	ISOCD_UNIT	CHAR	3	0	Volume unit in ISO code	T006I
43	GROSS_WT	☐	BRGEW	MENG13	QUAN	13	3	Gross weight
44	UNIT_OF_WT	☐	GEWEI	MEINS	UNIT	3	0	Weight Unit	T006
45	UNIT_OF_WT_ISO	☐	GEWEI_ISO	ISOCD_UNIT	CHAR	3	0	Unit of weight in ISO code	T006I
46	UNIT_BASE	☐	PRIUNITBASE	MEINS	UNIT	3	0	PRICAT: Lower-level unit of measure in a packing hierarchy	T006
47	UNIT_BASE_ISO	☐	PRIUNITBASE_ISO	ISOCD_UNIT	CHAR	3	0	PRICAT: Lower-lvl unit of measure in packing hierarchy (ISO)	T006I
48	.INCLUDE	☐				0	0	PRICAT: Catalog item units of measure info from MARA segm.
49	UNIT_PURORD	☐	PRIUNITPURORD	MEINS	UNIT	3	0	PRICAT: Display unit for the order unit	T006
50	UNIT_PURORD_ISO	☐	PRIUNITPURORD_ISO	ISOCD_UNIT	CHAR	3	0	PRICAT: Display unit of the order unit in ISO code	T006I
51	NET_WEIGHT	☐	NTGEW	MENG13	QUAN	13	3	Net weight
52	UNIT_OF_NET	☐	PRINTGEWEI	MEINS	UNIT	3	0	Weight unit for net weight	T006
53	UNIT_OF_NET_ISO	☐	PRINTGEWEI_ISO	ISOCD_UNIT	CHAR	3	0	Weight unit for net weight in ISO code	T006I
54	.INCLUDE	☐				0	0	PRICAT: Catalog item units of measure (display fields)
55	HAZARD_LIMIT	☐	PRIHAZLIM	PRICHAR17	CHAR	17	0	PRICAT: Dangerous goods indicator limited quantity
56	BARCODE_ID	☐	PRIBARCODE	PRICHAR3	CHAR	3	0	PRICAT: Bar code indicator on package
57	PALLET_HANDL	☐	PRIPALHAND	PRICHAR17	CHAR	17	0	PRICAT: Pallet handling (disposable, reusable etc.)
58	PALLET_TYPE	☐	PRIPALTYPE	PRICHAR17	CHAR	17	0	PRICAT: Pallet type (ISO, Europallet etc.)
59	PALLET_LAYER	☐	PRIPALLAYR	PRINUMC18	NUMC	18	0	PRICAT: Number of layers per load container
60	PALLET_UNITS	☐	PRIPALUNIT	PRINUMC18	NUMC	18	0	PRICAT: Number of units per load carrier
61	PALLET_HIGHT	☐	PRIPALHIGH	PRINUMC18	NUMC	18	0	PRICAT: Pallet load height
62	UNIT_PALHT_ISO	☐	PRIPALHT_ISO	ISOCD_UNIT	CHAR	3	0	PRICAT: Unit for pallet height in ISO code	*
63	PALLET_STACK	☐	PRIPALSTAK	PRINUMC18	NUMC	18	0	PRICAT: Pallet stacking factor
64	STATE_INFO	☐	PRISTATEINDICATOR	PRISTATEINDICATOR	CHAR	2	0	PRICAT: Movement Indicator for the Item

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	PRICAT_K004	ALT_UNIT	T006	MSEHI
2	PRICAT_K004	ALT_UNIT_ISO	T006I	ISOCODE
3	PRICAT_K004	EAN_UPC_BASE	PRICAT_K003	EAN_UPC_BASE
4	PRICAT_K004	MANDT	T000	MANDT	KEY	1	CN
5	PRICAT_K004	PRINBR	PRICAT_K001	PRINBR	KEY	1	CN
6	PRICAT_K004	PRODUCTGROUP	PRICAT_K002	PRODUCTGROUP	KEY	1	CN
7	PRICAT_K004	UNIT_BASE	T006	MSEHI
8	PRICAT_K004	UNIT_BASE_ISO	T006I	ISOCODE
9	PRICAT_K004	UNIT_HEIGHT	T006	MSEHI
10	PRICAT_K004	UNIT_HEIGHT_ISO	T006I	ISOCODE
11	PRICAT_K004	UNIT_LENGTH	T006	MSEHI
12	PRICAT_K004	UNIT_LENGTH_ISO	T006I	ISOCODE
13	PRICAT_K004	UNIT_OF_NET	T006	MSEHI
14	PRICAT_K004	UNIT_OF_NET_ISO	T006I	ISOCODE
15	PRICAT_K004	UNIT_OF_WT	T006	MSEHI
16	PRICAT_K004	UNIT_OF_WT_ISO	T006I	ISOCODE
17	PRICAT_K004	UNIT_PURORD	T006	MSEHI
18	PRICAT_K004	UNIT_PURORD_ISO	T006I	ISOCODE
19	PRICAT_K004	UNIT_WIDTH	T006	MSEHI
20	PRICAT_K004	UNIT_WIDTH_ISO	T006I	ISOCODE
21	PRICAT_K004	VALIDITY_BASE	PRICAT_K003	VALIDITY_BASE
22	PRICAT_K004	VOLUMEUNIT	T006	MSEHI
23	PRICAT_K004	VOLUMEUNIT_ISO	T006I	ISOCODE

History

Last changed by/on	SAP	20030703
SAP Release Created in