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 |
Possible values
|
||||||
OUTBOUNDFLAG | PRICAT: Indicator for Outbound Processing | PRIOUTBOUNDFLAG | CHAR | 1 | 0 |
Possible values
|
||||||
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 |
Possible values
|
||||||
VAT | PRICAT: Condition value amount/percentage | PRICONDVAL | DEC | 23 | 4 | |||||||
KZ_ONLY_UPDATE | Checkbox | XFELD | CHAR | 1 | 0 |
Possible values
|
||||||
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 |