SAP ABAP Table PRICAT_K004_VB (Copy of table PRICAT_K004 for posting material)

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	INTTAB	Structure
Structure	PRICAT_K004_VB	Table Relationship Diagram
Short Description	Copy of table PRICAT_K004 for posting material

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

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

Foreign Keys

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

History

Last changed by/on	SAP	20030703
SAP Release Created in