SAP ABAP Table PRICAT_K003 (PRICAT: Catalog item basic data)
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
⤷ 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_K003 | Table Relationship Diagram |
Short Description | PRICAT: Catalog item basic data |
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 | EAN_UPC_TYPE | PRIEANTYP | PRIEANTYP | CHAR | 2 | 0 | Type of material identification | ||
7 | BEARB_STATUS | PRIBEARBSTAT | PRIBEARBSTAT | CHAR | 2 | 0 | PRICAT: Status of material/unit of measure processing | ||
8 | STATEINDICATOR | PRISTATEINDICATOR | PRISTATEINDICATOR | CHAR | 2 | 0 | PRICAT: Movement Indicator for the Item | ||
9 | PUR_GROUP | EKGRP | EKGRP | CHAR | 3 | 0 | Purchasing group | T024 | |
10 | MATERIAL_GROUP | PRIMATKL | PRICHAR35 | CHAR | 35 | 0 | PRICAT: Material group from the message (char 35) | ||
11 | MAT_ID_SENDER | PRIMATLIEF | PRICHAR35 | CHAR | 35 | 0 | PRICAT: Material number of the sender of the message | ||
12 | SHELF_LIFE_MSG | PRIMHD | PRIPERIODE | CHAR | 6 | 0 | PRICAT: Shelf life expiration in time unit from message | ||
13 | SHELF_LIFE_QUAL | PRIQUALPERIOD | PRIQUALPERIOD | CHAR | 3 | 0 | PRICAT: Qualifier for periods | ||
14 | COMPOSITION | PRICOMPOSITION | PRICHAR3 | CHAR | 3 | 0 | PRICAT: Product composition | ||
15 | .INCLUDE | 0 | 0 | PRICAT: Catalog item basic data from MARART segment | |||||
16 | MATNR | MATNR | MATNR | CHAR | 18 | 0 | Material Number | MARA | |
17 | MATL_TYPE | MTART | MTART | CHAR | 4 | 0 | Material type | T134 | |
18 | MATL_GROUP | MATKL | MATKL | CHAR | 9 | 0 | Material Group | T023 | |
19 | MATL_CAT | ATTYP | ATTYP | CHAR | 2 | 0 | Material Category | ||
20 | DEL_FLAG | LVOMA | XFELD | CHAR | 1 | 0 | Flag Material for Deletion at Client Level | ||
21 | CONTAINER | BEHVO | BEHVO | CHAR | 2 | 0 | Container requirements | T144 | |
22 | STOR_CONDS | RAUBE | RAUBE | CHAR | 2 | 0 | Storage conditions | T142 | |
23 | TEMP_CONDS | TEMPB | TEMPB | CHAR | 2 | 0 | Temperature conditions indicator | T143 | |
24 | HAZ_MAT_NO | STOFF | STOFF | CHAR | 18 | 0 | Hazardous material number | MGEF | |
25 | DIVISION | SPART | SPART | CHAR | 2 | 0 | Division | TSPA | |
26 | SEASON | SAISO | SAISO | CHAR | 4 | 0 | Season Category | T6WSP | |
27 | ALLOWED_WT | ERGEW | MENG13 | QUAN | 13 | 3 | Allowed packaging weight | ||
28 | PACK_WT_UN | ERGEI | MEINS | UNIT | 3 | 0 | Unit of weight (allowed packaging weight) | T006 | |
29 | PACK_WT_UN_ISO | ERGEI_ISO | ISOCD_UNIT | CHAR | 3 | 0 | Unit of weight (allowed packaging weight) in ISO code | T006I | |
30 | ALLWD_VOL | ERVOL | MENG13 | QUAN | 13 | 3 | Allowed packaging volume | ||
31 | PACK_VO_UN | ERVOE | MEINS | UNIT | 3 | 0 | Volume unit (allowed packaging volume) | T006 | |
32 | PACK_VO_UN_ISO | ERVOE_ISO | ISOCD_UNIT | CHAR | 3 | 0 | Volume unit (allowed packaging volume) in ISO code | T006I | |
33 | VAR_ORD_UN | VABME | VABME | CHAR | 1 | 0 | Variable Purchase Order Unit Active | ||
34 | BATCH_MGMT | XCHPF | XFELD | CHAR | 1 | 0 | Batch management requirement indicator | ||
35 | SH_MAT_TYP | VHIART | TRATY | CHAR | 4 | 0 | Shipping material type | TVTY | |
36 | FILL_LEVEL | FUELG | DEC3 | DEC | 3 | 0 | Filling level (by volume) | ||
37 | STACK_FACT | STFAK | INT2 | INT2 | 5 | 0 | Stacking factor | ||
38 | MAT_GRP_SM | MAGRV | MAGRV | CHAR | 4 | 0 | Material Group: Packaging Materials | TVEGR | |
39 | MINREMLIFE | MHDRZ | DEC4 | DEC | 4 | 0 | Minimum Remaining Shelf Life | ||
40 | SHELF_LIFE | MHDHB | DEC4 | DEC | 4 | 0 | Total shelf life | ||
41 | STOR_PCT | MHDLP | DEC3 | DEC | 3 | 0 | Storage percentage | ||
42 | SAESON_YR | SAISJ | CJAHR | CHAR | 4 | 0 | Season Year | ||
43 | PRICE_BAND | PLGTP | PLGTP | CHAR | 2 | 0 | Price band category | TWPT | |
44 | EMPTIESBOM | W_MITLEERG | FLAG | CHAR | 1 | 0 | Empties Bill of Material | ||
45 | EXTMATLGRP | EXTWG | EXTWG | CHAR | 18 | 0 | External material group | * | |
46 | CONT_UNIT | INHME | MEINS | UNIT | 3 | 0 | Content unit | T006 | |
47 | CONT_UNIT_ISO | INHME_ISO | ISOCD_UNIT | CHAR | 3 | 0 | Content unit in ISO code | T006I | |
48 | NET_CONT | INHAL | MENG13 | QUAN | 13 | 3 | Net contents | ||
49 | COMPPRUNIT | VPREH | PACK3 | DEC | 5 | 0 | Comparison price unit | ||
50 | GROSS_CONT | INHBR | MENG13 | QUAN | 13 | 3 | Gross contents | ||
51 | ENVT_RLVT | KZUMW | XFELD | CHAR | 1 | 0 | Indicator: Environmentally relevant | ||
52 | SEASMATCAT | SAITY | SAITY | CHAR | 2 | 0 | Categories of seasonal materials | T6WSA | |
53 | HAZMATPROF | ADGE_PROFL | ADGD_PROFL | CHAR | 3 | 0 | Dangerous goods indicator profile | TDG41 | |
54 | HIGH_VISC | ADGE_IHIVI | X | CHAR | 1 | 0 | Indicator: Highly viscous | ||
55 | LOOSEORLIQ | ADGE_ILOOS | X | CHAR | 1 | 0 | Indicator: In bulk/liquid | ||
56 | CLOSED_BOX | KZGVH | XFELD | CHAR | 1 | 0 | Shipping material is closed packaging | ||
57 | APPD_B_REC | XGCHP | XFELD | CHAR | 1 | 0 | Indicator: Approved batch record required | ||
58 | PERIOD_IND_EXPIR | DATTP | DATTP | CHAR | 1 | 0 | Period Indicator for Shelf Life Expiration Date | ||
59 | ROUND_RULE_EXPIR | RDMHD | RDMHD | CHAR | 1 | 0 | Rounding rule for calculation of SLED | ||
60 | PROD_COMP_PACKAG | PRZUS | XFELD | CHAR | 1 | 0 | Indicator: Product composition printed on packaging | ||
61 | .INCLUDE | 0 | 0 | PRICAT: Catalog item basic data from MAW1RT segment | |||||
62 | SALES_UNIT | VRKME | MEINS | UNIT | 3 | 0 | Sales unit | T006 | |
63 | SALES_UNIT_ISO | VRKME_ISO | ISOCD_UNIT | CHAR | 3 | 0 | Sales unit in ISO code | T006I | |
64 | ISSUE_UNIT | AUSME | MEINS | UNIT | 3 | 0 | Unit of issue | T006 | |
65 | ISSUE_UNIT_ISO | AUSME_ISO | ISOCD_UNIT | CHAR | 3 | 0 | Unit of issue in ISO code | T006I | |
66 | COUNTRYORI | HERKL | LAND1 | CHAR | 3 | 0 | Country of origin of the material | T005 | |
67 | COUNTRYORI_ISO | HERKL_ISO | INTCA | CHAR | 2 | 0 | Material's country of origin in ISO code | ||
68 | REGIONORIG | HERKR | REGIO | CHAR | 3 | 0 | Region of origin of material (non-preferential origin) | T005S | |
69 | COMM_CODE | STAWN | STAWN | CHAR | 17 | 0 | Commodity Code/Import Code Number for Foreign Trade | T604 | |
70 | .INCLU--AP | 0 | 0 | Price Catalog Inbound: New Fields | |||||
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 | WRF_PRICAT_PROC | |
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 | MARA | |
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 | WRF_PROFIL | KLASSE | CHAR | 18 | 0 | Characteristic Profile | ||
83 | MANUAL_CHANGE | MANUAL_CHANGE | FLAG | CHAR | 1 | 0 | Manual Change | ||
84 | PROFILENAME | WRF_PROFILENAME | TEXT40 | CHAR | 40 | 0 | Profile Name |
Foreign Keys
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in |