SAP table PRICAT_S001 (PRICAT maintenance: Key and info fields)

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 * MANDT
PRINBR PRICAT: Unique internal catalog number CHAR 10 0 PRICAT_K001 PRINBR
LIFNR Vendor's account number CHAR 10 0 * ELIFN
UNIQUE_REFERENCE PRICAT: Unique catalog reference of the message sender CHAR 35 0 PRIUNIREF
TEST_INDICATOR PRICAT: Produktive / test indicator CHAR 1 0 PRITEST
The PRICAT message comes from a productive transfer
X The PRICAT message comes from a test transfer
OUTBOUNDFLAG PRICAT: Indicator for Outbound Processing CHAR 1 0 PRIOUTBOUNDFLAG
EKGRP Purchasing Group CHAR 3 0 T024 BKGRP
PRODUCTGROUP PRICAT: PGI or assortment module from Pricat IDoc CHAR 18 0 PRICAT_K002 PRIPRODUCTGROUP
PRODGROUP_TEXT PRICAT: PGI or assortment module text CHAR 35 0 PRIPRODUCTGRP_TEXT
EAN_UPC_BASE PRICAT: EAN/UPC Code of Base Unit of Measure CHAR 35 0 PRIEANBASIS
VALIDITY_BASE Price Catalog Inbound Start of Validity Period DATS 8 0 PRIVALIDITY
EAN_UPC_ALTUNIT PRICAT: EAN/UPC code of the unit of measure CHAR 35 0 PRIEANUNIT
VALIDITY_UNIT PRICAT: Date From Which the Unit Change is Valid DATS 8 0 PRIVALIDITYU
BASISTEXT Material Description CHAR 40 0 MAKTX
R3BASISTEXT Material Description CHAR 40 0 MAKTX
VORLAGETEXT Material Description CHAR 40 0 MAKTX
UNITTEXT Material description for unit of measure CHAR 40 0 MAKTM
R3UNITTEXT Material description for unit of measure CHAR 40 0 MAKTM
NEUERARTIKEL Material Number CHAR 40 0 * MATNR
ALTERARTIKEL Material Number CHAR 40 0 MARA MATNR
VORLAGE Reference Material CHAR 40 0 MARA REF_MATNR
SPRACHE_TEXT Language key LANG 1 0 T002 TDSPRAS
SPRACHE_TEXT_ISO 2-Character SAP Language Code CHAR 2 0 LAISO
KURZTEXT Material Description CHAR 40 0 MAKTX
KURZTEXT_VB Material Description CHAR 40 0 MAKTX
SPRACHE_BONTEXT Language key LANG 1 0 T002 TDSPRAS
SPRACHE_BONTEXT_ISO 2-Character SAP Language Code CHAR 2 0 LAISO
BONTEXT Material description for unit of measure CHAR 40 0 MAKTM
BONTEXT_VB Material description for unit of measure CHAR 40 0 MAKTM
TEXT_ID Text ID CHAR 4 0 TTXID TDID
BASE_UOM Base Unit of Measure UNIT 3 0 * MEINS
BASE_UOM_ISO Base unit of measure in ISO code CHAR 3 0 * MEINS_ISO
BASE_UOM_VB Base Unit of Measure UNIT 3 0 * MEINS
MEINH Unit of Measure for Display UNIT 3 0 T006 MEINH
KZBASE Indicates whether this relates to the base unit of measure CHAR 1 0 PRIKZBASIS
VAT PRICAT: Condition value amount/percentage DEC 23 4 PRICONDVAL
KZ_ONLY_UPDATE Checkbox CHAR 1 0 XFELD
No
X Yes
UNAME User Name CHAR 12 0 SYUNAME

PRICAT_S001 foreign key relationships

Table Field Check Table Check Field
0 PRICAT_S001 ALTERARTIKEL MARA General Material Data MATNR
1 PRICAT_S001 EKGRP T024 Purchasing Groups EKGRP
0 PRICAT_S001 MEINH T006 Units of Measurement MANDT
0 PRICAT_S001 MEINH T006 Units of Measurement MSEHI
1 PRICAT_S001 PRINBR PRICAT_K001 PRICAT: Catalog header MANDT
1 PRICAT_S001 PRINBR PRICAT_K001 PRICAT: Catalog header PRINBR
0 PRICAT_S001 PRODUCTGROUP PRICAT_K002 PRICAT: Catalog item product groups MANDT
0 PRICAT_S001 PRODUCTGROUP PRICAT_K002 PRICAT: Catalog item product groups PRINBR
0 PRICAT_S001 PRODUCTGROUP PRICAT_K002 PRICAT: Catalog item product groups PRODUCTGROUP
1 PRICAT_S001 SPRACHE_BONTEXT T002 Language Keys (Component BC-I18) SPRAS
0 PRICAT_S001 SPRACHE_TEXT T002 Language Keys (Component BC-I18) SPRAS
1 PRICAT_S001 VORLAGE MARA General Material Data MATNR