SAP ABAP Table WRF_ITEM_K003_AND_Z_STY (Price Catalog Inbound: Item Attributes (K003 and K003z))

Hierarchy

☛ EA-RETAIL (Software Component) SAP Enterprise Extension Retail
   ⤷ SD-EDI (Application Component) Electronic Data Interchange
     ⤷ WRF_VPRI_IN (Package) Price Catalog Inbound 2004

Basic Data

Table Category	INTTAB	Structure
Structure	WRF_ITEM_K003_AND_Z_STY	Table Relationship Diagram
Short Description	Price Catalog Inbound: Item Attributes (K003 and K003z)

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	Item: Attribute Part
2	EAN_UPC_TYPE	☐	PRIEANTYP	PRIEANTYP	CHAR	2	0	Type of material identification
3	BEARB_STATUS	☐	PRIBEARBSTAT	PRIBEARBSTAT	CHAR	2	0	PRICAT: Status of material/unit of measure processing
4	STATEINDICATOR	☐	PRISTATEINDICATOR	PRISTATEINDICATOR	CHAR	2	0	PRICAT: Movement Indicator for the Item
5	PUR_GROUP	☐	EKGRP	EKGRP	CHAR	3	0	Purchasing group	T024
6	MATERIAL_GROUP	☐	PRIMATKL	PRICHAR35	CHAR	35	0	PRICAT: Material group from the message (char 35)
7	MAT_ID_SENDER	☐	PRIMATLIEF	PRICHAR35	CHAR	35	0	PRICAT: Material number of the sender of the message
8	SHELF_LIFE_MSG	☐	PRIMHD	PRIPERIODE	CHAR	6	0	PRICAT: Shelf life expiration in time unit from message
9	SHELF_LIFE_QUAL	☐	PRIQUALPERIOD	PRIQUALPERIOD	CHAR	3	0	PRICAT: Qualifier for periods
10	COMPOSITION	☐	PRICOMPOSITION	PRICHAR3	CHAR	3	0	PRICAT: Product composition
11	.INCLUDE	☐				0	0	PRICAT: Catalog item basic data from MARART segment
12	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
13	MATL_TYPE	☐	MTART	MTART	CHAR	4	0	Material type	T134
14	MATL_GROUP	☐	MATKL	MATKL	CHAR	9	0	Material Group	T023
15	MATL_CAT	☐	ATTYP	ATTYP	CHAR	2	0	Material Category
16	DEL_FLAG	☐	LVOMA	XFELD	CHAR	1	0	Flag Material for Deletion at Client Level
17	CONTAINER	☐	BEHVO	BEHVO	CHAR	2	0	Container requirements	T144
18	STOR_CONDS	☐	RAUBE	RAUBE	CHAR	2	0	Storage conditions	T142
19	TEMP_CONDS	☐	TEMPB	TEMPB	CHAR	2	0	Temperature conditions indicator	T143
20	HAZ_MAT_NO	☐	STOFF	STOFF	CHAR	18	0	Hazardous material number	MGEF
21	DIVISION	☐	SPART	SPART	CHAR	2	0	Division	TSPA
22	SEASON	☐	SAISO	SAISO	CHAR	4	0	Season Category	T6WSP
23	ALLOWED_WT	☐	ERGEW	MENG13	QUAN	13	3	Allowed packaging weight
24	PACK_WT_UN	☐	ERGEI	MEINS	UNIT	3	0	Unit of weight (allowed packaging weight)	T006
25	PACK_WT_UN_ISO	☐	ERGEI_ISO	ISOCD_UNIT	CHAR	3	0	Unit of weight (allowed packaging weight) in ISO code	T006I
26	ALLWD_VOL	☐	ERVOL	MENG13	QUAN	13	3	Allowed packaging volume
27	PACK_VO_UN	☐	ERVOE	MEINS	UNIT	3	0	Volume unit (allowed packaging volume)	T006
28	PACK_VO_UN_ISO	☐	ERVOE_ISO	ISOCD_UNIT	CHAR	3	0	Volume unit (allowed packaging volume) in ISO code	T006I
29	VAR_ORD_UN	☐	VABME	VABME	CHAR	1	0	Variable Purchase Order Unit Active
30	BATCH_MGMT	☐	XCHPF	XFELD	CHAR	1	0	Batch management requirement indicator
31	SH_MAT_TYP	☐	VHIART	TRATY	CHAR	4	0	Shipping material type	TVTY
32	FILL_LEVEL	☐	FUELG	DEC3	DEC	3	0	Filling level (by volume)
33	STACK_FACT	☐	STFAK	INT2	INT2	5	0	Stacking factor
34	MAT_GRP_SM	☐	MAGRV	MAGRV	CHAR	4	0	Material Group: Packaging Materials	TVEGR
35	MINREMLIFE	☐	MHDRZ	DEC4	DEC	4	0	Minimum Remaining Shelf Life
36	SHELF_LIFE	☐	MHDHB	DEC4	DEC	4	0	Total shelf life
37	STOR_PCT	☐	MHDLP	DEC3	DEC	3	0	Storage percentage
38	SAESON_YR	☐	SAISJ	CJAHR	CHAR	4	0	Season Year
39	PRICE_BAND	☐	PLGTP	PLGTP	CHAR	2	0	Price band category	TWPT
40	EMPTIESBOM	☐	W_MITLEERG	FLAG	CHAR	1	0	Empties Bill of Material
41	EXTMATLGRP	☐	EXTWG	EXTWG	CHAR	18	0	External material group	*
42	CONT_UNIT	☐	INHME	MEINS	UNIT	3	0	Content unit	T006
43	CONT_UNIT_ISO	☐	INHME_ISO	ISOCD_UNIT	CHAR	3	0	Content unit in ISO code	T006I
44	NET_CONT	☐	INHAL	MENG13	QUAN	13	3	Net contents
45	COMPPRUNIT	☐	VPREH	PACK3	DEC	5	0	Comparison price unit
46	GROSS_CONT	☐	INHBR	MENG13	QUAN	13	3	Gross contents
47	ENVT_RLVT	☐	KZUMW	XFELD	CHAR	1	0	Indicator: Environmentally relevant
48	SEASMATCAT	☐	SAITY	SAITY	CHAR	2	0	Categories of seasonal materials	T6WSA
49	HAZMATPROF	☐	ADGE_PROFL	ADGD_PROFL	CHAR	3	0	Dangerous goods indicator profile	TDG41
50	HIGH_VISC	☐	ADGE_IHIVI	X	CHAR	1	0	Indicator: Highly viscous
51	LOOSEORLIQ	☐	ADGE_ILOOS	X	CHAR	1	0	Indicator: In bulk/liquid
52	CLOSED_BOX	☐	KZGVH	XFELD	CHAR	1	0	Shipping material is closed packaging
53	APPD_B_REC	☐	XGCHP	XFELD	CHAR	1	0	Indicator: Approved batch record required
54	PERIOD_IND_EXPIR	☐	DATTP	DATTP	CHAR	1	0	Period Indicator for Shelf Life Expiration Date
55	ROUND_RULE_EXPIR	☐	RDMHD	RDMHD	CHAR	1	0	Rounding rule for calculation of SLED
56	PROD_COMP_PACKAG	☐	PRZUS	XFELD	CHAR	1	0	Indicator: Product composition printed on packaging
57	.INCLUDE	☐				0	0	PRICAT: Catalog item basic data from MAW1RT segment
58	SALES_UNIT	☐	VRKME	MEINS	UNIT	3	0	Sales unit	T006
59	SALES_UNIT_ISO	☐	VRKME_ISO	ISOCD_UNIT	CHAR	3	0	Sales unit in ISO code	T006I
60	ISSUE_UNIT	☐	AUSME	MEINS	UNIT	3	0	Unit of issue	T006
61	ISSUE_UNIT_ISO	☐	AUSME_ISO	ISOCD_UNIT	CHAR	3	0	Unit of issue in ISO code	T006I
62	COUNTRYORI	☐	HERKL	LAND1	CHAR	3	0	Country of origin of the material	T005
63	COUNTRYORI_ISO	☐	HERKL_ISO	INTCA	CHAR	2	0	Material's country of origin in ISO code
64	REGIONORIG	☐	HERKR	REGIO	CHAR	3	0	Region of origin of material (non-preferential origin)	T005S
65	COMM_CODE	☐	STAWN	STAWN	CHAR	17	0	Commodity Code/Import Code Number for Foreign Trade	T604
66	LOCK_STATUS	☐	WRF_LOCK_STATUS	FLAG	CHAR	1	0	Price Catalog: Lock Status (Yes or No)
67	SATNR	☐	SATNR	MATNR	CHAR	18	0	Cross-Plant Configurable Material	*
68	VENDOR_SATNR	☐	WRF_VENDOR_SATNR	WRF_VENDOR_SATNR	CHAR	20	0	Price Catalog: Grouping Field: Generic Material Assignment
69	SATNR_HEAD_FLAG	☐	WRF_MASTER_VARIANT	CHAR1	CHAR	1	0	Master Variant
70	PROC_STATUS	☐	WRF_PROCSTATUS	WRF_PROCSTATUS	CHAR	2	0	Processing Status	*
71	TAKE_OVER_DATE	☐	WRF_TAKE_OVER_DATE	DATUM	DATS	8	0	Price Catalog: Transfer Date (in PRICAT Data Pool)
72	TRIGGER_DATE	☐	WRF_TRIGGER_DATE	DATUM	DATS	8	0	Primary Update Date Set Online
73	MORE_MATNR	☐	MORE_MATNR	FLAG	CHAR	1	0	Price Catalog Indicator EAN for Mat. No. = 1..n
74	REF_ARTICLE	☐	WWGDA	MATNR	CHAR	18	0	Material group reference material	*
75	HIER_ID	☐	WRF_HIER_CNT	WRF_HIERCNT	CHAR	2	0	Hierarchy
76	HIER_NODE	☐	WRF_STRUC_NODE	WRF_NODES	CHAR	18	0	Hierarchy Node
77	MERKMALSPROFIL	☐	KLASSE_D	KLASSE	CHAR	18	0	Class number
78	MANUAL_CHANGE	☐	MANUAL_CHANGE	FLAG	CHAR	1	0	Manual Change
79	.INCLUDE	☐				0	0	PRICAT Inbound: Item Additional Data
80	.INCLUDE	☐				0	0	PRICAT: Catalog item additional data from MARART segment
81	SIZE_DIM	☐	GROES	CHAR32	CHAR	32	0	Size/dimensions
82	BASIC_MATL	☐	WRKST	WRKST	CHAR	48	0	Basic Material	*
83	STD_DESCR	☐	NORMT	NORMT	CHAR	18	0	Industry Standard Description (such as ANSI or ISO)
84	DSN_OFFICE	☐	LABOR	LABOR	CHAR	3	0	Laboratory/design office	*
85	COMPETITOR	☐	WETTB	KUNNR	CHAR	10	0	Competitor	*
86	MANUFACTUR	☐	PRIILNM	PRICHAR35	CHAR	35	0	PRICAT: International location number manufactur. (CHAR 35)
87	.INCLUDE	☐				0	0	PRICAT: Catalog item other additional data (display only)
88	GENETIC_INFO	☐	PRIGENETIC	PRICHAR18	CHAR	18	0	PRICAT: Information on genetic modification
89	ALCOHOL_PERC_VOL	☐	PRIALCVOL	PRICHAR18	CHAR	18	0	PRICAT: Alcohol volume as percentage (measured value)
90	FAT_CONTENT	☐	PRIFATCONT	PRICHAR18	CHAR	18	0	PRICAT: Fat content
91	KEEP_REFRIG	☐	PRIKEEPREFRIG	PRICHAR3	CHAR	3	0	PRICAT: Keep refrigerated
92	KEEP_FROZEN	☐	PRIKEEPFROZEN	PRICHAR3	CHAR	3	0	PRICAT: Keep frozen
93	GREEN_DOT	☐	PRIGREENDOT	PRICHAR3	CHAR	3	0	PRICAT: Recyling indicator on goods
94	EXPIR_MARKING	☐	PRIEXPIRDATE	PRICHAR3	CHAR	3	0	PRICAT: Expiration date shown on goods
95	PRICE_MARKING	☐	PRIPRICEMARK	PRICHAR3	CHAR	3	0	PRICAT: Price marked on goods
96	KEEP_DRY	☐	PRIKEEPDRY	PRICHAR3	CHAR	3	0	PRICAT: Keep dry
97	HEAT_SENSITIVE	☐	PRIHEATSENS	PRICHAR3	CHAR	3	0	PRICAT: Heat-sensitive
98	.INCLUDE	☐				0	0	PRICAT: Catalog item Additional display data from EANCOM
99	PREDECES_MAT_ID	☐	PRIPREDEC	PRICHAR35	CHAR	35	0	PRICAT: Preceding EAN/UPC
100	FOLLOW_UP	☐	NFMAT	MATNR	CHAR	18	0	Follow-up material	*
101	HAZARD_CLASS	☐	PRIHAZCLASS	PRICHAR4	CHAR	4	0	PRICAT: Dangerous Goods Classification
102	HAZARD_DESCRIPT	☐	PRIHAZDES	PRICHAR35	CHAR	35	0	PRICAT: Dangerous goods general description
103	HAZARD_DESCR_2	☐	PRIHAZDES2	PRICHAR35	CHAR	35	0	PRICAT: Dangerous goods general description field 2
104	HAZARD_DESCR_3	☐	PRIHAZDES3	PRICHAR35	CHAR	35	0	PRICAT: Dangerous goods general description field 3
105	SAISON_PERIOD	☐	PRISAISON	PRICHAR35	CHAR	35	0	PRICAT: Seasonal ordering (from to)
106	BASE_UOM	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
107	TAX_TYPE	☐	TATYP	KSCHL	CHAR	4	0	Tax category (sales tax, federal sales tax,...)	T685
108	TAX_CLASS	☐	TAKLV	TAXKM	CHAR	1	0	Tax Classification of Material	TSKM
109	VAL_CLASS	☐	BKLAS	BKLAS	CHAR	4	0	Valuation Class	T025
110	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	WRF_ITEM_K003_AND_Z_STY	BASE_UOM	T006	MSEHI
2	WRF_ITEM_K003_AND_Z_STY	COMM_CODE	T604	STAWN
3	WRF_ITEM_K003_AND_Z_STY	CONTAINER	T144	BEHVO
4	WRF_ITEM_K003_AND_Z_STY	CONT_UNIT	T006	MSEHI
5	WRF_ITEM_K003_AND_Z_STY	CONT_UNIT_ISO	T006I	ISOCODE
6	WRF_ITEM_K003_AND_Z_STY	COUNTRYORI	T005	LAND1
7	WRF_ITEM_K003_AND_Z_STY	DIVISION	TSPA	SPART
8	WRF_ITEM_K003_AND_Z_STY	HAZMATPROF	TDG41	PROFL
9	WRF_ITEM_K003_AND_Z_STY	HAZ_MAT_NO	MGEF	STOFF
10	WRF_ITEM_K003_AND_Z_STY	ISSUE_UNIT	T006	MSEHI
11	WRF_ITEM_K003_AND_Z_STY	ISSUE_UNIT_ISO	T006I	ISOCODE
12	WRF_ITEM_K003_AND_Z_STY	MATL_GROUP	T023	MATKL
13	WRF_ITEM_K003_AND_Z_STY	MATL_TYPE	T134	MTART
14	WRF_ITEM_K003_AND_Z_STY	MATNR	MARA	MATNR
15	WRF_ITEM_K003_AND_Z_STY	MAT_GRP_SM	TVEGR	MAGRV
16	WRF_ITEM_K003_AND_Z_STY	MWSKZ	T007A	MWSKZ
17	WRF_ITEM_K003_AND_Z_STY	PACK_VO_UN	T006	MSEHI
18	WRF_ITEM_K003_AND_Z_STY	PACK_VO_UN_ISO	T006I	ISOCODE
19	WRF_ITEM_K003_AND_Z_STY	PACK_WT_UN	T006	MSEHI
20	WRF_ITEM_K003_AND_Z_STY	PACK_WT_UN_ISO	T006I	ISOCODE
21	WRF_ITEM_K003_AND_Z_STY	PRICE_BAND	TWPT	PLGTP
22	WRF_ITEM_K003_AND_Z_STY	PUR_GROUP	T024	EKGRP
23	WRF_ITEM_K003_AND_Z_STY	REGIONORIG	T005S	BLAND
24	WRF_ITEM_K003_AND_Z_STY	SALES_UNIT	T006	MSEHI
25	WRF_ITEM_K003_AND_Z_STY	SALES_UNIT_ISO	T006I	ISOCODE
26	WRF_ITEM_K003_AND_Z_STY	SEASMATCAT	T6WSA	SAITY
27	WRF_ITEM_K003_AND_Z_STY	SEASON	T6WSP	SAISO
28	WRF_ITEM_K003_AND_Z_STY	SH_MAT_TYP	TVTY	TRATY
29	WRF_ITEM_K003_AND_Z_STY	STOR_CONDS	T142	RAUBE
30	WRF_ITEM_K003_AND_Z_STY	TAX_CLASS	TSKM	TAXKM
31	WRF_ITEM_K003_AND_Z_STY	TAX_TYPE	T685	KSCHL
32	WRF_ITEM_K003_AND_Z_STY	TEMP_CONDS	T143	TEMPB
33	WRF_ITEM_K003_AND_Z_STY	VAL_CLASS	T025	BKLAS

History

Last changed by/on	SAP	20130529
SAP Release Created in	111