SAP Table PRICAT_S001

PRICAT maintenance: Key and info fields

PRICAT_S001 (PRICAT maintenance: Key and info fields) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link PRICAT_S001 to other SAP tables.

Source: PRICAT_S001 (PRICAT maintenance: Key and info fields)

PRICAT_S001 table fields

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

PRICAT_S001 foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
PRICAT_S001 ALTERARTIKEL PRICAT_S001 ALTERARTIKEL MARA General Material Data MATNR
PRICAT_S001 ALTERARTIKEL PRICAT_S001 MANDT MARA General Material Data MANDT
PRICAT_S001 EKGRP PRICAT_S001 EKGRP T024 Purchasing Groups EKGRP
PRICAT_S001 EKGRP PRICAT_S001 MANDT T024 Purchasing Groups MANDT
PRICAT_S001 MEINH PRICAT_S001 MANDT T006 Units of Measurement MANDT
PRICAT_S001 MEINH PRICAT_S001 MEINH T006 Units of Measurement MSEHI
PRICAT_S001 PRINBR PRICAT_S001 MANDT PRICAT_K001 PRICAT: Catalog header MANDT
PRICAT_S001 PRINBR PRICAT_S001 PRINBR PRICAT_K001 PRICAT: Catalog header PRINBR
PRICAT_S001 PRODUCTGROUP PRICAT_S001 MANDT PRICAT_K002 PRICAT: Catalog item product groups MANDT
PRICAT_S001 PRODUCTGROUP PRICAT_S001 PRINBR PRICAT_K002 PRICAT: Catalog item product groups PRINBR
PRICAT_S001 PRODUCTGROUP PRICAT_S001 PRODUCTGROUP PRICAT_K002 PRICAT: Catalog item product groups PRODUCTGROUP
PRICAT_S001 SPRACHE_BONTEXT PRICAT_S001 SPRACHE_BONTEXT T002 Language Keys (Component BC-I18) SPRAS
PRICAT_S001 SPRACHE_TEXT PRICAT_S001 SPRACHE_TEXT T002 Language Keys (Component BC-I18) SPRAS
PRICAT_S001 TEXT_ID 'MATERIAL' TTXID Valid text IDs TDOBJECT
PRICAT_S001 TEXT_ID PRICAT_S001 TEXT_ID TTXID Valid text IDs TDID
PRICAT_S001 VORLAGE PRICAT_S001 VORLAGE MARA General Material Data MATNR
PRICAT_S001 VORLAGE PRICAT_S001 MANDT MARA General Material Data MANDT