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

History

Last changed by/on	SAP	20130529
SAP Release Created in