SAP ABAP Table PRICAT_S001 (PRICAT maintenance: Key and info fields)

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_S001	Table Relationship Diagram
Short Description	PRICAT maintenance: Key and info fields

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	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	*
2	PRINBR	☐	PRINBR	PRINBR	CHAR	10	0	PRICAT: Unique internal catalog number	PRICAT_K001
3	LIFNR	☐	ELIFN	LIFNR	CHAR	10	0	Vendor's account number	*
4	UNIQUE_REFERENCE	☐	PRIUNIREF	CHAR35	CHAR	35	0	PRICAT: Unique catalog reference of the message sender
5	TEST_INDICATOR	☐	PRITEST	PRITEST	CHAR	1	0	PRICAT: Produktive / test indicator
6	OUTBOUNDFLAG	☐	PRIOUTBOUNDFLAG	XFELD	CHAR	1	0	PRICAT: Indicator for Outbound Processing
7	EKGRP	☐	BKGRP	EKGRP	CHAR	3	0	Purchasing Group	T024
8	PRODUCTGROUP	☐	PRIPRODUCTGROUP	PRIPRODUCTGROUP	CHAR	18	0	PRICAT: PGI or assortment module from Pricat IDoc	PRICAT_K002
9	PRODGROUP_TEXT	☐	PRIPRODUCTGRP_TEXT	PRIPRODUCTGRP_TEXT	CHAR	35	0	PRICAT: PGI or assortment module text
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_ALTUNIT	☐	PRIEANUNIT	PRIEAN	CHAR	35	0	PRICAT: EAN/UPC code of the unit of measure
13	VALIDITY_UNIT	☐	PRIVALIDITYU	DATUM	DATS	8	0	PRICAT: Date From Which the Unit Change is Valid
14	BASISTEXT	☐	MAKTX	TEXT40	CHAR	40	0	Material description
15	R3BASISTEXT	☐	MAKTX	TEXT40	CHAR	40	0	Material description
16	VORLAGETEXT	☐	MAKTX	TEXT40	CHAR	40	0	Material description
17	UNITTEXT	☐	MAKTM	TEXT40	CHAR	40	0	Material description for unit of measure
18	R3UNITTEXT	☐	MAKTM	TEXT40	CHAR	40	0	Material description for unit of measure
19	NEUERARTIKEL	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
20	ALTERARTIKEL	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
21	VORLAGE	☐	REF_MATNR	MATNR	CHAR	18	0	Reference material	MARA
22	SPRACHE_TEXT	☐	TDSPRAS	SPRAS	LANG	1	0	Language key	T002
23	SPRACHE_TEXT_ISO	☐	LAISO	LAISO	CHAR	2	0	2-Character SAP Language Code
24	KURZTEXT	☐	MAKTX	TEXT40	CHAR	40	0	Material description
25	KURZTEXT_VB	☐	MAKTX	TEXT40	CHAR	40	0	Material description
26	SPRACHE_BONTEXT	☐	TDSPRAS	SPRAS	LANG	1	0	Language key	T002
27	SPRACHE_BONTEXT_ISO	☐	LAISO	LAISO	CHAR	2	0	2-Character SAP Language Code
28	BONTEXT	☐	MAKTM	TEXT40	CHAR	40	0	Material description for unit of measure
29	BONTEXT_VB	☐	MAKTM	TEXT40	CHAR	40	0	Material description for unit of measure
30	TEXT_ID	☐	TDID	TDID	CHAR	4	0	Text ID	TTXID
31	BASE_UOM	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
32	BASE_UOM_ISO	☐	MEINS_ISO	ISOCD_UNIT	CHAR	3	0	Base unit of measure in ISO code	*
33	BASE_UOM_VB	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
34	MEINH	☐	MEINH	MEINS	UNIT	3	0	Unit of Measure for Display	T006
35	KZBASE	☐	PRIKZBASIS	XFELD	CHAR	1	0	Indicates whether this relates to the base unit of measure
36	VAT	☐	PRICONDVAL	BAPICURR	DEC	23	4	PRICAT: Condition value amount/percentage
37	KZ_ONLY_UPDATE	☐	XFELD	XFELD	CHAR	1	0	Checkbox
38	UNAME	☐	SYUNAME	SYCHAR12	CHAR	12	0	User Name

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	PRICAT_S001	ALTERARTIKEL	MARA	MATNR
2	PRICAT_S001	EKGRP	T024	EKGRP
3	PRICAT_S001	MEINH	T006	MSEHI
4	PRICAT_S001	PRINBR	PRICAT_K001	PRINBR
5	PRICAT_S001	PRODUCTGROUP	PRICAT_K002	PRODUCTGROUP
6	PRICAT_S001	SPRACHE_BONTEXT	T002	SPRAS
7	PRICAT_S001	SPRACHE_TEXT	T002	SPRAS
8	PRICAT_S001	TEXT_ID	TTXID	TDID
9	PRICAT_S001	VORLAGE	MARA	MATNR

History

Last changed by/on	SAP	20140121
SAP Release Created in