SAP ABAP Table PRICAT_S003 (PRICAT maintenance: Item selection: contains PRIcAT_K003)

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_S003	Table Relationship Diagram
Short Description	PRICAT maintenance: Item selection: contains PRIcAT_K003

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	MARK	☐			CHAR	1	0
2	ITEM_NUMBER	☐	PRIPRODGRP	PRIPRODGRP	NUMC	6	0	PRICAT: Print sequence of the vendor
3	CHANGED	☐	XFELD	XFELD	CHAR	1	0	Checkbox
4	GESPERRT	☐	XFELD	XFELD	CHAR	1	0	Checkbox
5	KURZTEXT	☐	MAKTX	TEXT40	CHAR	40	0	Material description
6	.INCLUDE	☐				0	0	PRICAT: Catalog item basic data
7	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
8	PRINBR	☐	PRINBR	PRINBR	CHAR	10	0	PRICAT: Unique internal catalog number	PRICAT_K001
9	PRODUCTGROUP	☐	PRIPRODUCTGROUP	PRIPRODUCTGROUP	CHAR	18	0	PRICAT: PGI or assortment module from Pricat IDoc	PRICAT_K002
10	EAN_UPC_BASE	☐	PRIEANBASIS	PRIEAN	CHAR	35	0	PRICAT: EAN/UPC Code of the Base Unit of Measure
11	VALIDITY_BASE	☐	PRIVALIDITY	DATUM	DATS	8	0	Price Catalog Inbound Start of Validity Period
12	EAN_UPC_TYPE	☐	PRIEANTYP	PRIEANTYP	CHAR	2	0	Type of material identification
13	BEARB_STATUS	☐	PRIBEARBSTAT	PRIBEARBSTAT	CHAR	2	0	PRICAT: Status of material/unit of measure processing
14	STATEINDICATOR	☐	PRISTATEINDICATOR	PRISTATEINDICATOR	CHAR	2	0	PRICAT: Movement Indicator for the Item
15	PUR_GROUP	☐	EKGRP	EKGRP	CHAR	3	0	Purchasing group	T024
16	MATERIAL_GROUP	☐	PRIMATKL	PRICHAR35	CHAR	35	0	PRICAT: Material group from the message (char 35)
17	MAT_ID_SENDER	☐	PRIMATLIEF	PRICHAR35	CHAR	35	0	PRICAT: Material number of the sender of the message
18	SHELF_LIFE_MSG	☐	PRIMHD	PRIPERIODE	CHAR	6	0	PRICAT: Shelf life expiration in time unit from message
19	SHELF_LIFE_QUAL	☐	PRIQUALPERIOD	PRIQUALPERIOD	CHAR	3	0	PRICAT: Qualifier for periods
20	COMPOSITION	☐	PRICOMPOSITION	PRICHAR3	CHAR	3	0	PRICAT: Product composition
21	.INCLUDE	☐				0	0	PRICAT: Catalog item basic data from MARART segment
22	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
23	MATL_TYPE	☐	MTART	MTART	CHAR	4	0	Material type	T134
24	MATL_GROUP	☐	MATKL	MATKL	CHAR	9	0	Material Group	T023
25	MATL_CAT	☐	ATTYP	ATTYP	CHAR	2	0	Material Category
26	DEL_FLAG	☐	LVOMA	XFELD	CHAR	1	0	Flag Material for Deletion at Client Level
27	CONTAINER	☐	BEHVO	BEHVO	CHAR	2	0	Container requirements	T144
28	STOR_CONDS	☐	RAUBE	RAUBE	CHAR	2	0	Storage conditions	T142
29	TEMP_CONDS	☐	TEMPB	TEMPB	CHAR	2	0	Temperature conditions indicator	T143
30	HAZ_MAT_NO	☐	STOFF	STOFF	CHAR	18	0	Hazardous material number	MGEF
31	DIVISION	☐	SPART	SPART	CHAR	2	0	Division	TSPA
32	SEASON	☐	SAISO	SAISO	CHAR	4	0	Season Category	T6WSP
33	ALLOWED_WT	☐	ERGEW	MENG13	QUAN	13	3	Allowed packaging weight
34	PACK_WT_UN	☐	ERGEI	MEINS	UNIT	3	0	Unit of weight (allowed packaging weight)	T006
35	PACK_WT_UN_ISO	☐	ERGEI_ISO	ISOCD_UNIT	CHAR	3	0	Unit of weight (allowed packaging weight) in ISO code	T006I
36	ALLWD_VOL	☐	ERVOL	MENG13	QUAN	13	3	Allowed packaging volume
37	PACK_VO_UN	☐	ERVOE	MEINS	UNIT	3	0	Volume unit (allowed packaging volume)	T006
38	PACK_VO_UN_ISO	☐	ERVOE_ISO	ISOCD_UNIT	CHAR	3	0	Volume unit (allowed packaging volume) in ISO code	T006I
39	VAR_ORD_UN	☐	VABME	VABME	CHAR	1	0	Variable Purchase Order Unit Active
40	BATCH_MGMT	☐	XCHPF	XFELD	CHAR	1	0	Batch management requirement indicator
41	SH_MAT_TYP	☐	VHIART	TRATY	CHAR	4	0	Shipping material type	TVTY
42	FILL_LEVEL	☐	FUELG	DEC3	DEC	3	0	Filling level (by volume)
43	STACK_FACT	☐	STFAK	INT2	INT2	5	0	Stacking factor
44	MAT_GRP_SM	☐	MAGRV	MAGRV	CHAR	4	0	Material Group: Packaging Materials	TVEGR
45	MINREMLIFE	☐	MHDRZ	DEC4	DEC	4	0	Minimum Remaining Shelf Life
46	SHELF_LIFE	☐	MHDHB	DEC4	DEC	4	0	Total shelf life
47	STOR_PCT	☐	MHDLP	DEC3	DEC	3	0	Storage percentage
48	SAESON_YR	☐	SAISJ	CJAHR	CHAR	4	0	Season Year
49	PRICE_BAND	☐	PLGTP	PLGTP	CHAR	2	0	Price band category	TWPT
50	EMPTIESBOM	☐	W_MITLEERG	FLAG	CHAR	1	0	Empties Bill of Material
51	EXTMATLGRP	☐	EXTWG	EXTWG	CHAR	18	0	External material group	*
52	CONT_UNIT	☐	INHME	MEINS	UNIT	3	0	Content unit	T006
53	CONT_UNIT_ISO	☐	INHME_ISO	ISOCD_UNIT	CHAR	3	0	Content unit in ISO code	T006I
54	NET_CONT	☐	INHAL	MENG13	QUAN	13	3	Net contents
55	COMPPRUNIT	☐	VPREH	PACK3	DEC	5	0	Comparison price unit
56	GROSS_CONT	☐	INHBR	MENG13	QUAN	13	3	Gross contents
57	ENVT_RLVT	☐	KZUMW	XFELD	CHAR	1	0	Indicator: Environmentally relevant
58	SEASMATCAT	☐	SAITY	SAITY	CHAR	2	0	Categories of seasonal materials	T6WSA
59	HAZMATPROF	☐	ADGE_PROFL	ADGD_PROFL	CHAR	3	0	Dangerous goods indicator profile	TDG41
60	HIGH_VISC	☐	ADGE_IHIVI	X	CHAR	1	0	Indicator: Highly viscous
61	LOOSEORLIQ	☐	ADGE_ILOOS	X	CHAR	1	0	Indicator: In bulk/liquid
62	CLOSED_BOX	☐	KZGVH	XFELD	CHAR	1	0	Shipping material is closed packaging
63	APPD_B_REC	☐	XGCHP	XFELD	CHAR	1	0	Indicator: Approved batch record required
64	PERIOD_IND_EXPIR	☐	DATTP	DATTP	CHAR	1	0	Period Indicator for Shelf Life Expiration Date
65	ROUND_RULE_EXPIR	☐	RDMHD	RDMHD	CHAR	1	0	Rounding rule for calculation of SLED
66	PROD_COMP_PACKAG	☐	PRZUS	XFELD	CHAR	1	0	Indicator: Product composition printed on packaging
67	.INCLUDE	☐				0	0	PRICAT: Catalog item basic data from MAW1RT segment
68	SALES_UNIT	☐	VRKME	MEINS	UNIT	3	0	Sales unit	T006
69	SALES_UNIT_ISO	☐	VRKME_ISO	ISOCD_UNIT	CHAR	3	0	Sales unit in ISO code	T006I
70	ISSUE_UNIT	☐	AUSME	MEINS	UNIT	3	0	Unit of issue	T006
71	ISSUE_UNIT_ISO	☐	AUSME_ISO	ISOCD_UNIT	CHAR	3	0	Unit of issue in ISO code	T006I
72	COUNTRYORI	☐	HERKL	LAND1	CHAR	3	0	Country of origin of the material	T005
73	COUNTRYORI_ISO	☐	HERKL_ISO	INTCA	CHAR	2	0	Material's country of origin in ISO code
74	REGIONORIG	☐	HERKR	REGIO	CHAR	3	0	Region of origin of material (non-preferential origin)	T005S
75	COMM_CODE	☐	STAWN	STAWN	CHAR	17	0	Commodity Code/Import Code Number for Foreign Trade	T604
76	.INCLU--AP	☐				0	0	Price Catalog Inbound: New Fields
77	LOCK_STATUS	☐	WRF_LOCK_STATUS	FLAG	CHAR	1	0	Price Catalog: Lock Status (Yes or No)
78	SATNR	☐	SATNR	MATNR	CHAR	18	0	Cross-Plant Configurable Material	*
79	VENDOR_SATNR	☐	WRF_VENDOR_SATNR	WRF_VENDOR_SATNR	CHAR	20	0	Price Catalog: Grouping Field: Generic Material Assignment
80	SATNR_HEAD_FLAG	☐	WRF_MASTER_VARIANT	CHAR1	CHAR	1	0	Master Variant
81	PROC_STATUS	☐	WRF_PROCSTATUS	WRF_PROCSTATUS	CHAR	2	0	Processing Status	WRF_PRICAT_PROC
82	TAKE_OVER_DATE	☐	WRF_TAKE_OVER_DATE	DATUM	DATS	8	0	Price Catalog: Transfer Date (in PRICAT Data Pool)
83	TRIGGER_DATE	☐	WRF_TRIGGER_DATE	DATUM	DATS	8	0	Primary Update Date Set Online
84	MORE_MATNR	☐	MORE_MATNR	FLAG	CHAR	1	0	Price Catalog Indicator EAN for Mat. No. = 1..n
85	REF_ARTICLE	☐	WWGDA	MATNR	CHAR	18	0	Material group reference material	MARA
86	HIER_ID	☐	WRF_HIER_CNT	WRF_HIERCNT	CHAR	2	0	Hierarchy
87	HIER_NODE	☐	WRF_STRUC_NODE	WRF_NODES	CHAR	18	0	Hierarchy Node
88	MERKMALSPROFIL	☐	WRF_PROFIL	KLASSE	CHAR	18	0	Characteristic Profile
89	MANUAL_CHANGE	☐	MANUAL_CHANGE	FLAG	CHAR	1	0	Manual Change
90	PROFILENAME	☐	WRF_PROFILENAME	TEXT40	CHAR	40	0	Profile Name

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	PRICAT_S003	COMM_CODE	T604	STAWN
2	PRICAT_S003	CONTAINER	T144	BEHVO
3	PRICAT_S003	CONT_UNIT	T006	MSEHI
4	PRICAT_S003	CONT_UNIT_ISO	T006I	ISOCODE
5	PRICAT_S003	COUNTRYORI	T005	LAND1
6	PRICAT_S003	DIVISION	TSPA	SPART
7	PRICAT_S003	HAZMATPROF	TDG41	PROFL
8	PRICAT_S003	HAZ_MAT_NO	MGEF	STOFF
9	PRICAT_S003	ISSUE_UNIT	T006	MSEHI
10	PRICAT_S003	ISSUE_UNIT_ISO	T006I	ISOCODE
11	PRICAT_S003	MANDT	T000	MANDT	KEY	1	CN
12	PRICAT_S003	MATL_GROUP	T023	MATKL
13	PRICAT_S003	MATL_TYPE	T134	MTART
14	PRICAT_S003	MATNR	MARA	MATNR
15	PRICAT_S003	MAT_GRP_SM	TVEGR	MAGRV
16	PRICAT_S003	PACK_VO_UN	T006	MSEHI
17	PRICAT_S003	PACK_VO_UN_ISO	T006I	ISOCODE
18	PRICAT_S003	PACK_WT_UN	T006	MSEHI
19	PRICAT_S003	PACK_WT_UN_ISO	T006I	ISOCODE
20	PRICAT_S003	PRICE_BAND	TWPT	PLGTP
21	PRICAT_S003	PRINBR	PRICAT_K001	PRINBR	KEY	1	CN
22	PRICAT_S003	PROC_STATUS	WRF_PRICAT_PROC	WRF_PROCSTATUS
23	PRICAT_S003	PRODUCTGROUP	PRICAT_K002	PRODUCTGROUP	KEY	1	CN
24	PRICAT_S003	PUR_GROUP	T024	EKGRP
25	PRICAT_S003	REF_ARTICLE	MARA	MATNR
26	PRICAT_S003	REGIONORIG	T005S	BLAND
27	PRICAT_S003	SALES_UNIT	T006	MSEHI
28	PRICAT_S003	SALES_UNIT_ISO	T006I	ISOCODE
29	PRICAT_S003	SEASMATCAT	T6WSA	SAITY
30	PRICAT_S003	SEASON	T6WSP	SAISO
31	PRICAT_S003	SH_MAT_TYP	TVTY	TRATY
32	PRICAT_S003	STOR_CONDS	T142	RAUBE
33	PRICAT_S003	TEMP_CONDS	T143	TEMPB

History

Last changed by/on	SAP	20130529
SAP Release Created in