SAP ABAP Table PRICAT_K003Z (PRICAT: Catalog item basic data extras)

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_K003Z	Table Relationship Diagram
Short Description	PRICAT: Catalog item basic data extras

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_BASE	☑	PRIEANBASIS	PRIEAN	CHAR	35	0	PRICAT: EAN/UPC Code of the Base Unit of Measure
5	VALIDITY_BASE	☑	PRIVALIDITY	DATUM	DATS	8	0	Price Catalog Inbound Start of Validity Period
6	.INCLUDE	☐				0	0	PRICAT: Catalog item additional data from MARART segment
7	SIZE_DIM	☐	GROES	CHAR32	CHAR	32	0	Size/dimensions
8	BASIC_MATL	☐	WRKST	WRKST	CHAR	48	0	Basic Material	*
9	STD_DESCR	☐	NORMT	NORMT	CHAR	18	0	Industry Standard Description (such as ANSI or ISO)
10	DSN_OFFICE	☐	LABOR	LABOR	CHAR	3	0	Laboratory/design office	*
11	COMPETITOR	☐	WETTB	KUNNR	CHAR	10	0	Competitor	*
12	MANUFACTUR	☐	PRIILNM	PRICHAR35	CHAR	35	0	PRICAT: International location number manufactur. (CHAR 35)
13	.INCLUDE	☐				0	0	PRICAT: Catalog item other additional data (display only)
14	GENETIC_INFO	☐	PRIGENETIC	PRICHAR18	CHAR	18	0	PRICAT: Information on genetic modification
15	ALCOHOL_PERC_VOL	☐	PRIALCVOL	PRICHAR18	CHAR	18	0	PRICAT: Alcohol volume as percentage (measured value)
16	FAT_CONTENT	☐	PRIFATCONT	PRICHAR18	CHAR	18	0	PRICAT: Fat content
17	KEEP_REFRIG	☐	PRIKEEPREFRIG	PRICHAR3	CHAR	3	0	PRICAT: Keep refrigerated
18	KEEP_FROZEN	☐	PRIKEEPFROZEN	PRICHAR3	CHAR	3	0	PRICAT: Keep frozen
19	GREEN_DOT	☐	PRIGREENDOT	PRICHAR3	CHAR	3	0	PRICAT: Recyling indicator on goods
20	EXPIR_MARKING	☐	PRIEXPIRDATE	PRICHAR3	CHAR	3	0	PRICAT: Expiration date shown on goods
21	PRICE_MARKING	☐	PRIPRICEMARK	PRICHAR3	CHAR	3	0	PRICAT: Price marked on goods
22	KEEP_DRY	☐	PRIKEEPDRY	PRICHAR3	CHAR	3	0	PRICAT: Keep dry
23	HEAT_SENSITIVE	☐	PRIHEATSENS	PRICHAR3	CHAR	3	0	PRICAT: Heat-sensitive
24	.INCLUDE	☐				0	0	PRICAT: Catalog item Additional display data from EANCOM
25	COMM_CODE	☐	PRICOMMCODE	PRICHAR35	CHAR	35	0	PRICAT: Customs tariff number
26	PREDECES_MAT_ID	☐	PRIPREDEC	PRICHAR35	CHAR	35	0	PRICAT: Preceding EAN/UPC
27	FOLLOW_UP	☐	NFMAT	MATNR	CHAR	18	0	Follow-up material	*
28	HAZARD_CLASS	☐	PRIHAZCLASS	PRICHAR4	CHAR	4	0	PRICAT: Dangerous Goods Classification
29	HAZARD_DESCRIPT	☐	PRIHAZDES	PRICHAR35	CHAR	35	0	PRICAT: Dangerous goods general description
30	HAZARD_DESCR_2	☐	PRIHAZDES2	PRICHAR35	CHAR	35	0	PRICAT: Dangerous goods general description field 2
31	HAZARD_DESCR_3	☐	PRIHAZDES3	PRICHAR35	CHAR	35	0	PRICAT: Dangerous goods general description field 3
32	SAISON_PERIOD	☐	PRISAISON	PRICHAR35	CHAR	35	0	PRICAT: Seasonal ordering (from to)
33	.INCLU--AP	☐				0	0	Price Catalog Append for Updating
34	BASE_UOM	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
35	TAX_TYPE	☐	TATYP	KSCHL	CHAR	4	0	Tax category (sales tax, federal sales tax,...)	T685
36	TAX_CLASS	☐	TAKLV	TAXKM	CHAR	1	0	Tax Classification of Material	TSKM
37	VAL_CLASS	☐	BKLAS	BKLAS	CHAR	4	0	Valuation Class	T025
38	MWSKZ	☐	MWSKZ	MWSKZ	CHAR	2	0	Tax on sales/purchases code	T007A

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	PRICAT_K003Z	BASE_UOM	T006	MSEHI
2	PRICAT_K003Z	MANDT	T000	MANDT	KEY	1	CN
3	PRICAT_K003Z	MWSKZ	T007A	MWSKZ
4	PRICAT_K003Z	PRINBR	PRICAT_K001	PRINBR	KEY	1	CN
5	PRICAT_K003Z	PRODUCTGROUP	PRICAT_K002	PRODUCTGROUP	KEY	1	CN
6	PRICAT_K003Z	TAX_CLASS	TSKM	TAXKM
7	PRICAT_K003Z	TAX_TYPE	T685	KSCHL
8	PRICAT_K003Z	VAL_CLASS	T025	BKLAS

History

Last changed by/on	SAP	20130529
SAP Release Created in