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
⤷ 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
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in | 600 |