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